terminal tools
play

Terminal Tools pg_top, pg_systat, pg_proctab PostgresOpen 2019 . - PowerPoint PPT Presentation

Feb 19, 2024 •623 likes •1.01k views

Terminal Tools pg_top, pg_systat, pg_proctab PostgresOpen 2019 . . . . . . . . . . . . . . . . . . . . https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . PostgresOpen 2019 Orlando, FL |

  1. Terminal Tools pg_top, pg_systat, pg_proctab PostgresOpen 2019 . . . . . . . . . . . . . . . . . . . . https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . .

  2. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 Overview • Terminal based tools • Basic live views of the system • Intended to be simpler to use than psql • Compliment other tools • Present capabilities of these tools https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  3. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 About me … • Employed by 2ndQuadrant • PostgreSQL Contributor since 2005 • Director at United States PostgreSQL Association since 2011 • Portland PostgreSQL Users Group https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  4. https://pg_proctab.gitlab.io/ https://pg_systat.gitlab.io/ https://pg_top.gitlab.io/ PostgresOpen 2019 Orlando, FL | 11-13 September 2019 Open source projects • pg_top - Display PostgreSQL processes • pg_systat - Display PostgreSQL statistics • pg_proctab - PostgreSQL extension to query operating system process table https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  5. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_top Display top PostgreSQL processes by: • Memory • Processor utilization • Transaction or query run time https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  6. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_top Default View https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  7. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_top Backend States https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  8. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_top State https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  9. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_top Username https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  10. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_top Transaction & Query Time https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  11. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_top I/O Statistics https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  12. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_top Replication https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  13. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_top Display Query https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  14. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_top Query Execution Plan https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  15. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_top Display Locks Held https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  16. pg_top -b -d 1 -x 10 > pg_top.out PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_top Additional Features • Batch-mode operation can be used to capture output to file: • Can be used to display PostgreSQL processes on remote systems if the remote database has the pg_proctab extension loaded https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  17. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_systat Display PostgreSQL statistics tables: • pg_stat_database • pg_stat_database_conflicts • pg_stat_all_tables • pg_stat_all_indexes • pg_statio_all_tables • pg_statio_all_indexes • pg_stat_process_vacuum https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  18. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_systat database transactions https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  19. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_systat database blocks https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  20. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_systat database tuples https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  21. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_systat database file system usage https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  22. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_systat database confmicts (replicas only) https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  23. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_systat table scans https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  24. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_systat table tuples https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  25. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_systat table vacuum https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  26. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_systat table analyze https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  27. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_systat index https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  28. pg_systat -b > pg_systat.out PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_systat Additional Features • Batch-mode operation can be used to capture output to file: • Almost all views can display PostgreSQL statistics from remote systems https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  29. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_proctab A PostgreSQL extension that provides a SQL interface to the operating system’s process table through user-defined functions: • pg_cputime • pg_loadavg • pg_memusage • pg_proctab https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  30. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_proctab Features • Generate reports on system utilization by process; see scripts in contrib directory • Allows pg_top to get operating system statistics from remote systems • Currently only for PostgreSQL systems running on Linux https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  31. PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_proctab Information • Provides low level system information • Example scripts provided for: • creating tables to store snapshots of statistics data • collecting snapshots of statistics data • generating reports from the saved data https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  32. pg_top -b -d 1 -x 10 > pg_top.out PostgresOpen 2019 Orlando, FL | 11-13 September 2019 pg_system Additional Features • Batch-mode operation can be used to capture output to file: • Can be used to display PostgreSQL processes on remote systems if the remote database has the pg_proctab extension loaded https://www. 2ndQuadrant.com . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Recommend

Linux Terminal System Conceptual Linux terminal Terminal API Terminal emulators

Linux Terminal System Conceptual Linux terminal Terminal API Terminal emulators

Linux Terminal System Conceptual Linux terminal Terminal API Terminal emulators Graphical user interfaces Conceptual Linux terminal Mainframe Terminal User Application Keyboard Display Kernel Modem Modem stdin/stdout

461 views • 12 slides
Tan Cang Haiphong International Container Terminal The First Deep-sea Terminal in North of

Tan Cang Haiphong International Container Terminal The First Deep-sea Terminal in North of

Tan Cang Haiphong International Container Terminal The First Deep-sea Terminal in North of Vietnam HICT - A Heartfelt, Innovative & Caring Terminal 1 Lo Loca cation tion & & Acc Access R ess Roa oads ds 10 Major IZ 5 BAC

607 views • 33 slides
Tan Cang Haiphong International Container Terminal The First Deep-sea Terminal in North of

Tan Cang Haiphong International Container Terminal The First Deep-sea Terminal in North of

Tan Cang Haiphong International Container Terminal The First Deep-sea Terminal in North of Vietnam HICT - A Heartfelt, Innovative & Caring Terminal 1 Lo Loca cation tion & & Acc Access R ess Roa oads ds 10 Major IZ 5 BAC

654 views • 38 slides
MELBOURNE AIRPORT TERMINAL 2 RETAIL DEVELOPMENT Terminal 2 - International Departures Terminal

MELBOURNE AIRPORT TERMINAL 2 RETAIL DEVELOPMENT Terminal 2 - International Departures Terminal

MELBOURNE AIRPORT TERMINAL 2 RETAIL DEVELOPMENT Terminal 2 - International Departures Terminal 2 Departures Retail Amenities Food and Beverage Duty Free Seating Satellite Expansion North Infjll T2 Northern Infjll Departures Retail

326 views • 6 slides
PORT OF SAVANNAH Garden City Terminal: The Southeast Gateway for the U.S. September 2020

PORT OF SAVANNAH Garden City Terminal: The Southeast Gateway for the U.S. September 2020

PORT OF SAVANNAH Garden City Terminal: The Southeast Gateway for the U.S. September 2020 GEORGIA PORTS AUTHORITY DEEPWATER & INLAND TERMINAL OPTIONS APPALACHIAN REGIONAL PORT ATLANTA GARDEN CITY TERMINAL OCEAN TERMINAL COLONELS

431 views • 13 slides
Using the terminal effectively Peter Hill Using the terminal effectively | March 2018 | 1/26

Using the terminal effectively Peter Hill Using the terminal effectively | March 2018 | 1/26

Using the terminal effectively Peter Hill Using the terminal effectively | March 2018 | 1/26 Outline Escape codes Customising the prompt The command line and readline History Command, process and variable substitutions Aliases and functions

478 views • 26 slides
The Mobile Alabama Cruise Terminal and City of Mobile City of Mobile Alabama Cruise Terminal

The Mobile Alabama Cruise Terminal and City of Mobile City of Mobile Alabama Cruise Terminal

The Mobile Alabama Cruise Terminal and City of Mobile City of Mobile Alabama Cruise Terminal 201 South Water Street Mobile, AL 36602 Phone: (251) 338-7447 POC: Sheila Gurganus GulfQuest Maritime Museum Mobile Alabama Cruise Terminal

203 views • 7 slides
Terminal 5 Modernization Briefing for Southwest District Council Project Purpose Big Ship

Terminal 5 Modernization Briefing for Southwest District Council Project Purpose Big Ship

Terminal 5 Modernization Briefing for Southwest District Council Project Purpose Big Ship Ready Improve Terminal 5 to a modern, flexible, well- equipped cargo terminal capable of handling the biggest ships in the Pacific trade lane.

217 views • 11 slides
EUROKOMBI TERMINAL HAMBURG Presentation of EUROKOMBI Terminal Hamburg October 2017

EUROKOMBI TERMINAL HAMBURG Presentation of EUROKOMBI Terminal Hamburg October 2017

EUROKOMBI TERMINAL HAMBURG Presentation of EUROKOMBI Terminal Hamburg October 2017 thorsten.reese@eurokombi.de History More than 15 years experience in intermodal container handling 2001 Foundation of EUROKOMBI as a joint venture of

350 views • 9 slides
Polling Networks terminals terminals low-speedlines Terminal Personal Terminal

Polling Networks terminals terminals low-speedlines Terminal Personal Terminal

Chapter 1 Polling Networks terminals terminals low-speedlines Terminal Personal Terminal Interchange Computer Interchange monitorlinks Central Computer Fullduplex high-speed connection Each station on the network is polled

350 views • 23 slides
ROBERTS BANK TERMINAL 2 PROJECT Proposed three-berth container terminal at Roberts Bank

ROBERTS BANK TERMINAL 2 PROJECT Proposed three-berth container terminal at Roberts Bank

ROBERTS BANK TERMINAL 2 PROJECT Proposed three-berth container terminal at Roberts Bank Could provide additional capacity of 2.4 million TEUs per year p o r t m e t r o v a n c o u v e r.c o m RBT2 Environmental Assessment Update 2013

344 views • 10 slides
Aerial View of Valdez Marine Terminal Valdez Marine Terminal Currently 2 Berths in service

Aerial View of Valdez Marine Terminal Valdez Marine Terminal Currently 2 Berths in service

Aerial View of Valdez Marine Terminal Valdez Marine Terminal Currently 2 Berths in service 200,000 bph loading capacity, both with Vapor Recovery 18 Storage Tanks built originally - 510,000 bbl. each or 9.18 million bbl. total

365 views • 33 slides
SUMINISTROS INDUSTRIALES POTOSINOS, S.A. DE C.V. TERMINAL INTERIOR DE CARGA Mexicos Central

SUMINISTROS INDUSTRIALES POTOSINOS, S.A. DE C.V. TERMINAL INTERIOR DE CARGA Mexicos Central

SUMINISTROS INDUSTRIALES POTOSINOS, S.A. DE C.V. TERMINAL INTERIOR DE CARGA Mexicos Central Region Best Multimodal Terminal SIPSA-TERMINAL NETWORK SIPSA is the best multimodal terminal network in central Mexico. Monterrey (Northern market)

58 views • 5 slides
Resiliency in Terminal Operations at Tenth Avenue Marine Terminal The Port Act and Tidelands

Resiliency in Terminal Operations at Tenth Avenue Marine Terminal The Port Act and Tidelands

Port of San Diego Resiliency in Terminal Operations at Tenth Avenue Marine Terminal The Port Act and Tidelands Trust Doctrine Details responsibility on behalf of the people of the State of California Manage San Diego Bay and the Waterfront

500 views • 18 slides
Terminal Presentation System and Process Overview Agenda Terminal Presentation Phase 2

Terminal Presentation System and Process Overview Agenda Terminal Presentation Phase 2

Terminal Presentation System and Process Overview Agenda Terminal Presentation Phase 2 Release 1 Scope Using the smartAUDIT app Supporting Materials smartAUDIT THE APPLICATION Designed specifically for use by the Sydney

378 views • 18 slides
FLORIDA INTERNATIONAL TERMINAL LLC Since 2005, the Most Efficient Marine Terminal in South

FLORIDA INTERNATIONAL TERMINAL LLC Since 2005, the Most Efficient Marine Terminal in South

FLORIDA INTERNATIONAL TERMINAL LLC Since 2005, the Most Efficient Marine Terminal in South Florida Location FIT is located 23 miles North of Miami, 48 miles South of West Palm Beach and 215 miles from Orlando. Direct access to

233 views • 9 slides
Terminal 2 The Queens Terminal Lessons Learned for the Water Industry 29 th January 2019

Terminal 2 The Queens Terminal Lessons Learned for the Water Industry 29 th January 2019

Terminal 2 The Queens Terminal Lessons Learned for the Water Industry 29 th January 2019 Julian Foster Capital Programme Director Challenges Water Industry Challenges Live Operating Environment Safety and Security Not a

279 views • 26 slides
M A C S T E R M I N A L P R E S E N T E D O N M A R C H 8 , 2 0 1 6 B Y B U RT S T E P

M A C S T E R M I N A L P R E S E N T E D O N M A R C H 8 , 2 0 1 6 B Y B U RT S T E P

M A C S T E R M I N A L P R E S E N T E D O N M A R C H 8 , 2 0 1 6 B Y B U RT S T E P H E N S , O M U G M E M B E R Note: You will not be able to run Terminal from this PDF. You are encouraged to try Terminal on your computer.

682 views • 46 slides
CAC Temporary Terminal Presentation Terminal Presentation July 13, 2010 July 13, 2010 Program

CAC Temporary Terminal Presentation Terminal Presentation July 13, 2010 July 13, 2010 Program

CAC Temporary Terminal Presentation Terminal Presentation July 13, 2010 July 13, 2010 Program Status Program Status Finalizing Temporary Terminal construction Striping and traffic changes in progress p g g p g SFMTA and

297 views • 13 slides
TRIMODAL TERMINAL BRUSSELS Container Terminal Port of Brussels AGENDA Location

TRIMODAL TERMINAL BRUSSELS Container Terminal Port of Brussels AGENDA Location

TRIMODAL TERMINAL BRUSSELS Container Terminal Port of Brussels AGENDA Location Trimodal access Connection Equipment Our services Network Joint-Venture Stukwerkers, Duferco, HTS LOCATION In the Port of Brussels

484 views • 9 slides
Welcome! Public Meeting for the West End Transit Terminal July 31, 2018 The West End Transit

Welcome! Public Meeting for the West End Transit Terminal July 31, 2018 The West End Transit

Welcome! Public Meeting for the West End Transit Terminal July 31, 2018 The West End Transit Terminal Transit Windsor currently operates a West End Transit Terminal at the College Avenue Community Centre (CACC) at the intersection of

359 views • 13 slides
Using itsunix.albany.edu for Windows: 1) Download PuTTY at

Using itsunix.albany.edu for Windows: 1) Download PuTTY at

Using itsunix.albany.edu for Mac: 1) Open the Terminal. Searching terminal on Spotlight can open the terminal. This will allow you to use the command line on the Mac. 2) To connect to itsunix.albany.edu type the following command: ssh X

162 views • 4 slides
PORT OF SAVANNAH Garden City Terminal: The Southeast Gateway for the U.S. Presented to June 6,

PORT OF SAVANNAH Garden City Terminal: The Southeast Gateway for the U.S. Presented to June 6,

PORT OF SAVANNAH Garden City Terminal: The Southeast Gateway for the U.S. Presented to June 6, 2017 Chatham ICTF served by CSX Transportation Mason ICTF served by Norfolk Southern Railroad GARDEN CITY TERMINAL TODAY LARGEST SINGLE TERMINAL

728 views • 19 slides
(TIP) Airport Commission 1 December 18, 2019 Terminal Integration Project Concept 2 TERMINAL

(TIP) Airport Commission 1 December 18, 2019 Terminal Integration Project Concept 2 TERMINAL

Burlington International Airport Terminal Integration Project (TIP) Airport Commission 1 December 18, 2019 Terminal Integration Project Concept 2 TERMINAL INTEGRATION PROJECT (TIP) Consolidated SSCP Basis of Design Burlington International

628 views • 28 slides

More recommend