Prasad wrote:
> I have installed PostgreSQL 9.4 (open source) version on my CentOS
> Linux Red Hat 7 production server and kept default parameters which
> are in postgresql.conf file.So my basic question is, once I start
> using postgres how much RAM the postgres processes consumes
> (postgres
Hello Eric,
To start with, you can set log_min_duration_statement to 1500ms and
log_statement to the required one which will give you the statement that ran
for more than 1.5 s. Then you know what to do!
For tools: 1. pgcluu2. PoWA
Best Regards,Rijo Roy
On Thursday, 4 April, 2019,
Hi,
|Cc: pgsql-nov...@postgresql.org, pgsql-performa...@postgresql.org
Please don't cross post to multiple lists.
On Thu, Apr 04, 2019 at 08:18:01PM +0530, Prasad wrote:
> There are lot of allocations in postgresql.conf file, for example
> shared_buffers, work_mem...etc.
>
> As per my
Hi there,
I would like to monitor our postgresql instance under AWS-RDS to get some alert
(or log) if any query runs over a certain amount of time, like 1.5 seconds.
I would like to know which query took over that time (and how long), when and
which parameters it used.
The exact parameters are
On Thu, Apr 4, 2019 at 3:42 AM Duncan Kinnear
wrote:
>
> the EXPLAIN (ANALYSE, TIMING TRUE) of this query gives:
>
> Update on next_id (cost=0.14..8.16 rows=1 width=36) (actual
> time=0.057..0.057 rows=0 loops=1)
>-> Index Scan using next_id_pk on next_id (cost=0.14..8.16 rows=1
>
Hi,
I have installed PostgreSQL 9.4 (open source) version on my CentOS Linux
Red Hat 7 production server and kept default parameters which are in
postgresql.conf file.So my basic question is, once I start using postgres
how much RAM the postgres processes consumes (postgres related processes
We have a very simple table, whose DDL is as follows:
CREATE TABLE public.next_id (
id varchar(255) NOT NULL,
next_value int8 NOT NULL,
CONSTRAINT next_id_pk PRIMARY KEY (id)
);
The table only has about 125 rows, and there are no indexes apart from the
primary key