thanks i understand now, i have other dought
Index Scan using xix3_movimento_roteiro_empresa on movimento_roteiro_empresa
movimentor0_ (cost=0.00..73386.80 rows=5126width=451)
what's this mean on red color above?
De: Kevin Grittner
Para: pgsql-performance@
Tom Lane [...@sss.pgh.pa.us] wrote:
Oh, and don't forget the more-complete pg_locks state. We'll want all
the columns of pg_locks, not just the ones you showed before.
auto vacuum of ts_user_sessions_map has been running for > 17 hours.
This table has 2,204,488 rows. I hope that I've captured e
paulo matadr wrote:
> Im confused about who is the most import (colour red ou blue).
For the benefit of those without an easy way to view email in http,
the first cost number was in red, the second in blue.
The first number is the cost to retrieve the first row, the second
number is the cos
Hi all have a dought about explain of postgres
Let's see:
Who have more cost for database:
Index Scan using xix3_movimento_roteiro_empresa on movimento_roteiro_empresa
movimentor0_ (cost=0.00..73386.80 rows=5126 width=451)
Index Cond: (mrem_ammovimento = 200906)
Filter: ((ftgr_id = 26) AND (
Eric Haszlakiewicz wrote:
> I noticed a bit of a performance regression in embedded sql queries when
> moving from the client libraries in verison 8.2.4 to 8.3.7. My
> application does a whole lot of queries, many of which don't return any
> data. When we moved to the new libraries the time of ru
