explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Oe4L6

Settings
# exclusive inclusive rows x rows loops node
1. 1,022.237 6,472.193 ↑ 10.7 57,555 1

GroupAggregate (cost=619,960.04..683,747.20 rows=614,816 width=221) (actual time=4,888.036..6,472.193 rows=57,555 loops=1)

  • Group Key: o.date_from, o.event_uid, o.chain_hash, o.organization_id, o.init_point_id, o.is_imported, o.is_fbs, o.autorepeat_hash
2. 3,498.665 5,449.956 ↑ 1.0 1,519,851 1

Sort (cost=619,960.04..623,802.64 rows=1,537,040 width=157) (actual time=4,887.986..5,449.956 rows=1,519,851 loops=1)

  • Sort Key: o.date_from, o.event_uid, o.chain_hash, o.organization_id, o.init_point_id, o.is_imported, o.is_fbs, o.autorepeat_hash
  • Sort Method: external merge Disk: 264800kB
3. 411.151 1,951.291 ↑ 1.0 1,519,851 1

Hash Join (cost=2,802.94..220,347.93 rows=1,537,040 width=157) (actual time=17.078..1,951.291 rows=1,519,851 loops=1)

  • Hash Cond: (o.point_to_id = pt.id)
4. 520.069 1,531.593 ↑ 1.0 1,519,851 1

Hash Join (cost=1,401.47..197,812.17 rows=1,537,040 width=157) (actual time=8.479..1,531.593 rows=1,519,851 loops=1)

  • Hash Cond: (o.point_from_id = p.id)
5. 1,003.163 1,003.163 ↑ 1.0 1,519,851 1

Seq Scan on org_schedule_calendar o (cost=0.00..175,276.40 rows=1,537,040 width=157) (actual time=0.053..1,003.163 rows=1,519,851 loops=1)

  • Filter: (is_active AND (event_uid IS NOT NULL) AND (init_point_id IS NOT NULL))
6. 3.521 8.361 ↑ 1.0 30,706 1

Hash (cost=1,017.64..1,017.64 rows=30,706 width=8) (actual time=8.361..8.361 rows=30,706 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1456kB
7. 4.840 4.840 ↑ 1.0 30,706 1

Index Only Scan using idx_views_valid_point_is_deleted on valid_point p (cost=0.29..1,017.64 rows=30,706 width=8) (actual time=0.017..4.840 rows=30,706 loops=1)

  • Index Cond: (is_deleted = false)
  • Filter: (NOT is_deleted)
  • Heap Fetches: 0
8. 3.626 8.547 ↑ 1.0 30,706 1

Hash (cost=1,017.64..1,017.64 rows=30,706 width=8) (actual time=8.547..8.547 rows=30,706 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1456kB
9. 4.921 4.921 ↑ 1.0 30,706 1

Index Only Scan using idx_views_valid_point_is_deleted on valid_point pt (cost=0.29..1,017.64 rows=30,706 width=8) (actual time=0.016..4.921 rows=30,706 loops=1)

  • Index Cond: (is_deleted = false)
  • Filter: (NOT is_deleted)
  • Heap Fetches: 0
Planning time : 0.558 ms
Execution time : 6,531.124 ms