Export events

Last updated:

|Edit this page

At PostHog we believe in your right to own your data - this means being able to export the raw events whenever you want.

There are several ways to export your events depending on your use case:

MethodWhen?Limitations
PostHog UI - click "Export" on the events tableYou need to export a small number of events3,500 events
Events APIGreat for one-off smaller exports1 day date range and 3,500 events
Data export appYou need to export a large number of eventsNo limits

If you're looking to migrate to a new PostHog instance follow the migrating between PostHog instances guide.

Not sure which export method to use?

Here's a decision tree you might find useful:

Yes
No
Yes
No
Do you need to export a large number of events? Above 3,500
Use a data export app
Do you need to run regular exports e.g. once a day or once a week?
Use the PostHog UI or the Events API

Using Data Export Apps

Popular apps for data export include the S3, Google Cloud Storage, BigQuery, PostgreSQL, Redshift, Snowflake. See the full list of data export apps, or find out how to build your own app.

To export your historical data you'll want to connect the app and then run a historical export.

Additionally, these apps stream all the new events to the destination. This keeps your destination up to date with new events as they come in.

Why are there limitations on the PostHog UI export and the events API?

The PostHog UI and the events API are designed to quickly respond with a small number of events. To prevent your queries running slower when another user is trying to export large numbers of events we've built a separate system for managing the exporting of large number of events using apps.

Questions?

Was this page useful?

Next article

Billing limits and alerts

To help you avoid surprise bills, PostHog enables you to set billing limits for each of our products. Setting a billing limit means we will stop ingesting and processing your data so you are not charged over the set limit. In other words, if you exceed the billing limit you set, your additional data is lost forever. To set a billing limit: Go to your organization's billing settings Click on the three dots in the top right of a product, then "Set billing limit." Set your dollar limit in the box…

Read next article