explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NvjT

Settings
# exclusive inclusive rows x rows loops node
1. 1.718 2.851 ↑ 1.0 1,000 1

Sort (cost=149.64..152.14 rows=1,000 width=87) (actual time=2.802..2.851 rows=1,000 loops=1)

  • Sort Key: f.title
  • Sort Method: quicksort Memory: 103kB
2. 0.229 1.133 ↑ 1.0 1,000 1

Hash Join (cost=77.86..99.81 rows=1,000 width=87) (actual time=0.551..1.133 rows=1,000 loops=1)

  • Hash Cond: (fc.category_id = c.category_id)
3. 0.271 0.879 ↑ 1.0 1,000 1

Hash Join (cost=76.50..95.14 rows=1,000 width=21) (actual time=0.507..0.879 rows=1,000 loops=1)

  • Hash Cond: (fc.film_id = f.film_id)
4. 0.111 0.111 ↑ 1.0 1,000 1

Seq Scan on film_category fc (cost=0.00..16.00 rows=1,000 width=4) (actual time=0.003..0.111 rows=1,000 loops=1)

5. 0.241 0.497 ↑ 1.0 1,000 1

Hash (cost=64.00..64.00 rows=1,000 width=19) (actual time=0.497..0.497 rows=1,000 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 59kB
6. 0.256 0.256 ↑ 1.0 1,000 1

Seq Scan on film f (cost=0.00..64.00 rows=1,000 width=19) (actual time=0.004..0.256 rows=1,000 loops=1)

7. 0.009 0.025 ↑ 1.0 16 1

Hash (cost=1.16..1.16 rows=16 width=72) (actual time=0.025..0.025 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.016 0.016 ↑ 1.0 16 1

Seq Scan on category c (cost=0.00..1.16 rows=16 width=72) (actual time=0.013..0.016 rows=16 loops=1)

Planning time : 0.928 ms
Execution time : 2.940 ms