explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bPGn

Settings
# exclusive inclusive rows x rows loops node
1. 0.095 74.720 ↑ 1.4 29 1

Sort (cost=9,146.60..9,146.70 rows=40 width=1,932) (actual time=74.717..74.720 rows=29 loops=1)

  • Sort Key: analytical_results.id DESC
  • Sort Method: quicksort Memory: 54kB
2. 0.047 74.625 ↑ 1.4 29 1

Hash Left Join (cost=6,292.94..9,145.54 rows=40 width=1,932) (actual time=73.382..74.625 rows=29 loops=1)

  • Hash Cond: (t33.type_id = t34.id)
3. 1.578 74.556 ↑ 1.4 29 1

Hash Left Join (cost=6,291.62..9,144.08 rows=40 width=1,894) (actual time=73.343..74.556 rows=29 loops=1)

  • Hash Cond: (analytical_results.id = t33.result_id)
4. 0.048 70.682 ↑ 1.4 29 1

Hash Left Join (cost=6,143.35..8,995.60 rows=40 width=1,867) (actual time=69.499..70.682 rows=29 loops=1)

  • Hash Cond: (analytical_results.boundary_type_id = t32.id)
5. 0.049 70.607 ↑ 1.4 29 1

Nested Loop Left Join (cost=6,142.03..8,994.16 rows=40 width=1,825) (actual time=69.458..70.607 rows=29 loops=1)

  • Join Filter: ((analytical_results.value_type)::text = 'BooleanResultValue'::text)
6. 0.061 70.529 ↑ 1.4 29 1

Nested Loop Left Join (cost=6,141.88..8,986.83 rows=40 width=1,820) (actual time=69.445..70.529 rows=29 loops=1)

  • Join Filter: ((analytical_results.value_type)::text = 'NumericResultValue'::text)
7. 0.032 70.381 ↑ 1.4 29 1

Nested Loop Left Join (cost=6,141.46..8,962.65 rows=40 width=1,797) (actual time=69.427..70.381 rows=29 loops=1)

  • Join Filter: ((analytical_results.value_type)::text = 'TextResultValue'::text)
8. 0.064 70.262 ↑ 1.4 29 1

Nested Loop Left Join (cost=6,141.04..8,941.21 rows=40 width=1,774) (actual time=69.410..70.262 rows=29 loops=1)

9. 0.046 70.140 ↑ 1.4 29 1

Nested Loop Left Join (cost=6,140.77..8,929.60 rows=40 width=1,731) (actual time=69.393..70.140 rows=29 loops=1)

10. 0.053 69.978 ↑ 1.4 29 1

Nested Loop Left Join (cost=6,140.35..8,909.88 rows=40 width=1,655) (actual time=69.370..69.978 rows=29 loops=1)

11. 0.048 69.925 ↑ 1.4 29 1

Nested Loop Left Join (cost=6,140.06..8,897.72 rows=40 width=1,644) (actual time=69.361..69.925 rows=29 loops=1)

12. 0.068 69.355 ↑ 1.4 29 1

Hash Left Join (cost=6,140.06..8,869.68 rows=40 width=1,630) (actual time=69.267..69.355 rows=29 loops=1)

  • Hash Cond: ((analytical_results.appraisal)::text = (t23.value)::text)
13. 10.585 69.145 ↑ 1.4 29 1

Hash Right Join (cost=6,133.13..8,862.30 rows=40 width=1,584) (actual time=69.093..69.145 rows=29 loops=1)

  • Hash Cond: (t25.level_id = analytical_results.level_id)
14. 11.542 11.542 ↑ 1.0 116,918 1

Seq Scan on worklist_assignments t25 (cost=0.00..2,144.18 rows=116,918 width=12) (actual time=0.011..11.542 rows=116,918 loops=1)

15. 0.055 47.018 ↑ 1.0 29 1

Hash (cost=6,132.75..6,132.75 rows=30 width=1,576) (actual time=47.018..47.018 rows=29 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 24kB
16. 0.046 46.963 ↑ 1.0 29 1

Nested Loop Left Join (cost=5,993.14..6,132.75 rows=30 width=1,576) (actual time=46.691..46.963 rows=29 loops=1)

17. 0.019 46.888 ↑ 1.0 29 1

Nested Loop Left Join (cost=5,992.87..6,124.01 rows=30 width=1,554) (actual time=46.680..46.888 rows=29 loops=1)

18. 0.046 46.811 ↑ 1.0 29 1

Nested Loop (cost=5,992.59..6,115.29 rows=30 width=1,528) (actual time=46.665..46.811 rows=29 loops=1)

19. 0.020 46.707 ↑ 1.0 29 1

Nested Loop (cost=5,992.32..6,106.59 rows=30 width=1,528) (actual time=46.645..46.707 rows=29 loops=1)

20. 0.007 46.623 ↑ 1.0 1 1

Nested Loop (cost=5,991.90..6,105.09 rows=1 width=1,528) (actual time=46.614..46.623 rows=1 loops=1)

21. 0.003 46.603 ↑ 1.0 1 1

Nested Loop (cost=5,991.62..6,104.77 rows=1 width=1,458) (actual time=46.595..46.603 rows=1 loops=1)

22. 0.006 46.589 ↑ 1.0 1 1

Nested Loop Left Join (cost=5,991.34..6,104.47 rows=1 width=1,450) (actual time=46.580..46.589 rows=1 loops=1)

23. 0.005 46.578 ↑ 1.0 1 1

Nested Loop Left Join (cost=5,991.07..6,104.17 rows=1 width=1,409) (actual time=46.569..46.578 rows=1 loops=1)

24. 0.004 46.569 ↑ 1.0 1 1

Nested Loop (cost=5,990.93..6,104.00 rows=1 width=893) (actual time=46.561..46.569 rows=1 loops=1)

25. 0.005 46.553 ↑ 1.0 1 1

Nested Loop Left Join (cost=5,990.65..6,103.70 rows=1 width=839) (actual time=46.545..46.553 rows=1 loops=1)

26. 0.005 46.545 ↑ 1.0 1 1

Nested Loop Left Join (cost=5,990.52..6,103.54 rows=1 width=835) (actual time=46.538..46.545 rows=1 loops=1)

27. 0.007 46.531 ↑ 1.0 1 1

Nested Loop Left Join (cost=5,990.24..6,103.24 rows=1 width=796) (actual time=46.524..46.531 rows=1 loops=1)

28. 0.004 46.509 ↑ 1.0 1 1

Nested Loop Left Join (cost=5,990.24..6,100.71 rows=1 width=740) (actual time=46.502..46.509 rows=1 loops=1)

29. 0.005 46.502 ↑ 1.0 1 1

Nested Loop Left Join (cost=5,989.97..6,100.41 rows=1 width=659) (actual time=46.495..46.502 rows=1 loops=1)

30. 0.004 46.493 ↑ 1.0 1 1

Nested Loop Left Join (cost=5,989.68..6,100.08 rows=1 width=617) (actual time=46.487..46.493 rows=1 loops=1)

31. 0.006 46.481 ↑ 1.0 1 1

Nested Loop (cost=5,989.55..6,099.92 rows=1 width=598) (actual time=46.474..46.481 rows=1 loops=1)

32. 0.003 46.462 ↑ 1.0 1 1

Nested Loop Left Join (cost=5,989.26..6,099.60 rows=1 width=577) (actual time=46.456..46.462 rows=1 loops=1)

33. 0.003 46.446 ↑ 1.0 1 1

Nested Loop Left Join (cost=5,989.12..6,099.43 rows=1 width=552) (actual time=46.440..46.446 rows=1 loops=1)

34. 0.005 46.438 ↑ 1.0 1 1

Nested Loop (cost=5,988.99..6,099.28 rows=1 width=548) (actual time=46.432..46.438 rows=1 loops=1)

35. 0.003 46.422 ↑ 1.0 1 1

Nested Loop Left Join (cost=5,988.70..6,096.77 rows=1 width=353) (actual time=46.416..46.422 rows=1 loops=1)

36. 0.005 46.406 ↑ 1.0 1 1

Nested Loop Left Join (cost=5,988.42..6,096.47 rows=1 width=300) (actual time=46.400..46.406 rows=1 loops=1)

37. 0.003 46.391 ↑ 1.0 1 1

Nested Loop (cost=5,988.14..6,096.15 rows=1 width=249) (actual time=46.385..46.391 rows=1 loops=1)

38. 0.004 46.303 ↑ 2.0 1 1

Nested Loop (cost=5,987.85..6,095.46 rows=2 width=237) (actual time=46.297..46.303 rows=1 loops=1)

39. 0.006 46.283 ↑ 2.0 1 1

Nested Loop (cost=5,987.43..6,093.50 rows=2 width=216) (actual time=46.278..46.283 rows=1 loops=1)

40. 0.002 46.249 ↑ 40.0 1 1

Limit (cost=5,987.00..5,987.20 rows=40 width=4) (actual time=46.244..46.249 rows=1 loops=1)

41. 0.005 46.247 ↑ 40.0 1 1

Group (cost=5,987.00..5,987.20 rows=40 width=4) (actual time=46.242..46.247 rows=1 loops=1)

  • Group Key: analytical_results_1.id
42. 0.015 46.242 ↑ 1.4 29 1

Sort (cost=5,987.00..5,987.10 rows=40 width=4) (actual time=46.241..46.242 rows=29 loops=1)

  • Sort Key: analytical_results_1.id DESC
  • Sort Method: quicksort Memory: 26kB
43. 0.111 46.227 ↑ 1.4 29 1

Hash Left Join (cost=3,256.56..5,985.94 rows=40 width=4) (actual time=46.219..46.227 rows=29 loops=1)

  • Hash Cond: (analytical_results_1.id = t33_1.result_id)
44. 15.623 44.748 ↑ 1.4 29 1

Hash Right Join (cost=3,108.28..5,837.45 rows=40 width=4) (actual time=44.743..44.748 rows=29 loops=1)

  • Hash Cond: (t25_1.level_id = analytical_results_1.level_id)
45. 14.949 14.949 ↑ 1.0 116,918 1

Seq Scan on worklist_assignments t25_1 (cost=0.00..2,144.18 rows=116,918 width=8) (actual time=0.010..14.949 rows=116,918 loops=1)

46. 0.014 14.176 ↑ 1.0 29 1

Hash (cost=3,107.91..3,107.91 rows=30 width=8) (actual time=14.176..14.176 rows=29 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
47. 0.021 14.162 ↑ 1.0 29 1

Nested Loop Left Join (cost=10.45..3,107.91 rows=30 width=8) (actual time=13.726..14.162 rows=29 loops=1)

48. 0.073 13.822 ↑ 1.0 29 1

Hash Left Join (cost=10.45..3,086.88 rows=30 width=50) (actual time=13.683..13.822 rows=29 loops=1)

  • Hash Cond: ((analytical_results_1.appraisal)::text = (t23_1.value)::text)
49. 0.015 13.631 ↑ 1.0 29 1

Nested Loop (cost=3.51..3,079.61 rows=30 width=16) (actual time=13.504..13.631 rows=29 loops=1)

50. 0.006 13.529 ↑ 1.0 29 1

Nested Loop (cost=3.24..3,070.90 rows=30 width=20) (actual time=13.482..13.529 rows=29 loops=1)

51. 0.001 13.459 ↑ 1.0 1 1

Nested Loop (cost=2.82..3,069.41 rows=1 width=24) (actual time=13.454..13.459 rows=1 loops=1)

52. 0.004 13.432 ↑ 1.0 1 1

Nested Loop (cost=2.54..3,069.08 rows=1 width=20) (actual time=13.427..13.432 rows=1 loops=1)

53. 0.002 13.416 ↑ 1.0 1 1

Nested Loop (cost=2.26..3,068.78 rows=1 width=20) (actual time=13.413..13.416 rows=1 loops=1)

54. 0.004 13.401 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.98..3,068.48 rows=1 width=24) (actual time=13.397..13.401 rows=1 loops=1)

55. 0.003 13.371 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.98..3,065.95 rows=1 width=66) (actual time=13.367..13.371 rows=1 loops=1)

56. 0.007 13.365 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.71..3,065.66 rows=1 width=30) (actual time=13.361..13.365 rows=1 loops=1)

57. 0.002 13.355 ↑ 1.0 1 1

Nested Loop (cost=1.42..3,065.33 rows=1 width=28) (actual time=13.352..13.355 rows=1 loops=1)

58. 0.003 13.341 ↑ 1.0 1 1

Nested Loop (cost=1.13..3,065.00 rows=1 width=28) (actual time=13.338..13.341 rows=1 loops=1)

59. 0.004 13.328 ↑ 1.0 1 1

Nested Loop (cost=0.84..3,062.49 rows=1 width=32) (actual time=13.326..13.328 rows=1 loops=1)

60. 0.031 13.252 ↓ 6.0 18 1

Nested Loop (cost=0.42..3,060.48 rows=3 width=16) (actual time=13.231..13.252 rows=18 loops=1)

61. 13.176 13.176 ↑ 1.0 1 1

Seq Scan on samples t04_1 (cost=0.00..3,053.05 rows=1 width=8) (actual time=13.175..13.176 rows=1 loops=1)

  • Filter: ((number)::text = '20/19008'::text)
  • Rows Removed by Filter: 50,243
62. 0.045 0.045 ↓ 3.0 18 1

Index Scan using index_sample_parameters_on_sample_id_and_position on sample_parameters t03_1 (cost=0.42..7.37 rows=6 width=20) (actual time=0.027..0.045 rows=18 loops=1)

  • Index Cond: (sample_id = t04_1.id)
63. 0.072 0.072 ↓ 0.0 0 18

Index Scan using index_analytical_results_sample_parameter_id on analytical_results analytical_results_1 (cost=0.42..0.66 rows=1 width=69) (actual time=0.004..0.004 rows=0 loops=18)

  • Index Cond: (sample_parameter_id = t03_1.id)
  • Filter: ((tenant_id = 1) AND (((state)::text = ANY ('{awaiting_review,awaiting_validation}'::text[])) OR (reviews_limit = 0)))
  • Rows Removed by Filter: 1
64. 0.010 0.010 ↑ 1.0 1 1

Index Scan using sample_registrations_pkey on sample_registrations t05_1 (cost=0.29..2.51 rows=1 width=12) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (id = t04_1.registration_id)
65. 0.012 0.012 ↑ 1.0 1 1

Index Scan using work_orders_pkey on work_orders t08_1 (cost=0.29..0.32 rows=1 width=20) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: (id = t03_1.work_order_id)
66. 0.003 0.003 ↓ 0.0 0 1

Index Scan using patients_pk on patients t10_1 (cost=0.29..0.33 rows=1 width=10) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (id = t08_1.patient_id)
67. 0.003 0.003 ↓ 0.0 0 1

Index Scan using master_types_pk on master_types t11_1 (cost=0.27..0.29 rows=1 width=52) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (((key)::text = 'SexTypes'::text) AND ((value)::text = (t10_1.sex)::text))
68. 0.001 0.026 ↓ 0.0 0 1

Append (cost=0.00..2.51 rows=2 width=38) (actual time=0.026..0.026 rows=0 loops=1)

69. 0.018 0.018 ↓ 0.0 0 1

Seq Scan on translations t12_2 (cost=0.00..0.00 rows=1 width=516) (actual time=0.017..0.018 rows=0 loops=1)

  • Filter: (((locale_code)::text = 'pt-PT'::text) AND ((key)::text = (t11_1.translation_key)::text))
70. 0.007 0.007 ↓ 0.0 0 1

Index Only Scan using translations_pt_pt_pk on "translations_pt-PT" t12_3 (cost=0.28..2.50 rows=1 width=38) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((locale_code = 'pt-PT'::text) AND (key = (t11_1.translation_key)::text))
  • Heap Fetches: 0
71. 0.013 0.013 ↑ 1.0 1 1

Index Only Scan using analytical_parameters_pkey on analytical_parameters t15_1 (cost=0.28..0.30 rows=1 width=4) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (id = t03_1.parameter_id)
  • Heap Fetches: 1
72. 0.012 0.012 ↑ 1.0 1 1

Index Scan using analytical_workflow_steps_pkey on analytical_workflow_steps t18_1 (cost=0.28..0.30 rows=1 width=8) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: (id = analytical_results_1.step_id)
73. 0.026 0.026 ↑ 1.0 1 1

Index Only Scan using analytical_steps_pkey on analytical_steps t19_1 (cost=0.28..0.32 rows=1 width=4) (actual time=0.025..0.026 rows=1 loops=1)

  • Index Cond: (id = t18_1.analytical_step_id)
  • Heap Fetches: 1
74. 0.064 0.064 ↑ 1.0 29 1

Index Only Scan using index_analytical_steps_users_on_analytical_step_id_and_user_id on analytical_steps_users analytical_steps_users_1 (cost=0.42..1.20 rows=30 width=8) (actual time=0.025..0.064 rows=29 loops=1)

  • Index Cond: (analytical_step_id = t19_1.id)
  • Heap Fetches: 29
75. 0.087 0.087 ↑ 1.0 1 29

Index Only Scan using users_pkey on users t20_1 (cost=0.27..0.29 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=29)

  • Index Cond: (id = analytical_steps_users_1.user_id)
  • Heap Fetches: 29
76. 0.061 0.118 ↑ 1.0 175 1

Hash (cost=4.75..4.75 rows=175 width=52) (actual time=0.118..0.118 rows=175 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 23kB
77. 0.057 0.057 ↑ 1.0 175 1

Seq Scan on master_types t23_1 (cost=0.00..4.75 rows=175 width=52) (actual time=0.021..0.057 rows=175 loops=1)

78. 0.058 0.319 ↑ 2.0 1 29

Append (cost=0.00..0.68 rows=2 width=38) (actual time=0.011..0.011 rows=1 loops=29)

79. 0.000 0.000 ↓ 0.0 0 29

Seq Scan on translations t24_2 (cost=0.00..0.00 rows=1 width=516) (actual time=0.000..0.000 rows=0 loops=29)

  • Filter: (((locale_code)::text = 'pt-PT'::text) AND ((key)::text = (t23_1.translation_key)::text))
80. 0.261 0.261 ↑ 1.0 1 29

Index Only Scan using translations_pt_pt_pk on "translations_pt-PT" t24_3 (cost=0.28..0.67 rows=1 width=38) (actual time=0.009..0.009 rows=1 loops=29)

  • Index Cond: ((locale_code = 'pt-PT'::text) AND (key = (t23_1.translation_key)::text))
  • Heap Fetches: 29
81. 0.623 1.368 ↑ 1.0 4,190 1

Hash (cost=95.90..95.90 rows=4,190 width=8) (actual time=1.368..1.368 rows=4,190 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 228kB
82. 0.745 0.745 ↑ 1.0 4,190 1

Seq Scan on analytical_result_boundaries t33_1 (cost=0.00..95.90 rows=4,190 width=8) (actual time=0.024..0.745 rows=4,190 loops=1)

83. 0.028 0.028 ↑ 1.0 1 1

Index Scan using analytical_results_pkey on analytical_results (cost=0.42..2.65 rows=1 width=216) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: (id = analytical_results_1.id)
  • Filter: ((tenant_id = 1) AND (((state)::text = ANY ('{awaiting_review,awaiting_validation}'::text[])) OR (reviews_limit = 0)))
84. 0.016 0.016 ↑ 1.0 1 1

Index Scan using sample_parameters_pkey on sample_parameters t03 (cost=0.42..0.98 rows=1 width=21) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: (id = analytical_results.sample_parameter_id)
85. 0.085 0.085 ↑ 1.0 1 1

Index Scan using samples_pkey on samples t04 (cost=0.29..0.33 rows=1 width=16) (actual time=0.084..0.085 rows=1 loops=1)

  • Index Cond: (id = t03.sample_id)
  • Filter: ((number)::text = '20/19008'::text)
86. 0.010 0.010 ↑ 1.0 1 1

Index Scan using result_definitions_pkey on result_definitions t01 (cost=0.28..0.31 rows=1 width=51) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (id = analytical_results.definition_id)
87. 0.013 0.013 ↑ 1.0 1 1

Index Scan using result_definition_suites_pkey on result_definition_suites t02 (cost=0.28..0.30 rows=1 width=53) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (id = analytical_results.definition_suite_id)
88. 0.011 0.011 ↑ 1.0 1 1

Index Scan using sample_registrations_pkey on sample_registrations t05 (cost=0.29..2.51 rows=1 width=199) (actual time=0.010..0.011 rows=1 loops=1)

  • Index Cond: (id = t04.registration_id)
89. 0.005 0.005 ↓ 0.0 0 1

Index Scan using urgency_levels_pkey on urgency_levels t06 (cost=0.13..0.15 rows=1 width=8) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: (id = t05.urgency_level_id)
90. 0.013 0.013 ↑ 1.0 1 1

Index Scan using lab_matrices_pkey on lab_matrices t07 (cost=0.15..0.17 rows=1 width=25) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (id = t05.lab_matrix_id)
91. 0.013 0.013 ↑ 1.0 1 1

Index Scan using work_orders_pkey on work_orders t08 (cost=0.29..0.32 rows=1 width=25) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (id = t03.work_order_id)
92. 0.008 0.008 ↑ 1.0 1 1

Index Scan using sample_types_pkey on sample_types t09 (cost=0.13..0.15 rows=1 width=23) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (id = t08.sample_type_id)
93. 0.004 0.004 ↓ 0.0 0 1

Index Scan using patients_pk on patients t10 (cost=0.29..0.33 rows=1 width=46) (actual time=0.003..0.004 rows=0 loops=1)

  • Index Cond: (id = t08.patient_id)
94. 0.003 0.003 ↓ 0.0 0 1

Index Scan using master_types_pk on master_types t11 (cost=0.27..0.29 rows=1 width=81) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (((key)::text = 'SexTypes'::text) AND ((value)::text = (t10.sex)::text))
95. 0.001 0.015 ↓ 0.0 0 1

Append (cost=0.00..2.51 rows=2 width=56) (actual time=0.015..0.015 rows=0 loops=1)

96. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on translations t12 (cost=0.00..0.00 rows=1 width=548) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (((locale_code)::text = 'pt-PT'::text) AND ((key)::text = (t11.translation_key)::text))
97. 0.007 0.007 ↓ 0.0 0 1

Index Scan using translations_pt_pt_pk on "translations_pt-PT" t12_1 (cost=0.28..2.50 rows=1 width=56) (actual time=0.006..0.007 rows=0 loops=1)

  • Index Cond: (((locale_code)::text = 'pt-PT'::text) AND ((key)::text = (t11.translation_key)::text))
98. 0.009 0.009 ↑ 1.0 1 1

Index Scan using entities_pkey on entities t13 (cost=0.28..0.31 rows=1 width=39) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (id = t08.store_id)
99. 0.003 0.003 ↓ 0.0 0 1

Index Scan using urgency_levels_pkey on urgency_levels t14 (cost=0.13..0.15 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (id = t08.urgency_level_id)
100. 0.012 0.012 ↑ 1.0 1 1

Index Scan using analytical_parameters_pkey on analytical_parameters t15 (cost=0.28..0.30 rows=1 width=54) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: (id = t03.parameter_id)
101. 0.004 0.004 ↓ 0.0 0 1

Index Scan using equipment_pkey on equipment t16 (cost=0.14..0.15 rows=1 width=520) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (id = t03.equipment_id)
102. 0.005 0.005 ↓ 0.0 0 1

Index Scan using analytical_methods_pkey on analytical_methods t17 (cost=0.28..0.30 rows=1 width=41) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (id = analytical_results.analytical_method_id)
103. 0.011 0.011 ↑ 1.0 1 1

Index Scan using analytical_workflow_steps_pkey on analytical_workflow_steps t18 (cost=0.28..0.30 rows=1 width=8) (actual time=0.010..0.011 rows=1 loops=1)

  • Index Cond: (id = analytical_results.step_id)
104. 0.013 0.013 ↑ 1.0 1 1

Index Scan using analytical_steps_pkey on analytical_steps t19 (cost=0.28..0.32 rows=1 width=70) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (id = t18.analytical_step_id)
105. 0.064 0.064 ↑ 1.0 29 1

Index Only Scan using index_analytical_steps_users_on_analytical_step_id_and_user_id on analytical_steps_users (cost=0.42..1.20 rows=30 width=8) (actual time=0.025..0.064 rows=29 loops=1)

  • Index Cond: (analytical_step_id = t19.id)
  • Heap Fetches: 29
106. 0.058 0.058 ↑ 1.0 1 29

Index Only Scan using users_pkey on users t20 (cost=0.27..0.29 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=29)

  • Index Cond: (id = analytical_steps_users.user_id)
  • Heap Fetches: 29
107. 0.058 0.058 ↑ 1.0 1 29

Index Scan using measurement_units_pkey on measurement_units t21 (cost=0.27..0.29 rows=1 width=26) (actual time=0.002..0.002 rows=1 loops=29)

  • Index Cond: (id = analytical_results.unit_id)
108. 0.029 0.029 ↑ 1.0 1 29

Index Scan using users_pkey on users t22 (cost=0.27..0.29 rows=1 width=22) (actual time=0.001..0.001 rows=1 loops=29)

  • Index Cond: (id = analytical_results.value_by_id)
109. 0.081 0.142 ↑ 1.0 175 1

Hash (cost=4.75..4.75 rows=175 width=56) (actual time=0.142..0.142 rows=175 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 24kB
110. 0.061 0.061 ↑ 1.0 175 1

Seq Scan on master_types t23 (cost=0.00..4.75 rows=175 width=56) (actual time=0.017..0.061 rows=175 loops=1)

111. 0.116 0.522 ↑ 2.0 1 29

Append (cost=0.00..0.68 rows=2 width=56) (actual time=0.017..0.018 rows=1 loops=29)

112. 0.000 0.000 ↓ 0.0 0 29

Seq Scan on translations t24 (cost=0.00..0.00 rows=1 width=548) (actual time=0.000..0.000 rows=0 loops=29)

  • Filter: (((locale_code)::text = 'pt-PT'::text) AND ((key)::text = (t23.translation_key)::text))
113. 0.406 0.406 ↑ 1.0 1 29

Index Scan using translations_pt_pt_pk on "translations_pt-PT" t24_1 (cost=0.28..0.67 rows=1 width=56) (actual time=0.014..0.014 rows=1 loops=29)

  • Index Cond: (((locale_code)::text = 'pt-PT'::text) AND ((key)::text = (t23.translation_key)::text))
114. 0.000 0.000 ↓ 0.0 0 29

Index Scan using worklists_pkey on worklists t26 (cost=0.29..0.30 rows=1 width=11) (actual time=0.000..0.000 rows=0 loops=29)

  • Index Cond: (id = t25.worklist_id)
115. 0.116 0.116 ↑ 1.0 1 29

Index Scan using index_parameter_assignments_on_parameter_id_and_registration_id on sample_parameter_assignments t27 (cost=0.42..0.49 rows=1 width=88) (actual time=0.004..0.004 rows=1 loops=29)

  • Index Cond: ((analytical_parameter_id = t03.parameter_id) AND (sample_registration_id = t05.id))
116. 0.058 0.058 ↑ 1.0 1 29

Index Scan using analytical_parameter_lists_pkey on analytical_parameter_lists t28 (cost=0.27..0.29 rows=1 width=47) (actual time=0.002..0.002 rows=1 loops=29)

  • Index Cond: (id = t27.analytical_parameter_list_id)
117. 0.087 0.087 ↓ 0.0 0 29

Index Scan using text_result_values_pkey on text_result_values t29 (cost=0.42..0.52 rows=1 width=23) (actual time=0.003..0.003 rows=0 loops=29)

  • Index Cond: (id = analytical_results.value_id)
118. 0.087 0.087 ↑ 1.0 1 29

Index Scan using numeric_result_values_pkey on numeric_result_values t30 (cost=0.42..0.59 rows=1 width=23) (actual time=0.003..0.003 rows=1 loops=29)

  • Index Cond: (id = analytical_results.value_id)
119. 0.029 0.029 ↓ 0.0 0 29

Index Scan using boolean_result_values_pkey on boolean_result_values t31 (cost=0.15..0.17 rows=1 width=5) (actual time=0.001..0.001 rows=0 loops=29)

  • Index Cond: (id = analytical_results.value_id)
120. 0.008 0.027 ↑ 1.0 14 1

Hash (cost=1.14..1.14 rows=14 width=42) (actual time=0.027..0.027 rows=14 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
121. 0.019 0.019 ↑ 1.0 14 1

Seq Scan on result_boundary_types t32 (cost=0.00..1.14 rows=14 width=42) (actual time=0.012..0.019 rows=14 loops=1)

122. 1.109 2.296 ↑ 1.0 4,190 1

Hash (cost=95.90..95.90 rows=4,190 width=31) (actual time=2.296..2.296 rows=4,190 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 318kB
123. 1.187 1.187 ↑ 1.0 4,190 1

Seq Scan on analytical_result_boundaries t33 (cost=0.00..95.90 rows=4,190 width=31) (actual time=0.015..1.187 rows=4,190 loops=1)

124. 0.009 0.022 ↑ 1.0 14 1

Hash (cost=1.14..1.14 rows=14 width=42) (actual time=0.022..0.022 rows=14 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
125. 0.013 0.013 ↑ 1.0 14 1

Seq Scan on result_boundary_types t34 (cost=0.00..1.14 rows=14 width=42) (actual time=0.010..0.013 rows=14 loops=1)