explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pWwh : remove_gl_account

Settings
# exclusive inclusive rows x rows loops node
1. 0.097 2,124.856 ↑ 1.0 31 1

Sort (cost=845,155.09..845,155.17 rows=31 width=72) (actual time=2,124.844..2,124.856 rows=31 loops=1)

  • Sort Key: ('ap_allocations'::text)
  • Sort Method: quicksort Memory: 27kB
2. 0.041 2,124.759 ↑ 1.0 31 1

Append (cost=43,209.42..845,154.32 rows=31 width=72) (actual time=141.542..2,124.759 rows=31 loops=1)

3. 0.000 141.542 ↑ 1.0 1 1

Finalize Aggregate (cost=43,209.42..43,209.43 rows=1 width=72) (actual time=141.541..141.542 rows=1 loops=1)

4. 4.328 141.594 ↓ 1.5 3 1

Gather (cost=43,209.21..43,209.42 rows=2 width=8) (actual time=141.460..141.594 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 0.004 137.266 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=42,209.21..42,209.22 rows=1 width=8) (actual time=137.265..137.266 rows=1 loops=3)

6. 137.262 137.262 ↓ 0.0 0 3 / 3

Parallel Seq Scan on ap_allocations aa (cost=0.00..42,206.23 rows=1,190 width=4) (actual time=137.261..137.262 rows=0 loops=3)

  • Filter: ((cid = 2,603) AND ((ap_gl_account_id = 196,869) OR (purchases_clearing_gl_account_id = 196,869) OR (pending_reimbursements_gl_account_id = 196,869) OR (inter_co_ap_gl_account_id = 196,869) OR (bank_gl_account_id = 196,869) OR (charge_gl_account_id = 196,869) OR (credit_gl_account_id = 196,869) OR (charge_wip_gl_account_id = 196,869) OR (credit_wip_gl_account_id = 196,869) OR (accrual_credit_gl_account_id = 196,869) OR (accrual_debit_gl_account_id = 196,869) OR (cash_credit_gl_account_id = 196,869) OR (cash_debit_gl_account_id = 196,869)))
  • Rows Removed by Filter: 346,173
7. 0.000 774.812 ↑ 1.0 1 1

Finalize Aggregate (cost=275,502.64..275,502.65 rows=1 width=72) (actual time=774.812..774.812 rows=1 loops=1)

8. 5.013 774.842 ↓ 1.5 3 1

Gather (cost=275,502.43..275,502.64 rows=2 width=8) (actual time=774.712..774.842 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
9. 0.004 769.829 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=274,502.43..274,502.44 rows=1 width=8) (actual time=769.828..769.829 rows=1 loops=3)

10. 769.825 769.825 ↓ 0.0 0 3 / 3

Parallel Seq Scan on ap_detail_logs adl (cost=0.00..274,484.12 rows=7,325 width=4) (actual time=769.825..769.825 rows=0 loops=3)

  • Filter: ((cid = 2,603) AND ((gl_account_id = 196,869) OR (ap_gl_account_id = 196,869) OR (wip_gl_account_id = 196,869) OR (purchases_clearing_gl_account_id = 196,869) OR (pending_reimbursements_gl_account_id = 196,869) OR (inter_co_ap_gl_account_id = 196,869) OR (bank_gl_account_id = 196,869) OR (accrual_debit_gl_account_id = 196,869) OR (accrual_credit_gl_account_id = 196,869) OR (cash_debit_gl_account_id = 196,869) OR (cash_credit_gl_account_id = 196,869)))
  • Rows Removed by Filter: 1,766,923
11. 0.000 300.715 ↑ 1.0 1 1

Finalize Aggregate (cost=113,815.69..113,815.70 rows=1 width=72) (actual time=300.714..300.715 rows=1 loops=1)

12. 4.194 300.747 ↓ 1.5 3 1

Gather (cost=113,815.48..113,815.69 rows=2 width=8) (actual time=300.615..300.747 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
13. 0.004 296.553 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=112,815.48..112,815.49 rows=1 width=8) (actual time=296.552..296.553 rows=1 loops=3)

14. 296.549 296.549 ↓ 0.0 0 3 / 3

Parallel Seq Scan on ap_details ad (cost=0.00..112,808.18 rows=2,918 width=4) (actual time=296.549..296.549 rows=0 loops=3)

  • Filter: ((cid = 2,603) AND ((gl_account_id = 196,869) OR (ap_gl_account_id = 196,869) OR (wip_gl_account_id = 196,869) OR (purchases_clearing_gl_account_id = 196,869) OR (pending_reimbursements_gl_account_id = 196,869) OR (inter_co_ap_gl_account_id = 196,869) OR (bank_gl_account_id = 196,869) OR (accrual_debit_gl_account_id = 196,869) OR (accrual_credit_gl_account_id = 196,869) OR (cash_debit_gl_account_id = 196,869) OR (cash_credit_gl_account_id = 196,869)))
  • Rows Removed by Filter: 741,977
15. 0.002 0.028 ↑ 1.0 1 1

Aggregate (cost=4.34..4.35 rows=1 width=72) (actual time=0.027..0.028 rows=1 loops=1)

16. 0.026 0.026 ↓ 0.0 0 1

Seq Scan on ap_formula_properties afp (cost=0.00..4.34 rows=1 width=4) (actual time=0.025..0.026 rows=0 loops=1)

  • Filter: ((cid = 2,603) AND (gl_account_id = 196,869))
  • Rows Removed by Filter: 156
17. 0.003 1.080 ↑ 1.0 1 1

Aggregate (cost=307.95..307.96 rows=1 width=72) (actual time=1.080..1.080 rows=1 loops=1)

18. 1.077 1.077 ↓ 0.0 0 1

Seq Scan on ap_payees ap (cost=0.00..307.94 rows=1 width=4) (actual time=1.076..1.077 rows=0 loops=1)

  • Filter: ((cid = 2,603) AND (gl_account_id = 196,869))
  • Rows Removed by Filter: 8,463
19. 0.003 0.024 ↑ 1.0 1 1

Aggregate (cost=6.06..6.07 rows=1 width=72) (actual time=0.023..0.024 rows=1 loops=1)

20. 0.021 0.021 ↓ 0.0 0 1

Index Scan using idx_ap_payee_accounts_gl_account_id on ap_payee_accounts apa (cost=0.29..6.06 rows=1 width=4) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: ((cid = 2,603) AND (default_gl_account_id = 196,869))
21. 0.003 0.010 ↑ 1.0 1 1

Aggregate (cost=8.17..8.18 rows=1 width=72) (actual time=0.009..0.010 rows=1 loops=1)

22. 0.007 0.007 ↓ 0.0 0 1

Index Scan using idx_ap_payee_sub_accounts_gl_account_id on ap_payee_sub_accounts apsa (cost=0.15..8.17 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (gl_account_id = 196,869)
  • Filter: (cid = 2,603)
23. 4.402 11.743 ↑ 1.0 1 1

Aggregate (cost=49,406.96..49,406.97 rows=1 width=72) (actual time=11.742..11.743 rows=1 loops=1)

24. 6.668 7.341 ↑ 1.9 11,047 1

Bitmap Heap Scan on ar_allocations aa_1 (cost=418.80..49,354.96 rows=20,801 width=4) (actual time=0.806..7.341 rows=11,047 loops=1)

  • Recheck Cond: ((accrual_credit_gl_account_id = 196,869) OR (accrual_debit_gl_account_id = 196,869) OR (cash_credit_gl_account_id = 196,869) OR (cash_debit_gl_account_id = 196,869))
  • Filter: (cid = 2,603)
  • Heap Blocks: exact=1,123
25. 0.002 0.673 ↓ 0.0 0 1

BitmapOr (cost=418.80..418.80 rows=20,836 width=0) (actual time=0.673..0.673 rows=0 loops=1)

26. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on idx_ar_allocations_accrual_credit_gl_account_id (cost=0.00..119.34 rows=6,254 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (accrual_credit_gl_account_id = 196,869)
27. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on idx_ar_allocations_accrual_debit_gl_account_id (cost=0.00..80.39 rows=4,261 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (accrual_debit_gl_account_id = 196,869)
28. 0.303 0.303 ↓ 1.1 5,473 1

Bitmap Index Scan on idx_ar_allocations_cash_credit_gl_account_id (cost=0.00..99.06 rows=5,151 width=0) (actual time=0.302..0.303 rows=5,473 loops=1)

  • Index Cond: (cash_credit_gl_account_id = 196,869)
29. 0.355 0.355 ↓ 1.3 6,689 1

Bitmap Index Scan on idx_ar_allocations_cash_debit_gl_account_id (cost=0.00..99.21 rows=5,170 width=0) (actual time=0.355..0.355 rows=6,689 loops=1)

  • Index Cond: (cash_debit_gl_account_id = 196,869)
30. 0.004 0.063 ↑ 1.0 1 1

Aggregate (cost=13.17..13.18 rows=1 width=72) (actual time=0.062..0.063 rows=1 loops=1)

31. 0.059 0.059 ↑ 4.0 1 1

Seq Scan on ar_codes ac (cost=0.00..13.16 rows=4 width=4) (actual time=0.024..0.059 rows=1 loops=1)

  • Filter: ((cid = 2,603) AND ((credit_gl_account_id = 196,869) OR (debit_gl_account_id = 196,869) OR (modified_debit_gl_account_id = 196,869)))
  • Rows Removed by Filter: 257
32. 0.000 82.190 ↑ 1.0 1 1

Finalize Aggregate (cost=29,634.84..29,634.85 rows=1 width=72) (actual time=82.190..82.190 rows=1 loops=1)

33. 4.848 82.222 ↓ 1.5 3 1

Gather (cost=29,634.63..29,634.84 rows=2 width=8) (actual time=82.114..82.222 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
34. 0.004 77.374 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=28,634.63..28,634.64 rows=1 width=8) (actual time=77.373..77.374 rows=1 loops=3)

35. 77.370 77.370 ↓ 0.0 0 3 / 3

Parallel Seq Scan on ar_deposit_transactions adt (cost=0.00..28,630.87 rows=1,502 width=4) (actual time=77.369..77.370 rows=0 loops=3)

  • Filter: ((cid = 2,603) AND ((credit_gl_account_id = 196,869) OR (debit_gl_account_id = 196,869)))
  • Rows Removed by Filter: 442,326
36. 0.000 589.577 ↑ 1.0 1 1

Finalize Aggregate (cost=215,617.62..215,617.63 rows=1 width=72) (actual time=589.576..589.577 rows=1 loops=1)

37. 4.135 589.609 ↓ 1.5 3 1

Gather (cost=215,617.40..215,617.61 rows=2 width=8) (actual time=589.472..589.609 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
38. 0.619 585.474 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=214,617.40..214,617.41 rows=1 width=8) (actual time=585.473..585.474 rows=1 loops=3)

39. 584.855 584.855 ↑ 7.8 1,352 3 / 3

Parallel Seq Scan on ar_transactions at (cost=0.00..214,591.02 rows=10,554 width=4) (actual time=35.102..584.855 rows=1,352 loops=3)

  • Filter: ((cid = 2,603) AND ((accrual_credit_gl_account_id = 196,869) OR (accrual_debit_gl_account_id = 196,869) OR (cash_credit_gl_account_id = 196,869) OR (cash_debit_gl_account_id = 196,869)))
  • Rows Removed by Filter: 1,934,155
40. 0.004 0.014 ↑ 1.0 1 1

Aggregate (cost=1.04..1.05 rows=1 width=72) (actual time=0.013..0.014 rows=1 loops=1)

41. 0.010 0.010 ↑ 1.0 1 1

Seq Scan on gl_settings gs (cost=0.00..1.03 rows=1 width=4) (actual time=0.009..0.010 rows=1 loops=1)

  • Filter: ((cid = 2,603) AND ((ap_gl_account_id = 196,869) OR (gain_to_lease_gl_account_id = 196,869) OR (loss_to_lease_gl_account_id = 196,869) OR (market_rent_gl_account_id = 196,869) OR (retained_earnings_gl_account_id = 196,869) OR (vacancy_loss_gl_account_id = 196,869) OR (floating_reimbursements_gl_account_id = 196,869) OR (inter_company_ar_gl_account_id = 196,869) OR (inter_company_ap_gl_account_id = 196,869)))
42. 0.002 0.020 ↑ 1.0 1 1

Aggregate (cost=3.49..3.50 rows=1 width=72) (actual time=0.020..0.020 rows=1 loops=1)

43. 0.018 0.018 ↓ 0.0 0 1

Seq Scan on fee_template_rules ftr (cost=0.00..3.48 rows=1 width=4) (actual time=0.017..0.018 rows=0 loops=1)

  • Filter: ((cid = 2,603) AND (gl_account_id = 196,869))
  • Rows Removed by Filter: 99
44. 0.002 0.023 ↑ 1.0 1 1

Aggregate (cost=1.71..1.72 rows=1 width=72) (actual time=0.023..0.023 rows=1 loops=1)

45. 0.021 0.021 ↓ 0.0 0 1

Seq Scan on fee_templates ft (cost=0.00..1.71 rows=1 width=4) (actual time=0.020..0.021 rows=0 loops=1)

  • Filter: ((cid = 2,603) AND (gl_account_id = 196,869))
  • Rows Removed by Filter: 47
46. 0.002 0.015 ↑ 1.0 1 1

Aggregate (cost=14.60..14.61 rows=1 width=72) (actual time=0.014..0.015 rows=1 loops=1)

47. 0.003 0.013 ↓ 0.0 0 1

Bitmap Heap Scan on gl_account_properties gap (cost=4.31..14.60 rows=3 width=4) (actual time=0.012..0.013 rows=0 loops=1)

  • Recheck Cond: (gl_account_id = 196,869)
  • Filter: (cid = 2,603)
48. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on idx_gl_account_properties_gl_account_id (cost=0.00..4.30 rows=3 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (gl_account_id = 196,869)
49. 1.144 3.099 ↑ 1.0 1 1

Aggregate (cost=5,603.12..5,603.13 rows=1 width=72) (actual time=3.098..3.099 rows=1 loops=1)

50. 1.798 1.955 ↓ 1.0 2,915 1

Bitmap Heap Scan on budget_gl_account_months bgam (cost=54.37..5,596.04 rows=2,832 width=4) (actual time=0.195..1.955 rows=2,915 loops=1)

  • Recheck Cond: (gl_account_id = 196,869)
  • Filter: (cid = 2,603)
  • Heap Blocks: exact=291
51. 0.157 0.157 ↓ 1.0 2,915 1

Bitmap Index Scan on idx_budget_gl_account_months_gl_account_id (cost=0.00..53.66 rows=2,832 width=0) (actual time=0.156..0.157 rows=2,915 loops=1)

  • Index Cond: (gl_account_id = 196,869)
52. 0.000 103.081 ↑ 1.0 1 1

Finalize Aggregate (cost=37,854.09..37,854.10 rows=1 width=72) (actual time=103.080..103.081 rows=1 loops=1)

53. 3.833 103.114 ↓ 1.5 3 1

Gather (cost=37,853.88..37,854.09 rows=2 width=8) (actual time=102.982..103.114 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
54. 1.006 99.281 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=36,853.88..36,853.89 rows=1 width=8) (actual time=99.280..99.281 rows=1 loops=3)

55. 98.275 98.275 ↑ 1.6 2,169 3 / 3

Parallel Seq Scan on gl_detail_logs gdl (cost=0.00..36,845.16 rows=3,486 width=4) (actual time=0.044..98.275 rows=2,169 loops=3)

  • Filter: ((cid = 2,603) AND ((accrual_gl_account_id = 196,869) OR (cash_gl_account_id = 196,869)))
  • Rows Removed by Filter: 499,233
56. 7.863 26.947 ↑ 1.0 1 1

Aggregate (cost=41,854.05..41,854.06 rows=1 width=72) (actual time=26.946..26.947 rows=1 loops=1)

57. 17.322 19.084 ↓ 1.6 19,857 1

Bitmap Heap Scan on gl_details gd (cost=254.95..41,823.77 rows=12,110 width=4) (actual time=2.527..19.084 rows=19,857 loops=1)

  • Recheck Cond: ((accrual_gl_account_id = 196,869) OR ((cid = 2,603) AND (cash_gl_account_id = 196,869)))
  • Filter: (cid = 2,603)
  • Heap Blocks: exact=5,674
58. 0.002 1.762 ↓ 0.0 0 1

BitmapOr (cost=254.95..254.95 rows=12,112 width=0) (actual time=1.762..1.762 rows=0 loops=1)

59. 1.108 1.108 ↓ 1.3 9,278 1

Bitmap Index Scan on idx_gl_details_accrual_gl_account_id (cost=0.00..128.09 rows=6,887 width=0) (actual time=1.107..1.108 rows=9,278 loops=1)

  • Index Cond: (accrual_gl_account_id = 196,869)
60. 0.652 0.652 ↓ 2.2 11,302 1

Bitmap Index Scan on idx_gl_details_cid_cash_gl_account_id (cost=0.00..120.80 rows=5,224 width=0) (actual time=0.652..0.652 rows=11,302 loops=1)

  • Index Cond: ((cid = 2,603) AND (cash_gl_account_id = 196,869))
61. 0.000 88.701 ↑ 1.0 1 1

Finalize Aggregate (cost=32,093.45..32,093.46 rows=1 width=72) (actual time=88.700..88.701 rows=1 loops=1)

62. 13.276 97.728 ↓ 1.5 3 1

Gather (cost=32,093.24..32,093.45 rows=2 width=8) (actual time=88.608..97.728 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
63. 0.253 84.452 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=31,093.24..31,093.25 rows=1 width=8) (actual time=84.451..84.452 rows=1 loops=3)

64. 84.199 84.199 ↓ 1.0 516 3 / 3

Parallel Seq Scan on accounting_export_batch_details gebd (cost=0.00..31,091.99 rows=498 width=4) (actual time=0.442..84.199 rows=516 loops=3)

  • Filter: ((cid = 2,603) AND ((accrual_gl_account_id = 196,869) OR (cash_gl_account_id = 196,869)))
  • Rows Removed by Filter: 468,513
65. 0.003 0.012 ↑ 1.0 1 1

Aggregate (cost=1.06..1.07 rows=1 width=72) (actual time=0.011..0.012 rows=1 loops=1)

66. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on maintenance_request_materials mrm (cost=0.00..1.06 rows=1 width=4) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: ((cid = 2,603) AND (gl_account_id = 196,869))
  • Rows Removed by Filter: 4
67. 0.003 0.016 ↑ 1.0 1 1

Aggregate (cost=8.04..8.05 rows=1 width=72) (actual time=0.015..0.016 rows=1 loops=1)

68. 0.013 0.013 ↓ 0.0 0 1

Index Scan using idx_fee_rules_gl_account_id on old_fee_rules fr (cost=0.28..8.04 rows=1 width=4) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (gl_account_id = 196,869)
  • Filter: (cid = 2,603)
69. 0.004 0.080 ↑ 1.0 1 1

Aggregate (cost=11.15..11.16 rows=1 width=72) (actual time=0.080..0.080 rows=1 loops=1)

70. 0.076 0.076 ↑ 1.5 2 1

Seq Scan on property_ar_codes pac (cost=0.00..11.14 rows=3 width=4) (actual time=0.035..0.076 rows=2 loops=1)

  • Filter: ((cid = 2,603) AND ((credit_gl_account_id = 196,869) OR (debit_gl_account_id = 196,869) OR (modified_debit_gl_account_id = 196,869)))
  • Rows Removed by Filter: 305
71. 0.002 0.058 ↑ 1.0 1 1

Aggregate (cost=12.20..12.21 rows=1 width=72) (actual time=0.057..0.058 rows=1 loops=1)

72. 0.056 0.056 ↓ 0.0 0 1

Seq Scan on unit_space_exclusions pet (cost=0.00..12.20 rows=1 width=4) (actual time=0.055..0.056 rows=0 loops=1)

  • Filter: ((cid = 2,603) AND (gl_account_id = 196,869))
  • Rows Removed by Filter: 413
73. 0.002 0.009 ↑ 1.0 1 1

Aggregate (cost=12.65..12.66 rows=1 width=72) (actual time=0.008..0.009 rows=1 loops=1)

74. 0.003 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on property_gl_balances pgb (cost=4.18..12.65 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: (cid = 2,603)
  • Filter: (gl_account_id = 196,869)
75. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on pk_property_gl_balances (cost=0.00..4.18 rows=4 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (cid = 2,603)
76. 0.217 0.582 ↑ 1.0 1 1

Aggregate (cost=48.03..48.04 rows=1 width=72) (actual time=0.581..0.582 rows=1 loops=1)

77. 0.365 0.365 ↑ 1.0 542 1

Seq Scan on property_gl_settings pgs (cost=0.00..46.68 rows=542 width=4) (actual time=0.009..0.365 rows=542 loops=1)

  • Filter: ((cid = 2,603) AND ((ap_gl_account_id = 196,869) OR (retained_earnings_gl_account_id = 196,869) OR (market_rent_gl_account_id = 196,869) OR (gain_to_lease_gl_account_id = 196,869) OR (loss_to_lease_gl_account_id = 196,869) OR (vacancy_loss_gl_account_id = 196,869) OR (delinquent_rent_gl_account_id = 196,869) OR (prepaid_rent_gl_account_id = 196,869) OR (inter_co_ar_gl_account_id = 196,869) OR (inter_co_ap_gl_account_id = 196,869) OR (purchases_clearing_gl_account_id = 196,869)))
78. 0.003 0.009 ↑ 1.0 1 1

Aggregate (cost=9.12..9.13 rows=1 width=72) (actual time=0.008..0.009 rows=1 loops=1)

79. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on scheduled_ap_transaction_details satd (cost=4.29..9.11 rows=2 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (gl_account_id = 196,869)
  • Filter: (cid = 2,603)
80. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on idx_scheduled_ap_transaction_details_gl_account_id (cost=0.00..4.29 rows=2 width=0) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: (gl_account_id = 196,869)
81. 0.002 0.012 ↑ 1.0 1 1

Aggregate (cost=1.35..1.36 rows=1 width=72) (actual time=0.011..0.012 rows=1 loops=1)

82. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on depreciation_categories dc (cost=0.00..1.35 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: ((cid = 2,603) AND ((depreciation_gl_account_id = 196,869) OR (accum_depreciation_gl_account_id = 196,869)))
  • Rows Removed by Filter: 20
83. 0.002 0.014 ↑ 1.0 1 1

Aggregate (cost=3.76..3.77 rows=1 width=72) (actual time=0.013..0.014 rows=1 loops=1)

84. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on ap_code_categories acc (cost=0.00..3.76 rows=1 width=4) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: ((cid = 2,603) AND ((debit_gl_account_id = 196,869) OR (credit_gl_account_id = 196,869) OR (consumption_gl_account_id = 196,869)))
  • Rows Removed by Filter: 38
85. 0.002 0.228 ↑ 1.0 1 1

Aggregate (cost=74.45..74.46 rows=1 width=72) (actual time=0.227..0.228 rows=1 loops=1)

86. 0.226 0.226 ↓ 0.0 0 1

Seq Scan on ap_codes ac_1 (cost=0.00..74.45 rows=1 width=4) (actual time=0.225..0.226 rows=0 loops=1)

  • Filter: ((ap_code_type_id <> 1) AND (cid = 2,603) AND ((item_gl_account_id = 196,869) OR (ap_gl_account_id = 196,869) OR (wip_gl_account_id = 196,869) OR (consumption_gl_account_id = 196,869)))
  • Rows Removed by Filter: 1,698
87. 0.002 0.006 ↑ 1.0 1 1

Aggregate (cost=8.17..8.18 rows=1 width=72) (actual time=0.005..0.006 rows=1 loops=1)

88. 0.004 0.004 ↓ 0.0 0 1

Index Scan using pk_asset_transactions on asset_transactions at_1 (cost=0.14..8.17 rows=1 width=4) (actual time=0.003..0.004 rows=0 loops=1)

  • Index Cond: (cid = 2,603)
  • Filter: ((debit_gl_account_id = 196,869) OR (credit_gl_account_id = 196,869))
89. 0.002 0.008 ↑ 1.0 1 1

Aggregate (cost=11.30..11.31 rows=1 width=72) (actual time=0.007..0.008 rows=1 loops=1)

90. 0.003 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on asset_allocations aa_2 (cost=4.17..11.29 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (cid = 2,603)
  • Filter: ((debit_gl_account_id = 196,869) OR (credit_gl_account_id = 196,869))
91. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on pk_asset_allocations (cost=0.00..4.17 rows=3 width=0) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (cid = 2,603)