pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
A query with performance problems. 2+ messages / 2 participants [nested] [flat]
* A query with performance problems. @ 2003-05-06 12:21 Fabio C. Bon <bon@kernel.net.uy> 2003-05-06 14:39 ` Re: [ADMIN] A query with performance problems. Stephan Szabo <sszabo@megazone23.bigpanda.com> 0 siblings, 1 reply; 2+ messages in thread From: Fabio C. Bon @ 2003-05-06 12:21 UTC (permalink / raw) To: pgsql-admin@postgresql.org Hi ! I have a database on PostgreSQL 7.2.1 and I have performance's problems with some queries. I'm debbuging the query below: Select count(*) from blcar where manide = 3811 and blide = 58090 and bcalupcod = 'MVDUY' and bcalopcod = 'LOCAL' and bcapag <> 'P'; ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [ADMIN] A query with performance problems. 2003-05-06 12:21 A query with performance problems. Fabio C. Bon <bon@kernel.net.uy> @ 2003-05-06 14:39 ` Stephan Szabo <sszabo@megazone23.bigpanda.com> 0 siblings, 0 replies; 2+ messages in thread From: Stephan Szabo @ 2003-05-06 14:39 UTC (permalink / raw) To: Fabio C. Bon <bon@kernel.net.uy>; +Cc: pgsql-performance [Moving to -performance since it's more ontopic there] On Tue, 6 May 2003, Fabio C. Bon wrote: > I have a database on PostgreSQL 7.2.1 and I have performance's problems with > some queries. > I'm debbuging the query below: > > Select count(*) from blcar > where manide = 3811 and blide = 58090 and bcalupcod = 'MVDUY' and bcalopcod > = 'LOCAL' and bcapag <> 'P'; What does the schema of the table look like? Is the SQL query in the file exactly the same text as the above? > Aggregate (cost=8277.10..8277.10 rows=1 width=0) (actual > time=1273.98..1273.98 rows=1 loops=1) > -> Seq Scan on blcar (cost=0.00..8277.09 rows=1 width=0) (actual > time=1273.96..1273.96 rows=0 loops=1) > Filter: (((manide)::numeric = 3811::numeric) AND ((blide)::numeric It seems to want to coerce manide and blide to a numeric here, which seems odd. > = 58090::numeric) AND (bcalupcod = 'MVDUY'::bpchar) AND (bcalopcod = > 'REPRE'::bpchar) AND (bcapag <> 'P'::bpchar)) > Total runtime: 1274.08 msec > (4 rows) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-05-06 14:39 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2003-05-06 12:21 A query with performance problems. Fabio C. Bon <bon@kernel.net.uy> 2003-05-06 14:39 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox