#	exclusive	inclusive	rows x	rows	loops	node
1.	61.498	340.086	↑ 1.0	319	1	→ HashAggregate (cost=1768.21..1774.61 rows=320 width=28) (actual time=339.314..340.086 rows=319 loops=1)
2.						Initplan (forHashAggregate)
3.	0.012	0.012	↑ 1.0	1	1	→ Result (cost=0.00..0.02 rows=1 width=0) (actual time=0.010..0.012 rows=1 loops=1)
4.	86.387	278.576	↑ 1.0	16837	1	→ Hash Join (cost=263.96..1557.19 rows=16880 width=28) (actual time=52.897..278.576 rows=16837 loops=1) Hash Cond: (s.contenant_id = c.id)
5.	82.687	192.159	↑ 1.0	16837	1	→ Hash Join (cost=262.89..1155.22 rows=16880 width=28) (actual time=52.827..192.159 rows=16837 loops=1) Hash Cond: (s.vin_id = v.id)
6.	56.867	56.867	↑ 1.0	16837	1	→ Index Scan using stock_annee on stock s (cost=0.00..554.74 rows=16880 width=16) (actual time=0.187..56.867 rows=16837 loops=1) Index Cond: (annee = ($0)::integer)
7.	13.175	52.605	↑ 1.0	6061	1	→ Hash (cost=187.13..187.13 rows=6061 width=20) (actual time=52.605..52.605 rows=6061 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 265kB
8.	25.936	39.430	↑ 1.0	6061	1	→ Hash Left Join (cost=10.18..187.13 rows=6061 width=20) (actual time=1.419..39.430 rows=6061 loops=1) Hash Cond: (v.appellation_id = a.id)
9.	12.104	12.104	↑ 1.0	6061	1	→ Seq Scan on vin v (cost=0.00..93.61 rows=6061 width=8) (actual time=0.009..12.104 rows=6061 loops=1)
10.	0.716	1.390	↑ 1.0	319	1	→ Hash (cost=6.19..6.19 rows=319 width=20) (actual time=1.390..1.390 rows=319 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 15kB
11.	0.674	0.674	↑ 1.0	319	1	→ Seq Scan on appellation a (cost=0.00..6.19 rows=319 width=20) (actual time=0.011..0.674 rows=319 loops=1)
12.	0.016	0.030	↑ 1.0	3	1	→ Hash (cost=1.03..1.03 rows=3 width=8) (actual time=0.030..0.030 rows=3 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 1kB
13.	0.014	0.014	↑ 1.0	3	1	→ Seq Scan on contenant c (cost=0.00..1.03 rows=3 width=8) (actual time=0.007..0.014 rows=3 loops=1)

HashAggregate  (cost=1768.21..1774.61 rows=320 width=28) (actual time=339.314..340.086 rows=319 loops=1)
  InitPlan 1 (returns $0)
    ->  Result  (cost=0.00..0.02 rows=1 width=0) (actual time=0.010..0.012 rows=1 loops=1)
  ->  Hash Join  (cost=263.96..1557.19 rows=16880 width=28) (actual time=52.897..278.576 rows=16837 loops=1)
        Hash Cond: (s.contenant_id = c.id)
        ->  Hash Join  (cost=262.89..1155.22 rows=16880 width=28) (actual time=52.827..192.159 rows=16837 loops=1)
              Hash Cond: (s.vin_id = v.id)
              ->  Index Scan using stock_annee on stock s  (cost=0.00..554.74 rows=16880 width=16) (actual time=0.187..56.867 rows=16837 loops=1)
                    Index Cond: (annee = ($0)::integer)
              ->  Hash  (cost=187.13..187.13 rows=6061 width=20) (actual time=52.605..52.605 rows=6061 loops=1)
                    Buckets: 1024  Batches: 1  Memory Usage: 265kB
                    ->  Hash Left Join  (cost=10.18..187.13 rows=6061 width=20) (actual time=1.419..39.430 rows=6061 loops=1)
                          Hash Cond: (v.appellation_id = a.id)
                          ->  Seq Scan on vin v  (cost=0.00..93.61 rows=6061 width=8) (actual time=0.009..12.104 rows=6061 loops=1)
                          ->  Hash  (cost=6.19..6.19 rows=319 width=20) (actual time=1.390..1.390 rows=319 loops=1)
                                Buckets: 1024  Batches: 1  Memory Usage: 15kB
                                ->  Seq Scan on appellation a  (cost=0.00..6.19 rows=319 width=20) (actual time=0.011..0.674 rows=319 loops=1)
        ->  Hash  (cost=1.03..1.03 rows=3 width=8) (actual time=0.030..0.030 rows=3 loops=1)
              Buckets: 1024  Batches: 1  Memory Usage: 1kB
              ->  Seq Scan on contenant c  (cost=0.00..1.03 rows=3 width=8) (actual time=0.007..0.014 rows=3 loops=1)
Total runtime: 340.842 ms

Per node type stats

node type	count	sum of times	% of query
Hash	3	13.907 ms	4.1 %
Hash Join	2	169.074 ms	49.7 %
Hash Left Join	1	25.936 ms	7.6 %
HashAggregate	1	61.498 ms	18.1 %
Index Scan	1	56.867 ms	16.7 %
Result	1	0.012 ms	0.0 %
Seq Scan	3	12.792 ms	3.8 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
appellation	1	0.674 ms	0.2 %
Seq Scan	1	0.674 ms	100.0 %
contenant	1	0.014 ms	0.0 %
Seq Scan	1	0.014 ms	100.0 %
stock	1	56.867 ms	16.7 %
Index Scan	1	56.867 ms	100.0 %
vin	1	12.104 ms	3.6 %
Seq Scan	1	12.104 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: m0m

Colorize:

Columns visibility:

Per node type stats

Per table stats