Index Usage — ACME-192-0-2-136-PGLAB-5432

Index reportsSQL Server 13ACME-203-0-113-170 ACME-198-51-100-45 ACME-192-0-2-15-MSSQL25-1433 ACME-198-51-100-66 ACME-192-0-2-136-MSSQLLAB-1433 ACME-198-51-100-210 ACME-198-51-100-60 ACME-192-0-2-243 ACME-203-0-113-99 ACME-203-0-113-69 ACME-192-0-2-97 ACME-192-0-2-242 ACME-203-0-113-155Oracle 3ACME-192-0-2-136-ORALAB-1521 ACME-192-0-2-120 ACME-198-51-100-125PostgreSQL 2ACME-192-0-2-15-PG-5433ACME-192-0-2-136-PGLAB-5432

Host: 192.0.2.136

Collected: 2026-10-19T18:00:23Z

Server dashboard: http://192.0.2.15:8080/report_dba/server-metrics.html?server=ACME-192-0-2-136-PGLAB-5432

Fleet inventory: http://192.0.2.15:8080/report_dba/database-inventory.html

Metric	Count	Meaning
indexes_total	51	every index on a user table
used	2	had a seek, scan or lookup
unused	0	written but never read
cold	49	never read AND never written since restart
disabled	0	ALTER INDEX ... DISABLE was run
droppable	9	nonclustered, not unique, no constraint, never read

By database

Database	Total	Cold	Disabled	Droppable	Recommend action
WAREHOUSE	50	49	0	9	review the drop candidates above

Drop candidates (9)

Nonclustered, not unique, not enforcing a constraint, never read. Highest write cost first — that is what the index is charging for.

Index	last_read	State	Recommend action
WAREHOUSE.drs.MeterResult.IX_PricingDaily	never	COLD	review, then DROP
WAREHOUSE.drs.MeterResult.IX_SupplierAudit	never	COLD	review, then DROP
WAREHOUSE.drs.InvoiceHistory.IX_AssetHeader	never	COLD	review, then DROP
WAREHOUSE.drs.AssetQueue.IX_ReconcileLog	never	COLD	review, then DROP
WAREHOUSE.drs.MeterResult.IX_TicketSummary	never	COLD	review, then DROP
WAREHOUSE.drs.SettlementHeader.IX_SettlementStaging	never	COLD	review, then DROP
WAREHOUSE.drs.SettlementHeader.IX_RouteStaging	never	COLD	review, then DROP
WAREHOUSE.drs.TerritorySnapshot.IX_SalesStatus	never	COLD	review, then DROP
WAREHOUSE.drs.TerritorySnapshot.IX_SalesStaging	never	COLD	review, then DROP

All indexes (51)

Every index on the instance, including the healthy ones — the answer to "is THIS index used?" has to be here, not only the problems.

Index	id	Type	Uniq	PK	Constr	Filt	seeks	updates	last_read	last_stats_update	State	Recommend action
WAREHOUSE.drs.InvoiceHistory.IX_AssetHeader	16440	btree					0	0	never	never	COLD	review, then DROP
WAREHOUSE.drs.InvoiceHistory.PK_ShipmentLine	16438	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
WAREHOUSE.drs.OrdersLine.IX_CatalogHeader	16421	btree	Y	Y			11	12	2026-10-15T03:04:20.802645+00:00	never	USED	KEEP — primary key
WAREHOUSE.drs.AssetQueue.IX_ReconcileLog	16457	btree					0	0	never	never	COLD	review, then DROP
WAREHOUSE.drs.AssetQueue.PK_WarehouseLog	16455	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
WAREHOUSE.drs.RouteStatus.PK_ForecastLine	16892	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
WAREHOUSE.drs.AssetSnapshot.PK_BatchHistory	16477	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
WAREHOUSE.drs.AssetSnapshot.UQ_ForecastSummary	16479	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
WAREHOUSE.drs.StaffingLog.PK_SettlementDetail	16913	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
WAREHOUSE.drs.StaffingLog.UQ_PayrollDaily	16930	btree	Y			Y	0	0	never	never	COLD	review carefully — unique
WAREHOUSE.drs.StaffingLog.UQ_PayrollLine	16931	btree	Y			Y	0	0	never	never	COLD	review carefully — unique
WAREHOUSE.drs.BatchStaging.PK_SettlementResult	16553	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
WAREHOUSE.drs.BatchStaging.UQ_CampaignLog	16570	btree	Y			Y	0	0	never	never	COLD	review carefully — unique
WAREHOUSE.drs.BatchStaging.UQ_InvoiceLog	16571	btree	Y			Y	0	0	never	never	COLD	review carefully — unique
WAREHOUSE.drs.ShiftDetail.PK_ClaimHeader	16679	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
WAREHOUSE.drs.ShiftDetail.UQ_ContractLine	16696	btree	Y			Y	0	0	never	never	COLD	review carefully — unique
WAREHOUSE.drs.ShiftDetail.UQ_PolicyDaily	16697	btree	Y			Y	0	0	never	never	COLD	review carefully — unique
WAREHOUSE.drs.CustomerArchive.PK_ShipmentDetail	16599	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
WAREHOUSE.drs.CustomerArchive.UQ_MeterStatus	16601	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
WAREHOUSE.drs.BatchSnapshot.PK_CampaignResult	16970	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
WAREHOUSE.drs.CampaignLine.PK_QuotaSnapshot	16990	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
WAREHOUSE.drs.BatchLog.IX_MeterSummary	16729	btree	Y				0	0	never	never	COLD	review carefully — unique
WAREHOUSE.drs.BatchLog.PK_ForecastHistory	16722	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
WAREHOUSE.drs.TerritorySnapshot.IX_SalesStaging	16957	btree					0	0	never	never	COLD	review, then DROP
WAREHOUSE.drs.TerritorySnapshot.IX_SalesStatus	16958	btree					0	0	never	never	COLD	review, then DROP
WAREHOUSE.drs.TerritorySnapshot.PK_MeterSummary	16950	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
WAREHOUSE.drs.TerritorySnapshot.UQ_ShiftMonthly	16959	btree	Y			Y	0	0	never	never	COLD	review carefully — unique
WAREHOUSE.drs.CatalogHistory.PK_PolicyDaily	16495	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
WAREHOUSE.drs.CatalogHistory.UQ_PayrollSummary	16497	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
WAREHOUSE.drs.RouteHeader.PK_TerritoryArchive	16738	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
WAREHOUSE.drs.LedgerStatus.IX_MeterArchive	16780	btree	Y				0	0	never	never	COLD	review carefully — unique
WAREHOUSE.drs.LedgerStatus.PK_ClaimStaging	16768	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
WAREHOUSE.drs.TerritoryStatus.IX_ClaimSnapshot	16797	btree	Y				0	0	never	never	COLD	review carefully — unique
WAREHOUSE.drs.TerritoryStatus.PK_BookingQueue	16790	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
WAREHOUSE.drs.SettlementHeader.IX_SettlementStaging	16824	btree					0	0	never	never	COLD	review, then DROP
WAREHOUSE.drs.SettlementHeader.IX_RouteStaging	16825	btree					0	0	never	never	COLD	review, then DROP
WAREHOUSE.drs.SettlementHeader.PK_InvoiceDaily	16817	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
WAREHOUSE.drs.MeterResult.IX_TicketSummary	16848	btree					0	0	never	never	COLD	review, then DROP
WAREHOUSE.drs.MeterResult.IX_PricingDaily	16849	btree					0	0	never	never	COLD	review, then DROP
WAREHOUSE.drs.MeterResult.IX_SupplierAudit	16850	btree					0	0	never	never	COLD	review, then DROP
WAREHOUSE.drs.MeterResult.PK_PricingLine	16846	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
WAREHOUSE.drs.AssetEntry.PK_ContractMonthly	16509	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
WAREHOUSE.drs.AssetEntry.UQ_RosterAudit	16511	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
WAREHOUSE.drs.ContractArchive.PK_ReconcileDetail	16628	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
WAREHOUSE.drs.CustomerStatus.IX_SettlementHeader	17003	btree	Y				0	0	never	never	COLD	review carefully — unique
WAREHOUSE.drs.CustomerStatus.PK_TerritoryMonthly	16533	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
WAREHOUSE.drs.CustomerStatus.UQ_SettlementLine	16535	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
WAREHOUSE.drs.CustomerStatus.UQ_WarehouseSummary	16537	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
WAREHOUSE.drs.AssetSummary.PK_CatalogHistory	16641	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
WAREHOUSE.drs.ClaimArchive.PK_StaffingHistory	16653	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
QUOTATest.public.TicketHistory.IX_SettlementLine	16401	btree	Y	Y			76990	100980	2026-10-07T10:38:41.961066+00:00	2026-10-07 09:13:12	USED	KEEP — primary key