explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ctO3

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.025 ↑ 1.0 1 1

Limit (cost=8.46..8.46 rows=1 width=60) (actual time=0.023..0.025 rows=1 loops=1)

2. 0.007 0.023 ↑ 1.0 1 1

Sort (cost=8.46..8.46 rows=1 width=60) (actual time=0.022..0.023 rows=1 loops=1)

  • Sort Key: updated_at DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.016 0.016 ↑ 1.0 1 1

Index Scan using weights_unique_deleted_at_null_idx on weights (cost=0.42..8.45 rows=1 width=60) (actual time=0.015..0.016 rows=1 loops=1)

  • Index Cond: ((user_id = 34,067) AND (assigned_date >= '2018-02-02'::date) AND (assigned_date = '2018-02-02'::date))
Planning time : 0.174 ms
Execution time : 0.054 ms