Login
[x]
Log in using an account from:
Fedora Account System
Red Hat Associate
Red Hat Customer
Or login using a Red Hat Bugzilla account
Forgot Password
Login:
Hide Forgot
Create an Account
Red Hat Bugzilla – Attachment 915414 Details for
Bug 794759
Pool Family page fires an outrageous number of SQL queries
[?]
New
Simple Search
Advanced Search
My Links
Browse
Requests
Reports
Current State
Search
Tabular reports
Graphical reports
Duplicates
Other Reports
User Changes
Plotly Reports
Bug Status
Bug Severity
Non-Defaults
|
Product Dashboard
Help
Page Help!
Bug Writing Guidelines
What's new
Browser Support Policy
5.0.4.rh83 Release notes
FAQ
Guides index
User guide
Web Services
Contact
Legal
This site requires JavaScript to be enabled to function correctly, please enable it.
Comment
comment_4456143.txt (text/plain), 172.01 KB, created by
Matt Wagner
on 2012-02-17 14:51:35 UTC
(
hide
)
Description:
Comment
Filename:
MIME Type:
Creator:
Matt Wagner
Created:
2012-02-17 14:51:35 UTC
Size:
172.01 KB
patch
obsolete
>Excluding the initialization that goes on because I'm in development mode, here is what shows up in my log when I click on the Pool Families page: > > > SQL (6.0ms) SELECT COUNT(*) FROM "catalogs" WHERE ("catalogs".pool_id = 1) > Catalog Load (0.4ms) SELECT "catalogs".* FROM "catalogs" WHERE ("catalogs".pool_id = 1) LIMIT 1 > CACHE (0.0ms) SELECT "catalogs".* FROM "catalogs" WHERE ("catalogs".pool_id = 1) LIMIT 1 > SQL (0.3ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > Quota Load (0.3ms) SELECT "quotas".* FROM "quotas" WHERE "quotas"."id" = 9 LIMIT 1 > Instance Load (0.4ms) SELECT "instances".* FROM "instances" WHERE ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > SQL (0.3ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > SQL (0.4ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > SQL (0.3ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > SQL (0.2ms) SELECT COUNT(*) FROM "catalogs" WHERE ("catalogs".pool_id = 2) > SQL (0.1ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > Quota Load (0.3ms) SELECT "quotas".* FROM "quotas" WHERE "quotas"."id" = 12 LIMIT 1 > Instance Load (0.2ms) SELECT "instances".* FROM "instances" WHERE ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > SQL (0.5ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > SQL (0.3ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > SQL (0.3ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > SQL (0.3ms) SELECT COUNT(*) FROM "catalogs" WHERE ("catalogs".pool_id = 4) > SQL (0.2ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > Quota Load (0.2ms) SELECT "quotas".* FROM "quotas" WHERE "quotas"."id" = 13 LIMIT 1 > Instance Load (0.2ms) SELECT "instances".* FROM "instances" WHERE ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > SQL (0.2ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > SQL (0.2ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > SQL (0.2ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > SQL (0.3ms) SELECT COUNT(*) FROM "catalogs" WHERE ("catalogs".pool_id = 5) > SQL (0.1ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > Quota Load (0.2ms) SELECT "quotas".* FROM "quotas" WHERE "quotas"."id" = 14 LIMIT 1 > Instance Load (0.2ms) SELECT "instances".* FROM "instances" WHERE ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > SQL (0.2ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > SQL (0.3ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > SQL (0.2ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > SQL (0.2ms) SELECT COUNT(*) FROM "catalogs" WHERE ("catalogs".pool_id = 6) > Quota Load (0.2ms) SELECT "quotas".* FROM "quotas" WHERE "quotas"."id" = 1 LIMIT 1 > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 1) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 2) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 4) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 5) > CACHE (0.0ms) SELECT COUNT(*) FROM "deployments" WHERE ("deployments".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('running', 'shutting_down') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('new', 'pending') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > CACHE (0.0ms) SELECT COUNT(*) FROM "instances" WHERE "instances"."state" IN ('create_failed', 'error', 'vanished') AND ("instances".pool_id = 6) > Pool Load (0.4ms) SELECT "pools".* FROM "pools" WHERE ("pools".pool_family_id = 3) > > > >That seems... excessive.
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=915414">View the attachment on a separate page</a>.</b>
View Attachment As Raw
Actions:
View
Attachments on
bug 794759
: 915414