# pg\_stat\_statements extension in Postgres

**URL:** <https://community.fly.io/t/pg-stat-statements-extension-in-postgres/3788>\
**Category:** General\
**Tags:** postgres\
**Created:** [January 25, 2022, 3:25am UTC](https://community.fly.io/t/pg-stat-statements-extension-in-postgres/3788 "2022-01-25T03:25:48Z")\
**Posts on this page:** 1\
**Showing post:** 11

<div class="post-metadata">

**Author:** ![carter1](https://sea1.discourse-cdn.com/fly1/user_avatar/community.fly.io/carter1/32/8032_2.png) [@carter1](https://community.fly.io/u/carter1)\
**Post date:** [January 11, 2023, 11:46pm UTC](https://community.fly.io/t/pg-stat-statements-extension-in-postgres/3788/11 "2023-01-11T23:46:27Z")

</div>

This is how I resolved my issue:

I ssh’d onto the pg server:

```auto
> fly ssh console -a chat-pg

```

then ran a stolon update similar to kurt’s above

```auto
> stolonctl update --patch "{\"pgParameters\": {\"shared_preload_libraries\": \"pg_stat_statements\"}}"

```

afterwards, the config did show as updated:

```auto
> fly postgres config view -a chat-pg

Update available 0.0.441 -> 0.0.442.
Run "fly version update" to upgrade.
NAME VALUE UNIT	DESCRIPTION PENDING RESTART
...
shared-preload-libraries -> (pg_stat_statements) Lists shared libraries to preload into server. true
...

Some changes are awaiting a restart!
To apply changes, run: `fly postgres restart --app chat-pg`

```

Then I followed the instructions in that last command to restart the server. Done!

---

_[View the full topic](https://community.fly.io/t/pg-stat-statements-extension-in-postgres/3788)._