explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8x3V

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.031 ↓ 0.0 0 1

Sort (cost=43.16..43.17 rows=22 width=890) (actual time=0.031..0.031 rows=0 loops=1)

  • Sort Key: matches.created_at DESC
  • Sort Method: quicksort Memory: 25kB
2. 0.000 0.025 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.20..43.06 rows=22 width=890) (actual time=0.025..0.025 rows=0 loops=1)

3. 0.001 0.025 ↓ 0.0 0 1

Limit (cost=0.11..4.12 rows=1 width=838) (actual time=0.025..0.025 rows=0 loops=1)

4. 0.024 0.024 ↓ 0.0 0 1

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

  • Index Cond: ((sender_id)::text = '1253607318073152'::text)
5. 0.000 0.000 ↓ 0.0 0

Index Scan using matches_user_id on matches (cost=0.08..38.87 rows=22 width=52) (never executed)

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