#	exclusive	inclusive	rows x	rows	loops	node
1.	27.836	50.547	↑ 1.0	16044	1	→ Sort (cost=2345.44..2385.55 rows=16044 width=52) (actual time=43.825..50.547 rows=16044 loops=1) Sort Key: r.inventory_id, r.rental_date Sort Method: external merge Disk: 1096kB
2.	13.471	22.711	↑ 1.0	16044	1	→ Hash Join (cost=128.07..703.28 rows=16044 width=52) (actual time=4.345..22.711 rows=16044 loops=1) Hash Cond: (r.inventory_id = i.inventory_id)
3.	4.913	4.913	↑ 1.0	16044	1	→ Seq Scan on rental r (cost=0.00..294.44 rows=16044 width=36) (actual time=0.008..4.913 rows=16044 loops=1)
4.	2.311	4.327	↑ 1.0	4581	1	→ Hash (cost=70.81..70.81 rows=4581 width=16) (actual time=4.327..4.327 rows=4581 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 162kB
5.	2.016	2.016	↑ 1.0	4581	1	→ Seq Scan on inventory i (cost=0.00..70.81 rows=4581 width=16) (actual time=0.008..2.016 rows=4581 loops=1)

 Sort  (cost=2345.44..2385.55 rows=16044 width=52) (actual time=43.825..50.547 rows=16044 loops=1)
   Sort Key: r.inventory_id, r.rental_date
   Sort Method: external merge  Disk: 1096kB
   ->  Hash Join  (cost=128.07..703.28 rows=16044 width=52) (actual time=4.345..22.711 rows=16044 loops=1)
         Hash Cond: (r.inventory_id = i.inventory_id)
         ->  Seq Scan on rental r  (cost=0.00..294.44 rows=16044 width=36) (actual time=0.008..4.913 rows=16044 loops=1)
         ->  Hash  (cost=70.81..70.81 rows=4581 width=16) (actual time=4.327..4.327 rows=4581 loops=1)
               Buckets: 1024  Batches: 1  Memory Usage: 162kB
               ->  Seq Scan on inventory i  (cost=0.00..70.81 rows=4581 width=16) (actual time=0.008..2.016 rows=4581 loops=1)

Per node type stats

node type	count	sum of times	% of query
Hash	1	2.311 ms	4.6 %
Hash Join	1	13.471 ms	26.7 %
Seq Scan	2	6.929 ms	13.7 %
Sort	1	27.836 ms	55.1 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
inventory	1	2.016 ms	4.0 %
Seq Scan	1	2.016 ms	100.0 %
rental	1	4.913 ms	9.7 %
Seq Scan	1	4.913 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: g7p

Colorize:

Columns visibility:

Per node type stats

Per table stats