explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uWs1

Settings
# exclusive inclusive rows x rows loops node
1. 28.698 2,494.230 ↑ 1.9 76,234 1

Group (cost=335,329.58..338,953.20 rows=144,945 width=199) (actual time=2,447.276..2,494.230 rows=76,234 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. 92.163 2,465.532 ↑ 1.4 105,564 1

Sort (cost=335,329.58..335,691.94 rows=144,945 width=199) (actual time=2,447.274..2,465.532 rows=105,564 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: external merge Disk: 13,808kB
3. 21.589 2,373.369 ↑ 1.4 105,564 1

Hash Left Join (cost=243,233.09..309,030.06 rows=144,945 width=199) (actual time=1,851.200..2,373.369 rows=105,564 loops=1)

  • Hash Cond: (facture.id_fact = avoir.id_fact)
4. 20.124 2,338.400 ↑ 1.1 104,817 1

Hash Left Join (cost=241,368.19..305,272.12 rows=115,476 width=199) (actual time=1,837.719..2,338.400 rows=104,817 loops=1)

  • Hash Cond: (bordereau.id_film = films.id_film)
5. 303.577 2,315.082 ↑ 1.1 104,817 1

Hash Right Join (cost=240,621.26..302,938.93 rows=115,476 width=185) (actual time=1,834.464..2,315.082 rows=104,817 loops=1)

  • Hash Cond: (encaissement.id_fact = facture.id_fact)
6. 177.747 177.747 ↑ 1.0 1,744,648 1

Seq Scan on encaissement (cost=0.00..38,011.48 rows=1,744,648 width=4) (actual time=0.019..177.747 rows=1,744,648 loops=1)

7. 38.688 1,833.758 ↑ 1.1 103,852 1

Hash (cost=236,132.81..236,132.81 rows=115,476 width=185) (actual time=1,833.758..1,833.758 rows=103,852 loops=1)

  • Buckets: 32,768 Batches: 8 Memory Usage: 2,069kB
8. 11.633 1,795.070 ↑ 1.1 103,852 1

Nested Loop (cost=77,637.63..236,132.81 rows=115,476 width=185) (actual time=506.324..1,795.070 rows=103,852 loops=1)

9. 0.012 0.012 ↑ 1.0 1 1

Index Only Scan using distributeur_pkey on distributeur (cost=0.27..8.29 rows=1 width=0) (actual time=0.009..0.012 rows=1 loops=1)

  • Index Cond: (id_societe = 42)
  • Heap Fetches: 1
10. 25.161 1,783.425 ↑ 1.1 103,852 1

Hash Left Join (cost=77,637.36..234,969.76 rows=115,476 width=185) (actual time=506.315..1,783.425 rows=103,852 loops=1)

  • Hash Cond: (facture.id_societe = societe.id_societe)
11. 31.979 1,755.998 ↑ 1.1 103,852 1

Hash Left Join (cost=77,218.64..232,967.10 rows=115,476 width=179) (actual time=504.014..1,755.998 rows=103,852 loops=1)

  • Hash Cond: (bordereau.screen_id = salles.screen_id)
12. 481.939 1,714.624 ↑ 1.1 103,852 1

Hash Join (cost=76,064.16..230,265.08 rows=115,476 width=152) (actual time=494.603..1,714.624 rows=103,852 loops=1)

  • Hash Cond: (bordereau.id_fact = facture.id_fact)
13. 738.306 738.306 ↑ 1.0 2,764,877 1

Seq Scan on bordereau (cost=0.00..114,102.77 rows=2,766,977 width=12) (actual time=0.009..738.306 rows=2,764,877 loops=1)

14. 18.965 494.379 ↑ 1.0 76,239 1

Hash (cost=73,513.27..73,513.27 rows=77,271 width=144) (actual time=494.379..494.379 rows=76,239 loops=1)

  • Buckets: 32,768 Batches: 4 Memory Usage: 2,181kB
15. 275.839 475.414 ↑ 1.0 76,239 1

Hash Right Join (cost=27,834.05..73,513.27 rows=77,271 width=144) (actual time=49.707..475.414 rows=76,239 loops=1)

  • Hash Cond: (edition_fact.id_fact = facture.id_fact)
16. 150.674 150.674 ↑ 1.0 1,555,354 1

Seq Scan on edition_fact (cost=0.00..25,460.54 rows=1,555,354 width=8) (actual time=0.011..150.674 rows=1,555,354 loops=1)

17. 10.993 48.901 ↑ 1.0 76,239 1

Hash (cost=25,283.17..25,283.17 rows=77,271 width=140) (actual time=48.901..48.901 rows=76,239 loops=1)

  • Buckets: 32,768 Batches: 4 Memory Usage: 2,116kB
18. 33.333 37.908 ↑ 1.0 76,239 1

Bitmap Heap Scan on facture (cost=1,447.28..25,283.17 rows=77,271 width=140) (actual time=6.128..37.908 rows=76,239 loops=1)

  • Recheck Cond: (id_distri = 42)
  • Heap Blocks: exact=13,266
19. 4.575 4.575 ↑ 1.0 76,239 1

Bitmap Index Scan on idx_facture_id_distri (cost=0.00..1,427.96 rows=77,271 width=0) (actual time=4.575..4.575 rows=76,239 loops=1)

  • Index Cond: (id_distri = 42)
20. 2.383 9.395 ↑ 1.0 16,876 1

Hash (cost=943.53..943.53 rows=16,876 width=35) (actual time=9.395..9.395 rows=16,876 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,373kB
21. 3.245 7.012 ↑ 1.0 16,876 1

Hash Left Join (cost=393.73..943.53 rows=16,876 width=35) (actual time=2.756..7.012 rows=16,876 loops=1)

  • Hash Cond: (salles.id_cinema = cinema.id_cinema)
22. 1.026 1.026 ↑ 1.0 16,876 1

Seq Scan on salles (cost=0.00..317.76 rows=16,876 width=8) (actual time=0.009..1.026 rows=16,876 loops=1)

23. 1.057 2.741 ↑ 1.0 7,410 1

Hash (cost=301.10..301.10 rows=7,410 width=35) (actual time=2.741..2.741 rows=7,410 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 577kB
24. 1.684 1.684 ↑ 1.0 7,410 1

Seq Scan on cinema (cost=0.00..301.10 rows=7,410 width=35) (actual time=0.003..1.684 rows=7,410 loops=1)

25. 0.445 2.266 ↑ 1.0 4,804 1

Hash (cost=358.17..358.17 rows=4,844 width=6) (actual time=2.266..2.266 rows=4,804 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 233kB
26. 0.392 1.821 ↑ 1.0 4,804 1

Hash Right Join (cost=228.99..358.17 rows=4,844 width=6) (actual time=0.974..1.821 rows=4,804 loops=1)

  • Hash Cond: (societe_redressement.id_societe = societe.id_societe)
27. 0.489 0.489 ↑ 1.0 52 1

Seq Scan on societe_redressement (cost=0.00..128.46 rows=52 width=6) (actual time=0.009..0.489 rows=52 loops=1)

  • Filter: (id_distri = 42)
  • Rows Removed by Filter: 7,105
28. 0.462 0.940 ↑ 1.0 4,804 1

Hash (cost=168.44..168.44 rows=4,844 width=4) (actual time=0.940..0.940 rows=4,804 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 233kB
29. 0.478 0.478 ↑ 1.0 4,804 1

Seq Scan on societe (cost=0.00..168.44 rows=4,844 width=4) (actual time=0.004..0.478 rows=4,804 loops=1)

30. 1.693 3.194 ↑ 1.0 13,197 1

Hash (cost=581.97..581.97 rows=13,197 width=22) (actual time=3.194..3.194 rows=13,197 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 846kB
31. 1.501 1.501 ↑ 1.0 13,197 1

Seq Scan on films (cost=0.00..581.97 rows=13,197 width=22) (actual time=0.004..1.501 rows=13,197 loops=1)

32. 2.645 13.380 ↓ 1.0 26,562 1

Hash (cost=1,532.90..1,532.90 rows=26,560 width=4) (actual time=13.380..13.380 rows=26,562 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,190kB
33. 4.942 10.735 ↓ 1.0 26,562 1

Hash Right Join (cost=626.10..1,532.90 rows=26,560 width=4) (actual time=4.097..10.735 rows=26,562 loops=1)

  • Hash Cond: (avoir_data.id_avoir = avoir.id_avoir)
34. 1.790 1.790 ↑ 1.0 26,560 1

Seq Scan on avoir_data (cost=0.00..541.60 rows=26,560 width=4) (actual time=0.004..1.790 rows=26,560 loops=1)

35. 2.145 4.003 ↑ 1.0 21,160 1

Hash (cost=361.60..361.60 rows=21,160 width=8) (actual time=4.003..4.003 rows=21,160 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,083kB
36. 1.858 1.858 ↑ 1.0 21,160 1

Seq Scan on avoir (cost=0.00..361.60 rows=21,160 width=8) (actual time=0.005..1.858 rows=21,160 loops=1)

Planning time : 2.161 ms
Execution time : 2,499.616 ms