Result: 2TD

options

HTML
TEXT
STATS

exclusive	inclusive	rows x	rows	loops	node
2027.314	366599.754	↑ 1.0	1	1	→ Aggregate (cost=2616036.32..2616036.33 rows=1 width=0) (actual time=366599.753..366599.754 rows=1 loops=1)
364572.440	364572.440	↓ 1.6	3729425	1	→ Seq Scan on tbl_searches (cost=0.00..2610378.99 rows=2262931 width=0) (actual time=3566.505..364572.440 rows=3729425 loops=1) Filter: ((NOT filtered) AND (fk_event = 42))

"Aggregate  (cost=2616036.32..2616036.33 rows=1 width=0) (actual time=366599.753..366599.754 rows=1 loops=1)"
"  ->  Seq Scan on tbl_searches  (cost=0.00..2610378.99 rows=2262931 width=0) (actual time=3566.505..364572.440 rows=3729425 loops=1)"
"        Filter: ((NOT filtered) AND (fk_event = 42))"
"Total runtime: 366599.816 ms"

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	2027.314 ms	0.6 %
Seq Scan	1	364572.440 ms	99.4 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
tbl_searches	1	364572.440 ms	99.4 %
Seq Scan	1	364572.440 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 2TD

Colorize:

Columns visibility:

Per node type stats

Per table stats