Schema:

ACCOUNT_USAGE

POSTGRES_COMPUTE_USAGE_HISTORY view

This Account Usage view can be used to query the total hourly compute credit usage across all Postgres instances in the account for the last 365 days (1 year).

Columns

The following table provides definitions for the POSTGRES_COMPUTE_USAGE_HISTORY view columns.

Column nameData typeDescription
START_TIMETIMESTAMP_LTZThe date and beginning of the hour (in the local time zone) in which the usage took place.
END_TIMETIMESTAMP_LTZThe date and end of the hour (in the local time zone) in which the usage took place.
CREDITS_USEDNUMBERNumber of compute credits consumed by Postgres instances.

Usage notes

  • The maximum latency for this view is three hours.
  • The POSTGRES_COMPUTE_USAGE_HISTORY view and the Snowsight cost management tools can return different daily compute usage values. This discrepancy is caused by the methods used to determine compute usage. To determine these values, the POSTGRES_COMPUTE_USAGE_HISTORY view uses the current session’s TIMEZONE parameter and the Snowsight cost management tools use Coordinated Universal Time (UTC). To resolve any discrepancies, Snowflake recommends setting the TIMEZONE parameter to UTC.