explain.depesz.com

PostgreSQL's explain analyze made readable

Result: z3Ts

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 38.227 915.171 ↑ 1.3 135,739 1

Unique (cost=103,655.57..107,767.82 rows=182,767 width=100) (actual time=855.635..915.171 rows=135,739 loops=1)

2. 580.492 876.944 ↑ 1.0 182,031 1

Sort (cost=103,655.57..104,112.48 rows=182,767 width=100) (actual time=855.633..876.944 rows=182,031 loops=1)

  • Sort Key: event_uid, 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
  • Sort Method: external sort Disk: 20,840kB
3. 282.489 296.452 ↑ 1.0 182,031 1

Bitmap Heap Scan on org_schedule_calendar o (cost=3,424.88..77,686.05 rows=182,767 width=100) (actual time=17.365..296.452 rows=182,031 loops=1)

  • Recheck Cond: (date_from >= (CURRENT_TIMESTAMP - '7 days'::interval))
  • Filter: (is_active AND (event_uid IS NOT NULL) AND (init_point_id IS NOT NULL))
  • Heap Blocks: exact=21,794
4. 13.963 13.963 ↑ 1.0 182,031 1

Bitmap Index Scan on idx_org_schedule_calendar_date_from (cost=0.00..3,379.19 rows=182,767 width=0) (actual time=13.963..13.963 rows=182,031 loops=1)

  • Index Cond: (date_from >= (CURRENT_TIMESTAMP - '7 days'::interval))
Planning time : 0.216 ms
Execution time : 924.755 ms