Re: slow query

Justin thank you very much for your answer, as you can also see the number of rows differs a lot I attach the complete explain, do not attach it because it is large "HashAggregate (cost=12640757.46..12713163.46 rows=385 width=720) (actual time=1971962.023..1971962.155 rows=306 loops=1)" " Output

slow query

Dear I have a question to ask you I am having a slow problem with a query and I am seeing with the explain that the current cost and time differ by 4 times Postgres version 9.5.16 in centos 7.6 To try to solve this run the statistics to the table and the same problem remains It's a very big table 2

Re: pg_stat_bgwriter

thank you very much justin, i am seeing install the product you recommended me! -- Sent from: https://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html

Re: pg_stat_bgwriter

thank you very much jeff I'll see with the team that manages the operating system to see if they can help me with this data that you have given me -- Sent from: https://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html

Re: pg_stat_bgwriter

Excuse me, can you tell me how can I achieve this? "The question is how that compared to database size, and size of the active set (fraction of the database accessed by the application / queries)." -- Sent from: https://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html

Re: pg_stat_bgwriter

Hi Tomas, restart the statistics and take 24-hour samples to see if you can help me 24 gb server memory 6 gb sharred buffers # select now, # pg_size_pretty(buffers_checkpoint*8192)AS buffers_checkpoint, # pg_size_pretty(buffers_clean*8192)AS buffers_clean, # pg_size_pretty(buffers_backend*8192)

Re: pg_stat_bgwriter

Thanks a lot, always helping I attached a snapshot that I take every 12 hours of the pg_stat_bgwriter select now,buffers_checkpoint,buffers_clean, buffers_backend from pg_stat_bgwriter_snapshot; now | buffers_checkpoint | buffers_clean | buffers_backend

pg_stat_bgwriter

Dear I would like to share with you to see what you think about the statistics of pg_stat_bgwriter postgres = # select * from pg_stat_bgwriter;  checkpoints_timed | checkpoints_req | checkpoint_write_time | checkpoint_sync_time | buffers_checkpoint | buffers_clean | maxwritten_clean | buffers_back

Re: autovacuum big table taking hours and sometimes seconds

Would it be nice to start changing those values ​​found in the default postgres.conf so low? -- Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html

Re: Memory size

I was seeing thanks to your recommendations and I found the following, to see what you think cache hit rate 0.99637443599712620769 We have the default values 5 minutes total checkpoint minutes beetween checkpoint 26927 0.358545045634493 temp_files temp_si

Re: Memory size

With several views, Jeff is following us Tomorrow I will see if I can provide more data to see if you can guide me a bit Thank you so much everyone -- Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html

Re: Memory size

thank you very much Tomas, tomorrow at work I will see to capture plans of ejcucion to see if you can give me a hand, I am really helping me a lot with their advice -- Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html

Re: Memory size

jeff thank you very much for your time, I tell you, they are the same queries with the same parameters, I take 3 minutes for example, but I execute it and it takes me seconds, that's why I suspect it is the shared buffer The server had 16 GB and we increased it to 24, but I really do not know if it

Re: Sv: Memory size

The rest of the memory Andreas, 16 gb -- Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html

Memory size

Dear some consultation, I have a base of about 750 GB in size and we are having problem of slowness in certain views of the application, so I have been seeing it is apparently a memory problem because if I run again the view runs fast, the base is in a virtual server with 24 GB of RAM and 8 GB of