explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CDKk : Optimization for: current branch; plan #EumO

Settings

Optimization path:

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

Limit (cost=6.82..6.87 rows=20 width=45) (actual time=0.111..0.117 rows=20 loops=1)

2. 0.060 0.112 ↑ 6.2 20 1

Sort (cost=6.82..7.13 rows=123 width=45) (actual time=0.110..0.112 rows=20 loops=1)

  • Sort Key: created_at DESC
  • Sort Method: top-N heapsort Memory: 28kB
3. 0.052 0.052 ↑ 1.0 123 1

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

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