Re: Slow query on V12.

2019-09-23 Thread Luís Roberto Weck
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

Re: Slow query on V12.

2019-09-23 Thread Tom Lane
=?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

Re: Slow query on V12.

2019-09-23 Thread Luís Roberto Weck
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:

Re: Slow query on V12.

2019-09-23 Thread Luís Roberto Weck
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

Re: Slow query on V12.

2019-09-23 Thread nikhil raj
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