explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IjNu

Settings
# exclusive inclusive rows x rows loops node
1. 23.908 6,441.118 ↑ 14.5 23 1

Hash Join (cost=9,469.79..38,867.31 rows=333 width=560) (actual time=310.070..6,441.118 rows=23 loops=1)

  • Hash Cond: ((mp.uuid)::text = (fb.step_id)::text)
2. 14.996 6,417.191 ↓ 2.8 186,426 1

Append (cost=9,466.48..38,000.85 rows=66,695 width=1,442) (actual time=302.232..6,417.191 rows=186,426 loops=1)

3. 51.994 488.748 ↓ 3.8 120,863 1

Hash Join (cost=9,466.48..11,261.42 rows=31,440 width=432) (actual time=302.231..488.748 rows=120,863 loops=1)

  • Hash Cond: (mp.application_id = ap.application_id)
4. 55.424 434.072 ↓ 3.8 120,863 1

Hash Join (cost=9,163.11..10,875.46 rows=31,440 width=401) (actual time=299.528..434.072 rows=120,863 loops=1)

  • Hash Cond: (ps.message_panel_id = mp.message_panel_id)
5. 74.497 373.884 ↓ 3.8 120,863 1

Hash Right Join (cost=8,638.03..10,267.82 rows=31,440 width=358) (actual time=294.732..373.884 rows=120,863 loops=1)

  • Hash Cond: (plp.property_id = p.property_id)
6. 4.736 4.736 ↑ 1.0 58,412 1

Seq Scan on property_list_possible plp (cost=0.00..1,150.06 rows=60,606 width=26) (actual time=0.014..4.736 rows=58,412 loops=1)

7. 47.506 294.651 ↓ 2.5 77,621 1

Hash (cost=8,245.03..8,245.03 rows=31,440 width=332) (actual time=294.651..294.651 rows=77,621 loops=1)

  • Buckets: 131,072 (originally 32768) Batches: 1 (originally 1) Memory Usage: 21,665kB
8. 50.572 247.145 ↓ 2.5 77,621 1

Hash Right Join (cost=7,285.11..8,245.03 rows=31,440 width=332) (actual time=194.008..247.145 rows=77,621 loops=1)

  • Hash Cond: (hpv.property_id = p.property_id)
9. 2.639 2.639 ↑ 1.0 34,546 1

Seq Scan on hierarchy_possible_values hpv (cost=0.00..686.46 rows=34,546 width=47) (actual time=0.022..2.639 rows=34,546 loops=1)

10. 39.907 193.934 ↓ 2.0 63,556 1

Hash (cost=6,892.11..6,892.11 rows=31,440 width=285) (actual time=193.934..193.934 rows=63,556 loops=1)

  • Buckets: 65,536 (originally 32768) Batches: 1 (originally 1) Memory Usage: 17,195kB
11. 39.040 154.027 ↓ 2.0 63,556 1

Hash Join (cost=4,142.77..6,892.11 rows=31,440 width=285) (actual time=66.893..154.027 rows=63,556 loops=1)

  • Hash Cond: (psi.property_id = p.property_id)
12. 38.933 60.261 ↓ 2.0 63,556 1

Hash Join (cost=1,071.60..3,738.41 rows=31,440 width=126) (actual time=11.980..60.261 rows=63,556 loops=1)

  • Hash Cond: (psi.panel_section_id = ps.section_id)
13. 9.381 9.381 ↑ 1.0 92,735 1

Seq Scan on panel_section_item psi (cost=0.00..2,423.35 rows=92,735 width=76) (actual time=0.005..9.381 rows=92,735 loops=1)

14. 3.720 11.947 ↑ 1.0 11,378 1

Hash (cost=928.90..928.90 rows=11,416 width=93) (actual time=11.947..11.947 rows=11,378 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 1,509kB
15. 8.227 8.227 ↑ 1.0 11,378 1

Seq Scan on panel_section ps (cost=0.00..928.90 rows=11,416 width=93) (actual time=0.005..8.227 rows=11,378 loops=1)

  • Filter: (type = '1'::numeric)
  • Rows Removed by Filter: 22,219
16. 30.528 54.726 ↓ 1.0 75,867 1

Hash (cost=2,127.74..2,127.74 rows=75,474 width=165) (actual time=54.726..54.726 rows=75,867 loops=1)

  • Buckets: 131,072 Batches: 1 Memory Usage: 11,662kB
17. 24.198 24.198 ↓ 1.0 75,867 1

Seq Scan on property p (cost=0.00..2,127.74 rows=75,474 width=165) (actual time=0.009..24.198 rows=75,867 loops=1)

18. 1.851 4.764 ↓ 1.0 10,178 1

Hash (cost=398.37..398.37 rows=10,137 width=50) (actual time=4.764..4.764 rows=10,178 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 953kB
19. 2.913 2.913 ↓ 1.0 10,178 1

Seq Scan on message_panel mp (cost=0.00..398.37 rows=10,137 width=50) (actual time=0.007..2.913 rows=10,178 loops=1)

20. 1.037 2.682 ↓ 1.0 5,884 1

Hash (cost=229.83..229.83 rows=5,883 width=30) (actual time=2.682..2.682 rows=5,884 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 427kB
21. 1.645 1.645 ↓ 1.0 5,884 1

Seq Scan on application ap (cost=0.00..229.83 rows=5,883 width=30) (actual time=0.007..1.645 rows=5,884 loops=1)

22. 0.002 0.138 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=2.40..724.71 rows=194 width=490) (actual time=0.138..0.138 rows=0 loops=1)

23. 0.001 0.136 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.40..722.29 rows=194 width=466) (actual time=0.136..0.136 rows=0 loops=1)

24. 0.000 0.135 ↓ 0.0 0 1

Nested Loop (cost=2.10..130.84 rows=194 width=374) (actual time=0.135..0.135 rows=0 loops=1)

25. 0.001 0.135 ↓ 0.0 0 1

Nested Loop (cost=1.97..128.51 rows=15 width=390) (actual time=0.135..0.135 rows=0 loops=1)

26. 0.000 0.134 ↓ 0.0 0 1

Nested Loop (cost=1.69..123.54 rows=15 width=372) (actual time=0.134..0.134 rows=0 loops=1)

27. 0.001 0.134 ↓ 0.0 0 1

Nested Loop (cost=1.40..118.28 rows=15 width=329) (actual time=0.134..0.134 rows=0 loops=1)

28. 0.001 0.133 ↓ 0.0 0 1

Nested Loop (cost=0.99..51.78 rows=43 width=290) (actual time=0.133..0.133 rows=0 loops=1)

29. 0.006 0.123 ↓ 1.1 9 1

Nested Loop Left Join (cost=0.83..32.96 rows=8 width=250) (actual time=0.076..0.123 rows=9 loops=1)

30. 0.013 0.069 ↑ 1.0 8 1

Nested Loop (cost=0.42..28.58 rows=8 width=224) (actual time=0.043..0.069 rows=8 loops=1)

31. 0.016 0.016 ↑ 1.0 8 1

Seq Scan on external_property_set_item epsi (cost=0.00..1.08 rows=8 width=67) (actual time=0.015..0.016 rows=8 loops=1)

32. 0.040 0.040 ↑ 1.0 1 8

Index Scan using property_pk on property p_1 (cost=0.42..3.44 rows=1 width=165) (actual time=0.005..0.005 rows=1 loops=8)

  • Index Cond: (property_id = (epsi.external_property_id)::numeric)
33. 0.048 0.048 ↓ 0.0 0 8

Index Scan using idx_prop_list_pv_unq1 on property_list_possible plp_1 (cost=0.41..0.51 rows=4 width=26) (actual time=0.005..0.006 rows=0 loops=8)

  • Index Cond: (p_1.property_id = property_id)
34. 0.009 0.009 ↓ 0.0 0 9

Index Scan using idx_external_property_set_epsi on panel_section_external_property_set_item psepsi (cost=0.15..2.30 rows=5 width=40) (actual time=0.001..0.001 rows=0 loops=9)

  • Index Cond: (external_property_set_id = epsi.external_property_set_id)
35. 0.000 0.000 ↓ 0.0 0

Index Scan using panel_section_pk on panel_section ps_1 (cost=0.41..1.55 rows=1 width=93) (never executed)

  • Index Cond: (section_id = psepsi.panel_section_id)
  • Filter: (type = '1'::numeric)
36. 0.000 0.000 ↓ 0.0 0

Index Scan using message_panel_pk on message_panel mp_1 (cost=0.29..0.35 rows=1 width=50) (never executed)

  • Index Cond: (message_panel_id = ps_1.message_panel_id)
37. 0.000 0.000 ↓ 0.0 0

Index Scan using application_pk on application ap_1 (cost=0.28..0.33 rows=1 width=30) (never executed)

  • Index Cond: (application_id = mp_1.application_id)
38. 0.000 0.000 ↓ 0.0 0

Index Only Scan using external_property_set_pk on external_property_set eps (cost=0.14..0.16 rows=1 width=8) (never executed)

  • Index Cond: (external_property_set_id = psepsi.external_property_set_id)
  • Heap Fetches: 0
39. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_prop_id on hierarchy_possible_values hpv_1 (cost=0.29..2.05 rows=100 width=47) (never executed)

  • Index Cond: (property_id = p_1.property_id)
40. 0.481 15.526 ↓ 9.1 1,085 1

Subquery Scan on *SELECT* 3 (cost=37.98..1,031.40 rows=119 width=1,266) (actual time=0.486..15.526 rows=1,085 loops=1)

41. 3.137 15.045 ↓ 9.1 1,085 1

Nested Loop (cost=37.98..1,029.32 rows=119 width=1,182) (actual time=0.473..15.045 rows=1,085 loops=1)

42. 0.522 9.738 ↓ 9.1 1,085 1

Nested Loop (cost=37.70..988.43 rows=119 width=122) (actual time=0.441..9.738 rows=1,085 loops=1)

43. 2.166 3.791 ↑ 1.0 1,085 1

Hash Join (cost=37.41..484.65 rows=1,085 width=79) (actual time=0.420..3.791 rows=1,085 loops=1)

  • Hash Cond: (mp_2.message_panel_id = mpcs.message_panel_id)
44. 1.244 1.244 ↓ 1.0 10,178 1

Seq Scan on message_panel mp_2 (cost=0.00..398.37 rows=10,137 width=50) (actual time=0.021..1.244 rows=10,178 loops=1)

45. 0.202 0.381 ↑ 1.0 1,085 1

Hash (cost=23.85..23.85 rows=1,085 width=29) (actual time=0.381..0.381 rows=1,085 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 82kB
46. 0.179 0.179 ↑ 1.0 1,085 1

Seq Scan on message_panel_conf_setting mpcs (cost=0.00..23.85 rows=1,085 width=29) (actual time=0.011..0.179 rows=1,085 loops=1)

47. 5.425 5.425 ↑ 1.0 1 1,085

Index Scan using uc_panel_section_order on panel_section ps_2 (cost=0.29..0.45 rows=1 width=57) (actual time=0.004..0.005 rows=1 loops=1,085)

  • Index Cond: (message_panel_id = mp_2.message_panel_id)
  • Filter: (type = '5'::numeric)
  • Rows Removed by Filter: 4
48. 2.170 2.170 ↑ 1.0 1 1,085

Index Scan using application_pk on application ap_2 (cost=0.28..0.33 rows=1 width=30) (actual time=0.002..0.002 rows=1 loops=1,085)

  • Index Cond: (application_id = mp_2.application_id)
49. 20.533 5,601.301 ↓ 3.3 52,174 1

Subquery Scan on *SELECT* 4 (cost=8,378.83..10,526.42 rows=16,037 width=633) (actual time=146.374..5,601.301 rows=52,174 loops=1)

50. 5,427.793 5,580.768 ↓ 3.3 52,174 1

Hash Right Join (cost=8,378.83..10,366.05 rows=16,037 width=633) (actual time=146.371..5,580.768 rows=52,174 loops=1)

  • Hash Cond: (plp_2.property_id = p_2.property_id)
51. 6.918 6.918 ↑ 1.0 58,412 1

Seq Scan on property_list_possible plp_2 (cost=0.00..1,150.06 rows=60,606 width=26) (actual time=0.012..6.918 rows=58,412 loops=1)

52. 17.896 146.057 ↓ 1.8 29,179 1

Hash (cost=8,178.37..8,178.37 rows=16,037 width=291) (actual time=146.057..146.057 rows=29,179 loops=1)

  • Buckets: 32,768 (originally 16384) Batches: 1 (originally 1) Memory Usage: 8,367kB
53. 21.170 128.161 ↓ 1.8 29,179 1

Hash Join (cost=5,204.79..8,178.37 rows=16,037 width=291) (actual time=71.145..128.161 rows=29,179 loops=1)

  • Hash Cond: (psi_1.property_id = p_2.property_id)
54. 27.547 61.291 ↓ 1.8 29,179 1

Hash Join (cost=2,133.63..5,065.10 rows=16,037 width=145) (actual time=25.235..61.291 rows=29,179 loops=1)

  • Hash Cond: (psi_1.panel_section_id = ps_3.section_id)
55. 8.547 8.547 ↑ 1.0 92,735 1

Seq Scan on panel_section_item psi_1 (cost=0.00..2,423.35 rows=92,735 width=39) (actual time=0.009..8.547 rows=92,735 loops=1)

56. 1.827 25.197 ↓ 1.0 5,832 1

Hash (cost=2,060.84..2,060.84 rows=5,823 width=149) (actual time=25.197..25.197 rows=5,832 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 1,124kB
57. 2.699 23.370 ↓ 1.0 5,832 1

Hash Join (cost=1,830.14..2,060.84 rows=5,823 width=149) (actual time=15.224..23.370 rows=5,832 loops=1)

  • Hash Cond: (mp_3.application_id = ap_3.application_id)
58. 2.690 18.207 ↓ 1.0 5,832 1

Hash Join (cost=1,526.77..1,742.18 rows=5,823 width=131) (actual time=12.741..18.207 rows=5,832 loops=1)

  • Hash Cond: (ps_3.message_panel_id = mp_3.message_panel_id)
59. 2.503 11.003 ↓ 1.0 5,832 1

Hash Right Join (cost=1,001.69..1,201.80 rows=5,823 width=88) (actual time=8.196..11.003 rows=5,832 loops=1)

  • Hash Cond: ((ho.message_panel_id)::numeric = ps_3.message_panel_id)
60. 0.340 0.340 ↓ 1.0 3,085 1

Seq Scan on message_panel_handling_option ho (cost=0.00..59.71 rows=3,071 width=17) (actual time=0.010..0.340 rows=3,085 loops=1)

61. 1.450 8.160 ↓ 1.0 5,832 1

Hash (cost=928.90..928.90 rows=5,823 width=79) (actual time=8.160..8.160 rows=5,832 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 705kB
62. 6.710 6.710 ↓ 1.0 5,832 1

Seq Scan on panel_section ps_3 (cost=0.00..928.90 rows=5,823 width=79) (actual time=0.011..6.710 rows=5,832 loops=1)

  • Filter: (type = '4'::numeric)
  • Rows Removed by Filter: 27,765
63. 1.813 4.514 ↓ 1.0 10,178 1

Hash (cost=398.37..398.37 rows=10,137 width=50) (actual time=4.514..4.514 rows=10,178 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 953kB
64. 2.701 2.701 ↓ 1.0 10,178 1

Seq Scan on message_panel mp_3 (cost=0.00..398.37 rows=10,137 width=50) (actual time=0.009..2.701 rows=10,178 loops=1)

65. 1.023 2.464 ↓ 1.0 5,884 1

Hash (cost=229.83..229.83 rows=5,883 width=30) (actual time=2.464..2.464 rows=5,884 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 427kB
66. 1.441 1.441 ↓ 1.0 5,884 1

Seq Scan on application ap_3 (cost=0.00..229.83 rows=5,883 width=30) (actual time=0.006..1.441 rows=5,884 loops=1)

67. 24.481 45.700 ↓ 1.0 75,867 1

Hash (cost=2,127.74..2,127.74 rows=75,474 width=152) (actual time=45.700..45.700 rows=75,867 loops=1)

  • Buckets: 131,072 Batches: 1 Memory Usage: 10,825kB
68. 21.219 21.219 ↓ 1.0 75,867 1

Seq Scan on property p_2 (cost=0.00..2,127.74 rows=75,474 width=152) (actual time=0.010..21.219 rows=75,867 loops=1)

69. 1.051 97.769 ↑ 4.1 2,142 1

Subquery Scan on *SELECT* 5 (cost=3,235.35..4,692.44 rows=8,699 width=1,276) (actual time=55.358..97.769 rows=2,142 loops=1)

70. 40.414 96.718 ↑ 4.1 2,142 1

GroupAggregate (cost=3,235.35..4,540.20 rows=8,699 width=1,192) (actual time=55.353..96.718 rows=2,142 loops=1)

  • Group Key: ap_4.org_id, ap_4.uuid, mp_4.message_panel_id, ps_4.uuid, 'Device'::text, ps_4.order_num, ps_4.type, ps_4.is_visible, ps_4.is_collapsed, 20, 'deviceOverride'::text, NULL::text, NULL::text, 3, 'N'::text, NULL::numeric, NULL::numeric, NULL::text, NULL::numeric, NULL::numeric, NULL::text, NULL::numeric, NULL::text, ((uuid_generate_v5((mp_4.uuid)::uuid, 'deviceOverride_property'::text))::text), NULL::text, NULL::text, NULL::numeric, NULL::numeric, NULL::text, NULL::text, NULL::text, NULL::numeric, NULL::numeric, NULL::text, NULL::numeric, NULL::text, NULL::text, 'targetDeviceNames'::text, 0, 'N'::text, 'N'::text, 'N'::text, 'N'::text
71. 12.673 56.304 ↑ 1.2 7,172 1

Sort (cost=3,235.35..3,257.10 rows=8,699 width=1,199) (actual time=55.304..56.304 rows=7,172 loops=1)

  • Sort Key: ap_4.org_id, ap_4.uuid, mp_4.message_panel_id, ps_4.uuid, ps_4.order_num, ps_4.is_visible, ps_4.is_collapsed, ((uuid_generate_v5((mp_4.uuid)::uuid, 'deviceOverride_property'::text))::text)
  • Sort Method: quicksort Memory: 3,761kB
72. 18.101 43.631 ↑ 1.2 7,172 1

Hash Right Join (cost=2,241.47..2,666.15 rows=8,699 width=1,199) (actual time=22.208..43.631 rows=7,172 loops=1)

  • Hash Cond: (mpd.message_panel_device_filter_id = mpdf.message_panel_device_filter_id)
73. 2.570 6.107 ↑ 1.0 6,653 1

Hash Left Join (cost=316.82..520.82 rows=6,653 width=60) (actual time=2.755..6.107 rows=6,653 loops=1)

  • Hash Cond: (mpd.device_id = odn.org_dvc_name_id)
74. 0.816 0.816 ↑ 1.0 6,653 1

Seq Scan on message_panel_device mpd (cost=0.00..186.53 rows=6,653 width=33) (actual time=0.010..0.816 rows=6,653 loops=1)

75. 1.105 2.721 ↓ 1.0 6,723 1

Hash (cost=233.03..233.03 rows=6,703 width=43) (actual time=2.721..2.721 rows=6,723 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 551kB
76. 1.616 1.616 ↓ 1.0 6,723 1

Seq Scan on org_dvc_names odn (cost=0.00..233.03 rows=6,703 width=43) (actual time=0.005..1.616 rows=6,723 loops=1)

77. 0.690 19.423 ↓ 1.0 2,142 1

Hash (cost=1,898.13..1,898.13 rows=2,122 width=145) (actual time=19.423..19.423 rows=2,142 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 411kB
78. 1.200 18.733 ↓ 1.0 2,142 1

Hash Join (cost=1,783.88..1,898.13 rows=2,122 width=145) (actual time=15.109..18.733 rows=2,142 loops=1)

  • Hash Cond: (mp_4.application_id = ap_4.application_id)
79. 1.187 14.834 ↓ 1.0 2,142 1

Hash Join (cost=1,480.51..1,589.19 rows=2,122 width=121) (actual time=12.391..14.834 rows=2,142 loops=1)

  • Hash Cond: (ps_4.message_panel_id = mp_4.message_panel_id)
80. 1.140 8.657 ↓ 1.0 2,142 1

Hash Right Join (cost=955.43..1,058.54 rows=2,122 width=78) (actual time=7.364..8.657 rows=2,142 loops=1)

  • Hash Cond: ((mpdf.message_panel_id)::numeric = ps_4.message_panel_id)
81. 0.181 0.181 ↓ 1.0 1,623 1

Seq Scan on message_panel_device_filter mpdf (cost=0.00..35.15 rows=1,615 width=29) (actual time=0.009..0.181 rows=1,623 loops=1)

82. 0.559 7.336 ↓ 1.0 2,142 1

Hash (cost=928.90..928.90 rows=2,122 width=57) (actual time=7.336..7.336 rows=2,142 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 221kB
83. 6.777 6.777 ↓ 1.0 2,142 1

Seq Scan on panel_section ps_4 (cost=0.00..928.90 rows=2,122 width=57) (actual time=0.011..6.777 rows=2,142 loops=1)

  • Filter: (type = '3'::numeric)
  • Rows Removed by Filter: 31,455
84. 2.047 4.990 ↓ 1.0 10,178 1

Hash (cost=398.37..398.37 rows=10,137 width=50) (actual time=4.990..4.990 rows=10,178 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 953kB
85. 2.943 2.943 ↓ 1.0 10,178 1

Seq Scan on message_panel mp_4 (cost=0.00..398.37 rows=10,137 width=50) (actual time=0.012..2.943 rows=10,178 loops=1)

86. 1.077 2.699 ↓ 1.0 5,884 1

Hash (cost=229.83..229.83 rows=5,883 width=30) (actual time=2.699..2.699 rows=5,884 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 427kB
87. 1.622 1.622 ↓ 1.0 5,884 1

Seq Scan on application ap_4 (cost=0.00..229.83 rows=5,883 width=30) (actual time=0.013..1.622 rows=5,884 loops=1)

88. 4.633 198.713 ↑ 1.0 10,162 1

Subquery Scan on *SELECT* 6 (cost=7,689.52..9,450.06 rows=10,206 width=1,276) (actual time=144.613..198.713 rows=10,162 loops=1)

89. 48.059 194.080 ↑ 1.0 10,162 1

GroupAggregate (cost=7,689.52..9,271.45 rows=10,206 width=1,192) (actual time=144.607..194.080 rows=10,162 loops=1)

  • Group Key: ap_5.org_id, ap_5.uuid, mp_5.message_panel_id, ps_5.uuid, 'Recipients'::text, ps_5.order_num, ps_5.type, ps_5.is_visible, ps_5.is_collapsed, 30, 'recipients'::text, NULL::text, NULL::text, 3, 'N'::text, NULL::numeric, NULL::numeric, NULL::text, NULL::numeric, NULL::numeric, NULL::text, NULL::numeric, NULL::text, ((uuid_generate_v5((mp_5.uuid)::uuid, 'recipients_property'::text))::text), NULL::text, NULL::text, NULL::numeric, NULL::numeric, NULL::text, NULL::text, NULL::text, NULL::numeric, NULL::numeric, NULL::text, NULL::numeric, NULL::text, NULL::text, 'recipients'::text, 0, 'N'::text, 'N'::text, 'N'::text, 'N'::text
90. 19.901 146.021 ↓ 1.3 13,071 1

Sort (cost=7,689.52..7,715.04 rows=10,206 width=1,225) (actual time=144.574..146.021 rows=13,071 loops=1)

  • Sort Key: ap_5.org_id, ap_5.uuid, mp_5.message_panel_id, ps_5.uuid, ps_5.order_num, ps_5.is_visible, ps_5.is_collapsed, ((uuid_generate_v5((mp_5.uuid)::uuid, 'recipients_property'::text))::text)
  • Sort Method: quicksort Memory: 5,734kB
91. 40.981 126.120 ↓ 1.3 13,071 1

Hash Join (cost=5,813.62..7,009.95 rows=10,206 width=1,225) (actual time=76.898..126.120 rows=13,071 loops=1)

  • Hash Cond: (ps_5.message_panel_id = mp_5.message_panel_id)
92. 8.312 8.312 ↑ 1.0 10,162 1

Seq Scan on panel_section ps_5 (cost=0.00..928.90 rows=10,206 width=57) (actual time=0.018..8.312 rows=10,162 loops=1)

  • Filter: (type = '2'::numeric)
  • Rows Removed by Filter: 23,435
93. 4.987 76.827 ↓ 1.3 13,087 1

Hash (cost=5,686.91..5,686.91 rows=10,137 width=139) (actual time=76.827..76.827 rows=13,087 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 2,066kB
94. 5.328 71.840 ↓ 1.3 13,087 1

Hash Join (cost=5,396.44..5,686.91 rows=10,137 width=139) (actual time=55.873..71.840 rows=13,087 loops=1)

  • Hash Cond: (mp_5.application_id = ap_5.application_id)
95. 4.847 63.729 ↓ 1.3 13,087 1

Hash Right Join (cost=5,093.07..5,356.91 rows=10,137 width=115) (actual time=53.071..63.729 rows=13,087 loops=1)

  • Hash Cond: (mpr.message_panel_id = mp_5.message_panel_id)
96. 1.351 53.793 ↓ 1.0 7,512 1

Hash Left Join (cost=4,567.99..4,812.17 rows=7,486 width=72) (actual time=47.944..53.793 rows=7,512 loops=1)

  • Hash Cond: (r.org_dvc_name_id = odn_1.org_dvc_name_id)
97. 3.630 49.942 ↓ 1.0 7,512 1

Hash Left Join (cost=4,251.18..4,475.69 rows=7,486 width=70) (actual time=45.416..49.942 rows=7,512 loops=1)

  • Hash Cond: (mpr.recipient_id = r.recipient_id)
98. 1.009 1.009 ↓ 1.0 7,512 1

Seq Scan on message_panel_recipient mpr (cost=0.00..204.86 rows=7,486 width=15) (actual time=0.011..1.009 rows=7,512 loops=1)

99. 15.406 45.303 ↓ 1.0 62,428 1

Hash (cost=3,471.31..3,471.31 rows=62,389 width=71) (actual time=45.303..45.303 rows=62,428 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 6,816kB
100. 29.897 29.897 ↓ 1.0 62,428 1

Seq Scan on recipients r (cost=0.00..3,471.31 rows=62,389 width=71) (actual time=0.008..29.897 rows=62,428 loops=1)

  • Filter: (deleted_id = '-1'::integer)
  • Rows Removed by Filter: 18,898
101. 0.996 2.500 ↓ 1.0 6,723 1

Hash (cost=233.03..233.03 rows=6,703 width=18) (actual time=2.500..2.500 rows=6,723 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 425kB
102. 1.504 1.504 ↓ 1.0 6,723 1

Seq Scan on org_dvc_names odn_1 (cost=0.00..233.03 rows=6,703 width=18) (actual time=0.011..1.504 rows=6,723 loops=1)

103. 2.041 5.089 ↓ 1.0 10,178 1

Hash (cost=398.37..398.37 rows=10,137 width=50) (actual time=5.089..5.089 rows=10,178 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 953kB
104. 3.048 3.048 ↓ 1.0 10,178 1

Seq Scan on message_panel mp_5 (cost=0.00..398.37 rows=10,137 width=50) (actual time=0.011..3.048 rows=10,178 loops=1)

105. 1.076 2.783 ↓ 1.0 5,884 1

Hash (cost=229.83..229.83 rows=5,883 width=30) (actual time=2.783..2.783 rows=5,884 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 427kB
106. 1.707 1.707 ↓ 1.0 5,884 1

Seq Scan on application ap_5 (cost=0.00..229.83 rows=5,883 width=30) (actual time=0.006..1.707 rows=5,884 loops=1)

107. 0.003 0.019 ↑ 1.0 1 1

Hash (cost=3.30..3.30 rows=1 width=32) (actual time=0.019..0.019 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
108. 0.016 0.016 ↑ 1.0 1 1

Index Scan using flow_blocks_pkey on flow_blocks fb (cost=0.28..3.30 rows=1 width=32) (actual time=0.015..0.016 rows=1 loops=1)

  • Index Cond: (flow_block_id = '5aa6aa2f-b9b6-4451-9edb-466dfdfa1b93'::uuid)
  • Filter: (step_type = 'CREATE_EVENT'::text)
Planning time : 8.594 ms
Execution time : 6,442.891 ms