What causes a query to wait in pending? What resources can be increased to lower this time?
For context this is a kubernetes deployment.
What causes a query to wait in pending? What resources can be increased to lower this time?
For context this is a kubernetes deployment.
@millius, Pending means the query is waiting to be planned. Sixteen seconds seems somewhat high.
I suspect that bullet #2 may be the key. There are about 12 jobs submitted in a 16 second window. Each gets a progressively longer pending time.
What resource can be expanded to improve the pending time?
The number of cores available to the master coordinator.