How do I display the query time when a query completes in Vertica?

sql vertica vsql
Ilya Kaplun picture Ilya Kaplun · Jul 20, 2011 · Viewed 8.9k times · Source

When using vsql, I would like to see how long a query took to run once it completes. For example when i run:

select count(distinct key) from schema.table;

I would like to see an output like:

5678
(1 row)
total query time: 55 seconds.

If this is not possible, is there another way to measure query time?

Answer

Igor picture Igor · Jul 21, 2011

In vsql type:

\timing

and then hit Enter. You'll like what you'll see :-)

Repeating that will turn it off.

Related questions

Return Top N rows for each group (Vertica/vsql)

Familiar question, but with Vertica. I'd like to return the top 5 geo_country rows based on sum(imps) for each tag_id. This is the query I started: SELECT tag_id, geo_country, SUM(imps) AS imps, RANK() OVER (PARTITION …

Read More
SQL left outer join on multiple columns

According to this SQL join cheat-sheet, a left outer join on one column is the following : SELECT * FROM a LEFT JOIN b ON a.foo = b.foo WHERE b.foo IS NULL I'm wondering what it would look like with …

Read More
Export Vertica query result to csv file

I`m working with Vertica. I try to export data from SELECT query into csv. I tried making it with sql query: SELECT * FROM table_name INTO OUTFILE '/tmp/fileName.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"…

Read More