Re: How to investigate what postgres is spending time on

2018-09-23 Thread Chris Travers
On Sun, Sep 23, 2018 at 1:15 PM Kim Rose Carlsen wrote: > Hi > > > I have some simple INSERT / UPDATE queries, that takes a long time the > first time they are run in out test environment, but I'm not sure what > postgres is doing and what I can do to help it. Whats common is that the > table con

How to investigate what postgres is spending time on

2018-09-23 Thread Kim Rose Carlsen
Hi I have some simple INSERT / UPDATE queries, that takes a long time the first time they are run in out test environment, but I'm not sure what postgres is doing and what I can do to help it. Whats common is that the table contains many rows in the order of about 20 millions. Query: INSERT