explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8sB6

Settings
# exclusive inclusive rows x rows loops node
1. 0.141 1.226 ↑ 1.0 1,000 1

Limit (cost=0.00..49.79 rows=1,000 width=16) (actual time=0.106..1.226 rows=1,000 loops=1)

2. 1.085 1.085 ↑ 5,217.2 1,000 1

Seq Scan on messages (cost=0.00..259,741.50 rows=5,217,220 width=16) (actual time=0.105..1.085 rows=1,000 loops=1)

  • Filter: (inserted_tstamp < ((timezone('UTC'::text, now()) - '30 days'::interval))::timestamp(0) with time zone)