#	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

"Nested Loop  (cost=0.71..16.50 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=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"
"  ->  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"
"Execution time: 0.022 ms"

Per node type stats

node type	count	sum of times	% of query
Index Only Scan	1	0.003 ms	100.0 %
Index Scan	1	0.000 ms	0.0 %
Nested Loop	1	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
entries	1	0.003 ms	100.0 %
Index Only Scan	1	0.003 ms	100.0 %
events	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UideP

Color mode:

Visible columns:

Per node type stats

Per table stats