explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NEss

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.104 ↑ 1.0 1 1

Nested Loop Left Join (cost=8.75..12.79 rows=1 width=84) (actual time=0.103..0.104 rows=1 loops=1)

2. 0.047 0.047 ↑ 1.0 1 1

Index Only Scan using usr_id_name_freq_idx on usr u (cost=0.41..4.43 rows=1 width=20) (actual time=0.046..0.047 rows=1 loops=1)

  • Index Cond: (id = 76109550)
  • Heap Fetches: 1
3. 0.012 0.054 ↑ 1.0 1 1

Aggregate (cost=8.33..8.34 rows=1 width=64) (actual time=0.053..0.054 rows=1 loops=1)

4. 0.042 0.042 ↓ 4.0 4 1

Index Scan using user_post_user_id_idx on user_post up (cost=0.29..8.32 rows=1 width=25) (actual time=0.037..0.042 rows=4 loops=1)

  • Index Cond: (user_id = u.id)
  • Filter: ((is_deleted = 0) AND (now() >= start_date) AND ((now() <= end_date) OR (is_until_now = 1)))
  • Rows Removed by Filter: 1
Planning time : 0.452 ms
Execution time : 0.216 ms