explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nkrg

Settings
# exclusive inclusive rows x rows loops node
1. 122.622 851.143 ↑ 1.0 599 1

HashAggregate (cost=726.77..732.76 rows=599 width=10) (actual time=842.419..851.143 rows=599 loops=1)

  • Group Key: r.customer_id
2. 306.842 728.521 ↑ 1.0 8,608 1

Hash Join (cost=226.68..683.61 rows=8,632 width=6) (actual time=217.819..728.521 rows=8,608 loops=1)

  • Hash Cond: (r.inventory_id = i.inventory_id)
3. 203.937 203.937 ↑ 1.0 16,044 1

Seq Scan on rental r (cost=0.00..310.44 rows=16,044 width=10) (actual time=0.021..203.937 rows=16,044 loops=1)

4. 41.130 217.742 ↓ 1.0 2,471 1

Hash (cost=195.86..195.86 rows=2,465 width=4) (actual time=217.733..217.742 rows=2,471 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 119kB
5. 100.737 176.612 ↓ 1.0 2,471 1

Hash Join (cost=83.22..195.86 rows=2,465 width=4) (actual time=15.684..176.612 rows=2,471 loops=1)

  • Hash Cond: (i.film_id = f.film_id)
6. 60.260 60.260 ↑ 1.0 4,581 1

Seq Scan on inventory i (cost=0.00..70.81 rows=4,581 width=6) (actual time=0.029..60.260 rows=4,581 loops=1)

7. 6.521 15.615 ↑ 1.0 538 1

Hash (cost=76.50..76.50 rows=538 width=4) (actual time=15.607..15.615 rows=538 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 27kB
8. 9.094 9.094 ↑ 1.0 538 1

Seq Scan on film f (cost=0.00..76.50 rows=538 width=4) (actual time=0.023..9.094 rows=538 loops=1)

  • Filter: ('Behind the Scenes'::text = ANY (special_features))
  • Rows Removed by Filter: 462
Planning time : 0.511 ms
Execution time : 857.725 ms