explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5yu8

Settings
# exclusive inclusive rows x rows loops node
1. 0.102 0.190 ↓ 2.3 51 1

Sort (cost=43.16..43.17 rows=22 width=890) (actual time=0.187..0.190 rows=51 loops=1)

  • Sort Key: matches.created_at DESC
  • Sort Method: quicksort Memory: 76kB
2. 0.013 0.088 ↓ 2.3 51 1

Nested Loop Left Join (cost=0.20..43.06 rows=22 width=890) (actual time=0.043..0.088 rows=51 loops=1)

3. 0.002 0.031 ↑ 1.0 1 1

Limit (cost=0.11..4.12 rows=1 width=838) (actual time=0.030..0.031 rows=1 loops=1)

4. 0.029 0.029 ↑ 1.0 1 1

Index Scan using users_combined_index_crush_query on users "user" (cost=0.11..4.12 rows=1 width=838) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: ((sender_id)::text = '2438456456201488'::text)
5. 0.044 0.044 ↓ 2.3 51 1

Index Scan using matches_user_id on matches (cost=0.08..38.87 rows=22 width=52) (actual time=0.011..0.044 rows=51 loops=1)

  • Index Cond: ("user".id = user_id)
  • Filter: visible
Planning time : 0.397 ms
Execution time : 0.266 ms