Search found 5 matches
- 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...
- 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 ...
- 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?
- 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 ?
- 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...