explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 4Eo : 2idx

options
# exclusive inclusive rows x rows loops node
1. 5816.185 86452.995 ↓ 752314.0 752314 1
→

HashAggregate (cost=619813.12..619813.13 rows=1 width=104) (actual time=85888.788..86452.995 rows=752314 loops=1)

  • Buffers: shared hit=10547158 read=40977
2. 3358.728 80636.810 ↓ 2178784.0 2178784 1
→

Nested Loop (cost=0.00..619813.09 rows=1 width=104) (actual time=438.354..80636.810 rows=2178784 loops=1)

  • Join Filter: ((i1.id_portion)::text = t1.id_portion)
  • Buffers: shared hit=10547158 read=40977
3. 2826.938 24517.205 ↓ 917.8 1352843 1
→

Subquery Scan on t1 (cost=0.00..612349.42 rows=1474 width=68) (actual time=438.294..24517.205 rows=1352843 loops=1)

  • Filter: ((t1.nd)::text ~~ '%/__0612/%'::text)
  • Buffers: shared hit=2154020 read=40612
4. 10791.429 21690.267 ↑ 1.0 5685117 1
→

WindowAgg (cost=0.00..535600.34 rows=5685117 width=43) (actual time=399.633..21690.267 rows=5685117 loops=1)

  • Buffers: shared hit=2154020 read=40612
5. 10898.838 10898.838 ↑ 1.0 5685117 1
→

Index Scan using dclcont_idx2 on dclcont (cost=0.00..416212.88 rows=5685117 width=43) (actual time=399.597..10898.838 rows=5685117 loops=1)

  • Buffers: shared hit=2154020 read=40612
6. 52760.877 52760.877 ↓ 2.0 2 1352843
→

Index Scan using dclcont_idx2 on dclcont i1 (cost=0.00..5.04 rows=1 width=111) (actual time=0.037..0.039 rows=2 loops=1352843)

  • Index Cond: (((nd)::text = (t1.nd)::text) AND (g32 = t1.g32) AND (nzp = t1.nzp))
  • Buffers: shared hit=8393138 read=365