Article - CS261072

Enabling SQL Statement Logging on PostgreSQL to troubleshoot ThingWorx Platform

Modified: 08-Oct-2025   


Applies To

  • ThingWorx Platform 6.5 to 10.0
  • PostgreSQL

Description

  • How to enable additional logging on a PostgreSQL database?
  • How to enable SQL Statement Logging on a PostgreSQL database?
  • How to get timings for SQL statements on a PostgreSQL database?
  • How to troubleshoot a ThingWorx Platform instance that is experiencing slow performance stemming from the PostgreSQL database
  • Need to enable statement logging for ThingWorx Platform PostgreSQL database that is hosted by a Cloud Provider such as Azure or Amazon
  • ThingWorx is backed by a PostgreSQL as a Service database in Azure which is experience performance issues
  • Is it possible to get all of the parameter values passed to the PostgreSQL database from ThingWorx Platform for a given statement?
This is a printer-friendly version of Article 261072 and may be out of date. For the latest version click CS261072