explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Yo10

Settings
# exclusive inclusive rows x rows loops node
1. 0.120 8.524 ↑ 1.0 599 1

Sort (cost=492.17..493.67 rows=599 width=44) (actual time=8.500..8.524 rows=599 loops=1)

  • Sort Key: c.customer_id
  • Sort Method: quicksort Memory: 71kB
2. 2.915 8.404 ↑ 1.0 599 1

HashAggregate (cost=455.55..464.54 rows=599 width=44) (actual time=8.274..8.404 rows=599 loops=1)

  • Group Key: c.customer_id
3. 4.210 5.489 ↑ 1.0 16,044 1

Hash Join (cost=22.48..375.33 rows=16,044 width=17) (actual time=0.162..5.489 rows=16,044 loops=1)

  • Hash Cond: (r.customer_id = c.customer_id)
4. 1.126 1.126 ↑ 1.0 16,044 1

Seq Scan on rental r (cost=0.00..310.44 rows=16,044 width=2) (actual time=0.005..1.126 rows=16,044 loops=1)

5. 0.076 0.153 ↑ 1.0 599 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 38kB
6. 0.077 0.077 ↑ 1.0 599 1

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

Planning time : 0.138 ms
Execution time : 8.569 ms