explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QYwC : Optimization for: plan #ZKMj

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 31.802 80.244 ↓ 8.5 24,977 1

GroupAggregate (cost=0.42..19,035.25 rows=2,952 width=56) (actual time=0.184..80.244 rows=24,977 loops=1)

  • Group Key: participant_statuses.list_item_id, participant_statuses.event_id
  • Filter: ((max(participant_statuses.notified_at) > max(participant_statuses.selected_attendance_at)) AND (max(participant_statuses.selected_attendance_at) < '2019-09-30 21:42:39.671372'::timestamp without time zone))
  • Rows Removed by Filter: 8,628
2. 48.442 48.442 ↑ 1.0 120,535 1

Index Scan using index_participant_statuses_on_item_and_event_and_part on participant_statuses (cost=0.42..16,159.61 rows=120,535 width=28) (actual time=0.011..48.442 rows=120,535 loops=1)

Planning time : 0.146 ms
Execution time : 81.643 ms