explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l1NT

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 211,817.869 ↑ 3.2 31 1

Limit (cost=0.43..14,552.29 rows=100 width=1,399) (actual time=0.020..211,817.869 rows=31 loops=1)

  • Output: id, created_at, created_by, created_from, updated_at, updated_by, updated_from, site_id, agency_id, notification_configuration_refid, notification_group_cd, notification_delay_mins, notification_data_json_text, notification_method_cd, delivery_destination, delivery_status_cd, delivery_status_at, delivery_status_by, delivery_status_from, delivery_status_msg, offender_id, parent_notification_id, notification_event_id, versioned_config_id, template_url, merge_result_url, language_cd, priority, notification_desc, confirmation_type_cd, call_pattern_refid, call_pattern_start_at, next_delivery_attempt_at, push_notification_platform_cd, senden_app_refid, long_call_pattern_latched, approval_status_cd, approval_status_at, approval_status_by, approval_status_from, approval_status_msg, court_case_id, defendant_id, backup_letter, assertion_id
  • Buffers: shared hit=5,905,120 read=1,280,509 dirtied=177
2. 211,817.840 211,817.840 ↑ 378.3 31 1

Index Scan Backward using pk_notification on revere.notification (cost=0.43..1,706,642.78 rows=11,728 width=1,399) (actual time=0.019..211,817.840 rows=31 loops=1)

  • Output: id, created_at, created_by, created_from, updated_at, updated_by, updated_from, site_id, agency_id, notification_configuration_refid, notification_group_cd, notification_delay_mins, notification_data_json_text, notification_method_cd, delivery_destination, delivery_status_cd, delivery_status_at, delivery_status_by, delivery_status_from, delivery_status_msg, offender_id, parent_notification_id, notification_event_id, versioned_config_id, template_url, merge_result_url, language_cd, priority, notification_desc, confirmation_type_cd, call_pattern_refid, call_pattern_start_at, next_delivery_attempt_at, push_notification_platform_cd, senden_app_refid, long_call_pattern_latched, approval_status_cd, approval_status_at, approval_status_by, approval_status_from, approval_status_msg, court_case_id, defendant_id, backup_letter, assertion_id
  • Filter: ((notification.site_id = 4) AND ((notification.delivery_status_cd)::text = ANY ('{APPROVED,DELAYED,HOLD_AGENCY,HOLD_SITE,HOLD_USER,MERGE_FAILED,PENDING,PROCESSING,SUPPRESSED}'::text[])))
  • Rows Removed by Filter: 7,271,896
  • Buffers: shared hit=5,905,120 read=1,280,509 dirtied=177
Planning time : 0.227 ms
Execution time : 211,817.913 ms