explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NP7V

Settings
# exclusive inclusive rows x rows loops node
1. 0.040 298.508 ↑ 1.0 1 1

Aggregate (cost=162,605.19..162,605.20 rows=1 width=8) (actual time=298.502..298.508 rows=1 loops=1)

2. 90.923 298.468 ↓ 30.7 491 1

Hash Join (cost=1,960.65..162,605.15 rows=16 width=0) (actual time=34.284..298.468 rows=491 loops=1)

  • Hash Cond: (g.id = z.id)
3. 196.652 196.652 ↑ 1.0 808,402 1

Seq Scan on tbl_visual_zone_119270 g (cost=0.00..157,598.30 rows=810,730 width=4) (actual time=0.009..196.652 rows=808,402 loops=1)

4. 0.175 10.893 ↑ 1.2 491 1

Hash (cost=1,953.20..1,953.20 rows=596 width=8) (actual time=10.889..10.893 rows=491 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 28kB
5. 4.498 10.718 ↑ 1.2 491 1

Hash Join (cost=1,539.37..1,953.20 rows=596 width=8) (actual time=2.037..10.718 rows=491 loops=1)

  • Hash Cond: (z.id = av.zo_id)
6. 4.221 4.221 ↑ 1.0 21,768 1

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

7. 0.165 1.999 ↑ 1.2 491 1

Hash (cost=1,531.92..1,531.92 rows=596 width=4) (actual time=1.997..1.999 rows=491 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 26kB
8. 1.321 1.834 ↑ 1.2 491 1

Bitmap Heap Scan on rtpezoav_119075 av (cost=106.04..1,531.92 rows=596 width=4) (actual time=0.543..1.834 rows=491 loops=1)

  • Recheck Cond: ((pe_id = 66) AND (ad_id = 50))
  • Rows Removed by Index Recheck: 3,998
  • Heap Blocks: lossy=33
9. 0.035 0.513 ↓ 0.0 0 1

BitmapAnd (cost=106.04..106.04 rows=963 width=0) (actual time=0.512..0.513 rows=0 loops=1)

10. 0.057 0.057 ↑ 2.9 14,080 1

Bitmap Index Scan on rtpezoav_pe_id_idx_119075 (cost=0.00..12.07 rows=40,727 width=0) (actual time=0.056..0.057 rows=14,080 loops=1)

  • Index Cond: (pe_id = 66)
11. 0.421 0.421 ↑ 1.0 4,910 1

Bitmap Index Scan on rtpezoav_idx_ad_119075 (cost=0.00..93.42 rows=4,933 width=0) (actual time=0.420..0.421 rows=4,910 loops=1)

  • Index Cond: (ad_id = 50)
Planning time : 0.512 ms
Execution time : 298.592 ms