explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WfEI

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 3,868.378 ↑ 1.0 1 1

GroupAggregate (cost=10,000,000,868.42..10,000,342,997.95 rows=1 width=88) (actual time=3,868.368..3,868.378 rows=1 loops=1)

  • Group Key: NULL::integer
2. 0.010 3,868.360 ↓ 35.0 35 1

Nested Loop (cost=10,000,000,868.42..10,000,342,997.94 rows=1 width=12) (actual time=3,500.512..3,868.360 rows=35 loops=1)

3. 0.019 0.051 ↑ 1.0 1 1

Hash Join (cost=8.31..9.54 rows=1 width=4) (actual time=0.046..0.051 rows=1 loops=1)

  • Hash Cond: (b.id = c.br_id)
4. 0.013 0.013 ↑ 1.0 17 1

Seq Scan on rtbr_102095 b (cost=0.00..1.17 rows=17 width=4) (actual time=0.009..0.013 rows=17 loops=1)

5. 0.005 0.019 ↑ 1.0 1 1

Hash (cost=8.30..8.30 rows=1 width=8) (actual time=0.018..0.019 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
6. 0.014 0.014 ↑ 1.0 1 1

Index Scan using rtco_pkey_120185 on rtco_120185 c (cost=0.29..8.30 rows=1 width=8) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: (lo_id = 693)
7. 0.029 3,868.299 ↓ 35.0 35 1

Hash Join (cost=860.11..342,988.39 rows=1 width=12) (actual time=3,500.463..3,868.299 rows=35 loops=1)

  • Hash Cond: (act.se_id = av.se_id)
8. 3,860.356 3,860.356 ↓ 1.7 10 1

Seq Scan on rmv_active_sepeco_119895 act (cost=0.00..342,128.25 rows=6 width=12) (actual time=3,491.909..3,860.356 rows=10 loops=1)

  • Filter: ((co_id = 693) AND (pe_id = 391))
  • Rows Removed by Filter: 16,766,535
9. 0.012 7.914 ↓ 35.0 35 1

Hash (cost=860.09..860.09 rows=1 width=20) (actual time=7.908..7.914 rows=35 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
10. 2.958 7.902 ↓ 35.0 35 1

Hash Join (cost=421.77..860.09 rows=1 width=20) (actual time=3.973..7.902 rows=35 loops=1)

  • Hash Cond: (z.id = av_.zo_id)
11. 2.779 2.779 ↑ 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..2.779 rows=21,768 loops=1)

12. 0.013 2.165 ↓ 35.0 35 1

Hash (cost=421.76..421.76 rows=1 width=24) (actual time=2.159..2.165 rows=35 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
13. 0.612 2.152 ↓ 35.0 35 1

Hash Join (cost=74.38..421.76 rows=1 width=24) (actual time=0.707..2.152 rows=35 loops=1)

  • Hash Cond: (av_.combi_id = av.id)
14. 0.696 1.540 ↓ 1.1 35 1

Append (cost=0.00..347.31 rows=31 width=18) (actual time=0.110..1.540 rows=35 loops=1)

  • -> Seq Scan on rtsepezocoav_14_391_334_280487 av__4 (cost=0.00..1.02 rows=1 wid
15. 0.119 0.119 ↑ 1.0 2 1

Seq Scan on rtsepezocoav_12_391_334_274151 av_ (cost=0.00..25.83 rows=2 width=18) (actual time=0.108..0.119 rows=2 loops=1)

  • Filter: ((co_id = 693) AND (combi_id = ANY ('{135,619,867,868,1341,1565,1671,2629,3142,3188}'::integer[])))
  • Rows Removed by Filter: 791
16. 0.359 0.359 ↑ 1.0 9 1

Seq Scan on rtsepezocoav_22_391_334_276359 av__1 (cost=0.00..82.12 rows=9 width=18) (actual time=0.087..0.359 rows=9 loops=1)

  • Filter: ((co_id = 693) AND (combi_id = ANY ('{135,619,867,868,1341,1565,1671,2629,3142,3188}'::integer[])))
  • Rows Removed by Filter: 2,596
17. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on rtsepezocoav_18_391_334_277895 av__2 (cost=0.00..1.52 rows=1 width=18) (actual time=0.007..0.008 rows=0 loops=1)

  • Filter: ((co_id = 693) AND (combi_id = ANY ('{135,619,867,868,1341,1565,1671,2629,3142,3188}'::integer[])))
  • Rows Removed by Filter: 21
18. 0.358 0.358 ↓ 9.0 9 1

Seq Scan on rtsepezocoav_20_391_334_277943 av__3 (cost=0.00..82.12 rows=1 width=18) (actual time=0.083..0.358 rows=9 loops=1)

  • Filter: ((co_id = 693) AND (combi_id = ANY ('{135,619,867,868,1341,1565,1671,2629,3142,3188}'::integer[])))
  • Rows Removed by Filter: 2,596