-
ge
-
apply a "greater than or equal to" operator to a WHERE condition, instead of the default equality matching
-
get_column_names
-
retuns a list of all column names. These will be exactly the same as the columns returned by the query.
-
get_create
-
Extract the table names from a query, and return the result of SHOW CREATE TABLE tablename;
-
get_create_table
-
Get the create table definitions for the query
-
get_custom_fields
-
returns a list of custom fields names.
-
get_data_source
-
Given a data source name, get the properties for it.
-
get_data_source_names
-
Get the list of names for the configured data sources
-
get_default_report_action
-
return the default report action name; usually either report or graph_search
-
get_distinct_values
-
given a table and column, find all the unique values. This is a utility method often used when building dropdown lists on a search form, or getting values for pivot operations.
-
get_explain_for_sample
-
try to get the explain plan for a query
-
get_form_fields
-
get the field names for the given report
-
get_form_fields
-
return the list of form fields defined by the configuration parameters used to construct this object. Field names are prefixed by the table *alias*
-
get_form_field_values
-
return an associate array with form_field_name => value for all fields.
-
get_pivot_values
-
return the list of values for a given pivot column
-
get_query_advisor
-
invoke pt-query-advisor and get its output
-
get_query_by_checksum
-
given a checksum, return the full database row from the fact table for it.
-
get_query_samples
-
Retrieve query samples from the history table, ordered from most recent
-
get_report
-
get the full config information for the given report.
-
get_report_defaults
-
get the default search values for the specified report type
-
get_reviewers
-
Return a list of reviewers defined by the config file
-
get_review_types
-
return the list of review types. This is a configurable list of short text statuses that can describe the query.
-
get_search_uri
-
return a urlencoded string of parameters that were used in this report.
-
get_tables
-
returns the list of table names, not the aliases
-
get_tables_from_query
-
Try to parse the real table names out of a sql query
-
get_table_by_alias
-
gets the concrete name of a table for the given alias
-
get_table_fields
-
select the field names for the report tables from the database.
-
get_table_status
-
Get the table status info for the given query
-
get_table_status
-
Extract the table names and the return the result of SHOW TABLE STATUS LIKE 'tablename' for each table;
-
get_var
-
search global request variables $_POST and $_GET in that order and return the first defined value for the given key
-
get_visual_explain
-
invoke pt-visual-explain and get its output
-
graph_search
-
Search by using a graph. A brief search form is shown to allow a graph to be built. Html table results that corespond to the time range of the graph is displayed below. Regions can be selected in the graph directly which will update the table results with the new time range.
-
group
-
set the GROUP BY expression
-
gt
-
greater than: see documentation for ge()