Postgres

Answers from your app’s Postgres database, or its read replica.

Try Dot with PostgresRead the docs

Every answer comes with the SQL Dot ran against your database.

Threadanalytics

Daniel Weber9:41 AM

@Dot What share of our new workspaces invite a teammate in their first week, by signup month?

1 reply

DotAPP9:42 AM

5 steps · 31s · Access Online

34% in September, up 7 points since June.

Sources: Postgres’ workspaces and invites.

Chart

Threadanalytics

Lisa Park9:41 AM

@Dot How many of our orders have been stuck in ‘pending payment’ for more than a day?

1 reply

DotAPP9:42 AM

4 steps · 20s · Access Online

57 orders worth $9,300. The oldest has waited three days.

Sources: Postgres’ orders and payments.

Here is the data.

OrderAmountWaiting
#48213$4203 days
#48377$1852 days
#48402$962 days

Threadanalytics

David Mensah9:41 AM

@Dot I need upgrade leads: which free accounts had more than 10 active users this month?

1 reply

DotAPP9:42 AM

10 steps · 51s · Access Online

31 accounts, with 870 active users between them.

Sources: Postgres’ accounts and sessions.

Here is the data.

AccountActive users
Lumen64
Corvid52
Halden41

Connect Postgres

  • Read-only user and group
  • SSL required by default
  • SSH tunnel through a bastion
  • RDS, Cloud SQL, Azure or self-hosted

More in Databases & spreadsheets

Connect your data.

Start for Free