curl -X POST <http://127.0.0.1:8080/pdb/admin/v1/cmd|http://127.0.0.1:8080/pdb/admin/v1/cmd> -H 'Accept: application/json' -H 'Content-Type: application/json' -d '{"command": "clean", "version": 1, "payload": ["other"] }'

other

EXPLAIN ANALYZE CREATE TABLE bad_kitties AS
SELECT
    resource
FROM
    resource_params_cache
EXCEPT
SELECT
    resource
FROM
    catalog_resources;

CREATE INDEX bad_kitties_idx ON bad_kitties (resource);

EXPLAIN ANALYZE
WITH loosers AS (
    SELECT
        *
    FROM
        bad_kitties
    ORDER BY
        resource
    LIMIT 250000
), dead_loosers AS (
    DELETE FROM bad_kitties AS bk
    USING
        loosers AS l
    WHERE
        bk.resource = l.resource
)
DELETE FROM resource_params_cache AS rpc
USING
    loosers AS l
WHERE
    rpc.resource = l.resource;

EXPLAIN ANALYZE CREATE TABLE bad_kitties AS
SELECT
    resource
FROM
    resource_params_cache
EXCEPT
SELECT
    resource
FROM
    catalog_resources;

CREATE INDEX bad_kitties_idx ON bad_kitties (resource);

EXPLAIN ANALYZE
WITH loosers AS (
    SELECT
        *
    FROM
        bad_kitties
    ORDER BY
        resource
    LIMIT 250000
), dead_loosers AS (
    DELETE FROM bad_kitties AS bk
    USING
        loosers AS l
    WHERE
        bk.resource = l.resource
)
DELETE FROM resource_params_cache AS rpc
USING
    loosers AS l
WHERE
    rpc.resource = l.resource;

kubectl get installer --sort-by=.metadata.creationTimestamp -o jsonpath='{.items[-1:].metadata.name}' ; echo

merged