Note
We are no longer onboarding new users to Citus Cloud on AWS. However, existing customers can continue to use Citus Cloud as they do today.
Logging
What Is Logged
By default, Citus Cloud logs all errors and other useful information that happen on any of the Citus instances and makes it available to you.
The logs will contain the following messages:
Citus and PostgreSQL errors
Slow queries that take longer than 30 seconds
Checkpoint statistics
Temporary files that are written and bigger than 64 MB
Autovacuum that takes more than 30 seconds
Recent Logs
The Citus Cloud dashboard automatically shows you the most recent 100 log lines from each of your servers. You don’t need to configure anything to access this information.
External Log Destinations
For anything more than a quick look at your logs, we recommend setting up an external provider. Through this method the logs will transmit to a dedicated logging service and you can analyze and retain them according to your own preferences. To use an external provider, create a new logging destination in the Citus Cloud console. For instance, here is the new destination dialog filled in with Papertrail settings:
Note that after creation, it might take up to five minutes for logging preferences to be applied. You’ll then see logs show up in your chosen provider’s dashboard.
The settings to use differ per provider. In the following tables we list settings verified to work for a number of popular providers.
Verified Provider Settings
Replace <token>
with the custom token listed in the provider’s web site. This token tells them the logs are yours.
Papertrail
Hostname | logs<N>.papertrailapp.com |
Port | port defined per account |
TLS | Yes |
Protocol | BSD Syslog |
Message Template |
Loggly
Hostname | logs-01.loggly.com |
Port | 6514 |
TLS | Yes |
Protocol | BSD Syslog over TCP |
Message Template |
|
Sumologic
Hostname | syslog.collection.us2.sumologic.com |
Port | 6514 |
TLS | Yes |
Protocol | IETF Syslog |
Message Template |
|
Logentries / Rapid7 insightOps
Hostname | us.data.logs.insight.rapid7.com |
Port | 443 |
TLS | Yes |
Protocol | BSD |
Message Template |
|
LogDNA
Hostname | syslog-a.logdna.com |
Port | 6514 |
TLS | Yes |
Protocol | BSD Syslog over TCP |
Message Template |
|
Other
We support other providers that can receive syslog via the BSD or IETF protocols. Internally Citus Cloud uses syslog-ng, so check your providers configuration documentation for syslog-ng settings.
Please reach out if you encounter any issues.