pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / 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>
  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 14:39  Stephan Szabo <sszabo@megazone23.bigpanda.com>
  parent: Fabio C. Bon <bon@kernel.net.uy>
  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