explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oFVo

Settings
# exclusive inclusive rows x rows loops node
1. 646.798 3,680.644 ↑ 3.2 159,898 1

GroupAggregate (cost=364,787.76..391,905.22 rows=516,523 width=188) (actual time=2,803.900..3,680.644 rows=159,898 loops=1)

  • Group Key: o.event_uid, o.date_from, o.organization_id, o.init_point_id, o.is_imported, o.is_fbs, o.autorepeat_hash
2. 1,202.282 3,033.846 ↓ 1.0 540,499 1

Sort (cost=364,787.76..366,079.07 rows=516,523 width=124) (actual time=2,803.859..3,033.846 rows=540,499 loops=1)

  • Sort Key: o.event_uid, o.date_from, o.organization_id, o.init_point_id, o.is_imported, o.is_fbs, o.autorepeat_hash
  • Sort Method: external merge Disk: 77,272kB
3. 135.913 1,831.564 ↓ 1.0 540,499 1

Hash Join (cost=3,870.32..248,685.67 rows=516,523 width=124) (actual time=114.596..1,831.564 rows=540,499 loops=1)

  • Hash Cond: (o.point_to_id = pt.id)
4. 192.925 1,681.776 ↓ 1.0 540,499 1

Hash Join (cost=1,935.16..245,394.47 rows=516,523 width=124) (actual time=100.388..1,681.776 rows=540,499 loops=1)

  • Hash Cond: (o.point_from_id = p.id)
5. 1,475.311 1,475.311 ↓ 1.0 540,499 1

Seq Scan on org_schedule_calendar o (cost=0.00..242,103.27 rows=516,523 width=124) (actual time=86.415..1,475.311 rows=540,499 loops=1)

  • Filter: (is_active AND (event_uid IS NOT NULL) AND (init_point_id IS NOT NULL) AND (date_from >= (CURRENT_TIMESTAMP - '30 days'::interval)))
  • Rows Removed by Filter: 1,671,025
6. 5.671 13.540 ↑ 1.0 35,385 1

Hash (cost=1,492.85..1,492.85 rows=35,385 width=8) (actual time=13.540..13.540 rows=35,385 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 1,895kB
7. 7.869 7.869 ↑ 1.0 35,385 1

Seq Scan on valid_point p (cost=0.00..1,492.85 rows=35,385 width=8) (actual time=0.010..7.869 rows=35,385 loops=1)

  • Filter: (NOT is_deleted)
8. 5.845 13.875 ↑ 1.0 35,385 1

Hash (cost=1,492.85..1,492.85 rows=35,385 width=8) (actual time=13.875..13.875 rows=35,385 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 1,895kB
9. 8.030 8.030 ↑ 1.0 35,385 1

Seq Scan on valid_point pt (cost=0.00..1,492.85 rows=35,385 width=8) (actual time=0.009..8.030 rows=35,385 loops=1)

  • Filter: (NOT is_deleted)
Planning time : 0.636 ms
Execution time : 3,711.477 ms