🖥️pg_top

➡️This is a command-line reference manual for commands and command combinations that you don’t use often enough to remember it. This cheatsheet explains the pg_top command with important options and switches using examples.

2 minute read

▁ ▂ ▃ ▄ ꧁ 🔴☠ COMMANDLINE-KUNGFU WITH CHEATSHEETS ☠🔴꧂▅ ▃ ▂ ▁

#  ██████╗  ██████╗      ████████╗ ██████╗ ██████╗ 
#  ██╔══██╗██╔════╝      ╚══██╔══╝██╔═══██╗██╔══██╗
#  ██████╔╝██║  ███╗        ██║   ██║   ██║██████╔╝
#  ██╔═══╝ ██║   ██║        ██║   ██║   ██║██╔═══╝ 
#  ██║     ╚██████╔╝███████╗██║   ╚██████╔╝██║     
#  ╚═╝      ╚═════╝ ╚══════╝╚═╝    ╚═════╝ ╚═╝

# 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 backend process
#  L
#      Display the currently held locks by a backend process
#  Q
#      Display the currently running query of a backend process
#  X
#      Display user index statistics.

Cheatsheets are an excellent complement to other information sources like Linux man-pages, Linux help, or How-To’s and tutorials, as they provide compact and easily accessible information. While man-pages and detailed tutorials often contain comprehensive explanations and extensive guides, cheatsheets summarize the most important options forthe command pg_top in a clear format. This allows users to quickly access the needed information for pg_top without having to sift through lengthy texts. Especially in stressful situations or for recurring tasks, cheatsheets for pg_top are a valuable resource to work efficiently and purposefully.

░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░

  █║▌│║█║▌★ KALI ★ PARROT ★ DEBIAN 🔴 PENTESTING ★ HACKING ★ █║▌│║█║▌

              ██╗ ██╗ ██████╗  ██████╗ ██╗  ██╗███████╗██████╗
             ████████╗██╔══██╗██╔═══██╗╚██╗██╔╝██╔════╝██╔══██╗
             ╚██╔═██╔╝██║  ██║██║   ██║ ╚███╔╝ █████╗  ██║  ██║
             ████████╗██║  ██║██║   ██║ ██╔██╗ ██╔══╝  ██║  ██║
             ╚██╔═██╔╝██████╔╝╚██████╔╝██╔╝ ██╗███████╗██████╔╝
              ╚═╝ ╚═╝ ╚═════╝  ╚═════╝ ╚═╝  ╚═╝╚══════╝╚═════╝

               █║▌│║█║▌ WITH COMMANDLINE-KUNGFU POWER █║▌│║█║▌

░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░

Feedback

Was this page helpful?

Glad to hear it! Please tell us how we can improve.

Sorry to hear that. Please tell us how we can improve.