Search found 53 matches
- Tue Dec 04, 2018 2:04 pm
- Forum: Vertica Performance Tuning
- Topic: QUERY_PROFILES view, column QUERY_DURATION_US
- Replies: 0
- Views: 45665
QUERY_PROFILES view, column QUERY_DURATION_US
Hi, Does anyone know the definition for the column QUERY_DURATION_US in the QUERY_PROFILES view? The manual says "The duration of the query in microseconds." But want to clarify if this is time only in the Cluster or does it also include network time from the client initiating the request and confir...
- Tue Nov 24, 2015 9:45 am
- Forum: Vertica Performance Tuning
- Topic: Creating Live Aggregate Projection
- Replies: 7
- Views: 36250
Re: Creating Live Aggregate Projection
Thanks Sharon, the following worked ok:- CREATE PROJECTION point_max_lastupdated_agg AS SELECT instrument_id, element_id ,max(last_updated) AS max_timestamp FROM Phoenix1.Point group by instrument_id, element_id KSAFE; select refresh('PHOENIX1.point'); select make_ahm_now(); Now to see if there are ...
- Fri Nov 20, 2015 4:53 pm
- Forum: Vertica Performance Tuning
- Topic: Creating Live Aggregate Projection
- Replies: 7
- Views: 36250
Re: Creating Live Aggregate Projection
vsql --version
vsql version 07.02.0000, built for Linux64, contains support for command-line editing
vsql version 07.02.0000, built for Linux64, contains support for command-line editing
- Fri Nov 20, 2015 9:12 am
- Forum: Vertica Performance Tuning
- Topic: Creating Live Aggregate Projection
- Replies: 7
- Views: 36250
Re: Creating Live Aggregate Projection
All nodes up ok, everything is currently KSafe. Tried the following syntax, but no luck:- CREATE PROJECTION point_max_lastupdated_agg AS SELECT instrument_id, element_id ,max(last_updated) AS max_timestamp FROM Phoenix1.Point group by instrument_id, element_id ALL NODES KSAFE; vsql:cre_point_max_las...
- Thu Nov 19, 2015 6:22 pm
- Forum: Vertica Performance Tuning
- Topic: Creating Live Aggregate Projection
- Replies: 7
- Views: 36250
Creating Live Aggregate Projection
Hi, Playing with Live Aggregate Projection for the first time and failed at the first hurdle, is it obvious what I'm doing wrong:- CREATE PROJECTION point_max_lastupdated_agg AS SELECT instrument_id, element_id ,max(last_updated) AS max_timestamp FROM Phoenix1.Point group by instrument_id, element_i...
- Wed Jan 28, 2015 3:34 pm
- Forum: Vertica Performance Tuning
- Topic: Spread Monitoring
- Replies: 1
- Views: 16628
Spread Monitoring
Hi, Does anyone have the definition of the columns in the "dc_spread_monitor" table or some SQL that would make some meaning of the data? No information on this table in either the V6 or V7 online documentation. I see in the V7 MC that there is an alert for "Spread Retransmit Rate Over Threshold 10%...
- Thu Jan 22, 2015 11:20 am
- Forum: Vertica Performance Tuning
- Topic: Partition table by year
- Replies: 2
- Views: 18537
Re: Partition table by year
The following syntax appears to work ok:- alter table public.rawzeroratecurves PARTITION BY DATE_PART('year', date(last_updated at time zone 'UTC')) REORGANIZE; vsql:Partition_RAW1.sql:1: NOTICE 4954: The new partitioning scheme will produce 11 partitions vsql:Partition_RAW1.sql:1: NOTICE 4785: Star...