#	exclusive	inclusive	rows x	rows	loops	node
1.	6215.420	6215.420	↑ 1.0	9545314	1	→ Seq Scan on session_data (cost=0.00..357733.27 rows=9635381 width=67) (actual time=0.032..6215.420 rows=9545314 loops=1) Filter: (access_time <= (now() - '1 year'::interval))

Seq Scan on session_data  (cost=0.00..357733.27 rows=9635381 width=67) (actual time=0.032..6215.420 rows=9545314 loops=1)
   Filter: (access_time <= (now() - '1 year'::interval))

Per node type stats

node type	count	sum of times	% of query
Seq Scan	1	6215.420 ms	100.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
session_data	1	6215.420 ms	100.0 %
Seq Scan	1	6215.420 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: ee3

Colorize:

Columns visibility:

Per node type stats

Per table stats