explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bs4D

Settings
# exclusive inclusive rows x rows loops node
1. 115.466 1,168.586 ↑ 26.0 1 1

HashAggregate (cost=2,854,881.78..2,854,882.04 rows=26 width=25) (actual time=1,168.586..1,168.586 rows=1 loops=1)

  • Group Key: ozc.tgt_org_unit_id
2. 103.957 1,053.120 ↑ 1.7 559,816 1

Nested Loop (cost=73.50..2,847,934.24 rows=926,339 width=25) (actual time=0.439..1,053.120 rows=559,816 loops=1)

3. 0.971 0.971 ↑ 1.0 249 1

Index Only Scan using market_zip_code_org_src_org_unit_id_tgt_org_level_number_z_idx1 on market_zip_code_org ozc (cost=0.28..241.13 rows=249 width=15) (actual time=0.026..0.971 rows=249 loops=1)

  • Index Cond: ((src_org_unit_id = 'Organization-1'::text) AND (tgt_org_level_number = 1))
  • Heap Fetches: 249
4. 871.002 948.192 ↑ 1.7 2,248 249

Bitmap Heap Scan on atdntd_reg_vehicle_exp vr (cost=73.23..11,399.29 rows=3,723 width=22) (actual time=0.629..3.808 rows=2,248 loops=249)

  • Recheck Cond: (zip_code = (ozc.zip_code)::text)
  • Heap Blocks: exact=559175
5. 77.190 77.190 ↑ 1.7 2,248 249

Bitmap Index Scan on atdntd_reg_vehicle_exp_zip_code_idx_sort (cost=0.00..72.30 rows=3,723 width=0) (actual time=0.310..0.310 rows=2,248 loops=249)

  • Index Cond: (zip_code = (ozc.zip_code)::text)
Planning time : 0.402 ms
Execution time : 1,168.642 ms