explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Kbq

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 148.976 11326.034 ↑ 1.0 1 1

Aggregate (cost=360789.23..360789.24 rows=1 width=0) (actual time=11326.034..11326.034 rows=1 loops=1)

2. 575.550 11177.058 ↑ 200.0 526715 1

Nested Loop Left Join (cost=35181.83..97400.23 rows=105355600 width=0) (actual time=2546.410..11177.058 rows=526715 loops=1)

  • Join Filter: (oe.id = (max(x.id)))
3. 4262.958 4807.643 ↓ 13.2 526715 1

HashAggregate (cost=35181.83..36181.83 rows=40000 width=29) (actual time=2546.340..4807.643 rows=526715 loops=1)

4. 107.859 544.685 ↓ 1.0 526802 1

Append (cost=0.00..14110.71 rows=526778 width=29) (actual time=0.030..544.685 rows=526802 loops=1)

5. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on o_expertise x (cost=0.00..0.00 rows=1 width=29) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (id_load_period = 1205)
6. 436.824 436.824 ↓ 1.0 526802 1

Seq Scan on o_expertise_1205 x (cost=0.00..14110.71 rows=526777 width=29) (actual time=0.027..436.824 rows=526802 loops=1)

  • Filter: (id_load_period = 1205)
7. 1053.430 5793.865 ↑ 2.0 1 526715

Append (cost=0.00..1.50 rows=2 width=8) (actual time=0.010..0.011 rows=1 loops=526715)

8. 526.715 526.715 ↓ 0.0 0 526715

Index Scan using o_expertise_pkey on o_expertise oe (cost=0.00..0.27 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=526715)

  • Index Cond: (id = (max(x.id)))
  • Filter: (id_load_period = 1205)
9. 4213.720 4213.720 ↑ 1.0 1 526715

Index Scan using o_expertise_1205_pkey on o_expertise_1205 oe (cost=0.00..1.23 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=526715)

  • Index Cond: (id = (max(x.id)))
  • Filter: (id_load_period = 1205)