#	exclusive	inclusive	rows x	rows	loops	node
1.	4.511	264.749	↑ 1.0	1	1	→ Aggregate (cost=55.62..55.63 rows=1 width=4) (actual time=264.749..264.749 rows=1 loops=1)
2.	48.428	260.238	↓ 3,239.1	22,674	1	→ Nested Loop (cost=1.12..55.60 rows=7 width=4) (actual time=0.030..260.238 rows=22,674 loops=1)
3.	46.928	189.136	↓ 3,239.1	22,674	1	→ Nested Loop (cost=0.97..54.00 rows=7 width=37) (actual time=0.024..189.136 rows=22,674 loops=1)
4.	41.029	119.534	↓ 3,239.1	22,674	1	→ Nested Loop (cost=0.83..52.83 rows=7 width=37) (actual time=0.020..119.534 rows=22,674 loops=1)
5.	7.018	7.018	↓ 1,588.6	23,829	1	→ Index Scan using x_dm5_caracteristiquearticlestock_00 on dm5_caracteristiquearticlestock caracteris1_ (cost=0.42..16.12 rows=15 width=33) (actual time=0.012..7.018 rows=23,829 loops=1) Index Cond: ((id_article)::text = ($1)::text)
6.	71.487	71.487	↑ 1.0	1	23,829	→ Index Scan using x_dm5_quantitestock_00 on dm5_quantitestock quantitest0_ (cost=0.42..2.44 rows=1 width=70) (actual time=0.002..0.003 rows=1 loops=23,829) Index Cond: ((id_caracteristiquearticlestock)::text = (caracteris1_.id)::text) Filter: ((datefinvalidite IS NULL) AND (quantite_valeur <> '0'::numeric)) Rows Removed by Filter: 0
7.	22.674	22.674	↑ 1.0	1	22,674	→ Index Scan using dm5_caracteristiquelieustock_pkey on dm5_caracteristiquelieustock caracteris2_ (cost=0.14..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=1 loops=22,674) Index Cond: ((id)::text = (quantitest0_.id_caracteristiquelieustock)::text)
8.	22.674	22.674	↑ 1.0	1	22,674	→ Index Scan using dm5_lieustockage_pkey on dm5_lieustockage lieustocka3_ (cost=0.14..0.22 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=22,674) Index Cond: ((id)::text = (caracteris2_.id_lieustockage)::text) Filter: ((id_etablissement)::text = ($2)::text)

2018-11-30 10:56:50 CET Tx[310423] cmd[idle in transaction] PID[8076] DB[LOSANGE] LOG:  duration: 264.758 ms  plan:
        Query Text: select sum(quantitest0_.quantite_valeur) as col_0_0_ from dm5_quantitestock quantitest0_, dm5_caracteristiquearticlestock caracteris1_, dm5_caracteristiquelieustock caracteris2_, dm5_lieustockage lieustocka3_ where quantitest0_.id_caracteristiquearticlestock=caracteris1_.id and quantitest0_.id_caracteristiquelieustock=caracteris2_.id and caracteris2_.id_lieustockage=lieustocka3_.id and quantitest0_.quantite_valeur<>0 and (quantitest0_.dateFinValidite is null) and caracteris1_.id_article=$1 and lieustocka3_.id_etablissement=$2
        Aggregate  (cost=55.62..55.63 rows=1 width=4) (actual time=264.749..264.749 rows=1 loops=1)
          ->  Nested Loop  (cost=1.12..55.60 rows=7 width=4) (actual time=0.030..260.238 rows=22674 loops=1)
                ->  Nested Loop  (cost=0.97..54.00 rows=7 width=37) (actual time=0.024..189.136 rows=22674 loops=1)
                      ->  Nested Loop  (cost=0.83..52.83 rows=7 width=37) (actual time=0.020..119.534 rows=22674 loops=1)
                            ->  Index Scan using x_dm5_caracteristiquearticlestock_00 on dm5_caracteristiquearticlestock caracteris1_  (cost=0.42..16.12 rows=15 width=33) (actual time=0.012..7.018 rows=23829 loops=1)
                                  Index Cond: ((id_article)::text = ($1)::text)
                            ->  Index Scan using x_dm5_quantitestock_00 on dm5_quantitestock quantitest0_  (cost=0.42..2.44 rows=1 width=70) (actual time=0.002..0.003 rows=1 loops=23829)
                                  Index Cond: ((id_caracteristiquearticlestock)::text = (caracteris1_.id)::text)
                                  Filter: ((datefinvalidite IS NULL) AND (quantite_valeur <> '0'::numeric))
                                  Rows Removed by Filter: 0
                      ->  Index Scan using dm5_caracteristiquelieustock_pkey on dm5_caracteristiquelieustock caracteris2_  (cost=0.14..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=1 loops=22674)
                            Index Cond: ((id)::text = (quantitest0_.id_caracteristiquelieustock)::text)
                ->  Index Scan using dm5_lieustockage_pkey on dm5_lieustockage lieustocka3_  (cost=0.14..0.22 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=22674)
                      Index Cond: ((id)::text = (caracteris2_.id_lieustockage)::text)
                      Filter: ((id_etablissement)::text = ($2)::text)

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	4.511 ms	1.7 %
Index Scan	4	123.853 ms	46.8 %
Nested Loop	3	136.385 ms	51.5 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
dm5_caracteristiquearticlestock	1	7.018 ms	2.7 %
Index Scan	1	7.018 ms	100.0 %
dm5_caracteristiquelieustock	1	22.674 ms	8.6 %
Index Scan	1	22.674 ms	100.0 %
dm5_lieustockage	1	22.674 ms	8.6 %
Index Scan	1	22.674 ms	100.0 %
dm5_quantitestock	1	71.487 ms	27.0 %
Index Scan	1	71.487 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vgy5 : FAST

Color mode:

Visible columns:

Per node type stats

Per table stats