#	exclusive	inclusive	rows x	rows	loops	node
1.	36.989	147.552	↑ 51.0	319	1	→ HashAggregate (cost=1652.22..1977.60 rows=16269 width=28) (actual time=146.961..147.552 rows=319 loops=1)
2.	25.440	110.563	↓ 1.0	16881	1	→ Hash Join (cost=267.92..1399.98 rows=16816 width=28) (actual time=19.398..110.563 rows=16881 loops=1) Hash Cond: (s.contenant_id = c.id)
3.	29.373	85.107	↓ 1.0	16881	1	→ Hash Join (cost=266.85..1167.69 rows=16816 width=28) (actual time=19.371..85.107 rows=16881 loops=1) Hash Cond: (s.vin_id = v.id)
4.	36.387	36.399	↓ 1.0	16881	1	→ Append (cost=0.00..564.52 rows=16816 width=16) (actual time=0.021..36.399 rows=16881 loops=1) -> Index Scan using stock_annee on stock s (cost=0.00..536.45 rows=16807 width=16) (actual time=0.020..20.750 rows=16881 loops Index Cond: (annee = 1955)
5.	0.003	0.012	↓ 0.0	0	1	→ Bitmap Heap Scan on stock_1950 s (cost=17.53..28.07 rows=9 width=16) (actual time=0.012..0.012 rows=0 loops=1) Recheck Cond: (annee = 1955)
6.	0.009	0.009	↓ 0.0	0	1	→ Bitmap Index Scan on pk_stock_1950 (cost=0.00..17.53 rows=9 width=0) (actual time=0.009..0.009 rows=0 loops=1) Index Cond: (annee = 1955)
7.	5.900	19.335	↑ 1.0	6060	1	→ Hash (cost=191.10..191.10 rows=6060 width=20) (actual time=19.335..19.335 rows=6060 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 251kB
8.	8.976	13.435	↑ 1.0	6060	1	→ Hash Join (cost=10.18..191.10 rows=6060 width=20) (actual time=0.526..13.435 rows=6060 loops=1) Hash Cond: (v.appellation_id = a.id)
9.	3.952	3.952	↑ 1.0	6060	1	→ Seq Scan on vin v (cost=0.00..97.60 rows=6060 width=8) (actual time=0.009..3.952 rows=6060 loops=1)
10.	0.276	0.507	↑ 1.0	319	1	→ Hash (cost=6.19..6.19 rows=319 width=20) (actual time=0.507..0.507 rows=319 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 14kB
11.	0.231	0.231	↑ 1.0	319	1	→ Seq Scan on appellation a (cost=0.00..6.19 rows=319 width=20) (actual time=0.009..0.231 rows=319 loops=1)
12.	0.009	0.016	↑ 1.0	3	1	→ Hash (cost=1.03..1.03 rows=3 width=8) (actual time=0.016..0.016 rows=3 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 1kB
13.	0.007	0.007	↑ 1.0	3	1	→ Seq Scan on contenant c (cost=0.00..1.03 rows=3 width=8) (actual time=0.005..0.007 rows=3 loops=1)

----------------------------------------------------------------------------------------------------------------------------------------------------
----
 HashAggregate  (cost=1652.22..1977.60 rows=16269 width=28) (actual time=146.961..147.552 rows=319 loops=1)
   ->  Hash Join  (cost=267.92..1399.98 rows=16816 width=28) (actual time=19.398..110.563 rows=16881 loops=1)
         Hash Cond: (s.contenant_id = c.id)
         ->  Hash Join  (cost=266.85..1167.69 rows=16816 width=28) (actual time=19.371..85.107 rows=16881 loops=1)
               Hash Cond: (s.vin_id = v.id)
               ->  Append  (cost=0.00..564.52 rows=16816 width=16) (actual time=0.021..36.399 rows=16881 loops=1)
                     ->  Index Scan using stock_annee on stock s  (cost=0.00..536.45 rows=16807 width=16) (actual time=0.020..20.750 rows=16881 loops
=1)
                           Index Cond: (annee = 1955)
                     ->  Bitmap Heap Scan on stock_1950 s  (cost=17.53..28.07 rows=9 width=16) (actual time=0.012..0.012 rows=0 loops=1)
                           Recheck Cond: (annee = 1955)
                           ->  Bitmap Index Scan on pk_stock_1950  (cost=0.00..17.53 rows=9 width=0) (actual time=0.009..0.009 rows=0 loops=1)
                                 Index Cond: (annee = 1955)
               ->  Hash  (cost=191.10..191.10 rows=6060 width=20) (actual time=19.335..19.335 rows=6060 loops=1)
                     Buckets: 1024  Batches: 1  Memory Usage: 251kB
                     ->  Hash Join  (cost=10.18..191.10 rows=6060 width=20) (actual time=0.526..13.435 rows=6060 loops=1)
                           Hash Cond: (v.appellation_id = a.id)
                           ->  Seq Scan on vin v  (cost=0.00..97.60 rows=6060 width=8) (actual time=0.009..3.952 rows=6060 loops=1)
                           ->  Hash  (cost=6.19..6.19 rows=319 width=20) (actual time=0.507..0.507 rows=319 loops=1)
                                 Buckets: 1024  Batches: 1  Memory Usage: 14kB
                                 ->  Seq Scan on appellation a  (cost=0.00..6.19 rows=319 width=20) (actual time=0.009..0.231 rows=319 loops=1)
         ->  Hash  (cost=1.03..1.03 rows=3 width=8) (actual time=0.016..0.016 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.005..0.007 rows=3 loops=1)
 Total runtime: 147.860 ms
(24 lignes)

Per node type stats

node type	count	sum of times	% of query
Append	1	36.387 ms	24.7 %
Bitmap Heap Scan	1	0.003 ms	0.0 %
Bitmap Index Scan	1	0.009 ms	0.0 %
Hash	3	6.185 ms	4.2 %
Hash Join	3	63.789 ms	43.2 %
HashAggregate	1	36.989 ms	25.1 %
Seq Scan	3	4.190 ms	2.8 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
appellation	1	0.231 ms	0.2 %
Seq Scan	1	0.231 ms	100.0 %
contenant	1	0.007 ms	0.0 %
Seq Scan	1	0.007 ms	100.0 %
stock_1950	1	0.003 ms	0.0 %
Bitmap Heap Scan	1	0.003 ms	100.0 %
vin	1	3.952 ms	2.7 %
Seq Scan	1	3.952 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: v8hN

Colorize:

Columns visibility:

Per node type stats

Per table stats