Make management command to run and output data-shape on production

[exalate-issue-sync]

After creating some data shape observability scripts in https://fecgov.atlassian.net/browse/FECFILE-2208, create management commands that can be run on production to run them and output their values in the prod logs

QA Notes

null

DEV Notes

null

Design

null

See full ticket and images here: FECFILE-2900

Pull Request: #1915

[exalate-issue-sync]

Dan Fowlkes commented: Deployed to DEV and run.

Running command:

{noformat}danguyf@fecbuntu$ cf rt fecfile-web-api --command "python django-backend/manage.py get_overview" --name "overview test"
Creating task for app fecfile-web-api in org fec-fecfile / space dev as dfowlkes@precision-solutions.com...
Task has been submitted successfully for execution.
OK

task name: overview test
task id: 419
OK

danguyf@fecbuntu${noformat}

Log output:

{noformat}danguyf@fecbuntu$ cf logs fecfile-web-api | grep "overview test"
2026-03-06T11:47:51.97-0500 [APP/TASK/overview test/0] OUT Invoking pre-start scripts.
2026-03-06T11:47:52.09-0500 [APP/TASK/overview test/0] OUT Invoking start command.
2026-03-06T11:47:53.70-0500 [APP/TASK/overview test/0] OUT STARTING get_overview command
2026-03-06T11:47:53.76-0500 [APP/TASK/overview test/0] OUT {"event": "Number of committees: 64 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 43, "level": "info"}
2026-03-06T11:47:53.76-0500 [APP/TASK/overview test/0] OUT {"event": "Number of users: 39 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 47, "level": "info"}
2026-03-06T11:47:53.77-0500 [APP/TASK/overview test/0] OUT {"event": "Number of reports: 300 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 51, "level": "info"}
2026-03-06T11:47:53.96-0500 [APP/TASK/overview test/0] OUT {"event": "Number of reports per committee: ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 73, "level": "info"}
2026-03-06T11:47:53.96-0500 [APP/TASK/overview test/0] OUT {"event": " 1st quartile: 0 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:47:53.96-0500 [APP/TASK/overview test/0] OUT {"event": " 2nd quartile: 1 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:47:53.96-0500 [APP/TASK/overview test/0] OUT {"event": " 3rd quartile: 7 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:47:53.96-0500 [APP/TASK/overview test/0] OUT {"event": " Max: 44 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:47:53.96-0500 [APP/TASK/overview test/0] OUT {"event": " Mean: 4.6875 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:47:55.32-0500 [APP/TASK/overview test/0] OUT {"event": "Number of transactions per committee: ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 101, "level": "info"}
2026-03-06T11:47:55.32-0500 [APP/TASK/overview test/0] OUT {"event": " 1st quartile: 0 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:47:55.32-0500 [APP/TASK/overview test/0] OUT {"event": " 2nd quartile: 0 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:47:55.32-0500 [APP/TASK/overview test/0] OUT {"event": " 3rd quartile: 10 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:47:55.32-0500 [APP/TASK/overview test/0] OUT {"event": " Max: 25495 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:47:55.32-0500 [APP/TASK/overview test/0] OUT {"event": " Mean: 509.65625 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:47:55.32-0500 [APP/TASK/overview test/0] OUT {"event": " The largest committee is C00100297 with 25495 transactions", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 103, "level": "info"}
2026-03-06T11:48:01.80-0500 [APP/TASK/overview test/0] OUT {"event": "Number of transactions per report: ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 121, "level": "info"}
2026-03-06T11:48:01.80-0500 [APP/TASK/overview test/0] OUT {"event": " 1st quartile: 0 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:48:01.80-0500 [APP/TASK/overview test/0] OUT {"event": " 2nd quartile: 2 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:48:01.80-0500 [APP/TASK/overview test/0] OUT {"event": " 3rd quartile: 17 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:48:01.80-0500 [APP/TASK/overview test/0] OUT {"event": " Max: 25006 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:48:01.80-0500 [APP/TASK/overview test/0] OUT {"event": " Mean: 108.63 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:32.01-0500 [APP/TASK/overview test/0] OUT {"event": "Number of transactions per contact: ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 149, "level": "info"}
2026-03-06T11:49:32.01-0500 [APP/TASK/overview test/0] OUT {"event": " 1st quartile: 0 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:32.02-0500 [APP/TASK/overview test/0] OUT {"event": " 2nd quartile: 0 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:32.02-0500 [APP/TASK/overview test/0] OUT {"event": " 3rd quartile: 2 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:32.02-0500 [APP/TASK/overview test/0] OUT {"event": " Max: 25433 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:32.02-0500 [APP/TASK/overview test/0] OUT {"event": " Mean: 38.926540284360186 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": "Transaction types breakdown: ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 159, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " INDIVIDUAL_RECEIPT: 28882 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " CONDUIT_EARMARK_RECEIPT_DEPOSITED: 4 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " CONDUIT_EARMARK_OUT_DEPOSITED: 4 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " PARTNERSHIP_RECEIPT: 11 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " EARMARK_RECEIPT: 5 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " EARMARK_MEMO: 5 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " IN_KIND_RECEIPT: 9 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " IN_KIND_OUT: 9 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " TRIBAL_RECEIPT: 3 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " PARTNERSHIP_ATTRIBUTION: 2 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " RECEIPT_FROM_UNREGISTERED_ENTITY: 1 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " PARTY_RECEIPT: 11 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " PARTY_IN_KIND_RECEIPT: 1 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " PARTY_IN_KIND_OUT: 1 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " PAC_CONDUIT_EARMARK_RECEIPT_DEPOSITED: 3 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " PAC_CONDUIT_EARMARK_OUT_DEPOSITED: 3 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " PAC_RECEIPT: 2 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " PAC_EARMARK_RECEIPT: 2 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " PAC_EARMARK_MEMO: 2 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " JOINT_FUNDRAISING_TRANSFER: 28 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " PARTNERSHIP_JF_TRANSFER_MEMO: 12 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " PARTNERSHIP_ATTRIBUTION_JF_TRANSFER_MEMO: 16 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " INDIVIDUAL_JF_TRANSFER_MEMO: 8 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " PAC_JF_TRANSFER_MEMO: 5 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " TRANSFER: 3 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " IN_KIND_TRANSFER: 1 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " IN_KIND_TRANSFER_OUT: 1 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " LOAN_REPAYMENT_RECEIVED: 7 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " JF_TRANSFER_NATIONAL_PARTY_HEADQUARTERS_ACCOUNT: 3 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " OTHER_RECEIPT: 3 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " OPERATING_EXPENDITURE: 2801 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " OPERATING_EXPENDITURE_PAYMENT_TO_PAYROLL: 4 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " OPERATING_EXPENDITURE_PAYMENT_TO_PAYROLL_MEMO: 4 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " OPERATING_EXPENDITURE_CREDIT_CARD_PAYMENT: 2 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " CONTRIBUTION_TO_CANDIDATE: 26 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " CONTRIBUTION_TO_OTHER_COMMITTEE: 3 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " IN_KIND_CONTRIBUTION_TO_CANDIDATE: 4 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " CONTRIBUTION_TO_OTHER_COMMITTEE_VOID: 1 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " LOAN_REPAYMENT_MADE: 9 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " REFUND_INDIVIDUAL_CONTRIBUTION: 3 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " OTHER_DISBURSEMENT: 4 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " OTHER_DISBURSEMENT_CREDIT_CARD_PAYMENT: 2 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " OTHER_DISBURSEMENT_CREDIT_CARD_PAYMENT_MEMO: 1 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " FEDERAL_ELECTION_ACTIVITY_100PCT_PAYMENT: 1 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " FEDERAL_ELECTION_ACTIVITY_CREDIT_CARD_PAYMENT: 3 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " FEDERAL_ELECTION_ACTIVITY_STAFF_REIMBURSEMENT: 1 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " FEDERAL_ELECTION_ACTIVITY_PAYMENT_TO_PAYROLL: 1 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " LOAN_RECEIVED_FROM_INDIVIDUAL: 92 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " LOAN_RECEIVED_FROM_BANK: 123 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " LOAN_BY_COMMITTEE: 83 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " DEBT_OWED_BY_COMMITTEE: 80 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " DEBT_OWED_TO_COMMITTEE: 24 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " INDEPENDENT_EXPENDITURE_VOID: 2 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " INDEPENDENT_EXPENDITURE: 62 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " INDEPENDENT_EXPENDITURE_CREDIT_CARD_PAYMENT: 8 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " INDEPENDENT_EXPENDITURE_STAFF_REIMBURSEMENT: 2 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " MULTISTATE_INDEPENDENT_EXPENDITURE: 3 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " INDEPENDENT_EXPENDITURE_PAYMENT_TO_PAYROLL: 1 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " COORDINATED_PARTY_EXPENDITURE: 24 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " COORDINATED_PARTY_EXPENDITURE_VOID: 3 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " LOAN_RECEIVED_FROM_INDIVIDUAL_RECEIPT: 20 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " LOAN_RECEIVED_FROM_BANK_RECEIPT: 18 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " C1_LOAN_AGREEMENT: 19 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " C2_LOAN_GUARANTOR: 121 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " LOAN_MADE: 11 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " INDEPENDENT_EXPENDITURE_CREDIT_CARD_PAYMENT_MEMO: 4 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": " INDEPENDENT_EXPENDITURE_STAFF_REIMBURSEMENT_MEMO: 1 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 39, "level": "info"}
2026-03-06T11:49:42.35-0500 [APP/TASK/overview test/0] OUT {"event": "Transaction tiers breakdown: ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 172, "level": "info"}
2026-03-06T11:49:42.38-0500 [APP/TASK/overview test/0] OUT {"event": " Tier I: 31525 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 176, "level": "info"}
2026-03-06T11:49:42.41-0500 [APP/TASK/overview test/0] OUT {"event": " Tier II: 796 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 176, "level": "info"}
2026-03-06T11:49:42.43-0500 [APP/TASK/overview test/0] OUT {"event": " Tier III: 297 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 176, "level": "info"}
2026-03-06T11:49:42.43-0500 [APP/TASK/overview test/0] OUT {"event": "Carryover transactions: ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 180, "level": "info"}
2026-03-06T11:49:42.43-0500 [APP/TASK/overview test/0] OUT {"event": " ScheduleC: 947 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 182, "level": "info"}
2026-03-06T11:49:42.44-0500 [APP/TASK/overview test/0] OUT {"event": " ScheduleC2: 214 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 182, "level": "info"}
2026-03-06T11:49:42.44-0500 [APP/TASK/overview test/0] OUT {"event": " ScheduleD: 2092 ", "pathname": "/home/vcap/app/django-backend/fecfiler/devops/utils/common_queries.py", "lineno": 182, "level": "info"}
2026-03-06T11:49:42.44-0500 [APP/TASK/overview test/0] OUT FINISHED get_overview command
2026-03-06T11:49:42.75-0500 [APP/TASK/overview test/0] OUT Exit status 0{noformat}

I recommend that if tailing the logs life you grep on your task name. Some operations take time to compute so you will otherwise likely have unrelated log messages mixed in.

In OpenSearch, I filtered with:

!image-20260306-165958.png|width=652,alt="image-20260306-165958.png"!

and got back data like:

!image-20260306-170214.png|width=1053,alt="image-20260306-170214.png"!

[exalate-issue-sync]

Dan Fowlkes commented: Lot easier to read in OpenSearch if you hide some columns, reverse the time sort, and go into Developer Tools to allow the results to fill more vertical space:

!image-20260306-171545.png|width=1068,alt="image-20260306-171545.png"!

Getting it from {{cf logs}} in the console is still the best experience IMHO.

[exalate-issue-sync]

Shelly Wise commented: No QA needed on this ticket per DEV.

Moved to Stage Ready.