| Serge Bazanski | e59e6e1 | 2023-06-13 16:11:43 +0200 | [diff] [blame] | 1 | -- Used by the agent gRPC server to retrieve agent information by public key. |
| 2 | CREATE INDEX agent_public_key_idx |
| 3 | ON machine_agent_started (agent_public_key) |
| 4 | INCLUDE (agent_started_at); |
| 5 | |
| 6 | -- Used by queries which require a live session. |
| 7 | CREATE INDEX session_id_deadline_idx |
| 8 | ON sessions (session_id, session_deadline) |
| 9 | INCLUDE (session_component_name, session_runtime_info, session_Created_at, session_interval_seconds); |
| 10 | |
| 11 | -- Used by work retrieval/scheduling queries to exclude machines that have a given process backed off. |
| 12 | CREATE INDEX process_machine_id_idx |
| 13 | ON work_backoff (process, machine_id) |
| 14 | INCLUDE (until); |