explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f4OW

Settings
# exclusive inclusive rows x rows loops node
1. 0.040 12,285.011 ↑ 1,459,892,046.4 5 1

Sort (cost=15,207,019,104.76..15,225,267,755.34 rows=7,299,460,232 width=711) (actual time=12,285.011..12,285.011 rows=5 loops=1)

  • Sort Key: (((orders.status_id)::bigint = 8)), (CASE WHEN (orders.vehicle_type_id IS NULL) THEN NULL::boolean ELSE (orders.vehicle_type_id = ANY (event.rescue_vehicle_types)) END), orders.grade_through_sequence, (((orders.service_id)::integer <> 1)), orders.create_date_time, ((orders.vehicle_type_id IS NULL)), orders.department_name, orders.vehicle_type_code, orders.id, status_log.eoosl_date_time, status_log.eoosl_order_status_log_id
  • Sort Method: quicksort Memory: 27kB
2.          

CTE event

3. 0.003 0.041 ↑ 4,252.0 1 1

Nested Loop (cost=0.84..35.97 rows=4,252 width=40) (actual time=0.032..0.041 rows=1 loops=1)

4. 0.001 0.019 ↑ 1.0 1 1

Append (cost=0.42..8.44 rows=1 width=16) (actual time=0.018..0.019 rows=1 loops=1)

5. 0.018 0.018 ↑ 1.0 1 1

Index Scan using ea_event_pk on ea_event e (cost=0.42..8.44 rows=1 width=16) (actual time=0.018..0.018 rows=1 loops=1)

  • Index Cond: ((eaevn_event_id)::bigint = 3027809)
6. 0.002 0.019 ↑ 2.0 1 1

Append (cost=0.42..16.88 rows=2 width=16) (actual time=0.010..0.019 rows=1 loops=1)

7. 0.010 0.010 ↑ 1.0 1 1

Index Scan using ea_generic_event_type_pk on ea_generic_event_type generic_event_type (cost=0.42..8.44 rows=1 width=16) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: ((eagnt_generic_event_type_id)::bigint = (e.eagnt_generic_event_type_id)::bigint)
8. 0.007 0.007 ↓ 0.0 0 1

Index Scan using ea_generic_event_type_aius_pkey on ea_generic_event_type_aius generic_event_type_1 (cost=0.42..8.44 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((eagnt_generic_event_type_id)::bigint = (e.eagnt_generic_event_type_id)::bigint)
9.          

CTE orders

10. 3.242 6,738.556 ↑ 8,456.2 5 1

Hash Left Join (cost=318,154.17..397,874.67 rows=42,281 width=463) (actual time=6,705.223..6,738.556 rows=5 loops=1)

  • Hash Cond: ((vr.eadep_department_id)::bigint = (vehicle_rule_department.eadep_department_id)::bigint)
11. 30.696 6,735.108 ↑ 8,456.2 5 1

Hash Left Join (cost=318,119.10..386,366.79 rows=42,281 width=440) (actual time=6,704.289..6,735.108 rows=5 loops=1)

  • Hash Cond: ((_order.emmsg_mesage_id)::bigint = (em_message.emmsg_mesage_id)::bigint)
12. 0.012 4.223 ↑ 8,456.2 5 1

Hash Left Join (cost=1,280.79..16,340.86 rows=42,281 width=421) (actual time=3.966..4.223 rows=5 loops=1)

  • Hash Cond: ((vr.eovht_vehicle_type_id)::bigint = vehicle_rule_vehicle_type.eovht_vehicle_type_id)
13. 0.011 4.172 ↑ 8,456.2 5 1

Nested Loop Left Join (cost=1,276.47..15,806.38 rows=42,281 width=423) (actual time=3.922..4.172 rows=5 loops=1)

14. 0.007 4.081 ↑ 5.6 5 1

Nested Loop Left Join (cost=1,275.33..15,121.20 rows=28 width=407) (actual time=3.892..4.081 rows=5 loops=1)

15. 0.008 4.069 ↑ 5.6 5 1

Nested Loop Left Join (cost=1,275.04..14,892.59 rows=28 width=347) (actual time=3.888..4.069 rows=5 loops=1)

16. 0.006 4.046 ↑ 5.6 5 1

Nested Loop Left Join (cost=1,274.76..14,700.12 rows=28 width=285) (actual time=3.879..4.046 rows=5 loops=1)

17. 0.009 3.990 ↑ 5.6 5 1

Nested Loop Left Join (cost=1,274.21..14,680.55 rows=28 width=261) (actual time=3.870..3.990 rows=5 loops=1)

18. 0.009 3.981 ↑ 5.6 5 1

Nested Loop Left Join (cost=1,273.94..14,671.41 rows=28 width=250) (actual time=3.867..3.981 rows=5 loops=1)

  • Join Filter: ((cur_disp.eddsv_trip_action)::bpchar <> 'F'::bpchar)
19. 0.016 3.967 ↑ 5.6 5 1

Hash Left Join (cost=1,273.66..14,658.37 rows=28 width=244) (actual time=3.861..3.967 rows=5 loops=1)

  • Hash Cond: ((_order.eovht_vehicle_type_id)::bigint = vehicle_type.eovht_vehicle_type_id)
20. 0.017 3.901 ↑ 5.6 5 1

Hash Left Join (cost=1,269.34..14,653.70 rows=28 width=238) (actual time=3.800..3.901 rows=5 loops=1)

  • Hash Cond: ((_order.eovhl_vehicle_id)::bigint = (cur_disp.eovhl_vehicle_id)::bigint)
21. 0.008 0.129 ↑ 5.6 5 1

Nested Loop Left Join (cost=107.18..13,491.19 rows=28 width=236) (actual time=0.037..0.129 rows=5 loops=1)

22. 0.006 0.076 ↑ 5.6 5 1

Nested Loop Left Join (cost=106.90..13,270.11 rows=28 width=220) (actual time=0.027..0.076 rows=5 loops=1)

23. 0.012 0.055 ↑ 5.6 5 1

Nested Loop (cost=106.63..13,250.21 rows=28 width=210) (actual time=0.023..0.055 rows=5 loops=1)

24. 0.001 0.023 ↑ 5.6 5 1

Append (cost=106.36..13,146.07 rows=28 width=174) (actual time=0.014..0.023 rows=5 loops=1)

25. 0.014 0.022 ↑ 5.6 5 1

Bitmap Heap Scan on eo_order _order (cost=106.36..13,146.07 rows=28 width=174) (actual time=0.014..0.022 rows=5 loops=1)

  • Recheck Cond: ((eaevn_event_id)::bigint = 3027809)
  • Filter: ((eoord_is_deleted)::bpchar = 'N'::bpchar)
  • Heap Blocks: exact=1
26. 0.008 0.008 ↑ 698.8 8 1

Bitmap Index Scan on eo_evn_ord_fk (cost=0.00..106.35 rows=5,590 width=0) (actual time=0.008..0.008 rows=8 loops=1)

  • Index Cond: ((eaevn_event_id)::bigint = 3027809)
27. 0.020 0.020 ↑ 1.0 1 5

Index Scan using ea_department_pk on ea_department department (cost=0.27..3.72 rows=1 width=44) (actual time=0.004..0.004 rows=1 loops=5)

  • Index Cond: ((eadep_department_id)::bigint = (_order.eadep_department_id)::bigint)
28. 0.015 0.015 ↑ 1.0 1 5

Index Scan using ea_department_pk on ea_department department_parent (cost=0.27..0.71 rows=1 width=26) (actual time=0.003..0.003 rows=1 loops=5)

  • Index Cond: ((eadep_department_id)::bigint = (department.eadep_parent_department_id)::bigint)
29. 0.010 0.045 ↑ 2.0 1 5

Append (cost=0.28..7.88 rows=2 width=16) (actual time=0.005..0.009 rows=1 loops=5)

30. 0.025 0.025 ↑ 1.0 1 5

Index Scan using eo_vehicle_pk on eo_vehicle vehicle (cost=0.28..4.15 rows=1 width=16) (actual time=0.004..0.005 rows=1 loops=5)

  • Index Cond: (eovhl_vehicle_id = (_order.eovhl_vehicle_id)::bigint)
31. 0.010 0.010 ↓ 0.0 0 5

Index Scan using eo_vehicle_aius_pkey on eo_vehicle_aius vehicle_1 (cost=0.28..3.72 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=5)

  • Index Cond: (eovhl_vehicle_id = (_order.eovhl_vehicle_id)::bigint)
32. 0.110 3.755 ↑ 1.7 754 1

Hash (cost=1,146.11..1,146.11 rows=1,284 width=18) (actual time=3.755..3.755 rows=754 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 46kB
33. 0.146 3.645 ↑ 1.7 754 1

Subquery Scan on cur_disp (cost=1,125.54..1,146.11 rows=1,284 width=18) (actual time=3.326..3.645 rows=754 loops=1)

34. 0.118 3.499 ↑ 1.7 754 1

Unique (cost=1,125.54..1,133.27 rows=1,284 width=191) (actual time=3.325..3.499 rows=754 loops=1)

35. 0.365 3.381 ↑ 2.0 757 1

Sort (cost=1,125.54..1,129.40 rows=1,545 width=191) (actual time=3.324..3.381 rows=757 loops=1)

  • Sort Key: dq.eovhl_vehicle_id, dsq.eddsv_create_ts DESC, (CASE dsq.eddsv_squad_status WHEN 'W'::bpchar THEN 0 ELSE 1 END)
  • Sort Method: quicksort Memory: 84kB
36. 0.416 3.016 ↑ 2.0 757 1

Nested Loop (cost=1.27..1,043.71 rows=1,545 width=191) (actual time=0.371..3.016 rows=757 loops=1)

37. 0.250 1.086 ↑ 1.7 757 1

Nested Loop (cost=0.84..352.54 rows=1,268 width=16) (actual time=0.338..1.086 rows=757 loops=1)

38. 0.036 0.412 ↑ 1.7 212 1

Nested Loop (cost=0.42..102.61 rows=353 width=8) (actual time=0.328..0.412 rows=212 loops=1)

39. 0.000 0.292 ↑ 1.0 2 1

Append (cost=0.00..50.01 rows=2 width=8) (actual time=0.290..0.292 rows=2 loops=1)

40. 0.292 0.292 ↑ 1.0 2 1

Seq Scan on eo_shift_date sh (cost=0.00..50.01 rows=2 width=8) (actual time=0.290..0.292 rows=2 loops=1)

  • Filter: ((eoshd_status)::bpchar = 'A'::bpchar)
  • Rows Removed by Filter: 2251
41. 0.084 0.084 ↑ 1.7 106 2

Index Scan using ed_shd_dis_fk on ed_disposition d (cost=0.42..24.53 rows=177 width=16) (actual time=0.021..0.042 rows=106 loops=2)

  • Index Cond: ((eoshd_shift_date_id)::bigint = sh.eoshd_shift_date_id)
42. 0.424 0.424 ↑ 1.2 4 212

Index Scan using ed_dis_dsq_fk on ed_disposition_squad dq (cost=0.42..0.66 rows=5 width=24) (actual time=0.002..0.002 rows=4 loops=212)

  • Index Cond: ((eddis_disposition_id)::bigint = d.eddis_disposition_id)
43. 1.514 1.514 ↑ 2.0 1 757

Index Scan using ed_dsq_dsv_fk on ed_disposition_squad_version dsq (cost=0.43..0.52 rows=2 width=28) (actual time=0.002..0.002 rows=1 loops=757)

  • Index Cond: ((eddsq_disposition_squad_id)::bigint = dq.eddsq_disposition_squad_id)
44. 0.020 0.050 ↑ 1.0 103 1

Hash (cost=3.03..3.03 rows=103 width=14) (actual time=0.050..0.050 rows=103 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
45. 0.030 0.030 ↑ 1.0 103 1

Seq Scan on eo_vehicle_type vehicle_type (cost=0.00..3.03 rows=103 width=14) (actual time=0.013..0.030 rows=103 loops=1)

46. 0.005 0.005 ↓ 0.0 0 5

Index Scan using eo_vehicle_trip_pk on eo_vehicle_trip trip (cost=0.28..0.45 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=5)

  • Index Cond: (eovtr_vehicle_trip_id = (cur_disp.eovtr_vehicle_trip_id)::bigint)
47. 0.000 0.000 ↓ 0.0 0 5

Index Scan using ea_department_pk on ea_department trip_department (cost=0.27..0.33 rows=1 width=19) (actual time=0.000..0.000 rows=0 loops=5)

  • Index Cond: ((eadep_department_id)::bigint = (trip.eadep_department_id)::bigint)
48. 0.010 0.050 ↑ 1.0 1 5

Nested Loop (cost=0.55..0.69 rows=1 width=32) (actual time=0.009..0.010 rows=1 loops=5)

49. 0.025 0.025 ↑ 1.0 1 5

Index Scan using eo_vtm_vehicle_fk on et_vehicle_telematics_mount vtm (cost=0.28..0.30 rows=1 width=32) (actual time=0.004..0.005 rows=1 loops=5)

  • Index Cond: ((eovhl_vehicle_id)::bigint = vehicle.eovhl_vehicle_id)
50. 0.015 0.015 ↑ 1.0 1 3

Index Scan using pk_eo_vehicle_telematics on eo_vehicle_telematics vt (cost=0.28..0.37 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=3)

  • Index Cond: (eovtm_vehicle_telematics_id = (vtm.eovtm_vehicle_telematics_id)::bigint)
  • Filter: ((COALESCE((eovtm_date_time)::timestamp with time zone, now()) >= (vtm.etvtm_start_ts)::timestamp with time zone) AND (COALESCE((eovtm_date_time)::timestamp with time zone, now()) <= (COALESCE(vtm.etvtm_end_ts, eovtm_date_time))::timestamp with time zone))
51. 0.015 0.015 ↓ 0.0 0 5

Index Scan using re_response_plan_pk on re_response_plan response_plan (cost=0.29..6.87 rows=1 width=70) (actual time=0.003..0.003 rows=0 loops=5)

  • Index Cond: (rerpl_response_plan_id = (_order.rerpl_response_plan_id)::bigint)
52. 0.005 0.005 ↓ 0.0 0 5

Index Scan using ea_ebb_pk on eb_building special_object (cost=0.29..8.16 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=5)

  • Index Cond: ((easob_special_object_id)::bigint = (_order.easob_special_object_id)::bigint)
53. 0.005 0.080 ↑ 1,510.0 1 5

Nested Loop Left Join (cost=1.14..9.37 rows=1,510 width=24) (actual time=0.015..0.016 rows=1 loops=5)

  • Join Filter: ((p.rerpl_is_object_plan)::bpchar = 'Y'::bpchar)
  • Rows Removed by Join Filter: 0
54. 0.006 0.060 ↑ 1.0 1 5

Nested Loop (cost=0.85..8.40 rows=1 width=34) (actual time=0.011..0.012 rows=1 loops=5)

55. 0.010 0.045 ↑ 1.0 1 5

Nested Loop (cost=0.57..7.75 rows=1 width=32) (actual time=0.008..0.009 rows=1 loops=5)

56. 0.020 0.020 ↑ 1.0 1 5

Index Scan using re_district_order_vehicle_ru on re_district_order_vehicle_rule vr (cost=0.29..7.45 rows=1 width=32) (actual time=0.003..0.004 rows=1 loops=5)

  • Index Cond: (redvr_district_order_vhl_rl_id = (_order.redvr_district_order_vhl_rl_id)::bigint)
57. 0.015 0.015 ↑ 1.0 1 3

Index Scan using pk_re_order_rule on re_order_rule r (cost=0.28..0.30 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=3)

  • Index Cond: (reorl_order_rule_id = (vr.reorl_order_rule_id)::bigint)
58. 0.009 0.009 ↑ 1.0 1 3

Index Scan using re_response_plan_pk on re_response_plan p (cost=0.29..0.64 rows=1 width=10) (actual time=0.003..0.003 rows=1 loops=3)

  • Index Cond: (rerpl_response_plan_id = (r.rerpl_response_plan_id)::bigint)
59. 0.015 0.015 ↓ 0.0 0 3

Index Scan using ea_rep_orp_fk on ea_special_object_response_plan sp (cost=0.29..0.94 rows=3 width=8) (actual time=0.005..0.005 rows=0 loops=3)

  • Index Cond: ((r.rerpl_response_plan_id)::bigint = (rerpl_response_plan_id)::bigint)
  • Filter: ((eaorp_active)::bpchar = 'Y'::bpchar)
60. 0.019 0.039 ↑ 1.0 103 1

Hash (cost=3.03..3.03 rows=103 width=14) (actual time=0.039..0.039 rows=103 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
61. 0.020 0.020 ↑ 1.0 103 1

Seq Scan on eo_vehicle_type vehicle_rule_vehicle_type (cost=0.00..3.03 rows=103 width=14) (actual time=0.004..0.020 rows=103 loops=1)

62. 2,627.013 6,700.189 ↑ 1.0 6,106,604 1

Hash (cost=192,778.25..192,778.25 rows=6,107,525 width=35) (actual time=6,700.189..6,700.189 rows=6,106,604 loops=1)

  • Buckets: 65536 Batches: 128 Memory Usage: 3010kB
63. 702.972 4,073.176 ↑ 1.0 6,106,604 1

Append (cost=0.00..192,778.25 rows=6,107,525 width=35) (actual time=0.030..4,073.176 rows=6,106,604 loops=1)

64. 2,460.932 2,460.932 ↑ 1.0 4,395,599 1

Seq Scan on em_message (cost=0.00..140,133.62 rows=4,396,362 width=30) (actual time=0.030..2,460.932 rows=4,395,599 loops=1)

65. 909.272 909.272 ↑ 1.0 1,711,005 1

Seq Scan on em_message_aius em_message_1 (cost=0.00..52,644.63 rows=1,711,163 width=48) (actual time=0.061..909.272 rows=1,711,005 loops=1)

66. 0.062 0.206 ↑ 1.0 314 1

Hash (cost=31.14..31.14 rows=314 width=26) (actual time=0.206..0.206 rows=314 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 27kB
67. 0.144 0.144 ↑ 1.0 314 1

Seq Scan on ea_department vehicle_rule_department (cost=0.00..31.14 rows=314 width=26) (actual time=0.014..0.144 rows=314 loops=1)

68.          

CTE order_status_log

69. 0.017 0.135 ↑ 324,819.6 5 1

Nested Loop (cost=951.75..3,836.61 rows=1,624,098 width=96) (actual time=0.096..0.135 rows=5 loops=1)

70. 0.016 0.018 ↑ 40.0 5 1

HashAggregate (cost=951.32..953.32 rows=200 width=8) (actual time=0.011..0.018 rows=5 loops=1)

  • Group Key: orders_1.id
71. 0.002 0.002 ↑ 8,456.2 5 1

CTE Scan on orders orders_1 (cost=0.00..845.62 rows=42,281 width=8) (actual time=0.001..0.002 rows=5 loops=1)

72. 0.100 0.100 ↑ 5.0 1 5

Index Scan using eo_order_status_log_eoord_order_id_idx on eo_order_status_log (cost=0.43..14.37 rows=5 width=96) (actual time=0.019..0.020 rows=1 loops=5)

  • Index Cond: ((eoord_order_id)::bigint = orders_1.id)
73. 0.057 12,284.971 ↑ 1,459,892,046.4 5 1

Merge Left Join (cost=1,508,573.18..238,749,578.03 rows=7,299,460,232 width=711) (actual time=12,284.957..12,284.971 rows=5 loops=1)

  • Merge Cond: (orders.id = (status_log.eoord_order_id)::bigint)
74. 0.018 6,738.671 ↑ 179,778.8 5 1

Sort (cost=584,347.30..586,594.54 rows=898,894 width=582) (actual time=6,738.670..6,738.671 rows=5 loops=1)

  • Sort Key: orders.id
  • Sort Method: quicksort Memory: 27kB
75. 0.013 6,738.653 ↑ 179,778.8 5 1

Merge Join (cost=14,841.24..28,451.61 rows=898,894 width=582) (actual time=6,738.647..6,738.653 rows=5 loops=1)

  • Merge Cond: ((event.eaevn_event_id)::bigint = (orders.event_id)::bigint)
76. 0.004 0.048 ↑ 4,252.0 1 1

Sort (cost=341.31..351.94 rows=4,252 width=40) (actual time=0.048..0.048 rows=1 loops=1)

  • Sort Key: event.eaevn_event_id
  • Sort Method: quicksort Memory: 25kB
77. 0.044 0.044 ↑ 4,252.0 1 1

CTE Scan on event (cost=0.00..85.04 rows=4,252 width=40) (actual time=0.035..0.044 rows=1 loops=1)

78. 0.007 6,738.592 ↑ 8,456.2 5 1

Materialize (cost=14,499.93..14,711.34 rows=42,281 width=550) (actual time=6,738.590..6,738.592 rows=5 loops=1)

79. 0.010 6,738.585 ↑ 8,456.2 5 1

Sort (cost=14,499.93..14,605.64 rows=42,281 width=550) (actual time=6,738.585..6,738.585 rows=5 loops=1)

  • Sort Key: orders.event_id
  • Sort Method: quicksort Memory: 26kB
80. 6,738.575 6,738.575 ↑ 8,456.2 5 1

CTE Scan on orders (cost=0.00..845.62 rows=42,281 width=550) (actual time=6,705.228..6,738.575 rows=5 loops=1)

81. 0.007 5,546.243 ↑ 324,819.6 5 1

Materialize (cost=924,225.88..932,346.37 rows=1,624,098 width=165) (actual time=5,546.240..5,546.243 rows=5 loops=1)

82. 0.027 5,546.236 ↑ 324,819.6 5 1

Sort (cost=924,225.88..928,286.12 rows=1,624,098 width=165) (actual time=5,546.235..5,546.236 rows=5 loops=1)

  • Sort Key: status_log.eoord_order_id
  • Sort Method: quicksort Memory: 25kB
83. 0.020 5,546.209 ↑ 324,819.6 5 1

Hash Left Join (cost=299,244.47..490,235.37 rows=1,624,098 width=165) (actual time=5,517.381..5,546.209 rows=5 loops=1)

  • Hash Cond: ((status_log.eadsk_desk_id)::bigint = (status_log_desk.eadsk_desk_id)::bigint)
84. 0.019 5,546.090 ↑ 324,819.6 5 1

Hash Left Join (cost=299,235.78..469,779.41 rows=1,624,098 width=149) (actual time=5,517.265..5,546.090 rows=5 loops=1)

  • Hash Cond: ((status_log.eausr_user_id)::bigint = (status_log_user.eausr_user_id)::bigint)
85. 0.028 5,543.144 ↑ 324,819.6 5 1

Hash Left Join (cost=298,946.78..448,988.50 rows=1,624,098 width=100) (actual time=5,514.322..5,543.144 rows=5 loops=1)

  • Hash Cond: ((status_log_message.emstm_standard_message_id)::bigint = (status_log_standard_message.emstm_standard_message_id)::bigint)
86. 29.072 5,543.055 ↑ 324,819.6 5 1

Hash Left Join (cost=298,944.31..428,624.23 rows=1,624,098 width=72) (actual time=5,514.235..5,543.055 rows=5 loops=1)

  • Hash Cond: ((status_log.emmsg_mesage_id)::bigint = (status_log_message.emmsg_mesage_id)::bigint)
87. 0.148 0.148 ↑ 324,819.6 5 1

CTE Scan on order_status_log status_log (cost=0.00..32,481.96 rows=1,624,098 width=64) (actual time=0.102..0.148 rows=5 loops=1)

88. 2,013.205 5,513.835 ↑ 1.0 6,106,604 1

Hash (cost=192,778.25..192,778.25 rows=6,107,525 width=16) (actual time=5,513.835..5,513.835 rows=6,106,604 loops=1)

  • Buckets: 131072 Batches: 128 Memory Usage: 3128kB
89. 657.293 3,500.630 ↑ 1.0 6,106,604 1

Append (cost=0.00..192,778.25 rows=6,107,525 width=16) (actual time=0.087..3,500.630 rows=6,106,604 loops=1)

90. 2,027.590 2,027.590 ↑ 1.0 4,395,599 1

Seq Scan on em_message status_log_message (cost=0.00..140,133.62 rows=4,396,362 width=16) (actual time=0.086..2,027.590 rows=4,395,599 loops=1)

91. 815.747 815.747 ↑ 1.0 1,711,005 1

Seq Scan on em_message_aius status_log_message_1 (cost=0.00..52,644.63 rows=1,711,163 width=16) (actual time=0.033..815.747 rows=1,711,005 loops=1)

92. 0.038 0.061 ↓ 1.1 71 1

Hash (cost=1.65..1.65 rows=65 width=44) (actual time=0.061..0.061 rows=71 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
93. 0.023 0.023 ↓ 1.1 71 1

Seq Scan on em_standard_message status_log_standard_message (cost=0.00..1.65 rows=65 width=44) (actual time=0.012..0.023 rows=71 loops=1)

94. 1.470 2.927 ↓ 1.0 6,181 1

Hash (cost=211.78..211.78 rows=6,178 width=57) (actual time=2.927..2.927 rows=6,181 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 612kB
95. 1.457 1.457 ↓ 1.0 6,181 1

Seq Scan on ea_user status_log_user (cost=0.00..211.78 rows=6,178 width=57) (actual time=0.009..1.457 rows=6,181 loops=1)

96. 0.053 0.099 ↑ 1.0 253 1

Hash (cost=5.53..5.53 rows=253 width=24) (actual time=0.099..0.099 rows=253 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
97. 0.046 0.046 ↑ 1.0 253 1

Seq Scan on ea_desk status_log_desk (cost=0.00..5.53 rows=253 width=24) (actual time=0.011..0.046 rows=253 loops=1)

Planning time : 11.606 ms
Execution time : 12,285.773 ms