Em 23/09/2019 16:44, Tom Lane escreveu:
=?UTF-8?Q?Lu=c3=ads_Roberto_Weck?= writes:
This is the query that is actually slow:
-- EXPLAIN (ANALYZE, COSTS, VERBOSE, BUFFERS)
SELECT table_schema, table_name,
n_live_tup::numeric as est_rows,
pg_table_size(relid)::numeric as table_si
=?UTF-8?Q?Lu=c3=ads_Roberto_Weck?= writes:
> This is the query that is actually slow:
> -- EXPLAIN (ANALYZE, COSTS, VERBOSE, BUFFERS)
> SELECT table_schema, table_name,
> n_live_tup::numeric as est_rows,
> pg_table_size(relid)::numeric as table_size
> FROM information_schema.co
Em 23/09/2019 16:03, Luís Roberto Weck escreveu:
Em 23/09/2019 15:43, nikhil raj escreveu:
Hi,
Can you check by vacuum analyze the database. And run the query.
**Remember don't use Vacuum full.
On Tue, 24 Sep 2019, 12:07 am Luís Roberto Weck,
mailto:luisrobe...@siscobra.com.br>> wrote:
Em 23/09/2019 15:43, nikhil raj escreveu:
Hi,
Can you check by vacuum analyze the database. And run the query.
**Remember don't use Vacuum full.
On Tue, 24 Sep 2019, 12:07 am Luís Roberto Weck,
mailto:luisrobe...@siscobra.com.br>> wrote:
Hi!
Recently I've been looking for bloat
Hi,
Can you check by vacuum analyze the database. And run the query.
**Remember don't use Vacuum full.
On Tue, 24 Sep 2019, 12:07 am Luís Roberto Weck, <
luisrobe...@siscobra.com.br> wrote:
> Hi!
>
> Recently I've been looking for bloat in my databases and found a query to
> show which table
Hi!
Recently I've been looking for bloat in my databases and found a query
to show which tables are more bloated and by how much.
This is the explain plan on v12.3: https://explain.depesz.com/s/8dW8C
And this is with v11: https://explain.depesz.com/s/diXY
Both databases have approx. the same
I understood my problem. thanks.
בתאריך יום ב׳, 23 בספט׳ 2019 ב-13:59 מאת Mariel Cherkassky <
mariel.cherkas...@gmail.com>:
> Hey,
> I got the following partitions structure in pg12 beta 3 version :
>
> postgres=# \d+ students
> Partitioned table "public.studen
Hey,
I got the following partitions structure in pg12 beta 3 version :
postgres=# \d+ students
Partitioned table "public.students"
Column | Type | Collation | Nullable | Default | Storage | Stats
target | Description
+-+---+--+--
