explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jzjo

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.035 ↓ 0.0 0 1

Limit (cost=0.45..4.46 rows=1 width=67) (actual time=0.035..0.035 rows=0 loops=1)

2. 0.034 0.034 ↓ 0.0 0 1

Index Scan using messages_inserted_tstamp_pidx on messages (cost=0.45..4.46 rows=1 width=67) (actual time=0.034..0.034 rows=0 loops=1)

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