explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9mx6

Settings
# exclusive inclusive rows x rows loops node
1. 285.606 341.419 ↑ 1.0 180,940 1

Bitmap Heap Scan on public.org_schedule_calendar o (cost=20,050.68..232,148.06 rows=185,580 width=133) (actual time=58.403..341.419 rows=180,940 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
  • Recheck Cond: (o.date_from >= (CURRENT_TIMESTAMP - '1 day'::interval))
  • Filter: (o.is_active AND (o.event_uid IS NOT NULL) AND (o.init_point_id IS NOT NULL))
  • Heap Blocks: exact=11,317
  • Buffers: shared hit=12,689 read=13
2. 55.813 55.813 ↑ 1.0 180,940 1

Bitmap Index Scan on idx_org_schedule_calendar_date_from (cost=0.00..20,004.28 rows=185,580 width=0) (actual time=55.813..55.813 rows=180,940 loops=1)

  • Index Cond: (o.date_from >= (CURRENT_TIMESTAMP - '1 day'::interval))
  • Buffers: shared hit=1,385
Planning time : 0.360 ms
Execution time : 355.168 ms