explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iCoM

Settings
# exclusive inclusive rows x rows loops node
1. 0.027 3,204.999 ↓ 10.0 10 1

Sort (cost=193,450.25..193,450.26 rows=1 width=212) (actual time=3,204.995..3,204.999 rows=10 loops=1)

  • Sort Key: ba.budget_id, ba.property_id, ba.gl_account_id, ba.post_month
  • Sort Method: quicksort Memory: 25kB
2.          

CTE budget_amounts

3. 0.066 3.059 ↓ 10.0 10 1

Nested Loop (cost=30.03..280.93 rows=1 width=89) (actual time=1.053..3.059 rows=10 loops=1)

4. 0.050 0.067 ↓ 4.2 38 1

Bitmap Heap Scan on budgets b (cost=4.70..16.70 rows=9 width=8) (actual time=0.026..0.067 rows=38 loops=1)

  • Recheck Cond: (cid = 15229)
  • Filter: ((deleted_on IS NULL) AND (is_default = 1) AND (budget_status_type_id = 1))
  • Rows Removed by Filter: 19
  • Heap Blocks: exact=8
5. 0.017 0.017 ↑ 1.0 57 1

Bitmap Index Scan on pk_budgets (cost=0.00..4.70 rows=57 width=0) (actual time=0.017..0.017 rows=57 loops=1)

  • Index Cond: (cid = 15229)
6. 0.152 2.926 ↓ 0.0 0 38

Bitmap Heap Scan on budget_gl_account_months bgam (cost=25.32..29.35 rows=1 width=57) (actual time=0.077..0.077 rows=0 loops=38)

  • Recheck Cond: ((gl_account_id = 265476) AND (budget_id = b.id))
  • Filter: ((post_month <= '2019-10-01'::date) AND (post_month >= '2019-01-01'::date) AND (cid = 15229) AND (property_id = 589263))
  • Rows Removed by Filter: 8
  • Heap Blocks: exact=36
7. 0.114 2.774 ↓ 0.0 0 38

BitmapAnd (cost=25.32..25.32 rows=1 width=0) (actual time=0.073..0.073 rows=0 loops=38)

8. 0.722 0.722 ↓ 2.3 471 38

Bitmap Index Scan on idx_gl_budgets_gl_account_id (cost=0.00..5.93 rows=201 width=0) (actual time=0.019..0.019 rows=471 loops=38)

  • Index Cond: (gl_account_id = 265476)
9. 1.938 1.938 ↓ 1.5 1,304 38

Bitmap Index Scan on idx_gl_budgets_budget_id (cost=0.00..19.14 rows=896 width=0) (actual time=0.051..0.051 rows=1,304 loops=38)

  • Index Cond: (budget_id = b.id)
10.          

CTE year_budget

11. 0.020 2.038 ↑ 1.0 1 1

HashAggregate (cost=0.03..0.04 rows=1 width=44) (actual time=2.036..2.038 rows=1 loops=1)

  • Group Key: ba_1.budget_id, ba_1.property_id, ba_1.gl_account_id
12. 2.018 2.018 ↓ 10.0 10 1

CTE Scan on budget_amounts ba_1 (cost=0.00..0.02 rows=1 width=30) (actual time=0.001..2.018 rows=10 loops=1)

13.          

CTE accrual_actual_year_budget

14. 0.022 0.319 ↑ 1.0 1 1

GroupAggregate (cost=1.41..25.52 rows=1 width=40) (actual time=0.318..0.319 rows=1 loops=1)

  • Group Key: gd.property_id, gd.accrual_gl_account_id
15. 0.026 0.297 ↓ 21.0 21 1

Nested Loop (cost=1.41..25.50 rows=1 width=13) (actual time=0.045..0.297 rows=21 loops=1)

16. 0.022 0.208 ↓ 21.0 21 1

Nested Loop (cost=1.13..17.19 rows=1 width=17) (actual time=0.034..0.208 rows=21 loops=1)

17. 0.081 0.081 ↓ 21.0 21 1

Index Scan using idx_gl_details_cid_property_id_accrual_gl_account_id on gl_details gd (cost=0.57..8.60 rows=1 width=21) (actual time=0.017..0.081 rows=21 loops=1)

  • Index Cond: ((cid = 15229) AND (property_id = 589263) AND (accrual_gl_account_id = 265476))
  • Filter: ((post_month <= '2019-10-01'::date) AND (post_month >= '2019-01-01'::date))
  • Rows Removed by Filter: 25
18. 0.105 0.105 ↑ 1.0 1 21

Index Scan using idx_gl_headers_id on gl_headers gh (cost=0.56..8.59 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=21)

  • Index Cond: (id = gd.gl_header_id)
  • Filter: ((cid = 15229) AND (gl_header_status_type_id <> ALL ('{2,4,5,6}'::integer[])))
19. 0.063 0.063 ↑ 1.0 1 21

Index Scan using idx_property_gl_settings_cid_property_id_activate_standard_post on property_gl_settings pgs (cost=0.28..8.30 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=21)

  • Index Cond: ((cid = 15229) AND (property_id = 589263))
  • Filter: (is_cash_basis = 0)
20.          

CTE accrual_actual_month_budget

21. 0.014 0.136 ↑ 1.0 1 1

GroupAggregate (cost=1.41..25.51 rows=1 width=40) (actual time=0.135..0.136 rows=1 loops=1)

  • Group Key: gd_1.property_id, gd_1.accrual_gl_account_id
22. 0.013 0.122 ↓ 10.0 10 1

Nested Loop (cost=1.41..25.49 rows=1 width=13) (actual time=0.042..0.122 rows=10 loops=1)

23. 0.012 0.079 ↓ 10.0 10 1

Nested Loop (cost=1.13..17.18 rows=1 width=17) (actual time=0.035..0.079 rows=10 loops=1)

24. 0.037 0.037 ↓ 10.0 10 1

Index Scan using idx_gl_details_cid_property_id_accrual_gl_account_id on gl_details gd_1 (cost=0.57..8.59 rows=1 width=21) (actual time=0.026..0.037 rows=10 loops=1)

  • Index Cond: ((cid = 15229) AND (property_id = 589263) AND (accrual_gl_account_id = 265476))
  • Filter: (post_month = '2019-10-01'::date)
  • Rows Removed by Filter: 36
25. 0.030 0.030 ↑ 1.0 1 10

Index Scan using idx_gl_headers_id on gl_headers gh_1 (cost=0.56..8.59 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=10)

  • Index Cond: (id = gd_1.gl_header_id)
  • Filter: ((cid = 15229) AND (gl_header_status_type_id <> ALL ('{2,4,5,6}'::integer[])))
26. 0.030 0.030 ↑ 1.0 1 10

Index Scan using idx_property_gl_settings_cid_property_id_activate_standard_post on property_gl_settings pgs_1 (cost=0.28..8.30 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=10)

  • Index Cond: ((cid = 15229) AND (property_id = 589263))
  • Filter: (is_cash_basis = 0)
27.          

CTE cash_actual_year_budget

28. 0.001 5.069 ↓ 0.0 0 1

GroupAggregate (cost=1.41..29.77 rows=1 width=40) (actual time=5.069..5.069 rows=0 loops=1)

  • Group Key: gd_2.property_id, gd_2.cash_gl_account_id
29. 0.006 5.068 ↓ 0.0 0 1

Nested Loop (cost=1.41..29.75 rows=1 width=13) (actual time=5.068..5.068 rows=0 loops=1)

30. 0.026 5.026 ↓ 12.0 12 1

Nested Loop (cost=1.13..21.44 rows=1 width=17) (actual time=0.043..5.026 rows=12 loops=1)

31. 4.940 4.940 ↓ 12.0 12 1

Index Scan using idx_gl_details_cid_property_id_post_month_cash_gl_account_id on gl_details gd_2 (cost=0.57..12.85 rows=1 width=21) (actual time=0.026..4.940 rows=12 loops=1)

  • Index Cond: ((cid = 15229) AND (property_id = 589263) AND (post_month <= '2019-10-01'::date) AND (post_month >= '2019-01-01'::date) AND (cash_gl_account_id = 265476))
32. 0.060 0.060 ↑ 1.0 1 12

Index Scan using idx_gl_headers_id on gl_headers gh_2 (cost=0.56..8.59 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=12)

  • Index Cond: (id = gd_2.gl_header_id)
  • Filter: ((offsetting_gl_header_id IS NULL) AND (cid = 15229) AND (gl_header_status_type_id <> ALL ('{2,4,5,6}'::integer[])))
33. 0.036 0.036 ↓ 0.0 0 12

Index Scan using idx_property_gl_settings_cid_property_id_activate_standard_post on property_gl_settings pgs_2 (cost=0.28..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=12)

  • Index Cond: ((cid = 15229) AND (property_id = 589263))
  • Filter: (is_cash_basis <> 0)
  • Rows Removed by Filter: 1
34.          

CTE cash_actual_month_budget

35. 0.001 0.035 ↓ 0.0 0 1

GroupAggregate (cost=1.41..25.51 rows=1 width=40) (actual time=0.035..0.035 rows=0 loops=1)

  • Group Key: gd_3.property_id, gd_3.cash_gl_account_id
36. 0.001 0.034 ↓ 0.0 0 1

Nested Loop (cost=1.41..25.49 rows=1 width=13) (actual time=0.034..0.034 rows=0 loops=1)

37. 0.002 0.026 ↑ 1.0 1 1

Nested Loop (cost=1.13..17.18 rows=1 width=17) (actual time=0.024..0.026 rows=1 loops=1)

38. 0.013 0.013 ↑ 1.0 1 1

Index Scan using idx_gl_details_cid_property_id_post_month_cash_gl_account_id on gl_details gd_3 (cost=0.57..8.59 rows=1 width=21) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: ((cid = 15229) AND (property_id = 589263) AND (post_month = '2019-10-01'::date) AND (cash_gl_account_id = 265476))
39. 0.011 0.011 ↑ 1.0 1 1

Index Scan using idx_gl_headers_id on gl_headers gh_3 (cost=0.56..8.59 rows=1 width=8) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (id = gd_3.gl_header_id)
  • Filter: ((offsetting_gl_header_id IS NULL) AND (cid = 15229) AND (gl_header_status_type_id <> ALL ('{2,4,5,6}'::integer[])))
40. 0.007 0.007 ↓ 0.0 0 1

Index Scan using idx_property_gl_settings_cid_property_id_activate_standard_post on property_gl_settings pgs_3 (cost=0.28..8.30 rows=1 width=8) (actual time=0.006..0.007 rows=0 loops=1)

  • Index Cond: ((cid = 15229) AND (property_id = 589263))
  • Filter: (is_cash_basis <> 0)
  • Rows Removed by Filter: 1
41.          

CTE pending_invoices_month

42. 0.001 1.405 ↓ 0.0 0 1

GroupAggregate (cost=38.58..50.64 rows=1 width=40) (actual time=1.405..1.405 rows=0 loops=1)

  • Group Key: ad.property_id, ad.gl_account_id
43. 0.021 1.404 ↓ 0.0 0 1

Nested Loop (cost=38.58..50.62 rows=1 width=14) (actual time=1.404..1.404 rows=0 loops=1)

44. 0.156 1.299 ↓ 21.0 21 1

Bitmap Heap Scan on ap_details ad (cost=38.15..42.17 rows=1 width=22) (actual time=1.192..1.299 rows=21 loops=1)

  • Recheck Cond: ((cid = 15229) AND (property_id = 589263) AND (gl_account_id = 265476))
  • Filter: ((deleted_by IS NULL) AND (deleted_on IS NULL) AND (post_month = '2019-10-01'::date))
  • Rows Removed by Filter: 73
  • Heap Blocks: exact=75
45. 0.211 1.143 ↓ 0.0 0 1

BitmapAnd (cost=38.15..38.15 rows=1 width=0) (actual time=1.143..1.143 rows=0 loops=1)

46. 0.740 0.740 ↓ 75.3 6,404 1

Bitmap Index Scan on idx_ap_details_cid_property_id (cost=0.00..5.28 rows=85 width=0) (actual time=0.740..0.740 rows=6,404 loops=1)

  • Index Cond: ((cid = 15229) AND (property_id = 589263))
47. 0.192 0.192 ↓ 1.3 2,091 1

Bitmap Index Scan on idx_ap_details_gl_account_id (cost=0.00..32.61 rows=1,624 width=0) (actual time=0.192..0.192 rows=2,091 loops=1)

  • Index Cond: (gl_account_id = 265476)
48. 0.084 0.084 ↓ 0.0 0 21

Index Scan using idx_ap_headers on ap_headers ah (cost=0.43..8.45 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=21)

  • Index Cond: (id = ad.ap_header_id)
  • Filter: ((reversal_ap_header_id IS NULL) AND (ap_payment_id IS NULL) AND (NOT is_batching) AND (NOT is_posted) AND (NOT is_template) AND (cid = 15229) AND (ap_header_type_id = 5))
  • Rows Removed by Filter: 1
49.          

CTE pending_invoices_year

50. 0.001 1.424 ↓ 0.0 0 1

GroupAggregate (cost=38.58..50.64 rows=1 width=40) (actual time=1.424..1.424 rows=0 loops=1)

  • Group Key: ad_1.property_id, ad_1.gl_account_id
51. 0.066 1.423 ↓ 0.0 0 1

Nested Loop (cost=38.58..50.62 rows=1 width=14) (actual time=1.423..1.423 rows=0 loops=1)

52. 0.126 1.192 ↓ 55.0 55 1

Bitmap Heap Scan on ap_details ad_1 (cost=38.15..42.17 rows=1 width=22) (actual time=1.090..1.192 rows=55 loops=1)

  • Recheck Cond: ((cid = 15229) AND (property_id = 589263) AND (gl_account_id = 265476))
  • Filter: ((deleted_by IS NULL) AND (deleted_on IS NULL) AND (post_month <= '2019-10-01'::date) AND (post_month >= '2019-01-01'::date))
  • Rows Removed by Filter: 39
  • Heap Blocks: exact=75
53. 0.209 1.066 ↓ 0.0 0 1

BitmapAnd (cost=38.15..38.15 rows=1 width=0) (actual time=1.066..1.066 rows=0 loops=1)

54. 0.679 0.679 ↓ 75.3 6,404 1

Bitmap Index Scan on idx_ap_details_cid_property_id (cost=0.00..5.28 rows=85 width=0) (actual time=0.679..0.679 rows=6,404 loops=1)

  • Index Cond: ((cid = 15229) AND (property_id = 589263))
55. 0.178 0.178 ↓ 1.3 2,091 1

Bitmap Index Scan on idx_ap_details_gl_account_id (cost=0.00..32.61 rows=1,624 width=0) (actual time=0.178..0.178 rows=2,091 loops=1)

  • Index Cond: (gl_account_id = 265476)
56. 0.165 0.165 ↓ 0.0 0 55

Index Scan using idx_ap_headers on ap_headers ah_1 (cost=0.43..8.45 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=55)

  • Index Cond: (id = ad_1.ap_header_id)
  • Filter: ((reversal_ap_header_id IS NULL) AND (ap_payment_id IS NULL) AND (NOT is_batching) AND (NOT is_posted) AND (NOT is_template) AND (cid = 15229) AND (ap_header_type_id = 5))
  • Rows Removed by Filter: 1
57.          

CTE purchase_orders_month

58. 0.002 1,009.562 ↓ 0.0 0 1

GroupAggregate (cost=1,839.27..96,476.47 rows=1 width=40) (actual time=1,009.561..1,009.562 rows=0 loops=1)

  • Group Key: po_ad.property_id, po_ad.gl_account_id
59. 275.959 1,009.560 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,839.27..96,476.45 rows=1 width=14) (actual time=1,009.560..1,009.560 rows=0 loops=1)

  • Join Filter: ((po_ah.cid = ah_2.cid) AND (po_ah.id = ANY (ah_2.po_ap_header_ids)))
  • Rows Removed by Join Filter: 658850
  • Filter: (ah_2.id IS NULL)
  • Rows Removed by Filter: 10
60. 0.084 1.901 ↓ 10.0 10 1

Nested Loop (cost=38.58..58.64 rows=1 width=22) (actual time=1.315..1.901 rows=10 loops=1)

61. 0.171 1.347 ↓ 94.0 94 1

Bitmap Heap Scan on ap_details po_ad (cost=38.15..42.16 rows=1 width=22) (actual time=1.194..1.347 rows=94 loops=1)

  • Recheck Cond: ((cid = 15229) AND (property_id = 589263) AND (gl_account_id = 265476))
  • Heap Blocks: exact=75
62. 0.234 1.176 ↓ 0.0 0 1

BitmapAnd (cost=38.15..38.15 rows=1 width=0) (actual time=1.175..1.176 rows=0 loops=1)

63. 0.731 0.731 ↓ 75.3 6,404 1

Bitmap Index Scan on idx_ap_details_cid_property_id (cost=0.00..5.28 rows=85 width=0) (actual time=0.730..0.731 rows=6,404 loops=1)

  • Index Cond: ((cid = 15229) AND (property_id = 589263))
64. 0.211 0.211 ↓ 1.3 2,091 1

Bitmap Index Scan on idx_ap_details_gl_account_id (cost=0.00..32.61 rows=1,624 width=0) (actual time=0.210..0.211 rows=2,091 loops=1)

  • Index Cond: (gl_account_id = 265476)
65. 0.470 0.470 ↓ 0.0 0 94

Index Scan using idx_ap_headers on ap_headers po_ah (cost=0.43..8.46 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=94)

  • Index Cond: (id = po_ad.ap_header_id)
  • Filter: ((approved_by IS NOT NULL) AND (approved_on IS NOT NULL) AND (deleted_by IS NULL) AND (deleted_on IS NULL) AND (NOT is_template) AND (cid = 15229) AND (ap_header_type_id = 4) AND (post_month = '2019-10-01'::date))
  • Rows Removed by Filter: 1
66. 668.810 731.700 ↑ 1.4 65,886 10

Bitmap Heap Scan on ap_headers ah_2 (cost=1,800.70..94,066.80 rows=94,040 width=33) (actual time=8.426..73.170 rows=65,886 loops=10)

  • Recheck Cond: (cid = 15229)
  • Filter: ((reversal_ap_header_id IS NULL) AND (5 = ap_header_type_id))
  • Rows Removed by Filter: 28701
  • Heap Blocks: exact=135820
67. 62.890 62.890 ↑ 1.0 94,587 10

Bitmap Index Scan on pk_ap_headers (cost=0.00..1,777.19 rows=96,101 width=0) (actual time=6.289..6.289 rows=94,587 loops=10)

  • Index Cond: (cid = 15229)
68.          

CTE purchase_orders_year

69. 0.003 2,183.637 ↓ 0.0 0 1

GroupAggregate (cost=1,839.27..96,476.47 rows=1 width=40) (actual time=2,183.636..2,183.637 rows=0 loops=1)

  • Group Key: po_ad_1.property_id, po_ad_1.gl_account_id
70. 606.920 2,183.634 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,839.27..96,476.45 rows=1 width=14) (actual time=2,183.634..2,183.634 rows=0 loops=1)

  • Join Filter: ((po_ah_1.cid = ah_3.cid) AND (po_ah_1.id = ANY (ah_3.po_ap_header_ids)))
  • Rows Removed by Join Filter: 1449470
  • Filter: (ah_3.id IS NULL)
  • Rows Removed by Filter: 22
71. 0.206 1.844 ↓ 22.0 22 1

Nested Loop (cost=38.58..58.65 rows=1 width=22) (actual time=1.042..1.844 rows=22 loops=1)

72. 0.201 1.168 ↓ 94.0 94 1

Bitmap Heap Scan on ap_details po_ad_1 (cost=38.15..42.16 rows=1 width=22) (actual time=0.983..1.168 rows=94 loops=1)

  • Recheck Cond: ((cid = 15229) AND (property_id = 589263) AND (gl_account_id = 265476))
  • Heap Blocks: exact=75
73. 0.212 0.967 ↓ 0.0 0 1

BitmapAnd (cost=38.15..38.15 rows=1 width=0) (actual time=0.966..0.967 rows=0 loops=1)

74. 0.566 0.566 ↓ 75.3 6,404 1

Bitmap Index Scan on idx_ap_details_cid_property_id (cost=0.00..5.28 rows=85 width=0) (actual time=0.566..0.566 rows=6,404 loops=1)

  • Index Cond: ((cid = 15229) AND (property_id = 589263))
75. 0.189 0.189 ↓ 1.3 2,091 1

Bitmap Index Scan on idx_ap_details_gl_account_id (cost=0.00..32.61 rows=1,624 width=0) (actual time=0.188..0.189 rows=2,091 loops=1)

  • Index Cond: (gl_account_id = 265476)
76. 0.470 0.470 ↓ 0.0 0 94

Index Scan using idx_ap_headers on ap_headers po_ah_1 (cost=0.43..8.46 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=94)

  • Index Cond: (id = po_ad_1.ap_header_id)
  • Filter: ((approved_by IS NOT NULL) AND (approved_on IS NOT NULL) AND (deleted_by IS NULL) AND (deleted_on IS NULL) AND (NOT is_template) AND (post_month <= '2019-10-01'::date) AND (post_month >= '2019-01-01'::date) AND (cid = 15229) AND (ap_header_type_id = 4))
  • Rows Removed by Filter: 1
77. 1,439.372 1,574.870 ↑ 1.4 65,886 22

Bitmap Heap Scan on ap_headers ah_3 (cost=1,800.70..94,066.80 rows=94,040 width=33) (actual time=8.298..71.585 rows=65,886 loops=22)

  • Recheck Cond: (cid = 15229)
  • Filter: ((reversal_ap_header_id IS NULL) AND (5 = ap_header_type_id))
  • Rows Removed by Filter: 28701
  • Heap Blocks: exact=298804
78. 135.498 135.498 ↑ 1.0 94,587 22

Bitmap Index Scan on pk_ap_headers (cost=0.00..1,777.19 rows=96,101 width=0) (actual time=6.158..6.159 rows=94,587 loops=22)

  • Index Cond: (cid = 15229)
79. 0.041 3,204.972 ↓ 10.0 10 1

Nested Loop Left Join (cost=0.29..8.75 rows=1 width=212) (actual time=3,204.728..3,204.972 rows=10 loops=1)

  • Join Filter: ((ba.property_id = poy.property_id) AND (ba.gl_account_id = poy.gl_account_id))
80. 0.012 1,021.291 ↓ 10.0 10 1

Nested Loop Left Join (cost=0.29..8.63 rows=1 width=308) (actual time=1,021.075..1,021.291 rows=10 loops=1)

  • Join Filter: ((ba.property_id = pom.property_id) AND (ba.gl_account_id = pom.gl_account_id))
81. 0.013 11.709 ↓ 10.0 10 1

Nested Loop Left Join (cost=0.29..8.59 rows=1 width=276) (actual time=11.509..11.709 rows=10 loops=1)

  • Join Filter: ((ba.property_id = piy.property_id) AND (ba.gl_account_id = piy.gl_account_id))
82. 0.014 10.266 ↓ 10.0 10 1

Nested Loop Left Join (cost=0.29..8.56 rows=1 width=244) (actual time=10.082..10.266 rows=10 loops=1)

  • Join Filter: ((ba.property_id = pim.property_id) AND (ba.gl_account_id = pim.gl_account_id))
83. 0.014 8.842 ↓ 10.0 10 1

Nested Loop Left Join (cost=0.29..8.52 rows=1 width=212) (actual time=8.675..8.842 rows=10 loops=1)

  • Join Filter: ((ba.property_id = camb.property_id) AND (ba.gl_account_id = camb.gl_account_id))
84. 0.017 8.788 ↓ 10.0 10 1

Nested Loop Left Join (cost=0.29..8.49 rows=1 width=180) (actual time=8.637..8.788 rows=10 loops=1)

  • Join Filter: ((ba.property_id = cayb.property_id) AND (ba.gl_account_id = cayb.gl_account_id))
85. 0.017 3.701 ↓ 10.0 10 1

Nested Loop Left Join (cost=0.29..8.45 rows=1 width=148) (actual time=3.566..3.701 rows=10 loops=1)

  • Join Filter: ((ba.property_id = aamb.property_id) AND (ba.gl_account_id = aamb.gl_account_id))
86. 0.019 3.534 ↓ 10.0 10 1

Nested Loop Left Join (cost=0.29..8.42 rows=1 width=116) (actual time=3.427..3.534 rows=10 loops=1)

  • Join Filter: ((ba.property_id = aayb.property_id) AND (ba.gl_account_id = aayb.gl_account_id))
87. 0.020 3.185 ↓ 10.0 10 1

Nested Loop Left Join (cost=0.29..8.38 rows=1 width=84) (actual time=3.106..3.185 rows=10 loops=1)

  • Join Filter: ((ba.budget_id = yb.budget_id) AND (ba.property_id = yb.property_id) AND (ba.gl_account_id = yb.gl_account_id))
88. 0.014 1.115 ↓ 10.0 10 1

Nested Loop (cost=0.29..8.34 rows=1 width=52) (actual time=1.066..1.115 rows=10 loops=1)

89. 1.071 1.071 ↓ 10.0 10 1

CTE Scan on budget_amounts ba (cost=0.00..0.02 rows=1 width=52) (actual time=1.056..1.071 rows=10 loops=1)

  • Filter: (cid = 15229)
90. 0.030 0.030 ↑ 1.0 1 10

Index Scan using idx_gl_accounts_id on gl_accounts ga (cost=0.29..8.31 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=10)

  • Index Cond: (id = ba.gl_account_id)
  • Filter: (cid = 15229)
91. 2.050 2.050 ↑ 1.0 1 10

CTE Scan on year_budget yb (cost=0.00..0.02 rows=1 width=44) (actual time=0.204..0.205 rows=1 loops=10)

92. 0.330 0.330 ↑ 1.0 1 10

CTE Scan on accrual_actual_year_budget aayb (cost=0.00..0.02 rows=1 width=40) (actual time=0.032..0.033 rows=1 loops=10)

93. 0.150 0.150 ↑ 1.0 1 10

CTE Scan on accrual_actual_month_budget aamb (cost=0.00..0.02 rows=1 width=40) (actual time=0.014..0.015 rows=1 loops=10)

  • Filter: (accrual_actual_month_budget_amount IS NOT NULL)
94. 5.070 5.070 ↓ 0.0 0 10

CTE Scan on cash_actual_year_budget cayb (cost=0.00..0.02 rows=1 width=40) (actual time=0.507..0.507 rows=0 loops=10)

95. 0.040 0.040 ↓ 0.0 0 10

CTE Scan on cash_actual_month_budget camb (cost=0.00..0.02 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=10)

  • Filter: (cash_actual_month_budget_amount IS NOT NULL)
96. 1.410 1.410 ↓ 0.0 0 10

CTE Scan on pending_invoices_month pim (cost=0.00..0.02 rows=1 width=40) (actual time=0.141..0.141 rows=0 loops=10)

  • Filter: (pending_invoices_month_amount IS NOT NULL)
97. 1.430 1.430 ↓ 0.0 0 10

CTE Scan on pending_invoices_year piy (cost=0.00..0.02 rows=1 width=40) (actual time=0.143..0.143 rows=0 loops=10)

98. 1,009.570 1,009.570 ↓ 0.0 0 10

CTE Scan on purchase_orders_month pom (cost=0.00..0.02 rows=1 width=40) (actual time=100.957..100.957 rows=0 loops=10)

  • Filter: (purchase_orders_month_amount IS NOT NULL)
99. 2,183.640 2,183.640 ↓ 0.0 0 10

CTE Scan on purchase_orders_year poy (cost=0.00..0.02 rows=1 width=40) (actual time=218.364..218.364 rows=0 loops=10)