testdb=# \dx+ pg_profile
Objects in extension "pg_profile"
Object description
-------------------------------------------------------------------------------------------------
function profile.cluster_stat_io_format(integer,integer,integer)
function profile.cluster_stat_io_format(integer,integer,integer,integer,integer)
function profile.cluster_stat_io(integer,integer,integer)
function profile.cluster_stat_io_reset_format(integer,integer,integer)
function profile.cluster_stat_io_reset_format(integer,integer,integer,integer,integer)
function profile.cluster_stat_io_resets(integer,integer,integer)
function profile.cluster_stats_format_diff(integer,integer,integer,integer,integer)
function profile.cluster_stats_format(integer,integer,integer)
function profile.cluster_stats(integer,integer,integer)
function profile.cluster_stat_slru_format(integer,integer,integer)
function profile.cluster_stat_slru_format(integer,integer,integer,integer,integer)
function profile.cluster_stat_slru(integer,integer,integer)
function profile.cluster_stat_slru_reset_format(integer,integer,integer)
function profile.cluster_stat_slru_reset_format(integer,integer,integer,integer,integer)
function profile.cluster_stat_slru_resets(integer,integer,integer)
function profile.cluster_stats_reset_format_diff(integer,integer,integer,integer,integer)
function profile.cluster_stats_reset_format(integer,integer,integer)
function profile.cluster_stats_reset(integer,integer,integer)
function profile.collect_obj_stats(jsonb,integer,integer,boolean)
function profile.collect_pg_stat_statements_stats(jsonb,integer,integer,integer)
function profile.collect_pg_wait_sampling_stats_11(jsonb,integer,integer,integer)
function profile.collect_pg_wait_sampling_stats(jsonb,integer,integer,integer)
function profile.collect_subsamples(integer,integer,jsonb)
function profile.create_baseline(character varying,integer,integer,integer)
function profile.create_baseline(character varying,tstzrange,integer)
function profile.create_baseline(name,character varying,integer,integer,integer)
function profile.create_baseline(name,character varying,tstzrange,integer)
function profile.create_server(name,text,boolean,integer,text)
function profile.create_server_partitions(integer)
function profile.dbstats_format_diff(integer,integer,integer,integer,integer)
function profile.dbstats_format(integer,integer,integer)
function profile.dbstats(integer,integer,integer)
function profile.dbstats_reset_format_diff(integer,integer,integer,integer,integer)
function profile.dbstats_reset_format(integer,integer,integer)
function profile.dbstats_reset(integer,integer,integer)
function profile.delete_samples(integer,integer)
function profile.delete_samples(integer,integer,integer)
function profile.delete_samples(name,integer,integer)
function profile.delete_samples(name,tstzrange)
function profile.delete_samples(tstzrange)
function profile.disable_server(name)
function profile.drop_baseline(character varying)
function profile.drop_baseline(name,character varying)
function profile.drop_server(name)
function profile.enable_server(name)
function profile.export_data(name,integer,integer,boolean)
function profile.get_baseline_samples(integer,character varying)
function profile.get_connstr(integer,jsonb)
function profile.get_diffreport(character varying,character varying,text,boolean)
function profile.get_diffreport(character varying,integer,integer,text,boolean)
function profile.get_diffreport(integer,integer,character varying,text,boolean)
function profile.get_diffreport(integer,integer,integer,integer,integer,text,boolean)
function profile.get_diffreport(integer,integer,integer,integer,text,boolean)
function profile.get_diffreport(name,character varying,character varying,text,boolean)
function profile.get_diffreport(name,character varying,integer,integer,text,boolean)
function profile.get_diffreport(name,character varying,tstzrange,text,boolean)
function profile.get_diffreport(name,integer,integer,character varying,text,boolean)
function profile.get_diffreport(name,integer,integer,integer,integer,text,boolean)
function profile.get_diffreport(name,tstzrange,character varying,text,boolean)
function profile.get_diffreport(name,tstzrange,tstzrange,text,boolean)
function profile.get_report(character varying,text,boolean)
function profile.get_report_context(integer,integer,integer,text,integer,integer)
function profile.get_report_datasets(jsonb,integer)
function profile.get_report(integer,integer,integer,text,boolean)
function profile.get_report(integer,integer,text,boolean)
function profile.get_report(integer,tstzrange,text,boolean)
function profile.get_report_latest(name)
function profile.get_report(name,character varying,text,boolean)
function profile.get_report(name,integer,integer,text,boolean)
function profile.get_report(name,tstzrange,text,boolean)
function profile.get_report_template(jsonb,integer)
function profile.get_report(tstzrange,text,boolean)
function profile.get_sampleids_by_timerange(integer,tstzrange)
function profile.get_server_by_name(name)
function profile.get_sized_bounds(integer,integer,integer)
function profile.import_data(regclass,text)
function profile.import_section_data_profile(refcursor,name,jsonb,jsonb,text[])
function profile.import_section_data_subsample(refcursor,name,jsonb,jsonb,text[])
function profile.init_sample(integer)
function profile.keep_baseline(character varying,integer)
function profile.keep_baseline(name,character varying,integer)
function profile.mark_pg_stat_statements(integer,integer,integer)
function profile.profile_checkavail_cluster_stats_reset(integer,integer,integer)
function profile.profile_checkavail_dbstats_reset(integer,integer,integer)
function profile.profile_checkavail_functions(integer,integer,integer)
function profile.profile_checkavail_io_times(integer,integer,integer)
function profile.profile_checkavail_planning_times(integer,integer,integer)
function profile.profile_checkavail_rusage(integer,integer,integer)
function profile.profile_checkavail_rusage_planstats(integer,integer,integer)
function profile.profile_checkavail_sessionstats(integer,integer,integer)
function profile.profile_checkavail_statements_jit_stats(integer,integer,integer)
function profile.profile_checkavail_statements_temp_io_times(integer,integer,integer)
function profile.profile_checkavail_statstatements(integer,integer,integer)
function profile.profile_checkavail_stmt_cnt(integer,integer,integer)
function profile.profile_checkavail_stmt_wal_bytes(integer,integer,integer)
function profile.profile_checkavail_tbl_top_dead(integer,integer,integer)
function profile.profile_checkavail_tbl_top_mods(integer,integer,integer)
function profile.profile_checkavail_top_temp(integer,integer,integer)
function profile.profile_checkavail_trg_functions(integer,integer,integer)
function profile.profile_checkavail_wait_sampling_total(integer,integer,integer)
function profile.profile_checkavail_walstats(integer,integer,integer)
function profile.profile_checkavail_wal_stats_reset(integer,integer,integer)
function profile.rename_server(name,name)
function profile.report_active_queries_format(jsonb,integer,jsonb)
function profile.report_queries_format(jsonb,integer,jsonb,integer,integer,integer,integer)
function profile.sample_dbobj_delta(jsonb,integer,integer,integer,boolean)
function profile.save_pg_stat_statements(integer,integer)
function profile.section_apply_conditions(jsonb,jsonb)
function profile.sections_jsonb(jsonb,integer,integer)
function profile.set_server_connstr(name,text)
function profile.set_server_db_exclude(name,name[])
function profile.set_server_description(name,text)
function profile.set_server_max_sample_age(name,integer)
function profile.set_server_size_sampling(name,time with time zone,interval,interval)
function profile.set_server_subsampling(name,boolean,interval,interval,integer,interval)
function profile.settings_and_changes(integer,integer,integer)
function profile.settings_format_diff(integer,integer,integer,integer,integer)
function profile.settings_format(integer,integer,integer)
function profile.show_baselines(name)
function profile.show_samples(integer)
function profile.show_samples(name,integer)
function profile.show_servers()
function profile.show_servers_size_sampling()
function profile.snapshot()
function profile.snapshot(name)
function profile.stat_activity_agg_format(integer,integer,integer)
function profile.stat_activity_agg_format(integer,integer,integer,integer,integer)
function profile.stat_activity_agg(integer,integer,integer)
function profile.stat_activity_states_format(integer,integer,integer)
function profile.stat_activity_states_format(integer,integer,integer,integer,integer)
function profile.stat_activity_states(integer,integer,integer)
function profile.statements_dbstats_format_diff(integer,integer,integer,integer,integer)
function profile.statements_dbstats_format(integer,integer,integer)
function profile.statements_dbstats(integer,integer,integer)
function profile.stmt_cnt_format_diff(integer,integer,integer,integer,integer)
function profile.stmt_cnt_format(integer,integer,integer)
function profile.stmt_cnt(integer,integer,integer)
function profile.tablespace_stats_format_diff(integer,integer,integer,integer,integer)
function profile.tablespace_stats_format(integer,integer,integer)
function profile.tablespace_stats(integer,integer,integer)
function profile.take_sample()
function profile.take_sample(integer,boolean)
function profile.take_sample(name,boolean)
function profile.take_sample_subset(integer,integer)
function profile.take_subsample()
function profile.take_subsample(integer,jsonb)
function profile.take_subsample(name)
function profile.take_subsample_subset(integer,integer)
function profile.top_functions_format_diff(integer,integer,integer,integer,integer)
function profile.top_functions_format(integer,integer,integer)
function profile.top_functions(integer,integer,integer)
function profile.top_indexes_format_diff(integer,integer,integer,integer,integer)
function profile.top_indexes_format(integer,integer,integer)
function profile.top_indexes(integer,integer,integer)
function profile.top_io_indexes_format_diff(integer,integer,integer,integer,integer)
function profile.top_io_indexes_format(integer,integer,integer)
function profile.top_io_indexes(integer,integer,integer)
function profile.top_io_tables_format_diff(integer,integer,integer,integer,integer)
function profile.top_io_tables_format(integer,integer,integer)
function profile.top_io_tables(integer,integer,integer)
function profile.top_kcache_statements(integer,integer,integer)
function profile.top_rusage_statements_format_diff(integer,integer,integer,integer,integer)
function profile.top_rusage_statements_format(integer,integer,integer)
function profile.top_statements_format_diff(integer,integer,integer,integer,integer)
function profile.top_statements_format(integer,integer,integer)
function profile.top_statements(integer,integer,integer)
function profile.top_tables_format_diff(integer,integer,integer,integer,integer)
function profile.top_tables_format(integer,integer,integer)
function profile.top_tables(integer,integer,integer)
function profile.top_tbl_last_sample_format(integer,integer,integer)
function profile.top_toasts(integer,integer,integer)
function profile.top_wait_sampling_events_format_diff(integer,integer,integer,integer,integer)
function profile.top_wait_sampling_events_format(integer,integer,integer)
function profile.wait_sampling_total_stats_format_diff(integer,integer,integer,integer,integer)
function profile.wait_sampling_total_stats_format(integer,integer,integer)
function profile.wait_sampling_total_stats(integer,integer,integer)
function profile.wal_stats_format(integer,integer,integer,integer,integer,numeric,numeric)
function profile.wal_stats_format(integer,integer,integer,numeric)
function profile.wal_stats(integer,integer,integer)
function profile.wal_stats_reset_format_diff(integer,integer,integer,integer,integer)
function profile.wal_stats_reset_format(integer,integer,integer)
function profile.wal_stats_reset(integer,integer,integer)
sequence profile.baselines_bl_id_seq
sequence profile.servers_server_id_seq
sequence profile.session_attr_sess_attr_id_seq
table profile.act_query
table profile.baselines
table profile.bl_samples
table profile.funcs_list
table profile.import_queries_version_order
table profile.indexes_list
table profile.last_stat_activity
table profile.last_stat_activity_count
table profile.last_stat_activity_count_srv1
table profile.last_stat_activity_srv1
table profile.last_stat_archiver
table profile.last_stat_cluster
table profile.last_stat_database
table profile.last_stat_database_srv1
table profile.last_stat_indexes
table profile.last_stat_indexes_srv1
table profile.last_stat_io
table profile.last_stat_kcache
table profile.last_stat_kcache_srv1
table profile.last_stat_slru
table profile.last_stat_statements
table profile.last_stat_statements_srv1
table profile.last_stat_tables
table profile.last_stat_tablespaces
table profile.last_stat_tablespaces_srv1
table profile.last_stat_tables_srv1
table profile.last_stat_user_functions
table profile.last_stat_user_functions_srv1
table profile.last_stat_wal
table profile.report
table profile.report_static
table profile.report_struct
table profile.roles_list
table profile.sample_act_backend
table profile.sample_act_backend_state
table profile.sample_act_statement
table profile.sample_act_xact
table profile.sample_kcache
table profile.sample_kcache_total
table profile.samples
table profile.sample_settings
table profile.sample_stat_activity_cnt
table profile.sample_stat_archiver
table profile.sample_stat_cluster
table profile.sample_stat_database
table profile.sample_statements
table profile.sample_statements_total
table profile.sample_stat_indexes
table profile.sample_stat_indexes_total
table profile.sample_stat_io
table profile.sample_stat_slru
table profile.sample_stat_tables
table profile.sample_stat_tablespaces
table profile.sample_stat_tables_total
table profile.sample_stat_user_functions
table profile.sample_stat_user_func_total
table profile.sample_stat_wal
table profile.sample_timings
table profile.servers
table profile.server_subsample
table profile.session_attr
table profile.stmt_list
table profile.tables_list
table profile.tablespaces_list
table profile.wait_sampling_total
view profile.v_sample_settings
view profile.v_sample_stat_indexes
view profile.v_sample_stat_tables
view profile.v_sample_stat_tablespaces
view profile.v_sample_stat_user_functions
view profile.v_sample_timings
(256 rows)
- 1.
- 2.
- 3.
- 4.
- 5.
- 6.
- 7.
- 8.
- 9.
- 10.
- 11.
- 12.
- 13.
- 14.
- 15.
- 16.
- 17.
- 18.
- 19.
- 20.
- 21.
- 22.
- 23.
- 24.
- 25.
- 26.
- 27.
- 28.
- 29.
- 30.
- 31.
- 32.
- 33.
- 34.
- 35.
- 36.
- 37.
- 38.
- 39.
- 40.
- 41.
- 42.
- 43.
- 44.
- 45.
- 46.
- 47.
- 48.
- 49.
- 50.
- 51.
- 52.
- 53.
- 54.
- 55.
- 56.
- 57.
- 58.
- 59.
- 60.
- 61.
- 62.
- 63.
- 64.
- 65.
- 66.
- 67.
- 68.
- 69.
- 70.
- 71.
- 72.
- 73.
- 74.
- 75.
- 76.
- 77.
- 78.
- 79.
- 80.
- 81.
- 82.
- 83.
- 84.
- 85.
- 86.
- 87.
- 88.
- 89.
- 90.
- 91.
- 92.
- 93.
- 94.
- 95.
- 96.
- 97.
- 98.
- 99.
- 100.
- 101.
- 102.
- 103.
- 104.
- 105.
- 106.
- 107.
- 108.
- 109.
- 110.
- 111.
- 112.
- 113.
- 114.
- 115.
- 116.
- 117.
- 118.
- 119.
- 120.
- 121.
- 122.
- 123.
- 124.
- 125.
- 126.
- 127.
- 128.
- 129.
- 130.
- 131.
- 132.
- 133.
- 134.
- 135.
- 136.
- 137.
- 138.
- 139.
- 140.
- 141.
- 142.
- 143.
- 144.
- 145.
- 146.
- 147.
- 148.
- 149.
- 150.
- 151.
- 152.
- 153.
- 154.
- 155.
- 156.
- 157.
- 158.
- 159.
- 160.
- 161.
- 162.
- 163.
- 164.
- 165.
- 166.
- 167.
- 168.
- 169.
- 170.
- 171.
- 172.
- 173.
- 174.
- 175.
- 176.
- 177.
- 178.
- 179.
- 180.
- 181.
- 182.
- 183.
- 184.
- 185.
- 186.
- 187.
- 188.
- 189.
- 190.
- 191.
- 192.
- 193.
- 194.
- 195.
- 196.
- 197.
- 198.
- 199.
- 200.
- 201.
- 202.
- 203.
- 204.
- 205.
- 206.
- 207.
- 208.
- 209.
- 210.
- 211.
- 212.
- 213.
- 214.
- 215.
- 216.
- 217.
- 218.
- 219.
- 220.
- 221.
- 222.
- 223.
- 224.
- 225.
- 226.
- 227.
- 228.
- 229.
- 230.
- 231.
- 232.
- 233.
- 234.
- 235.
- 236.
- 237.
- 238.
- 239.
- 240.
- 241.
- 242.
- 243.
- 244.
- 245.
- 246.
- 247.
- 248.
- 249.
- 250.
- 251.
- 252.
- 253.
- 254.
- 255.
- 256.
- 257.
- 258.
- 259.
- 260.
- 261.