#	exclusive	inclusive	rows x	rows	loops	node
1.	161.812	787.098	↓ 470.3	85593	1	→ Nested Loop (cost=3.27..101.11 rows=182 width=430) (actual time=1.123..787.098 rows=85593 loops=1)
2.	101.214	208.761	↓ 534.0	83305	1	→ Nested Loop (cost=3.27..38.88 rows=156 width=315) (actual time=0.949..208.761 rows=83305 loops=1)
3.	0.536	4.075	↓ 111.5	446	1	→ Nested Loop (cost=3.27..15.89 rows=4 width=8) (actual time=0.764..4.075 rows=446 loops=1)
4.	0.091	1.091	↓ 24.0	48	1	→ Nested Loop (cost=3.27..14.12 rows=2 width=8) (actual time=0.672..1.091 rows=48 loops=1)
5.	0.400	0.400	↑ 1.0	1	1	→ Index Scan using cpte_entite_juridique_siren on cpte_entite_juridique a4_ (cost=0.00..6.27 rows=1 width=8) (actual time=0.367..0.400 rows=1 loops=1) Index Cond: ((siren)::text = '046970406'::text)
6.	0.351	0.600	↓ 24.0	48	1	→ Bitmap Heap Scan on cpte_root a3_ (cost=3.27..7.83 rows=2 width=16) (actual time=0.279..0.600 rows=48 loops=1) Recheck Cond: (a3_.entite_juridique_id = a4_.id)
7.	0.249	0.249	↓ 24.0	48	1	→ Bitmap Index Scan on cpte_root_ejid (cost=0.00..3.27 rows=2 width=0) (actual time=0.249..0.249 rows=48 loops=1) Index Cond: (a3_.entite_juridique_id = a4_.id)
8.	2.448	2.448	↓ 3.0	9	48	→ Index Scan using cpte_compte_facturation_root_id on cpte_compte_facturation a2_ (cost=0.00..0.85 rows=3 width=16) (actual time=0.022..0.051 rows=9 loops=48) Index Cond: (a2_.root_id = a3_.id)
9.	103.472	103.472	↓ 3.8	187	446	→ Index Scan using cpte_ligne_telephonique_cfid on cpte_ligne_telephonique a0_ (cost=0.00..5.14 rows=49 width=323) (actual time=0.026..0.232 rows=187 loops=446) Index Cond: (a0_.compte_facturation_id = a2_.id)
10.	416.525	416.525	↑ 1.0	1	83305	→ Index Scan using cpte_produit_ligne_ltid on cpte_produit_ligne a1_ (cost=0.00..0.39 rows=1 width=123) (actual time=0.005..0.005 rows=1 loops=83305) Index Cond: (a1_.ligne_telephonique_id = a0_.id)

 Nested Loop  (cost=3.27..101.11 rows=182 width=430) (actual time=1.123..787.098 rows=85593 loops=1)
   ->  Nested Loop  (cost=3.27..38.88 rows=156 width=315) (actual time=0.949..208.761 rows=83305 loops=1)
         ->  Nested Loop  (cost=3.27..15.89 rows=4 width=8) (actual time=0.764..4.075 rows=446 loops=1)
               ->  Nested Loop  (cost=3.27..14.12 rows=2 width=8) (actual time=0.672..1.091 rows=48 loops=1)
                     ->  Index Scan using cpte_entite_juridique_siren on cpte_entite_juridique a4_  (cost=0.00..6.27 rows=1 width=8) (actual time=0.367..0.400 rows=1 loops=1)
                           Index Cond: ((siren)::text = '046970406'::text)
                     ->  Bitmap Heap Scan on cpte_root a3_  (cost=3.27..7.83 rows=2 width=16) (actual time=0.279..0.600 rows=48 loops=1)
                           Recheck Cond: (a3_.entite_juridique_id = a4_.id)
                           ->  Bitmap Index Scan on cpte_root_ejid  (cost=0.00..3.27 rows=2 width=0) (actual time=0.249..0.249 rows=48 loops=1)
                                 Index Cond: (a3_.entite_juridique_id = a4_.id)
               ->  Index Scan using cpte_compte_facturation_root_id on cpte_compte_facturation a2_  (cost=0.00..0.85 rows=3 width=16) (actual time=0.022..0.051 rows=9 loops=48)
                     Index Cond: (a2_.root_id = a3_.id)
         ->  Index Scan using cpte_ligne_telephonique_cfid on cpte_ligne_telephonique a0_  (cost=0.00..5.14 rows=49 width=323) (actual time=0.026..0.232 rows=187 loops=446)
               Index Cond: (a0_.compte_facturation_id = a2_.id)
   ->  Index Scan using cpte_produit_ligne_ltid on cpte_produit_ligne a1_  (cost=0.00..0.39 rows=1 width=123) (actual time=0.005..0.005 rows=1 loops=83305)
         Index Cond: (a1_.ligne_telephonique_id = a0_.id)
 Total runtime: 806.875 ms
(17 lignes)

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	0.351 ms	0.0 %
Bitmap Index Scan	1	0.249 ms	0.0 %
Index Scan	4	522.845 ms	66.4 %
Nested Loop	4	263.653 ms	33.5 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
cpte_compte_facturation	1	2.448 ms	0.3 %
Index Scan	1	2.448 ms	100.0 %
cpte_entite_juridique	1	0.400 ms	0.1 %
Index Scan	1	0.400 ms	100.0 %
cpte_ligne_telephonique	1	103.472 ms	13.1 %
Index Scan	1	103.472 ms	100.0 %
cpte_produit_ligne	1	416.525 ms	52.9 %
Index Scan	1	416.525 ms	100.0 %
cpte_root	1	0.351 ms	0.0 %
Bitmap Heap Scan	1	0.351 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: tlo

Colorize:

Columns visibility:

Per node type stats

Per table stats