explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CB24

Settings
# exclusive inclusive rows x rows loops node
1. 340.751 2,630.224 ↑ 1.6 1,024 1

Result (cost=37,744.36..138,066.53 rows=1,600 width=3,604) (actual time=2,091.644..2,630.224 rows=1,024 loops=1)

2. 193.911 2,050.779 ↑ 1.6 1,024 1

Sort (cost=37,744.36..37,748.36 rows=1,600 width=2,283) (actual time=2,048.893..2,050.779 rows=1,024 loops=1)

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

GroupAggregate (cost=30,327.21..37,659.21 rows=1,600 width=2,283) (actual time=1,785.371..1,856.868 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. 149.404 1,789.332 ↓ 3.1 5,024 1

Sort (cost=30,327.21..30,331.21 rows=1,600 width=1,218) (actual time=1,784.956..1,789.332 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. 24.028 1,639.928 ↓ 3.1 5,024 1

Nested Loop Left Join (cost=23,750.59..30,242.06 rows=1,600 width=1,218) (actual time=118.177..1,639.928 rows=5,024 loops=1)

6. 26.955 1,445.084 ↓ 9.6 5,024 1

Hash Left Join (cost=23,750.02..28,777.15 rows=526 width=1,166) (actual time=118.157..1,445.084 rows=5,024 loops=1)

  • Hash Cond: (li.id = bulk_request_data.entity_id)
7. 2.779 1,418.099 ↓ 9.6 5,024 1

Hash Left Join (cost=23,655.56..28,680.71 rows=526 width=1,158) (actual time=118.112..1,418.099 rows=5,024 loops=1)

  • Hash Cond: (li.discrepancy_reason_id = drt.id)
8. 63.895 1,415.269 ↓ 9.6 5,024 1

Hash Left Join (cost=23,651.71..28,675.48 rows=526 width=1,136) (actual time=118.048..1,415.269 rows=5,024 loops=1)

  • Hash Cond: (li.relation_id = rel.id)
9. 3.179 1,351.059 ↓ 9.6 5,024 1

Hash Left Join (cost=23,582.73..28,605.11 rows=526 width=1,118) (actual time=117.721..1,351.059 rows=5,024 loops=1)

  • Hash Cond: (csd.currency_id = sdc.id)
10. 77.421 1,347.778 ↓ 9.6 5,024 1

Hash Left Join (cost=23,575.82..28,596.78 rows=526 width=1,118) (actual time=117.601..1,347.778 rows=5,024 loops=1)

  • Hash Cond: (bi.contract_id = c.id)
11. 2.811 1,268.569 ↓ 9.6 5,024 1

Hash Left Join (cost=23,186.25..28,205.84 rows=526 width=1,098) (actual time=115.785..1,268.569 rows=5,024 loops=1)

  • Hash Cond: (li.po_id = po.id)
12. 22.615 1,265.670 ↓ 9.6 5,024 1

Hash Left Join (cost=23,178.01..28,196.22 rows=526 width=1,086) (actual time=115.680..1,265.670 rows=5,024 loops=1)

  • Hash Cond: (ssct.service_category_id = sct.id)
13. 58.268 1,242.916 ↓ 9.6 5,024 1

Hash Left Join (cost=23,168.01..28,184.82 rows=526 width=1,066) (actual time=115.521..1,242.916 rows=5,024 loops=1)

  • Hash Cond: (csd.service_sub_category_id = ssct.id)
14. 8.621 1,168.155 ↓ 9.6 5,024 1

Nested Loop Left Join (cost=23,152.98..28,168.40 rows=526 width=1,043) (actual time=99.012..1,168.155 rows=5,024 loops=1)

15. 37.037 928.430 ↓ 9.6 5,024 1

Hash Left Join (cost=23,152.70..27,420.57 rows=526 width=986) (actual time=98.994..928.430 rows=5,024 loops=1)

  • Hash Cond: (li.currency_id = cur.id)
16. 42.376 891.298 ↓ 9.6 5,024 1

Hash Left Join (cost=23,145.78..27,412.24 rows=526 width=982) (actual time=98.870..891.298 rows=5,024 loops=1)

  • Hash Cond: (li.time_zone_id = tz.id)
17. 10.451 848.900 ↓ 9.6 5,024 1

Hash Left Join (cost=23,143.86..27,408.79 rows=526 width=970) (actual time=98.835..848.900 rows=5,024 loops=1)

  • Hash Cond: (li.line_item_type = lit.id)
18. 43.658 838.370 ↓ 9.6 5,024 1

Hash Left Join (cost=23,138.37..27,401.89 rows=526 width=944) (actual time=98.740..838.370 rows=5,024 loops=1)

  • Hash Cond: (li.invoice_id = bi.id)
19. 425.690 794.652 ↓ 9.6 5,024 1

Hash Right Join (cost=23,134.18..27,390.47 rows=526 width=905) (actual time=98.662..794.652 rows=5,024 loops=1)

  • Hash Cond: (ilis.line_item_id = li.id)
20. 270.408 270.408 ↓ 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.008..270.408 rows=193,673 loops=1)

21. 0.964 98.554 ↓ 1.9 1,024 1

Hash (cost=23,127.61..23,127.61 rows=526 width=904) (actual time=98.554..98.554 rows=1,024 loops=1)

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

Index Scan using idx_invoice_id on invoice_line_item li (cost=0.44..23,127.61 rows=526 width=904) (actual time=0.094..97.590 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.001 0.009 ↓ 0.0 0 1

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

28. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on secondary_data_access sda_1 (cost=0.00..1.19 rows=1 width=4) (actual time=0.008..0.008 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 13.312 ↑ 1.0 1 1,024

Nested Loop (cost=0.86..4.20 rows=1 width=0) (actual time=0.013..0.013 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. 10.240 10.240 ↑ 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.010..0.010 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.018 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.027 0.027 ↑ 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.003..0.003 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.004 0.060 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
46. 0.024 0.056 ↑ 1.0 1 1

Hash Right Join (cost=2.65..4.18 rows=1 width=43) (actual time=0.044..0.056 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.004..0.007 rows=41 loops=1)

48. 0.006 0.025 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
49. 0.019 0.019 ↑ 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.019..0.019 rows=1 loops=1)

  • Index Cond: (id = 5365)
50. 0.041 0.079 ↑ 1.0 155 1

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

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

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

52. 0.012 0.022 ↑ 1.0 41 1

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

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

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

54. 0.043 0.095 ↑ 1.0 174 1

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

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

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

56. 231.104 231.104 ↑ 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.046..0.046 rows=1 loops=5,024)

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

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

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

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

59. 0.072 0.139 ↑ 1.0 267 1

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

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

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

61. 0.038 0.088 ↑ 1.0 144 1

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

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

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

63. 0.689 1.788 ↓ 1.0 2,515 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 173kB
64. 1.099 1.099 ↓ 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.099 rows=2,515 loops=1)

65. 0.046 0.102 ↑ 1.0 174 1

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

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

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

67. 0.104 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.211 0.211 ↓ 1.0 400 1

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

69. 0.029 0.051 ↑ 1.0 82 1

Hash (cost=2.82..2.82 rows=82 width=30) (actual time=0.051..0.051 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.004..0.022 rows=82 loops=1)

71. 0.000 0.030 ↓ 0.0 0 1

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

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

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

73. 0.000 0.029 ↓ 0.0 0 1

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

  • Group Key: ebep.entity_id, ut.id
74. 0.011 0.029 ↓ 0.0 0 1

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

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

Nested Loop Left Join (cost=0.86..94.42 rows=1 width=8) (actual time=0.018..0.018 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.017..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. 170.816 170.816 ↑ 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.034..0.034 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. 0.102 0.102 ↓ 0.0 0 1

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

  • Filter: (entity_type_id = 165)
  • Rows Removed by Filter: 491
86. 13.312 13.312 ↑ 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.013..0.013 rows=1 loops=1,024)

  • Index Cond: (id = bi.status_id)
87. 32.768 32.768 ↑ 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.032..0.032 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. 19.456 116.736 ↑ 1.0 1 1,024

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

93. 30.645 97.280 ↓ 0.0 0 1,024

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

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

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

95. 1.024 66.560 ↓ 0.0 0 1,024

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
96. 65.536 65.536 ↓ 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.064..0.064 rows=0 loops=1,024)

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

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

98. 0.994 45.056 ↓ 0.0 0 1,024

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

99. 44.032 44.032 ↓ 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.043..0.043 rows=0 loops=1,024)

  • Index Cond: ((li.service_data_id = entity_id) AND (entity_type_id = 64))
100. 0.030 0.030 ↑ 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.002..0.002 rows=1 loops=15)

  • Index Cond: (les.service_id = id)
101. 2.048 2.048 ↑ 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.002..0.002 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)