pg_stat_activit y versus ps - PostgreSQL Database

Jeff Amiel

I ran a home-grown self continuous stress test tool against my 7.4.2
database.

I banged 'ps' (running freebsd) while it was active and witnessed
several of the 'back end' postgres processes exeucting queries, commits,
inserts, etc....(the actual work the processes were doing was listed in
the 'ps' output)
however, if I checked pg_stat_activit y during the same time period, I
saw nothing populated in the current_query column...ever.

Am I misunderstandin g what the pg_stat_activit y table is for? I
confirmed that the procpid listed in pg_stat_activit y was the same as
listed in my 'ps' process list....
Jeff

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #1

Subscribe Reply

1999

Tom Lane

Jeff Amiel <ja****@istream imaging.com> writes:

however, if I checked pg_stat_activit y during the same time period, I
saw nothing populated in the current_query column...ever.

Did you have it turned on? (stats_command_ string config parameter)

Were you checking as superuser?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #2

Jeff Amiel

That was it. (not having it turned on. duh).
Guess I should have read section 23.2 of the docs..."The Statistics
Collector"
Thanks for the heads up.

Jeff
Tom Lane wrote:

Jeff Amiel <ja****@istream imaging.com> writes:

however, if I checked pg_stat_activit y during the same time period, I
saw nothing populated in the current_query column...ever.

Did you have it turned on? (stats_command_ string config parameter)

Were you checking as superuser?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #3

Bruce Momjian

Jeff Amiel wrote:

That was it. (not having it turned on. duh).
Guess I should have read section 23.2 of the docs..."The Statistics
Collector"

8.0 will give clear output showing it is not turned on our you don't
have permissions.

--
Bruce Momjian | http://candle.pha.pa.us
pg***@candle.ph a.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #4

Similar topics

4532

Python versus Perl

by: Dieter Vanderelst | last post by:

Dear all, I'm currently comparing Python versus Perl to use in a project that involved a lot of text processing. I'm trying to determine what the most efficient language would be for our purposes. I have to admit that, although I'm very familiar with Python, I'm complete Perl noob (and I hope to stay one) which is reflected in my questions. I know that the web offers a lot of resources on Python/Perl differences. But I couldn't find a...

Python

5604

PostgreSQL versus MySQL

by: Joshua D. Drake | last post by:

Hello, I think the below just about says it all: http://www.commandprompt.com/images/mammoth_versus_dolphin_500.jpg Sincerely, Joshua Drake

PostgreSQL Database

1982

Query to pg_stat_activity

by: Carmen Gloria Sepulveda Dedes | last post by:

Hello. I want to query pg_stat_activity to see the current_query field. I do: mdbs=# select current_user; current_user -------------- postgres (1 row)

PostgreSQL Database

4623

pg_stat_activity

by: Jaime Casanova | last post by:

Hi all, in the pg_stat_activity catalog there is a field called current_query but it is in blank when i modify the show statement stat in postgresql.conf i win nothing. what am i doing wrong? thanks in advance, Jaime Casanova (el_vigia)

PostgreSQL Database

1825

procpid in pg_stat_activity but no correspoding backend

by: Rajesh Kumar Mallah | last post by:

Hi , I noticed that an entry in pg_stat_activity was existing for a long duration > 2 mins while its backend ( process corresponding to that procpid) was not running. how can it be possible ? version: 7.3.4

PostgreSQL Database

6742

Abstract Class versus Private Constructor

by: Andrew Robinson | last post by:

I need to create a shared static field for use within a number of different classes. Which one should I be using or are they all really the same thing? public class Widget { private Widget() {} public static string DataField = string.Empty; } versus

C# / C Sharp

2276

postgresql.conf for pg_stat_activity

by: elein | last post by:

The variable names in postgresql.conf have changed in the last several releases. I'm now confused about what variable(s) to set to show the query in pg_stat_activity. Hints? --elein ============================================================ elein@varlena.com Varlena, LLC www.varlena.com

PostgreSQL Database

3218

select count(*) from pg_stat_activity in V8.0.0

by: Anony Mous | last post by:

Coming off of 7.4.3 I've always used select count(*) from pg_stat_activity through the ODBC driver to obtain the number of connections to the db. I've found that with v8.0 Beta 1 that this at times has returned a value of 0 (when there is obviously still a connection). It's not repeatable, and occurs sporadically. Does anyone have any reason as to why this would be isolated to V8? Is this an acceptable means of obtaining the...

PostgreSQL Database

8354

IN versus ANY versus EXISTS

by: aj | last post by:

DB2 8.2 LUW FP14 Is there any real difference between select blahblahblah... where blah IN (select blah......) versus select blahblahblah... where blah = ANY (select blah.....) versus select blahblahblah... where exists (select blah.....) Is one more ANSI than another? Which is most portable?

DB2 Database

9605

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10651

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10393

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10405

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9208

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6893

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4342

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3871

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

3020

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General