Details
-
Improvement
-
Resolution: Fixed
-
Minor
-
None
-
None
-
None
Description
On our instance this table has about 112,000 rows. Every time queries for the device graphs were causing a scan of the table.
Check out the before and after. Adding the index lowered the number of rows scanned from 112K to 15.
SELECT `graph` FROM `device_graphs` WHERE `device_id` = '2745';
|
create index device_graphs_device_id ON device_graphs(device_id);
|
Attachments
Activity
Workflow | Original: classic default workflow [ 11235 ] | New: Observium workflow [ 13858 ] |
Status | Original: Resolved [ 5 ] | New: Closed [ 6 ] |
Resolution | New: Fixed [ 1 ] | |
Status | Original: Open [ 1 ] | New: Resolved [ 5 ] |
fixed in r4629