explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pOBV

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 4.808 ↓ 2.0 2 1

Nested Loop (cost=9.51..81.23 rows=1 width=212) (actual time=0.862..4.808 rows=2 loops=1)

  • Output: '2020-07-30 17:00:00'::timestamp without time zone, 1, 4, NULL::text, cc.related_org_id, client_org.name, client_org.tems_customer_number, cust.id, cust.gl_legal_entity, cust.gl_cust_no, cust.name, 1, el.id, el.org_id, org.name, el.device_id, el.device_sn, el.event_execution_dtt, el.dataset_name, el.dataset_version, el.create_dtt
  • Inner Unique: true
  • Buffers: shared hit=322 read=1
2. 0.026 4.794 ↓ 2.0 2 1

Nested Loop (cost=9.23..79.64 rows=1 width=117) (actual time=0.853..4.794 rows=2 loops=1)

  • Output: el.id, el.org_id, el.device_id, el.device_sn, el.event_execution_dtt, el.dataset_name, el.dataset_version, el.create_dtt, org.name, cc.related_org_id, client_org.name, client_org.tems_customer_number, client_org.bill_to_customer_id
  • Inner Unique: true
  • Join Filter: (cc.related_org_id = client_org.id)
  • Rows Removed by Join Filter: 72
  • Buffers: shared hit=316 read=1
3. 0.004 4.746 ↓ 2.0 2 1

Nested Loop (cost=9.23..77.25 rows=1 width=90) (actual time=0.828..4.746 rows=2 loops=1)

  • Output: el.id, el.org_id, el.device_id, el.device_sn, el.event_execution_dtt, el.dataset_name, el.dataset_version, el.create_dtt, org.name, cc.related_org_id
  • Inner Unique: true
  • Buffers: shared hit=314 read=1
4. 0.070 4.736 ↓ 2.0 2 1

Nested Loop (cost=9.09..76.27 rows=1 width=82) (actual time=0.822..4.736 rows=2 loops=1)

  • Output: el.id, el.org_id, el.device_id, el.device_sn, el.event_execution_dtt, el.dataset_name, el.dataset_version, el.create_dtt, cc.related_org_id, cc.org_id
  • Join Filter: (el.org_id = cc.org_id)
  • Rows Removed by Join Filter: 122
  • Buffers: shared hit=310 read=1
5. 0.049 0.698 ↓ 62.0 62 1

Subquery Scan on cc (cost=8.67..14.00 rows=1 width=8) (actual time=0.244..0.698 rows=62 loops=1)

  • Output: cc.org_id, cc.related_org_id, cc.rr, mv_org_tree.distance
  • Filter: (cc.rr = 1)
  • Rows Removed by Filter: 102
  • Buffers: shared hit=1
6. 0.387 0.649 ↑ 1.0 164 1

WindowAgg (cost=8.67..11.95 rows=164 width=20) (actual time=0.243..0.649 rows=164 loops=1)

  • Output: mv_org_tree.org_id, mv_org_tree.related_org_id, rank() OVER (?), mv_org_tree.distance
  • Buffers: shared hit=1
7. 0.183 0.262 ↑ 1.0 164 1

Sort (cost=8.67..9.08 rows=164 width=12) (actual time=0.234..0.262 rows=164 loops=1)

  • Output: mv_org_tree.org_id, mv_org_tree.distance, mv_org_tree.related_org_id
  • Sort Key: mv_org_tree.org_id, mv_org_tree.distance
  • Sort Method: quicksort Memory: 32kB
  • Buffers: shared hit=1
8. 0.079 0.079 ↑ 1.0 164 1

Seq Scan on users.mv_org_tree (cost=0.00..2.64 rows=164 width=12) (actual time=0.014..0.079 rows=164 loops=1)

  • Output: mv_org_tree.org_id, mv_org_tree.distance, mv_org_tree.related_org_id
  • Buffers: shared hit=1
9. 3.968 3.968 ↑ 7.5 2 62

Index Scan using _test_idx_event_log_03 on mgmtplan.event_log el (cost=0.42..62.08 rows=15 width=74) (actual time=0.062..0.064 rows=2 loops=62)

  • Output: el.id, el.org_id, el.device_id, el.device_sn, el.event_execution_dtt, el.result, el.dataset_name, el.dataset_type, el.dataset_version, el.addl_error_info, el.dataset_create_dtt, el.action_type, el.management_action_id, el.device_history_id, el.device_history_dtt, el.device_history_device_event_type, el.device_history_org_id, el.device_history_device_id2, el.device_history_serial_number, el.device_history_cpu_id, el.device_history_lane_id, el.device_history_device_state_id, el.device_history_type_id, el.device_history_store_id, el.device_history_timezone, el.device_history_timezone_source, el.device_history_online, el.device_history_store_name, el.device_history_org_name, el.device_history_user_scd_id, el.device_history_login_id, el.device_history_first_name, el.device_history_last_name, el.create_dtt
  • Index Cond: ((el.create_dtt >= '2020-03-01 00:00:00'::timestamp without time zone) AND (el.create_dtt < '2020-04-01 00:00:00'::timestamp without time zone) AND ((el.result)::text = 'SUCC'::text) AND ((el.action_type)::text = 'DWNL'::text) AND ((el.dataset_type)::text = 'SWPK'::text))
  • Buffers: shared hit=309 read=1
10. 0.006 0.006 ↑ 1.0 1 2

Index Scan using organization_pk on users.organization org (cost=0.14..0.96 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=2)

  • Output: org.id, org.name, org.parent_id, org.enabled, org.location_id, org.tems_customer_number, org.bill_to_customer_id, org.exclusivity, org.hsm_slot, org.agreement_accepted_ts, org.heart_beat_period, org.monitor_my_terminals, org.idp_version, org.sales_director_name, org.sales_director_email, org.sales_admin_name, org.sales_admin_email
  • Index Cond: (org.id = el.org_id)
  • Buffers: shared hit=4
11. 0.022 0.022 ↑ 1.7 37 2

Seq Scan on users.organization client_org (cost=0.00..1.62 rows=62 width=31) (actual time=0.005..0.011 rows=37 loops=2)

  • Output: client_org.id, client_org.name, client_org.parent_id, client_org.enabled, client_org.location_id, client_org.tems_customer_number, client_org.bill_to_customer_id, client_org.exclusivity, client_org.hsm_slot, client_org.agreement_accepted_ts, client_org.heart_beat_period, client_org.monitor_my_terminals, client_org.idp_version, client_org.sales_director_name, client_org.sales_director_email, client_org.sales_admin_name, client_org.sales_admin_email
  • Buffers: shared hit=2
12. 0.010 0.010 ↑ 1.0 1 2

Index Scan using customer_pkey on users.customer cust (cost=0.28..1.58 rows=1 width=51) (actual time=0.004..0.005 rows=1 loops=2)

  • Output: cust.id, cust.gl_legal_entity, cust.gl_cust_no, cust.name, cust.address, cust.address_2, cust.city, cust.postal_code, cust.blocked, cust.sim_auto_activation, cust.sim_activate_graceperiod_days, cust.sim_suspend_requests, cust.sim_suspend_days_max, cust.sim_guaranteed_cycle_max, cust.single_multi_src_invoice_ind, cust.create_dtt, cust.last_upd_dtt, cust.payment_terms_code
  • Index Cond: (cust.id = client_org.bill_to_customer_id)
  • Buffers: shared hit=6