explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hNwi

Settings
# exclusive inclusive rows x rows loops node
1. 0.149 1,032.034 ↑ 1.0 1 1

Aggregate (cost=161,805.63..161,805.64 rows=1 width=8) (actual time=1,032.026..1,032.034 rows=1 loops=1)

2. 0.524 1,031.885 ↑ 1.2 476 1

Hash Join (cost=2,108.93..161,804.24 rows=556 width=0) (actual time=37.805..1,031.885 rows=476 loops=1)

  • Hash Cond: (av.zo_id = z.id)
3. 324.154 1,020.139 ↑ 1.2 476 1

Hash Join (cost=1,480.15..161,174.00 rows=556 width=8) (actual time=26.535..1,020.139 rows=476 loops=1)

  • Hash Cond: (g.id = av.zo_id)
4. 694.245 694.245 ↓ 1.0 808,402 1

Seq Scan on tbl_visual_zone_119270 g (cost=0.00..157,572.46 rows=808,146 width=4) (actual time=0.006..694.245 rows=808,402 loops=1)

5. 0.130 1.740 ↑ 1.2 476 1

Hash (cost=1,473.20..1,473.20 rows=556 width=4) (actual time=1.737..1.740 rows=476 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 25kB
6. 1.120 1.610 ↑ 1.2 476 1

Bitmap Heap Scan on rtpezoav_119074 av (cost=100.33..1,473.20 rows=556 width=4) (actual time=0.528..1.610 rows=476 loops=1)

  • Recheck Cond: ((pe_id = 66) AND (ad_id = 50))
  • Rows Removed by Index Recheck: 3,740
  • Heap Blocks: lossy=31
7. 0.039 0.490 ↓ 0.0 0 1

BitmapAnd (cost=100.33..100.33 rows=917 width=0) (actual time=0.488..0.490 rows=0 loops=1)

8. 0.058 0.058 ↑ 2.8 14,080 1

Bitmap Index Scan on rtpezoav_pe_id_idx_119074 (cost=0.00..12.07 rows=39,387 width=0) (actual time=0.057..0.058 rows=14,080 loops=1)

  • Index Cond: (pe_id = 66)
9. 0.393 0.393 ↓ 1.0 4,760 1

Bitmap Index Scan on rtpezoav_idx_ad_119074 (cost=0.00..87.73 rows=4,708 width=0) (actual time=0.393..0.393 rows=4,760 loops=1)

  • Index Cond: (ad_id = 50)
10. 5.816 11.222 ↑ 1.0 21,768 1

Hash (cost=356.68..356.68 rows=21,768 width=4) (actual time=11.221..11.222 rows=21,768 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,022kB
11. 5.406 5.406 ↑ 1.0 21,768 1

Seq Scan on rtzo_102093 z (cost=0.00..356.68 rows=21,768 width=4) (actual time=0.014..5.406 rows=21,768 loops=1)

Planning time : 0.522 ms
Execution time : 1,032.130 ms