explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sTlS : ix_notification_inbox_user_id_status

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.006 ↑ 1.0 1 1

Aggregate (cost=8.33..8.34 rows=1 width=0) (actual time=0.006..0.006 rows=1 loops=1)

2. 0.004 0.004 ↓ 0.0 0 1

Index Only Scan using ix_notification_inbox_user_id_status on notification_inbox (cost=0.15..8.33 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((user_id = 'a'::text) AND (status = ANY ('{read,unread}'::notification_status[])))
  • Heap Fetches: 0
Planning time : 2.815 ms
Execution time : 0.045 ms