Can anyone explain time spent between queue_entry_timestamp and start_timestamp

Moderator: NorbertKrupa

Post Reply
VerDBA
Newbie
Newbie
Posts: 5
Joined: Wed Nov 25, 2015 4:34 am

Can anyone explain time spent between queue_entry_timestamp and start_timestamp

Post by VerDBA » Sun Dec 06, 2015 8:17 am

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_timestamp 23:47:32.

Where did this (23:47:32 - 23:47:11) = 21 Seconds spend or go? This additional 21 seconds got added to execution time....

Post Reply

Return to “Vertica Performance Tuning”