distribution: local
vectorized: true

• limit
│ count: 16
│
└── • filter
    │ filter: ((auto_restart_policy = 'best_effort') AND (((time_last_auto_restarted IS NULL) OR ((auto_restart_cooldown IS NOT NULL) AND (time_last_auto_restarted <= ('2024-09-18 22:20:47.535126+00:00' - auto_restart_cooldown)))) OR ((auto_restart_cooldown IS NULL) AND (time_last_auto_restarted <= '2024-09-18 21:20:47.535126+00:00')))) AND (updater_id IS NULL)
    │
    └── • index join
        │ table: instance@instance_pkey
        │
        └── • scan
              missing stats
              table: instance@lookup_instance_by_state (partial index)
              spans: [/'failed' - /'failed']

index recommendations: 1
1. type: index creation
   SQL command: CREATE INDEX ON instance (auto_restart_policy) STORING (name, description, time_created, time_modified, time_deleted, project_id, user_data, time_state_updated, state_generation, active_propolis_id, target_propolis_id, migration_id, ncpus, memory, hostname, updater_id, updater_gen, state, time_last_auto_restarted, auto_restart_cooldown);