explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3Wjp

Settings
# exclusive inclusive rows x rows loops node
1. 0.026 0.071 ↓ 2.5 51 1

Sort (cost=35.65..35.66 rows=20 width=52) (actual time=0.068..0.071 rows=51 loops=1)

  • Sort Key: created_at DESC
  • Sort Method: quicksort Memory: 32kB
2. 0.045 0.045 ↓ 2.5 51 1

Index Scan using matches_user_id on matches (cost=0.08..35.56 rows=20 width=52) (actual time=0.013..0.045 rows=51 loops=1)

  • Index Cond: (user_id = 3106338)
Planning time : 0.133 ms
Execution time : 0.092 ms