explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sgZg

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 41.625 ↓ 3.0 3 1

Limit (cost=7,182.67..7,182.68 rows=1 width=3,694) (actual time=41.624..41.625 rows=3 loops=1)

  • Buffers: shared hit=1,970
2.          

CTE billers

3. 0.001 0.030 ↑ 2.0 1 1

Append (cost=4.16..13.04 rows=2 width=66) (actual time=0.013..0.03 rows=1 loops=1)

  • Buffers: shared hit=4
4. 0.001 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on sub_jobs s (cost=4.16..9.5 rows=1 width=72) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (s.deleted_at IS NULL)
  • Buffers: shared hit=1
5. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on index_sub_jobs_on_project_id (cost=0..4.16 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (s.project_id = '7'::bigint)
  • Buffers: shared hit=1
6. 0.025 0.025 ↑ 1.0 1 1

Seq Scan on projects p (cost=0..3.51 rows=1 width=61) (actual time=0.008..0.025 rows=1 loops=1)

  • Filter: (p.id = '7'::bigint)
  • Buffers: shared hit=3
7.          

CTE monresources

8. 0.013 0.084 ↑ 26.0 1 1

GroupAggregate (cost=113.49..114.05 rows=26 width=40) (actual time=0.084..0.084 rows=1 loops=1)

  • Group Key: fli.wbs_code_id
  • Buffers: shared hit=6
9. 0.017 0.071 ↑ 10.3 3 1

Sort (cost=113.49..113.57 rows=31 width=12) (actual time=0.071..0.071 rows=3 loops=1)

  • Sort Key: fli.wbs_code_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=6
10. 0.023 0.054 ↑ 10.3 3 1

Bitmap Heap Scan on florence_line_items fli (cost=4.56..112.72 rows=31 width=12) (actual time=0.05..0.054 rows=3 loops=1)

  • Filter: (fli.project_id = '7'::bigint)
  • Heap Blocks: exact=4
  • Buffers: shared hit=6
11. 0.031 0.031 ↑ 1.5 24 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.031..0.031 rows=24 loops=1)

  • Index Cond: (fli.type = 'monitored-resource'::text)
  • Buffers: shared hit=2
12.          

CTE budforecasts

13. 0.032 0.519 ↑ 29.0 2 1

HashAggregate (cost=141.64..142.66 rows=58 width=104) (actual time=0.515..0.519 rows=2 loops=1)

  • Group Key: fp.migrated_object_id, (fp.migrated_metadata ->> 'wbs_code_id'::text), (fp.migrated_metadata ->> 'calculation_strategy'::text)
  • Buffers: shared hit=51
14. 0.037 0.487 ↑ 15.5 4 1

Hash Join (cost=32.38..141.02 rows=62 width=76) (actual time=0.325..0.487 rows=4 loops=1)

  • Buffers: shared hit=51
15. 0.153 0.188 ↓ 1.2 45 1

Bitmap Heap Scan on florence_line_items fli_1 (cost=4.56..112.72 rows=36 width=12) (actual time=0.046..0.188 rows=45 loops=1)

  • Filter: (fli_1.amount_type = 'dollar'::text)
  • Heap Blocks: exact=30
  • Buffers: shared hit=32
16. 0.035 0.035 ↓ 2.5 90 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.035..0.035 rows=90 loops=1)

  • Index Cond: (fli_1.type = 'forecast'::text)
  • Buffers: shared hit=2
17. 0.006 0.262 ↑ 31.0 2 1

Hash (cost=27.04..27.04 rows=62 width=122) (actual time=0.262..0.262 rows=2 loops=1)

  • Buffers: shared hit=19
18. 0.256 0.256 ↑ 31.0 2 1

Seq Scan on florence_packages fp (cost=0..27.04 rows=62 width=122) (actual time=0.225..0.256 rows=2 loops=1)

  • Filter: ((fp.project_id = '7'::bigint) AND (fp.migrated_object_type = 'BudgetForecast'::text))
  • Buffers: shared hit=19
19.          

CTE budgetforecasts

20. 0.023 0.639 ↑ 29.0 2 1

Hash Join (cost=0.84..2.77 rows=58 width=137) (actual time=0.631..0.639 rows=2 loops=1)

  • Buffers: shared hit=57
21. 0.522 0.522 ↑ 29.0 2 1

CTE Scan on budforecasts bf (cost=0..1.16 rows=58 width=104) (actual time=0.517..0.522 rows=2 loops=1)

  • Buffers: shared hit=51
22. 0.008 0.094 ↑ 26.0 1 1

Hash (cost=0.52..0.52 rows=26 width=40) (actual time=0.094..0.094 rows=1 loops=1)

  • Buffers: shared hit=6
23. 0.086 0.086 ↑ 26.0 1 1

CTE Scan on monresources resources (cost=0..0.52 rows=26 width=40) (actual time=0.086..0.086 rows=1 loops=1)

  • Buffers: shared hit=6
24.          

CTE periods_cte

25. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.28..25.81 rows=1 width=44) (never executed)

26. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on budgeting_periods periods (cost=0..16.8 rows=3 width=44) (never executed)

  • Filter: (periods.deleted_at IS NULL)
27. 0.000 0.000 ↓ 0.0 0 0

Materialize (cost=0.28..8.92 rows=2 width=8) (never executed)

28. 0.000 0.000 ↓ 0.0 0 0

Index Scan using budget_line_items_project_id_idx on budget_line_items bli (cost=0.28..8.91 rows=2 width=8) (never executed)

  • Index Cond: (bli.project_id = '7'::bigint)
  • Filter: (bli.deleted_at IS NULL)
29.          

CTE budgetmodificationsfrom

30. 0.011 0.076 ↑ 1.0 1 1

GroupAggregate (cost=112.81..112.84 rows=1 width=40) (actual time=0.076..0.076 rows=1 loops=1)

  • Group Key: fli_2.wbs_code_id
  • Buffers: shared hit=5
31. 0.009 0.065 ↑ 1.0 1 1

Sort (cost=112.81..112.82 rows=1 width=12) (actual time=0.065..0.065 rows=1 loops=1)

  • Sort Key: fli_2.wbs_code_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=5
32. 0.037 0.056 ↑ 1.0 1 1

Bitmap Heap Scan on florence_line_items fli_2 (cost=4.56..112.8 rows=1 width=12) (actual time=0.031..0.056 rows=1 loops=1)

  • Filter: ((fli_2.amount < '0'::numeric) AND (fli_2.project_id = '7'::bigint))
  • Heap Blocks: exact=2
  • Buffers: shared hit=5
33. 0.019 0.019 ↓ 1.2 44 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.019..0.019 rows=44 loops=1)

  • Index Cond: (fli_2.type = 'estimate-change'::text)
  • Buffers: shared hit=3
34.          

CTE budgetmodificationsto

35. 0.030 0.090 ↑ 14.0 1 1

GroupAggregate (cost=113.1..113.39 rows=14 width=40) (actual time=0.089..0.09 rows=1 loops=1)

  • Group Key: fli_3.wbs_code_id
  • Buffers: shared hit=5
36. 0.012 0.060 ↑ 15.0 1 1

Sort (cost=113.1..113.14 rows=15 width=12) (actual time=0.06..0.06 rows=1 loops=1)

  • Sort Key: fli_3.wbs_code_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=5
37. 0.023 0.048 ↑ 15.0 1 1

Bitmap Heap Scan on florence_line_items fli_3 (cost=4.56..112.81 rows=15 width=12) (actual time=0.029..0.048 rows=1 loops=1)

  • Filter: ((fli_3.amount > '0'::numeric) AND (fli_3.project_id = '7'::bigint))
  • Heap Blocks: exact=2
  • Buffers: shared hit=5
38. 0.025 0.025 ↓ 1.2 44 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.025..0.025 rows=44 loops=1)

  • Index Cond: (fli_3.type = 'estimate-change'::text)
  • Buffers: shared hit=3
39.          

CTE budgetquantities

40. 0.011 0.089 ↓ 2.0 2 1

GroupAggregate (cost=112.81..112.84 rows=1 width=40) (actual time=0.088..0.089 rows=2 loops=1)

  • Group Key: fli_4.wbs_code_id
  • Buffers: shared hit=5
41. 0.015 0.078 ↓ 2.0 2 1

Sort (cost=112.81..112.82 rows=1 width=12) (actual time=0.078..0.078 rows=2 loops=1)

  • Sort Key: fli_4.wbs_code_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=5
42. 0.033 0.063 ↓ 2.0 2 1

Bitmap Heap Scan on florence_line_items fli_4 (cost=4.56..112.8 rows=1 width=12) (actual time=0.036..0.063 rows=2 loops=1)

  • Filter: ((fli_4.amount_type <> 'dollar'::text) AND (fli_4.project_id = '7'::bigint))
  • Heap Blocks: exact=3
  • Buffers: shared hit=5
43. 0.030 0.030 ↓ 2.4 88 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.03..0.03 rows=88 loops=1)

  • Index Cond: (fli_4.type = 'estimate'::text)
  • Buffers: shared hit=2
44.          

CTE budgetrows

45. 0.003 2.506 ↑ 2.0 3 1

Unique (cost=1,455.82..1,455.85 rows=6 width=352) (actual time=2.502..2.506 rows=3 loops=1)

  • Buffers: shared hit=327
46. 0.037 2.503 ↑ 2.0 3 1

Sort (cost=1,455.82..1,455.83 rows=6 width=352) (actual time=2.501..2.503 rows=3 loops=1)

  • Sort Key: ((bli_4.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=327
47. 0.025 2.466 ↑ 2.0 3 1

Nested Loop (cost=11.35..1,455.74 rows=6 width=352) (actual time=0.981..2.466 rows=3 loops=1)

  • Buffers: shared hit=327
48. 0.001 2.426 ↑ 2.0 3 1

Nested Loop (cost=10.94..1,418.05 rows=6 width=195) (actual time=0.954..2.426 rows=3 loops=1)

  • Buffers: shared hit=321
49. 0.012 2.413 ↑ 2.0 3 1

Nested Loop (cost=10.66..1,368.17 rows=6 width=72) (actual time=0.946..2.413 rows=3 loops=1)

  • Buffers: shared hit=315
50. 0.006 0.949 ↑ 2.0 3 1

Nested Loop (cost=0.57..1,283.47 rows=6 width=56) (actual time=0.897..0.949 rows=3 loops=1)

  • Filter: (cc.deleted_at IS NULL)
  • Buffers: shared hit=264
51. 0.105 0.931 ↑ 2.0 3 1

Index Scan using index_wbs_codes_on_project_id on wbs_codes wbs (cost=0.28..1,233.6 rows=6 width=32) (actual time=0.886..0.931 rows=3 loops=1)

  • Index Cond: (wbs.project_id = '7'::bigint)
  • Filter: ((wbs.deleted_at IS NULL) AND ((alternatives: SubPlan 9 or hashed SubPlan 10) OR (alternatives: SubPlan 11 or hashed SubPlan 12) OR (SubPlan 13) OR (alternatives: SubPlan 14 or hashed SubPlan 15) OR (alternatives: SubPlan 16 or hashed SubPlan 17) OR (alternatives: SubPlan 18 or hashed SubPlan 19)))
  • Buffers: shared hit=258
52.          

SubPlan (for Index Scan)

53. 0.078 0.078 ↓ 0.0 0 6

Index Scan using index_line_items_on_wbs_code_id on line_items li (cost=0.41..23.54 rows=1 width=0) (actual time=0.013..0.013 rows=0 loops=6)

  • Index Cond: (li.wbs_code_id = wbs.id)
  • Filter: ((li.deleted_at IS NULL) AND (li.project_id = '7'::bigint))
  • Buffers: shared hit=24
54. 0.000 0.000 ↓ 0.0 0 0

Bitmap Heap Scan on line_items li_1 (cost=80.36..1,366.59 rows=510 width=8) (never executed)

  • Filter: (li_1.deleted_at IS NULL)
55. 0.000 0.000 ↓ 0.0 0 0

Bitmap Index Scan on line_items_project_id_idx (cost=0..80.24 rows=510 width=0) (never executed)

  • Index Cond: (li_1.project_id = '7'::bigint)
56. 0.006 0.117 ↓ 0.0 0 3

Bitmap Heap Scan on florence_line_items bli_1 (cost=10.08..14.1 rows=1 width=0) (actual time=0.039..0.039 rows=0 loops=3)

  • Filter: (bli_1.project_id = '7'::bigint)
  • Buffers: shared hit=12
57. 0.003 0.111 ↓ 0.0 0 3

BitmapAnd (cost=10.08..10.08 rows=1 width=0) (actual time=0.037..0.037 rows=0 loops=3)

  • Buffers: shared hit=12
58. 0.090 0.090 ↓ 2.4 88 3

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.03..0.03 rows=88 loops=3)

  • Index Cond: (bli_1.type = 'estimate'::text)
  • Buffers: shared hit=6
59. 0.018 0.018 ↑ 132.0 1 3

Bitmap Index Scan on index_florence_line_items_on_wbs_code_id (cost=0..5.28 rows=132 width=0) (actual time=0.006..0.006 rows=1 loops=3)

  • Index Cond: (bli_1.wbs_code_id = wbs.id)
  • Buffers: shared hit=6
60. 0.000 0.000 ↓ 0.0 0 0

Bitmap Heap Scan on florence_line_items bli_2 (cost=4.56..112.72 rows=31 width=8) (never executed)

  • Filter: (bli_2.project_id = '7'::bigint)
61. 0.000 0.000 ↓ 0.0 0 0

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (never executed)

  • Index Cond: (bli_2.type = 'estimate'::text)
62. 0.026 0.108 ↓ 0.0 0 3

Nested Loop (cost=8.73..122.59 rows=1 width=0) (actual time=0.036..0.036 rows=0 loops=3)

  • Filter: (bli_3.id IS NULL)
  • Buffers: shared hit=9
63. 0.009 0.015 ↓ 0.0 0 3

Bitmap Heap Scan on budgeted_production_quantities bpq (cost=4.16..9.51 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=3)

  • Filter: ((bpq.deleted_at IS NULL) AND (bpq.project_id = '7'::bigint))
  • Heap Blocks: exact=1
  • Buffers: shared hit=4
64. 0.006 0.006 ↓ 0.0 0 3

Bitmap Index Scan on index_budgeted_production_quantities_on_wbs_code_id (cost=0..4.16 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=3)

  • Index Cond: (bpq.wbs_code_id = wbs.id)
  • Buffers: shared hit=3
65. 0.040 0.067 ↓ 2.4 88 1

Bitmap Heap Scan on florence_line_items bli_3 (cost=4.56..112.63 rows=36 width=8) (actual time=0.035..0.067 rows=88 loops=1)

  • Heap Blocks: exact=3
  • Buffers: shared hit=5
66. 0.027 0.027 ↓ 2.4 88 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.027..0.027 rows=88 loops=1)

  • Index Cond: (bli_3.type = 'estimate'::text)
  • Buffers: shared hit=2
67. 0.003 0.027 ↓ 0.0 0 3

Nested Loop (cost=0.57..38.98 rows=13 width=0) (actual time=0.009..0.009 rows=0 loops=3)

  • Buffers: shared hit=15
68. 0.015 0.015 ↑ 1.0 1 3

Index Scan using wbs_codes_pkey on wbs_codes wc (cost=0.28..8.3 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=3)

  • Index Cond: (wc.id = wbs.id)
  • Filter: (wc.project_id = '7'::bigint)
  • Buffers: shared hit=9
69. 0.009 0.009 ↓ 0.0 0 3

Index Scan using index_change_event_line_items_on_wbs_code_id on change_event_line_items celi (cost=0.29..30.55 rows=13 width=8) (actual time=0.003..0.003 rows=0 loops=3)

  • Index Cond: (celi.wbs_code_id = wbs.id)
  • Filter: (celi.deleted_at IS NULL)
  • Buffers: shared hit=6
70. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.57..183.63 rows=15 width=8) (never executed)

71. 0.000 0.000 ↓ 0.0 0 0

Index Scan using index_wbs_codes_on_project_id on wbs_codes wc_1 (cost=0.28..14.23 rows=6 width=8) (never executed)

  • Index Cond: (wc_1.project_id = '7'::bigint)
72. 0.000 0.000 ↓ 0.0 0 0

Index Scan using index_change_event_line_items_on_wbs_code_id on change_event_line_items celi_1 (cost=0.29..28.1 rows=13 width=8) (never executed)

  • Index Cond: (celi_1.wbs_code_id = wc_1.id)
  • Filter: (celi_1.deleted_at IS NULL)
73. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=7.13..24.75 rows=1 width=0) (never executed)

74. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=6.85..21.61 rows=1 width=8) (never executed)

75. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=6.71..13.43 rows=1 width=8) (never executed)

76. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=6.43..9.12 rows=1 width=16) (never executed)

77. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on markup_line_items mli (cost=0..2.5 rows=50 width=8) (never executed)

78. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=6.42..6.42 rows=1 width=24) (never executed)

79. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on markups m (cost=0..6.42 rows=1 width=24) (never executed)

  • Filter: ((m.deleted_at IS NULL) AND (m.destination_budget_line_item_id IS NULL) AND (m.wbs_code_id = wbs.id) AND ((m.holder_type)::text = 'PotentialChangeOrder'::text))
80. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using wbs_codes_pkey on wbs_codes w (cost=0.28..4.3 rows=1 width=8) (never executed)

  • Index Cond: (w.id = wbs.id)
81. 0.000 0.000 ↓ 0.0 0 0

Index Scan using potential_change_orders_pkey on potential_change_orders pco (cost=0.14..8.16 rows=1 width=16) (never executed)

  • Index Cond: (pco.id = m.holder_id)
82. 0.000 0.000 ↓ 0.0 0 0

Index Scan using contracts_pkey on contracts c (cost=0.28..3.13 rows=1 width=8) (never executed)

  • Index Cond: (c.id = pco.contract_id)
  • Filter: (((c.type)::text = 'PrimeContract'::text) AND (c.project_id = '7'::bigint))
83. 0.018 0.447 ↓ 26.0 26 1

Nested Loop (cost=6.74..24.36 rows=1 width=8) (actual time=0.2..0.447 rows=26 loops=1)

  • Buffers: shared hit=189
84. 0.022 0.351 ↓ 26.0 26 1

Nested Loop (cost=6.46..21.22 rows=1 width=16) (actual time=0.188..0.351 rows=26 loops=1)

  • Buffers: shared hit=111
85. 0.018 0.277 ↓ 26.0 26 1

Nested Loop (cost=6.32..13.04 rows=1 width=16) (actual time=0.177..0.277 rows=26 loops=1)

  • Buffers: shared hit=59
86. 0.034 0.155 ↓ 26.0 26 1

Hash Join (cost=6.04..8.73 rows=1 width=16) (actual time=0.118..0.155 rows=26 loops=1)

  • Buffers: shared hit=6
87. 0.032 0.032 ↓ 1.2 60 1

Seq Scan on markup_line_items mli_1 (cost=0..2.5 rows=50 width=8) (actual time=0.016..0.032 rows=60 loops=1)

  • Buffers: shared hit=2
88. 0.012 0.089 ↓ 3.0 6 1

Hash (cost=6.01..6.01 rows=2 width=24) (actual time=0.089..0.089 rows=6 loops=1)

  • Buffers: shared hit=4
89. 0.077 0.077 ↓ 3.0 6 1

Seq Scan on markups m_1 (cost=0..6.01 rows=2 width=24) (actual time=0.013..0.077 rows=6 loops=1)

  • Filter: ((m_1.deleted_at IS NULL) AND (m_1.destination_budget_line_item_id IS NULL) AND ((m_1.holder_type)::text = 'PotentialChangeOrder'::text))
  • Buffers: shared hit=4
90. 0.104 0.104 ↑ 1.0 1 26

Index Only Scan using wbs_codes_pkey on wbs_codes w_1 (cost=0.28..4.3 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=26)

  • Index Cond: (w_1.id = m_1.wbs_code_id)
  • Buffers: shared hit=53
91. 0.052 0.052 ↑ 1.0 1 26

Index Scan using potential_change_orders_pkey on potential_change_orders pco_1 (cost=0.14..8.16 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=26)

  • Index Cond: (pco_1.id = m_1.holder_id)
  • Buffers: shared hit=52
92. 0.078 0.078 ↑ 1.0 1 26

Index Scan using contracts_pkey on contracts c_1 (cost=0.28..3.13 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=26)

  • Index Cond: (c_1.id = pco_1.contract_id)
  • Filter: (((c_1.type)::text = 'PrimeContract'::text) AND (c_1.project_id = '7'::bigint))
  • Buffers: shared hit=78
93. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.28..14.73 rows=1 width=0) (never executed)

94. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on markups m_2 (cost=0..6.42 rows=1 width=8) (never executed)

  • Filter: ((m_2.deleted_at IS NULL) AND (m_2.destination_budget_line_item_id IS NULL) AND (m_2.wbs_code_id = wbs.id) AND ((m_2.holder_type)::text = 'ChangeEvent::Event'::text))
95. 0.000 0.000 ↓ 0.0 0 0

Index Scan using wbs_codes_pkey on wbs_codes w_2 (cost=0.28..8.3 rows=1 width=8) (never executed)

  • Index Cond: (w_2.id = wbs.id)
  • Filter: (w_2.project_id = '7'::bigint)
96. 0.000 0.049 ↓ 0.0 0 1

Nested Loop (cost=0.28..14.32 rows=1 width=8) (actual time=0.049..0.049 rows=0 loops=1)

  • Buffers: shared hit=4
97. 0.049 0.049 ↓ 0.0 0 1

Seq Scan on markups m_3 (cost=0..6.01 rows=1 width=8) (actual time=0.049..0.049 rows=0 loops=1)

  • Filter: ((m_3.deleted_at IS NULL) AND (m_3.destination_budget_line_item_id IS NULL) AND ((m_3.holder_type)::text = 'ChangeEvent::Event'::text))
  • Buffers: shared hit=4
98. 0.000 0.000 ↓ 0.0 0 0

Index Scan using wbs_codes_pkey on wbs_codes w_3 (cost=0.28..8.3 rows=1 width=8) (never executed)

  • Index Cond: (w_3.id = m_3.wbs_code_id)
  • Filter: (w_3.project_id = '7'::bigint)
99. 0.012 0.012 ↑ 1.0 1 3

Index Scan using cost_codes_pkey on cost_codes cc (cost=0.29..8.3 rows=1 width=40) (actual time=0.004..0.004 rows=1 loops=3)

  • Index Cond: (wbs.cost_code_id = cc.id)
  • Buffers: shared hit=6
100. 0.012 1.452 ↑ 1.0 1 3

Bitmap Heap Scan on florence_line_items bli_4 (cost=10.09..14.11 rows=1 width=24) (actual time=0.483..0.484 rows=1 loops=3)

  • Filter: (bli_4.amount_type = 'dollar'::text)
  • Heap Blocks: exact=2
  • Buffers: shared hit=51
101. 0.006 1.440 ↓ 0.0 0 3

BitmapAnd (cost=10.09..10.09 rows=1 width=0) (actual time=0.48..0.48 rows=0 loops=3)

  • Buffers: shared hit=49
102. 0.069 0.069 ↓ 2.4 88 3

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.023..0.023 rows=88 loops=3)

  • Index Cond: (bli_4.type = 'estimate'::text)
  • Buffers: shared hit=6
103. 1.365 1.365 ↓ 25.7 3,397 3

Bitmap Index Scan on index_florence_line_items_on_wbs_code_id (cost=0..5.28 rows=132 width=0) (actual time=0.455..0.455 rows=3,397 loops=3)

  • Index Cond: (wbs.id = bli_4.wbs_code_id)
  • Buffers: shared hit=43
104. 0.012 0.012 ↑ 1.0 1 3

Index Scan using index_wbs_cost_code_paths_on_cost_code_id on wbs_cost_code_paths ccp (cost=0.29..8.3 rows=1 width=131) (actual time=0.004..0.004 rows=1 loops=3)

  • Index Cond: (ccp.cost_code_id = wbs.cost_code_id)
  • Buffers: shared hit=6
105. 0.015 0.015 ↓ 0.0 0 3

Index Scan using index_external_data_on_item_id_and_item_type on external_data cost_code_external_data (cost=0.41..6.27 rows=1 width=40) (actual time=0.005..0.005 rows=0 loops=3)

  • Index Cond: ((cost_code_external_data.item_id = wbs.cost_code_id) AND ((cost_code_external_data.item_type)::text = 'CostCode'::text))
  • Buffers: shared hit=6
106.          

CTE rawdatacolumns

107. 0.616 40.516 ↓ 3.0 3 1

Nested Loop (cost=4,796.15..5,088.15 rows=1 width=2,964) (actual time=38.655..40.516 rows=3 loops=1)

  • Buffers: shared hit=1,967
108. 0.004 38.199 ↓ 3.0 3 1

Nested Loop (cost=4,782.56..5,044.66 rows=1 width=3,130) (actual time=36.974..38.199 rows=3 loops=1)

  • Buffers: shared hit=1,927
109. 0.023 38.030 ↓ 3.0 3 1

Nested Loop (cost=4,760.67..5,022.72 rows=1 width=3,098) (actual time=36.81..38.03 rows=3 loops=1)

  • Buffers: shared hit=1,882
110. 0.011 20.250 ↓ 3.0 3 1

Merge Join (cost=4,102..4,360.45 rows=1 width=3,066) (actual time=19.073..20.25 rows=3 loops=1)

  • Buffers: shared hit=1,495
111. 0.035 20.107 ↓ 3.0 3 1

Nested Loop (cost=3,988.08..4,245.27 rows=1 width=3,034) (actual time=18.934..20.107 rows=3 loops=1)

  • Buffers: shared hit=1,490
112. 0.028 18.827 ↓ 3.0 3 1

Nested Loop (cost=3,570..3,823.59 rows=1 width=3,002) (actual time=17.745..18.827 rows=3 loops=1)

  • Buffers: shared hit=1,446
113. 0.043 16.669 ↓ 3.0 3 1

Nested Loop (cost=3,116.3..3,366.29 rows=1 width=2,970) (actual time=15.678..16.669 rows=3 loops=1)

  • Buffers: shared hit=1,393
114. 0.014 15.357 ↓ 3.0 3 1

Merge Join (cost=2,698.22..2,944.61 rows=1 width=2,938) (actual time=14.459..15.357 rows=3 loops=1)

  • Buffers: shared hit=1,349
115. 0.009 15.217 ↓ 3.0 3 1

Nested Loop (cost=2,173.68..2,419.02 rows=1 width=2,906) (actual time=14.329..15.217 rows=3 loops=1)

  • Buffers: shared hit=1,336
116. 0.006 15.091 ↓ 3.0 3 1

Nested Loop (cost=2,151.79..2,397.07 rows=1 width=2,842) (actual time=14.216..15.091 rows=3 loops=1)

  • Buffers: shared hit=1,327
117. 0.010 14.947 ↓ 3.0 3 1

Nested Loop (cost=2,129.9..2,375.13 rows=1 width=2,778) (actual time=14.085..14.947 rows=3 loops=1)

  • Buffers: shared hit=1,318
118. 0.029 14.760 ↓ 3.0 3 1

Nested Loop (cost=1,938.82..2,182.05 rows=1 width=2,746) (actual time=13.906..14.76 rows=3 loops=1)

  • Buffers: shared hit=1,311
119. 0.009 12.403 ↓ 3.0 3 1

Nested Loop (cost=1,485.12..1,724.75 rows=1 width=2,714) (actual time=11.64..12.403 rows=3 loops=1)

  • Buffers: shared hit=1,258
120. 0.004 12.361 ↓ 3.0 3 1

Nested Loop (cost=1,484.84..1,716.44 rows=1 width=2,712) (actual time=11.624..12.361 rows=3 loops=1)

  • Buffers: shared hit=1,249
121. 0.008 12.255 ↓ 3.0 3 1

Nested Loop (cost=1,454.39..1,685.93 rows=1 width=2,648) (actual time=11.533..12.255 rows=3 loops=1)

  • Buffers: shared hit=1,240
122. 0.012 12.178 ↓ 3.0 3 1

Nested Loop (cost=1,440.82..1,672.3 rows=1 width=2,616) (actual time=11.462..12.178 rows=3 loops=1)

  • Buffers: shared hit=1,235
123. 0.005 10.771 ↓ 3.0 3 1

Nested Loop (cost=1,427.24..1,658.68 rows=1 width=2,584) (actual time=10.075..10.771 rows=3 loops=1)

  • Buffers: shared hit=1,196
124. 0.018 10.682 ↓ 3.0 3 1

Nested Loop (cost=1,413.66..1,645.05 rows=1 width=2,552) (actual time=9.991..10.682 rows=3 loops=1)

  • Buffers: shared hit=1,191
125. 0.016 10.352 ↓ 3.0 3 1

Nested Loop (cost=1,400.06..1,631.4 rows=1 width=2,520) (actual time=9.713..10.352 rows=3 loops=1)

  • Buffers: shared hit=1,183
126. 0.025 10.288 ↓ 3.0 3 1

Nested Loop (cost=1,395.5..1,517.96 rows=1 width=2,516) (actual time=9.688..10.288 rows=3 loops=1)

  • Buffers: shared hit=1,174
127. 0.003 10.212 ↓ 3.0 3 1

Nested Loop (cost=1,390.93..1,404.52 rows=1 width=2,512) (actual time=9.661..10.212 rows=3 loops=1)

  • Buffers: shared hit=1,165
128. 0.004 10.182 ↓ 3.0 3 1

Nested Loop (cost=1,369.05..1,382.58 rows=1 width=2,480) (actual time=9.634..10.182 rows=3 loops=1)

  • Buffers: shared hit=1,163
129. 0.002 10.052 ↓ 3.0 3 1

Nested Loop (cost=1,324.69..1,338.17 rows=1 width=2,448) (actual time=9.509..10.052 rows=3 loops=1)

  • Buffers: shared hit=1,148
130. 0.006 10.029 ↓ 3.0 3 1

Nested Loop (cost=1,292.47..1,305.9 rows=1 width=2,416) (actual time=9.49..10.029 rows=3 loops=1)

  • Buffers: shared hit=1,146
131. 0.044 10.002 ↓ 3.0 3 1

Nested Loop (cost=1,259.85..1,273.23 rows=1 width=2,384) (actual time=9.467..10.002 rows=3 loops=1)

  • Buffers: shared hit=1,143
132. 0.009 8.845 ↓ 3.0 3 1

Nested Loop (cost=1,180.4..1,193.73 rows=1 width=2,352) (actual time=8.498..8.845 rows=3 loops=1)

  • Buffers: shared hit=1,108
133. 0.016 8.554 ↓ 3.0 3 1

Nested Loop (cost=1,153.79..1,167.07 rows=1 width=2,320) (actual time=8.24..8.554 rows=3 loops=1)

  • Buffers: shared hit=994
134. 0.014 8.304 ↓ 3.0 3 1

Nested Loop (cost=1,127.19..1,140.42 rows=1 width=2,288) (actual time=8.022..8.304 rows=3 loops=1)

  • Buffers: shared hit=932
135. 0.018 6.751 ↓ 3.0 3 1

Nested Loop (cost=1,087.52..1,100.71 rows=1 width=2,256) (actual time=6.574..6.751 rows=3 loops=1)

  • Buffers: shared hit=758
136. 0.002 6.406 ↓ 3.0 3 1

Merge Join (cost=1,054.91..1,068.04 rows=1 width=2,224) (actual time=6.273..6.406 rows=3 loops=1)

  • Buffers: shared hit=736
137. 0.009 6.376 ↓ 3.0 3 1

Nested Loop (cost=908.93..920.84 rows=1 width=2,192) (actual time=6.244..6.376 rows=3 loops=1)

  • Buffers: shared hit=734
138. 0.009 5.092 ↓ 3.0 3 1

Nested Loop (cost=463.92..472.26 rows=1 width=2,160) (actual time=4.972..5.092 rows=3 loops=1)

  • Buffers: shared hit=688
139. 0.010 4.831 ↓ 3.0 3 1

Nested Loop (cost=442.03..450.33 rows=1 width=2,128) (actual time=4.729..4.831 rows=3 loops=1)

  • Buffers: shared hit=576
140. 0.008 4.626 ↓ 3.0 3 1

Nested Loop (cost=420.15..428.39 rows=1 width=2,096) (actual time=4.538..4.626 rows=3 loops=1)

  • Buffers: shared hit=516
141. 0.007 4.558 ↓ 3.0 3 1

Nested Loop (cost=419.87..420.08 rows=1 width=2,086) (actual time=4.502..4.558 rows=3 loops=1)

  • Buffers: shared hit=507
142. 0.008 4.524 ↓ 3.0 3 1

Nested Loop (cost=389.69..389.85 rows=1 width=2,030) (actual time=4.472..4.524 rows=3 loops=1)

  • Buffers: shared hit=503
143. 0.007 4.420 ↓ 3.0 3 1

Nested Loop (cost=359.52..359.63 rows=1 width=1,966) (actual time=4.382..4.42 rows=3 loops=1)

  • Buffers: shared hit=492
144. 0.026 4.281 ↓ 3.0 3 1

Merge Join (cost=337.64..337.7 rows=1 width=1,902) (actual time=4.274..4.281 rows=3 loops=1)

  • Buffers: shared hit=484
145. 0.018 3.936 ↓ 3.0 3 1

Sort (cost=303.22..303.23 rows=1 width=1,870) (actual time=3.935..3.936 rows=3 loops=1)

  • Sort Key: br.budget_row_id
  • Sort Method: quicksort Memory: 26kB
  • Buffers: shared hit=462
146. 0.005 3.918 ↓ 3.0 3 1

Merge Join (cost=299.87..303.21 rows=1 width=1,870) (actual time=3.901..3.918 rows=3 loops=1)

  • Buffers: shared hit=462
147. 0.002 3.827 ↓ 3.0 3 1

Nested Loop (cost=169.63..171.52 rows=1 width=1,806) (actual time=3.812..3.827 rows=3 loops=1)

  • Buffers: shared hit=454
148. 0.006 3.729 ↓ 3.0 3 1

Nested Loop (cost=169.63..171.49 rows=1 width=1,782) (actual time=3.718..3.729 rows=3 loops=1)

  • Buffers: shared hit=449
149. 0.002 3.633 ↓ 3.0 3 1

Nested Loop (cost=169.63..171.03 rows=1 width=1,750) (actual time=3.624..3.633 rows=3 loops=1)

  • Buffers: shared hit=444
150. 0.009 3.550 ↓ 3.0 3 1

Merge Join (cost=169.63..171 rows=1 width=1,718) (actual time=3.544..3.55 rows=3 loops=1)

  • Buffers: shared hit=439
151. 0.018 3.433 ↓ 3.0 3 1

Sort (cost=39.39..39.4 rows=1 width=1,682) (actual time=3.432..3.433 rows=3 loops=1)

  • Sort Key: br.actual_cost_code_id
  • Sort Method: quicksort Memory: 26kB
  • Buffers: shared hit=428
152. 0.029 3.415 ↓ 3.0 3 1

Hash Join (cost=37.85..39.38 rows=1 width=1,682) (actual time=3.398..3.415 rows=3 loops=1)

  • Buffers: shared hit=428
153. 0.642 0.642 ↑ 29.0 2 1

CTE Scan on budgetforecasts bf_1 (cost=0..1.16 rows=58 width=137) (actual time=0.633..0.642 rows=2 loops=1)

  • Buffers: shared hit=57
154. 0.017 2.744 ↓ 3.0 3 1

Hash (cost=37.84..37.84 rows=1 width=1,577) (actual time=2.744..2.744 rows=3 loops=1)

  • Buffers: shared hit=371
155. 0.008 2.727 ↓ 3.0 3 1

Nested Loop (cost=0.98..37.84 rows=1 width=1,577) (actual time=2.613..2.727 rows=3 loops=1)

  • Buffers: shared hit=371
156. 0.007 2.689 ↓ 3.0 3 1

Nested Loop (cost=0.98..37.77 rows=1 width=1,545) (actual time=2.596..2.689 rows=3 loops=1)

  • Buffers: shared hit=367
157. 0.004 2.664 ↓ 3.0 3 1

Nested Loop (cost=0.98..36.75 rows=1 width=1,029) (actual time=2.582..2.664 rows=3 loops=1)

  • Buffers: shared hit=364
158. 0.005 2.651 ↓ 3.0 3 1

Nested Loop (cost=0.69..28.43 rows=1 width=995) (actual time=2.577..2.651 rows=3 loops=1)

  • Buffers: shared hit=356
159. 0.008 2.637 ↓ 3.0 3 1

Nested Loop (cost=0.41..20.12 rows=1 width=961) (actual time=2.571..2.637 rows=3 loops=1)

  • Filter: (bli_5.deleted_at IS NULL)
  • Buffers: shared hit=348
160. 0.008 2.602 ↓ 3.0 3 1

Nested Loop (cost=0.12..11.81 rows=1 width=906) (actual time=2.546..2.602 rows=3 loops=1)

  • Buffers: shared hit=342
161. 0.014 2.567 ↓ 3.0 3 1

Nested Loop (cost=0..3.66 rows=1 width=390) (actual time=2.524..2.567 rows=3 loops=1)

  • Buffers: shared hit=336
162. 2.511 2.511 ↓ 3.0 3 1

CTE Scan on budgetrows br (cost=0..0.14 rows=1 width=352) (actual time=2.505..2.511 rows=3 loops=1)

  • Filter: (br.project_id = '7'::bigint)
  • Buffers: shared hit=327
163. 0.042 0.042 ↑ 1.0 1 3

Seq Scan on projects p_1 (cost=0..3.51 rows=1 width=38) (actual time=0.007..0.014 rows=1 loops=3)

  • Filter: (p_1.id = '7'::bigint)
  • Buffers: shared hit=9
164. 0.027 0.027 ↓ 7.0 7 3

Index Scan using companies_pkey on companies co (cost=0.12..8.14 rows=1 width=524) (actual time=0.006..0.009 rows=7 loops=3)

  • Buffers: shared hit=6
165. 0.027 0.027 ↑ 1.0 1 3

Index Scan using budget_line_items_pkey1 on budget_line_items bli_5 (cost=0.28..8.3 rows=1 width=71) (actual time=0.009..0.009 rows=1 loops=3)

  • Index Cond: (br.budget_line_item_id = bli_5.id)
  • Buffers: shared hit=6
166. 0.009 0.009 ↑ 1.0 1 3

Index Scan using cost_codes_pkey on cost_codes cc_1 (cost=0.29..8.3 rows=1 width=34) (actual time=0.003..0.003 rows=1 loops=3)

  • Index Cond: (br.cost_code_id = cc_1.id)
  • Buffers: shared hit=8
167. 0.009 0.009 ↑ 1.0 1 3

Index Scan using cost_codes_pkey on cost_codes division (cost=0.29..8.3 rows=1 width=34) (actual time=0.002..0.003 rows=1 loops=3)

  • Index Cond: (br.root_cost_code_id = division.id)
  • Buffers: shared hit=8
168. 0.018 0.018 ↑ 1.0 1 3

Seq Scan on line_item_types lit (cost=0..1.01 rows=1 width=524) (actual time=0.005..0.006 rows=1 loops=3)

  • Buffers: shared hit=3
169. 0.030 0.030 ↑ 2.0 1 3

CTE Scan on billers b (cost=0..0.04 rows=2 width=72) (actual time=0.005..0.01 rows=1 loops=3)

  • Buffers: shared hit=4
170. 0.004 0.108 ↑ 36.0 1 1

Materialize (cost=130.24..131.5 rows=36 width=44) (actual time=0.108..0.108 rows=1 loops=1)

  • Buffers: shared hit=11
171. 0.025 0.104 ↑ 36.0 1 1

GroupAggregate (cost=130.24..131.05 rows=36 width=44) (actual time=0.104..0.104 rows=1 loops=1)

  • Group Key: wbs_1.cost_code_id, fli_7.amount
  • Buffers: shared hit=11
172. 0.031 0.079 ↑ 36.0 1 1

Sort (cost=130.24..130.33 rows=36 width=18) (actual time=0.079..0.079 rows=1 loops=1)

  • Sort Key: wbs_1.cost_code_id, fli_7.amount
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=11
173. 0.007 0.048 ↑ 36.0 1 1

Merge Join (cost=113.94..129.31 rows=36 width=18) (actual time=0.045..0.048 rows=1 loops=1)

  • Buffers: shared hit=8
174. 0.008 0.008 ↑ 1,021.8 6 1

Index Scan using wbs_codes_pkey on wbs_codes wbs_1 (cost=0.28..1,475.93 rows=6,131 width=16) (actual time=0.004..0.008 rows=6 loops=1)

  • Buffers: shared hit=5
175. 0.012 0.033 ↑ 36.0 1 1

Sort (cost=113.65..113.74 rows=36 width=18) (actual time=0.033..0.033 rows=1 loops=1)

  • Sort Key: fli_7.wbs_code_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3
176. 0.005 0.021 ↑ 36.0 1 1

Bitmap Heap Scan on florence_line_items fli_7 (cost=4.56..112.72 rows=36 width=18) (actual time=0.021..0.021 rows=1 loops=1)

  • Filter: (fli_7.company_id = 7)
  • Heap Blocks: exact=1
  • Buffers: shared hit=3
177. 0.016 0.016 ↑ 36.0 1 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: (fli_7.type = 'estimate-production'::text)
  • Buffers: shared hit=2
178. 0.081 0.081 ↑ 1.0 1 3

CTE Scan on budgetmodificationsfrom mods_from (cost=0..0.02 rows=1 width=40) (actual time=0.026..0.027 rows=1 loops=3)

  • Buffers: shared hit=5
179. 0.090 0.090 ↑ 14.0 1 3

CTE Scan on budgetmodificationsto mods_to (cost=0..0.28 rows=14 width=40) (actual time=0.03..0.03 rows=1 loops=3)

  • Buffers: shared hit=5
180. 0.096 0.096 ↓ 2.0 2 3

CTE Scan on budgetquantities budget_quantity (cost=0..0.02 rows=1 width=40) (actual time=0.03..0.032 rows=2 loops=3)

  • Buffers: shared hit=5
181. 0.006 0.086 ↑ 36.0 1 1

Materialize (cost=130.24..131.59 rows=36 width=72) (actual time=0.086..0.086 rows=1 loops=1)

  • Buffers: shared hit=8
182. 0.019 0.080 ↑ 36.0 1 1

GroupAggregate (cost=130.24..131.14 rows=36 width=72) (actual time=0.08..0.08 rows=1 loops=1)

  • Group Key: wbs_2.cost_code_id
  • Buffers: shared hit=8
183. 0.010 0.061 ↑ 36.0 1 1

Sort (cost=130.24..130.33 rows=36 width=18) (actual time=0.061..0.061 rows=1 loops=1)

  • Sort Key: wbs_2.cost_code_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=8
184. 0.005 0.051 ↑ 36.0 1 1

Merge Join (cost=113.94..129.31 rows=36 width=18) (actual time=0.049..0.051 rows=1 loops=1)

  • Buffers: shared hit=8
185. 0.008 0.008 ↑ 1,021.8 6 1

Index Scan using wbs_codes_pkey on wbs_codes wbs_2 (cost=0.28..1,475.93 rows=6,131 width=16) (actual time=0.005..0.008 rows=6 loops=1)

  • Buffers: shared hit=5
186. 0.010 0.038 ↑ 36.0 1 1

Sort (cost=113.65..113.74 rows=36 width=18) (actual time=0.038..0.038 rows=1 loops=1)

  • Sort Key: fli_8.wbs_code_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3
187. 0.002 0.028 ↑ 36.0 1 1

Bitmap Heap Scan on florence_line_items fli_8 (cost=4.56..112.72 rows=36 width=18) (actual time=0.028..0.028 rows=1 loops=1)

  • Filter: (fli_8.company_id = 7)
  • Heap Blocks: exact=1
  • Buffers: shared hit=3
188. 0.026 0.026 ↑ 36.0 1 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: (fli_8.type = 'spend-actual-production'::text)
  • Buffers: shared hit=2
189. 0.010 0.319 ↓ 19.0 19 1

Materialize (cost=34.41..34.45 rows=1 width=64) (actual time=0.29..0.319 rows=19 loops=1)

  • Buffers: shared hit=22
190. 0.029 0.309 ↓ 19.0 19 1

GroupAggregate (cost=34.41..34.44 rows=1 width=64) (actual time=0.287..0.309 rows=19 loops=1)

  • Group Key: ((fli_9.wbs_code_id)::text)
  • Buffers: shared hit=22
191. 0.081 0.280 ↓ 21.0 21 1

Sort (cost=34.41..34.42 rows=1 width=36) (actual time=0.275..0.28 rows=21 loops=1)

  • Sort Key: ((fli_9.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=22
192. 0.025 0.199 ↓ 21.0 21 1

Nested Loop (cost=17.94..34.4 rows=1 width=36) (actual time=0.09..0.199 rows=21 loops=1)

  • Buffers: shared hit=22
193. 0.016 0.036 ↓ 3.0 3 1

Bitmap Heap Scan on florence_packages holder (cost=4.31..16.74 rows=1 width=8) (actual time=0.03..0.036 rows=3 loops=1)

  • Filter: ((holder.type = 'Invoice'::text) AND (holder.status = ANY ('{revise_and_resubmit,pending,approved}'::text[])) AND ((holder.migrated_metadata ->> 'direct_cost_type'::text) = ANY ('{invoice,expense}'::text[])))
  • Heap Blocks: exact=1
  • Buffers: shared hit=3
194. 0.020 0.020 ↑ 1.0 5 1

Bitmap Index Scan on index_florence_packages_on_migrated_object_type (cost=0..4.31 rows=5 width=0) (actual time=0.02..0.02 rows=5 loops=1)

  • Index Cond: (holder.migrated_object_type = 'DirectCost::Item'::text)
  • Buffers: shared hit=2
195. 0.042 0.138 ↓ 7.0 7 3

Bitmap Heap Scan on florence_line_items fli_9 (cost=13.63..17.65 rows=1 width=20) (actual time=0.041..0.046 rows=7 loops=3)

  • Filter: ((fli_9.amount_type = 'dollar'::text) AND (fli_9.company_id = 7))
  • Heap Blocks: exact=3
  • Buffers: shared hit=19
196. 0.006 0.096 ↓ 0.0 0 3

BitmapAnd (cost=13.63..13.63 rows=1 width=0) (actual time=0.032..0.032 rows=0 loops=3)

  • Buffers: shared hit=16
197. 0.072 0.072 ↓ 1.8 64 3

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.024..0.024 rows=64 loops=3)

  • Index Cond: (fli_9.type = 'spend-actual'::text)
  • Buffers: shared hit=9
198. 0.018 0.018 ↑ 5.1 14 3

Bitmap Index Scan on index_florence_line_items_on_florence_package_id (cost=0..8.82 rows=71 width=0) (actual time=0.006..0.006 rows=14 loops=3)

  • Index Cond: (fli_9.florence_package_id = holder.id)
  • Buffers: shared hit=7
199. 0.045 0.132 ↑ 1.0 1 3

GroupAggregate (cost=21.88..21.91 rows=1 width=72) (actual time=0.044..0.044 rows=1 loops=3)

  • Group Key: wbs_3.cost_code_id
  • Buffers: shared hit=8
200. 0.011 0.087 ↑ 1.0 1 3

Sort (cost=21.88..21.88 rows=1 width=18) (actual time=0.029..0.029 rows=1 loops=3)

  • Sort Key: wbs_3.cost_code_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=8
201. 0.002 0.076 ↑ 1.0 1 1

Nested Loop (cost=9.82..21.87 rows=1 width=18) (actual time=0.075..0.076 rows=1 loops=1)

  • Buffers: shared hit=8
202. 0.008 0.071 ↑ 1.0 1 1

Bitmap Heap Scan on florence_line_items fli_10 (cost=9.53..13.56 rows=1 width=18) (actual time=0.07..0.071 rows=1 loops=1)

  • Filter: ((fli_10.company_id = 7) AND ((fli_10.migrated_metadata ->> 'event_status'::text) = ANY ('{pending,closed,open}'::text[])))
  • Heap Blocks: exact=1
  • Buffers: shared hit=5
203. 0.000 0.063 ↓ 0.0 0 1

BitmapAnd (cost=9.53..9.53 rows=1 width=0) (actual time=0.063..0.063 rows=0 loops=1)

  • Buffers: shared hit=4
204. 0.022 0.022 ↑ 36.0 1 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: (fli_10.type = 'revenue-change-production'::text)
  • Buffers: shared hit=2
205. 0.041 0.041 ↓ 2.2 128 1

Bitmap Index Scan on florence_line_items_event_scope_index (cost=0..4.73 rows=59 width=0) (actual time=0.041..0.041 rows=128 loops=1)

  • Index Cond: ((fli_10.migrated_metadata ->> 'event_scope'::text) = 'tbd'::text)
  • Buffers: shared hit=2
206. 0.003 0.003 ↑ 1.0 1 1

Index Scan using wbs_codes_pkey on wbs_codes wbs_3 (cost=0.28..8.3 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: (wbs_3.id = fli_10.wbs_code_id)
  • Buffers: shared hit=3
207. 0.024 0.096 ↑ 1.0 1 3

GroupAggregate (cost=30.18..30.21 rows=1 width=72) (actual time=0.032..0.032 rows=1 loops=3)

  • Group Key: wbs_4.cost_code_id
  • Buffers: shared hit=11
208. 0.009 0.072 ↑ 1.0 1 3

Sort (cost=30.18..30.18 rows=1 width=18) (actual time=0.023..0.024 rows=1 loops=3)

  • Sort Key: wbs_4.cost_code_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=11
209. 0.002 0.063 ↑ 1.0 1 1

Nested Loop (cost=10.09..30.17 rows=1 width=18) (actual time=0.062..0.063 rows=1 loops=1)

  • Buffers: shared hit=11
210. 0.002 0.058 ↑ 1.0 1 1

Nested Loop (cost=9.81..21.86 rows=1 width=18) (actual time=0.057..0.058 rows=1 loops=1)

  • Buffers: shared hit=8
211. 0.003 0.050 ↑ 1.0 1 1

Bitmap Heap Scan on florence_line_items fli_11 (cost=9.53..13.55 rows=1 width=26) (actual time=0.05..0.05 rows=1 loops=1)

  • Filter: (fli_11.company_id = 7)
  • Heap Blocks: exact=1
  • Buffers: shared hit=5
212. 0.002 0.047 ↓ 0.0 0 1

BitmapAnd (cost=9.53..9.53 rows=1 width=0) (actual time=0.047..0.047 rows=0 loops=1)

  • Buffers: shared hit=4
213. 0.016 0.016 ↑ 36.0 1 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: (fli_11.type = 'revenue-change-order-production'::text)
  • Buffers: shared hit=2
214. 0.029 0.029 ↓ 2.2 128 1

Bitmap Index Scan on florence_line_items_event_scope_index (cost=0..4.73 rows=59 width=0) (actual time=0.029..0.029 rows=128 loops=1)

  • Index Cond: ((fli_11.migrated_metadata ->> 'event_scope'::text) = 'tbd'::text)
  • Buffers: shared hit=2
215. 0.006 0.006 ↑ 1.0 1 1

Index Scan using florence_packages_pkey on florence_packages holder_1 (cost=0.28..8.29 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (holder_1.id = fli_11.florence_package_id)
  • Filter: (holder_1.status = 'approved'::text)
  • Buffers: shared hit=3
216. 0.003 0.003 ↑ 1.0 1 1

Index Scan using wbs_codes_pkey on wbs_codes wbs_4 (cost=0.28..8.3 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: (wbs_4.id = fli_11.wbs_code_id)
  • Buffers: shared hit=3
217. 0.000 0.027 ↓ 0.0 0 3

GroupAggregate (cost=30.18..30.21 rows=1 width=72) (actual time=0.009..0.009 rows=0 loops=3)

  • Group Key: wbs_5.cost_code_id
  • Buffers: shared hit=4
218. 0.002 0.027 ↓ 0.0 0 3

Sort (cost=30.18..30.18 rows=1 width=18) (actual time=0.009..0.009 rows=0 loops=3)

  • Sort Key: wbs_5.cost_code_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=4
219. 0.000 0.025 ↓ 0.0 0 1

Nested Loop (cost=10.09..30.17 rows=1 width=18) (actual time=0.025..0.025 rows=0 loops=1)

  • Buffers: shared hit=4
220. 0.000 0.025 ↓ 0.0 0 1

Nested Loop (cost=9.81..21.86 rows=1 width=18) (actual time=0.025..0.025 rows=0 loops=1)

  • Buffers: shared hit=4
221. 0.000 0.025 ↓ 0.0 0 1

Bitmap Heap Scan on florence_line_items fli_12 (cost=9.53..13.55 rows=1 width=26) (actual time=0.025..0.025 rows=0 loops=1)

  • Filter: (fli_12.company_id = 7)
  • Buffers: shared hit=4
222. 0.002 0.025 ↓ 0.0 0 1

BitmapAnd (cost=9.53..9.53 rows=1 width=0) (actual time=0.025..0.025 rows=0 loops=1)

  • Buffers: shared hit=4
223. 0.015 0.015 ↑ 36.0 1 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: (fli_12.type = 'revenue-change-order-production'::text)
  • Buffers: shared hit=2
224. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on florence_line_items_event_scope_index (cost=0..4.73 rows=59 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fli_12.migrated_metadata ->> 'event_scope'::text) = 'out_of_scope'::text)
  • Buffers: shared hit=2
225. 0.000 0.000 ↓ 0.0 0 0

Index Scan using florence_packages_pkey on florence_packages holder_2 (cost=0.28..8.29 rows=1 width=8) (never executed)

  • Index Cond: (holder_2.id = fli_12.florence_package_id)
  • Filter: (holder_2.status = 'approved'::text)
226. 0.000 0.000 ↓ 0.0 0 0

Index Scan using wbs_codes_pkey on wbs_codes wbs_5 (cost=0.28..8.3 rows=1 width=16) (never executed)

  • Index Cond: (wbs_5.id = fli_12.wbs_code_id)
227. 0.060 0.060 ↑ 1.0 1 3

Index Scan using idx_tabs_on_provider_and_engine_name on tools column_55_direct_cost_tool (cost=0.28..8.3 rows=1 width=18) (actual time=0.018..0.02 rows=1 loops=3)

  • Index Cond: (((column_55_direct_cost_tool.provider_type)::text = 'Project'::text) AND (column_55_direct_cost_tool.provider_id = '7'::bigint) AND ((column_55_direct_cost_tool.engine_name)::text = 'direct_costs'::text))
  • Buffers: shared hit=9
228. 0.018 0.195 ↓ 4.0 4 3

GroupAggregate (cost=21.88..21.91 rows=1 width=64) (actual time=0.062..0.065 rows=4 loops=3)

  • Group Key: ((fli_13.wbs_code_id)::text)
  • Buffers: shared hit=60
229. 0.024 0.177 ↓ 4.0 4 3

Sort (cost=21.88..21.89 rows=1 width=36) (actual time=0.058..0.059 rows=4 loops=3)

  • Sort Key: ((fli_13.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=60
230. 0.009 0.153 ↓ 4.0 4 1

Nested Loop (cost=9.81..21.87 rows=1 width=36) (actual time=0.086..0.153 rows=4 loops=1)

  • Buffers: shared hit=60
231. 0.026 0.090 ↓ 18.0 18 1

Bitmap Heap Scan on florence_line_items fli_13 (cost=9.53..13.56 rows=1 width=20) (actual time=0.073..0.09 rows=18 loops=1)

  • Filter: ((fli_13.amount_type = 'dollar'::text) AND (fli_13.status = 'approved'::text) AND (fli_13.company_id = 7))
  • Heap Blocks: exact=2
  • Buffers: shared hit=6
232. 0.002 0.064 ↓ 0.0 0 1

BitmapAnd (cost=9.53..9.53 rows=1 width=0) (actual time=0.064..0.064 rows=0 loops=1)

  • Buffers: shared hit=4
233. 0.032 0.032 ↓ 1.2 44 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.032..0.032 rows=44 loops=1)

  • Index Cond: (fli_13.type = 'revenue-change-order'::text)
  • Buffers: shared hit=2
234. 0.030 0.030 ↓ 2.2 128 1

Bitmap Index Scan on florence_line_items_event_scope_index (cost=0..4.73 rows=59 width=0) (actual time=0.03..0.03 rows=128 loops=1)

  • Index Cond: ((fli_13.migrated_metadata ->> 'event_scope'::text) = 'tbd'::text)
  • Buffers: shared hit=2
235. 0.054 0.054 ↓ 0.0 0 18

Index Scan using florence_packages_pkey on florence_packages holder_3 (cost=0.28..8.3 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=18)

  • Index Cond: (holder_3.id = fli_13.florence_package_id)
  • Filter: (holder_3.status = ANY ('{not_proceeding,proceeding,revised,pending,pricing,not_pricing}'::text[]))
  • Buffers: shared hit=54
236. 0.021 0.252 ↓ 3.0 3 3

GroupAggregate (cost=21.88..21.91 rows=1 width=64) (actual time=0.082..0.084 rows=3 loops=3)

  • Group Key: ((fli_14.wbs_code_id)::text)
  • Buffers: shared hit=112
237. 0.023 0.231 ↓ 8.0 8 3

Sort (cost=21.88..21.89 rows=1 width=36) (actual time=0.075..0.077 rows=8 loops=3)

  • Sort Key: ((fli_14.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=112
238. 0.006 0.208 ↓ 8.0 8 1

Nested Loop (cost=9.81..21.87 rows=1 width=36) (actual time=0.086..0.208 rows=8 loops=1)

  • Buffers: shared hit=112
239. 0.039 0.097 ↓ 35.0 35 1

Bitmap Heap Scan on florence_line_items fli_14 (cost=9.53..13.56 rows=1 width=20) (actual time=0.066..0.097 rows=35 loops=1)

  • Filter: ((fli_14.amount_type = 'dollar'::text) AND (fli_14.status = 'approved'::text) AND (fli_14.company_id = 7))
  • Heap Blocks: exact=2
  • Buffers: shared hit=7
240. 0.002 0.058 ↓ 0.0 0 1

BitmapAnd (cost=9.53..9.53 rows=1 width=0) (actual time=0.058..0.058 rows=0 loops=1)

  • Buffers: shared hit=5
241. 0.029 0.029 ↓ 1.7 60 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.029..0.029 rows=60 loops=1)

  • Index Cond: (fli_14.type = 'revenue-change-order-markup'::text)
  • Buffers: shared hit=3
242. 0.027 0.027 ↓ 2.2 128 1

Bitmap Index Scan on florence_line_items_event_scope_index (cost=0..4.73 rows=59 width=0) (actual time=0.027..0.027 rows=128 loops=1)

  • Index Cond: ((fli_14.migrated_metadata ->> 'event_scope'::text) = 'tbd'::text)
  • Buffers: shared hit=2
243. 0.105 0.105 ↓ 0.0 0 35

Index Scan using florence_packages_pkey on florence_packages holder_4 (cost=0.28..8.3 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=35)

  • Index Cond: (holder_4.id = fli_14.florence_package_id)
  • Filter: (holder_4.status = ANY ('{not_proceeding,proceeding,revised,pending,pricing,not_pricing}'::text[]))
  • Buffers: shared hit=105
244. 0.240 1.275 ↑ 14.8 6 3

HashAggregate (cost=445.01..446.57 rows=89 width=64) (actual time=0.423..0.425 rows=6 loops=3)

  • Group Key: (fli_15.wbs_code_id)::text
  • Buffers: shared hit=46
245. 0.251 1.035 ↓ 1.1 380 1

Hash Join (cost=46.9..443.33 rows=336 width=36) (actual time=0.454..1.035 rows=380 loops=1)

  • Buffers: shared hit=46
246. 0.359 0.450 ↓ 1.0 381 1

Bitmap Heap Scan on florence_line_items fli_15 (cost=15.24..405.25 rows=378 width=20) (actual time=0.105..0.45 rows=381 loops=1)

  • Filter: ((fli_15.amount_type = 'dollar'::text) AND (fli_15.status = 'approved'::text) AND (fli_15.company_id = 7))
  • Heap Blocks: exact=22
  • Buffers: shared hit=27
247. 0.091 0.091 ↑ 1.0 381 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..15.14 rows=381 width=0) (actual time=0.091..0.091 rows=381 loops=1)

  • Index Cond: (fli_15.type = 'spend-change-order'::text)
  • Buffers: shared hit=5
248. 0.145 0.334 ↑ 1.0 477 1

Hash (cost=25.7..25.7 rows=477 width=8) (actual time=0.334..0.334 rows=477 loops=1)

  • Buffers: shared hit=19
249. 0.189 0.189 ↑ 1.0 477 1

Seq Scan on florence_packages holder_5 (cost=0..25.7 rows=477 width=8) (actual time=0.011..0.189 rows=477 loops=1)

  • Filter: (holder_5.status = 'approved'::text)
  • Buffers: shared hit=19
250. 0.003 0.028 ↓ 0.0 0 1

Materialize (cost=145.98..147.12 rows=30 width=64) (actual time=0.028..0.028 rows=0 loops=1)

  • Buffers: shared hit=2
251. 0.000 0.025 ↓ 0.0 0 1

GroupAggregate (cost=145.98..146.74 rows=30 width=64) (actual time=0.025..0.025 rows=0 loops=1)

  • Group Key: ((fli_16.wbs_code_id)::text)
  • Buffers: shared hit=2
252. 0.008 0.025 ↓ 0.0 0 1

Sort (cost=145.98..146.06 rows=32 width=36) (actual time=0.025..0.025 rows=0 loops=1)

  • Sort Key: ((fli_16.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=2
253. 0.001 0.017 ↓ 0.0 0 1

Hash Join (cost=36.23..145.18 rows=32 width=36) (actual time=0.017..0.017 rows=0 loops=1)

  • Buffers: shared hit=2
254. 0.000 0.016 ↓ 0.0 0 1

Bitmap Heap Scan on florence_line_items fli_16 (cost=4.56..112.9 rows=36 width=20) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: ((fli_16.amount_type = 'dollar'::text) AND (fli_16.status = 'approved'::text) AND (fli_16.company_id = 7))
  • Buffers: shared hit=2
255. 0.016 0.016 ↓ 0.0 0 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (fli_16.type = 'spend-change-order-markup'::text)
  • Buffers: shared hit=2
256. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=25.7..25.7 rows=477 width=8) (never executed)

257. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on florence_packages holder_6 (cost=0..25.7 rows=477 width=8) (never executed)

  • Filter: (holder_6.status = 'approved'::text)
258. 0.051 0.327 ↓ 19.0 19 3

GroupAggregate (cost=32.61..32.64 rows=1 width=64) (actual time=0.093..0.109 rows=19 loops=3)

  • Group Key: ((fli_17.wbs_code_id)::text)
  • Buffers: shared hit=22
259. 0.065 0.276 ↓ 20.0 20 3

Sort (cost=32.61..32.62 rows=1 width=36) (actual time=0.09..0.092 rows=20 loops=3)

  • Sort Key: ((fli_17.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=22
260. 0.022 0.211 ↓ 20.0 20 1

Nested Loop (cost=22.49..32.6 rows=1 width=36) (actual time=0.109..0.211 rows=20 loops=1)

  • Buffers: shared hit=22
261. 0.005 0.021 ↓ 2.0 2 1

Bitmap Heap Scan on florence_packages holder_7 (cost=4.29..10.37 rows=1 width=8) (actual time=0.019..0.021 rows=2 loops=1)

  • Filter: (holder_7.status = 'Approved'::text)
  • Heap Blocks: exact=1
  • Buffers: shared hit=3
262. 0.016 0.016 ↑ 1.0 2 1

Bitmap Index Scan on index_florence_packages_on_migrated_object_type (cost=0..4.29 rows=2 width=0) (actual time=0.016..0.016 rows=2 loops=1)

  • Index Cond: (holder_7.migrated_object_type = 'PurchaseOrderContract'::text)
  • Buffers: shared hit=2
263. 0.032 0.168 ↓ 10.0 10 2

Bitmap Heap Scan on florence_line_items fli_17 (cost=18.2..22.22 rows=1 width=20) (actual time=0.078..0.084 rows=10 loops=2)

  • Filter: ((fli_17.amount_type = 'dollar'::text) AND (fli_17.company_id = 7))
  • Heap Blocks: exact=3
  • Buffers: shared hit=19
264. 0.004 0.136 ↓ 0.0 0 2

BitmapAnd (cost=18.2..18.2 rows=1 width=0) (actual time=0.068..0.068 rows=0 loops=2)

  • Buffers: shared hit=16
265. 0.020 0.020 ↑ 7.1 10 2

Bitmap Index Scan on index_florence_line_items_on_florence_package_id (cost=0..8.82 rows=71 width=0) (actual time=0.01..0.01 rows=10 loops=2)

  • Index Cond: (fli_17.florence_package_id = holder_7.id)
  • Buffers: shared hit=4
266. 0.112 0.112 ↓ 3.2 228 2

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..9.11 rows=72 width=0) (actual time=0.056..0.056 rows=228 loops=2)

  • Index Cond: (fli_17.type = ANY ('{spend,revenue}'::text[]))
  • Buffers: shared hit=12
267. 0.135 1.539 ↓ 20.0 20 3

GroupAggregate (cost=39.66..39.69 rows=1 width=64) (actual time=0.495..0.513 rows=20 loops=3)

  • Group Key: ((fli_18.wbs_code_id)::text)
  • Buffers: shared hit=174
268. 0.142 1.404 ↓ 96.0 96 3

Sort (cost=39.66..39.67 rows=1 width=36) (actual time=0.459..0.468 rows=96 loops=3)

  • Sort Key: ((fli_18.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 29kB
  • Buffers: shared hit=174
269. 0.100 1.262 ↓ 96.0 96 1

Nested Loop (cost=31.6..39.65 rows=1 width=36) (actual time=0.12..1.262 rows=96 loops=1)

  • Buffers: shared hit=174
270. 0.006 0.046 ↓ 18.0 18 1

Bitmap Heap Scan on florence_packages holder_8 (cost=13.41..17.42 rows=1 width=8) (actual time=0.042..0.046 rows=18 loops=1)

  • Heap Blocks: exact=1
  • Buffers: shared hit=7
271. 0.001 0.040 ↓ 0.0 0 1

BitmapAnd (cost=13.41..13.41 rows=1 width=0) (actual time=0.04..0.04 rows=0 loops=1)

  • Buffers: shared hit=6
272. 0.010 0.010 ↑ 1.0 18 1

Bitmap Index Scan on index_florence_packages_on_migrated_object_type (cost=0..4.41 rows=18 width=0) (actual time=0.01..0.01 rows=18 loops=1)

  • Index Cond: (holder_8.migrated_object_type = 'WorkOrderContract'::text)
  • Buffers: shared hit=2
273. 0.029 0.029 ↑ 1.1 23 1

Bitmap Index Scan on index_florence_packages_on_status (cost=0..8.75 rows=26 width=0) (actual time=0.029..0.029 rows=23 loops=1)

  • Index Cond: (holder_8.status = ANY ('{Complete,Approved}'::text[]))
  • Buffers: shared hit=4
274. 0.180 1.116 ↓ 5.0 5 18

Bitmap Heap Scan on florence_line_items fli_18 (cost=18.2..22.22 rows=1 width=20) (actual time=0.058..0.062 rows=5 loops=18)

  • Filter: ((fli_18.amount_type = 'dollar'::text) AND (fli_18.company_id = 7))
  • Heap Blocks: exact=22
  • Buffers: shared hit=167
275. 0.018 0.936 ↓ 0.0 0 18

BitmapAnd (cost=18.2..18.2 rows=1 width=0) (actual time=0.052..0.052 rows=0 loops=18)

  • Buffers: shared hit=145
276. 0.054 0.054 ↑ 14.2 5 18

Bitmap Index Scan on index_florence_line_items_on_florence_package_id (cost=0..8.82 rows=71 width=0) (actual time=0.003..0.003 rows=5 loops=18)

  • Index Cond: (fli_18.florence_package_id = holder_8.id)
  • Buffers: shared hit=37
277. 0.864 0.864 ↓ 3.2 228 18

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..9.11 rows=72 width=0) (actual time=0.048..0.048 rows=228 loops=18)

  • Index Cond: (fli_18.type = ANY ('{spend,revenue}'::text[]))
  • Buffers: shared hit=108
278. 0.042 0.234 ↓ 13.0 13 3

GroupAggregate (cost=26.61..26.63 rows=1 width=64) (actual time=0.068..0.078 rows=13 loops=3)

  • Group Key: ((fli_19.wbs_code_id)::text)
  • Buffers: shared hit=62
279. 0.049 0.192 ↓ 14.0 14 3

Sort (cost=26.61..26.61 rows=1 width=36) (actual time=0.064..0.064 rows=14 loops=3)

  • Sort Key: ((fli_19.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=62
280. 0.011 0.143 ↓ 14.0 14 1

Nested Loop (cost=14.54..26.6 rows=1 width=36) (actual time=0.073..0.143 rows=14 loops=1)

  • Buffers: shared hit=62
281. 0.016 0.078 ↓ 18.0 18 1

Bitmap Heap Scan on florence_line_items fli_19 (cost=14.26..18.29 rows=1 width=20) (actual time=0.067..0.078 rows=18 loops=1)

  • Filter: ((fli_19.amount_type = 'dollar'::text) AND (fli_19.status = 'approved'::text) AND (fli_19.company_id = 7))
  • Heap Blocks: exact=2
  • Buffers: shared hit=8
282. 0.002 0.062 ↓ 0.0 0 1

BitmapAnd (cost=14.26..14.26 rows=1 width=0) (actual time=0.062..0.062 rows=0 loops=1)

  • Buffers: shared hit=6
283. 0.027 0.027 ↓ 1.2 44 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.027..0.027 rows=44 loops=1)

  • Index Cond: (fli_19.type = 'revenue-change-order'::text)
  • Buffers: shared hit=2
284. 0.033 0.033 ↓ 1.1 135 1

Bitmap Index Scan on florence_line_items_event_scope_index (cost=0..9.46 rows=119 width=0) (actual time=0.033..0.033 rows=135 loops=1)

  • Index Cond: ((fli_19.migrated_metadata ->> 'event_scope'::text) = ANY ('{in_scope,tbd}'::text[]))
  • Buffers: shared hit=4
285. 0.054 0.054 ↑ 1.0 1 18

Index Scan using florence_packages_pkey on florence_packages holder_9 (cost=0.28..8.29 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=18)

  • Index Cond: (holder_9.id = fli_19.florence_package_id)
  • Filter: (holder_9.status = 'approved'::text)
  • Buffers: shared hit=54
286. 0.036 0.282 ↓ 3.0 3 3

GroupAggregate (cost=26.61..26.63 rows=1 width=64) (actual time=0.092..0.094 rows=3 loops=3)

  • Group Key: ((fli_20.wbs_code_id)::text)
  • Buffers: shared hit=114
287. 0.040 0.246 ↓ 27.0 27 3

Sort (cost=26.61..26.61 rows=1 width=36) (actual time=0.078..0.082 rows=27 loops=3)

  • Sort Key: ((fli_20.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 26kB
  • Buffers: shared hit=114
288. 0.046 0.206 ↓ 27.0 27 1

Nested Loop (cost=14.54..26.6 rows=1 width=36) (actual time=0.071..0.206 rows=27 loops=1)

  • Buffers: shared hit=114
289. 0.030 0.090 ↓ 35.0 35 1

Bitmap Heap Scan on florence_line_items fli_20 (cost=14.26..18.29 rows=1 width=20) (actual time=0.065..0.09 rows=35 loops=1)

  • Filter: ((fli_20.amount_type = 'dollar'::text) AND (fli_20.status = 'approved'::text) AND (fli_20.company_id = 7))
  • Heap Blocks: exact=2
  • Buffers: shared hit=9
290. 0.001 0.060 ↓ 0.0 0 1

BitmapAnd (cost=14.26..14.26 rows=1 width=0) (actual time=0.06..0.06 rows=0 loops=1)

  • Buffers: shared hit=7
291. 0.027 0.027 ↓ 1.7 60 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.027..0.027 rows=60 loops=1)

  • Index Cond: (fli_20.type = 'revenue-change-order-markup'::text)
  • Buffers: shared hit=3
292. 0.032 0.032 ↓ 1.1 135 1

Bitmap Index Scan on florence_line_items_event_scope_index (cost=0..9.46 rows=119 width=0) (actual time=0.032..0.032 rows=135 loops=1)

  • Index Cond: ((fli_20.migrated_metadata ->> 'event_scope'::text) = ANY ('{in_scope,tbd}'::text[]))
  • Buffers: shared hit=4
293. 0.070 0.070 ↑ 1.0 1 35

Index Scan using florence_packages_pkey on florence_packages holder_10 (cost=0.28..8.29 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=35)

  • Index Cond: (holder_10.id = fli_20.florence_package_id)
  • Filter: (holder_10.status = 'approved'::text)
  • Buffers: shared hit=105
294. 0.225 1.113 ↓ 88.0 88 3

GroupAggregate (cost=79.45..79.48 rows=1 width=64) (actual time=0.297..0.371 rows=88 loops=3)

  • Group Key: ((fli_21.wbs_code_id)::text)
  • Buffers: shared hit=35
295. 0.521 0.888 ↓ 111.0 111 3

Sort (cost=79.45..79.46 rows=1 width=36) (actual time=0.283..0.296 rows=111 loops=3)

  • Sort Key: ((fli_21.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 30kB
  • Buffers: shared hit=35
296. 0.059 0.367 ↓ 111.0 111 1

Nested Loop (cost=22.49..79.44 rows=1 width=36) (actual time=0.093..0.367 rows=111 loops=1)

  • Buffers: shared hit=35
297. 0.002 0.011 ↑ 1.0 3 1

Bitmap Heap Scan on florence_packages holder_11 (cost=4.3..12.76 rows=3 width=8) (actual time=0.01..0.011 rows=3 loops=1)

  • Heap Blocks: exact=1
  • Buffers: shared hit=3
298. 0.009 0.009 ↑ 1.0 3 1

Bitmap Index Scan on index_florence_packages_on_migrated_object_type (cost=0..4.3 rows=3 width=0) (actual time=0.009..0.009 rows=3 loops=1)

  • Index Cond: (holder_11.migrated_object_type = 'PrimeContract'::text)
  • Buffers: shared hit=2
299. 0.114 0.297 ↓ 37.0 37 3

Bitmap Heap Scan on florence_line_items fli_21 (cost=18.2..22.22 rows=1 width=20) (actual time=0.068..0.099 rows=37 loops=3)

  • Filter: ((fli_21.amount_type = 'dollar'::text) AND (fli_21.company_id = 7))
  • Heap Blocks: exact=8
  • Buffers: shared hit=32
300. 0.003 0.183 ↓ 0.0 0 3

BitmapAnd (cost=18.2..18.2 rows=1 width=0) (actual time=0.061..0.061 rows=0 loops=3)

  • Buffers: shared hit=24
301. 0.027 0.027 ↑ 1.9 37 3

Bitmap Index Scan on index_florence_line_items_on_florence_package_id (cost=0..8.82 rows=71 width=0) (actual time=0.009..0.009 rows=37 loops=3)

  • Index Cond: (fli_21.florence_package_id = holder_11.id)
  • Buffers: shared hit=6
302. 0.153 0.153 ↓ 3.2 228 3

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..9.11 rows=72 width=0) (actual time=0.051..0.051 rows=228 loops=3)

  • Index Cond: (fli_21.type = ANY ('{spend,revenue}'::text[]))
  • Buffers: shared hit=18
303. 0.000 0.021 ↓ 0.0 0 3

GroupAggregate (cost=32.62..32.65 rows=1 width=64) (actual time=0.007..0.007 rows=0 loops=3)

  • Group Key: ((fli_22.wbs_code_id)::text)
  • Buffers: shared hit=3
304. 0.006 0.021 ↓ 0.0 0 3

Sort (cost=32.62..32.62 rows=1 width=36) (actual time=0.007..0.007 rows=0 loops=3)

  • Sort Key: ((fli_22.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3
305. 0.002 0.015 ↓ 0.0 0 1

Nested Loop (cost=22.49..32.61 rows=1 width=36) (actual time=0.015..0.015 rows=0 loops=1)

  • Buffers: shared hit=3
306. 0.003 0.013 ↓ 0.0 0 1

Bitmap Heap Scan on florence_packages holder_12 (cost=4.29..10.38 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (holder_12.status = ANY ('{Submitted,Received,Processing,"Partially Received"}'::text[]))
  • Heap Blocks: exact=1
  • Buffers: shared hit=3
307. 0.010 0.010 ↑ 1.0 2 1

Bitmap Index Scan on index_florence_packages_on_migrated_object_type (cost=0..4.29 rows=2 width=0) (actual time=0.01..0.01 rows=2 loops=1)

  • Index Cond: (holder_12.migrated_object_type = 'PurchaseOrderContract'::text)
  • Buffers: shared hit=2
308. 0.000 0.000 ↓ 0.0 0 0

Bitmap Heap Scan on florence_line_items fli_22 (cost=18.2..22.22 rows=1 width=20) (never executed)

  • Filter: ((fli_22.amount_type = 'dollar'::text) AND (fli_22.company_id = 7))
309. 0.000 0.000 ↓ 0.0 0 0

BitmapAnd (cost=18.2..18.2 rows=1 width=0) (never executed)

310. 0.000 0.000 ↓ 0.0 0 0

Bitmap Index Scan on index_florence_line_items_on_florence_package_id (cost=0..8.82 rows=71 width=0) (never executed)

  • Index Cond: (fli_22.florence_package_id = holder_12.id)
311. 0.000 0.000 ↓ 0.0 0 0

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..9.11 rows=72 width=0) (never executed)

  • Index Cond: (fli_22.type = ANY ('{spend,revenue}'::text[]))
312. 0.003 0.021 ↓ 0.0 0 3

GroupAggregate (cost=32.22..32.25 rows=1 width=64) (actual time=0.007..0.007 rows=0 loops=3)

  • Group Key: ((fli_23.wbs_code_id)::text)
  • Buffers: shared hit=2
313. 0.007 0.018 ↓ 0.0 0 3

Sort (cost=32.22..32.23 rows=1 width=36) (actual time=0.006..0.006 rows=0 loops=3)

  • Sort Key: ((fli_23.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=2
314. 0.000 0.011 ↓ 0.0 0 1

Nested Loop (cost=18.47..32.21 rows=1 width=36) (actual time=0.011..0.011 rows=0 loops=1)

  • Buffers: shared hit=2
315. 0.011 0.011 ↓ 0.0 0 1

Index Scan using index_florence_packages_on_status on florence_packages holder_13 (cost=0.28..9.98 rows=1 width=8) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (holder_13.status = 'Out For Signature'::text)
  • Filter: (holder_13.migrated_object_type = 'WorkOrderContract'::text)
  • Buffers: shared hit=2
316. 0.000 0.000 ↓ 0.0 0 0

Bitmap Heap Scan on florence_line_items fli_23 (cost=18.2..22.22 rows=1 width=20) (never executed)

  • Filter: ((fli_23.amount_type = 'dollar'::text) AND (fli_23.company_id = 7))
317. 0.000 0.000 ↓ 0.0 0 0

BitmapAnd (cost=18.2..18.2 rows=1 width=0) (never executed)

318. 0.000 0.000 ↓ 0.0 0 0

Bitmap Index Scan on index_florence_line_items_on_florence_package_id (cost=0..8.82 rows=71 width=0) (never executed)

  • Index Cond: (fli_23.florence_package_id = holder_13.id)
319. 0.000 0.000 ↓ 0.0 0 0

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..9.11 rows=72 width=0) (never executed)

  • Index Cond: (fli_23.type = ANY ('{spend,revenue}'::text[]))
320. 0.012 0.126 ↑ 1.0 1 3

GroupAggregate (cost=44.36..44.39 rows=1 width=64) (actual time=0.042..0.042 rows=1 loops=3)

  • Group Key: ((fli_24.wbs_code_id)::text)
  • Buffers: shared hit=15
321. 0.011 0.114 ↑ 1.0 1 3

Sort (cost=44.36..44.37 rows=1 width=36) (actual time=0.037..0.038 rows=1 loops=3)

  • Sort Key: ((fli_24.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=15
322. 0.003 0.103 ↑ 1.0 1 1

Nested Loop (cost=20.4..44.35 rows=1 width=36) (actual time=0.102..0.103 rows=1 loops=1)

  • Buffers: shared hit=15
323. 0.006 0.092 ↑ 1.0 2 1

Bitmap Heap Scan on florence_line_items fli_24 (cost=20.12..27.73 rows=2 width=20) (actual time=0.09..0.092 rows=2 loops=1)

  • Filter: ((fli_24.amount_type = 'dollar'::text) AND (fli_24.status = 'approved'::text) AND (fli_24.company_id = 7))
  • Heap Blocks: exact=2
  • Buffers: shared hit=9
324. 0.003 0.086 ↓ 0.0 0 1

BitmapAnd (cost=20.12..20.12 rows=2 width=0) (actual time=0.086..0.086 rows=0 loops=1)

  • Buffers: shared hit=7
325. 0.014 0.014 ↑ 8.4 7 1

Bitmap Index Scan on florence_line_items_event_scope_index (cost=0..4.73 rows=59 width=0) (actual time=0.014..0.014 rows=7 loops=1)

  • Index Cond: ((fli_24.migrated_metadata ->> 'event_scope'::text) = 'in_scope'::text)
  • Buffers: shared hit=2
326. 0.069 0.069 ↑ 1.0 381 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..15.14 rows=381 width=0) (actual time=0.069..0.069 rows=381 loops=1)

  • Index Cond: (fli_24.type = 'spend-change-order'::text)
  • Buffers: shared hit=5
327. 0.008 0.008 ↓ 0.0 0 2

Index Scan using florence_packages_pkey on florence_packages holder_14 (cost=0.28..8.3 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=2)

  • Index Cond: (holder_14.id = fli_24.florence_package_id)
  • Filter: (holder_14.status = ANY ('{not_proceeding,proceeding,revised,pending,pricing,not_pricing}'::text[]))
  • Buffers: shared hit=6
328. 0.000 0.027 ↓ 0.0 0 3

GroupAggregate (cost=21.88..21.91 rows=1 width=64) (actual time=0.009..0.009 rows=0 loops=3)

  • Group Key: ((fli_25.wbs_code_id)::text)
  • Buffers: shared hit=2
329. 0.010 0.027 ↓ 0.0 0 3

Sort (cost=21.88..21.89 rows=1 width=36) (actual time=0.009..0.009 rows=0 loops=3)

  • Sort Key: ((fli_25.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=2
330. 0.000 0.017 ↓ 0.0 0 1

Nested Loop (cost=9.81..21.87 rows=1 width=36) (actual time=0.017..0.017 rows=0 loops=1)

  • Buffers: shared hit=2
331. 0.001 0.017 ↓ 0.0 0 1

Bitmap Heap Scan on florence_line_items fli_25 (cost=9.53..13.56 rows=1 width=20) (actual time=0.017..0.017 rows=0 loops=1)

  • Filter: ((fli_25.amount_type = 'dollar'::text) AND (fli_25.status = 'approved'::text) AND (fli_25.company_id = 7))
  • Buffers: shared hit=2
332. 0.000 0.016 ↓ 0.0 0 1

BitmapAnd (cost=9.53..9.53 rows=1 width=0) (actual time=0.016..0.016 rows=0 loops=1)

  • Buffers: shared hit=2
333. 0.016 0.016 ↓ 0.0 0 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (fli_25.type = 'spend-change-order-markup'::text)
  • Buffers: shared hit=2
334. 0.000 0.000 ↓ 0.0 0 0

Bitmap Index Scan on florence_line_items_event_scope_index (cost=0..4.73 rows=59 width=0) (never executed)

  • Index Cond: ((fli_25.migrated_metadata ->> 'event_scope'::text) = 'in_scope'::text)
335. 0.000 0.000 ↓ 0.0 0 0

Index Scan using florence_packages_pkey on florence_packages holder_15 (cost=0.28..8.3 rows=1 width=8) (never executed)

  • Index Cond: (holder_15.id = fli_25.florence_package_id)
  • Filter: (holder_15.status = ANY ('{not_proceeding,proceeding,revised,pending,pricing,not_pricing}'::text[]))
336. 0.012 0.051 ↑ 18.0 2 3

Bitmap Heap Scan on florence_line_items fli_5 (cost=4.56..112.81 rows=36 width=12) (actual time=0.016..0.017 rows=2 loops=3)

  • Filter: ((fli_5.amount_type = 'dollar'::text) AND (fli_5.company_id = 7))
  • Heap Blocks: exact=3
  • Buffers: shared hit=9
337. 0.039 0.039 ↑ 18.0 2 3

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.013..0.013 rows=2 loops=3)

  • Index Cond: (fli_5.type = 'erp-job-cost-to-date'::text)
  • Buffers: shared hit=6
338. 0.012 0.048 ↑ 18.0 2 3

Bitmap Heap Scan on florence_line_items fli_6 (cost=4.56..112.81 rows=36 width=12) (actual time=0.014..0.016 rows=2 loops=3)

  • Filter: ((fli_6.amount_type = 'dollar'::text) AND (fli_6.company_id = 7))
  • Heap Blocks: exact=3
  • Buffers: shared hit=9
339. 0.036 0.036 ↑ 18.0 2 3

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.012..0.012 rows=2 loops=3)

  • Index Cond: (fli_6.type = 'erp-commitment-invoiced'::text)
  • Buffers: shared hit=6
340. 0.069 0.312 ↓ 22.0 22 3

GroupAggregate (cost=13.6..13.63 rows=1 width=64) (actual time=0.083..0.104 rows=22 loops=3)

  • Group Key: ((fli_26.wbs_code_id)::text)
  • Buffers: shared hit=8
341. 0.085 0.243 ↓ 25.0 25 3

Sort (cost=13.6..13.61 rows=1 width=36) (actual time=0.079..0.081 rows=25 loops=3)

  • Sort Key: ((fli_26.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 26kB
  • Buffers: shared hit=8
342. 0.101 0.158 ↓ 25.0 25 1

Bitmap Heap Scan on florence_line_items fli_26 (cost=9.53..13.59 rows=1 width=36) (actual time=0.076..0.158 rows=25 loops=1)

  • Filter: ((fli_26.amount_type = 'dollar'::text) AND (fli_26.company_id = 7) AND (((fli_26.migrated_metadata ->> 'prime_potential_change_order_line_item_id'::text) IS NOT NULL) OR ((fli_26.migrated_metadata ->> 'prime_potential_change_order_line_item_id'::text) IS NULL)) AND (((fli_26.migrated_metadata ->> 'manual_latest_cost_amount'::text) IS NOT NULL) OR ((fli_26.migrated_metadata ->> 'manual_latest_cost_amount'::text) IS NULL)) AND ((fli_26.migrated_metadata ->> 'event_status'::text) = 'open'::text) AND ((((fli_26.migrated_metadata ->> 'commitment_contract_line_item_id'::text) IS NULL) AND ((fli_26.migrated_metadata ->> 'commitment_potential_change_order_line_item_id'::text) IS NULL) AND ((fli_26.migrated_metadata ->> 'quote_id'::text) IS NULL)) OR ((fli_26.migrated_metadata ->> 'commitment_contract_line_item_id'::text) IS NOT NULL) OR ((fli_26.migrated_metadata ->> 'commitment_potential_change_order_line_item_id'::text) IS NOT NULL) OR ((fli_26.migrated_metadata ->> 'quote_id'::text) IS NOT NULL)))
  • Heap Blocks: exact=3
  • Buffers: shared hit=8
343. 0.002 0.057 ↓ 0.0 0 1

BitmapAnd (cost=9.53..9.53 rows=1 width=0) (actual time=0.057..0.057 rows=0 loops=1)

  • Buffers: shared hit=5
344. 0.027 0.027 ↑ 1.2 30 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.027..0.027 rows=30 loops=1)

  • Index Cond: (fli_26.type = 'spend-change'::text)
  • Buffers: shared hit=3
345. 0.028 0.028 ↓ 2.2 128 1

Bitmap Index Scan on florence_line_items_event_scope_index (cost=0..4.73 rows=59 width=0) (actual time=0.028..0.028 rows=128 loops=1)

  • Index Cond: ((fli_26.migrated_metadata ->> 'event_scope'::text) = 'tbd'::text)
  • Buffers: shared hit=2
346. 0.012 0.084 ↑ 1.0 1 3

GroupAggregate (cost=13.58..13.6 rows=1 width=64) (actual time=0.028..0.028 rows=1 loops=3)

  • Group Key: ((fli_27.wbs_code_id)::text)
  • Buffers: shared hit=5
347. 0.010 0.072 ↑ 1.0 1 3

Sort (cost=13.58..13.58 rows=1 width=36) (actual time=0.024..0.024 rows=1 loops=3)

  • Sort Key: ((fli_27.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=5
348. 0.006 0.062 ↑ 1.0 1 1

Bitmap Heap Scan on florence_line_items fli_27 (cost=9.53..13.57 rows=1 width=36) (actual time=0.062..0.062 rows=1 loops=1)

  • Filter: ((fli_27.amount_type = 'dollar'::text) AND (fli_27.company_id = 7) AND ((fli_27.migrated_metadata ->> 'event_scope'::text) = ANY ('{tbd,out_of_scope}'::text[])))
  • Heap Blocks: exact=1
  • Buffers: shared hit=5
349. 0.001 0.056 ↓ 0.0 0 1

BitmapAnd (cost=9.53..9.53 rows=1 width=0) (actual time=0.056..0.056 rows=0 loops=1)

  • Buffers: shared hit=4
350. 0.017 0.017 ↑ 36.0 1 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: (fli_27.type = 'spend-change-non-committed'::text)
  • Buffers: shared hit=2
351. 0.038 0.038 ↓ 2.3 135 1

Bitmap Index Scan on florence_line_items_event_status_index (cost=0..4.73 rows=59 width=0) (actual time=0.038..0.038 rows=135 loops=1)

  • Index Cond: ((fli_27.migrated_metadata ->> 'event_status'::text) = 'open'::text)
  • Buffers: shared hit=2
352. 0.018 1.395 ↓ 7.0 7 3

GroupAggregate (cost=13.58..13.61 rows=1 width=64) (actual time=0.46..0.465 rows=7 loops=3)

  • Group Key: ((fli_28.wbs_code_id)::text)
  • Buffers: shared hit=39
353. 0.028 1.377 ↓ 7.0 7 3

Sort (cost=13.58..13.58 rows=1 width=36) (actual time=0.459..0.459 rows=7 loops=3)

  • Sort Key: ((fli_28.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=39
354. 0.020 1.349 ↓ 7.0 7 1

Bitmap Heap Scan on florence_line_items fli_28 (cost=9.53..13.57 rows=1 width=36) (actual time=1.338..1.349 rows=7 loops=1)

  • Filter: ((fli_28.amount_type = 'dollar'::text) AND (fli_28.company_id = 7) AND ((fli_28.migrated_metadata ->> 'event_status'::text) = 'open'::text) AND ((fli_28.migrated_metadata ->> 'event_scope'::text) = 'tbd'::text))
  • Heap Blocks: exact=2
  • Buffers: shared hit=39
355. 0.015 1.329 ↓ 0.0 0 1

BitmapAnd (cost=9.53..9.53 rows=1 width=0) (actual time=1.329..1.329 rows=0 loops=1)

  • Buffers: shared hit=37
356. 0.030 0.030 ↑ 1.3 27 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.03..0.03 rows=27 loops=1)

  • Index Cond: (fli_28.type = 'revenue-change'::text)
  • Buffers: shared hit=3
357. 1.284 1.284 ↓ 200.7 11,842 1

Bitmap Index Scan on florence_line_items_prime_potential_change_order_line_item_id_i (cost=0..4.73 rows=59 width=0) (actual time=1.284..1.284 rows=11,842 loops=1)

  • Index Cond: ((fli_28.migrated_metadata ->> 'prime_potential_change_order_line_item_id'::text) IS NULL)
  • Buffers: shared hit=34
358. 0.009 0.069 ↑ 1.0 1 3

GroupAggregate (cost=13.57..13.6 rows=1 width=64) (actual time=0.023..0.023 rows=1 loops=3)

  • Group Key: ((fli_29.wbs_code_id)::text)
  • Buffers: shared hit=5
359. 0.010 0.060 ↑ 1.0 1 3

Sort (cost=13.57..13.58 rows=1 width=36) (actual time=0.02..0.02 rows=1 loops=3)

  • Sort Key: ((fli_29.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=5
360. 0.004 0.050 ↑ 1.0 1 1

Bitmap Heap Scan on florence_line_items fli_29 (cost=9.53..13.56 rows=1 width=36) (actual time=0.05..0.05 rows=1 loops=1)

  • Filter: ((fli_29.amount_type = 'dollar'::text) AND (fli_29.company_id = 7))
  • Heap Blocks: exact=1
  • Buffers: shared hit=5
361. 0.001 0.046 ↓ 0.0 0 1

BitmapAnd (cost=9.53..9.53 rows=1 width=0) (actual time=0.046..0.046 rows=0 loops=1)

  • Buffers: shared hit=4
362. 0.017 0.017 ↑ 36.0 1 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: (fli_29.type = 'revenue-change-markup'::text)
  • Buffers: shared hit=2
363. 0.028 0.028 ↓ 2.3 135 1

Bitmap Index Scan on florence_line_items_event_status_index (cost=0..4.73 rows=59 width=0) (actual time=0.028..0.028 rows=135 loops=1)

  • Index Cond: ((fli_29.migrated_metadata ->> 'event_status'::text) = 'open'::text)
  • Buffers: shared hit=2
364. 0.030 0.102 ↑ 1.0 1 3

GroupAggregate (cost=30.46..30.49 rows=1 width=96) (actual time=0.034..0.034 rows=1 loops=3)

  • Group Key: ((fli_30.wbs_code_id)::text)
  • Buffers: shared hit=9
365. 0.013 0.072 ↑ 1.0 1 3

Sort (cost=30.46..30.46 rows=1 width=42) (actual time=0.023..0.024 rows=1 loops=3)

  • Sort Key: ((fli_30.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=9
366. 0.005 0.059 ↑ 1.0 1 1

Nested Loop (cost=17.92..30.45 rows=1 width=42) (actual time=0.057..0.059 rows=1 loops=1)

  • Buffers: shared hit=9
367. 0.005 0.020 ↑ 1.0 1 1

Bitmap Heap Scan on florence_packages holder_16 (cost=4.3..12.79 rows=1 width=8) (actual time=0.019..0.02 rows=1 loops=1)

  • Filter: ((holder_16.type = 'Invoice'::text) AND (holder_16.migrated_object_type = 'DirectCost::Item'::text) AND (holder_16.status = 'draft'::text))
  • Heap Blocks: exact=1
  • Buffers: shared hit=3
368. 0.015 0.015 ↑ 1.5 2 1

Bitmap Index Scan on florence_package_direct_cost_type_index (cost=0..4.3 rows=3 width=0) (actual time=0.015..0.015 rows=2 loops=1)

  • Index Cond: ((holder_16.migrated_metadata ->> 'direct_cost_type'::text) = 'expense'::text)
  • Buffers: shared hit=2
369. 0.005 0.034 ↑ 1.0 1 1

Bitmap Heap Scan on florence_line_items fli_30 (cost=13.62..17.64 rows=1 width=26) (actual time=0.034..0.034 rows=1 loops=1)

  • Filter: ((fli_30.amount_type <> 'dollar'::text) AND (fli_30.company_id = 7))
  • Heap Blocks: exact=1
  • Buffers: shared hit=6
370. 0.002 0.029 ↓ 0.0 0 1

BitmapAnd (cost=13.62..13.62 rows=1 width=0) (actual time=0.029..0.029 rows=0 loops=1)

  • Buffers: shared hit=5
371. 0.025 0.025 ↓ 1.8 64 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.025..0.025 rows=64 loops=1)

  • Index Cond: (fli_30.type = 'spend-actual'::text)
  • Buffers: shared hit=3
372. 0.002 0.002 ↑ 35.5 2 1

Bitmap Index Scan on index_florence_line_items_on_florence_package_id (cost=0..8.82 rows=71 width=0) (actual time=0.002..0.002 rows=2 loops=1)

  • Index Cond: (fli_30.florence_package_id = holder_16.id)
  • Buffers: shared hit=2
373. 0.033 0.033 ↑ 1.0 1 3

Index Scan using idx_tabs_on_provider_and_engine_name on tools column_109_direct_cost_tool (cost=0.28..8.3 rows=1 width=18) (actual time=0.01..0.011 rows=1 loops=3)

  • Index Cond: (((column_109_direct_cost_tool.provider_type)::text = 'Project'::text) AND (column_109_direct_cost_tool.provider_id = '7'::bigint) AND ((column_109_direct_cost_tool.engine_name)::text = 'direct_costs'::text))
  • Buffers: shared hit=9
374. 0.922 2.328 ↑ 1.0 88 3

HashAggregate (cost=453.7..455.27 rows=90 width=64) (actual time=0.746..0.776 rows=88 loops=3)

  • Group Key: (fli_31.wbs_code_id)::text
  • Buffers: shared hit=53
375. 1.166 1.406 ↑ 1.0 1,378 1

Bitmap Heap Scan on florence_line_items fli_31 (cost=51.25..446.81 rows=1,378 width=36) (actual time=0.253..1.406 rows=1,378 loops=1)

  • Filter: (fli_31.company_id = 7)
  • Heap Blocks: exact=41
  • Buffers: shared hit=53
376. 0.240 0.240 ↑ 1.0 1,378 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..50.91 rows=1,378 width=0) (actual time=0.24..0.24 rows=1,378 loops=1)

  • Index Cond: (fli_31.type = ANY ('{revenue-actual-billed,revenue-actual-retained}'::text[]))
  • Buffers: shared hit=12
377. 0.042 0.177 ↑ 25.0 2 3

HashAggregate (cost=191.08..191.95 rows=50 width=64) (actual time=0.059..0.059 rows=2 loops=3)

  • Group Key: (fli_32.wbs_code_id)::text
  • Buffers: shared hit=7
378. 0.073 0.135 ↑ 1.1 68 1

Bitmap Heap Scan on florence_line_items fli_32 (cost=9.13..190.72 rows=72 width=36) (actual time=0.068..0.135 rows=68 loops=1)

  • Filter: (fli_32.company_id = 7)
  • Heap Blocks: exact=3
  • Buffers: shared hit=7
379. 0.062 0.062 ↑ 1.1 68 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..9.11 rows=72 width=0) (actual time=0.062..0.062 rows=68 loops=1)

  • Index Cond: (fli_32.type = ANY ('{revenue-actual-markup-billed,revenue-actual-markup-retained}'::text[]))
  • Buffers: shared hit=4
380. 0.036 0.138 ↑ 1.0 1 3

GroupAggregate (cost=21.89..21.92 rows=1 width=96) (actual time=0.046..0.046 rows=1 loops=3)

  • Group Key: ((fli_33.wbs_code_id)::text)
  • Buffers: shared hit=9
381. 0.010 0.102 ↑ 1.0 1 3

Sort (cost=21.89..21.9 rows=1 width=42) (actual time=0.034..0.034 rows=1 loops=3)

  • Sort Key: ((fli_33.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=9
382. 0.006 0.092 ↑ 1.0 1 1

Nested Loop (cost=9.82..21.88 rows=1 width=42) (actual time=0.084..0.092 rows=1 loops=1)

  • Buffers: shared hit=9
383. 0.012 0.072 ↑ 1.0 1 1

Bitmap Heap Scan on florence_line_items fli_33 (cost=9.53..13.56 rows=1 width=26) (actual time=0.066..0.072 rows=1 loops=1)

  • Filter: ((fli_33.amount_type <> 'dollar'::text) AND (fli_33.status = 'approved'::text) AND (fli_33.company_id = 7))
  • Heap Blocks: exact=2
  • Buffers: shared hit=6
384. 0.004 0.060 ↓ 0.0 0 1

BitmapAnd (cost=9.53..9.53 rows=1 width=0) (actual time=0.06..0.06 rows=0 loops=1)

  • Buffers: shared hit=4
385. 0.029 0.029 ↓ 1.2 44 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.029..0.029 rows=44 loops=1)

  • Index Cond: (fli_33.type = 'revenue-change-order'::text)
  • Buffers: shared hit=2
386. 0.027 0.027 ↓ 2.2 128 1

Bitmap Index Scan on florence_line_items_event_scope_index (cost=0..4.73 rows=59 width=0) (actual time=0.027..0.027 rows=128 loops=1)

  • Index Cond: ((fli_33.migrated_metadata ->> 'event_scope'::text) = 'tbd'::text)
  • Buffers: shared hit=2
387. 0.014 0.014 ↑ 1.0 1 1

Index Scan using florence_line_items_pkey on florence_line_items florence_line_items (cost=0.29..8.31 rows=1 width=8) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: (florence_line_items.id = fli_33.id)
  • Filter: ((florence_line_items.migrated_metadata ->> 'change_order_package_status'::text) = 'approved'::text)
  • Buffers: shared hit=3
388. 0.027 0.117 ↑ 1.0 1 3

GroupAggregate (cost=21.89..21.92 rows=1 width=96) (actual time=0.039..0.039 rows=1 loops=3)

  • Group Key: ((fli_34.wbs_code_id)::text)
  • Buffers: shared hit=9
389. 0.010 0.090 ↑ 1.0 1 3

Sort (cost=21.89..21.9 rows=1 width=42) (actual time=0.03..0.03 rows=1 loops=3)

  • Sort Key: ((fli_34.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=9
390. 0.005 0.080 ↑ 1.0 1 1

Nested Loop (cost=9.82..21.88 rows=1 width=42) (actual time=0.074..0.08 rows=1 loops=1)

  • Buffers: shared hit=9
391. 0.012 0.069 ↑ 1.0 1 1

Bitmap Heap Scan on florence_line_items fli_34 (cost=9.53..13.56 rows=1 width=26) (actual time=0.063..0.069 rows=1 loops=1)

  • Filter: ((fli_34.amount_type <> 'dollar'::text) AND (fli_34.status = 'approved'::text) AND (fli_34.company_id = 7))
  • Heap Blocks: exact=2
  • Buffers: shared hit=6
392. 0.003 0.057 ↓ 0.0 0 1

BitmapAnd (cost=9.53..9.53 rows=1 width=0) (actual time=0.057..0.057 rows=0 loops=1)

  • Buffers: shared hit=4
393. 0.028 0.028 ↓ 1.2 44 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.028..0.028 rows=44 loops=1)

  • Index Cond: (fli_34.type = 'revenue-change-order'::text)
  • Buffers: shared hit=2
394. 0.026 0.026 ↓ 2.2 128 1

Bitmap Index Scan on florence_line_items_event_scope_index (cost=0..4.73 rows=59 width=0) (actual time=0.026..0.026 rows=128 loops=1)

  • Index Cond: ((fli_34.migrated_metadata ->> 'event_scope'::text) = 'tbd'::text)
  • Buffers: shared hit=2
395. 0.006 0.006 ↑ 1.0 1 1

Index Scan using florence_line_items_pkey on florence_line_items florence_line_items_1 (cost=0.29..8.31 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (florence_line_items_1.id = fli_34.id)
  • Filter: ((florence_line_items_1.migrated_metadata ->> 'potential_change_order_status'::text) = 'approved'::text)
  • Buffers: shared hit=3
396. 0.007 0.126 ↑ 4.3 6 1

Materialize (cost=524.55..525.52 rows=26 width=64) (actual time=0.116..0.126 rows=6 loops=1)

  • Buffers: shared hit=13
397. 0.017 0.119 ↑ 4.3 6 1

GroupAggregate (cost=524.55..525.2 rows=26 width=64) (actual time=0.111..0.119 rows=6 loops=1)

  • Group Key: ((fli_35.wbs_code_id)::text)
  • Buffers: shared hit=13
398. 0.021 0.102 ↑ 4.3 6 1

Sort (cost=524.55..524.61 rows=26 width=36) (actual time=0.101..0.102 rows=6 loops=1)

  • Sort Key: ((fli_35.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=13
399. 0.015 0.081 ↑ 4.3 6 1

Nested Loop (cost=9.1..523.93 rows=26 width=36) (actual time=0.052..0.081 rows=6 loops=1)

  • Buffers: shared hit=13
400. 0.032 0.032 ↑ 1.5 2 1

Index Scan using index_florence_packages_on_status on florence_packages holder_17 (cost=0.28..16.84 rows=3 width=8) (actual time=0.025..0.032 rows=2 loops=1)

  • Index Cond: (holder_17.status = 'draft'::text)
  • Filter: ((holder_17.type = 'Invoice'::text) AND (holder_17.migrated_object_type = 'Billings::Requisition'::text))
  • Buffers: shared hit=7
401. 0.016 0.034 ↑ 9.3 3 2

Bitmap Heap Scan on florence_line_items fli_35 (cost=8.82..168.71 rows=28 width=20) (actual time=0.012..0.017 rows=3 loops=2)

  • Filter: ((fli_35.type = 'spend-actual-billed'::text) AND (fli_35.amount_type = 'dollar'::text) AND (fli_35.company_id = 7))
  • Heap Blocks: exact=2
  • Buffers: shared hit=6
402. 0.018 0.018 ↑ 11.8 6 2

Bitmap Index Scan on index_florence_line_items_on_florence_package_id (cost=0..8.82 rows=71 width=0) (actual time=0.009..0.009 rows=6 loops=2)

  • Index Cond: (fli_35.florence_package_id = holder_17.id)
  • Buffers: shared hit=4
403. 0.503 1.269 ↑ 1.0 88 3

HashAggregate (cost=418.08..419.65 rows=90 width=64) (actual time=0.397..0.423 rows=88 loops=3)

  • Group Key: (fli_36.wbs_code_id)::text
  • Buffers: shared hit=44
404. 0.629 0.766 ↓ 1.0 689 1

Bitmap Heap Scan on florence_line_items fli_36 (cost=25.62..414.66 rows=684 width=36) (actual time=0.15..0.766 rows=689 loops=1)

  • Filter: ((fli_36.amount_type = 'dollar'::text) AND (fli_36.company_id = 7))
  • Heap Blocks: exact=38
  • Buffers: shared hit=44
405. 0.137 0.137 ↑ 1.0 689 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..25.45 rows=689 width=0) (actual time=0.137..0.137 rows=689 loops=1)

  • Index Cond: (fli_36.type = 'revenue-actual-billed'::text)
  • Buffers: shared hit=6
406. 0.932 2.130 ↑ 1.0 88 3

HashAggregate (cost=453.7..455.27 rows=90 width=64) (actual time=0.681..0.71 rows=88 loops=3)

  • Group Key: (fli_37.wbs_code_id)::text
  • Buffers: shared hit=53
407. 0.962 1.198 ↑ 1.0 1,378 1

Bitmap Heap Scan on florence_line_items fli_37 (cost=51.25..446.81 rows=1,378 width=36) (actual time=0.249..1.198 rows=1,378 loops=1)

  • Filter: (fli_37.company_id = 7)
  • Heap Blocks: exact=41
  • Buffers: shared hit=53
408. 0.236 0.236 ↑ 1.0 1,378 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..50.91 rows=1,378 width=0) (actual time=0.236..0.236 rows=1,378 loops=1)

  • Index Cond: (fli_37.type = ANY ('{revenue-actual-billed,revenue-actual-retained}'::text[]))
  • Buffers: shared hit=12
409. 0.549 1.245 ↑ 1.0 88 3

HashAggregate (cost=418.08..419.65 rows=90 width=64) (actual time=0.388..0.415 rows=88 loops=3)

  • Group Key: (fli_38.wbs_code_id)::text
  • Buffers: shared hit=44
410. 0.577 0.696 ↓ 1.0 689 1

Bitmap Heap Scan on florence_line_items fli_38 (cost=25.62..414.66 rows=684 width=36) (actual time=0.131..0.696 rows=689 loops=1)

  • Filter: ((fli_38.amount_type = 'dollar'::text) AND (fli_38.company_id = 7))
  • Heap Blocks: exact=38
  • Buffers: shared hit=44
411. 0.119 0.119 ↑ 1.0 689 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..25.45 rows=689 width=0) (actual time=0.119..0.119 rows=689 loops=1)

  • Index Cond: (fli_38.type = 'revenue-actual-billed'::text)
  • Buffers: shared hit=6
412. 0.005 0.132 ↑ 15.0 2 1

Materialize (cost=113.92..115.09 rows=30 width=64) (actual time=0.129..0.132 rows=2 loops=1)

  • Buffers: shared hit=5
413. 0.030 0.127 ↑ 15.0 2 1

GroupAggregate (cost=113.92..114.72 rows=30 width=64) (actual time=0.125..0.127 rows=2 loops=1)

  • Group Key: ((fli_39.wbs_code_id)::text)
  • Buffers: shared hit=5
414. 0.029 0.097 ↑ 1.1 34 1

Sort (cost=113.92..114.01 rows=36 width=36) (actual time=0.095..0.097 rows=34 loops=1)

  • Sort Key: ((fli_39.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 26kB
  • Buffers: shared hit=5
415. 0.035 0.068 ↑ 1.1 34 1

Bitmap Heap Scan on florence_line_items fli_39 (cost=4.56..112.99 rows=36 width=36) (actual time=0.042..0.068 rows=34 loops=1)

  • Filter: ((fli_39.amount_type = 'dollar'::text) AND (fli_39.company_id = 7))
  • Heap Blocks: exact=3
  • Buffers: shared hit=5
416. 0.033 0.033 ↑ 1.1 34 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.033..0.033 rows=34 loops=1)

  • Index Cond: (fli_39.type = 'revenue-actual-markup-billed'::text)
  • Buffers: shared hit=2
417. 4.728 17.757 ↑ 2.3 39 3

HashAggregate (cost=658.67..660.25 rows=90 width=64) (actual time=5.908..5.919 rows=39 loops=3)

  • Group Key: (fli_40.wbs_code_id)::text
  • Buffers: shared hit=387
418. 4.983 13.029 ↓ 7.0 9,332 1

Hash Join (cost=28.23..652.02 rows=1,329 width=36) (actual time=0.303..13.029 rows=9,332 loops=1)

  • Buffers: shared hit=387
419. 7.785 7.785 ↓ 1.2 9,332 1

Seq Scan on florence_line_items fli_40 (cost=0..575.92 rows=7,500 width=20) (actual time=0.02..7.785 rows=9,332 loops=1)

  • Filter: ((fli_40.company_id = 7) AND ((fli_40.type = 'spend-actual-billed'::text) OR (fli_40.type = 'spend-actual-retained'::text)))
  • Buffers: shared hit=368
420. 0.072 0.261 ↓ 2.3 214 1

Hash (cost=27.04..27.04 rows=95 width=8) (actual time=0.261..0.261 rows=214 loops=1)

  • Buffers: shared hit=19
421. 0.189 0.189 ↓ 2.3 214 1

Seq Scan on florence_packages holder_18 (cost=0..27.04 rows=95 width=8) (actual time=0.048..0.189 rows=214 loops=1)

  • Filter: ((holder_18.type = 'Invoice'::text) AND (holder_18.migrated_object_type = 'Billings::Requisition'::text))
  • Buffers: shared hit=19
422. 0.012 0.165 ↑ 1.0 1 3

GroupAggregate (cost=21.89..21.92 rows=1 width=64) (actual time=0.055..0.055 rows=1 loops=3)

  • Group Key: ((fli_41.wbs_code_id)::text)
  • Buffers: shared hit=45
423. 0.015 0.153 ↑ 1.0 1 3

Sort (cost=21.89..21.9 rows=1 width=36) (actual time=0.051..0.051 rows=1 loops=3)

  • Sort Key: ((fli_41.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=45
424. 0.006 0.138 ↑ 1.0 1 1

Nested Loop (cost=9.81..21.88 rows=1 width=36) (actual time=0.081..0.138 rows=1 loops=1)

  • Buffers: shared hit=45
425. 0.041 0.093 ↓ 13.0 13 1

Bitmap Heap Scan on florence_line_items fli_41 (cost=9.53..13.57 rows=1 width=20) (actual time=0.065..0.093 rows=13 loops=1)

  • Filter: (((fli_41.migrated_metadata ->> 'manual_latest_cost_amount'::text) IS NULL) AND (fli_41.amount_type = 'dollar'::text) AND (fli_41.company_id = 7) AND (((fli_41.migrated_metadata ->> 'prime_potential_change_order_line_item_id'::text) IS NOT NULL) OR ((fli_41.migrated_metadata ->> 'prime_potential_change_order_line_item_id'::text) IS NULL)) AND (((fli_41.migrated_metadata ->> 'commitment_contract_line_item_id'::text) IS NOT NULL) OR ((fli_41.migrated_metadata ->> 'commitment_potential_change_order_line_item_id'::text) IS NOT NULL)) AND ((fli_41.migrated_metadata ->> 'event_scope'::text) = ANY ('{tbd,in_scope}'::text[])))
  • Heap Blocks: exact=2
  • Buffers: shared hit=6
426. 0.002 0.052 ↓ 0.0 0 1

BitmapAnd (cost=9.53..9.53 rows=1 width=0) (actual time=0.052..0.052 rows=0 loops=1)

  • Buffers: shared hit=4
427. 0.022 0.022 ↑ 2.8 13 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.022..0.022 rows=13 loops=1)

  • Index Cond: (fli_41.type = 'quote'::text)
  • Buffers: shared hit=2
428. 0.028 0.028 ↓ 2.3 135 1

Bitmap Index Scan on florence_line_items_event_status_index (cost=0..4.73 rows=59 width=0) (actual time=0.028..0.028 rows=135 loops=1)

  • Index Cond: ((fli_41.migrated_metadata ->> 'event_status'::text) = 'open'::text)
  • Buffers: shared hit=2
429. 0.039 0.039 ↓ 0.0 0 13

Index Scan using florence_packages_pkey on florence_packages holder_19 (cost=0.28..8.29 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=13)

  • Index Cond: (holder_19.id = fli_41.florence_package_id)
  • Filter: (holder_19.status = ANY ('{out_for_pricing,revise_and_resubmit}'::text[]))
  • Buffers: shared hit=39
430. 0.030 1.149 ↑ 1.0 1 3

GroupAggregate (cost=13.58..13.61 rows=1 width=96) (actual time=0.383..0.383 rows=1 loops=3)

  • Group Key: ((fli_42.wbs_code_id)::text)
  • Buffers: shared hit=40
431. 0.009 1.119 ↓ 2.0 2 3

Sort (cost=13.58..13.59 rows=1 width=42) (actual time=0.373..0.373 rows=2 loops=3)

  • Sort Key: ((fli_42.wbs_code_id)::text)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=40
432. 0.020 1.110 ↓ 2.0 2 1

Bitmap Heap Scan on florence_line_items fli_42 (cost=9.53..13.57 rows=1 width=42) (actual time=1.1..1.11 rows=2 loops=1)

  • Filter: ((fli_42.amount_type <> 'dollar'::text) AND ((fli_42.migrated_metadata ->> 'commitment_contract_line_item_id'::text) IS NULL) AND ((fli_42.migrated_metadata ->> 'quote_id'::text) IS NULL) AND ((fli_42.migrated_metadata ->> 'manual_latest_cost_amount'::text) IS NULL) AND (fli_42.company_id = 7) AND ((fli_42.migrated_metadata ->> 'event_status'::text) = ANY ('{pending,closed,open}'::text[])))
  • Heap Blocks: exact=3
  • Buffers: shared hit=40
433. 0.003 1.090 ↓ 0.0 0 1

BitmapAnd (cost=9.53..9.53 rows=1 width=0) (actual time=1.09..1.09 rows=0 loops=1)

  • Buffers: shared hit=37
434. 0.021 0.021 ↑ 1.2 30 1

Bitmap Index Scan on index_florence_line_items_on_type (cost=0..4.55 rows=36 width=0) (actual time=0.021..0.021 rows=30 loops=1)

  • Index Cond: (fli_42.type = 'spend-change'::text)
  • Buffers: shared hit=3
435. 1.066 1.066 ↓ 200.9 11,856 1

Bitmap Index Scan on florence_line_items_commitment_potential_change_order_line_item (cost=0..4.73 rows=59 width=0) (actual time=1.066..1.066 rows=11,856 loops=1)

  • Index Cond: ((fli_42.migrated_metadata ->> 'commitment_potential_change_order_line_item_id'::text) IS NULL)
  • Buffers: shared hit=34
436.          

SubPlan (for Nested Loop)

437. 0.012 0.045 ↑ 1.0 1 3

Subquery Scan on column_60_has_more_than_one_uom (cost=1.77..1.8 rows=1 width=32) (actual time=0.015..0.015 rows=1 loops=3)

438. 0.009 0.033 ↑ 1.0 1 3

Aggregate (cost=1.77..1.79 rows=1 width=32) (actual time=0.011..0.011 rows=1 loops=3)

439. 0.012 0.024 ↓ 0.0 0 3

Subquery Scan on distinct_units_of_measure (cost=0.02..1.52 rows=100 width=24) (actual time=0.008..0.008 rows=0 loops=3)

440. 0.003 0.012 ↓ 0.0 0 3

HashAggregate (cost=0.02..0.52 rows=100 width=32) (actual time=0.004..0.004 rows=0 loops=3)

  • Group Key: unnest((array_agg(DISTINCT fli_7.amount_type)))
441. 0.009 0.009 ↓ 0.0 0 3

Result (cost=0..0.01 rows=1 width=32) (actual time=0.002..0.003 rows=0 loops=3)

442. 0.006 0.033 ↑ 1.0 1 3

Subquery Scan on column_61_has_more_than_one_uom (cost=1.77..1.8 rows=1 width=32) (actual time=0.011..0.011 rows=1 loops=3)

443. 0.012 0.027 ↑ 1.0 1 3

Aggregate (cost=1.77..1.79 rows=1 width=32) (actual time=0.009..0.009 rows=1 loops=3)

444. 0.009 0.015 ↓ 0.0 0 3

Subquery Scan on distinct_units_of_measure_1 (cost=0.02..1.52 rows=100 width=24) (actual time=0.005..0.005 rows=0 loops=3)

445. 0.003 0.006 ↓ 0.0 0 3

HashAggregate (cost=0.02..0.52 rows=100 width=32) (actual time=0.002..0.002 rows=0 loops=3)

  • Group Key: unnest((array_agg(DISTINCT fli_8.amount_type)))
446. 0.003 0.003 ↓ 0.0 0 3

Result (cost=0..0.01 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=3)

447. 0.009 0.057 ↑ 1.0 1 3

Subquery Scan on column_62_has_more_than_one_uom (cost=1.77..1.8 rows=1 width=32) (actual time=0.018..0.019 rows=1 loops=3)

448. 0.012 0.048 ↑ 1.0 1 3

Aggregate (cost=1.77..1.79 rows=1 width=32) (actual time=0.016..0.016 rows=1 loops=3)

449. 0.021 0.036 ↓ 0.0 0 3

Subquery Scan on distinct_units_of_measure_2 (cost=0.02..1.52 rows=100 width=24) (actual time=0.012..0.012 rows=0 loops=3)

450. 0.006 0.015 ↓ 0.0 0 3

HashAggregate (cost=0.02..0.52 rows=100 width=32) (actual time=0.005..0.005 rows=0 loops=3)

  • Group Key: unnest((array_agg(DISTINCT fli_10.amount_type)))
451. 0.009 0.009 ↓ 0.0 0 3

Result (cost=0..0.01 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=3)

452. 0.006 0.039 ↑ 1.0 1 3

Subquery Scan on column_63_has_more_than_one_uom (cost=1.78..1.81 rows=1 width=32) (actual time=0.013..0.013 rows=1 loops=3)

453. 0.012 0.033 ↑ 1.0 1 3

Aggregate (cost=1.78..1.79 rows=1 width=32) (actual time=0.011..0.011 rows=1 loops=3)

454. 0.012 0.021 ↓ 0.0 0 3

Subquery Scan on distinct_units_of_measure_3 (cost=0.02..1.53 rows=100 width=24) (actual time=0.007..0.007 rows=0 loops=3)

455. 0.003 0.009 ↓ 0.0 0 3

HashAggregate (cost=0.02..0.53 rows=100 width=32) (actual time=0.003..0.003 rows=0 loops=3)

  • Group Key: unnest(((array_agg(DISTINCT fli_11.amount_type)) || (array_agg(DISTINCT fli_12.amount_type))))
456. 0.006 0.006 ↓ 0.0 0 3

Result (cost=0..0.01 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=3)

457. 0.009 0.036 ↑ 1.0 1 3

Subquery Scan on column_63_has_more_than_one_uom_1 (cost=1.78..1.81 rows=1 width=32) (actual time=0.011..0.012 rows=1 loops=3)

458. 0.009 0.027 ↑ 1.0 1 3

Aggregate (cost=1.78..1.79 rows=1 width=32) (actual time=0.009..0.009 rows=1 loops=3)

459. 0.012 0.018 ↓ 0.0 0 3

Subquery Scan on distinct_units_of_measure_4 (cost=0.02..1.53 rows=100 width=24) (actual time=0.006..0.006 rows=0 loops=3)

460. 0.003 0.006 ↓ 0.0 0 3

HashAggregate (cost=0.02..0.53 rows=100 width=32) (actual time=0.002..0.002 rows=0 loops=3)

  • Group Key: unnest(((array_agg(DISTINCT fli_11.amount_type)) || (array_agg(DISTINCT fli_12.amount_type))))
461. 0.003 0.003 ↓ 0.0 0 3

Result (cost=0..0.01 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=3)

462. 0.009 0.036 ↑ 1.0 1 3

Subquery Scan on column_58_has_more_than_one_uom (cost=1.77..1.8 rows=1 width=32) (actual time=0.012..0.012 rows=1 loops=3)

463. 0.009 0.027 ↑ 1.0 1 3

Aggregate (cost=1.77..1.79 rows=1 width=32) (actual time=0.009..0.009 rows=1 loops=3)

464. 0.015 0.018 ↓ 0.0 0 3

Subquery Scan on distinct_units_of_measure_5 (cost=0.02..1.52 rows=100 width=24) (actual time=0.006..0.006 rows=0 loops=3)

465. 0.000 0.003 ↓ 0.0 0 3

HashAggregate (cost=0.02..0.52 rows=100 width=32) (actual time=0.001..0.001 rows=0 loops=3)

  • Group Key: unnest((array_agg(DISTINCT fli_30.amount_type)))
466. 0.003 0.003 ↓ 0.0 0 3

Result (cost=0..0.01 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=3)

467. 0.009 0.039 ↑ 1.0 1 3

Subquery Scan on column_54_has_more_than_one_uom (cost=1.78..1.81 rows=1 width=32) (actual time=0.013..0.013 rows=1 loops=3)

468. 0.009 0.030 ↑ 1.0 1 3

Aggregate (cost=1.78..1.79 rows=1 width=32) (actual time=0.01..0.01 rows=1 loops=3)

469. 0.009 0.021 ↓ 0.0 0 3

Subquery Scan on distinct_units_of_measure_6 (cost=0.02..1.53 rows=100 width=24) (actual time=0.007..0.007 rows=0 loops=3)

470. 0.006 0.012 ↓ 0.0 0 3

HashAggregate (cost=0.02..0.53 rows=100 width=32) (actual time=0.003..0.004 rows=0 loops=3)

  • Group Key: unnest(((array_agg(DISTINCT fli_33.amount_type)) || (array_agg(DISTINCT fli_34.amount_type))))
471. 0.006 0.006 ↑ 1.0 1 3

Result (cost=0..0.01 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=3)

472. 0.006 0.039 ↑ 1.0 1 3

Subquery Scan on column_54_has_more_than_one_uom_1 (cost=1.78..1.81 rows=1 width=32) (actual time=0.012..0.013 rows=1 loops=3)

473. 0.012 0.033 ↑ 1.0 1 3

Aggregate (cost=1.78..1.79 rows=1 width=32) (actual time=0.01..0.011 rows=1 loops=3)

474. 0.012 0.021 ↓ 0.0 0 3

Subquery Scan on distinct_units_of_measure_7 (cost=0.02..1.53 rows=100 width=24) (actual time=0.006..0.007 rows=0 loops=3)

475. 0.003 0.009 ↓ 0.0 0 3

HashAggregate (cost=0.02..0.53 rows=100 width=32) (actual time=0.003..0.003 rows=0 loops=3)

  • Group Key: unnest(((array_agg(DISTINCT fli_33.amount_type)) || (array_agg(DISTINCT fli_34.amount_type))))
476. 0.006 0.006 ↑ 1.0 1 3

Result (cost=0..0.01 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=3)

477. 0.009 0.042 ↑ 1.0 1 3

Subquery Scan on column_59_has_more_than_one_uom (cost=1.77..1.8 rows=1 width=32) (actual time=0.014..0.014 rows=1 loops=3)

478. 0.018 0.033 ↑ 1.0 1 3

Aggregate (cost=1.77..1.79 rows=1 width=32) (actual time=0.011..0.011 rows=1 loops=3)

479. 0.012 0.015 ↓ 0.0 0 3

Subquery Scan on distinct_units_of_measure_8 (cost=0.02..1.52 rows=100 width=24) (actual time=0.005..0.005 rows=0 loops=3)

480. 0.000 0.003 ↓ 0.0 0 3

HashAggregate (cost=0.02..0.52 rows=100 width=32) (actual time=0.001..0.001 rows=0 loops=3)

  • Group Key: unnest((array_agg(DISTINCT fli_42.amount_type)))
481. 0.003 0.003 ↓ 0.0 0 3

Result (cost=0..0.01 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=3)

482. 0.009 0.027 ↑ 1.0 1 3

Aggregate (cost=1.77..1.79 rows=1 width=32) (actual time=0.009..0.009 rows=1 loops=3)

483. 0.012 0.018 ↓ 0.0 0 3

Subquery Scan on distinct_units_of_measure_9 (cost=0.02..1.52 rows=100 width=24) (actual time=0.006..0.006 rows=0 loops=3)

484. 0.003 0.006 ↓ 0.0 0 3

HashAggregate (cost=0.02..0.52 rows=100 width=32) (actual time=0.001..0.002 rows=0 loops=3)

  • Group Key: unnest((array_agg(DISTINCT fli_7.amount_type)))
485. 0.003 0.003 ↓ 0.0 0 3

Result (cost=0..0.01 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=3)

486. 0.009 0.024 ↑ 1.0 1 3

Aggregate (cost=1.77..1.79 rows=1 width=32) (actual time=0.008..0.008 rows=1 loops=3)

487. 0.012 0.015 ↓ 0.0 0 3

Subquery Scan on distinct_units_of_measure_10 (cost=0.02..1.52 rows=100 width=24) (actual time=0.005..0.005 rows=0 loops=3)

488. 0.003 0.003 ↓ 0.0 0 3

HashAggregate (cost=0.02..0.52 rows=100 width=32) (actual time=0.001..0.001 rows=0 loops=3)

  • Group Key: unnest((array_agg(DISTINCT fli_8.amount_type)))
489. 0.000 0.000 ↓ 0.0 0 3

Result (cost=0..0.01 rows=1 width=32) (actual time=0..0 rows=0 loops=3)

490. 0.009 0.027 ↑ 1.0 1 3

Aggregate (cost=1.77..1.79 rows=1 width=32) (actual time=0.009..0.009 rows=1 loops=3)

491. 0.012 0.018 ↓ 0.0 0 3

Subquery Scan on distinct_units_of_measure_11 (cost=0.02..1.52 rows=100 width=24) (actual time=0.005..0.006 rows=0 loops=3)

492. 0.003 0.006 ↓ 0.0 0 3

HashAggregate (cost=0.02..0.52 rows=100 width=32) (actual time=0.002..0.002 rows=0 loops=3)

  • Group Key: unnest((array_agg(DISTINCT fli_10.amount_type)))
493. 0.003 0.003 ↓ 0.0 0 3

Result (cost=0..0.01 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=3)

494. 0.009 0.027 ↑ 1.0 1 3

Aggregate (cost=1.78..1.79 rows=1 width=32) (actual time=0.009..0.009 rows=1 loops=3)

495. 0.012 0.018 ↓ 0.0 0 3

Subquery Scan on distinct_units_of_measure_12 (cost=0.02..1.53 rows=100 width=24) (actual time=0.006..0.006 rows=0 loops=3)

496. 0.003 0.006 ↓ 0.0 0 3

HashAggregate (cost=0.02..0.53 rows=100 width=32) (actual time=0.002..0.002 rows=0 loops=3)

  • Group Key: unnest(((array_agg(DISTINCT fli_11.amount_type)) || (array_agg(DISTINCT fli_12.amount_type))))
497. 0.003 0.003 ↓ 0.0 0 3

Result (cost=0..0.01 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=3)

498. 0.006 0.024 ↑ 1.0 1 3

Aggregate (cost=1.77..1.79 rows=1 width=32) (actual time=0.008..0.008 rows=1 loops=3)

499. 0.015 0.018 ↓ 0.0 0 3

Subquery Scan on distinct_units_of_measure_13 (cost=0.02..1.52 rows=100 width=24) (actual time=0.005..0.006 rows=0 loops=3)

500. 0.000 0.003 ↓ 0.0 0 3

HashAggregate (cost=0.02..0.52 rows=100 width=32) (actual time=0.001..0.001 rows=0 loops=3)

  • Group Key: unnest((array_agg(DISTINCT fli_30.amount_type)))
501. 0.003 0.003 ↓ 0.0 0 3

Result (cost=0..0.01 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=3)

502. 0.009 0.033 ↑ 1.0 1 3

Aggregate (cost=1.78..1.79 rows=1 width=32) (actual time=0.011..0.011 rows=1 loops=3)

503. 0.012 0.024 ↓ 0.0 0 3

Subquery Scan on distinct_units_of_measure_14 (cost=0.02..1.53 rows=100 width=24) (actual time=0.008..0.008 rows=0 loops=3)

504. 0.003 0.012 ↓ 0.0 0 3

HashAggregate (cost=0.02..0.53 rows=100 width=32) (actual time=0.004..0.004 rows=0 loops=3)

  • Group Key: unnest(((array_agg(DISTINCT fli_33.amount_type)) || (array_agg(DISTINCT fli_34.amount_type))))
505. 0.009 0.009 ↑ 1.0 1 3

Result (cost=0..0.01 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=3)

506. 0.009 0.024 ↑ 1.0 1 3

Aggregate (cost=1.77..1.79 rows=1 width=32) (actual time=0.008..0.008 rows=1 loops=3)

507. 0.009 0.015 ↓ 0.0 0 3

Subquery Scan on distinct_units_of_measure_15 (cost=0.02..1.52 rows=100 width=24) (actual time=0.005..0.005 rows=0 loops=3)

508. 0.003 0.006 ↓ 0.0 0 3

HashAggregate (cost=0.02..0.52 rows=100 width=32) (actual time=0.002..0.002 rows=0 loops=3)

  • Group Key: unnest((array_agg(DISTINCT fli_42.amount_type)))
509. 0.003 0.003 ↓ 0.0 0 3

Result (cost=0..0.01 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=3)

510. 0.058 41.622 ↓ 3.0 3 1

Sort (cost=1.3..1.3 rows=1 width=3,694) (actual time=41.622..41.622 rows=3 loops=1)

  • Sort Key: (natural_sort(raw.biller_type)), (natural_sort((raw.biller)::text)), (natural_sort(raw.root_cost_code)), (natural_sort(raw.cost_code)), raw.category_id, (natural_sort(raw.budget_row_id))
  • Sort Method: quicksort Memory: 27kB
  • Buffers: shared hit=1,970
511. 1.027 41.564 ↓ 3.0 3 1

WindowAgg (cost=0..1.29 rows=1 width=3,694) (actual time=41.417..41.564 rows=3 loops=1)

  • Buffers: shared hit=1,970
512. 40.537 40.537 ↓ 3.0 3 1

CTE Scan on rawdatacolumns raw (cost=0..0.02 rows=1 width=3,502) (actual time=38.665..40.537 rows=3 loops=1)

  • Buffers: shared hit=1,967
Planning time : 143.094 ms
Execution time : 50.049 ms