explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IPla

Settings
# exclusive inclusive rows x rows loops node
1. 61.989 3,655.116 ↑ 11.7 24,534 1

GroupAggregate (cost=11,866,248.67..23,514,355.82 rows=285,899 width=1,349) (actual time=3,539.652..3,655.116 rows=24,534 loops=1)

  • Group Key: w.number, estado_req.value, s.number, sr.received_at, sp.reception_date, sr.harvested_at, sr.lab_matrix_id, lm.name, sr.sample_reference_id, sre.name, sp.parameter_id, ap.name, estado_parametro.value, sp.sample_type_id, st.name, fsd.department_id, d.name, sp.functional_structure_id, fs.name, w.date_out, (CASE WHEN ((SubPlan 1) > 0) THEN (SubPlan 2) WHEN ((SubPlan 3) > 0) THEN (SubPlan 4) ELSE (SubPlan 5) END), (CASE WHEN ((SubPlan 6) > 0) THEN (SubPlan 7) WHEN ((SubPlan 8) > 0) THEN (SubPlan 9) ELSE (SubPlan 10) END)
2. 492.840 3,593.127 ↑ 6.5 43,868 1

Sort (cost=11,866,248.67..11,866,963.42 rows=285,899 width=1,317) (actual time=3,539.634..3,593.127 rows=43,868 loops=1)

  • Sort Key: w.number, estado_req.value, s.number, sr.received_at, sp.reception_date, sr.harvested_at, sr.lab_matrix_id, lm.name, sr.sample_reference_id, sre.name, sp.parameter_id, ap.name, estado_parametro.value, sp.sample_type_id, st.name, fsd.department_id, d.name, sp.functional_structure_id, fs.name, w.date_out, (CASE WHEN ((SubPlan 1) > 0) THEN (SubPlan 2) WHEN ((SubPlan 3) > 0) THEN (SubPlan 4) ELSE (SubPlan 5) END), (CASE WHEN ((SubPlan 6) > 0) THEN (SubPlan 7) WHEN ((SubPlan 8) > 0) THEN (SubPlan 9) ELSE (SubPlan 10) END)
  • Sort Method: external merge Disk: 15,144kB
3. 141.240 3,100.287 ↑ 6.5 43,868 1

Nested Loop Left Join (cost=8,342.11..11,648,024.26 rows=285,899 width=1,317) (actual time=91.000..3,100.287 rows=43,868 loops=1)

4. 55.787 700.373 ↓ 2.2 43,868 1

Nested Loop Left Join (cost=8,342.11..13,902.12 rows=20,255 width=1,304) (actual time=90.829..700.373 rows=43,868 loops=1)

5. 0.000 118.170 ↓ 30.6 43,868 1

Gather (cost=8,342.11..13,407.58 rows=1,435 width=1,296) (actual time=90.789..118.170 rows=43,868 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
6. 8.026 332.456 ↓ 26.0 21,934 2 / 2

Hash Left Join (cost=7,342.11..12,264.08 rows=844 width=1,296) (actual time=60.853..332.456 rows=21,934 loops=2)

  • Hash Cond: (sr.sample_reference_id = sre.id)
7. 19.196 323.871 ↓ 26.0 21,934 2 / 2

Nested Loop Left Join (cost=7,323.47..12,243.23 rows=844 width=1,266) (actual time=60.278..323.871 rows=21,934 loops=2)

  • Join Filter: (ar.value_by_id IS NOT NULL)
8. 8.922 260.872 ↓ 26.0 21,902 2 / 2

Hash Join (cost=7,323.05..11,859.76 rows=844 width=1,266) (actual time=60.236..260.872 rows=21,902 loops=2)

  • Hash Cond: (sr.lab_matrix_id = lm.id)
9. 10.390 251.551 ↓ 26.0 21,902 2 / 2

Hash Join (cost=7,306.43..11,840.89 rows=844 width=1,245) (actual time=59.703..251.551 rows=21,902 loops=2)

  • Hash Cond: (sp.functional_structure_id = fsd.functional_structure_id)
10. 8.023 240.481 ↓ 26.0 21,902 2 / 2

Nested Loop (cost=7,297.99..11,820.85 rows=844 width=674) (actual time=59.009..240.481 rows=21,902 loops=2)

11. 7.055 183.390 ↓ 26.9 12,267 2 / 2

Nested Loop (cost=7,297.57..11,540.21 rows=456 width=658) (actual time=58.982..183.390 rows=12,267 loops=2)

12. 4.810 151.801 ↓ 26.9 12,267 2 / 2

Hash Join (cost=7,297.29..11,404.10 rows=456 width=612) (actual time=58.962..151.801 rows=12,267 loops=2)

  • Hash Cond: (sp.sample_type_id = st.id)
13. 13.901 146.798 ↓ 26.9 12,268 2 / 2

Nested Loop (cost=7,296.11..11,401.09 rows=456 width=96) (actual time=58.758..146.798 rows=12,268 loops=2)

  • Join Filter: (s.registration_id = sr.id)
14. 32.625 108.014 ↓ 24.4 12,442 2 / 2

Parallel Hash Join (cost=7,295.82..11,233.34 rows=509 width=80) (actual time=58.728..108.014 rows=12,442 loops=2)

  • Hash Cond: ((spa.sample_registration_id = s.registration_id) AND (spa.analytical_parameter_id = sp.parameter_id))
15. 17.078 17.078 ↑ 1.2 86,494 2 / 2

Parallel Seq Scan on sample_parameter_assignments spa (cost=0.00..3,172.37 rows=101,737 width=8) (actual time=0.011..17.078 rows=86,494 loops=2)

16. 6.860 58.311 ↓ 1.1 12,442 2 / 2

Parallel Hash (cost=7,124.39..7,124.39 rows=11,429 width=72) (actual time=58.311..58.311 rows=12,442 loops=2)

  • Buckets: 32,768 Batches: 1 Memory Usage: 3,040kB
17. 5.672 51.451 ↓ 1.1 12,442 2 / 2

Parallel Hash Join (cost=2,744.19..7,124.39 rows=11,429 width=72) (actual time=20.955..51.451 rows=12,442 loops=2)

  • Hash Cond: (sp.sample_id = s.id)
18. 14.803 33.688 ↓ 1.1 12,442 2 / 2

Hash Join (cost=855.96..5,206.15 rows=11,429 width=60) (actual time=8.233..33.688 rows=12,442 loops=2)

  • Hash Cond: (sp.work_order_id = w.id)
19. 10.753 10.753 ↓ 1.2 82,816 2 / 2

Parallel Seq Scan on sample_parameters sp (cost=0.00..4,167.79 rows=69,479 width=41) (actual time=0.012..10.753 rows=82,816 loops=2)

20. 1.220 8.132 ↓ 1.0 5,455 2 / 2

Hash (cost=789.08..789.08 rows=5,350 width=23) (actual time=8.132..8.132 rows=5,455 loops=2)

  • Buckets: 8,192 Batches: 1 Memory Usage: 377kB
21. 6.912 6.912 ↓ 1.0 5,455 2 / 2

Index Scan using idx_received_at on work_orders w (cost=0.29..789.08 rows=5,350 width=23) (actual time=0.040..6.912 rows=5,455 loops=2)

  • Index Cond: ((received_at >= '2019-12-31 23:59:59'::timestamp without time zone) AND (received_at <= '2020-01-31 23:59:59'::timestamp without time zone))
  • Filter: active
  • Rows Removed by Filter: 55
22. 6.486 12.091 ↑ 1.2 25,124 2 / 2

Parallel Hash (cost=1,516.99..1,516.99 rows=29,699 width=16) (actual time=12.091..12.091 rows=25,124 loops=2)

  • Buckets: 65,536 Batches: 1 Memory Usage: 3,136kB
23. 5.605 5.605 ↓ 1.7 50,248 1 / 2

Parallel Seq Scan on samples s (cost=0.00..1,516.99 rows=29,699 width=16) (actual time=0.006..11.210 rows=50,248 loops=1)

24. 24.883 24.883 ↑ 1.0 1 24,883 / 2

Index Scan using sample_registrations_pkey on sample_registrations sr (cost=0.29..0.32 rows=1 width=28) (actual time=0.002..0.002 rows=1 loops=24,883)

  • Index Cond: (id = spa.sample_registration_id)
  • Filter: active
  • Rows Removed by Filter: 0
25. 0.007 0.193 ↑ 1.0 8 2 / 2

Hash (cost=1.08..1.08 rows=8 width=520) (actual time=0.193..0.193 rows=8 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
26. 0.186 0.186 ↑ 1.0 8 2 / 2

Seq Scan on sample_types st (cost=0.00..1.08 rows=8 width=520) (actual time=0.184..0.186 rows=8 loops=2)

27. 24.534 24.534 ↑ 1.0 1 24,534 / 2

Index Scan using analytical_parameters_pkey on analytical_parameters ap (cost=0.28..0.30 rows=1 width=54) (actual time=0.002..0.002 rows=1 loops=24,534)

  • Index Cond: (id = spa.analytical_parameter_id)
28. 49.068 49.068 ↑ 2.5 2 24,534 / 2

Index Scan using index_analytical_results_sample_parameter_id on analytical_results ar (cost=0.42..0.57 rows=5 width=20) (actual time=0.003..0.004 rows=2 loops=24,534)

  • Index Cond: (sample_parameter_id = sp.id)
29. 0.027 0.680 ↑ 1.0 82 2 / 2

Hash (cost=7.41..7.41 rows=82 width=579) (actual time=0.680..0.680 rows=82 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 20kB
30. 0.030 0.653 ↑ 1.0 82 2 / 2

Hash Join (cost=5.05..7.41 rows=82 width=579) (actual time=0.610..0.653 rows=82 loops=2)

  • Hash Cond: (fsd.functional_structure_id = fs.id)
31. 0.034 0.412 ↑ 1.0 82 2 / 2

Hash Join (cost=1.20..3.34 rows=82 width=524) (actual time=0.390..0.412 rows=82 loops=2)

  • Hash Cond: (fsd.department_id = d.id)
32. 0.189 0.189 ↑ 1.0 82 2 / 2

Seq Scan on functional_structures_departments fsd (cost=0.00..1.82 rows=82 width=8) (actual time=0.186..0.189 rows=82 loops=2)

33. 0.008 0.189 ↑ 1.0 9 2 / 2

Hash (cost=1.09..1.09 rows=9 width=520) (actual time=0.189..0.189 rows=9 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
34. 0.181 0.181 ↑ 1.0 9 2 / 2

Seq Scan on departments d (cost=0.00..1.09 rows=9 width=520) (actual time=0.179..0.181 rows=9 loops=2)

35. 0.019 0.211 ↑ 1.0 82 2 / 2

Hash (cost=2.82..2.82 rows=82 width=55) (actual time=0.211..0.211 rows=82 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
36. 0.192 0.192 ↑ 1.0 82 2 / 2

Seq Scan on functional_structures fs (cost=0.00..2.82 rows=82 width=55) (actual time=0.176..0.192 rows=82 loops=2)

37. 0.098 0.399 ↑ 1.0 339 2 / 2

Hash (cost=12.39..12.39 rows=339 width=25) (actual time=0.399..0.399 rows=339 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 28kB
38. 0.301 0.301 ↑ 1.0 339 2 / 2

Seq Scan on lab_matrices lm (cost=0.00..12.39 rows=339 width=25) (actual time=0.220..0.301 rows=339 loops=2)

39. 43.803 43.803 ↑ 1.0 1 43,803 / 2

Index Scan using index_analytical_result_validations_result_id on analytical_result_validations arv (cost=0.42..0.44 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=43,803)

  • Index Cond: (result_id = ar.id)
40. 0.110 0.559 ↑ 1.0 517 2 / 2

Hash (cost=12.17..12.17 rows=517 width=34) (actual time=0.559..0.559 rows=517 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 43kB
41. 0.449 0.449 ↑ 1.0 517 2 / 2

Seq Scan on sample_references sre (cost=0.00..12.17 rows=517 width=34) (actual time=0.353..0.449 rows=517 loops=2)

42. 87.736 526.416 ↑ 2.0 1 43,868

Append (cost=0.00..0.32 rows=2 width=56) (actual time=0.012..0.012 rows=1 loops=43,868)

43. 0.000 0.000 ↓ 0.0 0 43,868

Seq Scan on translations estado_req (cost=0.00..0.00 rows=1 width=548) (actual time=0.000..0.000 rows=0 loops=43,868)

  • Filter: (((locale_code)::text = 'pt-PT'::text) AND ((key)::text = ('samples.work-orders.sample-registrations.state.'::text || (w.state)::text)))
44. 438.680 438.680 ↑ 1.0 1 43,868

Index Scan using translations_pt_pt_pk on "translations_pt-PT" estado_req_1 (cost=0.28..0.31 rows=1 width=56) (actual time=0.009..0.010 rows=1 loops=43,868)

  • Index Cond: (((locale_code)::text = 'pt-PT'::text) AND ((key)::text = ('samples.work-orders.sample-registrations.state.'::text || (w.state)::text)))
45. 87.736 482.548 ↑ 2.0 1 43,868

Append (cost=0.00..0.31 rows=2 width=56) (actual time=0.011..0.011 rows=1 loops=43,868)

46. 0.000 0.000 ↓ 0.0 0 43,868

Seq Scan on translations estado_parametro (cost=0.00..0.00 rows=1 width=548) (actual time=0.000..0.000 rows=0 loops=43,868)

  • Filter: (((locale_code)::text = 'pt-PT'::text) AND ((key)::text = ('samples.analytical-results.state.'::text || (sp.state)::text)))
47. 394.812 394.812 ↑ 1.0 1 43,868

Index Scan using translations_pt_pt_pk on "translations_pt-PT" estado_parametro_1 (cost=0.28..0.30 rows=1 width=56) (actual time=0.008..0.009 rows=1 loops=43,868)

  • Index Cond: (((locale_code)::text = 'pt-PT'::text) AND ((key)::text = ('samples.analytical-results.state.'::text || (sp.state)::text)))
48.          

SubPlan (for Nested Loop Left Join)

49. 87.736 307.076 ↑ 1.0 1 43,868

Aggregate (cost=4.50..4.51 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=43,868)

50. 43.868 219.340 ↓ 0.0 0 43,868

Bitmap Heap Scan on analytical_reports report_parametro (cost=3.38..4.49 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=43,868)

  • Recheck Cond: ((sample_id = s.id) AND (work_order_id = w.id))
  • Filter: (sample_parameter_id = sp.id)
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=40,039
51. 48.048 175.472 ↓ 0.0 0 43,868

BitmapAnd (cost=3.38..3.38 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=43,868)

52. 87.736 87.736 ↑ 6.0 1 43,868

Bitmap Index Scan on index_analytical_reports_on_sample_id (cost=0.00..1.56 rows=6 width=0) (actual time=0.002..0.002 rows=1 loops=43,868)

  • Index Cond: (sample_id = s.id)
53. 39.688 39.688 ↓ 4.3 26 9,922

Bitmap Index Scan on index_analytical_reports_on_work_order_id_and_preview (cost=0.00..1.56 rows=6 width=0) (actual time=0.004..0.004 rows=26 loops=9,922)

  • Index Cond: (work_order_id = w.id)
54. 0.000 0.000 ↓ 0.0 0

Limit (cost=3.77..3.78 rows=1 width=8) (never executed)

55. 0.000 0.000 ↓ 0.0 0

Sort (cost=3.77..3.78 rows=1 width=8) (never executed)

  • Sort Key: report_parametro_1.created_at
56. 0.000 0.000 ↓ 0.0 0

Index Scan using index_analytical_reports_on_work_order_id_and_preview on analytical_reports report_parametro_1 (cost=0.42..3.76 rows=1 width=8) (never executed)

  • Index Cond: ((work_order_id = w.id) AND (preview = false))
  • Filter: ((NOT partial) AND (sample_id = s.id) AND (sample_parameter_id = sp.id))
57. 131.604 307.076 ↑ 1.0 1 43,868

Aggregate (cost=4.49..4.50 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=43,868)

58. 43.868 175.472 ↑ 1.0 1 43,868

Bitmap Heap Scan on analytical_reports report_amostra (cost=3.38..4.49 rows=1 width=0) (actual time=0.004..0.004 rows=1 loops=43,868)

  • Recheck Cond: ((sample_id = s.id) AND (work_order_id = w.id))
  • Filter: (sample_parameter_id IS NULL)
  • Heap Blocks: exact=40,039
59. 4.180 131.604 ↓ 0.0 0 43,868

BitmapAnd (cost=3.38..3.38 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=43,868)

60. 87.736 87.736 ↑ 6.0 1 43,868

Bitmap Index Scan on index_analytical_reports_on_sample_id (cost=0.00..1.56 rows=6 width=0) (actual time=0.002..0.002 rows=1 loops=43,868)

  • Index Cond: (sample_id = s.id)
61. 39.688 39.688 ↓ 4.3 26 9,922

Bitmap Index Scan on index_analytical_reports_on_work_order_id_and_preview (cost=0.00..1.56 rows=6 width=0) (actual time=0.004..0.004 rows=26 loops=9,922)

  • Index Cond: (work_order_id = w.id)
62. 9.922 109.142 ↑ 1.0 1 9,922

Limit (cost=3.77..3.77 rows=1 width=8) (actual time=0.011..0.011 rows=1 loops=9,922)

63. 9.922 99.220 ↑ 1.0 1 9,922

Sort (cost=3.77..3.77 rows=1 width=8) (actual time=0.010..0.010 rows=1 loops=9,922)

  • Sort Key: report_amostra_1.created_at
  • Sort Method: quicksort Memory: 25kB
64. 89.298 89.298 ↑ 1.0 1 9,922

Index Scan using index_analytical_reports_on_work_order_id_and_preview on analytical_reports report_amostra_1 (cost=0.42..3.76 rows=1 width=8) (actual time=0.006..0.009 rows=1 loops=9,922)

  • Index Cond: ((work_order_id = w.id) AND (preview = false))
  • Filter: ((sample_parameter_id IS NULL) AND (NOT partial) AND (sample_id = s.id))
  • Rows Removed by Filter: 7
65. 33.946 169.730 ↓ 0.0 0 33,946

Limit (cost=3.76..3.77 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=33,946)

66. 33.946 135.784 ↓ 0.0 0 33,946

Sort (cost=3.76..3.77 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=33,946)

  • Sort Key: report_requisicao.created_at
  • Sort Method: quicksort Memory: 25kB
67. 101.838 101.838 ↓ 0.0 0 33,946

Index Scan using index_analytical_reports_on_work_order_id_and_preview on analytical_reports report_requisicao (cost=0.42..3.75 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=33,946)

  • Index Cond: ((work_order_id = w.id) AND (preview = false))
  • Filter: ((sample_id IS NULL) AND (sample_parameter_id IS NULL) AND (NOT partial))
  • Rows Removed by Filter: 1
68. 87.736 307.076 ↑ 1.0 1 43,868

Aggregate (cost=4.50..4.51 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=43,868)

69. 87.736 219.340 ↓ 0.0 0 43,868

Bitmap Heap Scan on analytical_reports report_parametro_2 (cost=3.38..4.49 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=43,868)

  • Recheck Cond: ((sample_id = s.id) AND (work_order_id = w.id))
  • Filter: (sample_parameter_id = sp.id)
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=40,039
70. 4.180 131.604 ↓ 0.0 0 43,868

BitmapAnd (cost=3.38..3.38 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=43,868)

71. 87.736 87.736 ↑ 6.0 1 43,868

Bitmap Index Scan on index_analytical_reports_on_sample_id (cost=0.00..1.56 rows=6 width=0) (actual time=0.002..0.002 rows=1 loops=43,868)

  • Index Cond: (sample_id = s.id)
72. 39.688 39.688 ↓ 4.3 26 9,922

Bitmap Index Scan on index_analytical_reports_on_work_order_id_and_preview (cost=0.00..1.56 rows=6 width=0) (actual time=0.004..0.004 rows=26 loops=9,922)

  • Index Cond: (work_order_id = w.id)
73. 0.000 0.000 ↓ 0.0 0

Limit (cost=3.77..3.78 rows=1 width=8) (never executed)

74. 0.000 0.000 ↓ 0.0 0

Sort (cost=3.77..3.78 rows=1 width=8) (never executed)

  • Sort Key: report_parametro_3.created_at
75. 0.000 0.000 ↓ 0.0 0

Index Scan using index_analytical_reports_on_work_order_id_and_preview on analytical_reports report_parametro_3 (cost=0.42..3.76 rows=1 width=8) (never executed)

  • Index Cond: ((work_order_id = w.id) AND (preview = false))
  • Filter: (partial AND (sample_id = s.id) AND (sample_parameter_id = sp.id))
76. 131.604 307.076 ↑ 1.0 1 43,868

Aggregate (cost=4.49..4.50 rows=1 width=8) (actual time=0.006..0.007 rows=1 loops=43,868)

77. 43.868 175.472 ↑ 1.0 1 43,868

Bitmap Heap Scan on analytical_reports report_amostra_2 (cost=3.38..4.49 rows=1 width=0) (actual time=0.004..0.004 rows=1 loops=43,868)

  • Recheck Cond: ((sample_id = s.id) AND (work_order_id = w.id))
  • Filter: (sample_parameter_id IS NULL)
  • Heap Blocks: exact=40,039
78. 4.180 131.604 ↓ 0.0 0 43,868

BitmapAnd (cost=3.38..3.38 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=43,868)

79. 87.736 87.736 ↑ 6.0 1 43,868

Bitmap Index Scan on index_analytical_reports_on_sample_id (cost=0.00..1.56 rows=6 width=0) (actual time=0.002..0.002 rows=1 loops=43,868)

  • Index Cond: (sample_id = s.id)
80. 39.688 39.688 ↓ 4.3 26 9,922

Bitmap Index Scan on index_analytical_reports_on_work_order_id_and_preview (cost=0.00..1.56 rows=6 width=0) (actual time=0.004..0.004 rows=26 loops=9,922)

  • Index Cond: (work_order_id = w.id)
81. 9.922 99.220 ↓ 0.0 0 9,922

Limit (cost=3.77..3.77 rows=1 width=8) (actual time=0.010..0.010 rows=0 loops=9,922)

82. 9.922 89.298 ↓ 0.0 0 9,922

Sort (cost=3.77..3.77 rows=1 width=8) (actual time=0.009..0.009 rows=0 loops=9,922)

  • Sort Key: report_amostra_3.created_at
  • Sort Method: quicksort Memory: 25kB
83. 79.376 79.376 ↓ 0.0 0 9,922

Index Scan using index_analytical_reports_on_work_order_id_and_preview on analytical_reports report_amostra_3 (cost=0.42..3.76 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=9,922)

  • Index Cond: ((work_order_id = w.id) AND (preview = false))
  • Filter: ((sample_parameter_id IS NULL) AND partial AND (sample_id = s.id))
  • Rows Removed by Filter: 7
84. 33.946 169.730 ↑ 1.0 1 33,946

Limit (cost=3.76..3.77 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=33,946)

85. 33.946 135.784 ↑ 1.0 1 33,946

Sort (cost=3.76..3.77 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=33,946)

  • Sort Key: report_requisicao_1.created_at
  • Sort Method: quicksort Memory: 25kB
86. 101.838 101.838 ↑ 1.0 1 33,946

Index Scan using index_analytical_reports_on_work_order_id_and_preview on analytical_reports report_requisicao_1 (cost=0.42..3.75 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=33,946)

  • Index Cond: ((work_order_id = w.id) AND (preview = false))
  • Filter: ((sample_id IS NULL) AND (sample_parameter_id IS NULL) AND partial)
  • Rows Removed by Filter: 0