Skip to content

Instantly share code, notes, and snippets.

@cderwin

cderwin/gist:e0a393f4f0d597f1afecff375bd5de9e

Created May 15, 2016 20:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cderwin/e0a393f4f0d597f1afecff375bd5de9e to your computer and use it in GitHub Desktop.
Save cderwin/e0a393f4f0d597f1afecff375bd5de9e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Aggregate (cost=40095.76..40095.77 rows=1 width=0)
-> Hash Join (cost=16470.62..40095.40 rows=145 width=0)
Hash Cond: ((c.tract_id)::text = (((g.state)::text || (g.county)::text) || (g.tract)::text))
-> Hash Join (cost=47.98..23660.40 rows=10 width=52)
Hash Cond: ((t.geoid)::text = (c.tract_id)::text)
-> Seq Scan on tract t (cost=0.00..23334.33 rows=74133 width=12)
-> Hash (cost=47.85..47.85 rows=10 width=40)
-> Seq Scan on tractcache c (cost=0.00..47.85 rows=10 width=40)
Filter: ((metro_id)::text = '348'::text)
-> Hash (cost=16386.46..16386.46 rows=2895 width=56)
-> Seq Scan on geoheader g (cost=0.00..16386.46 rows=2895 width=56)
Filter: (blkgrp IS NULL)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment