#	rows x	node
1.	↓ 0.0	→ HashAggregate (cost=167.15..169.65 rows=200 width=236) (actual time=.. rows= loops=)
2.	↓ 0.0	→ Append (cost=101.48..164.08 rows=246 width=236) (actual time=.. rows= loops=)
3.	↓ 0.0	→ Subquery Scan on v_salaires_a_payer (cost=101.48..106.68 rows=231 width=236) (actual time=.. rows= loops=)
4.	↓ 0.0	→ HashAggregate (cost=101.48..104.37 rows=231 width=215) (actual time=.. rows= loops=)
5.	↓ 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.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.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.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.0	→ Hash (cost=29.02..29.02 rows=1402 width=15) (actual time=.. rows= loops=)
10.	↓ 0.0	→ Seq Scan on t_salaire_joueur sj (cost=0.00..29.02 rows=1402 width=15) (actual time=.. rows= loops=)
11.	↓ 0.0	→ Hash (cost=1.11..1.11 rows=11 width=200) (actual time=.. rows= loops=)
12.	↓ 0.0	→ Seq Scan on t_proprio p (cost=0.00..1.11 rows=11 width=200) (actual time=.. rows= loops=)
13.	↓ 0.0	→ Hash (cost=1.21..1.21 rows=21 width=8) (actual time=.. rows= loops=)
14.	↓ 0.0	→ Seq Scan on t_saison s (cost=0.00..1.21 rows=21 width=8) (actual time=.. rows= loops=)
15.	↓ 0.0	→ Subquery Scan on v_rpt_bonus_saison (cost=5.58..5.63 rows=2 width=236) (actual time=.. rows= loops=)
16.	↓ 0.0	→ HashAggregate (cost=5.58..5.61 rows=2 width=218) (actual time=.. rows= loops=)
17.	↓ 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.0	→ Seq Scan on t_saison s (cost=0.00..1.21 rows=21 width=8) (actual time=.. rows= loops=)
19.	↓ 0.0	→ Hash (cost=4.20..4.20 rows=4 width=218) (actual time=.. rows= loops=)
20.	↓ 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.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.0	→ Seq Scan on t_bonus_alloue ba (cost=0.00..1.34 rows=34 width=26) (actual time=.. rows= loops=)
23.	↓ 0.0	→ Hash (cost=1.11..1.11 rows=11 width=200) (actual time=.. rows= loops=)
24.	↓ 0.0	→ Seq Scan on t_proprio p (cost=0.00..1.11 rows=11 width=200) (actual time=.. rows= loops=)
25.	↓ 0.0	→ Hash (cost=1.13..1.13 rows=13 width=4) (actual time=.. rows= loops=)
26.	↓ 0.0	→ Seq Scan on t_bonus b (cost=0.00..1.13 rows=13 width=4) (actual time=.. rows= loops=)
27.	↓ 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.0	→ Seq Scan on t_saison s (cost=0.00..1.21 rows=21 width=8) (actual time=.. rows= loops=)
29.	↓ 0.0	→ Hash (cost=2.96..2.96 rows=11 width=218) (actual time=.. rows= loops=)
30.	↓ 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.0	→ Seq Scan on t_plafond_salarial ps (cost=0.00..1.44 rows=44 width=22) (actual time=.. rows= loops=)
32.	↓ 0.0	→ Hash (cost=1.11..1.11 rows=11 width=200) (actual time=.. rows= loops=)
33.	↓ 0.0	→ Seq Scan on t_proprio p (cost=0.00..1.11 rows=11 width=200) (actual time=.. rows= loops=)
34.	↓ 0.0	→ Subquery Scan on "SELECT 1" (cost=23.55..23.64 rows=4 width=236) (actual time=.. rows= loops=)
35.	↓ 0.0	→ HashAggregate (cost=23.55..23.60 rows=4 width=218) (actual time=.. rows= loops=)
36.	↓ 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.0	→ Seq Scan on t_saison sa (cost=0.00..1.21 rows=21 width=12) (actual time=.. rows= loops=)
38.	↓ 0.0	→ Materialize (cost=2.50..21.56 rows=2 width=218) (actual time=.. rows= loops=)
39.	↓ 0.0	→ Nested Loop (cost=2.50..21.55 rows=2 width=218) (actual time=.. rows= loops=)
40.	↓ 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.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.0	→ Seq Scan on t_echange_argent ec (cost=0.00..15.80 rows=580 width=26) (actual time=.. rows= loops=)
43.	↓ 0.0	→ Hash (cost=1.11..1.11 rows=11 width=4) (actual time=.. rows= loops=)
44.	↓ 0.0	→ Seq Scan on t_proprio p1 (cost=0.00..1.11 rows=11 width=4) (actual time=.. rows= loops=)
45.	↓ 0.0	→ Hash (cost=1.11..1.11 rows=11 width=200) (actual time=.. rows= loops=)
46.	↓ 0.0	→ Seq Scan on t_proprio p2 (cost=0.00..1.11 rows=11 width=200) (actual time=.. rows= loops=)
47.	↓ 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.0	→ Subquery Scan on "SELECT 2" (cost=23.55..23.65 rows=4 width=236) (actual time=.. rows= loops=)
49.	↓ 0.0	→ HashAggregate (cost=23.55..23.61 rows=4 width=218) (actual time=.. rows= loops=)
50.	↓ 0.0	→ Nested Loop (cost=2.50..23.50 rows=4 width=218) (actual time=.. rows= loops=)

HashAggregate  (cost=167.15..169.65 rows=200 width=236)
  ->  Append  (cost=101.48..164.08 rows=246 width=236)
        ->  Subquery Scan on v_salaires_a_payer  (cost=101.48..106.68 rows=231 width=236)
              ->  HashAggregate  (cost=101.48..104.37 rows=231 width=215)
                    ->  Hash Join  (cost=52.77..97.30 rows=279 width=215)
                          Hash Cond: (jg.saison_id = s.saison_id)
                          ->  Hash Join  (cost=51.30..91.99 rows=279 width=215)
                                Hash Cond: (jg.proprio_id = p.proprio_id)
                                ->  Hash Join  (cost=50.05..86.91 rows=279 width=19)
                                      Hash Cond: ((jg.joueur_id = sj.joueur_id) AND (jg.saison_id = sj.saison_id))
                                      ->  Seq Scan on t_joueur_garde jg  (cost=0.00..22.59 rows=510 width=12)
                                            Filter: joueur_garde
                                      ->  Hash  (cost=29.02..29.02 rows=1402 width=15)
                                            ->  Seq Scan on t_salaire_joueur sj  (cost=0.00..29.02 rows=1402 width=15)
                                ->  Hash  (cost=1.11..1.11 rows=11 width=200)
                                      ->  Seq Scan on t_proprio p  (cost=0.00..1.11 rows=11 width=200)
                          ->  Hash  (cost=1.21..1.21 rows=21 width=8)
                                ->  Seq Scan on t_saison s  (cost=0.00..1.21 rows=21 width=8)
        ->  Subquery Scan on v_rpt_bonus_saison  (cost=5.58..5.63 rows=2 width=236)
              ->  HashAggregate  (cost=5.58..5.61 rows=2 width=218)
                    ->  Hash Join  (cost=4.25..5.56 rows=2 width=218)
                          Hash Cond: (s.saison_id = ba.saison_id)
                          ->  Seq Scan on t_saison s  (cost=0.00..1.21 rows=21 width=8)
                          ->  Hash  (cost=4.20..4.20 rows=4 width=218)
                                ->  Hash Join  (cost=2.54..4.20 rows=4 width=218)
                                      Hash Cond: (ba.bonus_id = b.bonus_id)
                                      ->  Hash Join  (cost=1.25..2.83 rows=11 width=222)
                                            Hash Cond: (ba.proprio_id = p.proprio_id)
                                            ->  Seq Scan on t_bonus_alloue ba  (cost=0.00..1.34 rows=34 width=26)
                                            ->  Hash  (cost=1.11..1.11 rows=11 width=200)
                                                  ->  Seq Scan on t_proprio p  (cost=0.00..1.11 rows=11 width=200)
                                      ->  Hash  (cost=1.13..1.13 rows=13 width=4)
                                            ->  Seq Scan on t_bonus b  (cost=0.00..1.13 rows=13 width=4)
        ->  Hash Join  (cost=3.10..4.44 rows=5 width=218)
              Hash Cond: (s.saison_id = ps.saison_id)
              ->  Seq Scan on t_saison s  (cost=0.00..1.21 rows=21 width=8)
              ->  Hash  (cost=2.96..2.96 rows=11 width=218)
                    ->  Hash Join  (cost=1.25..2.96 rows=11 width=218)
                          Hash Cond: (ps.proprio_id = p.proprio_id)
                          ->  Seq Scan on t_plafond_salarial ps  (cost=0.00..1.44 rows=44 width=22)
                          ->  Hash  (cost=1.11..1.11 rows=11 width=200)
                                ->  Seq Scan on t_proprio p  (cost=0.00..1.11 rows=11 width=200)
        ->  Subquery Scan on "*SELECT* 1"  (cost=23.55..23.64 rows=4 width=236)
              ->  HashAggregate  (cost=23.55..23.60 rows=4 width=218)
                    ->  Nested Loop  (cost=2.50..23.50 rows=4 width=218)
                          Join Filter: ((trans.date_transaction >= sa.date_debut) AND (trans.date_transaction <= sa.date_fin))
                          ->  Seq Scan on t_saison sa  (cost=0.00..1.21 rows=21 width=12)
                          ->  Materialize  (cost=2.50..21.56 rows=2 width=218)
                                ->  Nested Loop  (cost=2.50..21.55 rows=2 width=218)
                                      ->  Hash Join  (cost=2.50..20.93 rows=2 width=218)
                                            Hash Cond: (ec.proprio_id_recoit = p2.proprio_id)
                                            ->  Hash Join  (cost=1.25..19.54 rows=32 width=22)
                                                  Hash Cond: (ec.proprio_id_donne = p1.proprio_id)
                                                  ->  Seq Scan on t_echange_argent ec  (cost=0.00..15.80 rows=580 width=26)
                                                  ->  Hash  (cost=1.11..1.11 rows=11 width=4)
                                                        ->  Seq Scan on t_proprio p1  (cost=0.00..1.11 rows=11 width=4)
                                            ->  Hash  (cost=1.11..1.11 rows=11 width=200)
                                                  ->  Seq Scan on t_proprio p2  (cost=0.00..1.11 rows=11 width=200)
                                      ->  Index Scan using pk_transaction_transaction_id on t_transaction trans  (cost=0.00..0.30 rows=1 width=8)
                                            Index Cond: (trans.transaction_id = ec.transaction_id)
        ->  Subquery Scan on "*SELECT* 2"  (cost=23.55..23.65 rows=4 width=236)
              ->  HashAggregate  (cost=23.55..23.61 rows=4 width=218)
                    ->  Nested Loop  (cost=2.50..23.50 rows=4 width=218)

Per node type stats

node type	count	sum of times	% of query
Append	1	0.000 ms	0.0 %
Hash	10	0.000 ms	0.0 %
Hash Join	10	0.000 ms	0.0 %
HashAggregate	5	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
Materialize	1	0.000 ms	0.0 %
Nested Loop	3	0.000 ms	0.0 %
Seq Scan	15	0.000 ms	0.0 %
Subquery Scan on "SELECT 1"	1	0.000 ms	0.0 %
Subquery Scan on "SELECT 2"	1	0.000 ms	0.0 %
Subquery Scan on v_rpt_bonus_saison	1	0.000 ms	0.0 %
Subquery Scan on v_salaires_a_payer	1	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
t_bonus	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
t_bonus_alloue	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
t_echange_argent	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
t_joueur_garde	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
t_plafond_salarial	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
t_proprio	5	0.000 ms	0.0 %
Seq Scan	5	0.000 ms	0.0 %
t_saison	4	0.000 ms	0.0 %
Seq Scan	4	0.000 ms	0.0 %
t_salaire_joueur	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
t_transaction	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 4OH

Colorize:

Columns visibility:

Per node type stats

Per table stats