explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ayyr

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.013 ↓ 0.0 0 1

Group (cost=180.47..180.50 rows=1 width=199) (actual time=0.013..0.013 rows=0 loops=1)

  • Group Key: facture.id_fact, edition_fact.mode_envoi, films.nom_film, societe_redressement.redressement, societe_redressement.liquidation, societe.id_societe, cinema.liv_ville, cinema.liv_dep, cinema.nom_cinema
2. 0.009 0.013 ↓ 0.0 0 1

Sort (cost=180.47..180.48 rows=1 width=199) (actual time=0.013..0.013 rows=0 loops=1)

  • Sort Key: facture.id_fact, edition_fact.mode_envoi, films.nom_film, societe_redressement.redressement, societe_redressement.liquidation, societe.id_societe, cinema.liv_ville, cinema.liv_dep, cinema.nom_cinema
  • Sort Method: quicksort Memory: 25kB
3. 0.000 0.004 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.41..180.46 rows=1 width=199) (actual time=0.004..0.004 rows=0 loops=1)

4. 0.000 0.004 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.12..172.15 rows=1 width=203) (actual time=0.004..0.004 rows=0 loops=1)

5. 0.000 0.004 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.70..170.38 rows=1 width=203) (actual time=0.004..0.004 rows=0 loops=1)

6. 0.000 0.004 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.41..162.07 rows=1 width=189) (actual time=0.004..0.004 rows=0 loops=1)

7. 0.000 0.004 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.13..161.70 rows=1 width=162) (actual time=0.004..0.004 rows=0 loops=1)

8. 0.000 0.004 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.84..153.38 rows=1 width=162) (actual time=0.004..0.004 rows=0 loops=1)

  • Join Filter: (societe.id_societe = societe_redressement.id_societe)
9. 0.000 0.004 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.84..24.27 rows=1 width=160) (actual time=0.004..0.004 rows=0 loops=1)

10. 0.000 0.004 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.56..23.95 rows=1 width=156) (actual time=0.004..0.004 rows=0 loops=1)

11. 0.000 0.004 ↓ 0.0 0 1

Nested Loop (cost=1.13..22.76 rows=1 width=152) (actual time=0.004..0.004 rows=0 loops=1)

12. 0.000 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.86..14.46 rows=1 width=152) (actual time=0.004..0.004 rows=0 loops=1)

13. 0.004 0.004 ↓ 0.0 0 1

Index Scan using idx_bordereau_id_fact on bordereau (cost=0.43..6.01 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (id_fact > 2000000)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using facture_id_fact_date on facture (cost=0.43..8.45 rows=1 width=140) (never executed)

  • Index Cond: (id_fact = bordereau.id_fact)
  • Filter: (id_distri = 42)
15. 0.000 0.000 ↓ 0.0 0

Index Only Scan using distributeur_pkey on distributeur (cost=0.27..8.29 rows=1 width=0) (never executed)

  • Index Cond: (id_societe = 42)
  • Heap Fetches: 0
16. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_edition_fact_id_fact on edition_fact (cost=0.43..1.18 rows=1 width=8) (never executed)

  • Index Cond: (id_fact = facture.id_fact)
17. 0.000 0.000 ↓ 0.0 0

Index Only Scan using societe_pkey on societe (cost=0.28..0.31 rows=1 width=4) (never executed)

  • Index Cond: (id_societe = facture.id_societe)
  • Heap Fetches: 0
18. 0.000 0.000 ↓ 0.0 0

Seq Scan on societe_redressement (cost=0.00..128.46 rows=52 width=6) (never executed)

  • Filter: (id_distri = 42)
19. 0.000 0.000 ↓ 0.0 0

Index Only Scan using idx_salles_screen_id_id_cinema on salles (cost=0.29..8.30 rows=1 width=8) (never executed)

  • Index Cond: (screen_id = bordereau.screen_id)
  • Heap Fetches: 0
20. 0.000 0.000 ↓ 0.0 0

Index Scan using cinema_id_cinema_area on cinema (cost=0.28..0.36 rows=1 width=35) (never executed)

  • Index Cond: (salles.id_cinema = id_cinema)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using films_pkey on films (cost=0.29..8.30 rows=1 width=22) (never executed)

  • Index Cond: (bordereau.id_film = id_film)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using encaissement_id_fact_idx on encaissement (cost=0.43..1.76 rows=1 width=4) (never executed)

  • Index Cond: (id_fact = facture.id_fact)
  • Filter: (id_distri = 42)
23. 0.000 0.000 ↓ 0.0 0

Index Only Scan using avoir_data_id_bordereau on avoir_data (cost=0.29..8.30 rows=1 width=4) (never executed)

  • Index Cond: (id_bordereau = bordereau.id_bordereau)
  • Heap Fetches: 0
Planning time : 2.123 ms
Execution time : 0.113 ms