You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
20 lines
576 B
Plaintext
20 lines
576 B
Plaintext
# pg_top
|
|
# Display and update information about the top CPU PostgreSQL processes
|
|
|
|
# connect to port 5432 using user postgres, and database, ask for password
|
|
pg_top -p 5432 -U postgres -d database -W
|
|
|
|
# Interactive mode keys:
|
|
#
|
|
# A
|
|
# Display the actual query plan (EXPLAIN ANALYZE)
|
|
# E
|
|
# Display re-determined execution plan (EXPLAIN) of the SQL statement
|
|
# by a back end process
|
|
# L
|
|
# Display the currently held locks by a back end process
|
|
# Q
|
|
# Display the currently running query of a back end process
|
|
# X
|
|
# Display user index statistics.
|