explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oFdl : Optimization for: Optimization for: plan #B0Wu; plan #4hkY

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.001 0.024 ↑ 1.0 1 1

Limit (cost=27.48..27.48 rows=1 width=16) (actual time=0.024..0.024 rows=1 loops=1)

2. 0.007 0.023 ↑ 31.0 1 1

Sort (cost=27.48..27.56 rows=31 width=16) (actual time=0.023..0.023 rows=1 loops=1)

  • Sort Key: created DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 0.016 0.016 ↑ 1.8 17 1

Index Scan using useractions_useraction_e8701ad4 on useractions_useraction (cost=0.28..27.32 rows=31 width=16) (actual time=0.008..0.016 rows=17 loops=1)

  • Index Cond: (user_id = 13,604,128)
Planning time : 0.173 ms
Execution time : 0.039 ms