explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yXln

Settings
# exclusive inclusive rows x rows loops node
1. 1.670 109.093 ↑ 1.0 1 1

Aggregate (cost=132,800,000,510,835.42..132,800,000,510,835.44 rows=1 width=8) (actual time=108.899..109.093 rows=1 loops=1)

2. 12.451 107.423 ↓ 1.2 8,269 1

Nested Loop (cost=20,000,016,286.45..132,800,000,510,818.83 rows=6,639 width=0) (actual time=17.452..107.423 rows=8,269 loops=1)

  • Join Filter: (NOT (SubPlan 1))
3. 2.456 94.972 ↑ 1.6 8,269 1

Nested Loop (cost=10,000,016,286.17..10,000,018,146.82 rows=13,278 width=14) (actual time=17.419..94.972 rows=8,269 loops=1)

4. 0.020 0.020 ↑ 1.0 1 1

Seq Scan on rtbr_102095 b (cost=0.00..1.21 rows=1 width=4) (actual time=0.016..0.020 rows=1 loops=1)

  • Filter: (id = 926)
  • Rows Removed by Filter: 16
5. 5.082 92.496 ↑ 1.6 8,269 1

Hash Join (cost=16,286.17..18,012.82 rows=13,278 width=18) (actual time=17.399..92.496 rows=8,269 loops=1)

  • Hash Cond: (av_.zo_id = z.id)
6. 5.804 76.203 ↑ 1.6 8,269 1

Hash Join (cost=15,657.39..17,349.18 rows=13,278 width=18) (actual time=6.137..76.203 rows=8,269 loops=1)

  • Hash Cond: (av_.co_id = act.co_id)
7. 25.663 66.936 ↑ 2.5 8,854 1

Hash Join (cost=244.93..1,879.45 rows=21,802 width=18) (actual time=2.655..66.936 rows=8,854 loops=1)

  • Hash Cond: (av_.co_id = c.lo_id)
8. 38.686 38.686 ↑ 1.0 75,997 1

Seq Scan on rtsepezocoav_12_63_335_307031 av_ (cost=0.00..1,434.96 rows=75,997 width=10) (actual time=0.017..38.686 rows=75,997 loops=1)

  • Filter: (combi_id = 3,205)
9. 1.093 2.587 ↑ 1.0 3,806 1

Hash (cost=197.36..197.36 rows=3,806 width=8) (actual time=2.585..2.587 rows=3,806 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 181kB
10. 1.187 1.494 ↑ 1.0 3,806 1

Bitmap Heap Scan on rtco_120185 c (cost=77.78..197.36 rows=3,806 width=8) (actual time=0.320..1.494 rows=3,806 loops=1)

  • Recheck Cond: (br_id = 926)
  • Heap Blocks: exact=26
11. 0.307 0.307 ↑ 1.0 3,806 1

Bitmap Index Scan on rtco_br_id_idx_120185 (cost=0.00..76.83 rows=3,806 width=0) (actual time=0.306..0.307 rows=3,806 loops=1)

  • Index Cond: (br_id = 926)
12. 1.432 3.463 ↓ 1.1 5,017 1

Hash (cost=15,354.04..15,354.04 rows=4,673 width=8) (actual time=3.461..3.463 rows=5,017 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 260kB
13. 1.510 2.031 ↓ 1.1 5,017 1

Bitmap Heap Scan on rmv_active_sepeco_119895 act (cost=124.46..15,354.04 rows=4,673 width=8) (actual time=0.543..2.031 rows=5,017 loops=1)

  • Recheck Cond: ((se_id = 12) AND (pe_id = 70))
  • Heap Blocks: exact=28
14. 0.521 0.521 ↓ 1.1 5,017 1

Bitmap Index Scan on rmv_active_sepeco_2_se_id_pe_id_co_id_idx_119895 (cost=0.00..123.29 rows=4,673 width=0) (actual time=0.520..0.521 rows=5,017 loops=1)

  • Index Cond: ((se_id = 12) AND (pe_id = 70))
15. 5.775 11.211 ↑ 1.0 21,768 1

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

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

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

17. 0.000 0.000 ↑ 1.0 1 8,269

Materialize (cost=0.28..8.31 rows=1 width=10) (actual time=0.000..0.000 rows=1 loops=8,269)

18. 0.019 0.019 ↑ 1.0 1 1

Index Scan using rt_sepeadsh_pkey_140422 on rt_sepeadsh_140422 av (cost=0.28..8.30 rows=1 width=10) (actual time=0.019..0.019 rows=1 loops=1)

  • Index Cond: (id = 3,205)
  • Filter: ((se_id = 12) AND (ad_id = 335) AND (pe_id = 63))
19.          

SubPlan (for Nested Loop)

20. 0.000 0.000 ↓ 0.0 0 8,269

Result (cost=10,000,000,000.28..10,000,027,054.72 rows=735 width=0) (actual time=0.000..0.000 rows=0 loops=8,269)

  • One-Time Filter: (av_.combi_id = 2,342)
21. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=10,000,000,000.28..10,000,027,054.72 rows=735 width=0) (never executed)

  • -> Index Scan using idx_sepead_140422 on rt_sepeadsh_140422 avo (cost=0.2