This is not the document you are looking for? Use the search form below to find more!

Report home > Others

pg_top is ’top’ for PostgreSQL

0.00 (0 votes)

Document Description

File Details

Added: April, 14th 2011
Reads: 95
Downloads: 0
File size: 216.16kb
Pages: 27
Tags: postgresql, performance, top
content preview

Submitter

Name: cerys

We are unable to create an online viewer for this document. Please download the document instead.

pg_top is ’top’ for PostgreSQL screenshot

DOWNLOAD

Add New Comment

pg_top is ’top’ for PostgreSQL: pg_top + pg_proctab

by: wasil, 35 pages

pg_top is ’top’ for PostgreSQL: pg_top + pg_proctab

Why Code ’for’ Android and Motodev Studio

by: heikki, 22 pages

Why Code ’for’ Android and Motodev Studio

Is the Economy good for VoIP

by: drvoip, 1 pages

Is the Economy good for VoIP

Is AARP Looking Out for You? Life Insurance and Annuities

by: shinta, 4 pages

Since AARP is an advocacy group for older people, and a nonprofit, and a huge organization that can bring massive economies of scale to any product it sells, you’d expect that its ...

This is not the time for Big Lazy Brands

by: terttu, 54 pages

This is not the time for Big Lazy Brands

UKPVC 2010 - Ben Hill - Why crystalline technology is the right solution for the UK solar market

by: heidi, 22 pages

UKPVC 2010 - Ben Hill - Why crystalline technology is the right solution for the UK solar market

Lamisil Clinical Trials. What Is Lamisil Cream Used For.

by: justin, 1 pages

Lamisil Clinical Trials. What Is Lamisil Cream Used For.

THAILAND is a global center for sex change operations

by: thailand2, 5 pages

THAILAND is a global center for sex change operations

Eurodb Automotive is Paving a Path for Used Car Sale

by: vehiclencars, 1 pages

EuroDB Automotive is paving a path for used car sale. The magnificent EuroDB Automotive is a company involved in automotive business since long. Buying a car is an exciting task as well as ...

Position Sensor Market ’Positioned’ For Recovery

by: igino, 18 pages

VDC Research Webcast: Position Sensor Market ‘Positioned’ for Recovery Market Demand Analysis, 9th Edition Global Automation & Control Practice Industrial Chris J. ...

Content Preview

ptop is 'top' for PostgreSQLLinuxfest Northwest 2008April 26-27, 2008Mark WongPostgreSQL Global Development Groupmarkwkm@gmail.comOops'ptop' is the Free Pascal (aka FPK Pascal) source formatter.2008 April 26-27pg_top is 'top' for PostgreSQL2pg_top is 'top' for PostgreSQLLinuxfest Northwest 2008April 26-27, 2008Mark WongPostgreSQL Global Development Groupmarkwkm@gmail.com2008 April 26-27pg_top is 'top' for PostgreSQL3Outline׏ A little about me● More about pg_top– PostgreSQL specific functionality– How you might have done it, how pg_top may help you● Q/A2008 April 26-27pg_top is 'top' for PostgreSQL4About my moonlighting● pg_top● PostgreSQL Virtual Machines● Portland Performance lab http://wiki.postgresql.org/wiki/Performances_QA_testing2008 April 26-27pg_top is 'top' for PostgreSQL5About pg_top● http://ptop.projects.postgresql.org/● Derived from the Unix Top v3.6.1– William LeFebvre– http://www.unixtop.org/● pg_top currently at 3.6.2-beta42008 April 26-27pg_top is 'top' for PostgreSQL6PostgreSQL Specific Features● Displays only PostgreSQL connection processes● Show running SQL statements● Show query plans (EXPLAIN or EXPLAIN ANALYZE)● Show table or index statistics● Show database locks2008 April 26-27pg_top is 'top' for PostgreSQL7pg_top2008 April 26-27pg_top is 'top' for PostgreSQL8SELECT current_querySELECT datname, procpid, current_queryFROM pg_stat_activityORDER BY procpid; datname | procpid | current_query---------+---------+------------------------------------------------------------ dbt3 | 10994 | select sum(l_extendedprice * l_discount) as revenue from dbt3 | 11021 | select s_name, count(*) as numwait from supplier, lineite dbt3 | 11141 | insert into lineitem (select * from tmp_lineitem2); dbt3 | 11155 | : SELECT datname, procpid, current_query : FROM pg_stat_activity : ORDER BY procpid; : (4 rows)2008 April 26-27pg_top is 'top' for PostgreSQL9Hit the 'Q' key, enter a pid2008 April 26-27pg_top is 'top' for PostgreSQL10Document Outline