explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s9Dq : test

Settings

Optimization(s) for this plan:

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

Hash Join (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)
2. 0.129 0.550 ↓ 1.1 204 1

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
3. 0.421 0.421 ↓ 1.1 204 1

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))