explain.depesz.com

A tool for finding a real cause for slow queries.

Result: tlo

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# 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)