Search found 53 matches

by Timbo
Tue Dec 04, 2018 2:04 pm
Forum: Vertica Performance Tuning
Topic: QUERY_PROFILES view, column QUERY_DURATION_US
Replies: 0
Views: 30949

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...
by Timbo
Tue Nov 24, 2015 9:45 am
Forum: Vertica Performance Tuning
Topic: Creating Live Aggregate Projection
Replies: 7
Views: 34053

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 ...
by Timbo
Fri Nov 20, 2015 4:53 pm
Forum: Vertica Performance Tuning
Topic: Creating Live Aggregate Projection
Replies: 7
Views: 34053

Re: Creating Live Aggregate Projection

vsql --version
vsql version 07.02.0000, built for Linux64, contains support for command-line editing
by Timbo
Fri Nov 20, 2015 9:12 am
Forum: Vertica Performance Tuning
Topic: Creating Live Aggregate Projection
Replies: 7
Views: 34053

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...
by Timbo
Thu Nov 19, 2015 6:22 pm
Forum: Vertica Performance Tuning
Topic: Creating Live Aggregate Projection
Replies: 7
Views: 34053

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...
by Timbo
Wed Jan 28, 2015 3:34 pm
Forum: Vertica Performance Tuning
Topic: Spread Monitoring
Replies: 1
Views: 15611

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%...
by Timbo
Thu Jan 22, 2015 11:20 am
Forum: Vertica Performance Tuning
Topic: Partition table by year
Replies: 2
Views: 17133

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...

Go to advanced search