explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dMDy

Settings
# exclusive inclusive rows x rows loops node
1. 580.966 2,618.130 ↑ 1.6 1,024 1

Result (cost=31,097.52..132,611.01 rows=1,619 width=3,598) (actual time=1,910.220..2,618.130 rows=1,024 loops=1)

2. 52.145 1,893.775 ↑ 1.6 1,024 1

Sort (cost=31,097.52..31,101.56 rows=1,619 width=2,277) (actual time=1,893.644..1,893.775 rows=1,024 loops=1)

  • Sort Key: lit.name, li.client_entity_seq_id
  • Sort Method: quicksort Memory: 582kB
3. 77.866 1,841.630 ↑ 1.6 1,024 1

GroupAggregate (cost=30,671.23..31,011.22 rows=1,619 width=2,277) (actual time=1,763.244..1,841.630 rows=1,024 loops=1)

  • Group Key: li.id, bi.id, bitz.time_zone, lit.id, tz.time_zone, cur.id, sct.id, csd.id, ssct.name, po.id, c.id, sdc.short_name, rel.id, drt.name, ilis.marked_duplicate, bulk_request_data.entity_id, bulk_request_data.task_id, ilicd.id
4. 89.030 1,763.764 ↓ 3.1 5,024 1

Sort (cost=30,671.23..30,675.27 rows=1,619 width=1,314) (actual time=1,763.225..1,763.764 rows=5,024 loops=1)

  • Sort Key: li.id, bi.id, bitz.time_zone, lit.id, tz.time_zone, cur.id, sct.id, csd.id, ssct.name, po.id, c.id, sdc.short_name, rel.id, drt.name, ilis.marked_duplicate, bulk_request_data.entity_id, bulk_request_data.task_id, ilicd.id
  • Sort Method: quicksort Memory: 2788kB
5. 34.679 1,674.734 ↓ 3.1 5,024 1

Nested Loop Left Join (cost=24,070.25..30,584.93 rows=1,619 width=1,314) (actual time=142.250..1,674.734 rows=5,024 loops=1)

6. 2.941 1,464.215 ↓ 9.4 5,024 1

Hash Left Join (cost=24,069.68..29,103.31 rows=532 width=1,262) (actual time=142.229..1,464.215 rows=5,024 loops=1)

  • Hash Cond: (li.id = bulk_request_data.entity_id)
7. 69.480 1,461.246 ↓ 9.4 5,024 1

Hash Left Join (cost=23,975.22..29,006.84 rows=532 width=1,254) (actual time=142.186..1,461.246 rows=5,024 loops=1)

  • Hash Cond: (li.discrepancy_reason_id = drt.id)
8. 51.512 1,391.718 ↓ 9.4 5,024 1

Hash Left Join (cost=23,971.38..29,001.60 rows=532 width=1,232) (actual time=142.124..1,391.718 rows=5,024 loops=1)

  • Hash Cond: (li.relation_id = rel.id)
9. 3.123 1,339.891 ↓ 9.4 5,024 1

Hash Left Join (cost=23,902.40..28,931.21 rows=532 width=1,214) (actual time=141.797..1,339.891 rows=5,024 loops=1)

  • Hash Cond: (csd.currency_id = sdc.id)
10. 125.218 1,336.671 ↓ 9.4 5,024 1

Hash Left Join (cost=23,895.49..28,922.87 rows=532 width=1,214) (actual time=141.679..1,336.671 rows=5,024 loops=1)

  • Hash Cond: (bi.contract_id = c.id)
11. 2.821 1,177.693 ↓ 9.4 5,024 1

Hash Left Join (cost=23,505.92..28,531.91 rows=532 width=1,194) (actual time=107.897..1,177.693 rows=5,024 loops=1)

  • Hash Cond: (li.po_id = po.id)
12. 35.166 1,174.797 ↓ 9.4 5,024 1

Hash Left Join (cost=23,497.68..28,522.27 rows=532 width=1,182) (actual time=107.810..1,174.797 rows=5,024 loops=1)

  • Hash Cond: (ssct.service_category_id = sct.id)
13. 29.469 1,139.510 ↓ 9.4 5,024 1

Hash Left Join (cost=23,487.67..28,510.86 rows=532 width=1,162) (actual time=107.674..1,139.510 rows=5,024 loops=1)

  • Hash Cond: (csd.service_sub_category_id = ssct.id)
14. 114.246 1,109.842 ↓ 9.4 5,024 1

Nested Loop Left Join (cost=23,472.65..28,494.43 rows=532 width=1,139) (actual time=107.465..1,109.842 rows=5,024 loops=1)

15. 2.795 940.332 ↓ 9.4 5,024 1

Hash Left Join (cost=23,472.36..27,740.37 rows=532 width=1,082) (actual time=107.450..940.332 rows=5,024 loops=1)

  • Hash Cond: (li.currency_id = cur.id)
16. 43.043 937.444 ↓ 9.4 5,024 1

Hash Left Join (cost=23,465.45..27,732.02 rows=532 width=1,078) (actual time=107.344..937.444 rows=5,024 loops=1)

  • Hash Cond: (li.time_zone_id = tz.id)
17. 44.220 894.380 ↓ 9.4 5,024 1

Hash Left Join (cost=23,463.53..27,728.56 rows=532 width=1,066) (actual time=107.312..894.380 rows=5,024 loops=1)

  • Hash Cond: (li.line_item_type = lit.id)
18. 3.277 850.090 ↓ 9.4 5,024 1

Hash Left Join (cost=23,458.04..27,721.64 rows=532 width=1,040) (actual time=107.229..850.090 rows=5,024 loops=1)

  • Hash Cond: (li.invoice_id = bi.id)
19. 341.702 846.758 ↓ 9.4 5,024 1

Hash Right Join (cost=23,453.85..27,710.13 rows=532 width=1,001) (actual time=107.155..846.758 rows=5,024 loops=1)

  • Hash Cond: (ilis.line_item_id = li.id)
20. 398.010 398.010 ↓ 1.0 193,673 1

Seq Scan on invoice_line_item_state ilis (cost=0.00..3,748.07 rows=193,607 width=5) (actual time=0.006..398.010 rows=193,673 loops=1)

21. 0.975 107.046 ↓ 1.9 1,024 1

Hash (cost=23,447.20..23,447.20 rows=532 width=1,000) (actual time=107.046..107.046 rows=1,024 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 221kB
22. 59.909 106.071 ↓ 1.9 1,024 1

Index Scan using idx_invoice_id on invoice_line_item li (cost=0.44..23,447.20 rows=532 width=1,000) (actual time=0.082..106.071 rows=1,024 loops=1)

  • Index Cond: (invoice_id = 5365)
  • Filter: ((NOT deleted) AND (NOT saved_as_draft) AND (client_id = 1005) AND (status_id = ANY ('{5,1,6,2,7255,7254,4322,4323,4321,4325,4324}'::integer[])) AND COALESCE(NULLIF((alternatives: SubPlan 15 or hashed SubPlan 16), false), NULLIF((alternatives: SubPlan 17 or hashed SubPlan 18), false), NULLIF((SubPlan 19), false), NULLIF((SubPlan 20), false), NULLIF((SubPlan 21), false)))
  • Rows Removed by Filter: 1
23.          

SubPlan (forIndex Scan)

24. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..3.84 rows=1 width=0) (never executed)

  • Join Filter: (sda.data_id = ed.id)
25. 0.000 0.000 ↓ 0.0 0

Seq Scan on secondary_data_access sda (cost=0.00..1.19 rows=1 width=4) (never executed)

  • Filter: (user_id = 1232)
26. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_entity_data_entity_type_id_entity_id on entity_data ed (cost=0.42..2.64 rows=1 width=4) (never executed)

  • Index Cond: ((entity_type_id = 61) AND (li.contract_id = entity_id))
27. 0.000 0.007 ↓ 0.0 0 1

Nested Loop (cost=0.42..3.83 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=1)

28. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on secondary_data_access sda_1 (cost=0.00..1.19 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (user_id = 1232)
  • Rows Removed by Filter: 17
29. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_entity_data on entity_data ed_1 (cost=0.42..2.64 rows=1 width=8) (never executed)

  • Index Cond: (id = sda_1.data_id)
  • Filter: (entity_type_id = 61)
30. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..3.84 rows=1 width=0) (never executed)

  • Join Filter: (sda_2.data_id = ed_2.id)
31. 0.000 0.000 ↓ 0.0 0

Seq Scan on secondary_data_access sda_2 (cost=0.00..1.19 rows=1 width=4) (never executed)

  • Filter: (user_id = 1232)
32. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_entity_data_entity_type_id_entity_id on entity_data ed_2 (cost=0.42..2.64 rows=1 width=4) (never executed)

  • Index Cond: ((entity_type_id = 1) AND (li.relation_id = entity_id))
33. 0.000 0.003 ↓ 0.0 0 1

Nested Loop (cost=0.42..3.83 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=1)

34. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on secondary_data_access sda_3 (cost=0.00..1.19 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (user_id = 1232)
  • Rows Removed by Filter: 17
35. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_entity_data on entity_data ed_3 (cost=0.42..2.64 rows=1 width=8) (never executed)

  • Index Cond: (id = sda_3.data_id)
  • Filter: (entity_type_id = 1)
36. 0.000 46.080 ↑ 1.0 1 1,024

Nested Loop (cost=0.86..4.20 rows=1 width=0) (actual time=0.045..0.045 rows=1 loops=1,024)

37. 3.072 3.072 ↑ 1.0 1 1,024

Index Scan using pk_invoice_line_item on invoice_line_item et (cost=0.44..2.66 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=1,024)

  • Index Cond: (id = li.id)
38. 43.008 43.008 ↑ 1.0 1 1,024

Index Only Scan using user_data_read_access_uk1 on user_data_read_access udr (cost=0.42..1.55 rows=1 width=4) (actual time=0.042..0.042 rows=1 loops=1,024)

  • Index Cond: ((user_id = 1232) AND (entity_type_id = 64) AND (entity_id = et.service_data_id))
  • Heap Fetches: 0
39. 0.009 0.072 ↑ 1.0 1 9

Nested Loop (cost=0.86..4.20 rows=1 width=0) (actual time=0.008..0.008 rows=1 loops=9)

40. 0.027 0.027 ↑ 1.0 1 9

Index Scan using pk_invoice_line_item on invoice_line_item et_1 (cost=0.44..2.66 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=9)

  • Index Cond: (id = li.id)
41. 0.036 0.036 ↑ 1.0 1 9

Index Only Scan using user_data_read_access_uk1 on user_data_read_access udr_1 (cost=0.42..1.55 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=9)

  • Index Cond: ((user_id = 1232) AND (entity_type_id = 61) AND (entity_id = et_1.contract_id))
  • Heap Fetches: 0
42. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.86..4.20 rows=1 width=0) (never executed)

43. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_invoice_line_item on invoice_line_item et_2 (cost=0.44..2.66 rows=1 width=4) (never executed)

  • Index Cond: (id = li.id)
44. 0.000 0.000 ↓ 0.0 0

Index Only Scan using user_data_read_access_uk1 on user_data_read_access udr_2 (cost=0.42..1.55 rows=1 width=4) (never executed)

  • Index Cond: ((user_id = 1232) AND (entity_type_id = 1) AND (entity_id = et_2.relation_id))
  • Heap Fetches: 0
45. 0.003 0.055 ↑ 1.0 1 1

Hash (cost=4.18..4.18 rows=1 width=43) (actual time=0.055..0.055 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
46. 0.022 0.052 ↑ 1.0 1 1

Hash Right Join (cost=2.65..4.18 rows=1 width=43) (actual time=0.040..0.052 rows=1 loops=1)

  • Hash Cond: (bitz.id = bi.time_zone_id)
47. 0.007 0.007 ↑ 1.0 41 1

Seq Scan on time_zone bitz (cost=0.00..1.41 rows=41 width=20) (actual time=0.003..0.007 rows=41 loops=1)

48. 0.007 0.023 ↑ 1.0 1 1

Hash (cost=2.64..2.64 rows=1 width=31) (actual time=0.023..0.023 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
49. 0.016 0.016 ↑ 1.0 1 1

Index Scan using invoice_id_indx on base_invoice bi (cost=0.42..2.64 rows=1 width=31) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: (id = 5365)
50. 0.037 0.070 ↑ 1.0 155 1

Hash (cost=3.55..3.55 rows=155 width=26) (actual time=0.070..0.070 rows=155 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
51. 0.033 0.033 ↑ 1.0 155 1

Seq Scan on line_item_type lit (cost=0.00..3.55 rows=155 width=26) (actual time=0.004..0.033 rows=155 loops=1)

52. 0.012 0.021 ↑ 1.0 41 1

Hash (cost=1.41..1.41 rows=41 width=20) (actual time=0.021..0.021 rows=41 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
53. 0.009 0.009 ↑ 1.0 41 1

Seq Scan on time_zone tz (cost=0.00..1.41 rows=41 width=20) (actual time=0.002..0.009 rows=41 loops=1)

54. 0.042 0.093 ↑ 1.0 174 1

Hash (cost=4.74..4.74 rows=174 width=8) (actual time=0.093..0.093 rows=174 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
55. 0.051 0.051 ↑ 1.0 174 1

Seq Scan on currency cur (cost=0.00..4.74 rows=174 width=8) (actual time=0.005..0.051 rows=174 loops=1)

56. 55.264 55.264 ↑ 1.0 1 5,024

Index Scan using pk_contract_service_data on contract_service_data csd (cost=0.29..1.42 rows=1 width=57) (actual time=0.011..0.011 rows=1 loops=5,024)

  • Index Cond: (id = li.service_data_id)
57. 0.108 0.199 ↑ 1.0 401 1

Hash (cost=10.01..10.01 rows=401 width=31) (actual time=0.199..0.199 rows=401 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
58. 0.091 0.091 ↑ 1.0 401 1

Seq Scan on service_sub_category ssct (cost=0.00..10.01 rows=401 width=31) (actual time=0.004..0.091 rows=401 loops=1)

59. 0.065 0.121 ↑ 1.0 267 1

Hash (cost=6.67..6.67 rows=267 width=24) (actual time=0.121..0.121 rows=267 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
60. 0.056 0.056 ↑ 1.0 267 1

Seq Scan on service_category sct (cost=0.00..6.67 rows=267 width=24) (actual time=0.004..0.056 rows=267 loops=1)

61. 0.034 0.075 ↑ 1.0 144 1

Hash (cost=6.44..6.44 rows=144 width=12) (actual time=0.075..0.075 rows=144 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
62. 0.041 0.041 ↑ 1.0 144 1

Seq Scan on purchase_order po (cost=0.00..6.44 rows=144 width=12) (actual time=0.004..0.041 rows=144 loops=1)

63. 32.733 33.760 ↓ 1.0 2,515 1

Hash (cost=358.14..358.14 rows=2,514 width=24) (actual time=33.760..33.760 rows=2,515 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 173kB
64. 1.027 1.027 ↓ 1.0 2,515 1

Seq Scan on contract c (cost=0.00..358.14 rows=2,514 width=24) (actual time=0.005..1.027 rows=2,515 loops=1)

65. 0.045 0.097 ↑ 1.0 174 1

Hash (cost=4.74..4.74 rows=174 width=8) (actual time=0.097..0.097 rows=174 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
66. 0.052 0.052 ↑ 1.0 174 1

Seq Scan on currency sdc (cost=0.00..4.74 rows=174 width=8) (actual time=0.006..0.052 rows=174 loops=1)

67. 0.112 0.315 ↓ 1.0 400 1

Hash (cost=63.99..63.99 rows=399 width=22) (actual time=0.315..0.315 rows=400 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
68. 0.203 0.203 ↓ 1.0 400 1

Seq Scan on relation rel (cost=0.00..63.99 rows=399 width=22) (actual time=0.007..0.203 rows=400 loops=1)

69. 0.026 0.048 ↑ 1.0 82 1

Hash (cost=2.82..2.82 rows=82 width=30) (actual time=0.048..0.048 rows=82 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
70. 0.022 0.022 ↑ 1.0 82 1

Seq Scan on discrepancy_reason_type drt (cost=0.00..2.82 rows=82 width=30) (actual time=0.005..0.022 rows=82 loops=1)

71. 0.000 0.028 ↓ 0.0 0 1

Hash (cost=94.45..94.45 rows=1 width=8) (actual time=0.028..0.028 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
72. 0.001 0.028 ↓ 0.0 0 1

Subquery Scan on bulk_request_data (cost=94.43..94.45 rows=1 width=8) (actual time=0.028..0.028 rows=0 loops=1)

73. 0.000 0.027 ↓ 0.0 0 1

Group (cost=94.43..94.44 rows=1 width=8) (actual time=0.027..0.027 rows=0 loops=1)

  • Group Key: ebep.entity_id, ut.id
74. 0.008 0.027 ↓ 0.0 0 1

Sort (cost=94.43..94.43 rows=1 width=8) (actual time=0.027..0.027 rows=0 loops=1)

  • Sort Key: ebep.entity_id, ut.id
  • Sort Method: quicksort Memory: 25kB
75. 0.001 0.019 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.86..94.42 rows=1 width=8) (actual time=0.019..0.019 rows=0 loops=1)

76. 0.000 0.018 ↓ 0.0 0 1

Nested Loop (cost=0.57..3.31 rows=1 width=8) (actual time=0.018..0.018 rows=0 loops=1)

77. 0.018 0.018 ↓ 0.0 0 1

Index Scan using idx_ebep_entity_type_id_entity_id on entity_bulk_edit_pending ebep (cost=0.29..1.90 rows=1 width=8) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: (entity_type_id = 165)
  • Filter: (NOT is_request_processed)
78. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_bulk_edit_request on bulk_edit_request ber (cost=0.29..1.41 rows=1 width=4) (never executed)

  • Index Cond: (id = ebep.bulk_edit_request_id)
  • Heap Fetches: 0
79. 0.000 0.000 ↓ 0.0 0

Index Scan using job_id_request_id on user_tasks ut (cost=0.29..91.10 rows=1 width=8) (never executed)

  • Index Cond: (request_id = ber.id)
  • Filter: (user_id = 1232)
80. 175.840 175.840 ↑ 1.0 1 5,024

Index Scan using idx_line_item_id on invoice_line_item_amount_fields ilicd (cost=0.57..2.79 rows=1 width=56) (actual time=0.035..0.035 rows=1 loops=5,024)

  • Index Cond: (line_item_id = li.id)
81.          

SubPlan (forResult)

82. 0.000 0.000 ↓ 0.0 0

Seq Scan on blocked_entity (cost=0.00..17.36 rows=1 width=0) (never executed)

  • Filter: ((entity_id = li.id) AND (entity_type_id = 165))
83. 0.000 0.000 ↓ 0.0 0

Seq Scan on blocked_entity blocked_entity_1 (cost=0.00..16.14 rows=1 width=4) (never executed)

  • Filter: (entity_type_id = 165)
84. 0.000 0.000 ↓ 0.0 0

Seq Scan on blocked_entity blocked_entity_2 (cost=0.00..17.36 rows=1 width=0) (never executed)

  • Filter: ((entity_id = li.id) AND (entity_type_id = 165))
85. 16.413 16.413 ↓ 0.0 0 1

Seq Scan on blocked_entity blocked_entity_3 (cost=0.00..16.14 rows=1 width=4) (actual time=16.413..16.413 rows=0 loops=1)

  • Filter: (entity_type_id = 165)
  • Rows Removed by Filter: 491
86. 4.096 4.096 ↑ 1.0 1 1,024

Index Scan using pk_work_flow_status on work_flow_status (cost=0.28..2.50 rows=1 width=18) (actual time=0.004..0.004 rows=1 loops=1,024)

  • Index Cond: (id = bi.status_id)
87. 77.824 77.824 ↑ 1.0 1 1,024

Index Scan using pk_work_flow_status on work_flow_status work_flow_status_1 (cost=0.28..2.50 rows=1 width=18) (actual time=0.076..0.076 rows=1 loops=1,024)

  • Index Cond: (id = li.status_id)
88. 0.000 0.000 ↓ 0.0 0

Seq Scan on region (cost=0.00..1.90 rows=1 width=8) (never executed)

  • Filter: (id = li.attribute_value)
89. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_delivery_country on delivery_country (cost=0.15..2.37 rows=1 width=12) (never executed)

  • Index Cond: (id = li.attribute_value)
90. 0.000 0.000 ↓ 0.0 0

Seq Scan on department (cost=0.00..1.16 rows=1 width=9) (never executed)

  • Filter: (id = li.attribute_value)
91. 0.000 0.000 ↓ 0.0 0 1,024

Index Scan using pk_currency on currency (cost=0.14..2.36 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1,024)

  • Index Cond: (id = li.system_currency_id)
92. 3.072 7.168 ↑ 1.0 1 1,024

Aggregate (cost=4.12..4.13 rows=1 width=32) (actual time=0.007..0.007 rows=1 loops=1,024)

93. 1.988 4.096 ↓ 0.0 0 1,024

Hash Right Join (cost=2.52..4.11 rows=1 width=10) (actual time=0.004..0.004 rows=0 loops=1,024)

  • Hash Cond: (ct.id = lef.function_id)
94. 0.060 0.060 ↑ 1.0 42 15

Seq Scan on contract_type ct (cost=0.00..1.42 rows=42 width=14) (actual time=0.001..0.004 rows=42 loops=15)

95. 0.000 2.048 ↓ 0.0 0 1,024

Hash (cost=2.51..2.51 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1,024)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
96. 2.048 2.048 ↓ 0.0 0 1,024

Index Scan using idx_link_entity_function_6 on link_entity_function lef (cost=0.29..2.51 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1,024)

  • Index Cond: ((li.service_data_id = entity_id) AND (entity_type_id = 64))
97. 2.048 4.096 ↑ 1.0 1 1,024

Aggregate (cost=5.04..5.05 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=1,024)

98. 0.000 2.048 ↓ 0.0 0 1,024

Nested Loop Left Join (cost=0.56..5.04 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1,024)

99. 2.048 2.048 ↓ 0.0 0 1,024

Index Scan using idx_link_entity_service_6 on link_entity_service les (cost=0.42..2.64 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1,024)

  • Index Cond: ((li.service_data_id = entity_id) AND (entity_type_id = 64))
100. 0.015 0.015 ↑ 1.0 1 15

Index Scan using pk_contract_sub_type on contract_sub_type cst (cost=0.14..2.36 rows=1 width=20) (actual time=0.001..0.001 rows=1 loops=15)

  • Index Cond: (les.service_id = id)
101. 33.792 33.792 ↑ 1.0 1 1,024

Index Scan using pk_unit_type on unit_type (cost=0.14..2.36 rows=1 width=8) (actual time=0.001..0.033 rows=1 loops=1,024)

  • Index Cond: (id = li.unit_type_id)
102. 0.000 0.000 ↓ 0.0 0 1,024

Index Scan using pk_unit_type on unit_type unit_type_1 (cost=0.14..2.36 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=1,024)

  • Index Cond: (id = li.system_unit_id)