explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VLsr : t2

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

Gather (cost=1,029.57..1,051.65 rows=192 width=64) (actual time=12.881..13.947 rows=1 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Single Copy: true
2. 0.047 0.231 ↑ 192.0 1 1

HashAggregate (cost=29.57..32.45 rows=192 width=64) (actual time=0.230..0.231 rows=1 loops=1)

  • Group Key: "left"((tract_id)::text, 5)
3. 0.078 0.184 ↓ 1.1 204 1

Bitmap Heap Scan on hisp_pop (cost=10.25..28.61 rows=192 width=36) (actual time=0.127..0.184 rows=204 loops=1)

  • Recheck Cond:
  • (((tract_id)::text >= '25025000000'::text) AND ((tract_id)::text <= '25025999999'::text))
4. 0.106 0.106 ↓ 1.1 204 1

Bitmap Index Scan on hisp_pop_pkey (cost=0.00..10.20 rows=192 width=0) (actual time=0.106..0.106 rows=204 loops=1)

  • Index Cond:
  • (((tract_id)::text >= '25025000000'::text) AND ((tract_id)::text <= '25025999999'::text))