explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ydYCz : sfdsfsfref$^%&$%^%4r030303fdl,wemo340

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 2,972.789 ↑ 35,976,175,294,394,880.0 11 1

Hash Left Join (cost=369.21..23,618,905,218,092.83 rows=395,737,928,238,343,680 width=10,202) (actual time=2,972.704..2,972.789 rows=11 loops=1)

  • Hash Cond: (m0_.id = m27_.id)
  • Functions: 192
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 22.083 ms, Inlining 6.542 ms, Optimization 1455.107 ms, Emission 1505.268 ms, Total 2989.001 ms
2. 0.008 2,972.777 ↑ 795,933,081,734,400.0 11 1

Hash Left Join (cost=308.36..593,239,115,306.38 rows=8,755,263,899,078,400 width=10,198) (actual time=2,972.695..2,972.777 rows=11 loops=1)

  • Hash Cond: (m0_.id = m26_.id)
3. 0.010 2,972.767 ↑ 19,508,163,768,000.0 11 1

Hash Left Join (cost=252.46..28,770,635,694.04 rows=214,589,801,448,000 width=10,190) (actual time=2,972.689..2,972.767 rows=11 loops=1)

  • Hash Cond: (m0_.id = m25_.id)
4. 0.009 2,972.755 ↑ 812,840,157,000.0 11 1

Hash Left Join (cost=215.46..5,216,983,361.82 rows=8,941,241,727,000 width=10,154) (actual time=2,972.680..2,972.755 rows=11 loops=1)

  • Hash Cond: (m0_.id = m23_.id)
5. 0.007 2,972.745 ↑ 56,447,233,125.0 11 1

Hash Left Join (cost=189.26..3,577,475,409.47 rows=620,919,564,375 width=10,074) (actual time=2,972.674..2,972.745 rows=11 loops=1)

  • Hash Cond: (m0_.id = m24_.id)
6. 0.010 2,972.736 ↑ 56,447,233,125.0 11 1

Hash Left Join (cost=179.03..1,809,406,939.68 rows=620,919,564,375 width=4,906) (actual time=2,972.668..2,972.736 rows=11 loops=1)

  • Hash Cond: (m0_.id = m22_.id)
7. 0.007 2,972.713 ↑ 56,447,233,125.0 11 1

Hash Left Join (cost=177.99..41,338,479.08 rows=620,919,564,375 width=4,894) (actual time=2,972.649..2,972.713 rows=11 loops=1)

  • Hash Cond: (m0_.id = m16_.id)
8. 0.009 2,972.705 ↑ 1,383,510,614.9 11 1

Hash Left Join (cost=122.09..1,306,560.49 rows=15,218,616,764 width=4,886) (actual time=2,972.643..2,972.705 rows=11 loops=1)

  • Hash Cond: (m0_.id = m21_.id)
9. 0.010 2,972.694 ↑ 38,218,525.3 11 1

Hash Left Join (cost=71.36..200,365.88 rows=420,403,778 width=4,873) (actual time=2,972.635..2,972.694 rows=11 loops=1)

  • Hash Cond: (m0_.id = m20_.id)
10. 0.007 2,972.682 ↑ 1,317,880.2 11 1

Merge Left Join (cost=28.74..162,158.24 rows=14,496,682 width=4,849) (actual time=2,972.628..2,972.682 rows=11 loops=1)

  • Merge Cond: (m0_.id = m19_.id)
11. 0.007 2,972.673 ↑ 1,317,880.2 11 1

Merge Left Join (cost=28.61..123,009.05 rows=14,496,682 width=4,845) (actual time=2,972.621..2,972.673 rows=11 loops=1)

  • Merge Cond: (m0_.id = m18_.id)
12. 0.006 2,972.663 ↑ 1,317,880.2 11 1

Merge Left Join (cost=28.49..83,859.86 rows=14,496,682 width=4,841) (actual time=2,972.616..2,972.663 rows=11 loops=1)

  • Merge Cond: (m0_.id = m17_.id)
13. 0.007 2,972.655 ↑ 1,317,880.2 11 1

Merge Left Join (cost=28.36..44,710.67 rows=14,496,682 width=4,800) (actual time=2,972.610..2,972.655 rows=11 loops=1)

  • Merge Cond: (m0_.id = m15_.id)
14. 0.007 2,972.645 ↑ 1,317,880.2 11 1

Merge Left Join (cost=28.24..5,561.49 rows=14,496,682 width=4,252) (actual time=2,972.605..2,972.645 rows=11 loops=1)

  • Merge Cond: (m0_.id = m8_.id)
15. 0.005 2,972.631 ↑ 33,966.0 11 1

Merge Left Join (cost=28.09..809.06 rows=373,626 width=4,242) (actual time=2,972.594..2,972.631 rows=11 loops=1)

  • Merge Cond: (m0_.id = m12_.id)
16. 0.006 2,972.625 ↑ 1,998.0 11 1

Merge Left Join (cost=27.94..475.31 rows=21,978 width=4,178) (actual time=2,972.590..2,972.625 rows=11 loops=1)

  • Merge Cond: (m0_.id = m14_.id)
17. 0.007 2,972.612 ↑ 1,998.0 11 1

Merge Left Join (cost=26.86..401.68 rows=21,978 width=4,177) (actual time=2,972.580..2,972.612 rows=11 loops=1)

  • Merge Cond: (m0_.id = m13_.id)
18. 0.006 2,972.599 ↑ 1,998.0 11 1

Merge Left Join (cost=25.75..323.62 rows=21,978 width=4,176) (actual time=2,972.571..2,972.599 rows=11 loops=1)

  • Merge Cond: (m0_.id = m11_.id)
19. 0.006 2,972.589 ↑ 1,998.0 11 1

Merge Left Join (cost=24.73..263.25 rows=21,978 width=4,160) (actual time=2,972.564..2,972.589 rows=11 loops=1)

  • Merge Cond: (m0_.id = m10_.id)
20. 0.006 2,972.577 ↑ 1,998.0 11 1

Merge Left Join (cost=23.71..202.88 rows=21,978 width=3,617) (actual time=2,972.554..2,972.577 rows=11 loops=1)

  • Merge Cond: (m0_.id = m9_.id)
21. 0.005 2,972.566 ↑ 1,998.0 11 1

Merge Left Join (cost=22.69..142.51 rows=21,978 width=3,609) (actual time=2,972.546..2,972.566 rows=11 loops=1)

  • Merge Cond: (m0_.id = m5_.id)
22. 0.005 2,972.558 ↑ 93.4 11 1

Merge Left Join (cost=22.54..66.79 rows=1,027 width=3,565) (actual time=2,972.540..2,972.558 rows=11 loops=1)

  • Merge Cond: (m0_.id = m1_.id)
23. 0.009 2,972.550 ↑ 42.8 11 1

Nested Loop Left Join (cost=7.71..45.52 rows=471 width=2,887) (actual time=2,972.535..2,972.550 rows=11 loops=1)

24. 0.007 2,972.530 ↑ 1.0 11 1

Merge Left Join (cost=7.55..7.62 rows=11 width=2,881) (actual time=2,972.526..2,972.530 rows=11 loops=1)

  • Merge Cond: (m0_.id = m7_.id)
25. 0.020 2,972.517 ↑ 1.0 11 1

Sort (cost=6.53..6.56 rows=11 width=2,865) (actual time=2,972.516..2,972.517 rows=11 loops=1)

  • Sort Key: m0_.id
  • Sort Method: quicksort Memory: 27kB
26. 0.006 2,972.497 ↑ 1.0 11 1

Hash Left Join (cost=3.07..6.34 rows=11 width=2,865) (actual time=2,972.481..2,972.497 rows=11 loops=1)

  • Hash Cond: (m0_.id = m6_.id)
27. 0.005 2,972.487 ↑ 1.0 11 1

Hash Left Join (cost=2.04..5.29 rows=11 width=2,861) (actual time=2,972.472..2,972.487 rows=11 loops=1)

  • Hash Cond: (m0_.id = m4_.id)
28. 0.019 2,972.477 ↑ 1.0 11 1

Hash Left Join (cost=1.02..4.24 rows=11 width=2,781) (actual time=2,972.463..2,972.477 rows=11 loops=1)

  • Hash Cond: (m0_.id = m3_.id)
29. 2,972.443 2,972.443 ↑ 1.0 11 1

Seq Scan on medical_activity m0_ (cost=0.00..3.19 rows=11 width=717) (actual time=2,972.431..2,972.443 rows=11 loops=1)

  • Filter: (id = ANY ('{33,32,31,30,29,28,27,26,23,7,5}'::integer[]))
  • Rows Removed by Filter: 36
30. 0.004 0.015 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=2,068) (actual time=0.015..0.015 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
31. 0.011 0.011 ↑ 1.0 1 1

Seq Scan on ma_allergies_check m3_ (cost=0.00..1.01 rows=1 width=2,068) (actual time=0.011..0.011 rows=1 loops=1)

32. 0.001 0.005 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=84) (actual time=0.005..0.005 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
33. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on ma_scale_barthel_check m4_ (cost=0.00..1.01 rows=1 width=84) (actual time=0.003..0.004 rows=1 loops=1)

34. 0.001 0.004 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
35. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on ma_body_height_measurement m6_ (cost=0.00..1.01 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=1)

36. 0.003 0.006 ↑ 1.0 1 1

Sort (cost=1.02..1.02 rows=1 width=20) (actual time=0.006..0.006 rows=1 loops=1)

  • Sort Key: m7_.id
  • Sort Method: quicksort Memory: 25kB
37. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on ma_body_weight_measurement m7_ (cost=0.00..1.01 rows=1 width=20) (actual time=0.003..0.003 rows=1 loops=1)

38. 0.011 0.011 ↓ 0.0 0 11

Index Scan using ma_activities_of_daily_living_pkey on ma_activities_of_daily_living m2_ (cost=0.15..3.45 rows=1 width=10) (actual time=0.001..0.001 rows=0 loops=11)

  • Index Cond: (id = m0_.id)
39. 0.001 0.003 ↓ 0.0 0 1

Sort (cost=14.83..15.10 rows=110 width=682) (actual time=0.003..0.003 rows=0 loops=1)

  • Sort Key: m1_.id
  • Sort Method: quicksort Memory: 25kB
40. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on ma_abbreviated_mental_test_score m1_ (cost=0.00..11.10 rows=110 width=682) (actual time=0.001..0.002 rows=0 loops=1)

41. 0.003 0.003 ↓ 0.0 0 1

Index Scan using ma_scale_barthel_adl_check_pkey on ma_scale_barthel_adl_check m5_ (cost=0.15..60.20 rows=1,070 width=48) (actual time=0.003..0.003 rows=0 loops=1)

42. 0.002 0.005 ↓ 2.0 2 1

Sort (cost=1.02..1.02 rows=1 width=12) (actual time=0.005..0.005 rows=2 loops=1)

  • Sort Key: m9_.id
  • Sort Method: quicksort Memory: 25kB
43. 0.003 0.003 ↓ 3.0 3 1

Seq Scan on ma_blood_pressure_measurement m9_ (cost=0.00..1.01 rows=1 width=12) (actual time=0.003..0.003 rows=3 loops=1)

44. 0.003 0.006 ↓ 2.0 2 1

Sort (cost=1.02..1.02 rows=1 width=547) (actual time=0.005..0.006 rows=2 loops=1)

  • Sort Key: m10_.id
  • Sort Method: quicksort Memory: 25kB
45. 0.003 0.003 ↓ 2.0 2 1

Seq Scan on ma_first_interview m10_ (cost=0.00..1.01 rows=1 width=547) (actual time=0.003..0.003 rows=2 loops=1)

46. 0.001 0.004 ↑ 1.0 1 1

Sort (cost=1.02..1.02 rows=1 width=20) (actual time=0.004..0.004 rows=1 loops=1)

  • Sort Key: m11_.id
  • Sort Method: quicksort Memory: 25kB
47. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on ma_scale_glasgow_check m11_ (cost=0.00..1.01 rows=1 width=20) (actual time=0.003..0.003 rows=1 loops=1)

48. 0.003 0.006 ↓ 1.2 6 1

Sort (cost=1.11..1.12 rows=5 width=5) (actual time=0.005..0.006 rows=6 loops=1)

  • Sort Key: m13_.id
  • Sort Method: quicksort Memory: 25kB
49. 0.003 0.003 ↓ 1.2 6 1

Seq Scan on ma_inspection_of_bedsores m13_ (cost=0.00..1.05 rows=5 width=5) (actual time=0.003..0.003 rows=6 loops=1)

50. 0.002 0.007 ↑ 1.0 4 1

Sort (cost=1.08..1.09 rows=4 width=5) (actual time=0.007..0.007 rows=4 loops=1)

  • Sort Key: m14_.id
  • Sort Method: quicksort Memory: 25kB
51. 0.005 0.005 ↑ 1.0 4 1

Seq Scan on ma_inspection_of_wounds m14_ (cost=0.00..1.04 rows=4 width=5) (actual time=0.005..0.005 rows=4 loops=1)

52. 0.001 0.001 ↓ 0.0 0 1

Index Scan using ma_scale_geriatric_depression_check_pkey on ma_scale_geriatric_depression_check m12_ (cost=0.15..56.90 rows=850 width=68) (actual time=0.001..0.001 rows=0 loops=1)

53. 0.007 0.007 ↑ 1,940.0 1 1

Index Scan using ma_blood_sugar_measurement_pkey on ma_blood_sugar_measurement m8_ (cost=0.15..77.25 rows=1,940 width=14) (actual time=0.007..0.007 rows=1 loops=1)

54. 0.003 0.003 ↑ 1.0 1 1

Index Scan using ma_laboratory_diagnostic_pkey on ma_laboratory_diagnostic m15_ (cost=0.12..8.14 rows=1 width=552) (actual time=0.002..0.003 rows=1 loops=1)

55. 0.002 0.002 ↑ 1.0 1 1

Index Scan using ma_nurse_observation_pkey on ma_nurse_observation m17_ (cost=0.12..8.14 rows=1 width=45) (actual time=0.002..0.002 rows=1 loops=1)

56. 0.003 0.003 ↓ 3.0 3 1

Index Scan using ma_pulse_measurement_pkey on ma_pulse_measurement m18_ (cost=0.12..8.14 rows=1 width=8) (actual time=0.002..0.003 rows=3 loops=1)

57. 0.002 0.002 ↓ 2.0 2 1

Index Scan using ma_saturation_measurement_pkey on ma_saturation_measurement m19_ (cost=0.12..8.14 rows=1 width=8) (actual time=0.002..0.002 rows=2 loops=1)

58. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=24.50..24.50 rows=1,450 width=28) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 16kB
59. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on ma_scale_norton_check m20_ (cost=0.00..24.50 rows=1,450 width=28) (actual time=0.002..0.002 rows=0 loops=1)

60. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=28.10..28.10 rows=1,810 width=17) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 16kB
61. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on ma_nutritional_risk_score m21_ (cost=0.00..28.10 rows=1,810 width=17) (actual time=0.002..0.002 rows=0 loops=1)

62. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=30.40..30.40 rows=2,040 width=12) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 16kB
63. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on ma_liquid_measurement m16_ (cost=0.00..30.40 rows=2,040 width=12) (actual time=0.001..0.001 rows=0 loops=1)

64. 0.002 0.013 ↓ 8.5 17 1

Hash (cost=1.02..1.02 rows=2 width=16) (actual time=0.013..0.013 rows=17 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
65. 0.011 0.011 ↓ 8.5 17 1

Seq Scan on ma_temperature_measurement m22_ (cost=0.00..1.02 rows=2 width=16) (actual time=0.009..0.011 rows=17 loops=1)

66. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=10.10..10.10 rows=10 width=5,172) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
67. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on ma_subjective_global_assessment m24_ (cost=0.00..10.10 rows=10 width=5,172) (actual time=0.002..0.002 rows=0 loops=1)

68. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=17.20..17.20 rows=720 width=84) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
69. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on ma_scale_tinetti_check m23_ (cost=0.00..17.20 rows=720 width=84) (actual time=0.001..0.001 rows=0 loops=1)

70. 0.001 0.002 ↓ 0.0 0 1

Hash (cost=22.00..22.00 rows=1,200 width=40) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 16kB
71. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on ma_performed_procedure m25_ (cost=0.00..22.00 rows=1,200 width=40) (actual time=0.001..0.001 rows=0 loops=1)

72. 0.001 0.002 ↓ 0.0 0 1

Hash (cost=30.40..30.40 rows=2,040 width=12) (actual time=0.001..0.002 rows=0 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 16kB
73. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on ma_scale_modified_rankin_check m26_ (cost=0.00..30.40 rows=2,040 width=12) (actual time=0.001..0.001 rows=0 loops=1)

74. 0.000 0.003 ↓ 0.0 0 1

Hash (cost=32.60..32.60 rows=2,260 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 32kB
75. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on ma_scale_visual_analogue_check m27_ (cost=0.00..32.60 rows=2,260 width=8) (actual time=0.003..0.003 rows=0 loops=1)

Planning time : 16.689 ms
Execution time : 2,995.951 ms