I am working on AWS RDS Postgres v9.6, and also v14. I noticed that in our shared_preload_libraries parameter, we have pg_stat_statement included. I don’t understand why that needs to be there.
Update: I read that a custom rewrite rule might be overridden and drop any parameter variables, when the custom rewrite rule is used on a child/parent page/post. The post my custom rewrite rule is meant for, is not a child/parent but it is part of a custom post type. Could this be causing similar rewrite issues (dropped parameter variables)?
We have a situation where effectively the same report is requested by different customers but they:
What causes it to be legal to pass an object name to the system stored procedure sp_helptext?
I have a function where I need to get a configuration parameter and assign it to a variable that I will use later in the function. The problem is that when the configuration parameter is not recognized (because it does not exist yet) the function dies. I want to evaluate if the variable was able to be assigned and if not set a null value to it.
I have found, through the query store, a query that’s performing on average 297582 logical reads.
I’ve found that a big, nasty data-extraction query that runs daily needs updated stats to avoid making horrible query plans based on incorrect rowcount estimates (let’s not worry about whether or not my stats should be updating automatically).
Recently I noticed my company’s application using AddWithValueto pass parameter values to dynamic, parameterized queries. Example:
I have a simple query:
I have a function in PostgreSQL 9.4 that calls another function. Both are written in plpgsql. The child function takes an array argument representing IDs from a table that is used to create a new table.