explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5c8tx

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 0.113 ↓ 2.3 51 1

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

2. 0.001 0.029 ↑ 1.0 1 1

Limit (cost=0.11..4.12 rows=1 width=838) (actual time=0.028..0.029 rows=1 loops=1)

3. 0.028 0.028 ↑ 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.028..0.028 rows=1 loops=1)

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

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

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