| schema | name | column | data type |
|---|---|---|---|
| pg_catalog | stl_aggr | bytes | int8 |
| pg_catalog | stl_aggr | dist_by_distinct | int4 |
| pg_catalog | stl_aggr | endtime | timestamp |
| pg_catalog | stl_aggr | flushable | int4 |
| pg_catalog | stl_aggr | is_diskbased | char(1) |
| pg_catalog | stl_aggr | maxlength | int4 |
| pg_catalog | stl_aggr | memory_usage_ratio | int4 |
| pg_catalog | stl_aggr | num_flushes | int4 |
| pg_catalog | stl_aggr | occupied | int4 |
| pg_catalog | stl_aggr | query | int4 |
| pg_catalog | stl_aggr | resizes | int4 |
| pg_catalog | stl_aggr | rows | int8 |
| pg_catalog | stl_aggr | segment | int4 |
| pg_catalog | stl_aggr | slice | int4 |
| pg_catalog | stl_aggr | slots | int4 |
| pg_catalog | stl_aggr | starttime | timestamp |
| pg_catalog | stl_aggr | step | int4 |
| pg_catalog | stl_aggr | tasknum | int4 |
| pg_catalog | stl_aggr | tbl | int4 |
| pg_catalog | stl_aggr | type | char(6) |
| pg_catalog | stl_aggr | used_agg_prefetching | char(1) |
| pg_catalog | stl_aggr | used_mega_block | char(1) |
| pg_catalog | stl_aggr | userid | int4 |
| pg_catalog | stl_aggr | varagg_opt_bitmap | int8 |
| pg_catalog | stl_aggr | varchar_agg_opt | char(1) |
| pg_catalog | stl_aggr | workmem | int8 |
SELECT stll_aggr.userid,
stll_aggr.query,
stll_aggr.slice,
stll_aggr.segment,
stll_aggr.step,
stll_aggr.starttime,
stll_aggr.endtime,
stll_aggr.tasknum,
stll_aggr.rows,
stll_aggr.bytes,
stll_aggr.slots,
stll_aggr.occupied,
stll_aggr.maxlength,
stll_aggr.tbl,
stll_aggr.is_diskbased,
stll_aggr.workmem,
stll_aggr.type,
stll_aggr.resizes,
stll_aggr.flushable,
stll_aggr.varchar_agg_opt,
stll_aggr.varagg_opt_bitmap,
stll_aggr.used_agg_prefetching,
stll_aggr.used_mega_block,
stll_aggr.num_flushes,
stll_aggr.memory_usage_ratio,
stll_aggr.dist_by_distinct
FROM stll_aggr 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