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!
The last_statement_duration_us column in the SESSIONS table
Moderator: NorbertKrupa
-
- Newbie
- Posts: 21
- Joined: Mon Feb 13, 2012 9:44 pm
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: The last_statement_duration_us column in the SESSIONS ta
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!
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
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.