#	exclusive	inclusive	rows x	rows	loops	node
1.	53.783	675.646	↓ 3.9	319	1	→ HashAggregate (cost=22702.98..22704.62 rows=82 width=28) (actual time=674.887..675.646 rows=319 loops=1) Total runtime: 676.475 ms
2.						Initplan (forHashAggregate)
3.	0.015	0.015	↑ 1.0	1	1	→ Result (cost=0.00..0.02 rows=1 width=0) (actual time=0.013..0.015 rows=1 loops=1)
4.	82.765	621.848	↓ 3.9	16879	1	→ Hash Left Join (cost=180.62..22649.16 rows=4304 width=28) (actual time=95.330..621.848 rows=16879 loops=1) Hash Cond: (v.appellation_id = a.id)
5.	68.324	537.721	↓ 3.9	16879	1	→ Hash Join (cost=170.44..22536.76 rows=4304 width=16) (actual time=93.925..537.721 rows=16879 loops=1) Hash Cond: (s.contenant_id = c.id)
6.	72.643	469.368	↓ 3.9	16879	1	→ Hash Join (cost=169.37..22476.52 rows=4304 width=16) (actual time=93.871..469.368 rows=16879 loops=1) Hash Cond: (s.vin_id = v.id)
7.	371.925	371.925	↓ 3.9	16879	1	→ Seq Scan on stock s (cost=0.00..22221.06 rows=4304 width=16) (actual time=68.993..371.925 rows=16879 loops=1) Filter: ((annee)::double precision = $0)
8.	12.564	24.800	↑ 1.0	6061	1	→ Hash (cost=93.61..93.61 rows=6061 width=8) (actual time=24.800..24.800 rows=6061 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 190kB
9.	12.236	12.236	↑ 1.0	6061	1	→ Seq Scan on vin v (cost=0.00..93.61 rows=6061 width=8) (actual time=0.015..12.236 rows=6061 loops=1)
10.	0.014	0.029	↑ 1.0	3	1	→ Hash (cost=1.03..1.03 rows=3 width=8) (actual time=0.029..0.029 rows=3 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 1kB
11.	0.015	0.015	↑ 1.0	3	1	→ Seq Scan on contenant c (cost=0.00..1.03 rows=3 width=8) (actual time=0.008..0.015 rows=3 loops=1)
12.	0.703	1.362	↑ 1.0	319	1	→ Hash (cost=6.19..6.19 rows=319 width=20) (actual time=1.362..1.362 rows=319 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 15kB
13.	0.659	0.659	↑ 1.0	319	1	→ Seq Scan on appellation a (cost=0.00..6.19 rows=319 width=20) (actual time=0.011..0.659 rows=319 loops=1)

HashAggregate  (cost=22702.98..22704.62 rows=82 width=28) (actual time=674.887..675.646 rows=319 loops=1)
   InitPlan 1 (returns $0)
     ->  Result  (cost=0.00..0.02 rows=1 width=0) (actual time=0.013..0.015 rows=1 loops=1)
   ->  Hash Left Join  (cost=180.62..22649.16 rows=4304 width=28) (actual time=95.330..621.848 rows=16879 loops=1)
         Hash Cond: (v.appellation_id = a.id)
         ->  Hash Join  (cost=170.44..22536.76 rows=4304 width=16) (actual time=93.925..537.721 rows=16879 loops=1)
               Hash Cond: (s.contenant_id = c.id)
               ->  Hash Join  (cost=169.37..22476.52 rows=4304 width=16) (actual time=93.871..469.368 rows=16879 loops=1)
                     Hash Cond: (s.vin_id = v.id)
                     ->  Seq Scan on stock s  (cost=0.00..22221.06 rows=4304 width=16) (actual time=68.993..371.925 rows=16879 loops=1)
                           Filter: ((annee)::double precision = $0)
                     ->  Hash  (cost=93.61..93.61 rows=6061 width=8) (actual time=24.800..24.800 rows=6061 loops=1)
                           Buckets: 1024  Batches: 1  Memory Usage: 190kB
                           ->  Seq Scan on vin v  (cost=0.00..93.61 rows=6061 width=8) (actual time=0.015..12.236 rows=6061 loops=1)
               ->  Hash  (cost=1.03..1.03 rows=3 width=8) (actual time=0.029..0.029 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.008..0.015 rows=3 loops=1)
         ->  Hash  (cost=6.19..6.19 rows=319 width=20) (actual time=1.362..1.362 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.659 rows=319 loops=1)
 Total runtime: 676.475 ms
(21 lignes)

Per node type stats

node type	count	sum of times	% of query
Hash	3	13.281 ms	2.0 %
Hash Join	2	140.967 ms	20.9 %
Hash Left Join	1	82.765 ms	12.2 %
HashAggregate	1	53.783 ms	8.0 %
Result	1	0.015 ms	0.0 %
Seq Scan	4	384.835 ms	57.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
appellation	1	0.659 ms	0.1 %
Seq Scan	1	0.659 ms	100.0 %
contenant	1	0.015 ms	0.0 %
Seq Scan	1	0.015 ms	100.0 %
stock	1	371.925 ms	55.0 %
Seq Scan	1	371.925 ms	100.0 %
vin	1	12.236 ms	1.8 %
Seq Scan	1	12.236 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: KNcv

Colorize:

Columns visibility:

Per node type stats

Per table stats