Hologres:Pricing

Permissions

Access to scan volume data in hologres.hg_query_log depends on your role:

Grant superuser access

-- Replace "Alibaba Cloud account ID" with the actual username.
-- For a RAM user, add "p4_" before the account ID.
ALTER USER "Alibaba Cloud account ID" SUPERUSER;

Grant pg_read_all_stats access

GRANT pg_read_all_stats TO "Alibaba Cloud account ID";                        -- Standard PostgreSQL authorization model
CALL spm_grant('pg_read_all_stats', 'Alibaba Cloud account ID');              -- SPM
CALL slpm_grant('pg_read_all_stats', 'Alibaba Cloud account ID');             -- SLPM

Grant db_admin access (current DB only)

CALL spm_grant('<db_name>_admin', 'Alibaba Cloud account ID');   -- SPM
CALL slpm_grant('<db_name>.admin', 'Alibaba Cloud account ID');  -- SLPM

For a full overview of permission management, see Permission management overview.

SHOW log_min_duration_statement;

Query aggregated scan volume by day

Use this query to get daily scan totals for a time range. Requires superuser access.

Syntax

SELECT
    to_char(query_end, 'DD Mon YYYY')  AS day,
    ROUND(
        SUM(
            CASE WHEN read_bytes < 10 * 1024 * 1024
                 THEN 10 * 1024 * 1024
                 ELSE read_bytes
            END
        ) / 1024 / 1024
    )                                   AS scan_size_mb,  -- 10 MB minimum applied per query
    COUNT(*)                            AS sql_count
FROM    hologres.hg_query_log
WHERE   status      = 'SUCCESS'
AND     command_tag IN ('SELECT')
AND     read_bytes  IS NOT NULL
AND     query_end  >= 'start_time'::TIMESTAMPTZ
AND     query_end   < 'end_time'::TIMESTAMPTZ
GROUP BY 1
ORDER BY 3 DESC;

Example: Query scan volume from 10:00 to 11:00 on January 1, 2022 (UTC+8)

SELECT
    to_char(query_end, 'DD Mon YYYY')  AS day,
    ROUND(
        SUM(
            CASE WHEN read_bytes < 10 * 1024 * 1024
                 THEN 10 * 1024 * 1024
                 ELSE read_bytes
            END
        ) / 1024 / 1024
    )                                   AS scan_size_mb,
    COUNT(*)                            AS sql_count
FROM    hologres.hg_query_log
WHERE   status      = 'SUCCESS'
AND     command_tag IN ('SELECT')
AND     read_bytes  IS NOT NULL
AND     query_end  >= '2022-01-01 10:00:00+08'::TIMESTAMPTZ
AND     query_end   < '2022-01-01 11:00:00+08'::TIMESTAMPTZ
GROUP BY 1
ORDER BY 3 DESC;

Query scan volume per SQL statement

Use this query to see billable scan volume for each individual SQL statement over a time range. Requires superuser access.

All examples use billing_read_bytes — the scan volume with the 10 MB minimum applied — as the field used for cost calculation.

Syntax

SELECT
    usename,
    status,
    query_id,
    datname,
    command_tag,
    duration,
    message,
    query_start,
    query_end,
    query_date,
    query,
    CASE WHEN read_bytes < 10 * 1024 * 1024
         THEN 10 * 1024 * 1024
         ELSE read_bytes
    END  AS billing_read_bytes,  -- 10 MB minimum applied
    application_name
FROM    hologres.hg_query_log
WHERE   status      = 'SUCCESS'
AND     command_tag IN ('SELECT')
AND     read_bytes  IS NOT NULL
AND     query_end  >= 'start_time'::TIMESTAMPTZ
AND     query_end   < 'end_time'::TIMESTAMPTZ;

The billing_read_bytes field represents the scanned data volume used for billing.

Example: Query per-statement scan volume from 10:00 to 11:00 on March 1, 2022 (UTC+8)

SELECT
    usename,
    status,
    query_id,
    datname,
    command_tag,
    duration,
    message,
    query_start,
    query_end,
    query_date,
    query,
    CASE WHEN read_bytes < 10 * 1024 * 1024
         THEN 10 * 1024 * 1024
         ELSE read_bytes
    END  AS billing_read_bytes,
    application_name
FROM    hologres.hg_query_log
WHERE   status      = 'SUCCESS'
AND     command_tag IN ('SELECT')
AND     read_bytes  IS NOT NULL
AND     query_end  >= '2022-03-01 10:00:00+08'::TIMESTAMPTZ
AND     query_end   < '2022-03-01 11:00:00+08'::TIMESTAMPTZ;