explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EumO : current branch

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.005 0.632 ↑ 1.0 20 1

Limit (cost=34.43..34.48 rows=20 width=45) (actual time=0.625..0.632 rows=20 loops=1)

2. 0.107 0.627 ↑ 1.1 20 1

Sort (cost=34.43..34.49 rows=23 width=45) (actual time=0.624..0.627 rows=20 loops=1)

  • Sort Key: my_list_items.created_at DESC
  • Sort Method: top-N heapsort Memory: 28kB
3. 0.140 0.520 ↓ 5.3 123 1

Hash Join (cost=5.09..33.91 rows=23 width=45) (actual time=0.158..0.520 rows=123 loops=1)

  • Hash Cond: (films.id = my_list_items.listable_id)
4. 0.275 0.275 ↑ 1.0 181 1

Seq Scan on films (cost=0.00..27.67 rows=184 width=8) (actual time=0.012..0.275 rows=181 loops=1)

  • Filter: published
  • Rows Removed by Filter: 738
5. 0.055 0.105 ↑ 1.0 123 1

Hash (cost=3.55..3.55 rows=123 width=45) (actual time=0.105..0.105 rows=123 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 18kB
6. 0.050 0.050 ↑ 1.0 123 1

Seq Scan on my_list_items (cost=0.00..3.55 rows=123 width=45) (actual time=0.014..0.050 rows=123 loops=1)

  • Filter: (user_id = 56)
  • Rows Removed by Filter: 1
Planning time : 1.246 ms
Execution time : 0.747 ms