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 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Download Presentation
Download Policy: The content available on the website is offered to you 'AS IS' for your personal information and use only. It cannot be commercialized, licensed, or distributed on other websites without prior consent from the author. To download a presentation, simply click this link. If you encounter any difficulties during the download process, it's possible that the publisher has removed the file from their server.

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

460 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

323 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
1 Programmers often use analysis tools to improve program quality. These are just tools to

1 Programmers often use analysis tools to improve program quality. These are just tools to

1 Programmers often use analysis tools to improve program quality. These are just tools to analyze, or carefully examine, some aspect of a program. We can categorize program analyses into two groups: Static analysis involves analyzing a program's

511 views • 35 slides
Parallax Dutch Meyer University of British Columbia dmeyer@cs.ubc.ca The Plan Virtual

Parallax Dutch Meyer University of British Columbia dmeyer@cs.ubc.ca The Plan Virtual

Parallax Dutch Meyer University of British Columbia dmeyer@cs.ubc.ca The Plan Virtual Machines and Storage Parallax Feature Overview Technical Design System Evaluation Conclusion Parallax is a Storage Service Observations

398 views • 27 slides
Sustainable Software Development in an Academic Setting 4th International Symposium on Research

Sustainable Software Development in an Academic Setting 4th International Symposium on Research

Sustainable Software Development in an Academic Setting 4th International Symposium on Research and Education of Computational Science (RECS) University of Tokyo, October 1 st , 2019 Hartwig Anzt, Terry Cojean, Thomas Grtzmacher, Pratik Nayak,

516 views • 19 slides
Lab 10: Profiling time callgrind massif Other options gperftool Comp Sci 1585 perf Data

Lab 10: Profiling time callgrind massif Other options gperftool Comp Sci 1585 perf Data

Introduction Lab 10: Profiling time callgrind massif Other options gperftool Comp Sci 1585 perf Data Structures Lab: Tools for Computer Scientists Outline Introduction time callgrind 1 Introduction massif Other options gperftool

979 views • 18 slides
2016 Performance-Related Accountability Requirement 5.2.4 Monitoring and Revising the CHIP

2016 Performance-Related Accountability Requirement 5.2.4 Monitoring and Revising the CHIP

6/30/2016 2016 Performance-Related Accountability Requirement 5.2.4 Monitoring and Revising the CHIP Section 4: Walkthrough of Optional MDH Templates Relevant documents: CHIP Annual Report Template, CHIP Monitoring Spreadsheet, Checklist

522 views • 17 slides
Git, part 1 UNC COMP 523 Wed Sep 23, 2020 Prof. Jeff Terrell 1 / 32 Announcements music:

Git, part 1 UNC COMP 523 Wed Sep 23, 2020 Prof. Jeff Terrell 1 / 32 Announcements music:

Git, part 1 UNC COMP 523 Wed Sep 23, 2020 Prof. Jeff Terrell 1 / 32 Announcements music: Polynomial C by Aphex Twin you shouldn't have to pay for infrastructure! (most) clients have agreed to pay grades up to date as of 11am this morning

796 views • 32 slides
Revised Nonpublic School Monitoring Process 2015 2016 1 Past Nonpublic Monitoring Schedule

Revised Nonpublic School Monitoring Process 2015 2016 1 Past Nonpublic Monitoring Schedule

Revised Nonpublic School Monitoring Process 2015 2016 1 Past Nonpublic Monitoring Schedule 2012 2013 2013 2014 2014 2015 Onsite Monitoring Onsite Monitoring Onsite Monitoring ~18 NPs/yr. ~18 NPs/yr. ~18 NPs/yr. LEA LEA LEA Findings

583 views • 26 slides
Doing Business North America What is Doing Business North America The DBNA annual report

Doing Business North America What is Doing Business North America The DBNA annual report

A New Tool to Rank State and Local Business Regulations Doing Business North America What is Doing Business North America The DBNA annual report provides objective measures of the scale and scope of business regulations in 115 cities in 92

449 views • 18 slides

More recommend