[Epic: nwaku] PostgreSQL Maintenance

[chair28980]

Milestone-issue: waku-org/pm#119

Tasks

• Add retention policy with GB or MB limitation #1885
• chore: enhance time retention policy in Postgres #2689
• bug: nwaku node gets blocked because the postgres database is blocked #2783
• bug: the time retention policy seems not to be working properly in shards.test fleet #2807
• bug: PostgreSQL doesn't respond properly during E2E tests #2838
• chore: create sonda tool #2869
• bug: retention policy does not work when postgres db is over loaded #2890
• chore: query performance in PostgreSQL by avoiding ordering in queries #2902
• chore: improve postgres query performance #2895
• store-db add more appropriate db settings for current db hw status-im/infra-status#37
• chore: ANALYZE messages query should be performed regularly #2986
• chore: store queries for content topics take longer with cursor #2963
• chore: create grafana panel to show max, min, mean, median stats of query times #2995
• chore: Optimize store #3061

[fryorcraken]

Can we add to this dashboard the following graph(s):

• median query response time
• average query response time
• min query response time
• max query response time

Could be over a single graph or separate graph.

[Ivansete-status]

Great suggestion @fryorcraken ! I've created that one: #2995