explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UideP

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.003 ↓ 0.0 0 1

Nested Loop (cost=0.71..16.50 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

2. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using entries_time_asc_id_asc_idx on entries (cost=0.43..6.20 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (created_at < '2019-08-13 12:13:07.247433+00'::timestamp with time zone)
  • Heap Fetches: 0
3. 0.000 0.000 ↓ 0.0 0

Index Scan using events_pkey on events (cost=0.28..8.30 rows=1 width=8) (never executed)

  • Index Cond: (entry_id = entries.entry_id)
  • Filter: ((severity = 'Error'::text) OR ((severity = 'Warning'::text) AND (NOT resolved)))
Planning time : 0.235 ms