#	exclusive	inclusive	rows x	rows	loops	node
1.	231.404	7,797.560	↑ 1,401.0	1	1	→ Seq Scan on article_dosage ad (cost=0.00..3,285,987.46 rows=1,401 width=1,100) (actual time=6,746.922..7,797.560 rows=1 loops=1) Filter: (((SubPlan 1))::text = '5256632'::text) Rows Removed by Filter: 280227
2.						SubPlan (forSeq Scan)
3.	280.228	7,566.156	↑ 1.0	1	280,228	→ Limit (cost=11.68..11.68 rows=1 width=13) (actual time=0.026..0.027 rows=1 loops=280,228)
4.	1,681.368	7,285.928	↑ 1.0	1	280,228	→ Sort (cost=11.68..11.68 rows=1 width=13) (actual time=0.026..0.026 rows=1 loops=280,228) Sort Key: adav.valid_from DESC Sort Method: quicksort Memory: 25kB
5.	280.228	5,604.560	↑ 1.0	1	280,228	→ Nested Loop (cost=0.56..11.67 rows=1 width=13) (actual time=0.017..0.020 rows=1 loops=280,228)
6.	2,802.280	2,802.280	↑ 1.0	1	280,228	→ Seq Scan on article_dosage_attribute ada (cost=0.00..3.08 rows=1 width=7) (actual time=0.007..0.010 rows=1 loops=280,228) Filter: ((name)::text = 'article.dosage.sdu'::text) Rows Removed by Filter: 85
7.	2,522.052	2,522.052	↑ 1.0	1	280,228	→ Index Scan using pk_article_dosage_attr_value on article_dosage_attr_value adav (cost=0.56..8.58 rows=1 width=20) (actual time=0.008..0.009 rows=1 loops=280,228) Index Cond: ((article_dosage_id = ad.id) AND (attribute_id = ada.id) AND (valid_from < now()))

"Seq Scan on article_dosage ad  (cost=0.00..3285987.46 rows=1401 width=1100) (actual time=6746.922..7797.560 rows=1 loops=1)"
"  Filter: (((SubPlan 1))::text = '5256632'::text)"
"  Rows Removed by Filter: 280227"
"  SubPlan 1"
"    ->  Limit  (cost=11.68..11.68 rows=1 width=13) (actual time=0.026..0.027 rows=1 loops=280228)"
"          ->  Sort  (cost=11.68..11.68 rows=1 width=13) (actual time=0.026..0.026 rows=1 loops=280228)"
"                Sort Key: adav.valid_from DESC"
"                Sort Method: quicksort  Memory: 25kB"
"                ->  Nested Loop  (cost=0.56..11.67 rows=1 width=13) (actual time=0.017..0.020 rows=1 loops=280228)"
"                      ->  Seq Scan on article_dosage_attribute ada  (cost=0.00..3.08 rows=1 width=7) (actual time=0.007..0.010 rows=1 loops=280228)"
"                            Filter: ((name)::text = 'article.dosage.sdu'::text)"
"                            Rows Removed by Filter: 85"
"                      ->  Index Scan using pk_article_dosage_attr_value on article_dosage_attr_value adav  (cost=0.56..8.58 rows=1 width=20) (actual time=0.008..0.009 rows=1 loops=280228)"
"                            Index Cond: ((article_dosage_id = ad.id) AND (attribute_id = ada.id) AND (valid_from < now()))"
"Planning time: 2.043 ms"
"Execution time: 7797.719 ms"

Per node type stats

node type	count	sum of times	% of query
Index Scan	1	2,522.052 ms	32.3 %
Limit	1	280.228 ms	3.6 %
Nested Loop	1	280.228 ms	3.6 %
Seq Scan	2	3,033.684 ms	38.9 %
Sort	1	1,681.368 ms	21.6 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
article_dosage	1	231.404 ms	3.0 %
Seq Scan	1	231.404 ms	100.0 %
article_dosage_attr_value	1	2,522.052 ms	32.3 %
Index Scan	1	2,522.052 ms	100.0 %
article_dosage_attribute	1	2,802.280 ms	35.9 %
Seq Scan	1	2,802.280 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8HOZ

Color mode:

Visible columns:

Per node type stats

Per table stats