Redshift Observatory

System Table Tracker

System view pg_catalog.stl_arcadia_billing_txn_tracking version 1.0.74998 / 2024-09-20

schema	name	column	data type
pg_catalog	stl_arcadia_billing_txn_tracking	completed	int4
pg_catalog	stl_arcadia_billing_txn_tracking	pid	int4
pg_catalog	stl_arcadia_billing_txn_tracking	recordtime	timestamp
pg_catalog	stl_arcadia_billing_txn_tracking	remaining	int4
pg_catalog	stl_arcadia_billing_txn_tracking	reported_so_far	int4
pg_catalog	stl_arcadia_billing_txn_tracking	start_time	timestamp
pg_catalog	stl_arcadia_billing_txn_tracking	total_duration	int4
pg_catalog	stl_arcadia_billing_txn_tracking	tx_billable_state	int4
pg_catalog	stl_arcadia_billing_txn_tracking	userid	int4
pg_catalog	stl_arcadia_billing_txn_tracking	xid	int8

View Text

SELECT stll_arcadia_billing_txn_tracking.userid,
       stll_arcadia_billing_txn_tracking.recordtime,
       stll_arcadia_billing_txn_tracking.xid,
       stll_arcadia_billing_txn_tracking.pid,
       stll_arcadia_billing_txn_tracking.start_time,
       stll_arcadia_billing_txn_tracking.total_duration,
       stll_arcadia_billing_txn_tracking.reported_so_far,
       stll_arcadia_billing_txn_tracking.remaining,
       stll_arcadia_billing_txn_tracking.completed,
       stll_arcadia_billing_txn_tracking.tx_billable_state
FROM stll_arcadia_billing_txn_tracking

Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers