explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ibEA

Settings
# exclusive inclusive rows x rows loops node
1. 486.170 12,204.600 ↑ 3.9 227,524 1

Unique (cost=583,380.75..633,144.18 rows=884,684 width=100) (actual time=11,450.393..12,204.600 rows=227,524 loops=1)

2. 10,019.764 11,718.430 ↑ 1.0 2,211,524 1

Sort (cost=583,380.75..588,910.02 rows=2,211,708 width=100) (actual time=11,450.391..11,718.430 rows=2,211,524 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: 253,184kB
3. 1,698.666 1,698.666 ↑ 1.0 2,211,524 1

Seq Scan on org_schedule_calendar o (cost=0.00..108,396.89 rows=2,211,708 width=100) (actual time=0.016..1,698.666 rows=2,211,524 loops=1)

  • Filter: (is_active AND (event_uid IS NOT NULL) AND (init_point_id IS NOT NULL))
Planning time : 0.161 ms
Execution time : 12,261.564 ms