explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZKMj

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 30.573 77.231 ↓ 0.0 0 1

GroupAggregate (cost=0.42..19,336.59 rows=2,982 width=56) (actual time=77.231..77.231 rows=0 loops=1)

  • Group Key: participant_statuses.list_item_id, participant_statuses.event_id
  • Filter: (((max(participant_statuses.notified_at) IS NULL) OR (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: 33,605
2. 46.658 46.658 ↑ 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..46.658 rows=120,535 loops=1)

Planning time : 0.151 ms
Execution time : 77.259 ms