Issues

• High (spin) contention under high DB connection counts

  legrandlegrand/pg_stat_sql_plans#29 · Filter by author legrandlegrand opened on Jul 1, 2020

• duplicated qpid in logs when pg_stat_sql_plans.explain=true

  legrandlegrand/pg_stat_sql_plans#27 · Filter by author legrandlegrand opened on Jun 10, 2020
  1

  

• clean up pgssp_backend_qpid() on process exit

  bug
  legrandlegrand/pg_stat_sql_plans#26 · Filter by author legrandlegrand opened on May 31, 2020
  

• reset previous pgssp_backend_qpid(pid) on parsing error

  legrandlegrand/pg_stat_sql_plans#25 · Filter by author legrandlegrand opened on May 31, 2020

• do not build PlanId for simple INSERT commands (and others)

  enhancement
  legrandlegrand/pg_stat_sql_plans#19 · Filter by author legrandlegrand opened on Apr 4, 2020

• normalize_query syntax problems (lisibility)

  enhancement
  legrandlegrand/pg_stat_sql_plans#14 · Filter by author legrandlegrand opened on Mar 13, 2020
  

• sqlplus: SET AUTOTRACE ON EXPLAIN equivalent

  how to
  legrandlegrand/pg_stat_sql_plans#13 · Filter by author legrandlegrand opened on Apr 22, 2019
  

• store search_path for current entry

  how to
  legrandlegrand/pg_stat_sql_plans#6 · Filter by author legrandlegrand opened on Dec 17, 2018
  

• regression tests missing

  bug
  legrandlegrand/pg_stat_sql_plans#5 · Filter by author legrandlegrand opened on Dec 15, 2018
  

• catch non default GUCs in execution context, impacting execution plan

  how to
  legrandlegrand/pg_stat_sql_plans#4 · Filter by author legrandlegrand opened on Dec 15, 2018
  2

  

• offer a way to exclude queries from being monitored

  enhancement
  legrandlegrand/pg_stat_sql_plans#3 · Filter by author legrandlegrand opened on Dec 13, 2018
  2

  

• reset statistics of a specific query (or db or user)

  enhancement
  legrandlegrand/pg_stat_sql_plans#1 · Filter by author legrandlegrand opened on Dec 12, 2018