explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1D4Q

Settings
# exclusive inclusive rows x rows loops node
1. 689.330 3,648.705 ↑ 1.6 1,024 1

Result (cost=31,923.21..133,436.70 rows=1,619 width=3,598) (actual time=2,830.022..3,648.705 rows=1,024 loops=1)

2. 5.666 2,805.718 ↑ 1.6 1,024 1

Sort (cost=31,923.21..31,927.25 rows=1,619 width=2,277) (actual time=2,805.622..2,805.718 rows=1,024 loops=1)

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

GroupAggregate (cost=30,671.23..31,836.91 rows=1,619 width=2,277) (actual time=2,686.660..2,800.052 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. 331.647 2,687.195 ↓ 3.1 5,024 1

Sort (cost=30,671.23..30,675.27 rows=1,619 width=1,379) (actual time=2,686.632..2,687.195 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. 197.354 2,355.548 ↓ 3.1 5,024 1

Nested Loop Left Join (cost=24,070.25..30,584.93 rows=1,619 width=1,379) (actual time=187.805..2,355.548 rows=5,024 loops=1)

6. 36.168 1,866.802 ↓ 9.4 5,024 1

Hash Left Join (cost=24,069.68..29,103.31 rows=532 width=1,327) (actual time=187.781..1,866.802 rows=5,024 loops=1)

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

Hash Left Join (cost=23,975.22..29,006.84 rows=532 width=1,319) (actual time=187.728..1,830.601 rows=5,024 loops=1)

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

Hash Left Join (cost=23,971.38..29,001.60 rows=532 width=1,297) (actual time=187.667..1,827.648 rows=5,024 loops=1)

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

Hash Left Join (cost=23,902.40..28,931.21 rows=532 width=1,279) (actual time=187.336..1,824.185 rows=5,024 loops=1)

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

Hash Left Join (cost=23,895.49..28,922.87 rows=532 width=1,279) (actual time=187.212..1,820.873 rows=5,024 loops=1)

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

Hash Left Join (cost=23,505.92..28,531.91 rows=532 width=1,259) (actual time=144.313..1,720.729 rows=5,024 loops=1)

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

Hash Left Join (cost=23,497.68..28,522.27 rows=532 width=1,247) (actual time=144.221..1,694.542 rows=5,024 loops=1)

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

Hash Left Join (cost=23,487.67..28,510.86 rows=532 width=1,227) (actual time=144.078..1,666.199 rows=5,024 loops=1)

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

Nested Loop Left Join (cost=23,472.65..28,494.43 rows=532 width=1,204) (actual time=143.859..1,660.604 rows=5,024 loops=1)

15. 2.920 1,458.074 ↓ 9.4 5,024 1

Hash Left Join (cost=23,472.36..27,740.37 rows=532 width=1,147) (actual time=143.839..1,458.074 rows=5,024 loops=1)

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

Hash Left Join (cost=23,465.45..27,732.02 rows=532 width=1,143) (actual time=143.725..1,455.056 rows=5,024 loops=1)

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

Hash Left Join (cost=23,463.53..27,728.56 rows=532 width=1,131) (actual time=143.681..1,452.084 rows=5,024 loops=1)

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

Hash Left Join (cost=23,458.04..27,721.64 rows=532 width=1,105) (actual time=143.587..1,415.218 rows=5,024 loops=1)

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

Hash Right Join (cost=23,453.85..27,710.13 rows=532 width=1,066) (actual time=143.505..1,310.955 rows=5,024 loops=1)

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

21. 1.001 143.370 ↓ 1.9 1,024 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 221kB
22. 38.860 142.369 ↓ 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,065) (actual time=0.094..142.369 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.009 ↓ 0.0 0 1

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

28. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on secondary_data_access sda_1 (cost=0.00..1.19 rows=1 width=4) (actual time=0.009..0.009 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.001 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.42..3.83 rows=1 width=4) (actual time=0.004..0.004 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. 1.024 103.424 ↑ 1.0 1 1,024

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

37. 47.104 47.104 ↑ 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.046..0.046 rows=1 loops=1,024)

  • Index Cond: (id = li.id)
38. 55.296 55.296 ↑ 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.054..0.054 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.000 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.036 0.036 ↑ 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.004..0.004 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.006 0.057 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
46. 0.023 0.051 ↑ 1.0 1 1

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

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

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

48. 0.005 0.022 ↑ 1.0 1 1

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

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

  • Index Cond: (id = 5365)
50. 0.043 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.036 0.036 ↑ 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.036 rows=155 loops=1)

52. 0.014 0.024 ↑ 1.0 41 1

Hash (cost=1.41..1.41 rows=41 width=20) (actual time=0.024..0.024 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.044 0.098 ↑ 1.0 174 1

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

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

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

56. 185.888 185.888 ↑ 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.037..0.037 rows=1 loops=5,024)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
58. 0.092 0.092 ↑ 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.092 rows=401 loops=1)

59. 0.069 0.128 ↑ 1.0 267 1

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

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

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

61. 0.035 0.076 ↑ 1.0 144 1

Hash (cost=6.44..6.44 rows=144 width=12) (actual time=0.076..0.076 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. 0.697 42.872 ↓ 1.0 2,515 1

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

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

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

65. 0.048 0.104 ↑ 1.0 174 1

Hash (cost=4.74..4.74 rows=174 width=8) (actual time=0.103..0.104 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.007..0.056 rows=174 loops=1)

67. 0.105 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.210 0.210 ↓ 1.0 400 1

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

69. 0.025 0.047 ↑ 1.0 82 1

Hash (cost=2.82..2.82 rows=82 width=30) (actual time=0.047..0.047 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.001 0.033 ↓ 0.0 0 1

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

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

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

73. 0.001 0.031 ↓ 0.0 0 1

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

  • Group Key: ebep.entity_id, ut.id
74. 0.009 0.030 ↓ 0.0 0 1

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

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

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

76. 0.001 0.020 ↓ 0.0 0 1

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

77. 0.019 0.019 ↓ 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.019..0.019 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. 291.392 291.392 ↑ 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.058..0.058 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.057 0.057 ↓ 0.0 0 1

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

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

  • Index Cond: (id = bi.status_id)
87. 51.200 51.200 ↑ 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.050..0.050 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. 24.576 24.576 ↓ 0.0 0 1,024

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

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

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

93. 1.973 4.096 ↓ 0.0 0 1,024

Hash Right Join (cost=2.52..4.11 rows=1 width=10) (actual time=0.003..0.004 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 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. 1.024 1.024 ↓ 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.001..0.001 rows=0 loops=1,024)

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

Aggregate (cost=5.04..5.05 rows=1 width=32) (actual time=0.003..0.003 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.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. 1.024 1.024 ↑ 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.001 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)