explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IaPw

Settings
# exclusive inclusive rows x rows loops node
1. 0.103 1,084.347 ↑ 1.0 1 1

Aggregate (cost=169,800.13..169,800.14 rows=1 width=8) (actual time=1,084.335..1,084.347 rows=1 loops=1)

2. 410.895 1,084.244 ↓ 31.7 476 1

Hash Join (cost=9,191.41..169,800.10 rows=15 width=0) (actual time=39.349..1,084.244 rows=476 loops=1)

  • Hash Cond: (g.id = z.id)
3. 659.134 659.134 ↓ 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.010..659.134 rows=808,402 loops=1)

4. 0.146 14.215 ↑ 1.2 476 1

Hash (cost=9,184.31..9,184.31 rows=568 width=8) (actual time=14.205..14.215 rows=476 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 27kB
5. 0.270 14.069 ↑ 1.2 476 1

Hash Join (cost=9,171.46..9,184.31 rows=568 width=8) (actual time=13.641..14.069 rows=476 loops=1)

  • Hash Cond: (rtpezoav.zo_id = z.id)
6. 0.501 2.630 ↑ 1.2 476 1

HashAggregate (cost=8,542.68..8,548.36 rows=568 width=56) (actual time=2.424..2.630 rows=476 loops=1)

  • Group Key: rtpezoav.id, rtpezoav.ad_id, rtpezoav.pe_id, rtpezoav.zo_id, rtpezoav.value_num, rtpezoav.value_text
7. 0.077 2.129 ↑ 1.2 476 1

Append (cost=619.00..8,534.16 rows=568 width=56) (actual time=1.636..2.129 rows=476 loops=1)

8. 0.189 1.810 ↑ 1.2 476 1

Bitmap Heap Scan on rtpezoav_distr_119221 rtpezoav (cost=619.00..1,724.48 rows=567 width=56) (actual time=1.635..1.810 rows=476 loops=1)

  • Recheck Cond: ((pe_id = 66) AND (ad_id = 50))
  • Heap Blocks: exact=5
9. 1.621 1.621 ↑ 1.2 476 1

Bitmap Index Scan on rtpezoav_distr_unique_119221 (cost=0.00..618.86 rows=567 width=0) (actual time=1.620..1.621 rows=476 loops=1)

  • Index Cond: ((pe_id = 66) AND (ad_id = 50))
10. 0.003 0.242 ↓ 0.0 0 1

Hash Anti Join (cost=1,738.58..6,801.16 rows=1 width=56) (actual time=0.237..0.242 rows=0 loops=1)

  • Hash Cond: ((rtpe.id = av_1_1.pe_id) AND (av_1.ad_id = av_1_1.ad_id) AND (av_1.zo_id = av_1_1.zo_id))
11. 0.008 0.239 ↓ 0.0 0 1

Hash Join (cost=4.18..4,035.34 rows=532 width=56) (actual time=0.236..0.239 rows=0 loops=1)

  • Hash Cond: (av_1.pe_id = rtpe.baseline_id)
12. 0.215 0.215 ↑ 4,732.0 1 1

Seq Scan on rtpezoav_distr_119221 av_1 (cost=0.00..4,012.83 rows=4,732 width=56) (actual time=0.215..0.215 rows=1 loops=1)

  • Filter: (ad_id = 50)
  • Rows Removed by Filter: 952
13. 0.002 0.016 ↓ 0.0 0 1

Hash (cost=4.17..4.17 rows=1 width=8) (actual time=0.015..0.016 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
14. 0.014 0.014 ↑ 1.0 1 1

Index Only Scan using rtpe_id_baseline_id_idx_102089 on rtpe_102089 rtpe (cost=0.15..4.17 rows=1 width=8) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: (id = 66)
  • Heap Fetches: 0
15. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,724.48..1,724.48 rows=567 width=12) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on rtpezoav_distr_119221 av_1_1 (cost=619.00..1,724.48 rows=567 width=12) (never executed)

  • Recheck Cond: ((pe_id = 66) AND (ad_id = 50))
17. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on rtpezoav_distr_unique_119221 (cost=0.00..618.86 rows=567 width=0) (never executed)

  • Index Cond: ((pe_id = 66) AND (ad_id = 50))
18. 5.819 11.169 ↑ 1.0 21,768 1

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

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

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

Planning time : 1.062 ms
Execution time : 1,084.513 ms