ledgers

Detailed performance metrics and schema analytics.

Configure Archival
Table Size
245.8 GB

+15.2% vs Last Month

Deadlocks
12

Last 30 Days execution window

Slow Queries
58

Averaging 2.4s execution time

Usage Frequency
Low
High Archival Priority
Table Storage Growth (GB)
Historical data size progression over the last 6 months.
Missing Indexes
[transaction_id]
CRITICAL

Missing non-clustered index detected on primary lookup field.

[created_at, status]
WARNING

Composite index recommended to improve archival query scans.

Slow Query Logs
SELECT TOP 100 * FROM...10 min ago
4.8s
UPDATE transactions SET...45 min ago
3.2s
DELETE FROM transactions WHERE...2 hours ago
12.5s