Linking pganalyze as a source
The pganalyze connector syncs Postgres performance findings – such as missing index recommendations, slow queries, vacuum issues, and server metadata – into PostHog.
To link pganalyze:
Go to the sources tab of the data pipeline section in PostHog.
Click + New source and then click Link next to pganalyze.
Enter your pganalyze API key. You can generate a read-only key from your pganalyze API keys settings.
Enter your organization slug. This is the slug visible in your pganalyze URL (e.g.,
https://app.pganalyze.com/organizations/your-org-slug).Optional: If you're using a self-hosted pganalyze Enterprise Server, enter your custom API URL. Cloud users can leave this blank.
Select the tables you want to sync and modify the method and frequency as needed. Once done, click Import.
Once the syncs are complete, you can query pganalyze data in PostHog.
Available tables
| Table | Description |
|---|---|
| servers | Metadata about your monitored Postgres servers |
| issues | Database performance findings such as missing indexes, vacuum problems, slow queries, and schema issues |
The issues table supports incremental syncing using the synced_at field. The servers table uses full refresh syncing since it contains dimensional data that changes infrequently.
Configuration
| Option | Type | Required |
|---|---|---|
API key | password | Yes |
Organization slug | text | Yes |
API URL (optional, for self-hosted Enterprise Server) | text | No |