explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wvQ1

Settings
# exclusive inclusive rows x rows loops node
1. 0.664 0.664 ↑ 192.0 1 1

HashAggregate (cost=29.57..32.45 rows=192 width=16) (actual time=0.664..0.664 rows=1 loops=1)

  • Group Key: "left"((tract_id)::text, 5)
  • -> Bitmap Heap Scan on hisp_pop
  • (cost=10.25..28.61 rows=192 width=16)
  • (actual time=0.441..0.550 rows=204 loops=1)
  • Recheck Cond:
  • (((tract_id)::text >= '25025000000'::text) AND
  • ((tract_id)::text <= '25025999999'::text))
  • Heap Blocks: exact=15
  • -> Bitmap Index Scan on hisp_pop_pkey
  • (cost=0.00..10.20 rows=192 width=0)
  • (actual time=0.421..0.421 rows=204 loops=1)
  • Index Cond:
  • (((tract_id)::text >= '25025000000'::text) AND
  • ((tract_id)::text <= '25025999999'::text))