explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cmeD

Settings
# exclusive inclusive rows x rows loops node
1. 1,393.339 6,074.077 ↓ 103.2 4,128 1

Result (cost=50,604.00..55,001.30 rows=40 width=2,352) (actual time=4,499.397..6,074.077 rows=4,128 loops=1)

2.          

CTE user_data_filter

3. 3.834 4.303 ↑ 1.0 7,182 1

Bitmap Heap Scan on user_data_access (cost=141.52..9,939.21 rows=7,359 width=23) (actual time=0.507..4.303 rows=7,182 loops=1)

  • Recheck Cond: (user_id = 2,649)
  • Filter: (NOT deleted)
  • Rows Removed by Filter: 5
  • Heap Blocks: exact=223
4. 0.469 0.469 ↑ 1.0 7,188 1

Bitmap Index Scan on idx_user_data_access_user_id (cost=0.00..139.68 rows=7,367 width=0) (actual time=0.469..0.469 rows=7,188 loops=1)

  • Index Cond: (user_id = 2,649)
5.          

CTE action_ids

6. 5.447 170.094 ↓ 78.8 4,257 1

HashAggregate (cost=17,679.50..17,680.04 rows=54 width=4) (actual time=169.281..170.094 rows=4,257 loops=1)

  • Group Key: edl.entity_id
7. 1.285 164.647 ↓ 160.4 8,659 1

Append (cost=4,729.83..17,679.37 rows=54 width=4) (actual time=35.262..164.647 rows=8,659 loops=1)

8. 9.695 50.481 ↓ 163.4 8,659 1

Merge Join (cost=4,729.83..4,918.13 rows=53 width=4) (actual time=35.261..50.481 rows=8,659 loops=1)

  • Merge Cond: ((edl.ancestor_id = da.entity_id) AND (edl.ancestor_type_id = da.entity_type_id))
9. 12.043 24.984 ↑ 1.1 20,324 1

Sort (cost=4,364.69..4,418.08 rows=21,356 width=12) (actual time=21.859..24.984 rows=20,324 loops=1)

  • Sort Key: edl.ancestor_id, edl.ancestor_type_id
  • Sort Method: quicksort Memory: 1,721kB
10. 11.413 12.941 ↑ 1.1 20,324 1

Bitmap Heap Scan on entity_data_link edl (cost=407.45..2,828.94 rows=21,356 width=12) (actual time=1.684..12.941 rows=20,324 loops=1)

  • Recheck Cond: (entity_type_id = 18)
  • Filter: (NOT deleted)
  • Rows Removed by Filter: 243
  • Heap Blocks: exact=957
11. 1.528 1.528 ↑ 1.0 20,572 1

Bitmap Index Scan on idx_entity_data_link_entity_type_id_entity_id (cost=0.00..402.12 rows=21,559 width=0) (actual time=1.528..1.528 rows=20,572 loops=1)

  • Index Cond: (entity_type_id = 18)
12. 6.136 15.802 ↓ 4.2 15,569 1

Sort (cost=365.14..374.34 rows=3,680 width=8) (actual time=13.383..15.802 rows=15,569 loops=1)

  • Sort Key: da.entity_id, da.entity_type_id
  • Sort Method: quicksort Memory: 529kB
13. 9.666 9.666 ↓ 2.0 7,182 1

CTE Scan on user_data_filter da (cost=0.00..147.18 rows=3,680 width=8) (actual time=0.511..9.666 rows=7,182 loops=1)

  • Filter: self_access
14. 0.003 112.881 ↓ 0.0 0 1

Nested Loop (cost=12,039.56..12,760.70 rows=1 width=4) (actual time=112.880..112.881 rows=0 loops=1)

  • Join Filter: (edc.ancestor_type_id = ANY (da_1.access_type_ids))
15. 0.004 112.878 ↓ 0.0 0 1

Merge Join (cost=12,039.14..12,637.23 rows=190 width=40) (actual time=112.878..112.878 rows=0 loops=1)

  • Merge Cond: ((edl_1.ancestor_id = da_1.entity_id) AND (edl_1.ancestor_type_id = da_1.entity_type_id))
16. 65.697 112.331 ↑ 75,812.0 1 1

Sort (cost=11,674.01..11,863.54 rows=75,812 width=16) (actual time=112.331..112.331 rows=1 loops=1)

  • Sort Key: edl_1.ancestor_id, edl_1.ancestor_type_id
  • Sort Method: external merge Disk: 1,968kB
17. 46.634 46.634 ↓ 1.0 77,248 1

Seq Scan on entity_data_link edl_1 (cost=0.00..5,529.39 rows=75,812 width=16) (actual time=0.040..46.634 rows=77,248 loops=1)

  • Filter: (parent AND (NOT deleted))
  • Rows Removed by Filter: 260,536
18. 0.009 0.543 ↓ 0.0 0 1

Sort (cost=365.14..374.34 rows=3,680 width=40) (actual time=0.543..0.543 rows=0 loops=1)

  • Sort Key: da_1.entity_id, da_1.entity_type_id
  • Sort Method: quicksort Memory: 25kB
19. 0.534 0.534 ↓ 0.0 0 1

CTE Scan on user_data_filter da_1 (cost=0.00..147.18 rows=3,680 width=40) (actual time=0.534..0.534 rows=0 loops=1)

  • Filter: (NOT self_access)
  • Rows Removed by Filter: 7,182
20. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_entity_data_link_entity_type_id_ancestor_type_id_ancestor_i on entity_data_link edc (cost=0.42..0.63 rows=1 width=12) (never executed)

  • Index Cond: ((entity_type_id = 18) AND (ancestor_type_id = edl_1.entity_type_id) AND (ancestor_id = edl_1.entity_id))
  • Filter: (NOT deleted)
21.          

Initplan (for Result)

22. 171.169 171.169 ↓ 78.8 4,257 1

CTE Scan on action_ids (cost=0.00..1.08 rows=54 width=4) (actual time=169.285..171.169 rows=4,257 loops=1)

23. 8.049 4,500.860 ↓ 103.2 4,128 1

Sort (cost=22,983.67..22,983.77 rows=40 width=2,260) (actual time=4,498.442..4,500.860 rows=4,128 loops=1)

  • Sort Key: action.status_id
  • Sort Method: quicksort Memory: 2,825kB
24. 171.674 4,492.811 ↓ 103.2 4,128 1

GroupAggregate (cost=22,948.60..22,982.60 rows=40 width=2,260) (actual time=4,291.691..4,492.811 rows=4,128 loops=1)

  • Group Key: action.id, r.id, c.id, lcat.name, cy.short_name, (change_tz(action.approveal_date, 'UTC'::character varying, tz.time_zone)), (change_tz(action.rejection_date, 'UTC'::character varying, tz.time_zone)), (change_tz(action.submission_date, 'UTC'::character varying, tz.time_zone)), v.status, tz.id, pt.id, res.id, rcl.id, gbc.id, gb.id, tier.name, (array_to_string(array_agg(DISTINCT rg1.name), ', '::text)), (array_to_string(array_agg(DISTINCT rg2.name), ', '::text)), (array_to_string(array_agg(DISTINCT dc1.name), ', '::text)), (array_to_string(array_agg(DISTINCT dc2_1.name), ', '::text)), v.name, ets.description, et.id
25. 1,494.063 4,321.137 ↓ 1,509.1 60,363 1

Sort (cost=22,948.60..22,948.70 rows=40 width=3,227) (actual time=4,290.511..4,321.137 rows=60,363 loops=1)

  • Sort Key: action.id, r.id, c.id, lcat.name, cy.short_name, (change_tz(action.approveal_date, 'UTC'::character varying, tz.time_zone)), (change_tz(action.rejection_date, 'UTC'::character varying, tz.time_zone)), (change_tz(action.submission_date, 'UTC'::character varying, tz.time_zone)), v.status, tz.id, pt.id, res.id, rcl.id, gbc.id, gb.id, tier.name, (array_to_string(array_agg(DISTINCT rg1.name), ', '::text)), (array_to_string(array_agg(DISTINCT rg2.name), ', '::text)), (array_to_string(array_agg(DISTINCT dc1.name), ', '::text)), (array_to_string(array_agg(DISTINCT dc2_1.name), ', '::text)), v.name, ets.description, et.id
  • Sort Method: external sort Disk: 39,320kB
26. 1,538.304 2,827.074 ↓ 1,509.1 60,363 1

Nested Loop Left Join (cost=20,796.10..22,947.54 rows=40 width=3,227) (actual time=229.654..2,827.074 rows=60,363 loops=1)

27. 68.121 1,288.770 ↓ 1,509.1 60,363 1

Hash Left Join (cost=20,795.83..22,905.50 rows=40 width=3,204) (actual time=229.597..1,288.770 rows=60,363 loops=1)

  • Hash Cond: ((action.client_id = lcat.client_id) AND (action.type_id = lcat.type_id))
28. 57.032 1,220.632 ↓ 2,012.1 60,363 1

Hash Left Join (cost=20,793.50..22,902.02 rows=30 width=3,192) (actual time=229.571..1,220.632 rows=60,363 loops=1)

  • Hash Cond: (action.vendor_id = v.id)
29. 85.170 1,163.413 ↓ 2,012.1 60,363 1

Nested Loop Left Join (cost=20,724.09..22,832.54 rows=30 width=3,180) (actual time=229.380..1,163.413 rows=60,363 loops=1)

30. 101.245 1,078.243 ↓ 2,012.1 60,363 1

Nested Loop Left Join (cost=20,723.81..22,583.46 rows=30 width=3,154) (actual time=229.373..1,078.243 rows=60,363 loops=1)

31. 51.220 856.272 ↓ 2,012.1 60,363 1

Hash Left Join (cost=20,723.53..22,574.65 rows=30 width=3,145) (actual time=229.367..856.272 rows=60,363 loops=1)

  • Hash Cond: (action.tier_id = tier.id)
32. 64.672 805.035 ↓ 2,012.1 60,363 1

Hash Left Join (cost=20,721.43..22,572.45 rows=30 width=2,633) (actual time=229.346..805.035 rows=60,363 loops=1)

  • Hash Cond: ((action.client_id = rcl.client_id) AND (res.id = rcl.responsibility_id))
33. 45.994 740.353 ↓ 2,012.1 60,363 1

Nested Loop Left Join (cost=20,720.38..22,571.08 rows=30 width=2,113) (actual time=229.327..740.353 rows=60,363 loops=1)

34. 12.213 621.020 ↓ 349.2 10,477 1

Merge Left Join (cost=20,719.96..22,317.50 rows=30 width=2,109) (actual time=229.306..621.020 rows=10,477 loops=1)

  • Merge Cond: (action.id = ller.entity_id)
35. 13.307 577.205 ↓ 349.2 10,477 1

Merge Left Join (cost=19,138.63..20,510.53 rows=30 width=2,045) (actual time=222.665..577.205 rows=10,477 loops=1)

  • Merge Cond: (action.id = ledc.entity_id)
36. 14.335 438.727 ↓ 1,309.6 10,477 1

Nested Loop Left Join (cost=2.54..452.03 rows=8 width=1,981) (actual time=173.011..438.727 rows=10,477 loops=1)

  • Join Filter: (res.id = action.responsibility_id)
  • Rows Removed by Join Filter: 16,380
37. 14.210 424.392 ↓ 1,309.6 10,477 1

Nested Loop Left Join (cost=2.54..450.67 rows=8 width=1,465) (actual time=173.004..424.392 rows=10,477 loops=1)

  • Join Filter: (pt.id = action.priority)
  • Rows Removed by Join Filter: 18,083
38. 16.253 410.182 ↓ 1,309.6 10,477 1

Nested Loop Left Join (cost=2.54..449.11 rows=8 width=949) (actual time=172.994..410.182 rows=10,477 loops=1)

  • Join Filter: (tz.id = action.time_zone_id)
  • Rows Removed by Join Filter: 74,347
39. 19.851 383.452 ↓ 1,309.6 10,477 1

Nested Loop Left Join (cost=2.54..442.68 rows=8 width=401) (actual time=172.978..383.452 rows=10,477 loops=1)

40. 9.722 342.647 ↓ 1,309.6 10,477 1

Nested Loop Left Join (cost=2.40..441.36 rows=8 width=389) (actual time=172.971..342.647 rows=10,477 loops=1)

41. 5.964 305.619 ↓ 568.9 4,551 1

Nested Loop Left Join (cost=1.98..373.74 rows=8 width=385) (actual time=172.961..305.619 rows=4,551 loops=1)

42. 7.069 290.553 ↓ 568.9 4,551 1

Nested Loop Left Join (cost=1.83..372.44 rows=8 width=379) (actual time=172.953..290.553 rows=4,551 loops=1)

43. 4.465 266.972 ↓ 516.0 4,128 1

Nested Loop Left Join (cost=1.42..304.84 rows=8 width=375) (actual time=172.943..266.972 rows=4,128 loops=1)

44. 7.697 254.251 ↓ 516.0 4,128 1

Nested Loop Left Join (cost=1.27..283.51 rows=8 width=376) (actual time=172.936..254.251 rows=4,128 loops=1)

45. 3.804 238.298 ↓ 516.0 4,128 1

Nested Loop Left Join (cost=0.99..229.15 rows=8 width=361) (actual time=172.928..238.298 rows=4,128 loops=1)

46. 5.774 230.366 ↓ 516.0 4,128 1

Nested Loop Left Join (cost=0.71..166.75 rows=8 width=344) (actual time=172.923..230.366 rows=4,128 loops=1)

47. 6.503 216.336 ↓ 516.0 4,128 1

Nested Loop Left Join (cost=0.56..141.41 rows=8 width=322) (actual time=172.901..216.336 rows=4,128 loops=1)

48. 197.449 197.449 ↓ 516.0 4,128 1

Index Scan using pk_action_item_mgmt on action_item_mgmt action (cost=0.28..79.01 rows=8 width=304) (actual time=172.890..197.449 rows=4,128 loops=1)

  • Index Cond: (id = ANY ($17))
  • Filter: ((NOT deleted) AND (client_id = 1,005) AND (status_id = ANY ('{2236,2237,2238,2239,2,1,4}'::integer[])))
  • Rows Removed by Filter: 129
49. 12.384 12.384 ↑ 1.0 1 4,128

Index Scan using pk_work_flow_status on work_flow_status ets (cost=0.28..7.80 rows=1 width=22) (actual time=0.003..0.003 rows=1 loops=4,128)

  • Index Cond: (id = action.status_id)
50. 8.256 8.256 ↑ 1.0 1 4,128

Index Scan using pk_entity_type on entity_type et (cost=0.15..3.17 rows=1 width=22) (actual time=0.002..0.002 rows=1 loops=4,128)

  • Index Cond: (action.entity_type_id = id)
51. 4.128 4.128 ↓ 0.0 0 4,128

Index Scan using pk_contract on contract c (cost=0.28..7.80 rows=1 width=21) (actual time=0.001..0.001 rows=0 loops=4,128)

  • Index Cond: (action.contract_id = id)
52. 8.256 8.256 ↑ 1.0 1 4,128

Index Scan using pk_relation on relation r (cost=0.28..6.79 rows=1 width=19) (actual time=0.002..0.002 rows=1 loops=4,128)

  • Index Cond: (action.relation_id = id)
53. 8.256 8.256 ↑ 1.0 1 4,128

Index Scan using pk_currency on currency cy (cost=0.14..2.66 rows=1 width=7) (actual time=0.002..0.002 rows=1 loops=4,128)

  • Index Cond: (action.currency_id = id)
54. 16.512 16.512 ↑ 1.0 1 4,128

Index Scan using idx_link_entity_function_6 on link_entity_function lef (cost=0.42..8.44 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=4,128)

  • Index Cond: ((action.id = entity_id) AND (entity_type_id = 18))
55. 9.102 9.102 ↑ 1.0 1 4,551

Index Scan using pk_contract_type on contract_type ct (cost=0.14..0.16 rows=1 width=14) (actual time=0.002..0.002 rows=1 loops=4,551)

  • Index Cond: (id = lef.function_id)
56. 27.306 27.306 ↓ 2.0 2 4,551

Index Scan using idx_link_entity_service_6 on link_entity_service les (cost=0.42..8.44 rows=1 width=8) (actual time=0.004..0.006 rows=2 loops=4,551)

  • Index Cond: ((action.id = entity_id) AND (entity_type_id = 18))
57. 20.954 20.954 ↑ 1.0 1 10,477

Index Scan using pk_contract_sub_type on contract_sub_type cst (cost=0.14..0.16 rows=1 width=20) (actual time=0.002..0.002 rows=1 loops=10,477)

  • Index Cond: (id = les.service_id)
58. 10.455 10.477 ↑ 5.1 8 10,477

Materialize (cost=0.00..1.62 rows=41 width=552) (actual time=0.000..0.001 rows=8 loops=10,477)

59. 0.022 0.022 ↑ 1.0 40 1

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

60. 0.000 0.000 ↑ 1.7 3 10,477

Materialize (cost=0.00..1.07 rows=5 width=520) (actual time=0.000..0.000 rows=3 loops=10,477)

61. 0.013 0.013 ↑ 1.0 5 1

Seq Scan on priority_table pt (cost=0.00..1.05 rows=5 width=520) (actual time=0.007..0.013 rows=5 loops=1)

62. 0.000 0.000 ↑ 1.5 2 10,477

Materialize (cost=0.00..1.04 rows=3 width=520) (actual time=0.000..0.000 rows=2 loops=10,477)

63. 0.007 0.007 ↑ 1.0 3 1

Seq Scan on responsibility res (cost=0.00..1.03 rows=3 width=520) (actual time=0.003..0.007 rows=3 loops=1)

64. 79.633 125.171 ↑ 3.8 4,893 1

GroupAggregate (cost=19,136.08..19,823.39 rows=18,783 width=68) (actual time=42.416..125.171 rows=4,893 loops=1)

  • Group Key: ledc.entity_id
65. 13.177 45.538 ↑ 1.0 31,063 1

Sort (cost=19,136.08..19,214.00 rows=31,165 width=30) (actual time=42.203..45.538 rows=31,063 loops=1)

  • Sort Key: ledc.entity_id
  • Sort Method: quicksort Memory: 2,371kB
66. 10.981 32.361 ↑ 1.0 31,063 1

Hash Left Join (cost=612.92..16,809.98 rows=31,165 width=30) (actual time=2.655..32.361 rows=31,063 loops=1)

  • Hash Cond: (ledc.country_id = dc2_1.id)
  • Join Filter: (NOT ledc.global)
  • Rows Removed by Join Filter: 30,965
67. 12.184 21.211 ↑ 1.0 31,063 1

Hash Left Join (cost=599.44..16,714.68 rows=31,165 width=22) (actual time=2.479..21.211 rows=31,063 loops=1)

  • Hash Cond: (ledc.country_id = dc1.id)
  • Join Filter: ledc.global
  • Rows Removed by Join Filter: 98
68. 6.691 8.822 ↑ 1.0 31,063 1

Bitmap Heap Scan on link_entity_country ledc (cost=585.96..16,618.48 rows=31,165 width=9) (actual time=2.263..8.822 rows=31,063 loops=1)

  • Recheck Cond: (entity_type_id = 18)
  • Heap Blocks: exact=833
69. 2.131 2.131 ↑ 1.0 31,107 1

Bitmap Index Scan on idx_link_entity_country_5 (cost=0.00..578.17 rows=31,165 width=0) (actual time=2.131..2.131 rows=31,107 loops=1)

  • Index Cond: (entity_type_id = 18)
70. 0.100 0.205 ↑ 1.0 377 1

Hash (cost=8.77..8.77 rows=377 width=17) (actual time=0.205..0.205 rows=377 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 27kB
71. 0.105 0.105 ↑ 1.0 377 1

Seq Scan on delivery_country dc1 (cost=0.00..8.77 rows=377 width=17) (actual time=0.010..0.105 rows=377 loops=1)

72. 0.089 0.169 ↑ 1.0 377 1

Hash (cost=8.77..8.77 rows=377 width=17) (actual time=0.169..0.169 rows=377 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 27kB
73. 0.080 0.080 ↑ 1.0 377 1

Seq Scan on delivery_country dc2_1 (cost=0.00..8.77 rows=377 width=17) (actual time=0.005..0.080 rows=377 loops=1)

74. 24.237 31.602 ↑ 1.1 4,893 1

GroupAggregate (cost=1,581.33..1,741.47 rows=5,209 width=68) (actual time=6.181..31.602 rows=4,893 loops=1)

  • Group Key: ller.entity_id
75. 2.601 7.365 ↑ 1.0 5,528 1

Sort (cost=1,581.33..1,595.32 rows=5,596 width=22) (actual time=6.151..7.365 rows=5,528 loops=1)

  • Sort Key: ller.entity_id
  • Sort Method: quicksort Memory: 461kB
76. 1.396 4.764 ↑ 1.0 5,528 1

Hash Left Join (cost=115.97..1,232.97 rows=5,596 width=22) (actual time=0.465..4.764 rows=5,528 loops=1)

  • Hash Cond: (ller.region_id = rg2.id)
  • Join Filter: (NOT ller.global)
  • Rows Removed by Join Filter: 5,512
77. 1.664 3.326 ↑ 1.0 5,528 1

Hash Left Join (cost=111.88..1,214.18 rows=5,596 width=18) (actual time=0.416..3.326 rows=5,528 loops=1)

  • Hash Cond: (ller.region_id = rg1.id)
  • Join Filter: ller.global
  • Rows Removed by Join Filter: 16
78. 1.313 1.614 ↑ 1.0 5,528 1

Bitmap Heap Scan on link_entity_region ller (cost=107.79..1,194.74 rows=5,596 width=9) (actual time=0.357..1.614 rows=5,528 loops=1)

  • Recheck Cond: (entity_type_id = 18)
  • Heap Blocks: exact=393
79. 0.301 0.301 ↑ 1.0 5,536 1

Bitmap Index Scan on idx_link_entity_region_5 (cost=0.00..106.39 rows=5,596 width=0) (actual time=0.301..0.301 rows=5,536 loops=1)

  • Index Cond: (entity_type_id = 18)
80. 0.019 0.048 ↑ 1.0 93 1

Hash (cost=2.93..2.93 rows=93 width=13) (actual time=0.048..0.048 rows=93 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
81. 0.029 0.029 ↑ 1.0 93 1

Seq Scan on region rg1 (cost=0.00..2.93 rows=93 width=13) (actual time=0.012..0.029 rows=93 loops=1)

82. 0.022 0.042 ↑ 1.0 93 1

Hash (cost=2.93..2.93 rows=93 width=13) (actual time=0.042..0.042 rows=93 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
83. 0.020 0.020 ↑ 1.0 93 1

Seq Scan on region rg2 (cost=0.00..2.93 rows=93 width=13) (actual time=0.005..0.020 rows=93 loops=1)

84. 73.339 73.339 ↓ 5.0 5 10,477

Index Scan using idx_link_entity_delivery_country_6 on link_entity_delivery_country ledc2 (cost=0.42..8.44 rows=1 width=8) (actual time=0.004..0.007 rows=5 loops=10,477)

  • Index Cond: ((entity_id = action.id) AND (entity_type_id = 18))
85. 0.002 0.010 ↓ 2.0 2 1

Hash (cost=1.04..1.04 rows=1 width=528) (actual time=0.010..0.010 rows=2 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
86. 0.008 0.008 ↓ 2.0 2 1

Seq Scan on responsibility_client_link rcl (cost=0.00..1.04 rows=1 width=528) (actual time=0.007..0.008 rows=2 loops=1)

  • Filter: (client_id = 1,005)
  • Rows Removed by Filter: 1
87. 0.008 0.017 ↑ 1.0 49 1

Hash (cost=1.49..1.49 rows=49 width=520) (actual time=0.017..0.017 rows=49 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
88. 0.009 0.009 ↑ 1.0 49 1

Seq Scan on tier (cost=0.00..1.49 rows=49 width=520) (actual time=0.004..0.009 rows=49 loops=1)

89. 120.726 120.726 ↑ 1.0 1 60,363

Index Scan using pk_delivery_country on delivery_country dc2 (cost=0.27..0.29 rows=1 width=17) (actual time=0.002..0.002 rows=1 loops=60,363)

  • Index Cond: (ledc2.country_id = id)
90. 0.000 0.000 ↓ 0.0 0 60,363

Index Scan using pk_governance_body_child on governance_body_child gbc (cost=0.29..8.30 rows=1 width=30) (actual time=0.000..0.000 rows=0 loops=60,363)

  • Index Cond: (action.governance_body_child_id = id)
91. 0.067 0.187 ↑ 1.0 418 1

Hash (cost=64.18..64.18 rows=418 width=20) (actual time=0.187..0.187 rows=418 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 29kB
92. 0.120 0.120 ↑ 1.0 418 1

Seq Scan on vendor v (cost=0.00..64.18 rows=418 width=20) (actual time=0.004..0.120 rows=418 loops=1)

93. 0.005 0.017 ↑ 1.0 23 1

Hash (cost=1.99..1.99 rows=23 width=24) (actual time=0.017..0.017 rows=23 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
94. 0.012 0.012 ↑ 1.0 23 1

Seq Scan on link_client_action_type lcat (cost=0.00..1.99 rows=23 width=24) (actual time=0.006..0.012 rows=23 loops=1)

  • Filter: (client_id = 1,005)
  • Rows Removed by Filter: 56
95. 0.000 0.000 ↓ 0.0 0 60,363

Index Scan using pk_governance_body on governance_body gb (cost=0.28..0.30 rows=1 width=27) (actual time=0.000..0.000 rows=0 loops=60,363)

  • Index Cond: (gbc.governance_body_id = id)
96.          

SubPlan (for Result)

97. 7.158 7.158 ↑ 1.0 1 3,579

Index Scan using pk_relation on relation src (cost=0.28..8.29 rows=1 width=15) (actual time=0.002..0.002 rows=1 loops=3,579)

  • Index Cond: (id = action.entity_id)
98. 0.300 0.300 ↑ 1.0 1 150

Index Scan using pk_contract on contract src_1 (cost=0.28..8.30 rows=1 width=17) (actual time=0.002..0.002 rows=1 loops=150)

  • Index Cond: (id = action.entity_id)
99. 0.070 0.070 ↑ 1.0 1 14

Index Scan using pk_dno on dno src_2 (cost=0.28..8.30 rows=1 width=20) (actual time=0.005..0.005 rows=1 loops=14)

  • Index Cond: (id = action.entity_id)
100. 0.115 0.115 ↑ 1.0 1 23

Index Scan using pk_child_dno on child_dno src_3 (cost=0.29..8.30 rows=1 width=23) (actual time=0.005..0.005 rows=1 loops=23)

  • Index Cond: (id = action.entity_id)
101. 0.045 0.045 ↑ 1.0 1 15

Index Scan using pk_sla on sla src_4 (cost=0.28..8.30 rows=1 width=18) (actual time=0.003..0.003 rows=1 loops=15)

  • Index Cond: (id = action.entity_id)
102. 0.048 0.048 ↑ 1.0 1 16

Index Scan using pk_child_sla on child_sla src_5 (cost=0.29..8.31 rows=1 width=22) (actual time=0.003..0.003 rows=1 loops=16)

  • Index Cond: (id = action.entity_id)
103. 0.052 0.052 ↑ 1.0 1 13

Index Scan using pk_contract_intpn on contract_intpn src_6 (cost=0.27..8.29 rows=1 width=20) (actual time=0.004..0.004 rows=1 loops=13)

  • Index Cond: (id = action.entity_id)
104. 0.063 0.063 ↑ 1.0 1 21

Index Scan using pk_issue_mgmt on issue_mgmt src_7 (cost=0.28..8.29 rows=1 width=18) (actual time=0.002..0.003 rows=1 loops=21)

  • Index Cond: (id = action.entity_id)
105. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_dispute_mgmt on dispute_mgmt src_8 (cost=0.28..8.29 rows=1 width=17) (never executed)

  • Index Cond: (id = action.entity_id)
106. 0.744 0.744 ↑ 1.0 1 248

Index Scan using action_item_mgmt_id_idx on action_item_mgmt src_9 (cost=0.28..8.30 rows=1 width=10) (actual time=0.002..0.003 rows=1 loops=248)

  • Index Cond: (id = action.entity_id)
107. 0.054 0.054 ↑ 1.0 1 27

Index Scan using change_request_pkey on change_request src_10 (cost=0.28..8.29 rows=1 width=23) (actual time=0.002..0.002 rows=1 loops=27)

  • Index Cond: (id = action.entity_id)
108. 0.024 0.024 ↑ 1.0 1 8

Index Scan using base_invoice_pkey on base_invoice src_11 (cost=0.29..8.30 rows=1 width=20) (actual time=0.003..0.003 rows=1 loops=8)

  • Index Cond: (id = action.entity_id)
109. 0.036 0.036 ↑ 1.0 1 12

Index Scan using work_order_request_pkey on work_order_request src_12 (cost=0.28..8.29 rows=1 width=44) (actual time=0.002..0.003 rows=1 loops=12)

  • Index Cond: (id = action.entity_id)
Planning time : 26.124 ms
Execution time : 6,091.106 ms