The last_statement_duration_us column in the SESSIONS table

Moderator: NorbertKrupa

Post Reply
JeffSatler
Newbie
Newbie
Posts: 21
Joined: Mon Feb 13, 2012 9:44 pm

The last_statement_duration_us column in the SESSIONS table

Post by JeffSatler » Fri Jun 22, 2012 8:37 pm

Hi,

I have a question about the last_statement_duration_us column in the SESSIONS table.

Is this the duration it takes for the query to complete in Vertica or the time it takes to actually send the data off to the client?

For instance, I have a query that returns 2.5 million rows. After running the query in a client tool, the last_statement_duration_us is equal to 67623031 for the statement. That's about 18 minutes. But if I run the query locally in Vertica (via vsql) the last_statement_duration_us is less than 10 seconds!

Thanks!

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: The last_statement_duration_us column in the SESSIONS ta

Post by JimKnicely » Thu Oct 11, 2012 3:59 pm

Hi,

From my experience the last_statement_duration_us column represents the total amount of time it takes to send all of the data to the client. So if you are running a query on a client that's not local (i.e. not on the server) it'll take a lot longer to transfer the data across the network.

Thanks!
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “New to Vertica Database Administration”