Vertica long running queries

=> SELECT user_name, start_timestamp, request_duration_ms, transaction_id, statement_id, substr(request, 0, 1000) as request FROM v_monitor.query_requests WHERE transaction_id > 0 ORDER BY request_duration_ms DESC limit 10;

user_name |        start_timestamp        | request_duration_ms |   transaction_id  | statement_id |                                request
----------+-------------------------------+---------------------+-------------------+--------------+---------------------------------------------------------------------
dbadmin   | 2017-03-30 12:33:56.381062-04 |             7567403 | 45035996274122533 |            1 | SELECT identifier, query FROM query_profiles;
dbadmin   | 2017-03-23 13:17:45.350174-04 |             6993612 | 45035996274068604 |            2 | select counter_name from execution_engine_profiles;
dbadmin   | 2017-03-13 13:17:12.618154-04 |             2195859 | 45035996273989990 |            2 | select * from customer_dimension;
dbadmin   | 2017-03-23 15:14:44.586491-04 |              988246 | 45035996274068604 |            4 | select * from execution_engine_profiles;
dbadmin   | 2017-04-13 10:08:21.999011-04 |              735847 | 45035996274232535 |           13 | SELECT * FROM v_monitor.system_resource_usage ORDER BY end_time DESC;

Source: vertica.com

Similar codes

1 vote271 views1 answer
How to sort a list by the second element in tuple python
Python
0 vote305 views1 answer
Use in in django while preserving order
Python Django
0 vote281 views1 answer
Integer to boolean numpy
Python
3 votes272 views2 answers
Scanning 2d array in python
Python
2 votes252 views1 answer
Python 3.7 tutorial pdf with exercises
Python
1 vote294 views1 answer
SystemError: tile cannot extend outside image
Python
2 votes254 views1 answer
Dataframe get row by name
Python
0 vote287 views1 answer
Https://stackoverflow.com/questions/7066121/how-to-set-a-single-main-title-above-all-the-subplots-with-pyplot
Python
3 votes261 views1 answer
How to connect templates in django
Python
15 votes284 views5 answers
Pandas profiling
Python