Skip to content
This repository

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
branch: master

Mar 30, 2014

  1. Tomas Vondra

    Fixed to handle 9.3 API change (hook signature changed) and other bit…

    …rot (header files etc.)
    authored March 30, 2014

Sep 28, 2012

  1. Tomas Vondra

    Minor doc updates, switched to 'stable' status.

    authored September 28, 2012

Jan 06, 2012

  1. Tomas Vondra

    README switched to markdown.

    authored January 06, 2012

Jan 03, 2012

  1. Tomas Vondra

    Relicensed to BSD (instead of GPLv3).

    authored January 03, 2012

Nov 12, 2011

  1. Tomas Vondra

    Update to fit recommended dir structure for PGXN.

    authored November 12, 2011

Nov 09, 2011

  1. Tomas Vondra

    Added ProcessUtility_hook to track utility commands (DDL etc.). Intro…

    …duced a new boolean GUC 'query_histogram.track_utility' to control this (true by default).
    authored November 09, 2011

Nov 06, 2011

  1. Tomas Vondra

    Added support for 9.0 (not all executor hooks supported, different nu…

    …mber of params when defining GUC options, different assign hook signature).
    authored November 06, 2011

Nov 04, 2011

  1. Tomas Vondra

    Fix of some errors in the META.json file (version, URLs etc.).

    authored November 04, 2011

Nov 03, 2011

  1. Tomas Vondra

    Enhancement of the META.json - added link to the git repository and a…

    … blog post.
    authored November 04, 2011
  2. Tomas Vondra

    Added average time for each bin (in miliseconds).

    authored November 04, 2011
  3. Tomas Vondra

    Extension of the previous commit - proper passing of 64-bit values fr…

    …om the SRF.
    authored November 04, 2011
  4. Tomas Vondra

    Replaced 32-bit counters (unsigned long and float4) with 64-bit ones …

    …(unsigned long long and float8).
    authored November 04, 2011
  5. Tomas Vondra

    Added PGXN Meta Spec for the package.

    authored November 04, 2011

Nov 01, 2011

  1. Tomas Vondra

    Fix of loading the initial GUC valus (must not work with the default_…

    …histogram_dynamic variable, as that may not be set).
    authored November 01, 2011
  2. Tomas Vondra

    Added tracking when was the histogram reset.

    authored November 01, 2011
  3. Tomas Vondra

    Proper check of the histogram when loading (the parameters have to be…

    … equal when the histogram is not dynamic).
    authored November 01, 2011
  4. Tomas Vondra

    Proper init of the local variables, when loading data from the file.

    authored November 01, 2011
  5. Tomas Vondra

    Added support for logarithmic histograms - computation of the bins, etc.

    authored November 01, 2011
  6. Tomas Vondra

    Implemented save/load of the histogram to a file (global/query_histog…

    …ram.stat).
    authored November 01, 2011
  7. Tomas Vondra

    Fix of the query_histogram_enabled() - when the histogram is dynamic,…

    … it's always enabled.
    authored November 01, 2011
  8. Tomas Vondra

    Added two TODO with possible enhancements (per database histogram, li…

    …st of databases).
    authored November 01, 2011
  9. Tomas Vondra

    Rewrite of the shared memory / locking code - using ShmemInitStruct/L…

    …WLocks instead of custom code and semaphores.
    
    From now on, the module has to be loaded using shared_preload_libraries to actually use it (it's possible to create the extension, but it's not possible to use it when loaded by a backend). But
    that's actually a good thing, as this forces all backends to update the histogram.
    authored November 01, 2011

Oct 31, 2011

  1. Tomas Vondra

    ID of the shared memory segment (and semaphore set) is not hard-coded…

    … anymore, it's related to PostPortNumber so that there may be separate histograms for different clusters. This needs to be
    
    further enhanced (to check that the shared segment really contains a histogram). See the FIXME at query_hist_init().
    authored October 31, 2011

Oct 30, 2011

  1. Tomas Vondra

    Added refresh of the local variables to the add_query method (to refr…

    …esh it more often).
    authored October 31, 2011
  2. Tomas Vondra

    Added ability to scale the histogram as if the sampling rate was 100%.

    authored October 31, 2011
  3. Tomas Vondra

    Removed units from definition of sample_pct and bin_count GUCs.

    authored October 30, 2011
  4. Tomas Vondra

    Fix of the sampling (was missing one percent of the queries).

    authored October 30, 2011
  5. Tomas Vondra

    Fix of a syntax error in the explain_ExecutorEnd hook (missing parent…

    …hesis).
    authored October 30, 2011
  6. Tomas Vondra

    README and description of the extension.

    authored October 30, 2011
  7. Tomas Vondra

    Fix of sampling (modulo returns 0..99 so we need to subtract 1 from t…

    …he sample_pct).
    authored October 30, 2011
  8. Tomas Vondra

    The query now returns time as REAL (float4) column and in seconds (bi…

    …ns are still in miliseconds).
    authored October 30, 2011

Oct 29, 2011

  1. Tomas Vondra

    Refreshing sample_pct (copy from the segment to local memory) wheneve…

    …r adding a new query (once we actually lock the segment).
    authored October 30, 2011
  2. Tomas Vondra

    When sampling, the backends are referencing default_histogram_sample_…

    …pct (possibly stale), instead of (*histogram_sample_pct) as that requires acquring a semaphore.
    authored October 30, 2011
  3. Tomas Vondra

    Implemented histogram shared by backends (shared memory segment and a…

    … semaphore).
    authored October 30, 2011
  4. Tomas Vondra

    Initial version of the histogram (works only within a single connecti…

    …on).
    authored October 29, 2011
Something went wrong with that request. Please try again.