#	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)

QUERY PLAN
Aggregate  (cost=360789.23..360789.24 rows=1 width=0) (actual time=11326.034..11326.034 rows=1 loops=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)))
        ->  HashAggregate  (cost=35181.83..36181.83 rows=40000 width=29) (actual time=2546.340..4807.643 rows=526715 loops=1)
              ->  Append  (cost=0.00..14110.71 rows=526778 width=29) (actual time=0.030..544.685 rows=526802 loops=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)
                    ->  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)
        ->  Append  (cost=0.00..1.50 rows=2 width=8) (actual time=0.010..0.011 rows=1 loops=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)
              ->  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)
Total runtime: 11326.886 ms

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	148.976 ms	1.3 %
Append	2	1161.289 ms	10.3 %
HashAggregate	1	4262.958 ms	37.6 %
Index Scan	2	4740.435 ms	41.9 %
Nested Loop Left Join	1	575.550 ms	5.1 %
Seq Scan	2	436.826 ms	3.9 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
o_expertise	2	526.717 ms	4.7 %
Index Scan	1	526.715 ms	100.0 %
Seq Scan	1	0.002 ms	0.0 %
o_expertise_1205	2	4650.544 ms	41.1 %
Index Scan	1	4213.720 ms	90.6 %
Seq Scan	1	436.824 ms	9.4 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Kbq

Colorize:

Columns visibility:

Per node type stats

Per table stats