explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vCTv

Settings
# exclusive inclusive rows x rows loops node
1. 0.142 0.773 ↑ 193.0 1 1

HashAggregate (cost=29.60..32.49 rows=193 width=64) (actual time=0.772..0.773 rows=1 loops=1)

  • Group Key: "left"((tract_id)::text, 5)
2. 0.146 0.631 ↓ 1.1 204 1

Bitmap Heap Scan on hisp_pop (cost=10.26..28.63 rows=193 width=36) (actual time=0.517..0.631 rows=204 loops=1)

  • Recheck Cond: (((tract_id)::text >= '25025000000'::text) AND ((tract_id)::text <= '25025999999'::text))
  • Heap Blocks: exact=15
3. 0.485 0.485 ↓ 1.1 204 1

Bitmap Index Scan on hisp_pop_pkey (cost=0.00..10.21 rows=193 width=0) (actual time=0.485..0.485 rows=204 loops=1)

  • Index Cond: (((tract_id)::text >= '25025000000'::text) AND ((tract_id)::text <= '25025999999'::text))
Planning time : 1.745 ms
Execution time : 0.855 ms