Search found 5 matches

by VerDBA
Sun Dec 06, 2015 8:17 am
Forum: Vertica Performance Tuning
Topic: Can anyone explain time spent between queue_entry_timestamp and start_timestamp
Replies: 0
Views: 15494

Can anyone explain time spent between queue_entry_timestamp and start_timestamp

I dont see any contention or lack of resources but sometimes query run in 6 Seconds sometimes 26 seconds..... When I looked more I saw in query_request or query profile table, query start_timestamp is 23:47:11. But when I look at resourec_acquistions table for same transaction I see queue_entry_time...
by VerDBA
Sun Dec 06, 2015 8:02 am
Forum: Vertica Performance Tuning
Topic: Queries slowdown on server load
Replies: 5
Views: 21672

Re: Queries slowdown on server load

I also have similar situations....I dont see any contention or lack of resources but sometimes query run in 6 Seconds sometimes 26 seconds..... When I looked more I saw in query_request or query profile table, query start_timestamp is 23:47:11. But when I look at resourec_acquistions table for same ...
by VerDBA
Thu Nov 26, 2015 9:57 pm
Forum: Vertica Performance Tuning
Topic: Canary Query Queuing
Replies: 5
Views: 21327

Re: Canary Query Queuing

this is the query I am running: select count(1) from sessions; I dont understand why there will be upstream perations. Is there any way to check: What are the upstream operations taking place in the query?
by VerDBA
Thu Nov 26, 2015 1:25 am
Forum: Vertica Performance Tuning
Topic: Canary Query Queuing
Replies: 5
Views: 21327

Re: Canary Query Queuing

Thanks for Reply...After more analysis I found Input Queue Wait number is outstanding large....Do you ahve any information why or how to tune this ?
by VerDBA
Wed Nov 25, 2015 4:43 am
Forum: Vertica Performance Tuning
Topic: Canary Query Queuing
Replies: 5
Views: 21327

Canary Query Queuing

I have a Canaray query that runs every minute in database. This query run every minutes. It just does: select count(1) from sessions; Most of the time i see this query hitting database on first or sencond seconds. Like 10:09:01, 10:10:01, 10:11:02. But sometimes i see this query wait and gets in the...

Go to advanced search