explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qlfi

Settings
# exclusive inclusive rows x rows loops node
1. 30.073 753.144 ↓ 1.0 40,092 1

Hash Left Join (cost=2,841.96..4,415.61 rows=40,036 width=1,533) (actual time=376.509..753.144 rows=40,092 loops=1)

  • Hash Cond: (lcsap.lcs_echeance = echeance_paiement.ech_cle)
2. 39.251 723.062 ↓ 1.0 40,092 1

Hash Join (cost=2,836.24..4,302.66 rows=40,036 width=1,285) (actual time=376.467..723.062 rows=40,092 loops=1)

  • Hash Cond: (transporteur.tra_chargeur = transport_chargeur.trc_cle)
3. 45.702 683.552 ↓ 1.0 40,092 1

Hash Join (cost=2,833.13..4,185.37 rows=40,036 width=1,224) (actual time=376.195..683.552 rows=40,092 loops=1)

  • Hash Cond: (commande.com_transporteur = transporteur.tra_code)
4. 37.420 637.448 ↓ 1.0 40,092 1

Hash Join (cost=2,827.89..4,070.76 rows=40,036 width=1,172) (actual time=375.774..637.448 rows=40,092 loops=1)

  • Hash Cond: (lcolis_lcsap.rlc_lcs_com_cle = commande_cplt.com_cle)
5. 43.366 593.601 ↓ 1.0 40,092 1

Hash Join (cost=2,718.98..3,856.60 rows=40,036 width=919) (actual time=369.331..593.601 rows=40,092 loops=1)

  • Hash Cond: (lcolis_lcsap.rlc_lcs_com_cle = commande.com_cle)
6. 150.213 532.852 ↓ 1.0 40,092 1

Hash Join (cost=2,475.72..3,508.10 rows=40,036 width=524) (actual time=351.926..532.852 rows=40,092 loops=1)

  • Hash Cond: ((lcolis_lcsap.rlc_lcs_com_cle = lcsap.lcs_com_cle) AND (lcolis_lcsap.rlc_lcs_num = lcsap.lcs_num))
7. 31.204 31.204 ↑ 1.0 40,092 1

Seq Scan on lcolis_lcsap (cost=0.00..438.96 rows=40,136 width=29) (actual time=0.046..31.204 rows=40,092 loops=1)

8. 172.034 351.435 ↓ 1.0 50,845 1

Hash (cost=1,385.46..1,385.46 rows=50,837 width=499) (actual time=351.434..351.435 rows=50,845 loops=1)

  • Buckets: 8192 Batches: 8 Memory Usage: 3450kB
9. 179.401 179.401 ↓ 1.0 50,845 1

Seq Scan on lcsap (cost=0.00..1,385.46 rows=50,837 width=499) (actual time=0.036..179.401 rows=50,845 loops=1)

  • Filter: (lcs_etat = 3)
10. 3.389 17.383 ↓ 1.0 3,060 1

Hash (cost=205.06..205.06 rows=3,056 width=395) (actual time=17.383..17.383 rows=3,060 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 1323kB
11. 13.994 13.994 ↓ 1.0 3,060 1

Seq Scan on commande (cost=0.00..205.06 rows=3,056 width=395) (actual time=0.016..13.994 rows=3,060 loops=1)

12. 1.549 6.427 ↓ 1.0 3,060 1

Hash (cost=70.74..70.74 rows=3,054 width=265) (actual time=6.427..6.427 rows=3,060 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 929kB
13. 4.878 4.878 ↓ 1.0 3,060 1

Seq Scan on commande_cplt (cost=0.00..70.74 rows=3,054 width=265) (actual time=0.030..4.878 rows=3,060 loops=1)

14. 0.058 0.402 ↑ 1.0 104 1

Hash (cost=3.94..3.94 rows=104 width=73) (actual time=0.401..0.402 rows=104 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
15. 0.344 0.344 ↑ 1.0 104 1

Seq Scan on transporteur (cost=0.00..3.94 rows=104 width=73) (actual time=0.008..0.344 rows=104 loops=1)

16. 0.030 0.259 ↑ 1.0 49 1

Hash (cost=2.49..2.49 rows=49 width=72) (actual time=0.259..0.259 rows=49 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
17. 0.229 0.229 ↑ 1.0 49 1

Seq Scan on transport_chargeur (cost=0.00..2.49 rows=49 width=72) (actual time=0.015..0.229 rows=49 loops=1)

18. 0.000 0.009 ↓ 0.0 0 1

Hash (cost=3.10..3.10 rows=210 width=264) (actual time=0.009..0.009 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
19. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on echeance_paiement (cost=0.00..3.10 rows=210 width=264) (actual time=0.008..0.009 rows=0 loops=1)