Closed Bug 1626308 Opened 5 years ago Closed 5 years ago

Enable pg_stat_statements for taskcluster databases

Categories

(Cloud Services :: Operations: Taskcluster, task)

Product:
Cloud Services
Component:
Operations: Taskcluster
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: brian, Assigned: brian)

References

Details

We should enable pg_stat_statements in existing postgresql databases for taskcluster, and we should document doing this as part of environment spinup.

https://cloud.google.com/sql/docs/postgres/extensions

See Also: → 1614424

I've done this in stage.

taskcluster=> CREATE EXTENSION pg_stat_statements;
CREATE EXTENSION
taskcluster=> \dx
                                     List of installed extensions
        Name        | Version |   Schema   |                        Description                        
--------------------+---------+------------+-----------------------------------------------------------
 pg_stat_statements | 1.6     | public     | track execution statistics of all SQL statements executed
 pgcrypto           | 1.3     | public     | cryptographic functions
 plpgsql            | 1.0     | pg_catalog | PL/pgSQL procedural language
(3 rows)
Assignee: edunham → bpitts
Status: NEW → ASSIGNED

Now enabled everywhere.

Status: ASSIGNED → RESOLVED
Closed: 5 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.