explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 4OH

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

HashAggregate (cost=167.15..169.65 rows=200 width=236) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0

Append (cost=101.48..164.08 rows=246 width=236) (actual time=.. rows= loops=)

3. 0.000 0.000 ↓ 0.0

Subquery Scan on v_salaires_a_payer (cost=101.48..106.68 rows=231 width=236) (actual time=.. rows= loops=)

4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=101.48..104.37 rows=231 width=215) (actual time=.. rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Join (cost=52.77..97.30 rows=279 width=215) (actual time=.. rows= loops=)

  • Hash Cond: (jg.saison_id = s.saison_id)
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=51.30..91.99 rows=279 width=215) (actual time=.. rows= loops=)

  • Hash Cond: (jg.proprio_id = p.proprio_id)
7. 0.000 0.000 ↓ 0.0

Hash Join (cost=50.05..86.91 rows=279 width=19) (actual time=.. rows= loops=)

  • Hash Cond: ((jg.joueur_id = sj.joueur_id) AND (jg.saison_id = sj.saison_id))
8. 0.000 0.000 ↓ 0.0

Seq Scan on t_joueur_garde jg (cost=0.00..22.59 rows=510 width=12) (actual time=.. rows= loops=)

  • Filter: joueur_garde
9. 0.000 0.000 ↓ 0.0

Hash (cost=29.02..29.02 rows=1402 width=15) (actual time=.. rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on t_salaire_joueur sj (cost=0.00..29.02 rows=1402 width=15) (actual time=.. rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=1.11..1.11 rows=11 width=200) (actual time=.. rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on t_proprio p (cost=0.00..1.11 rows=11 width=200) (actual time=.. rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash (cost=1.21..1.21 rows=21 width=8) (actual time=.. rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on t_saison s (cost=0.00..1.21 rows=21 width=8) (actual time=.. rows= loops=)

15. 0.000 0.000 ↓ 0.0

Subquery Scan on v_rpt_bonus_saison (cost=5.58..5.63 rows=2 width=236) (actual time=.. rows= loops=)

16. 0.000 0.000 ↓ 0.0

HashAggregate (cost=5.58..5.61 rows=2 width=218) (actual time=.. rows= loops=)

17. 0.000 0.000 ↓ 0.0

Hash Join (cost=4.25..5.56 rows=2 width=218) (actual time=.. rows= loops=)

  • Hash Cond: (s.saison_id = ba.saison_id)
18. 0.000 0.000 ↓ 0.0

Seq Scan on t_saison s (cost=0.00..1.21 rows=21 width=8) (actual time=.. rows= loops=)

19. 0.000 0.000 ↓ 0.0

Hash (cost=4.20..4.20 rows=4 width=218) (actual time=.. rows= loops=)

20. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.54..4.20 rows=4 width=218) (actual time=.. rows= loops=)

  • Hash Cond: (ba.bonus_id = b.bonus_id)
21. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.25..2.83 rows=11 width=222) (actual time=.. rows= loops=)

  • Hash Cond: (ba.proprio_id = p.proprio_id)
22. 0.000 0.000 ↓ 0.0

Seq Scan on t_bonus_alloue ba (cost=0.00..1.34 rows=34 width=26) (actual time=.. rows= loops=)

23. 0.000 0.000 ↓ 0.0

Hash (cost=1.11..1.11 rows=11 width=200) (actual time=.. rows= loops=)

24. 0.000 0.000 ↓ 0.0

Seq Scan on t_proprio p (cost=0.00..1.11 rows=11 width=200) (actual time=.. rows= loops=)

25. 0.000 0.000 ↓ 0.0

Hash (cost=1.13..1.13 rows=13 width=4) (actual time=.. rows= loops=)

26. 0.000 0.000 ↓ 0.0

Seq Scan on t_bonus b (cost=0.00..1.13 rows=13 width=4) (actual time=.. rows= loops=)

27. 0.000 0.000 ↓ 0.0

Hash Join (cost=3.10..4.44 rows=5 width=218) (actual time=.. rows= loops=)

  • Hash Cond: (s.saison_id = ps.saison_id)
28. 0.000 0.000 ↓ 0.0

Seq Scan on t_saison s (cost=0.00..1.21 rows=21 width=8) (actual time=.. rows= loops=)

29. 0.000 0.000 ↓ 0.0

Hash (cost=2.96..2.96 rows=11 width=218) (actual time=.. rows= loops=)

30. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.25..2.96 rows=11 width=218) (actual time=.. rows= loops=)

  • Hash Cond: (ps.proprio_id = p.proprio_id)
31. 0.000 0.000 ↓ 0.0

Seq Scan on t_plafond_salarial ps (cost=0.00..1.44 rows=44 width=22) (actual time=.. rows= loops=)

32. 0.000 0.000 ↓ 0.0

Hash (cost=1.11..1.11 rows=11 width=200) (actual time=.. rows= loops=)

33. 0.000 0.000 ↓ 0.0

Seq Scan on t_proprio p (cost=0.00..1.11 rows=11 width=200) (actual time=.. rows= loops=)

34. 0.000 0.000 ↓ 0.0

Subquery Scan on "*SELECT* 1" (cost=23.55..23.64 rows=4 width=236) (actual time=.. rows= loops=)

35. 0.000 0.000 ↓ 0.0

HashAggregate (cost=23.55..23.60 rows=4 width=218) (actual time=.. rows= loops=)

36. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.50..23.50 rows=4 width=218) (actual time=.. rows= loops=)

  • Join Filter: ((trans.date_transaction >= sa.date_debut) AND (trans.date_transaction <= sa.date_fin))
37. 0.000 0.000 ↓ 0.0

Seq Scan on t_saison sa (cost=0.00..1.21 rows=21 width=12) (actual time=.. rows= loops=)

38. 0.000 0.000 ↓ 0.0

Materialize (cost=2.50..21.56 rows=2 width=218) (actual time=.. rows= loops=)

39. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.50..21.55 rows=2 width=218) (actual time=.. rows= loops=)

40. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.50..20.93 rows=2 width=218) (actual time=.. rows= loops=)

  • Hash Cond: (ec.proprio_id_recoit = p2.proprio_id)
41. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.25..19.54 rows=32 width=22) (actual time=.. rows= loops=)

  • Hash Cond: (ec.proprio_id_donne = p1.proprio_id)
42. 0.000 0.000 ↓ 0.0

Seq Scan on t_echange_argent ec (cost=0.00..15.80 rows=580 width=26) (actual time=.. rows= loops=)

43. 0.000 0.000 ↓ 0.0

Hash (cost=1.11..1.11 rows=11 width=4) (actual time=.. rows= loops=)

44. 0.000 0.000 ↓ 0.0

Seq Scan on t_proprio p1 (cost=0.00..1.11 rows=11 width=4) (actual time=.. rows= loops=)

45. 0.000 0.000 ↓ 0.0

Hash (cost=1.11..1.11 rows=11 width=200) (actual time=.. rows= loops=)

46. 0.000 0.000 ↓ 0.0

Seq Scan on t_proprio p2 (cost=0.00..1.11 rows=11 width=200) (actual time=.. rows= loops=)

47. 0.000 0.000 ↓ 0.0

Index Scan using pk_transaction_transaction_id on t_transaction trans (cost=0.00..0.30 rows=1 width=8) (actual time=.. rows= loops=)

  • Index Cond: (trans.transaction_id = ec.transaction_id)
48. 0.000 0.000 ↓ 0.0

Subquery Scan on "*SELECT* 2" (cost=23.55..23.65 rows=4 width=236) (actual time=.. rows= loops=)

49. 0.000 0.000 ↓ 0.0

HashAggregate (cost=23.55..23.61 rows=4 width=218) (actual time=.. rows= loops=)

50. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.50..23.50 rows=4 width=218) (actual time=.. rows= loops=)