PerfSight Demo Workspace
Falcon Retail Group
Database-level analysis of heavy ERP workloads and suspected root causes.
| Query | Execution | Rows scanned | Est. cost | Tables / hints | Suspected cause | Recommendation | Severity |
|---|---|---|---|---|---|---|---|
| Sales summary aggregate | 2.1s | 640,000 | 72 | sales_order_line, res_partner | Repeated aggregates with low selectivity filters. | Introduce cached rollups for daily sales KPIs. | high |
| Inventory valuation ledger | 4.1s | 1,240,000 | 89 | stock_move_line, product_product | Full scans on movement date and product filters. | Index product_id + movement_date and precompute valuation table. | critical |
| Accounting aging join | 3.6s | 980,000 | 84 | account_move_line, account_account | Multi-table joins without composite indexes. | Add composite indexes and summarize in nightly batch. | high |
| CRM pipeline snapshot | 2.4s | 480,000 | 66 | crm_lead, crm_stage | Dashboard refresh interval too aggressive. | Cache pipeline cards and reduce refresh frequency. | medium |
| Helpdesk ticket metrics | 1.9s | 520,000 | 58 | helpdesk_ticket, helpdesk_stage | Repeated scans on large unfiltered ranges. | Index stage + create_date and add caching. | medium |