explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w6hj

Settings
# exclusive inclusive rows x rows loops node
1. 4,666.182 4,666.182 ↑ 1.0 668,627 1

Seq Scan on public.org_schedule_calendar o (cost=0.00..251,884.02 rows=691,163 width=133) (actual time=269.486..4,666.182 rows=668,627 loops=1)

  • Output: event_uid, chain_hash, init_point_id, timezone('UTC'::text, date_from), (timezone('MSK'::text, date_from))::time without time zone, organization_id, is_imported, is_fbs, autorepeat_hash
  • Filter: (o.is_active AND (o.event_uid IS NOT NULL) AND (o.init_point_id IS NOT NULL) AND (o.date_from >= (CURRENT_TIMESTAMP - '30 days'::interval)))
  • Rows Removed by Filter: 1,694,617
  • Buffers: shared hit=26,239 read=177,549
Planning time : 5.972 ms
Execution time : 4,718.207 ms