PostgreSQL: Tracking statistics of SQL planning and execution (pg_stat_statements)

This documentation is part of the Getting started guide. You can view the complete guide here: How to get started with PostgreSQL.

👋 Welcome to the Stackhero documentation!

Stackhero offers a ready-to-use PostgreSQL cloud solution that provides a host of benefits, including:

  • Unlimited connections and data transfers.
  • PgAdmin web UI included.
  • Many modules included like PostGIS, TimescaleDB and PgVector.
  • Effortless updates with just a click.
  • Optimal performance and robust security powered by a private and dedicated VM.

Save time and simplify your life: it only takes 5 minutes to try Stackhero's PostgreSQL cloud hosting solution!

To enable support for pg_stat_statements, first enable it in your PostgreSQL configuration via the Stackhero dashboard. Then, enable the extension for your current database by running:

CREATE EXTENSION pg_stat_statements;

For more information, please refer to the PostgreSQL official documentation.

Continue reading this guide

  1. Read the full guide: Getting started
    How to get started with PostgreSQL
  2. Using the PostgreSQL psql CLI
  3. Creating a user and database in PostgreSQL
  4. Importing data from your computer to PostgreSQL
  5. Exporting data from PostgreSQL to your computer
  6. Using PostgreSQL with Node.js
  7. Using PostgreSQL with Node.js/TypeORM
  8. Using PostgreSQL with Django
  9. Activating PostgreSQL PostGIS extension
  10. Deactivating PostgreSQL PostGIS extension
  11. Activating PgVector extension
  12. Activating TimescaleDB extension
  13. Configuring PostgreSQL with Skyvia

Other articles for PostgreSQL

  1. Alternative to ElephantSQL shutdown
  2. Automate with the CLI
    Start PostgreSQL, retrieve its credentials, and modify its configuration programmatically using the Stackhero CLI
  3. GitHub Actions & GitLab CI
    Launch a real PostgreSQL service from your GitHub Actions or GitLab CI pipeline, run your tests against it, and automatically tear it down