Get row count processed for a long running query

[usli06]

Good morning,

Does anyone know if there is a way to get the number of rows processed at any point during a long running query? For instance, say we have a Cognos cube that takes an hour to build for 87 million records. If I query the sessions table I can see the query in Vertica as the current statement while the build is occurring. What I'd like to know is how many rows have been processed at any point during that hour. We can do this in Oracle and was just wondering if Vertica can provide this information?

Thanks in advance!

[id10t]

Hi usli06

Look for LOAD_STREAMS table.

Code: Select all

select * from load_streams;

[usli06]

Isn't the load_streams table only applicable when using the COPY command?

[id10t]

Hi usli06
so:

Code: Select all

select * from current_session;

and look for query_profiling_configuration and session_profiling_configuration.

Hope it helps.