explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AzvO

Settings
# exclusive inclusive rows x rows loops node
1. 0.161 9.765 ↓ 1.0 600 1

Sort (cost=893.08..894.58 rows=599 width=44) (actual time=9.731..9.765 rows=600 loops=1)

  • Sort Key: c.customer_id
  • Sort Method: quicksort Memory: 71kB
2. 1.966 9.604 ↓ 1.0 600 1

HashAggregate (cost=857.96..865.45 rows=599 width=44) (actual time=9.277..9.604 rows=600 loops=1)

  • Group Key: c.customer_id
3. 1.508 7.638 ↑ 1.0 8,632 1

Hash Left Join (cost=239.15..814.79 rows=8,633 width=21) (actual time=2.192..7.638 rows=8,632 loops=1)

  • Hash Cond: (r.customer_id = c.customer_id)
4. 2.650 5.964 ↑ 1.0 8,632 1

Hash Right Join (cost=216.68..673.61 rows=8,633 width=6) (actual time=2.021..5.964 rows=8,632 loops=1)

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

Seq Scan on rental r (cost=0.00..310.44 rows=16,044 width=6) (actual time=0.008..1.307 rows=16,044 loops=1)

6. 0.290 2.007 ↓ 1.0 2,494 1

Hash (cost=185.86..185.86 rows=2,465 width=8) (actual time=2.007..2.007 rows=2,494 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 130kB
7. 0.704 1.717 ↓ 1.0 2,494 1

Hash Right Join (cost=73.22..185.86 rows=2,465 width=8) (actual time=0.533..1.717 rows=2,494 loops=1)

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

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

9. 0.059 0.522 ↑ 1.0 538 1

Hash (cost=66.50..66.50 rows=538 width=4) (actual time=0.522..0.522 rows=538 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 27kB
10. 0.463 0.463 ↑ 1.0 538 1

Seq Scan on film f (cost=0.00..66.50 rows=538 width=4) (actual time=0.011..0.463 rows=538 loops=1)

  • Filter: (special_features @> '{"Behind the Scenes"}'::text[])
  • Rows Removed by Filter: 462
11. 0.098 0.166 ↑ 1.0 599 1

Hash (cost=14.99..14.99 rows=599 width=17) (actual time=0.165..0.166 rows=599 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 39kB
12. 0.068 0.068 ↑ 1.0 599 1

Seq Scan on customer c (cost=0.00..14.99 rows=599 width=17) (actual time=0.006..0.068 rows=599 loops=1)

Planning time : 0.427 ms
Execution time : 9.851 ms