If customer sees queries on a specific table slow, I would ask them to collect these 2 system tables by running these 2 queries:
SELECT * FROM system.tables WHERE table_name = 'your_table_name';
SELECT FROM system.compactor WHERE table_name = 'your_table_name';
If many tables in the system have the issues, also collect size and number of partitions for all tables
SELECT table_name, COUNT() as partition_count,MAX(last_new_file_created_at) as last_new_file_created_at,SUM(total_size_mb) as total_size_mb
FROM system.partitions
GROUP BY table_name;
See the system table link
Querier, compactor and ingester dashboards are also important. Customers want to set them up and when have things happen, screen shot those for us.
If customer sees queries on a specific table slow, I would ask them to collect these 2 system tables by running these 2 queries: SELECT * FROM system.tables WHERE table_name = 'your_table_name';
SELECT FROM system.compactor WHERE table_name = 'your_table_name'; If many tables in the system have the issues, also collect size and number of partitions for all tables SELECT table_name, COUNT() as partition_count,MAX(last_new_file_created_at) as last_new_file_created_at,SUM(total_size_mb) as total_size_mb FROM system.partitions GROUP BY table_name; See the system table link Querier, compactor and ingester dashboards are also important. Customers want to set them up and when have things happen, screen shot those for us.
From https://influxdata.slack.com/archives/C04K1QRSDFG/p1720794940951799?thread_ts=1720729179.397319&cid=C04K1QRSDFG