explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7WZK

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 455.400 ↑ 1.0 1 1

Limit (cost=6.63..6.64 rows=1 width=1,195) (actual time=455.399..455.400 rows=1 loops=1)

2. 0.408 455.395 ↑ 6.0 1 1

Sort (cost=6.63..6.65 rows=6 width=1,195) (actual time=455.395..455.395 rows=1 loops=1)

  • Sort Key: auth_token_id DESC
  • Sort Method: top-N heapsort Memory: 31kB
3. 454.987 454.987 ↓ 17.5 105 1

Index Scan using user_dialog_index on auth_token (cost=0.43..6.60 rows=6 width=1,195) (actual time=3.357..454.987 rows=105 loops=1)

  • Index Cond: (user_id = 5)
Planning time : 168.797 ms
Execution time : 468.612 ms