1. Log in to the GCP console and select the project where the PostgreSQL instance is located.
2. In the navigation menu, go to SQL > PostgreSQL.
3. Select the instance where the PostgreSQL Log Min Duration Statement Flag should be remediated.
4. Click on the “Edit” button at the top of the page.
5. Scroll down to the “Flags” section and look for the “log_min_duration_statement” flag.
6. Change the value of the “log_min_duration_statement” flag to “-1”.
7. Click the “Save” button to apply the changes.
8. Verify that the PostgreSQL Log Min Duration Statement Flag has been successfully remediated by checking the PostgreSQL logs.

​

1. Open the Cloud Shell in your GCP console.
2. Run the following command to authenticate your GCP account:

gcloud auth login

3. Once you are authenticated, set the project where your PostgreSQL instance is located:

gcloud config set project [PROJECT_ID]

4. Check the current value of the PostgreSQL Log Min Duration Statement Flag by running the following command:

gcloud sql instances describe [INSTANCE_NAME] | grep log_min_duration_statement

5. If the current value is not -1, update it by running the following command:

gcloud sql instances patch [INSTANCE_NAME] --database-flags log_min_duration_statement=-1

6. Confirm the change by running the following command:

gcloud sql instances describe [INSTANCE_NAME] | grep log_min_duration_statement

1. Import the necessary libraries:

from google.cloud import bigquery
from google.oauth2 import service_account

2. Authenticate with the GCP account using service account credentials:

credentials = service_account.Credentials.from_service_account_file('<path_to_service_account_file>')
client = bigquery.Client(credentials= credentials, project='<project_id>')

3. Retrieve the current value of the log_min_duration_statement flag:

query = '''
SELECT name, setting
FROM pg_settings
WHERE name = 'log_min_duration_statement'
'''
query_job = client.query(query)
results = query_job.result()
for row in results:
    current_value = row.setting

4. If the current value is not -1, update the flag to -1:

if current_value != '-1':
    query = '''
    ALTER SYSTEM SET log_min_duration_statement = -1;
    '''
    query_job = client.query(query)
    query_job.result()

5. Restart the PostgreSQL service to apply the changes:

query = '''
SELECT pg_reload_conf();
'''
query_job = client.query(query)
query_job.result()