explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zrhL

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=1.55..7,303.51 rows=10 width=315) (actual rows= loops=)

  • Output: le.entry_id, le.code, le.entry_type, le.entry_subtype, le.centre_id, (CASE WHEN (le.from_vessel_history_id IS NOT NULL) THEN (SubPlan 1) WHEN ((le.from_vessel_id IS NOT NULL) AND (le.from_vessel_history_id IS NULL)) THEN (SubPlan 2) WHEN (le.from_entity_id IS NOT NULL) THEN (SubPlan 3) WHEN ((le.from_resource_id IS NOT NULL) AND (le.from_capability_id IS NULL)) THEN (SubPlan 4) WHEN ((le.from_resource_id IS NOT NULL) AND (le.from_capability_id IS NOT NULL)) THEN ((SubPlan 6))::character varying WHEN (le.from_centre_id IS NOT NULL) THEN (SubPlan 7) WHEN (le.from_port_id IS NOT NULL) THEN (SubPlan 8) ELSE le.from_text END), (CASE WHEN (le.to_vessel_history_id IS NOT NULL) THEN (SubPlan 9) WHEN ((le.to_vessel_id IS NOT NULL) AND (le.to_vessel_history_id IS NULL)) THEN (SubPlan 10) WHEN (le.to_entity_id IS NOT NULL) THEN (SubPlan 11) WHEN ((le.to_resource_id IS NOT NULL) AND (le.to_capability_id IS NULL)) THEN (SubPlan 12) WHEN ((le.to_resource_id IS NOT NULL) AND (le.to_capability_id IS NOT NULL)) THEN ((SubPlan 14))::character varying WHEN (le.to_centre_id IS NOT NULL) THEN (SubPlan 15) WHEN (le.to_port_id IS NOT NULL) THEN (SubPlan 16) ELSE le.to_text END), le.details, (CASE WHEN (le.linked_incident_id IS NOT NULL) THEN (SubPlan 17) WHEN (le.linked_activity_id IS NOT NULL) THEN (SubPlan 18) WHEN (le.linked_record_id IS NOT NULL) THEN (SubPlan 19) WHEN ((le.linked_record_id IS NULL) AND (le.entry_type = 'MSI'::log_entry_type) AND (le.event = 'BROADCAST'::log_event)) THEN ((SubPlan 20))::character varying WHEN ((le.linked_record_id IS NULL) AND (le.entry_type = 'MSI'::log_entry_type) AND (le.entry_subtype = 'NAVTEX'::log_entry_subtype)) THEN ((SubPlan 21))::character varying ELSE NULL::character varying END), (CASE WHEN (le.linked_incident_id IS NOT NULL) THEN 'INCIDENT'::text WHEN (le.linked_activity_id IS NOT NULL) THEN 'RESOURCE_ACTIVITY'::text WHEN (le.linked_record_id IS NOT NULL) THEN 'MSI_RECORD'::text WHEN ((le.linked_record_id IS NULL) AND (le.entry_type = 'MSI'::log_entry_type) AND (le.event = 'BROADCAST'::log_event) AND ((SubPlan 22) > 0)) THEN 'MSI_RECORD'::text WHEN ((le.linked_record_id IS NULL) AND (le.entry_type = 'MSI'::log_entry_type) AND (le.entry_subtype = 'NAVTEX'::log_entry_subtype) AND ((SubPlan 23) > 0)) THEN 'NAVTEX_MESSAGE'::text ELSE NULL::text END), (CASE WHEN (le.linked_incident_id IS NOT NULL) THEN (SubPlan 24) WHEN (le.linked_activity_id IS NOT NULL) THEN (SubPlan 25) ELSE NULL::text END), le.occurrence_timestamp, le.entry_state, (CASE WHEN ((reminders2_.due_datetime <= now()) AND reminders2_.sent) THEN 'OVERDUE'::text WHEN reminders2_.snoozed THEN 'SNOOZED'::text WHEN (NOT reminders2_.snoozed) THEN 'DUE_IN_FUTURE'::text ELSE NULL::text END)
2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.55..2,485,589.50 rows=3,404 width=315) (actual rows= loops=)

  • Output: le.entry_id, le.code, le.entry_type, le.entry_subtype, le.centre_id, CASE WHEN (le.from_vessel_history_id IS NOT NULL) THEN (SubPlan 1) WHEN ((le.from_vessel_id IS NOT NULL) AND (le.from_vessel_history_id IS NULL)) THEN (SubPlan 2) WHEN (le.from_entity_id IS NOT NULL) THEN (SubPlan 3) WHEN ((le.from_resource_id IS NOT NULL) AND (le.from_capability_id IS NULL)) THEN (SubPlan 4) WHEN ((le.from_resource_id IS NOT NULL) AND (le.from_capability_id IS NOT NULL)) THEN ((SubPlan 6))::character varying WHEN (le.from_centre_id IS NOT NULL) THEN (SubPlan 7) WHEN (le.from_port_id IS NOT NULL) THEN (SubPlan 8) ELSE le.from_text END, CASE WHEN (le.to_vessel_history_id IS NOT NULL) THEN (SubPlan 9) WHEN ((le.to_vessel_id IS NOT NULL) AND (le.to_vessel_history_id IS NULL)) THEN (SubPlan 10) WHEN (le.to_entity_id IS NOT NULL) THEN (SubPlan 11) WHEN ((le.to_resource_id IS NOT NULL) AND (le.to_capability_id IS NULL)) THEN (SubPlan 12) WHEN ((le.to_resource_id IS NOT NULL) AND (le.to_capability_id IS NOT NULL)) THEN ((SubPlan 14))::character varying WHEN (le.to_centre_id IS NOT NULL) THEN (SubPlan 15) WHEN (le.to_port_id IS NOT NULL) THEN (SubPlan 16) ELSE le.to_text END, le.details, CASE WHEN (le.linked_incident_id IS NOT NULL) THEN (SubPlan 17) WHEN (le.linked_activity_id IS NOT NULL) THEN (SubPlan 18) WHEN (le.linked_record_id IS NOT NULL) THEN (SubPlan 19) WHEN ((le.linked_record_id IS NULL) AND (le.entry_type = 'MSI'::log_entry_type) AND (le.event = 'BROADCAST'::log_event)) THEN ((SubPlan 20))::character varying WHEN ((le.linked_record_id IS NULL) AND (le.entry_type = 'MSI'::log_entry_type) AND (le.entry_subtype = 'NAVTEX'::log_entry_subtype)) THEN ((SubPlan 21))::character varying ELSE NULL::character varying END, CASE WHEN (le.linked_incident_id IS NOT NULL) THEN 'INCIDENT'::text WHEN (le.linked_activity_id IS NOT NULL) THEN 'RESOURCE_ACTIVITY'::text WHEN (le.linked_record_id IS NOT NULL) THEN 'MSI_RECORD'::text WHEN ((le.linked_record_id IS NULL) AND (le.entry_type = 'MSI'::log_entry_type) AND (le.event = 'BROADCAST'::log_event) AND ((SubPlan 22) > 0)) THEN 'MSI_RECORD'::text WHEN ((le.linked_record_id IS NULL) AND (le.entry_type = 'MSI'::log_entry_type) AND (le.entry_subtype = 'NAVTEX'::log_entry_subtype) AND ((SubPlan 23) > 0)) THEN 'NAVTEX_MESSAGE'::text ELSE NULL::text END, CASE WHEN (le.linked_incident_id IS NOT NULL) THEN (SubPlan 24) WHEN (le.linked_activity_id IS NOT NULL) THEN (SubPlan 25) ELSE NULL::text END, le.occurrence_timestamp, le.entry_state, CASE WHEN ((reminders2_.due_datetime <= now()) AND reminders2_.sent) THEN 'OVERDUE'::text WHEN reminders2_.snoozed THEN 'SNOOZED'::text WHEN (NOT reminders2_.snoozed) THEN 'DUE_IN_FUTURE'::text ELSE NULL::text END
  • Join Filter: (logentryen1_.entry_id = reminders2_.entry_id)
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.27..579,787.78 rows=3,404 width=225) (actual rows= loops=)

  • Output: le.entry_id, le.code, le.entry_type, le.entry_subtype, le.centre_id, le.from_vessel_history_id, le.from_vessel_id, le.from_entity_id, le.from_resource_id, le.from_capability_id, le.from_centre_id, le.from_port_id, le.from_text, le.to_vessel_history_id, le.to_vessel_id, le.to_entity_id, le.to_resource_id, le.to_capability_id, le.to_centre_id, le.to_port_id, le.to_text, le.details, le.linked_incident_id, le.linked_activity_id, le.linked_record_id, le.event, le.occurrence_timestamp, le.entry_state, ss.locale_id, logentryen1_.entry_id
  • Inner Unique: true
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..578,086.22 rows=3,404 width=225) (actual rows= loops=)

  • Output: le.entry_id, le.code, le.entry_type, le.entry_subtype, le.centre_id, le.from_vessel_history_id, le.from_vessel_id, le.from_entity_id, le.from_resource_id, le.from_capability_id, le.from_centre_id, le.from_port_id, le.from_text, le.to_vessel_history_id, le.to_vessel_id, le.to_entity_id, le.to_resource_id, le.to_capability_id, le.to_centre_id, le.to_port_id, le.to_text, le.details, le.linked_incident_id, le.linked_activity_id, le.linked_record_id, le.event, le.occurrence_timestamp, le.entry_state, ss.locale_id, ss.entry_id
  • Inner Unique: true
5. 0.000 0.000 ↓ 0.0

Index Scan Backward using idx_loge_26 on oversee.log_entry le (cost=0.42..58,261.55 rows=680,828 width=215) (actual rows= loops=)

  • Output: le.entry_id, le.code, le.code_number, le.code_series, le.entry_type, le.entry_subtype, le.entry_state, le.centre_id, le.occurrence_timestamp, le.from_text, le.from_vessel_id, le.from_vessel_history_id, le.from_entity_id, le.from_resource_id, le.from_centre_id, le.from_port_id, le.to_text, le.to_vessel_id, le.to_vessel_history_id, le.to_entity_id, le.to_resource_id, le.to_centre_id, le.to_port_id, le.channel_text, le.channel_id, le.details, le.casualty_text, le.casualty_vessel_id, le.casualty_vessel_history_id, le.casualty_entity_id, le.casualty_resource_id, le.casualty_centre_id, le.casualty_port_id, le.system, le.system_report_type, le.resource_text, le.resource_id, le.event, le.event_timestamp, le.event_start_date, le.event_end_date, le.linked_incident_id, le.linked_record_id, le.linked_activity_id, le.datasource_uuid, le.acknowledged, le.answer_time, le.call_id, le.call_duration, le.call_details, le.deleted, le.active, le.version, le.create_username, le.create_datetime, le.change_username, le.change_datetime, le.slot, le.queue_id, le.outgoing_call, le.from_capability_id, le.to_capability_id, le.resource_capability_id, le.casualty_capability_id, le.source_type
  • Filter: ((NOT le.deleted) AND le.active AND (le.centre_id = ANY ('{1,2,3,4}'::integer[])))
6. 0.000 0.000 ↓ 0.0

Index Scan using pk_log_entry_search on oversee.log_entry_search ss (cost=0.42..0.76 rows=1 width=10) (actual rows= loops=)

  • Output: ss.entry_id, ss.locale_id, ss.search_string
  • Index Cond: ((ss.entry_id = le.entry_id) AND ((ss.locale_id)::text = 'en-GB'::text))
  • Filter: (ss.search_string @@ to_tsquery('simple'::regconfig, unaccent('toremore'::text)))
7. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_log_entry on oversee.log_entry logentryen1_ (cost=0.42..0.50 rows=1 width=4) (actual rows= loops=)

  • Output: logentryen1_.entry_id
  • Index Cond: (logentryen1_.entry_id = le.entry_id)
8. 0.000 0.000 ↓ 0.0

Materialize (cost=0.28..2.50 rows=1 width=14) (actual rows= loops=)

  • Output: reminders2_.due_datetime, reminders2_.sent, reminders2_.snoozed, reminders2_.entry_id
9. 0.000 0.000 ↓ 0.0

Index Scan using idx_ovsr_09 on oversee.ovs_reminder reminders2_ (cost=0.28..2.50 rows=1 width=14) (actual rows= loops=)

  • Output: reminders2_.due_datetime, reminders2_.sent, reminders2_.snoozed, reminders2_.entry_id
  • Index Cond: (reminders2_.assigned_to_user_id = 0)
10.          

SubPlan (for Nested Loop Left Join)

11. 0.000 0.000 ↓ 0.0

Index Scan using pk_vdb_vessel_history on oversee.vdb_vessel_history vh (cost=0.43..2.65 rows=1 width=13) (actual rows= loops=)

  • Output: vh.name
  • Index Cond: (vh.vessel_history_id = le.from_vessel_history_id)
12. 0.000 0.000 ↓ 0.0

Index Scan using uk_vdb_vessel_id on oversee.vdb_vessel v (cost=0.42..2.64 rows=1 width=9) (actual rows= loops=)

  • Output: v.name
  • Index Cond: (v.vessel_id = le.from_vessel_id)
13. 0.000 0.000 ↓ 0.0

Index Scan using pk_ovs_entity on oversee.ovs_entity fe (cost=0.28..2.50 rows=1 width=15) (actual rows= loops=)

  • Output: fe.name
  • Index Cond: (fe.entity_id = le.from_entity_id)
14. 0.000 0.000 ↓ 0.0

Index Scan using pk_rm_resource on oversee.rm_resource r (cost=0.14..2.36 rows=1 width=19) (actual rows= loops=)

  • Output: r.name
  • Index Cond: (r.resource_id = le.from_resource_id)
15. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.14..238.53 rows=1 width=32) (actual rows= loops=)

  • Output: (((r_1.name)::text || ' - '::text) || (SubPlan 5))
16. 0.000 0.000 ↓ 0.0

Index Scan using pk_rm_resource on oversee.rm_resource r_1 (cost=0.14..2.36 rows=1 width=19) (actual rows= loops=)

  • Output: r_1.resource_id, r_1.resource_type_id, r_1.centre_id, r_1.name, r_1.alias, r_1.contact_card_id, r_1.position_text, r_1.gis_position, r_1.additional_info, r_1.notes, r_1.locked, r_1.active, r_1.version, r_1.create_username, r_1.create_datetime, r_1.change_username, r_1.change_datetime, r_1.code
  • Index Cond: (r_1.resource_id = le.from_resource_id)
17. 0.000 0.000 ↓ 0.0

Seq Scan on oversee.rm_capability c (cost=0.00..1.33 rows=1 width=118) (actual rows= loops=)

  • Output: c.capability_id, c.code, c.name, c.order_by, c.active, c.version, c.create_username, c.create_datetime, c.change_username, c.change_datetime
  • Filter: (c.capability_id = le.from_capability_id)
18.          

SubPlan (for Nested Loop)

19. 0.000 0.000 ↓ 0.0

Seq Scan on oversee.ovs_translation t (cost=0.00..234.83 rows=1 width=16) (actual rows= loops=)

  • Output: t.translation
  • Filter: (((t.locale_id)::text = (ss.locale_id)::text) AND ((t.key_value)::text = concat('resource.capabilities.', c.code)))
20. 0.000 0.000 ↓ 0.0

Seq Scan on oversee.ovs_centre c_1 (cost=0.00..1.05 rows=1 width=516) (actual rows= loops=)

  • Output: c_1.name
  • Filter: (c_1.centre_id = le.from_centre_id)
21. 0.000 0.000 ↓ 0.0

Index Scan using pk_ovs_port on oversee.ovs_port p (cost=0.14..2.36 rows=1 width=16) (actual rows= loops=)

  • Output: p.name
  • Index Cond: (p.port_id = le.from_port_id)
22. 0.000 0.000 ↓ 0.0

Index Scan using pk_vdb_vessel_history on oversee.vdb_vessel_history vh_1 (cost=0.43..2.65 rows=1 width=13) (actual rows= loops=)

  • Output: vh_1.name
  • Index Cond: (vh_1.vessel_history_id = le.to_vessel_history_id)
23. 0.000 0.000 ↓ 0.0

Index Scan using uk_vdb_vessel_id on oversee.vdb_vessel v_1 (cost=0.42..2.64 rows=1 width=9) (actual rows= loops=)

  • Output: v_1.name
  • Index Cond: (v_1.vessel_id = le.to_vessel_id)
24. 0.000 0.000 ↓ 0.0

Index Scan using pk_ovs_entity on oversee.ovs_entity e (cost=0.28..2.50 rows=1 width=15) (actual rows= loops=)

  • Output: e.name
  • Index Cond: (e.entity_id = le.to_entity_id)
25. 0.000 0.000 ↓ 0.0

Index Scan using pk_rm_resource on oversee.rm_resource r_2 (cost=0.14..2.36 rows=1 width=19) (actual rows= loops=)

  • Output: r_2.name
  • Index Cond: (r_2.resource_id = le.to_resource_id)
26. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.14..238.53 rows=1 width=32) (actual rows= loops=)

  • Output: (((r_3.name)::text || ' - '::text) || (SubPlan 13))
27. 0.000 0.000 ↓ 0.0

Index Scan using pk_rm_resource on oversee.rm_resource r_3 (cost=0.14..2.36 rows=1 width=19) (actual rows= loops=)

  • Output: r_3.resource_id, r_3.resource_type_id, r_3.centre_id, r_3.name, r_3.alias, r_3.contact_card_id, r_3.position_text, r_3.gis_position, r_3.additional_info, r_3.notes, r_3.locked, r_3.active, r_3.version, r_3.create_username, r_3.create_datetime, r_3.change_username, r_3.change_datetime, r_3.code
  • Index Cond: (r_3.resource_id = le.to_resource_id)
28. 0.000 0.000 ↓ 0.0

Seq Scan on oversee.rm_capability c_2 (cost=0.00..1.33 rows=1 width=118) (actual rows= loops=)

  • Output: c_2.capability_id, c_2.code, c_2.name, c_2.order_by, c_2.active, c_2.version, c_2.create_username, c_2.create_datetime, c_2.change_username, c_2.change_datetime
  • Filter: (c_2.capability_id = le.to_capability_id)
29.          

SubPlan (for Nested Loop)

30. 0.000 0.000 ↓ 0.0

Seq Scan on oversee.ovs_translation t_1 (cost=0.00..234.83 rows=1 width=16) (actual rows= loops=)

  • Output: t_1.translation
  • Filter: (((t_1.locale_id)::text = (ss.locale_id)::text) AND ((t_1.key_value)::text = concat('resource.capabilities.', c_2.code)))
31. 0.000 0.000 ↓ 0.0

Seq Scan on oversee.ovs_centre c_3 (cost=0.00..1.05 rows=1 width=516) (actual rows= loops=)

  • Output: c_3.name
  • Filter: (c_3.centre_id = le.to_centre_id)
32. 0.000 0.000 ↓ 0.0

Index Scan using pk_ovs_port on oversee.ovs_port p_1 (cost=0.14..2.36 rows=1 width=16) (actual rows= loops=)

  • Output: p_1.name
  • Index Cond: (p_1.port_id = le.to_port_id)
33. 0.000 0.000 ↓ 0.0

Index Scan using pk_im_incident on oversee.im_incident i (cost=0.29..2.50 rows=1 width=12) (actual rows= loops=)

  • Output: i.code
  • Index Cond: (le.linked_incident_id = i.incident_id)
34. 0.000 0.000 ↓ 0.0

Index Scan using pk_rm_activity on oversee.rm_activity a (cost=0.29..2.51 rows=1 width=11) (actual rows= loops=)

  • Output: a.code
  • Index Cond: (le.linked_activity_id = a.activity_id)
35. 0.000 0.000 ↓ 0.0

Index Scan using pk_msi_record on oversee.msi_record m (cost=0.28..2.50 rows=1 width=11) (actual rows= loops=)

  • Output: m.code
  • Index Cond: (le.linked_record_id = m.record_id)
36. 0.000 0.000 ↓ 0.0

Aggregate (cost=10.19..10.20 rows=1 width=32) (actual rows= loops=)

  • Output: array_to_string(array_agg(mr.code ORDER BY mr.code), ', '::text)
37. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.70..10.18 rows=3 width=11) (actual rows= loops=)

  • Output: mr.code
  • Inner Unique: true
38. 0.000 0.000 ↓ 0.0

Index Scan using idx_msire_02 on oversee.msi_record_log_entry rl (cost=0.42..2.69 rows=3 width=4) (actual rows= loops=)

  • Output: rl.records_id, rl.entries_id
  • Index Cond: (rl.entries_id = le.entry_id)
39. 0.000 0.000 ↓ 0.0

Index Scan using pk_msi_record on oversee.msi_record mr (cost=0.28..2.50 rows=1 width=15) (actual rows= loops=)

  • Output: mr.record_id, mr.code, mr.code_number, mr.code_series, mr.name, mr.originating_entry_id, mr.record_state, mr.start_date, mr.planned_cancel_date, mr.cancel_date, mr.cancelled_by_user_id, mr.schedule_id, mr.message_text, mr.num_words, mr.customer, mr.completed_tab_request, mr.completed_tab_invoices, mr.deleted, mr.active, mr.version, mr.create_username, mr.create_datetime, mr.change_username, mr.change_datetime
  • Index Cond: (mr.record_id = rl.records_id)
40. 0.000 0.000 ↓ 0.0

Aggregate (cost=20.61..20.63 rows=1 width=32) (actual rows= loops=)

  • Output: array_to_string(array_agg(m_1.code ORDER BY m_1.code), ', '::text)
41. 0.000 0.000 ↓ 0.0

Hash Join (cost=9.70..20.58 rows=11 width=118) (actual rows= loops=)

  • Output: m_1.code
  • Inner Unique: true
  • Hash Cond: (m_1.message_id = rl_1.messages_id)
42. 0.000 0.000 ↓ 0.0

Seq Scan on oversee.nt_message m_1 (cost=0.00..10.70 rows=70 width=122) (actual rows= loops=)

  • Output: m_1.message_id, m_1.code, m_1.code_number, m_1.code_series, m_1.name, m_1.outbox_id, m_1.subject_id, m_1.priority, m_1.schedule_id, m_1.first_schedule_tx_timestamp, m_1.last_schedule_tx_timestamp, m_1.cancelled_timestamp, m_1.message_text, m_1.status, m_1.estimated_duration, m_1.technical_characters, m_1.technical_characters_assign_date, m_1.numbering_characters, m_1.deleted, m_1.active, m_1.version, m_1.create_username, m_1.create_datetime, m_1.change_username, m_1.change_datetime
43. 0.000 0.000 ↓ 0.0

Hash (cost=9.56..9.56 rows=11 width=4) (actual rows= loops=)

  • Output: rl_1.messages_id
44. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on oversee.nt_message_log_entry rl_1 (cost=1.34..9.56 rows=11 width=4) (actual rows= loops=)

  • Output: rl_1.messages_id
  • Recheck Cond: (rl_1.entries_id = le.entry_id)
45. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_ntmle_02 (cost=0.00..1.34 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (rl_1.entries_id = le.entry_id)
46. 0.000 0.000 ↓ 0.0

Aggregate (cost=2.70..2.71 rows=1 width=8) (actual rows= loops=)

  • Output: count(*)
47. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_msire_02 on oversee.msi_record_log_entry rl_2 (cost=0.42..2.69 rows=3 width=0) (actual rows= loops=)

  • Output: rl_2.entries_id
  • Index Cond: (rl_2.entries_id = le.entry_id)
48. 0.000 0.000 ↓ 0.0

Aggregate (cost=9.59..9.60 rows=1 width=8) (actual rows= loops=)

  • Output: count(*)
49. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on oversee.nt_message_log_entry ml (cost=1.34..9.56 rows=11 width=0) (actual rows= loops=)

  • Recheck Cond: (ml.entries_id = le.entry_id)
50. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_ntmle_02 (cost=0.00..1.34 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (ml.entries_id = le.entry_id)
51. 0.000 0.000 ↓ 0.0

Index Scan using pk_im_incident on oversee.im_incident i_1 (cost=0.29..2.51 rows=1 width=32) (actual rows= loops=)

  • Output: (i_1.incident_state)::text
  • Index Cond: (le.linked_incident_id = i_1.incident_id)
52. 0.000 0.000 ↓ 0.0

Index Scan using pk_rm_activity on oversee.rm_activity a_1 (cost=0.29..2.51 rows=1 width=32) (actual rows= loops=)

  • Output: CASE WHEN (a_1.end_time IS NULL) THEN 'OPEN'::text ELSE 'CLOSED'::text END
  • Index Cond: (le.linked_activity_id = a_1.activity_id)