explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q6cQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.075 3,540.573 ↑ 8.0 25 1

Sort (cost=3,653,298.57..3,653,299.07 rows=200 width=532) (actual time=3,540.572..3,540.573 rows=25 loops=1)

  • Sort Key: zips.tgt_org_unit_id DESC
  • Sort Method: quicksort Memory: 26kB
2. 178.255 3,540.498 ↑ 8.0 25 1

HashAggregate (cost=3,653,288.92..3,653,290.92 rows=200 width=532) (actual time=3,540.491..3,540.498 rows=25 loops=1)

  • Group Key: zips.tgt_org_unit_id
3. 184.154 3,362.243 ↑ 1.5 808,848 1

Nested Loop (cost=73.31..3,644,172.54 rows=1,215,518 width=532) (actual time=1.084..3,362.243 rows=808,848 loops=1)

4. 0.239 0.239 ↑ 1.0 325 1

Seq Scan on relvnt_zip_codes zips (cost=0.00..5.25 rows=325 width=1,032) (actual time=0.010..0.239 rows=325 loops=1)

5. 3,050.125 3,177.850 ↑ 1.5 2,489 325

Bitmap Heap Scan on atdntd_reg_vehicle_exp vr (cost=73.31..11,175.42 rows=3,740 width=22) (actual time=0.760..9.778 rows=2,489 loops=325)

  • Recheck Cond: (zip_code = (zips.zip_code)::text)
  • Heap Blocks: exact=807865
6. 127.725 127.725 ↑ 1.5 2,489 325

Bitmap Index Scan on atdntd_reg_vehicle_exp_zip_code_idx (cost=0.00..72.37 rows=3,740 width=0) (actual time=0.393..0.393 rows=2,489 loops=325)

  • Index Cond: (zip_code = (zips.zip_code)::text)
Planning time : 0.178 ms
Execution time : 3,540.635 ms