Skip to content

Instantly share code, notes, and snippets.

@fourseven
Created June 25, 2014 23:25
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save fourseven/91a5b2c34e638ba84ace to your computer and use it in GitHub Desktop.
Before
Hash Semi Join (cost=1374.03..1852.31 rows=59 width=62) (actual time=22.141..23.774 rows=1 loops=1)
After
Nested Loop Anti Join (cost=19.22..235.45 rows=33 width=62) (actual time=0.046..0.047 rows=1 loops=1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment