#	rows x	node
1.	↓ 0.0	→ Aggregate (cost=55.62..55.63 rows=1 width=4) (actual rows= loops=)
2.	↓ 0.0	→ Nested Loop (cost=1.12..55.60 rows=7 width=4) (actual rows= loops=)
3.	↓ 0.0	→ Nested Loop (cost=0.97..54.00 rows=7 width=37) (actual rows= loops=)
4.	↓ 0.0	→ Nested Loop (cost=0.83..52.83 rows=7 width=37) (actual rows= loops=)
5.	↓ 0.0	→ Index Scan using x_dm5_caracteristiquearticlestock_00 on dm5_caracteristiquearticlestock caracteris1_ (cost=0.42..16.12 rows=15 width=33) (actual rows= loops=) Index Cond: ((id_article)::text = ($1)::text)
6.	↓ 0.0	→ Index Scan using x_dm5_quantitestock_00 on dm5_quantitestock quantitest0_ (cost=0.42..2.44 rows=1 width=70) (actual rows= loops=) Index Cond: ((id_caracteristiquearticlestock)::text = (caracteris1_.id)::text) Filter: ((datefinvalidite IS NULL) AND (quantite_valeur <> '0'::numeric))
7.	↓ 0.0	→ Index Scan using dm5_caracteristiquelieustock_pkey on dm5_caracteristiquelieustock caracteris2_ (cost=0.14..0.16 rows=1 width=66) (actual rows= loops=) Index Cond: ((id)::text = (quantitest0_.id_caracteristiquelieustock)::text)
8.	↓ 0.0	→ Index Scan using dm5_lieustockage_pkey on dm5_lieustockage lieustocka3_ (cost=0.14..0.22 rows=1 width=32) (actual rows= loops=) Index Cond: ((id)::text = (caracteris2_.id_lieustockage)::text) Filter: ((id_etablissement)::text = ($2)::text)

2018-11-30 10:47:39 CET Tx[309392] cmd[idle in transaction] PID[7596] DB[LOSANGE] LOG:  duration: 123.545 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)
          ->  Nested Loop  (cost=1.12..55.60 rows=7 width=4)
                ->  Nested Loop  (cost=0.97..54.00 rows=7 width=37)
                      ->  Nested Loop  (cost=0.83..52.83 rows=7 width=37)
                            ->  Index Scan using x_dm5_caracteristiquearticlestock_00 on dm5_caracteristiquearticlestock caracteris1_  (cost=0.42..16.12 rows=15 width=33)
                                  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)
                                  Index Cond: ((id_caracteristiquearticlestock)::text = (caracteris1_.id)::text)
                                  Filter: ((datefinvalidite IS NULL) AND (quantite_valeur <> '0'::numeric))
                      ->  Index Scan using dm5_caracteristiquelieustock_pkey on dm5_caracteristiquelieustock caracteris2_  (cost=0.14..0.16 rows=1 width=66)
                            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)
                      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	0.000 ms	0.0 %
Index Scan	4	0.000 ms	0.0 %
Nested Loop	3	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
dm5_caracteristiquearticlestock	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
dm5_caracteristiquelieustock	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
dm5_lieustockage	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
dm5_quantitestock	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZpTG

Color mode:

Visible columns:

Per node type stats

Per table stats