Mystery SELECT * query

From: Andrew Puschak <apuschak(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Mystery SELECT * query
Date: 2013-12-09 21:07:16
Message-ID: CALFZoBtB8xr1K2oQtZUQ5qMap9zqCwu2AEdk2oRkrY4NH0atVQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

I've inherited a web service on a Windows server that connects to a
Postgres database. There is a "SELECT * FROM" query below that runs a long
time and appears to happen whenever there is a web service update. I'd like
to eliminate or limit it but I have to find it first. I have pgBadger set
up and logging turned up which is how I found the query.

The developer says the query is not in his code and gave me the source
code. It's pasqual. I see the other queries but I don't see the select *
either in the code. He also added logging of the queries and the SELECT *
FROM is missing. Is it possible another query creates the select * such as
the two queries before it shown below?

These are all part of the same connection [2308] and I can see the
connection and disconnect each time. Can I safely assume this is all the
same connection and must be coming from the same web service code/program?

Any help would be greatly appreciated.

Thanks,
Andrew

2013-12-09 00:48:15 EST [2308]: [21-1] user=phoneworks,db=phoneworks LOG:
duration: 33.032 ms statement: Update cout4424ord set deliverbyopr='C'
Where col_id In (17403)

2013-12-09 00:48:15 EST [2308]: [22-1] user=phoneworks,db=phoneworks LOG:
duration: 4.047 ms statement: Select Count(col_id) from cout4424ord
Where deliverbyopr<>'C' OR deliverbyopr IS NULL

2013-12-09 00:48:16 EST [2308]: [23-1] user=phoneworks,db=phoneworks LOG:
duration: 905.426 ms statement: SELECT * FROM cout4424ord

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Kevin Grittner 2013-12-09 23:57:42 Re: Mystery SELECT * query
Previous Message Andy Kerslake 2013-12-05 14:00:19 Trying to set up synchronous replication. fe_sendauth: no password supplied