explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l3vB

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 0.168 ↑ 1.0 1 1

Limit (cost=0.97..1.83 rows=1 width=1,442) (actual time=0.156..0.168 rows=1 loops=1)

2. 0.001 0.155 ↑ 7,168.0 1 1

Append (cost=0.97..6,082.57 rows=7,168 width=1,442) (actual time=0.155..0.155 rows=1 loops=1)

3. 0.006 0.154 ↑ 479.0 1 1

Nested Loop Left Join (cost=0.97..648.40 rows=479 width=420) (actual time=0.154..0.154 rows=1 loops=1)

  • Join Filter: (hpv.property_id = p.property_id)
  • Rows Removed by Join Filter: 12
4. 0.002 0.136 ↑ 479.0 1 1

Nested Loop Left Join (cost=0.97..561.03 rows=479 width=362) (actual time=0.136..0.136 rows=1 loops=1)

5. 0.003 0.128 ↑ 479.0 1 1

Nested Loop (cost=0.70..372.13 rows=479 width=337) (actual time=0.128..0.128 rows=1 loops=1)

6. 0.002 0.096 ↑ 479.0 1 1

Nested Loop (cost=0.42..219.12 rows=479 width=186) (actual time=0.096..0.096 rows=1 loops=1)

7. 0.009 0.081 ↑ 113.0 1 1

Nested Loop (cost=0.14..123.90 rows=113 width=148) (actual time=0.080..0.081 rows=1 loops=1)

  • Join Filter: (mp.application_id = ap.application_id)
  • Rows Removed by Join Filter: 42
8. 0.005 0.039 ↑ 113.0 1 1

Nested Loop (cost=0.14..32.94 rows=113 width=130) (actual time=0.039..0.039 rows=1 loops=1)

9. 0.024 0.024 ↑ 113.0 1 1

Seq Scan on panel_section ps (cost=0.00..7.44 rows=113 width=87) (actual time=0.024..0.024 rows=1 loops=1)

  • Filter: (type = '1'::numeric)
  • Rows Removed by Filter: 6
10. 0.010 0.010 ↑ 1.0 1 1

Index Scan using message_panel_pk on message_panel mp (cost=0.14..0.23 rows=1 width=49) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (message_panel_id = ps.message_panel_id)
11. 0.014 0.033 ↑ 1.2 43 1

Materialize (cost=0.00..2.80 rows=53 width=30) (actual time=0.013..0.033 rows=43 loops=1)

12. 0.019 0.019 ↑ 1.2 43 1

Seq Scan on application ap (cost=0.00..2.53 rows=53 width=30) (actual time=0.010..0.019 rows=43 loops=1)

13. 0.013 0.013 ↑ 8.0 1 1

Index Scan using uc_ps_item_order on panel_section_item psi (cost=0.28..0.76 rows=8 width=71) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (panel_section_id = ps.section_id)
14. 0.029 0.029 ↑ 1.0 1 1

Index Scan using property_pk on property p (cost=0.28..0.32 rows=1 width=157) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: (property_id = psi.property_id)
15. 0.006 0.006 ↓ 0.0 0 1

Index Scan using idx_prop_list_pv_unq1 on property_list_possible plp (cost=0.27..0.35 rows=4 width=25) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (p.property_id = property_id)
16. 0.003 0.012 ↑ 1.0 12 1

Materialize (cost=0.00..1.18 rows=12 width=45) (actual time=0.009..0.012 rows=12 loops=1)

17. 0.009 0.009 ↑ 1.0 12 1

Seq Scan on hierarchy_possible_values hpv (cost=0.00..1.12 rows=12 width=45) (actual time=0.008..0.009 rows=12 loops=1)

18. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2 (cost=0.84..5,046.06 rows=6,160 width=491) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.84..4,969.06 rows=6,160 width=467) (never executed)

  • Join Filter: (hpv_1.property_id = p_1.property_id)
20. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=0.84..3,859.11 rows=6,160 width=377) (never executed)

  • Merge Cond: (eps.external_property_set_id = psepsi.external_property_set_id)
21. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.69..1,075.13 rows=700 width=262) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..799.08 rows=700 width=237) (never executed)

23. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.14..561.14 rows=700 width=88) (never executed)

  • Join Filter: (eps.external_property_set_id = epsi.external_property_set_id)
24. 0.000 0.000 ↓ 0.0 0

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

  • Heap Fetches: 0
25. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..20.50 rows=700 width=80) (never executed)

26. 0.000 0.000 ↓ 0.0 0

Seq Scan on external_property_set_item epsi (cost=0.00..17.00 rows=700 width=80) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Index Scan using property_pk on property p_1 (cost=0.28..0.34 rows=1 width=157) (never executed)

  • Index Cond: (property_id = (epsi.external_property_id)::numeric)
28. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_prop_list_pv_unq1 on property_list_possible plp_1 (cost=0.27..0.35 rows=4 width=25) (never executed)

  • Index Cond: (p_1.property_id = property_id)
29. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.15..2,760.22 rows=440 width=139) (never executed)

30. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.15..2,759.12 rows=440 width=139) (never executed)

  • Join Filter: (mp_1.application_id = ap_1.application_id)
31. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.15..2,412.78 rows=440 width=121) (never executed)

  • Join Filter: (ps_1.message_panel_id = mp_1.message_panel_id)
32. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.15..1,847.41 rows=440 width=78) (never executed)

  • Join Filter: (ps_1.section_id = psepsi.panel_section_id)
33. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_external_property_set_epsi on panel_section_external_property_set_item psepsi (cost=0.15..32.70 rows=1,070 width=40) (never executed)

34. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..8.00 rows=113 width=87) (never executed)

35. 0.000 0.000 ↓ 0.0 0

Seq Scan on panel_section ps_1 (cost=0.00..7.44 rows=113 width=87) (never executed)

  • Filter: (type = '1'::numeric)
36. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..4.29 rows=86 width=49) (never executed)

37. 0.000 0.000 ↓ 0.0 0

Seq Scan on message_panel mp_1 (cost=0.00..3.86 rows=86 width=49) (never executed)

38. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..2.80 rows=53 width=30) (never executed)

39. 0.000 0.000 ↓ 0.0 0

Seq Scan on application ap_1 (cost=0.00..2.53 rows=53 width=30) (never executed)

40. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.18 rows=12 width=45) (never executed)

41. 0.000 0.000 ↓ 0.0 0

Seq Scan on hierarchy_possible_values hpv_1 (cost=0.00..1.12 rows=12 width=45) (never executed)

42. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 3 (cost=1.59..9.56 rows=1 width=1,267) (never executed)

43. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.59..9.54 rows=1 width=1,183) (never executed)

44. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.45..9.30 rows=1 width=123) (never executed)

45. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1.18..5.44 rows=8 width=79) (never executed)

  • Hash Cond: (mp_2.message_panel_id = mpcs.message_panel_id)
46. 0.000 0.000 ↓ 0.0 0

Seq Scan on message_panel mp_2 (cost=0.00..3.86 rows=86 width=49) (never executed)

47. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.08..1.08 rows=8 width=30) (never executed)

48. 0.000 0.000 ↓ 0.0 0

Seq Scan on message_panel_conf_setting mpcs (cost=0.00..1.08 rows=8 width=30) (never executed)

49. 0.000 0.000 ↓ 0.0 0

Index Scan using uc_panel_section_order on panel_section ps_2 (cost=0.27..0.47 rows=1 width=56) (never executed)

  • Index Cond: (message_panel_id = mp_2.message_panel_id)
  • Filter: (type = '5'::numeric)
50. 0.000 0.000 ↓ 0.0 0

Index Scan using application_pk on application ap_2 (cost=0.14..0.23 rows=1 width=30) (never executed)

  • Index Cond: (application_id = mp_2.application_id)
51. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 4 (cost=1.11..232.52 rows=165 width=622) (never executed)

52. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.11..230.87 rows=165 width=622) (never executed)

53. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..160.85 rows=165 width=278) (never executed)

54. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..108.13 rows=165 width=143) (never executed)

55. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.28..49.73 rows=39 width=142) (never executed)

  • Join Filter: (ps_3.message_panel_id = (ho.message_panel_id)::numeric)
56. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.28..29.96 rows=39 width=140) (never executed)

57. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.14..21.18 rows=39 width=122) (never executed)

58. 0.000 0.000 ↓ 0.0 0

Seq Scan on panel_section ps_3 (cost=0.00..7.44 rows=39 width=73) (never executed)

  • Filter: (type = '4'::numeric)
59. 0.000 0.000 ↓ 0.0 0

Index Scan using message_panel_pk on message_panel mp_3 (cost=0.14..0.35 rows=1 width=49) (never executed)

  • Index Cond: (message_panel_id = ps_3.message_panel_id)
60. 0.000 0.000 ↓ 0.0 0

Index Scan using application_pk on application ap_3 (cost=0.14..0.23 rows=1 width=30) (never executed)

  • Index Cond: (application_id = mp_3.application_id)
61. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.41 rows=27 width=16) (never executed)

62. 0.000 0.000 ↓ 0.0 0

Seq Scan on message_panel_handling_option ho (cost=0.00..1.27 rows=27 width=16) (never executed)

63. 0.000 0.000 ↓ 0.0 0

Index Scan using uc_ps_item_order on panel_section_item psi_1 (cost=0.28..1.42 rows=8 width=34) (never executed)

  • Index Cond: (panel_section_id = ps_3.section_id)
64. 0.000 0.000 ↓ 0.0 0

Index Scan using property_pk on property p_2 (cost=0.28..0.32 rows=1 width=141) (never executed)

  • Index Cond: (property_id = psi_1.property_id)
65. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_prop_list_pv_unq1 on property_list_possible plp_2 (cost=0.27..0.35 rows=4 width=25) (never executed)

  • Index Cond: (p_2.property_id = property_id)
66. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 5 (cost=44.92..91.66 rows=279 width=1,275) (never executed)

67. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=44.92..86.77 rows=279 width=1,191) (never executed)

  • 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
68. 0.000 0.000 ↓ 0.0 0

Sort (cost=44.92..45.62 rows=279 width=1,195) (never executed)

  • 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)
69. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=19.87..33.59 rows=279 width=1,195) (never executed)

  • Hash Cond: (mpd.message_panel_device_filter_id = mpdf.message_panel_device_filter_id)
70. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=1.99..8.66 rows=207 width=58) (never executed)

  • Hash Cond: (mpd.device_id = odn.org_dvc_name_id)
71. 0.000 0.000 ↓ 0.0 0

Seq Scan on message_panel_device mpd (cost=0.00..6.07 rows=207 width=34) (never executed)

72. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.44..1.44 rows=44 width=40) (never executed)

73. 0.000 0.000 ↓ 0.0 0

Seq Scan on org_dvc_names odn (cost=0.00..1.44 rows=44 width=40) (never executed)

74. 0.000 0.000 ↓ 0.0 0

Hash (cost=17.49..17.49 rows=31 width=143) (never executed)

75. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=9.64..17.49 rows=31 width=143) (never executed)

  • Hash Cond: (ps_4.message_panel_id = (mpdf.message_panel_id)::numeric)
76. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=8.13..15.74 rows=31 width=129) (never executed)

  • Hash Cond: (mp_4.application_id = ap_4.application_id)
77. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=4.93..12.45 rows=31 width=105) (never executed)

  • Hash Cond: (ps_4.message_panel_id = mp_4.message_panel_id)
78. 0.000 0.000 ↓ 0.0 0

Seq Scan on panel_section ps_4 (cost=0.00..7.44 rows=31 width=56) (never executed)

  • Filter: (type = '3'::numeric)
79. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.86..3.86 rows=86 width=49) (never executed)

80. 0.000 0.000 ↓ 0.0 0

Seq Scan on message_panel mp_4 (cost=0.00..3.86 rows=86 width=49) (never executed)

81. 0.000 0.000 ↓ 0.0 0

Hash (cost=2.53..2.53 rows=53 width=30) (never executed)

82. 0.000 0.000 ↓ 0.0 0

Seq Scan on application ap_4 (cost=0.00..2.53 rows=53 width=30) (never executed)

83. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.23..1.23 rows=23 width=28) (never executed)

84. 0.000 0.000 ↓ 0.0 0

Seq Scan on message_panel_device_filter mpdf (cost=0.00..1.23 rows=23 width=28) (never executed)

85. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 6 (cost=35.09..49.58 rows=84 width=1,275) (never executed)

86. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=35.09..48.11 rows=84 width=1,191) (never executed)

  • 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
87. 0.000 0.000 ↓ 0.0 0

Sort (cost=35.09..35.30 rows=84 width=1,232) (never executed)

  • 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)
88. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=23.09..32.41 rows=84 width=1,232) (never executed)

  • Hash Cond: (mp_5.application_id = ap_5.application_id)
89. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=19.90..27.92 rows=84 width=172) (never executed)

  • Hash Cond: (mp_5.message_panel_id = mpr.message_panel_id)
90. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=4.93..12.60 rows=84 width=99) (never executed)

  • Hash Cond: (ps_5.message_panel_id = mp_5.message_panel_id)
91. 0.000 0.000 ↓ 0.0 0

Seq Scan on panel_section ps_5 (cost=0.00..7.44 rows=84 width=56) (never executed)

  • Filter: (type = '2'::numeric)
92. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.86..3.86 rows=86 width=49) (never executed)

93. 0.000 0.000 ↓ 0.0 0

Seq Scan on message_panel mp_5 (cost=0.00..3.86 rows=86 width=49) (never executed)

94. 0.000 0.000 ↓ 0.0 0

Hash (cost=14.91..14.91 rows=4 width=80) (never executed)

95. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.43..14.91 rows=4 width=80) (never executed)

96. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.29..14.28 rows=4 width=78) (never executed)

97. 0.000 0.000 ↓ 0.0 0

Seq Scan on message_panel_recipient mpr (cost=0.00..1.04 rows=4 width=15) (never executed)

98. 0.000 0.000 ↓ 0.0 0

Index Scan using recipients_pk on recipients r (cost=0.29..3.31 rows=1 width=79) (never executed)

  • Index Cond: (mpr.recipient_id = recipient_id)
  • Filter: (deleted_id = '-1'::integer)
99. 0.000 0.000 ↓ 0.0 0

Index Scan using org_dvc_names_pk on org_dvc_names odn_1 (cost=0.14..0.16 rows=1 width=18) (never executed)

  • Index Cond: (r.org_dvc_name_id = org_dvc_name_id)
100. 0.000 0.000 ↓ 0.0 0

Hash (cost=2.53..2.53 rows=53 width=30) (never executed)

101. 0.000 0.000 ↓ 0.0 0

Seq Scan on application ap_5 (cost=0.00..2.53 rows=53 width=30) (never executed)

Planning time : 14.317 ms
Execution time : 1.024 ms