explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Csz

Settings
# exclusive inclusive rows x rows loops node
1. 5.673 62.489 ↑ 11.0 719 1

Append (cost=77.61..581.18 rows=7,944 width=1,442) (actual time=28.702..62.489 rows=719 loops=1)

2. 5.408 37.521 ↓ 2.0 607 1

Hash Left Join (cost=77.61..82.03 rows=304 width=803) (actual time=28.691..37.521 rows=607 loops=1)

  • Hash Cond: (p.property_id = hpv.property_id)
3. 3.182 32.098 ↓ 2.0 607 1

Hash Right Join (cost=63.79..66.17 rows=304 width=361) (actual time=28.646..32.098 rows=607 loops=1)

  • Hash Cond: (plp.property_id = p.property_id)
4. 0.312 0.312 ↑ 1.0 73 1

Seq Scan on property_list_possible plp (cost=0.00..1.73 rows=73 width=23) (actual time=0.011..0.312 rows=73 loops=1)

5. 3.111 28.604 ↓ 1.9 582 1

Hash (cost=59.99..59.99 rows=304 width=338) (actual time=28.604..28.604 rows=582 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 187kB
6. 5.895 25.493 ↓ 1.9 582 1

Hash Join (cost=37.97..59.99 rows=304 width=338) (actual time=17.348..25.493 rows=582 loops=1)

  • Hash Cond: (p.property_id = psi.property_id)
7. 2.529 2.529 ↑ 1.0 580 1

Seq Scan on property p (cost=0.00..16.80 rows=580 width=157) (actual time=0.020..2.529 rows=580 loops=1)

8. 3.491 17.069 ↓ 1.9 582 1

Hash (cost=34.17..34.17 rows=304 width=188) (actual time=17.069..17.069 rows=582 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 135kB
9. 6.975 13.578 ↓ 1.9 582 1

Hash Join (cost=12.70..34.17 rows=304 width=188) (actual time=3.239..13.578 rows=582 loops=1)

  • Hash Cond: (psi.panel_section_id = ps.section_id)
10. 3.403 3.403 ↑ 1.0 613 1

Seq Scan on panel_section_item psi (cost=0.00..16.13 rows=613 width=68) (actual time=0.010..3.403 rows=613 loops=1)

11. 0.366 3.200 ↑ 1.0 61 1

Hash (cost=11.94..11.94 rows=61 width=144) (actual time=3.200..3.200 rows=61 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
12. 0.695 2.834 ↑ 1.0 61 1

Hash Join (cost=6.89..11.94 rows=61 width=144) (actual time=1.154..2.834 rows=61 loops=1)

  • Hash Cond: (mp.application_id = ap.application_id)
13. 0.704 1.695 ↑ 1.0 61 1

Hash Join (cost=4.04..8.33 rows=61 width=126) (actual time=0.675..1.695 rows=61 loops=1)

  • Hash Cond: (ps.message_panel_id = mp.message_panel_id)
14. 0.365 0.365 ↑ 1.0 61 1

Seq Scan on panel_section ps (cost=0.00..3.54 rows=61 width=83) (actual time=0.015..0.365 rows=61 loops=1)

  • Filter: (type = '1'::numeric)
  • Rows Removed by Filter: 62
15. 0.277 0.626 ↑ 1.0 46 1

Hash (cost=3.46..3.46 rows=46 width=49) (actual time=0.626..0.626 rows=46 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
16. 0.349 0.349 ↑ 1.0 46 1

Seq Scan on message_panel mp (cost=0.00..3.46 rows=46 width=49) (actual time=0.009..0.349 rows=46 loops=1)

17. 0.226 0.444 ↑ 1.0 38 1

Hash (cost=2.38..2.38 rows=38 width=30) (actual time=0.444..0.444 rows=38 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
18. 0.218 0.218 ↑ 1.0 38 1

Seq Scan on application ap (cost=0.00..2.38 rows=38 width=30) (actual time=0.011..0.218 rows=38 loops=1)

19. 0.008 0.015 ↓ 0.0 0 1

Hash (cost=11.70..11.70 rows=170 width=430) (actual time=0.015..0.015 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
20. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on hierarchy_possible_values hpv (cost=0.00..11.70 rows=170 width=430) (actual time=0.007..0.007 rows=0 loops=1)

21. 0.008 0.042 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=116.66..316.43 rows=7,434 width=874) (actual time=0.042..0.042 rows=0 loops=1)

22. 0.008 0.034 ↓ 0.0 0 1

Hash Left Join (cost=116.66..223.51 rows=7,434 width=850) (actual time=0.034..0.034 rows=0 loops=1)

  • Hash Cond: (p_1.property_id = hpv_1.property_id)
23. 0.009 0.026 ↓ 0.0 0 1

Hash Join (cost=102.83..160.01 rows=7,434 width=376) (actual time=0.026..0.026 rows=0 loops=1)

  • Hash Cond: (psepsi.external_property_set_id = eps.external_property_set_id)
24. 0.008 0.017 ↓ 0.0 0 1

Hash Join (cost=12.70..40.68 rows=531 width=140) (actual time=0.017..0.017 rows=0 loops=1)

  • Hash Cond: (psepsi.panel_section_id = ps_1.section_id)
25. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on panel_section_external_property_set_item psepsi (cost=0.00..20.70 rows=1,070 width=40) (actual time=0.009..0.009 rows=0 loops=1)

26. 0.000 0.000 ↓ 0.0 0

Hash (cost=11.94..11.94 rows=61 width=144) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=6.89..11.94 rows=61 width=144) (never executed)

  • Hash Cond: (mp_1.application_id = ap_1.application_id)
28. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=4.04..8.33 rows=61 width=126) (never executed)

  • Hash Cond: (ps_1.message_panel_id = mp_1.message_panel_id)
29. 0.000 0.000 ↓ 0.0 0

Seq Scan on panel_section ps_1 (cost=0.00..3.54 rows=61 width=83) (never executed)

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

Hash (cost=3.46..3.46 rows=46 width=49) (never executed)

31. 0.000 0.000 ↓ 0.0 0

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

32. 0.000 0.000 ↓ 0.0 0

Hash (cost=2.38..2.38 rows=38 width=30) (never executed)

33. 0.000 0.000 ↓ 0.0 0

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

34. 0.000 0.000 ↓ 0.0 0

Hash (cost=81.38..81.38 rows=700 width=260) (never executed)

35. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=45.08..81.38 rows=700 width=260) (never executed)

  • Hash Cond: (epsi.external_property_set_id = eps.external_property_set_id)
36. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=33.95..61.45 rows=700 width=252) (never executed)

  • Hash Cond: ((epsi.external_property_id)::numeric = p_1.property_id)
37. 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)

38. 0.000 0.000 ↓ 0.0 0

Hash (cost=26.70..26.70 rows=580 width=180) (never executed)

39. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=24.05..26.70 rows=580 width=180) (never executed)

  • Hash Cond: (plp_1.property_id = p_1.property_id)
40. 0.000 0.000 ↓ 0.0 0

Seq Scan on property_list_possible plp_1 (cost=0.00..1.73 rows=73 width=23) (never executed)

41. 0.000 0.000 ↓ 0.0 0

Hash (cost=16.80..16.80 rows=580 width=157) (never executed)

42. 0.000 0.000 ↓ 0.0 0

Seq Scan on property p_1 (cost=0.00..16.80 rows=580 width=157) (never executed)

43. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.50..10.50 rows=50 width=8) (never executed)

44. 0.000 0.000 ↓ 0.0 0

Seq Scan on external_property_set eps (cost=0.00..10.50 rows=50 width=8) (never executed)

45. 0.000 0.000 ↓ 0.0 0

Hash (cost=11.70..11.70 rows=170 width=430) (never executed)

46. 0.000 0.000 ↓ 0.0 0

Seq Scan on hierarchy_possible_values hpv_1 (cost=0.00..11.70 rows=170 width=430) (never executed)

47. 0.040 0.819 ↓ 3.0 3 1

Subquery Scan on *SELECT* 3 (cost=1.33..6.37 rows=1 width=1,321) (actual time=0.392..0.819 rows=3 loops=1)

48. 0.114 0.779 ↓ 3.0 3 1

Nested Loop (cost=1.33..6.35 rows=1 width=1,237) (actual time=0.379..0.779 rows=3 loops=1)

49. 0.066 0.611 ↓ 3.0 3 1

Nested Loop (cost=1.19..5.82 rows=1 width=177) (actual time=0.329..0.611 rows=3 loops=1)

50. 0.242 0.494 ↓ 1.5 3 1

Hash Join (cost=1.04..4.70 rows=2 width=159) (actual time=0.293..0.494 rows=3 loops=1)

  • Hash Cond: (mp_2.message_panel_id = mpcs.message_panel_id)
51. 0.200 0.200 ↑ 1.0 46 1

Seq Scan on message_panel mp_2 (cost=0.00..3.46 rows=46 width=49) (actual time=0.012..0.200 rows=46 loops=1)

52. 0.031 0.052 ↓ 1.5 3 1

Hash (cost=1.02..1.02 rows=2 width=110) (actual time=0.052..0.052 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
53. 0.021 0.021 ↓ 1.5 3 1

Seq Scan on message_panel_conf_setting mpcs (cost=0.00..1.02 rows=2 width=110) (actual time=0.008..0.021 rows=3 loops=1)

54. 0.051 0.051 ↑ 1.0 1 3

Index Scan using uc_panel_section_order on panel_section ps_2 (cost=0.14..0.55 rows=1 width=56) (actual time=0.012..0.017 rows=1 loops=3)

  • Index Cond: (message_panel_id = mp_2.message_panel_id)
  • Filter: (type = '5'::numeric)
  • Rows Removed by Filter: 3
55. 0.054 0.054 ↑ 1.0 1 3

Index Scan using application_pk on application ap_2 (cost=0.14..0.51 rows=1 width=30) (actual time=0.018..0.018 rows=1 loops=3)

  • Index Cond: (application_id = mp_2.application_id)
56. 0.503 12.640 ↑ 2.5 60 1

Subquery Scan on *SELECT* 4 (cost=73.41..90.82 rows=152 width=625) (actual time=7.688..12.640 rows=60 loops=1)

57. 3.868 12.137 ↑ 2.5 60 1

Hash Left Join (cost=73.41..89.30 rows=152 width=625) (actual time=7.678..12.137 rows=60 loops=1)

  • Hash Cond: (ps_3.message_panel_id = (ho.message_panel_id)::numeric)
58. 0.630 8.255 ↓ 1.2 60 1

Hash Right Join (cost=49.69..51.75 rows=50 width=299) (actual time=7.447..8.255 rows=60 loops=1)

  • Hash Cond: (plp_2.property_id = p_2.property_id)
59. 0.288 0.288 ↑ 1.0 73 1

Seq Scan on property_list_possible plp_2 (cost=0.00..1.73 rows=73 width=23) (actual time=0.008..0.288 rows=73 loops=1)

60. 0.169 7.337 ↑ 1.6 31 1

Hash (cost=49.06..49.06 rows=50 width=276) (actual time=7.337..7.337 rows=31 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
61. 0.430 7.168 ↑ 1.6 31 1

Nested Loop (cost=10.89..49.06 rows=50 width=276) (actual time=4.588..7.168 rows=31 loops=1)

62. 2.869 6.521 ↑ 1.6 31 1

Hash Join (cost=10.61..29.54 rows=50 width=142) (actual time=4.549..6.521 rows=31 loops=1)

  • Hash Cond: (psi_1.panel_section_id = ps_3.section_id)
63. 2.544 2.544 ↑ 1.0 613 1

Seq Scan on panel_section_item psi_1 (cost=0.00..16.13 rows=613 width=31) (actual time=0.009..2.544 rows=613 loops=1)

64. 0.061 1.108 ↑ 1.0 10 1

Hash (cost=10.49..10.49 rows=10 width=135) (actual time=1.108..1.108 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
65. 0.234 1.047 ↑ 1.0 10 1

Hash Join (cost=7.87..10.49 rows=10 width=135) (actual time=0.851..1.047 rows=10 loops=1)

  • Hash Cond: (ap_3.application_id = mp_3.application_id)
66. 0.162 0.162 ↑ 1.0 38 1

Seq Scan on application ap_3 (cost=0.00..2.38 rows=38 width=30) (actual time=0.007..0.162 rows=38 loops=1)

67. 0.057 0.651 ↑ 1.0 10 1

Hash (cost=7.74..7.74 rows=10 width=117) (actual time=0.651..0.651 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
68. 0.272 0.594 ↑ 1.0 10 1

Hash Join (cost=3.66..7.74 rows=10 width=117) (actual time=0.198..0.594 rows=10 loops=1)

  • Hash Cond: (mp_3.message_panel_id = ps_3.message_panel_id)
69. 0.192 0.192 ↑ 1.0 46 1

Seq Scan on message_panel mp_3 (cost=0.00..3.46 rows=46 width=49) (actual time=0.006..0.192 rows=46 loops=1)

70. 0.058 0.130 ↑ 1.0 10 1

Hash (cost=3.54..3.54 rows=10 width=68) (actual time=0.130..0.130 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
71. 0.072 0.072 ↑ 1.0 10 1

Seq Scan on panel_section ps_3 (cost=0.00..3.54 rows=10 width=68) (actual time=0.017..0.072 rows=10 loops=1)

  • Filter: (type = '4'::numeric)
  • Rows Removed by Filter: 113
72. 0.217 0.217 ↑ 1.0 1 31

Index Scan using property_pk on property p_2 (cost=0.28..0.39 rows=1 width=141) (actual time=0.007..0.007 rows=1 loops=31)

  • Index Cond: (property_id = psi_1.property_id)
73. 0.008 0.014 ↓ 0.0 0 1

Hash (cost=16.10..16.10 rows=610 width=72) (actual time=0.014..0.014 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
74. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on message_panel_handling_option ho (cost=0.00..16.10 rows=610 width=72) (actual time=0.006..0.006 rows=0 loops=1)

75. 0.043 1.886 ↑ 1.5 4 1

Subquery Scan on *SELECT* 5 (cost=30.09..31.09 rows=6 width=1,275) (actual time=1.702..1.886 rows=4 loops=1)

76. 0.206 1.843 ↑ 1.5 4 1

GroupAggregate (cost=30.09..30.99 rows=6 width=1,191) (actual time=1.688..1.843 rows=4 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
77. 0.180 1.637 ↓ 2.3 14 1

Sort (cost=30.09..30.10 rows=6 width=1,207) (actual time=1.589..1.637 rows=14 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: 32kB
78. 0.232 1.457 ↓ 2.3 14 1

Nested Loop Left Join (cost=9.81..30.01 rows=6 width=1,207) (actual time=0.945..1.457 rows=14 loops=1)

79. 0.139 1.099 ↓ 2.3 14 1

Nested Loop Left Join (cost=9.67..28.73 rows=6 width=147) (actual time=0.856..1.099 rows=14 loops=1)

80. 0.058 0.872 ↑ 1.5 4 1

Hash Right Join (cost=9.52..26.78 rows=6 width=155) (actual time=0.825..0.872 rows=4 loops=1)

  • Hash Cond: ((mpdf.message_panel_id)::numeric = ps_4.message_panel_id)
81. 0.029 0.029 ↑ 80.0 4 1

Seq Scan on message_panel_device_filter mpdf (cost=0.00..13.20 rows=320 width=40) (actual time=0.015..0.029 rows=4 loops=1)

82. 0.027 0.785 ↑ 1.0 4 1

Hash (cost=9.47..9.47 rows=4 width=129) (actual time=0.785..0.785 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
83. 0.056 0.758 ↑ 1.0 4 1

Nested Loop (cost=3.73..9.47 rows=4 width=129) (actual time=0.167..0.758 rows=4 loops=1)

84. 0.276 0.674 ↑ 1.0 4 1

Hash Join (cost=3.59..7.43 rows=4 width=105) (actual time=0.140..0.674 rows=4 loops=1)

  • Hash Cond: (mp_4.message_panel_id = ps_4.message_panel_id)
85. 0.318 0.318 ↑ 1.0 46 1

Seq Scan on message_panel mp_4 (cost=0.00..3.46 rows=46 width=49) (actual time=0.007..0.318 rows=46 loops=1)

86. 0.040 0.080 ↑ 1.0 4 1

Hash (cost=3.54..3.54 rows=4 width=56) (actual time=0.080..0.080 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
87. 0.040 0.040 ↑ 1.0 4 1

Seq Scan on panel_section ps_4 (cost=0.00..3.54 rows=4 width=56) (actual time=0.020..0.040 rows=4 loops=1)

  • Filter: (type = '3'::numeric)
  • Rows Removed by Filter: 119
88. 0.028 0.028 ↑ 1.0 1 4

Index Scan using application_pk on application ap_4 (cost=0.14..0.51 rows=1 width=30) (actual time=0.007..0.007 rows=1 loops=4)

  • Index Cond: (application_id = mp_4.application_id)
89. 0.088 0.088 ↓ 4.0 4 4

Index Scan using idx_message_panel_device_dvcf on message_panel_device mpd (cost=0.15..0.32 rows=1 width=56) (actual time=0.008..0.022 rows=4 loops=4)

  • Index Cond: (mpdf.message_panel_device_filter_id = message_panel_device_filter_id)
90. 0.126 0.126 ↑ 1.0 1 14

Index Scan using org_dvc_names_pk on org_dvc_names odn (cost=0.14..0.20 rows=1 width=40) (actual time=0.009..0.009 rows=1 loops=14)

  • Index Cond: (mpd.device_id = org_dvc_name_id)
91. 0.350 3.807 ↑ 1.0 45 1

Subquery Scan on *SELECT* 6 (cost=21.36..23.61 rows=45 width=1,275) (actual time=3.275..3.807 rows=45 loops=1)

92. 0.614 3.457 ↑ 1.0 45 1

HashAggregate (cost=21.36..22.82 rows=45 width=1,191) (actual time=3.264..3.457 rows=45 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
93. 0.505 2.843 ↑ 1.0 45 1

Hash Join (cost=10.55..15.96 rows=45 width=1,369) (actual time=1.525..2.843 rows=45 loops=1)

  • Hash Cond: (mp_5.application_id = ap_5.application_id)
94. 0.343 1.950 ↑ 1.0 45 1

Hash Left Join (cost=7.70..11.98 rows=45 width=309) (actual time=1.110..1.950 rows=45 loops=1)

  • Hash Cond: (mp_5.message_panel_id = mpr.message_panel_id)
95. 0.356 0.909 ↑ 1.0 45 1

Hash Join (cost=4.04..8.13 rows=45 width=99) (actual time=0.390..0.909 rows=45 loops=1)

  • Hash Cond: (ps_5.message_panel_id = mp_5.message_panel_id)
96. 0.195 0.195 ↑ 1.0 45 1

Seq Scan on panel_section ps_5 (cost=0.00..3.54 rows=45 width=56) (actual time=0.009..0.195 rows=45 loops=1)

  • Filter: (type = '2'::numeric)
  • Rows Removed by Filter: 78
97. 0.183 0.358 ↑ 1.0 46 1

Hash (cost=3.46..3.46 rows=46 width=49) (actual time=0.358..0.358 rows=46 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
98. 0.175 0.175 ↑ 1.0 46 1

Seq Scan on message_panel mp_5 (cost=0.00..3.46 rows=46 width=49) (actual time=0.006..0.175 rows=46 loops=1)

99. 0.019 0.698 ↑ 1.0 2 1

Hash (cost=3.64..3.64 rows=2 width=242) (actual time=0.698..0.698 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
100. 0.120 0.679 ↑ 1.0 2 1

Nested Loop Left Join (cost=1.18..3.64 rows=2 width=242) (actual time=0.534..0.679 rows=2 loops=1)

  • Join Filter: (mpr.recipient_id = r.recipient_id)
  • Rows Removed by Join Filter: 24
101. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on message_panel_recipient mpr (cost=0.00..1.02 rows=2 width=40) (actual time=0.008..0.015 rows=2 loops=1)

102. 0.148 0.544 ↓ 13.0 13 2

Materialize (cost=1.18..2.59 rows=1 width=218) (actual time=0.081..0.272 rows=13 loops=2)

103. 0.172 0.396 ↓ 13.0 13 1

Hash Right Join (cost=1.18..2.58 rows=1 width=218) (actual time=0.149..0.396 rows=13 loops=1)

  • Hash Cond: (odn_1.org_dvc_name_id = r.org_dvc_name_id)
104. 0.106 0.106 ↑ 1.0 29 1

Seq Scan on org_dvc_names odn_1 (cost=0.00..1.29 rows=29 width=18) (actual time=0.008..0.106 rows=29 loops=1)

105. 0.058 0.118 ↓ 13.0 13 1

Hash (cost=1.16..1.16 rows=1 width=216) (actual time=0.118..0.118 rows=13 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
106. 0.060 0.060 ↓ 13.0 13 1

Seq Scan on recipients r (cost=0.00..1.16 rows=1 width=216) (actual time=0.012..0.060 rows=13 loops=1)

  • Filter: (deleted_id = '-1'::integer)
107. 0.239 0.388 ↑ 1.0 38 1

Hash (cost=2.38..2.38 rows=38 width=30) (actual time=0.388..0.388 rows=38 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
108. 0.149 0.149 ↑ 1.0 38 1

Seq Scan on application ap_5 (cost=0.00..2.38 rows=38 width=30) (actual time=0.007..0.149 rows=38 loops=1)

109. 0.007 0.040 ↓ 0.0 0 1

Subquery Scan on *SELECT* 7 (cost=3.98..20.05 rows=1 width=1,805) (actual time=0.040..0.040 rows=0 loops=1)

110. 0.007 0.033 ↓ 0.0 0 1

Nested Loop (cost=3.98..20.04 rows=1 width=1,721) (actual time=0.033..0.033 rows=0 loops=1)

111. 0.007 0.026 ↓ 0.0 0 1

Nested Loop (cost=3.84..19.50 rows=1 width=693) (actual time=0.026..0.026 rows=0 loops=1)

  • Join Filter: (ps_6.message_panel_id = mp_6.message_panel_id)
112. 0.006 0.019 ↓ 0.0 0 1

Nested Loop (cost=3.69..19.27 rows=1 width=658) (actual time=0.019..0.019 rows=0 loops=1)

113. 0.008 0.013 ↓ 0.0 0 1

Hash Join (cost=3.55..18.67 rows=2 width=96) (actual time=0.013..0.013 rows=0 loops=1)

  • Hash Cond: ((so.message_panel_id)::numeric = ps_6.message_panel_id)
114. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on sender_overrides so (cost=0.00..13.40 rows=340 width=40) (actual time=0.005..0.005 rows=0 loops=1)

115. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.54..3.54 rows=1 width=56) (never executed)

116. 0.000 0.000 ↓ 0.0 0

Seq Scan on panel_section ps_6 (cost=0.00..3.54 rows=1 width=56) (never executed)

  • Filter: (type = '8'::numeric)
117. 0.000 0.000 ↓ 0.0 0

Index Scan using unique_sender_overrides_det on sender_overrides_details sd (cost=0.14..0.29 rows=1 width=626) (never executed)

  • Index Cond: (sender_overrides_id = so.sender_overrides_id)
118. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (message_panel_id = (so.message_panel_id)::numeric)
119. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (application_id = mp_6.application_id)
120. 0.006 0.061 ↓ 0.0 0 1

Nested Loop (cost=3.69..7.72 rows=1 width=1,301) (actual time=0.061..0.061 rows=0 loops=1)

121. 0.021 0.055 ↓ 0.0 0 1

Hash Join (cost=3.55..7.19 rows=1 width=99) (actual time=0.055..0.055 rows=0 loops=1)

  • Hash Cond: (mp_7.message_panel_id = ps_7.message_panel_id)
122. 0.008 0.008 ↑ 46.0 1 1

Seq Scan on message_panel mp_7 (cost=0.00..3.46 rows=46 width=49) (actual time=0.008..0.008 rows=1 loops=1)

123. 0.007 0.026 ↓ 0.0 0 1

Hash (cost=3.54..3.54 rows=1 width=56) (actual time=0.026..0.026 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
124. 0.019 0.019 ↓ 0.0 0 1

Seq Scan on panel_section ps_7 (cost=0.00..3.54 rows=1 width=56) (actual time=0.019..0.019 rows=0 loops=1)

  • Filter: (type = '6'::numeric)
  • Rows Removed by Filter: 123
125. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (application_id = mp_7.application_id)
Planning time : 12.271 ms
Execution time : 67.144 ms