Introduction

This software package provides a comprehensive set of replacement system tables for Amazon Redshift, which are intended to supersede the system tables shipped with Amazon Redshift.

The replacement system tables are versioned (in their schema names), and so you can have multiple versions installed and in use concurrently.

The main reason for this is so that any existing scripting continues to work when you install a new version.

A secondary reason is that it provides protection against any issues in a new version; you can just go back to using an earlier version. I intend there not to be any issues, but we’re talking production systems here, and depending on the absence of issues is unnecessary, not fail safe, and as experience tells us, entirely unrealistic. Only Knuth and Dijkstra have no issues.

Additionally, it allows me as the developer freedom to make substantial changes in structure and layout, because those changes will not break existing systems.

Installation

The replacement system tables are shipped as a single SQL file, with the name rst_YYMMDD.sql.

To install, run the SQL file on your cluster.

Installing more than once (presumably by accident) is fine; it does no harm.

Databases

The replacement system tables obtain their data from the Redshift system tables. The Redshift system tables have a mix of tables where some contain data for all databases, and some contain data only for the current database. Exactly which tables have what is not documented.

I spent some time once trying to see if I could compose a decent set of tables which would be cross-database, but it became clear this hasn’t been a design goal of the system tables, and that it isn’t possible - you find vital information is database specific.

As such, the replacement system tables inherit this problem from the Redshift system tables, and so the replacement system tables need to be installed in each database you wish to use them with.

Documentation

The documentation pages in this PDF are installed in the table base_YYMMDD.docs.

To see what’s installed for you to use;

select schema_name, object_name from base_YYMMDD.docs order by schema_name, object_name;

To view the documentation page for an object (substituting the schema name and object name of whatever you’re interested in);

select * from base_YYMMDD.docs where schema_name = 'sf' and object_name = 'ttables';

Privileges

Remember that users, groups, roles and privileges are independent of databases. The replacement system tables installer installs and only installs, the tables, views, procedures and functions which are the replacement system tables. It does nothing with users, groups, roles or privileges. The arrangement and configuration of privileges is wholly your responsibility. However, the replacement system tables in the ro schema procedures to easily grant or revoke privileges to the replacement system tables to users, groups, roles or to public.

Overview

The installer creates four schemas, and populates them with views, one or two tables, and a couple of functions and procedures.

The schemas are;

1. ro (this schema has no version and is shared across all versions)
2. base_YYMMDD
3. lf_YYMMDD
4. sf_YYMMDD

There is a fifth schema, which you can after installation create and/or remove as you wish (and the purpose of which is described below);

1. sf (this schema also has no version, but it is not shared - it points at a single installed version)

The version numbers are necessary so that multiple versions of the replacement system tables can be concurrently installed. The version is the YYMMDD of the day the installer was created, and it is appended (after an underscore) to the schema name.

The two unversioned schemas (ro and sf) are special and they, and the other schemas, are described below.

Schemas

ro

The ro schema is, if you like, the master schema, containing a single view which enumerates installed replacement system table versions, and a set of procedures to uninstall versions, and to grant or revoke privileges to a version to a user, group, role or to public.

There is only one ro schema, and it is used for all versions of the replacement system tables.

When you run the installer, the ro schema if it does not exist is created. If it does exist, it is replaced with the latest version.

base_YYYMMDD

The base_YYMMDD schema contains a range of helper-type views and one or two helper-type tables, all of which are used by the rest of the replacement system tables. They are helpful, users can use them too, but they are intended in the first instance for internal use by the replacement system tables.

lf_YYYMMDD

The name of the lf_YYMMDD schema is short for long form. These views are the replacement system tables, and the views in the long form schema (unlike those in the short form schema, below) are intended for use by users for scripting and for automation. They are not intended for direct use by humans. As such, these views contain ID columns, have long and explanatory column names, make no effort at all to keep row widths short (to avoid wrapping in the console), break out data such as booleans into individual columns for easy use in query logic, and so on.

sf_YYYMMDD

The name of the lf_YYMMDD schema is short for short form. These views are a presentation layer, each sitting on top of its matching long form view, intended for direct use by humans, in an SQL console. The query on the sf schema always always uses and only uses select *, as the view is designed for all columns to always be selected. ID columns are removed, less important columns are omitted, column names are shortened, columns can be amalgamated into single columns for ease of reading, long numbers are converted into human-readable forms (TB/GB/MB, b/m/k, and so on), numbers are truncated (where appropriate) to two decimal places, strings which psql fails to auto-complete on (such as table and procedure) have their first letter duplicated, keywords which are column names also have their first letter duplicated (uuser), and particular effort is taken to ensure rows are narrow, so they do not wrap in the console.

sf

Once the replacement system tables are installed, you have three versioned schemas and the ro schema.

Where the schema names contain their version string, they are long. There has to be a unique identifier in the schema names so multiple versions can be concurrently installed, and so we have to bear this cross when it comes to scripting and use the long name of the lf schema, but the sf schema is intended for direct human use in an SQL client. The long schema name is a fundamental problem.

Now, I see two solutions to this.

Firstly, you modify the schema search path for users so that the sf_YYMMDD schema of the version you want to use, is in their path. Awkward, but you can do it, and it allows you to select which version you use. I’m thinking of making a procedure to do this (to add and to remove), but that’s not done yet.

Secondly, what can be done is a versionless schema sf is created, and it contains views which simply select * from every matching view in a versioned sf schema.

Support for the second option, the creation of, dropping of, and granting and revoking privileges to and from, has been implement as procedures in the ro schema. Please see the ro schema docs for an overview and the documentation pages for the procedures.

As such, you can make and repoint this schema as you wish, and simply tell users “use the sf schema”.

Naming Conventions

1. The first word of every object is the broad area the object concerns - queries, ttables, users, etc.

2. Words which require quoting in psql have their first letter repeated (to most easily avoid the need for quoting).

3. The final stanza for many views is of the form _on_[node]_for_[entity]_by_[period], such as;

   sf.queries_stats_durations_on_leader_for_all_by_all
sf.queries_totals_aborts_on_workers_for_user_by_day
sf.steps_totals_data_on_both_for_slice_by_hour

   The node noun can be leader, workers, or both. With both, leader and worker are both reported, but they are never conflated - they have their own rows in the output, and have been handled independently of each other.

   The entity noun has quite a few values, and is used to select on what basis data is aggregated - so we might aggregate by schema, or by table, or user, etc.

   The period noun is the period over which data is aggregated. This almost always is the five values all, day, hour, minute, second. This is used by looking for at the high level, day, noticing odd days, then looking at the hours for the day, seeing where the oddness happened, and so on, until you found exactly where whatever it was happened.

4. There are quite a lot of schemas where the second word is stats or totals. In general, the stats views provide min/max/median/mean/stddev, and totals provides only a count. I’m in the process of adding a sum column to the stats views, which will mean I can get rid of the matching totals view. However, for a few totals views, the idea of stats makes no sense, and so they will remain.

5. The first word wqueues is short for wlm_queues, and the reason I use it is because queues overlaps with queries which is awkward for tab-complete in psql.

Uninstallation

To list all installed schemas;

select * from ro.installed_versions;

To uninstall a release (a stored procedure, and so the name begins with sp_);

call ro.sp_uninstall_version( 'YYMMDD' );

If you want to wholly remove the replacement system tables, uninstall all releases, and then you will need to manually cascade drop the ro schema.

Granting, Revoking, and Enumerating Granted, Privileges

Installing a release does and only does exactly that; installation - which is to say, creation of schemas, tables, views, functions and procedures. No configuration occurs - no privileges are granted, no groups are created, etc.

The privileges arrangement is wholly up to you.

Tooling is provided to make working with privileges easy.

Please see the ro schema docs for an overview and the documentation pages for the tooling.

Usage Guide

I want here to touch upon some of the important views and sets of functionality.

Very nearly nothing here is written up yet, so the doc pages for each view normally show you the columns only (I’ve just added in the write-up for sf_241129.utils_queries_benchmark, the very first :-)

One note; the Redshift system tables have a partial most-oldest-day. The RST views always exclude this partial day. Whnever you see results, they are always for whole days, excepting that the current day of course is also partial.

Real-Time System Status

There’s actually only a small set of views which provide functionality to inspect the system in its current, “what are you doing now?”, sense.

sf_241129.locks_by_table
sf_241129.locks_by_transaction
sf_241129.queries_queued
sf_241129.queries_running
sf_241129.sessions_fast
sf_241129.sessions_full
sf_241129.wqueues
sf_241129.wqueues_qmr_log

Query Development and Debugging

There are two absolutely critical views for this.

sf_241129.queries_step_plan
sf_241129.utils_queries_benchmark

Statistics / Totals

Views with the word stats usually provide min / max / med / avg / std. I’m in the process of adding sum.

Views with the word totals usually provide only a sum, and they will mainiy be integrated into a stats view, but there are a few views I think where stats make no sense, so you only have a total.

The _by_day variant is useful to get an idea of change over time.

You can drlil down to find problem queries by using the _by_hour, _by_minute, and _by_second view variants.

System Information

sf_241129.blocks_rows_totals_for_cluster
sf_241129.blocks_rows_totals_for_node
sf_241129.blocks_rows_totals_for_schema
sf_241129.blocks_rows_totals_for_slice
sf_241129.blocks_rows_totals_for_table
sf_241129.blocks_rows_totals_for_user
sf_241129.blocks_rows_totals_for_tables_by_node
sf_241129.blocks_rows_totals_for_tables_by_slice
sf_241129.groups
sf_241129.groups_users
sf_241129.objects
sf_241129.privileges_granted_to_groups
sf_241129.privileges_granted_to_public
sf_241129.privileges_granted_to_users
sf_241129.queries_for_all
sf_241129.queries_for_leader
sf_241129.queries_for_worker
sf_241129.sschemas
sf_241129.sschemas_blocks_rows
sf_241129.sschemas_blocks_rows_activity
sf_241129.transactions
sf_241129.ttables
sf_241129.ttables_blocks_rows
sf_241129.ttables_blocks_rows_activity
sf_241129.ttables_columns
sf_241129.ttables_columns_blocks
sf_241129.uusers
sf_241129.views_late_binding
sf_241129.views_late_binding_columns
sf_241129.views_materialized
sf_241129.views_materialized_columns
sf_241129.views_normal
sf_241129.views_normal_columns

Misc

sf.ttables_zonemap
sf_241129.utils_most_recent_copy_error_for_current_user

License

1. You are free to use this software/documentation in any way, including lifting code/structure/ideas from it for your own and/or organization and/or client use, excepting that you cannot use this software/documentation to create, support, develop, or anything like that, a competing product, commerical or free. My concern here is an entity making or improving their own product or software from this work, which they then publish and which by being published, competes; for I will in due course release a paid version of the replacement system tables, with system table archiving.

2. You cannot use this software if you, or the organization of whatever kind that you work for, pay tax in Belarus, China, Cuba, Hungary, Iran, North Korea, Russia, South Africa, Syria, or Venezuela. This is to do with Putin’s invasion of Ukraine. My concern here is my work contributing to the tax revenue of these countries, where a fraction of that tax revenue is paying for the appalling horrors of the invasion of Ukraine (and also in the case of China, the likely future invasion of Taiwan).

3. This software, its documentation, or anything to do with it, cannot be used as data of any kind for ML/AI/LLM and the like. My concern here is working for ten plus years to become a Redshift expert, and then a third party taking my knowledge, putting it into ML/AI/LLM and the like and providing my knowledge for free, or indeed even charging for it and taking that revenue to themselves.

Known Issues

Where to even begin? :-)

1. The big biggie - there is no test suite yet. Until there is, this is not a serious piece of software. There was a partial test suite for an earlier version, which tested quite a lot of static-type functionality, where the test suite would create and randomly populate clusters, and so it knew what was in the cluster, and so was able to compare the output of views to what should be there. However, I have not yet implemented this for these replacement system tables, and there was never in the past a test suite for dynamic functionality - testing queries, transactions, etc.

2. There’s a lot of as-yet unimplemented functionality. I need to bring over (from earlier iterations of replacement system tables) views for roles, for external tables, and create views for data shares, meh, the list goes on.

3. I’ve not implemented proper formatting yet throughout all the short-form views. You’ll notice this when the output isn’t nicely lined up.

4. The docs have not been written. The mechanism to auto-create the pages directly from SQL and to bring in manually created pages (such as this) exists (which is how you’re reading this), but I need to write descriptions now for something like 2000 views and columns. This may take a while :-)

5. AWS do not publish the Redshift BNF, so I have to use the Postgres BNF. I parse my SQL to auto-generate the docs. This means I write my SQL to be Postgres compliant (and so I specifically avoid a few bits of new RS functionality, because I can’t parse it), but I can’t parse Redshift tables because their SQL cannot be made Postgres compliant. There are three tables in the replacement system tables, and I’ll need to do some work to get them into the docs, which I’ve not yet done.

Benchmarks

1. These benchmarks are created on a reasonably populated dev cluster. The absolute times mean nothing, your cluster will run at whatever speed it gives you, but the relative times convey which views are slow and which are fast.

2. The sf views call their matching lf view and have very little overhead (some used to, because I had used the wrong approach in the SQL, but that all was fixed).

3. Stats are : “run times (in order of execution) : min / max / median / mean / standard deviation”, all times in seconds, the smaller the better.

4. All benchmarks are beginning of execution (not queuing) to beginning of return of rows to client.

   • all benchmark times from are system tables; nothing external to Redshift is involved
   • compilation time is removed from execution time (although this cannot be done for compilation hand-over, but I think this is rare in the benchmarks)

5. _by_day views are benchmarked for all days; _by_hour for 1 day, _by_minute for 1 hour, _by_second for 1 minute.

   • running _by_second views with a large _for, such as _for_table, and asking for all rows (so no time constraint), results in queries which do not return in a timely manner.

[object name] : list of durations : min / max / median / mean / std dev

base_241129.docs                                                       : 0.00,0.00 : 0.00 / 0.00 / 0.00 / 0.00 / 0.00
base_241129.fixed_pg_attribute                                         : 0.00,0.00 : 0.00 / 0.00 / 0.00 / 0.00 / 0.00
base_241129.fixed_pg_attribute_for_tables                              : 0.00,0.00 : 0.00 / 0.00 / 0.00 / 0.00 / 0.00
base_241129.fixed_pg_attribute_for_views                               : 0.00,0.00 : 0.00 / 0.00 / 0.00 / 0.00 / 0.00
base_241129.fixed_pg_class                                             : 0.00,0.00 : 0.00 / 0.00 / 0.00 / 0.00 / 0.00
base_241129.fixed_pg_class_for_tables                                  : 0.00,0.00 : 0.00 / 0.00 / 0.00 / 0.00 / 0.00
base_241129.fixed_pg_class_for_views                                   : 0.00,0.00 : 0.00 / 0.00 / 0.00 / 0.00 / 0.00
base_241129.fixed_pg_get_late_binding_view_cols                        : 1.03,0.57 : 0.57 / 1.03 / 0.80 / 0.80 / 0.23
base_241129.fixed_pg_group                                             : 0.00,0.00 : 0.00 / 0.00 / 0.00 / 0.00 / 0.00
base_241129.fixed_pg_language                                          : 0.00,0.00 : 0.00 / 0.00 / 0.00 / 0.00 / 0.00
base_241129.fixed_pg_namespace                                         : 0.00,0.00 : 0.00 / 0.00 / 0.00 / 0.00 / 0.00
base_241129.fixed_pg_proc                                              : 0.00,0.00 : 0.00 / 0.00 / 0.00 / 0.00 / 0.00
base_241129.fixed_pg_proc_for_functions                                : 0.00,0.00 : 0.00 / 0.00 / 0.00 / 0.00 / 0.00
base_241129.fixed_pg_proc_for_procedures                               : 0.00,0.00 : 0.00 / 0.00 / 0.00 / 0.00 / 0.00
base_241129.fixed_pg_user                                              : 0.00,0.00 : 0.00 / 0.00 / 0.00 / 0.00 / 0.00
base_241129.fixed_stl_commit_stats                                     : 0.62,0.38 : 0.38 / 0.62 / 0.50 / 0.50 / 0.12
base_241129.fixed_stl_ddltext                                          : 1.29,1.10 : 1.10 / 1.29 / 1.19 / 1.19 / 0.09
base_241129.fixed_stl_load_errors                                      : 0.28,0.10 : 0.10 / 0.28 / 0.19 / 0.19 / 0.09
base_241129.fixed_stl_query                                            : 4.74,5.01 : 4.74 / 5.01 / 4.88 / 4.88 / 0.14
base_241129.fixed_stl_query_metrics                                    : 0.41,0.78 : 0.41 / 0.78 / 0.60 / 0.60 / 0.19
base_241129.fixed_stl_querytext                                        : 1.78,1.28 : 1.28 / 1.78 / 1.53 / 1.53 / 0.25
base_241129.fixed_stl_scan                                             : 4.90,4.74 : 4.74 / 4.90 / 4.82 / 4.82 / 0.08
base_241129.fixed_stl_utilitytext                                      : 2.30,2.38 : 2.30 / 2.38 / 2.34 / 2.34 / 0.04
base_241129.fixed_stl_vacuum_detail                                    : 0.12,0.35 : 0.12 / 0.35 / 0.23 / 0.23 / 0.12
base_241129.fixed_stl_wlm_query                                        : 0.47,0.48 : 0.47 / 0.48 / 0.47 / 0.47 / 0.01
base_241129.fixed_stl_wlm_rule_action                                  : 0.10,0.23 : 0.10 / 0.23 / 0.16 / 0.16 / 0.06
base_241129.fixed_stv_blocklist                                        : 0.25,0.20 : 0.20 / 0.25 / 0.23 / 0.23 / 0.03
base_241129.fixed_stv_inflight                                         : 0.01,0.01 : 0.01 / 0.01 / 0.01 / 0.01 / 0.00
base_241129.fixed_stv_query_metrics                                    : 0.01,0.01 : 0.01 / 0.01 / 0.01 / 0.01 / 0.00
base_241129.fixed_stv_slices                                           : 0.03,0.03 : 0.03 / 0.03 / 0.03 / 0.03 / 0.00
base_241129.fixed_stv_wlm_classification_config                        : 0.01,0.01 : 0.01 / 0.01 / 0.01 / 0.01 / 0.00
base_241129.fixed_stv_wlm_qmr_config                                   : 0.02,0.02 : 0.02 / 0.02 / 0.02 / 0.02 / 0.00
base_241129.fixed_stv_wlm_query_state                                  : 0.01,0.01 : 0.01 / 0.01 / 0.01 / 0.01 / 0.00
base_241129.fixed_stv_wlm_service_class_config                         : 0.02,0.03 : 0.02 / 0.03 / 0.02 / 0.02 / 0.00
base_241129.fixed_stv_wlm_service_class_state                          : 0.01,0.01 : 0.01 / 0.01 / 0.01 / 0.01 / 0.00
base_241129.fixed_svl_compile                                          : 6.06,6.17 : 6.06 / 6.17 / 6.11 / 6.11 / 0.06
base_241129.generate_days                                              : 0.00,0.00 : 0.00 / 0.00 / 0.00 / 0.00 / 0.00
base_241129.generate_hours                                             : 0.00,0.00 : 0.00 / 0.00 / 0.00 / 0.00 / 0.00
base_241129.generate_minutes                                           : 0.00,0.00 : 0.00 / 0.00 / 0.00 / 0.00 / 0.00
base_241129.generate_seconds                                           : 0.00,0.00 : 0.00 / 0.00 / 0.00 / 0.00 / 0.00
base_241129.nodes                                                      : 0.03,0.04 : 0.03 / 0.04 / 0.04 / 0.04 / 0.00
base_241129.numbers                                                    : 0.00,0.00 : 0.00 / 0.00 / 0.00 / 0.00 / 0.00
base_241129.privileges_all                                             : 0.08,0.04 : 0.04 / 0.08 / 0.06 / 0.06 / 0.02
base_241129.privileges_groups                                          : 0.05,0.03 : 0.03 / 0.05 / 0.04 / 0.04 / 0.01
base_241129.privileges_public                                          : 0.05,0.03 : 0.03 / 0.05 / 0.04 / 0.04 / 0.01
base_241129.privileges_users                                           : 0.05,0.03 : 0.03 / 0.05 / 0.04 / 0.04 / 0.01
base_241129.queries_blocks                                             : 0.46,0.44 : 0.44 / 0.46 / 0.45 / 0.45 / 0.01
base_241129.queries_compilation                                        : 4.44,4.90 : 4.44 / 4.90 / 4.67 / 4.67 / 0.23
base_241129.queries_for_all                                            : 10.92,7.83 : 7.83 / 10.92 / 9.37 / 9.37 / 1.54
base_241129.queries_for_leader                                         : 3.08,3.96 : 3.08 / 3.96 / 3.52 / 3.52 / 0.44
base_241129.queries_for_worker                                         : 4.61,4.84 : 4.61 / 4.84 / 4.72 / 4.72 / 0.11
base_241129.queries_on_leader_as_for_worker                            : 2.77,3.06 : 2.77 / 3.06 / 2.91 / 2.91 / 0.14
base_241129.queries_transactions                                       : 14.66,15.04 : 14.66 / 15.04 / 14.85 / 14.85 / 0.19
base_241129.strings                                                    : 0.00,0.00 : 0.00 / 0.00 / 0.00 / 0.00 / 0.00
base_241129.transactions                                               : 9.30,9.08 : 9.08 / 9.30 / 9.19 / 9.19 / 0.11
base_241129.transactions_blocks                                        : 1.36,1.47 : 1.36 / 1.47 / 1.42 / 1.42 / 0.06
base_241129.transactions_compilation                                   : 5.39,4.67 : 4.67 / 5.39 / 5.03 / 5.03 / 0.36
base_241129.transactions_in_batches                                    : 0.52,0.58 : 0.52 / 0.58 / 0.55 / 0.55 / 0.03
base_241129.ttables_activity_fast                                      : 1.09,1.70 : 1.09 / 1.70 / 1.39 / 1.39 / 0.30
base_241129.ttables_activity_full                                      : 10.90,11.23 : 10.90 / 11.23 / 11.06 / 11.06 / 0.17
base_241129.ttables_basic_info_fast                                    : 0.25,0.22 : 0.22 / 0.25 / 0.24 / 0.24 / 0.02
base_241129.ttables_basic_info_full                                    : 1.37,1.46 : 1.37 / 1.46 / 1.41 / 1.41 / 0.05
base_241129.ttables_blocks_rows                                        : 1.81,1.43 : 1.43 / 1.81 / 1.62 / 1.62 / 0.19
base_241129.ttables_columns_basic_info                                 : 0.21,0.21 : 0.21 / 0.21 / 0.21 / 0.21 / 0.00
base_241129.views_tables                                               : 2.38,1.66 : 1.66 / 2.38 / 2.02 / 2.02 / 0.36
sf_241129.analyze_totals_for_all_by_all                                : 0.18,0.39 : 0.18 / 0.39 / 0.29 / 0.29 / 0.10
sf_241129.analyze_totals_for_all_by_day                                : 0.31,0.24 : 0.24 / 0.31 / 0.27 / 0.27 / 0.04
sf_241129.analyze_totals_for_all_by_hour                               : 0.23,0.24 : 0.23 / 0.24 / 0.24 / 0.24 / 0.01
sf_241129.analyze_totals_for_all_by_minute                             : 0.25,0.32 : 0.25 / 0.32 / 0.28 / 0.28 / 0.03
sf_241129.analyze_totals_for_all_by_second                             : 0.28,0.33 : 0.28 / 0.33 / 0.31 / 0.31 / 0.03
sf_241129.analyze_totals_for_database_by_all                           : 0.16,0.23 : 0.16 / 0.23 / 0.20 / 0.20 / 0.03
sf_241129.analyze_totals_for_database_by_day                           : 0.24,0.22 : 0.22 / 0.24 / 0.23 / 0.23 / 0.01
sf_241129.analyze_totals_for_database_by_hour                          : 0.18,0.23 : 0.18 / 0.23 / 0.20 / 0.20 / 0.02
sf_241129.analyze_totals_for_database_by_minute                        : 0.32,0.16 : 0.16 / 0.32 / 0.24 / 0.24 / 0.08
sf_241129.analyze_totals_for_database_by_second                        : 0.20,0.16 : 0.16 / 0.20 / 0.18 / 0.18 / 0.02
sf_241129.analyze_totals_for_tables_by_all                             : 0.35,0.36 : 0.35 / 0.36 / 0.35 / 0.35 / 0.01
sf_241129.analyze_totals_for_tables_by_day                             : 0.36,0.40 : 0.36 / 0.40 / 0.38 / 0.38 / 0.02
sf_241129.analyze_totals_for_tables_by_hour                            : 0.31,0.43 : 0.31 / 0.43 / 0.37 / 0.37 / 0.06
sf_241129.analyze_totals_for_tables_by_minute                          : 0.27,0.34 : 0.27 / 0.34 / 0.30 / 0.30 / 0.04
sf_241129.analyze_totals_for_tables_by_second                          : 0.31,0.32 : 0.31 / 0.32 / 0.31 / 0.31 / 0.01
sf_241129.analyze_totals_for_users_by_all                              : 0.19,0.17 : 0.17 / 0.19 / 0.18 / 0.18 / 0.01
sf_241129.analyze_totals_for_users_by_day                              : 0.16,0.19 : 0.16 / 0.19 / 0.18 / 0.18 / 0.02
sf_241129.analyze_totals_for_users_by_hour                             : 0.16,0.21 : 0.16 / 0.21 / 0.18 / 0.18 / 0.03
sf_241129.analyze_totals_for_users_by_minute                           : 0.19,0.19 : 0.19 / 0.19 / 0.19 / 0.19 / 0.00
sf_241129.analyze_totals_for_users_by_second                           : 0.33,0.37 : 0.33 / 0.37 / 0.35 / 0.35 / 0.02
sf_241129.analyze_totals_status_for_all                                : 0.06,0.06 : 0.06 / 0.06 / 0.06 / 0.06 / 0.00
sf_241129.analyze_totals_status_for_schema                             : 0.13,0.12 : 0.12 / 0.13 / 0.12 / 0.12 / 0.00
sf_241129.batches                                                      : 0.50,0.66 : 0.50 / 0.66 / 0.58 / 0.58 / 0.08
sf_241129.blocks_rows_totals_for_cluster                               : 0.63,0.66 : 0.63 / 0.66 / 0.64 / 0.64 / 0.02
sf_241129.blocks_rows_totals_for_node                                  : 0.66,0.70 : 0.66 / 0.70 / 0.68 / 0.68 / 0.02
sf_241129.blocks_rows_totals_for_schema                                : 1.45,1.17 : 1.17 / 1.45 / 1.31 / 1.31 / 0.14
sf_241129.blocks_rows_totals_for_slice                                 : 0.61,0.77 : 0.61 / 0.77 / 0.69 / 0.69 / 0.08
sf_241129.blocks_rows_totals_for_table                                 : 1.12,1.11 : 1.11 / 1.12 / 1.11 / 1.11 / 0.00
sf_241129.blocks_rows_totals_for_tables_by_node                        : 0.94,1.06 : 0.94 / 1.06 / 1.00 / 1.00 / 0.06
sf_241129.blocks_rows_totals_for_tables_by_slice                       : 0.86,0.68 : 0.68 / 0.86 / 0.77 / 0.77 / 0.09
sf_241129.blocks_rows_totals_for_user                                  : 1.16,1.22 : 1.16 / 1.22 / 1.19 / 1.19 / 0.03
sf_241129.blocks_totals_for_tables_by_column                           : 1.22,1.18 : 1.18 / 1.22 / 1.20 / 1.20 / 0.02
sf_241129.ddatabases                                                   : 0.13,0.15 : 0.13 / 0.15 / 0.14 / 0.14 / 0.01
sf_241129.docs                                                         : 0.01,0.01 : 0.01 / 0.01 / 0.01 / 0.01 / 0.00
sf_241129.ffunctions                                                   : 0.85,0.99 : 0.85 / 0.99 / 0.92 / 0.92 / 0.07
sf_241129.ffunctions_text                                              : 0.02,0.01 : 0.01 / 0.02 / 0.02 / 0.02 / 0.00
sf_241129.groups                                                       : 0.01,0.01 : 0.01 / 0.01 / 0.01 / 0.01 / 0.00
sf_241129.groups_privileges                                            : 1.40,1.37 : 1.37 / 1.40 / 1.39 / 1.39 / 0.01
sf_241129.groups_users                                                 : 0.01,0.00 : 0.00 / 0.01 / 0.00 / 0.00 / 0.00
sf_241129.locks_by_table                                               : 0.15,0.15 : 0.15 / 0.15 / 0.15 / 0.15 / 0.00
sf_241129.locks_by_transaction                                         : 0.13,0.13 : 0.13 / 0.13 / 0.13 / 0.13 / 0.00
sf_241129.nodes                                                        : 0.11,0.13 : 0.11 / 0.13 / 0.12 / 0.12 / 0.01
sf_241129.objects                                                      : 0.35,0.46 : 0.35 / 0.46 / 0.40 / 0.40 / 0.06
sf_241129.objects_dependencies                                         : 2.86,2.82 : 2.82 / 2.86 / 2.84 / 2.84 / 0.02
sf_241129.objects_totals_for_all                                       : 0.30,0.32 : 0.30 / 0.32 / 0.31 / 0.31 / 0.01
sf_241129.objects_totals_for_schema                                    : 0.40,0.43 : 0.40 / 0.43 / 0.42 / 0.42 / 0.02
sf_241129.objects_totals_for_user                                      : 0.44,0.45 : 0.44 / 0.45 / 0.44 / 0.44 / 0.01
sf_241129.pprocedures                                                  : 0.91,0.81 : 0.81 / 0.91 / 0.86 / 0.86 / 0.05
sf_241129.pprocedures_text                                             : 0.01,0.01 : 0.01 / 0.01 / 0.01 / 0.01 / 0.00
sf_241129.privileges_granted_to_groups                                 : 1.68,1.53 : 1.53 / 1.68 / 1.60 / 1.60 / 0.07
sf_241129.privileges_granted_to_public                                 : 1.48,1.49 : 1.48 / 1.49 / 1.48 / 1.48 / 0.00
sf_241129.privileges_granted_to_users                                  : 2.47,3.52 : 2.47 / 3.52 / 3.00 / 3.00 / 0.53
sf_241129.queries_compilation                                          : 8.09,7.80 : 7.80 / 8.09 / 7.94 / 7.94 / 0.14
sf_241129.queries_compilation_stream                                   : 7.41,6.62 : 6.62 / 7.41 / 7.02 / 7.02 / 0.39
sf_241129.queries_compilation_stream_segment                           : 7.81,6.80 : 6.80 / 7.81 / 7.30 / 7.30 / 0.51
sf_241129.queries_for_all                                              : 13.03,13.54 : 13.03 / 13.54 / 13.29 / 13.29 / 0.25
sf_241129.queries_for_leader                                           : 4.02,3.59 : 3.59 / 4.02 / 3.80 / 3.80 / 0.22
sf_241129.queries_for_worker                                           : 6.25,6.18 : 6.18 / 6.25 / 6.22 / 6.22 / 0.03
sf_241129.queries_queued                                               : 0.04,0.04 : 0.04 / 0.04 / 0.04 / 0.04 / 0.00
sf_241129.queries_running                                              : 0.27,0.26 : 0.26 / 0.27 / 0.27 / 0.27 / 0.00
sf_241129.queries_stats_durations_on_both_by_transaction               : 10.15,10.93 : 10.15 / 10.93 / 10.54 / 10.54 / 0.39
sf_241129.queries_stats_durations_on_leader_for_all_by_all             : 3.43,3.64 : 3.43 / 3.64 / 3.54 / 3.54 / 0.11
sf_241129.queries_stats_durations_on_leader_for_all_by_day             : 3.26,3.31 : 3.26 / 3.31 / 3.28 / 3.28 / 0.02
sf_241129.queries_stats_durations_on_leader_for_all_by_hour            : 3.68,4.38 : 3.68 / 4.38 / 4.03 / 4.03 / 0.35
sf_241129.queries_stats_durations_on_leader_for_all_by_minute          : 3.79,4.07 : 3.79 / 4.07 / 3.93 / 3.93 / 0.14
sf_241129.queries_stats_durations_on_leader_for_all_by_second          : 6.33,6.67 : 6.33 / 6.67 / 6.50 / 6.50 / 0.17
sf_241129.queries_stats_durations_on_leader_for_users_by_all           : 6.13,5.61 : 5.61 / 6.13 / 5.87 / 5.87 / 0.26
sf_241129.queries_stats_durations_on_leader_for_users_by_day           : 4.12,4.81 : 4.12 / 4.81 / 4.47 / 4.47 / 0.34
sf_241129.queries_stats_durations_on_leader_for_users_by_hour          : 5.16,4.47 : 4.47 / 5.16 / 4.81 / 4.81 / 0.35
sf_241129.queries_stats_durations_on_leader_for_users_by_minute        : 4.49,5.09 : 4.49 / 5.09 / 4.79 / 4.79 / 0.30
sf_241129.queries_stats_durations_on_leader_for_users_by_second        : 8.85,4.67 : 4.67 / 8.85 / 6.76 / 6.76 / 2.09
sf_241129.queries_stats_durations_on_workers_for_all_by_all            : 14.38,11.36 : 11.36 / 14.38 / 12.87 / 12.87 / 1.51
sf_241129.queries_stats_durations_on_workers_for_all_by_day            : 21.00,17.18 : 17.18 / 21.00 / 19.09 / 19.09 / 1.91
sf_241129.queries_stats_durations_on_workers_for_all_by_hour           : 14.83,13.54 : 13.54 / 14.83 / 14.19 / 14.19 / 0.64
sf_241129.queries_stats_durations_on_workers_for_all_by_minute         : 17.12,11.08 : 11.08 / 17.12 / 14.10 / 14.10 / 3.02
sf_241129.queries_stats_durations_on_workers_for_all_by_second         : 12.51,12.89 : 12.51 / 12.89 / 12.70 / 12.70 / 0.19
sf_241129.queries_stats_durations_on_workers_for_query                 : 13.96,18.69 : 13.96 / 18.69 / 16.33 / 16.33 / 2.37
sf_241129.queries_stats_durations_on_workers_for_queues_by_all         : 13.95,11.28 : 11.28 / 13.95 / 12.62 / 12.62 / 1.34
sf_241129.queries_stats_durations_on_workers_for_queues_by_day         : 11.32,11.46 : 11.32 / 11.46 / 11.39 / 11.39 / 0.07
sf_241129.queries_stats_durations_on_workers_for_queues_by_hour        : 10.29,9.73 : 9.73 / 10.29 / 10.01 / 10.01 / 0.28
sf_241129.queries_stats_durations_on_workers_for_queues_by_minute      : 10.03,11.32 : 10.03 / 11.32 / 10.67 / 10.67 / 0.64
sf_241129.queries_stats_durations_on_workers_for_queues_by_second      : 11.33,13.29 : 11.33 / 13.29 / 12.31 / 12.31 / 0.98
sf_241129.queries_stats_durations_on_workers_for_statements_by_all     : 12.57,15.07 : 12.57 / 15.07 / 13.82 / 13.82 / 1.25
sf_241129.queries_stats_durations_on_workers_for_statements_by_day     : 10.42,10.35 : 10.35 / 10.42 / 10.38 / 10.38 / 0.04
sf_241129.queries_stats_durations_on_workers_for_statements_by_hour    : 10.85,11.12 : 10.85 / 11.12 / 10.99 / 10.99 / 0.13
sf_241129.queries_stats_durations_on_workers_for_statements_by_minute  : 11.44,11.13 : 11.13 / 11.44 / 11.29 / 11.29 / 0.15
sf_241129.queries_stats_durations_on_workers_for_statements_by_second  : 17.20,16.70 : 16.70 / 17.20 / 16.95 / 16.95 / 0.25
sf_241129.queries_stats_durations_on_workers_for_users_by_all          : 14.21,14.87 : 14.21 / 14.87 / 14.54 / 14.54 / 0.33
sf_241129.queries_stats_durations_on_workers_for_users_by_day          : 13.00,13.44 : 13.00 / 13.44 / 13.22 / 13.22 / 0.22
sf_241129.queries_stats_durations_on_workers_for_users_by_hour         : 15.45,12.65 : 12.65 / 15.45 / 14.05 / 14.05 / 1.40
sf_241129.queries_stats_durations_on_workers_for_users_by_minute       : 13.70,13.06 : 13.06 / 13.70 / 13.38 / 13.38 / 0.32
sf_241129.queries_stats_durations_on_workers_for_users_by_second       : 18.44,19.24 : 18.44 / 19.24 / 18.84 / 18.84 / 0.40
sf_241129.queries_step_plan                                            : 71.02,73.51 : 71.02 / 73.51 / 72.26 / 72.26 / 1.25
sf_241129.queries_text_for_leader                                      : 3.62,4.37 : 3.62 / 4.37 / 3.99 / 3.99 / 0.38
sf_241129.queries_text_on_both_fast                                    : 8.16,7.77 : 7.77 / 8.16 / 7.96 / 7.96 / 0.20
sf_241129.queries_text_on_both_full                                    : 11.66,10.76 : 10.76 / 11.66 / 11.21 / 11.21 / 0.45
sf_241129.queries_text_on_workers_fast                                 : 4.49,4.21 : 4.21 / 4.49 / 4.35 / 4.35 / 0.14
sf_241129.queries_text_on_workers_full                                 : 2.07,2.16 : 2.07 / 2.16 / 2.11 / 2.11 / 0.04
sf_241129.queries_totals_aborts_on_workers_for_all_by_all              : 0.43,0.39 : 0.39 / 0.43 / 0.41 / 0.41 / 0.02
sf_241129.queries_totals_aborts_on_workers_for_all_by_day              : 0.41,0.41 : 0.41 / 0.41 / 0.41 / 0.41 / 0.00
sf_241129.queries_totals_aborts_on_workers_for_all_by_hour             : 0.40,0.47 : 0.40 / 0.47 / 0.44 / 0.44 / 0.03
sf_241129.queries_totals_aborts_on_workers_for_all_by_minute           : 0.73,0.68 : 0.68 / 0.73 / 0.71 / 0.71 / 0.03
sf_241129.queries_totals_aborts_on_workers_for_all_by_second           : 0.69,0.48 : 0.48 / 0.69 / 0.59 / 0.59 / 0.11
sf_241129.queries_totals_aborts_on_workers_for_query                   : 0.44,0.53 : 0.44 / 0.53 / 0.48 / 0.48 / 0.05
sf_241129.queries_totals_aborts_on_workers_for_queues_by_all           : 0.90,0.92 : 0.90 / 0.92 / 0.91 / 0.91 / 0.01
sf_241129.queries_totals_aborts_on_workers_for_queues_by_day           : 1.05,0.92 : 0.92 / 1.05 / 0.98 / 0.98 / 0.07
sf_241129.queries_totals_aborts_on_workers_for_queues_by_hour          : 0.95,0.90 : 0.90 / 0.95 / 0.93 / 0.93 / 0.03
sf_241129.queries_totals_aborts_on_workers_for_queues_by_minute        : 1.05,0.91 : 0.91 / 1.05 / 0.98 / 0.98 / 0.07
sf_241129.queries_totals_aborts_on_workers_for_queues_by_second        : 1.22,0.97 : 0.97 / 1.22 / 1.09 / 1.09 / 0.12
sf_241129.queries_totals_aborts_on_workers_for_users_by_all            : 0.43,0.43 : 0.43 / 0.43 / 0.43 / 0.43 / 0.00
sf_241129.queries_totals_aborts_on_workers_for_users_by_day            : 0.42,0.53 : 0.42 / 0.53 / 0.47 / 0.47 / 0.05
sf_241129.queries_totals_aborts_on_workers_for_users_by_hour           : 0.44,0.46 : 0.44 / 0.46 / 0.45 / 0.45 / 0.01
sf_241129.queries_totals_aborts_on_workers_for_users_by_minute         : 0.56,0.42 : 0.42 / 0.56 / 0.49 / 0.49 / 0.07
sf_241129.queries_totals_aborts_on_workers_for_users_by_second         : 1.07,0.80 : 0.80 / 1.07 / 0.94 / 0.94 / 0.14
sf_241129.queries_totals_blocks_on_workers_for_all_by_all              : 0.75,0.75 : 0.75 / 0.75 / 0.75 / 0.75 / 0.00
sf_241129.queries_totals_blocks_on_workers_for_all_by_day              : 0.63,0.52 : 0.52 / 0.63 / 0.57 / 0.57 / 0.06
sf_241129.queries_totals_blocks_on_workers_for_all_by_hour             : 0.49,0.52 : 0.49 / 0.52 / 0.50 / 0.50 / 0.02
sf_241129.queries_totals_blocks_on_workers_for_all_by_minute           : 0.46,0.60 : 0.46 / 0.60 / 0.53 / 0.53 / 0.07
sf_241129.queries_totals_blocks_on_workers_for_all_by_second           : 0.47,0.51 : 0.47 / 0.51 / 0.49 / 0.49 / 0.02
sf_241129.queries_totals_blocks_on_workers_for_query                   : 0.58,0.91 : 0.58 / 0.91 / 0.74 / 0.74 / 0.17
sf_241129.queries_totals_blocks_on_workers_for_users_by_all            : 0.52,0.47 : 0.47 / 0.52 / 0.50 / 0.50 / 0.02
sf_241129.queries_totals_blocks_on_workers_for_users_by_day            : 0.48,0.57 : 0.48 / 0.57 / 0.52 / 0.52 / 0.04
sf_241129.queries_totals_blocks_on_workers_for_users_by_hour           : 0.49,0.52 : 0.49 / 0.52 / 0.50 / 0.50 / 0.02
sf_241129.queries_totals_blocks_on_workers_for_users_by_minute         : 0.46,0.45 : 0.45 / 0.46 / 0.46 / 0.46 / 0.01
sf_241129.queries_totals_blocks_on_workers_for_users_by_second         : 0.48,0.58 : 0.48 / 0.58 / 0.53 / 0.53 / 0.05
sf_241129.queries_totals_result_cache_for_all_by_all                   : 5.26,5.26 : 5.26 / 5.26 / 5.26 / 5.26 / 0.00
sf_241129.queries_totals_result_cache_for_all_by_day                   : 6.11,5.96 : 5.96 / 6.11 / 6.03 / 6.03 / 0.07
sf_241129.queries_totals_result_cache_for_all_by_hour                  : 1.67,1.63 : 1.63 / 1.67 / 1.65 / 1.65 / 0.02
sf_241129.queries_totals_result_cache_for_all_by_minute                : 0.93,0.89 : 0.89 / 0.93 / 0.91 / 0.91 / 0.02
sf_241129.queries_totals_result_cache_for_all_by_second                : 0.88,0.92 : 0.88 / 0.92 / 0.90 / 0.90 / 0.02
sf_241129.queries_totals_result_cache_for_query                        : 5.51,5.24 : 5.24 / 5.51 / 5.38 / 5.38 / 0.13
sf_241129.queries_totals_result_cache_for_users_by_all                 : 5.14,5.27 : 5.14 / 5.27 / 5.20 / 5.20 / 0.06
sf_241129.queries_totals_result_cache_for_users_by_day                 : 5.88,5.95 : 5.88 / 5.95 / 5.91 / 5.91 / 0.04
sf_241129.queries_totals_result_cache_for_users_by_hour                : 1.77,1.92 : 1.77 / 1.92 / 1.84 / 1.84 / 0.07
sf_241129.queries_totals_result_cache_for_users_by_minute              : 1.00,1.01 : 1.00 / 1.01 / 1.00 / 1.00 / 0.00
sf_241129.queries_totals_result_cache_for_users_by_second              : 1.27,1.06 : 1.06 / 1.27 / 1.16 / 1.16 / 0.10
sf_241129.queries_transactions_batches                                 : 18.93,18.98 : 18.93 / 18.98 / 18.96 / 18.96 / 0.03
sf_241129.sessions_fast                                                : 2.62,1.07 : 1.07 / 2.62 / 1.85 / 1.85 / 0.78
sf_241129.sessions_full                                                : 1.21,1.28 : 1.21 / 1.28 / 1.25 / 1.25 / 0.03
sf_241129.sschemas                                                     : 0.28,0.27 : 0.27 / 0.28 / 0.28 / 0.28 / 0.01
sf_241129.sschemas_blocks_rows                                         : 0.92,0.96 : 0.92 / 0.96 / 0.94 / 0.94 / 0.02
sf_241129.sschemas_blocks_rows_activity                                : 1.91,1.57 : 1.57 / 1.91 / 1.74 / 1.74 / 0.17
sf_241129.steps_stats_durations_on_both_for_all_by_all_complete        : 10.02,9.70 : 9.70 / 10.02 / 9.86 / 9.86 / 0.16
sf_241129.steps_stats_durations_on_both_for_all_by_all_concise         : 7.73,7.58 : 7.58 / 7.73 / 7.65 / 7.65 / 0.08
sf_241129.steps_stats_durations_on_both_for_all_by_day_complete        : 9.16,9.42 : 9.16 / 9.42 / 9.29 / 9.29 / 0.13
sf_241129.steps_stats_durations_on_both_for_all_by_day_concise         : 7.92,7.99 : 7.92 / 7.99 / 7.95 / 7.95 / 0.03
sf_241129.steps_stats_durations_on_both_for_all_by_hour_complete       : 7.18,6.70 : 6.70 / 7.18 / 6.94 / 6.94 / 0.24
sf_241129.steps_stats_durations_on_both_for_all_by_hour_concise        : 6.71,6.55 : 6.55 / 6.71 / 6.63 / 6.63 / 0.08
sf_241129.steps_stats_durations_on_both_for_all_by_minute_complete     : 6.73,6.68 : 6.68 / 6.73 / 6.70 / 6.70 / 0.02
sf_241129.steps_stats_durations_on_both_for_all_by_minute_concise      : 6.41,6.65 : 6.41 / 6.65 / 6.53 / 6.53 / 0.12
sf_241129.steps_stats_durations_on_both_for_all_by_second_complete     : 6.50,6.84 : 6.50 / 6.84 / 6.67 / 6.67 / 0.17
sf_241129.steps_stats_durations_on_both_for_all_by_second_concise      : 7.00,6.58 : 6.58 / 7.00 / 6.79 / 6.79 / 0.21
sf_241129.steps_stats_durations_on_both_for_node_by_all_complete       : 13.72,13.40 : 13.40 / 13.72 / 13.56 / 13.56 / 0.16
sf_241129.steps_stats_durations_on_both_for_node_by_all_concise        : 9.77,9.75 : 9.75 / 9.77 / 9.76 / 9.76 / 0.01
sf_241129.steps_stats_durations_on_both_for_node_by_day_complete       : 13.65,13.80 : 13.65 / 13.80 / 13.73 / 13.73 / 0.07
sf_241129.steps_stats_durations_on_both_for_node_by_day_concise        : 10.51,10.66 : 10.51 / 10.66 / 10.58 / 10.58 / 0.07
sf_241129.steps_stats_durations_on_both_for_node_by_hour_complete      : 10.77,15.38 : 10.77 / 15.38 / 13.07 / 13.07 / 2.31
sf_241129.steps_stats_durations_on_both_for_node_by_hour_concise       : 9.91,9.71 : 9.71 / 9.91 / 9.81 / 9.81 / 0.10
sf_241129.steps_stats_durations_on_both_for_node_by_minute_complete    : 9.95,10.01 : 9.95 / 10.01 / 9.98 / 9.98 / 0.03
sf_241129.steps_stats_durations_on_both_for_node_by_minute_concise     : 9.48,9.49 : 9.48 / 9.49 / 9.49 / 9.49 / 0.01
sf_241129.steps_stats_durations_on_both_for_node_by_second_complete    : 9.75,10.18 : 9.75 / 10.18 / 9.97 / 9.97 / 0.22
sf_241129.steps_stats_durations_on_both_for_node_by_second_concise     : 10.16,9.82 : 9.82 / 10.16 / 9.99 / 9.99 / 0.17
sf_241129.steps_stats_durations_on_both_for_slices_by_all_complete     : 12.21,11.89 : 11.89 / 12.21 / 12.05 / 12.05 / 0.16
sf_241129.steps_stats_durations_on_both_for_slices_by_all_concise      : 11.82,11.82 : 11.82 / 11.82 / 11.82 / 11.82 / 0.00
sf_241129.steps_stats_durations_on_both_for_slices_by_day_complete     : 11.23,11.00 : 11.00 / 11.23 / 11.11 / 11.11 / 0.11
sf_241129.steps_stats_durations_on_both_for_slices_by_day_concise      : 11.49,11.19 : 11.19 / 11.49 / 11.34 / 11.34 / 0.15
sf_241129.steps_stats_durations_on_both_for_slices_by_hour_complete    : 10.67,12.81 : 10.67 / 12.81 / 11.74 / 11.74 / 1.07
sf_241129.steps_stats_durations_on_both_for_slices_by_hour_concise     : 12.56,13.28 : 12.56 / 13.28 / 12.92 / 12.92 / 0.36
sf_241129.steps_stats_durations_on_both_for_slices_by_minute_complete  : 10.80,10.74 : 10.74 / 10.80 / 10.77 / 10.77 / 0.03
sf_241129.steps_stats_durations_on_both_for_slices_by_minute_concise   : 10.65,10.62 : 10.62 / 10.65 / 10.63 / 10.63 / 0.02
sf_241129.steps_stats_durations_on_both_for_slices_by_second_complete  : 11.58,11.61 : 11.58 / 11.61 / 11.60 / 11.60 / 0.02
sf_241129.steps_stats_durations_on_both_for_slices_by_second_concise   : 11.35,11.36 : 11.35 / 11.36 / 11.36 / 11.36 / 0.00
sf_241129.steps_stats_durations_on_both_for_statements_by_all          : 9.95,9.59 : 9.59 / 9.95 / 9.77 / 9.77 / 0.18
sf_241129.steps_stats_durations_on_both_for_statements_by_day          : 9.74,9.78 : 9.74 / 9.78 / 9.76 / 9.76 / 0.02
sf_241129.steps_stats_durations_on_both_for_statements_by_hour         : 7.62,7.46 : 7.46 / 7.62 / 7.54 / 7.54 / 0.08
sf_241129.steps_stats_durations_on_both_for_statements_by_minute       : 7.07,7.29 : 7.07 / 7.29 / 7.18 / 7.18 / 0.11
sf_241129.steps_stats_durations_on_both_for_statements_by_second       : 6.83,7.15 : 6.83 / 7.15 / 6.99 / 6.99 / 0.16
sf_241129.steps_stats_durations_on_both_for_tables_by_all_complete     : 3.97,3.95 : 3.95 / 3.97 / 3.96 / 3.96 / 0.01
sf_241129.steps_stats_durations_on_both_for_tables_by_all_concise      : 4.09,3.92 : 3.92 / 4.09 / 4.01 / 4.01 / 0.09
sf_241129.steps_stats_durations_on_both_for_tables_by_day_complete     : 4.26,4.11 : 4.11 / 4.26 / 4.18 / 4.18 / 0.08
sf_241129.steps_stats_durations_on_both_for_tables_by_day_concise      : 4.13,4.08 : 4.08 / 4.13 / 4.11 / 4.11 / 0.03
sf_241129.steps_stats_durations_on_both_for_tables_by_hour_complete    : 3.58,3.59 : 3.58 / 3.59 / 3.58 / 3.58 / 0.01
sf_241129.steps_stats_durations_on_both_for_tables_by_hour_concise     : 3.57,4.16 : 3.57 / 4.16 / 3.87 / 3.87 / 0.30
sf_241129.steps_stats_durations_on_both_for_tables_by_minute_complete  : 5.05,4.42 : 4.42 / 5.05 / 4.73 / 4.73 / 0.32
sf_241129.steps_stats_durations_on_both_for_tables_by_minute_concise   : 4.77,4.43 : 4.43 / 4.77 / 4.60 / 4.60 / 0.17
sf_241129.steps_stats_durations_on_both_for_tables_by_second_complete  : 6.74,6.71 : 6.71 / 6.74 / 6.72 / 6.72 / 0.01
sf_241129.steps_stats_durations_on_both_for_tables_by_second_concise   : 4.85,6.63 : 4.85 / 6.63 / 5.74 / 5.74 / 0.89
sf_241129.steps_stats_durations_on_both_for_users_by_all_complete      : 9.68,9.83 : 9.68 / 9.83 / 9.76 / 9.76 / 0.08
sf_241129.steps_stats_durations_on_both_for_users_by_all_concise       : 9.45,9.81 : 9.45 / 9.81 / 9.63 / 9.63 / 0.18
sf_241129.steps_stats_durations_on_both_for_users_by_day_complete      : 9.35,9.49 : 9.35 / 9.49 / 9.42 / 9.42 / 0.07
sf_241129.steps_stats_durations_on_both_for_users_by_day_concise       : 9.21,9.12 : 9.12 / 9.21 / 9.16 / 9.16 / 0.05
sf_241129.steps_stats_durations_on_both_for_users_by_hour_complete     : 7.02,7.31 : 7.02 / 7.31 / 7.17 / 7.17 / 0.14
sf_241129.steps_stats_durations_on_both_for_users_by_hour_concise      : 8.75,6.95 : 6.95 / 8.75 / 7.85 / 7.85 / 0.90
sf_241129.steps_stats_durations_on_both_for_users_by_minute_complete   : 6.69,6.67 : 6.67 / 6.69 / 6.68 / 6.68 / 0.01
sf_241129.steps_stats_durations_on_both_for_users_by_minute_concise    : 6.50,6.52 : 6.50 / 6.52 / 6.51 / 6.51 / 0.01
sf_241129.steps_stats_durations_on_both_for_users_by_second_complete   : 6.53,6.51 : 6.51 / 6.53 / 6.52 / 6.52 / 0.01
sf_241129.steps_stats_durations_on_both_for_users_by_second_concise    : 6.88,6.60 : 6.60 / 6.88 / 6.74 / 6.74 / 0.14
sf_241129.steps_totals_data_on_both_for_all_by_all                     : 6.79,6.61 : 6.61 / 6.79 / 6.70 / 6.70 / 0.09
sf_241129.steps_totals_data_on_both_for_all_by_day                     : 6.82,6.86 : 6.82 / 6.86 / 6.84 / 6.84 / 0.02
sf_241129.steps_totals_data_on_both_for_all_by_hour                    : 6.38,6.74 : 6.38 / 6.74 / 6.56 / 6.56 / 0.18
sf_241129.steps_totals_data_on_both_for_all_by_minute                  : 6.50,6.57 : 6.50 / 6.57 / 6.53 / 6.53 / 0.04
sf_241129.steps_totals_data_on_both_for_all_by_second                  : 6.58,6.66 : 6.58 / 6.66 / 6.62 / 6.62 / 0.04
sf_241129.steps_totals_data_on_both_for_node_by_all                    : 7.18,6.93 : 6.93 / 7.18 / 7.06 / 7.06 / 0.12
sf_241129.steps_totals_data_on_both_for_node_by_day                    : 7.08,6.91 : 6.91 / 7.08 / 6.99 / 6.99 / 0.09
sf_241129.steps_totals_data_on_both_for_node_by_hour                   : 6.59,6.51 : 6.51 / 6.59 / 6.55 / 6.55 / 0.04
sf_241129.steps_totals_data_on_both_for_node_by_minute                 : 6.46,7.35 : 6.46 / 7.35 / 6.90 / 6.90 / 0.44
sf_241129.steps_totals_data_on_both_for_node_by_second                 : 6.67,6.45 : 6.45 / 6.67 / 6.56 / 6.56 / 0.11
sf_241129.steps_totals_data_on_both_for_query                          : 8.97,9.11 : 8.97 / 9.11 / 9.04 / 9.04 / 0.07
sf_241129.steps_totals_data_on_both_for_slices_by_all                  : 6.79,6.66 : 6.66 / 6.79 / 6.73 / 6.73 / 0.06
sf_241129.steps_totals_data_on_both_for_slices_by_day                  : 6.83,7.87 : 6.83 / 7.87 / 7.35 / 7.35 / 0.52
sf_241129.steps_totals_data_on_both_for_slices_by_hour                 : 8.22,7.14 : 7.14 / 8.22 / 7.68 / 7.68 / 0.54
sf_241129.steps_totals_data_on_both_for_slices_by_minute               : 7.08,8.12 : 7.08 / 8.12 / 7.60 / 7.60 / 0.52
sf_241129.steps_totals_data_on_both_for_slices_by_second               : 7.22,6.64 : 6.64 / 7.22 / 6.93 / 6.93 / 0.29
sf_241129.steps_totals_data_on_both_for_statements_by_all              : 9.24,8.49 : 8.49 / 9.24 / 8.87 / 8.87 / 0.37
sf_241129.steps_totals_data_on_both_for_statements_by_day              : 13.67,10.71 : 10.71 / 13.67 / 12.19 / 12.19 / 1.48
sf_241129.steps_totals_data_on_both_for_statements_by_hour             : 16.43,16.03 : 16.03 / 16.43 / 16.23 / 16.23 / 0.20
sf_241129.steps_totals_data_on_both_for_statements_by_minute           : 19.79,20.09 : 19.79 / 20.09 / 19.94 / 19.94 / 0.15
sf_241129.steps_totals_data_on_both_for_statements_by_second           : 83.80,54.21 : 54.21 / 83.80 / 69.00 / 69.00 / 14.79
sf_241129.steps_totals_data_on_both_for_users_by_all                   : 6.98,6.80 : 6.80 / 6.98 / 6.89 / 6.89 / 0.09
sf_241129.steps_totals_data_on_both_for_users_by_day                   : 6.91,6.82 : 6.82 / 6.91 / 6.86 / 6.86 / 0.04
sf_241129.steps_totals_data_on_both_for_users_by_hour                  : 6.82,6.58 : 6.58 / 6.82 / 6.70 / 6.70 / 0.12
sf_241129.steps_totals_data_on_both_for_users_by_minute                : 6.61,6.53 : 6.53 / 6.61 / 6.57 / 6.57 / 0.04
sf_241129.steps_totals_data_on_both_for_users_by_second                : 6.96,6.61 : 6.61 / 6.96 / 6.78 / 6.78 / 0.17
sf_241129.steps_totals_rows_on_workers_for_all_by_all                  : 4.72,5.52 : 4.72 / 5.52 / 5.12 / 5.12 / 0.40
sf_241129.steps_totals_rows_on_workers_for_all_by_day                  : 4.63,5.03 : 4.63 / 5.03 / 4.83 / 4.83 / 0.20
sf_241129.steps_totals_rows_on_workers_for_all_by_hour                 : 4.75,4.78 : 4.75 / 4.78 / 4.76 / 4.76 / 0.02
sf_241129.steps_totals_rows_on_workers_for_all_by_minute               : 4.65,4.86 : 4.65 / 4.86 / 4.76 / 4.76 / 0.11
sf_241129.steps_totals_rows_on_workers_for_all_by_second               : 5.11,4.77 : 4.77 / 5.11 / 4.94 / 4.94 / 0.17
sf_241129.steps_totals_rows_on_workers_for_query                       : 5.13,5.30 : 5.13 / 5.30 / 5.22 / 5.22 / 0.08
sf_241129.steps_totals_rows_on_workers_for_schemas_by_all              : 4.75,4.86 : 4.75 / 4.86 / 4.80 / 4.80 / 0.06
sf_241129.steps_totals_rows_on_workers_for_schemas_by_day              : 4.92,5.23 : 4.92 / 5.23 / 5.07 / 5.07 / 0.16
sf_241129.steps_totals_rows_on_workers_for_schemas_by_hour             : 4.93,4.86 : 4.86 / 4.93 / 4.89 / 4.89 / 0.03
sf_241129.steps_totals_rows_on_workers_for_schemas_by_minute           : 5.45,4.96 : 4.96 / 5.45 / 5.21 / 5.21 / 0.25
sf_241129.steps_totals_rows_on_workers_for_schemas_by_second           : 5.01,5.64 : 5.01 / 5.64 / 5.33 / 5.33 / 0.31
sf_241129.steps_totals_rows_on_workers_for_tables_by_all               : 4.95,4.81 : 4.81 / 4.95 / 4.88 / 4.88 / 0.07
sf_241129.steps_totals_rows_on_workers_for_tables_by_day               : 4.93,5.26 : 4.93 / 5.26 / 5.10 / 5.10 / 0.17
sf_241129.steps_totals_rows_on_workers_for_tables_by_hour              : 4.82,4.90 : 4.82 / 4.90 / 4.86 / 4.86 / 0.04
sf_241129.steps_totals_rows_on_workers_for_tables_by_minute            : 5.19,4.93 : 4.93 / 5.19 / 5.06 / 5.06 / 0.13
sf_241129.steps_totals_rows_on_workers_for_tables_by_second            : 5.05,5.25 : 5.05 / 5.25 / 5.15 / 5.15 / 0.10
sf_241129.steps_totals_rows_on_workers_for_users_by_all                : 4.91,4.64 : 4.64 / 4.91 / 4.78 / 4.78 / 0.13
sf_241129.steps_totals_rows_on_workers_for_users_by_day                : 4.63,4.79 : 4.63 / 4.79 / 4.71 / 4.71 / 0.08
sf_241129.steps_totals_rows_on_workers_for_users_by_hour               : 4.85,5.12 : 4.85 / 5.12 / 4.99 / 4.99 / 0.14
sf_241129.steps_totals_rows_on_workers_for_users_by_minute             : 5.03,4.80 : 4.80 / 5.03 / 4.91 / 4.91 / 0.11
sf_241129.steps_totals_rows_on_workers_for_users_by_second             : 5.06,4.80 : 4.80 / 5.06 / 4.93 / 4.93 / 0.13
sf_241129.steps_totals_scan_data_on_both_for_all_by_all                : 5.11,5.40 : 5.11 / 5.40 / 5.25 / 5.25 / 0.14
sf_241129.steps_totals_scan_data_on_both_for_all_by_day                : 5.88,5.64 : 5.64 / 5.88 / 5.76 / 5.76 / 0.12
sf_241129.steps_totals_scan_data_on_both_for_all_by_hour               : 5.55,7.08 : 5.55 / 7.08 / 6.31 / 6.31 / 0.77
sf_241129.steps_totals_scan_data_on_both_for_all_by_minute             : 5.46,5.27 : 5.27 / 5.46 / 5.36 / 5.36 / 0.09
sf_241129.steps_totals_scan_data_on_both_for_all_by_second             : 7.13,7.04 : 7.04 / 7.13 / 7.09 / 7.09 / 0.05
sf_241129.steps_totals_scan_data_on_both_for_node_by_all               : 5.20,5.10 : 5.10 / 5.20 / 5.15 / 5.15 / 0.05
sf_241129.steps_totals_scan_data_on_both_for_node_by_day               : 5.13,5.15 : 5.13 / 5.15 / 5.14 / 5.14 / 0.01
sf_241129.steps_totals_scan_data_on_both_for_node_by_hour              : 5.33,5.58 : 5.33 / 5.58 / 5.45 / 5.45 / 0.13
sf_241129.steps_totals_scan_data_on_both_for_node_by_minute            : 5.52,6.30 : 5.52 / 6.30 / 5.91 / 5.91 / 0.39
sf_241129.steps_totals_scan_data_on_both_for_node_by_second            : 11.19,11.01 : 11.01 / 11.19 / 11.10 / 11.10 / 0.09
sf_241129.steps_totals_scan_data_on_both_for_query                     : 8.47,8.66 : 8.47 / 8.66 / 8.57 / 8.57 / 0.09
sf_241129.steps_totals_scan_data_on_both_for_queues_by_all             : 7.19,7.28 : 7.19 / 7.28 / 7.24 / 7.24 / 0.04
sf_241129.steps_totals_scan_data_on_both_for_queues_by_day             : 8.64,7.51 : 7.51 / 8.64 / 8.07 / 8.07 / 0.56
sf_241129.steps_totals_scan_data_on_both_for_queues_by_hour            : 6.42,6.52 : 6.42 / 6.52 / 6.47 / 6.47 / 0.05
sf_241129.steps_totals_scan_data_on_both_for_queues_by_minute          : 7.32,7.09 : 7.09 / 7.32 / 7.21 / 7.21 / 0.12
sf_241129.steps_totals_scan_data_on_both_for_queues_by_second          : 8.89,8.39 : 8.39 / 8.89 / 8.64 / 8.64 / 0.25
sf_241129.steps_totals_scan_data_on_both_for_schemas_by_all            : 8.64,9.26 : 8.64 / 9.26 / 8.95 / 8.95 / 0.31
sf_241129.steps_totals_scan_data_on_both_for_schemas_by_day            : 9.24,8.80 : 8.80 / 9.24 / 9.02 / 9.02 / 0.22
sf_241129.steps_totals_scan_data_on_both_for_schemas_by_hour           : 8.84,8.90 : 8.84 / 8.90 / 8.87 / 8.87 / 0.03
sf_241129.steps_totals_scan_data_on_both_for_schemas_by_minute         : 9.79,9.89 : 9.79 / 9.89 / 9.84 / 9.84 / 0.05
sf_241129.steps_totals_scan_data_on_both_for_schemas_by_second         : 11.16,11.50 : 11.16 / 11.50 / 11.33 / 11.33 / 0.17
sf_241129.steps_totals_scan_data_on_both_for_slices_by_all             : 5.03,5.37 : 5.03 / 5.37 / 5.20 / 5.20 / 0.17
sf_241129.steps_totals_scan_data_on_both_for_slices_by_day             : 5.20,5.06 : 5.06 / 5.20 / 5.13 / 5.13 / 0.07
sf_241129.steps_totals_scan_data_on_both_for_slices_by_hour            : 5.16,5.05 : 5.05 / 5.16 / 5.11 / 5.11 / 0.06
sf_241129.steps_totals_scan_data_on_both_for_slices_by_minute          : 6.48,5.99 : 5.99 / 6.48 / 6.23 / 6.23 / 0.25
sf_241129.steps_totals_scan_data_on_both_for_slices_by_second          : 27.15,24.97 : 24.97 / 27.15 / 26.06 / 26.06 / 1.09
sf_241129.steps_totals_scan_data_on_both_for_tables_by_all             : 8.79,8.55 : 8.55 / 8.79 / 8.67 / 8.67 / 0.12
sf_241129.steps_totals_scan_data_on_both_for_tables_by_day             : 8.90,8.91 : 8.90 / 8.91 / 8.90 / 8.90 / 0.00
sf_241129.steps_totals_scan_data_on_both_for_tables_by_hour            : 9.11,9.26 : 9.11 / 9.26 / 9.18 / 9.18 / 0.08
sf_241129.steps_totals_scan_data_on_both_for_tables_by_minute          : 13.05,12.09 : 12.09 / 13.05 / 12.57 / 12.57 / 0.48
sf_241129.steps_totals_scan_data_on_both_for_tables_by_second          : 12.93,12.55 : 12.55 / 12.93 / 12.74 / 12.74 / 0.19
sf_241129.steps_totals_scan_data_on_both_for_users_by_all              : 5.31,5.43 : 5.31 / 5.43 / 5.37 / 5.37 / 0.06
sf_241129.steps_totals_scan_data_on_both_for_users_by_day              : 5.29,5.54 : 5.29 / 5.54 / 5.41 / 5.41 / 0.13
sf_241129.steps_totals_scan_data_on_both_for_users_by_hour             : 5.25,5.24 : 5.24 / 5.25 / 5.25 / 5.25 / 0.00
sf_241129.steps_totals_scan_data_on_both_for_users_by_minute           : 5.64,5.78 : 5.64 / 5.78 / 5.71 / 5.71 / 0.07
sf_241129.steps_totals_scan_data_on_both_for_users_by_second           : 10.23,9.67 : 9.67 / 10.23 / 9.95 / 9.95 / 0.28
sf_241129.transactions                                                 : 8.05,8.93 : 8.05 / 8.93 / 8.49 / 8.49 / 0.44
sf_241129.transactions_batches                                         : 8.67,8.55 : 8.55 / 8.67 / 8.61 / 8.61 / 0.06
sf_241129.transactions_stats_commits_by_all                            : 0.66,0.67 : 0.66 / 0.67 / 0.67 / 0.67 / 0.01
sf_241129.transactions_stats_commits_by_day                            : 0.69,0.85 : 0.69 / 0.85 / 0.77 / 0.77 / 0.08
sf_241129.transactions_stats_commits_by_hour                           : 0.73,0.67 : 0.67 / 0.73 / 0.70 / 0.70 / 0.03
sf_241129.transactions_stats_commits_by_minute                         : 0.74,0.78 : 0.74 / 0.78 / 0.76 / 0.76 / 0.02
sf_241129.transactions_stats_commits_by_second                         : 0.79,0.84 : 0.79 / 0.84 / 0.81 / 0.81 / 0.02
sf_241129.transactions_totals_commits_by_all                           : 0.40,0.39 : 0.39 / 0.40 / 0.39 / 0.39 / 0.00
sf_241129.transactions_totals_commits_by_day                           : 0.38,0.36 : 0.36 / 0.38 / 0.37 / 0.37 / 0.01
sf_241129.transactions_totals_commits_by_hour                          : 0.38,0.33 : 0.33 / 0.38 / 0.36 / 0.36 / 0.03
sf_241129.transactions_totals_commits_by_minute                        : 0.37,0.37 : 0.37 / 0.37 / 0.37 / 0.37 / 0.00
sf_241129.transactions_totals_commits_by_second                        : 0.38,0.34 : 0.34 / 0.38 / 0.36 / 0.36 / 0.02
sf_241129.transactions_totals_query_counts_on_both_for_all_by_all      : 7.57,7.34 : 7.34 / 7.57 / 7.46 / 7.46 / 0.12
sf_241129.transactions_totals_query_counts_on_both_for_all_by_day      : 6.48,7.49 : 6.48 / 7.49 / 6.98 / 6.98 / 0.51
sf_241129.transactions_totals_query_counts_on_both_for_all_by_hour     : 8.08,7.15 : 7.15 / 8.08 / 7.62 / 7.62 / 0.47
sf_241129.transactions_totals_query_counts_on_both_for_all_by_minute   : 8.32,7.60 : 7.60 / 8.32 / 7.96 / 7.96 / 0.36
sf_241129.transactions_totals_query_counts_on_both_for_all_by_second   : 7.86,6.72 : 6.72 / 7.86 / 7.29 / 7.29 / 0.57
sf_241129.transactions_totals_query_counts_on_both_for_users_by_all    : 8.34,7.55 : 7.55 / 8.34 / 7.94 / 7.94 / 0.40
sf_241129.transactions_totals_query_counts_on_both_for_users_by_day    : 7.01,7.99 : 7.01 / 7.99 / 7.50 / 7.50 / 0.49
sf_241129.transactions_totals_query_counts_on_both_for_users_by_hour   : 8.15,9.05 : 8.15 / 9.05 / 8.60 / 8.60 / 0.45
sf_241129.transactions_totals_query_counts_on_both_for_users_by_minute : 7.45,7.47 : 7.45 / 7.47 / 7.46 / 7.46 / 0.01
sf_241129.transactions_totals_query_counts_on_both_for_users_by_second : 7.56,6.50 : 6.50 / 7.56 / 7.03 / 7.03 / 0.53
sf_241129.ttables                                                      : 0.51,0.49 : 0.49 / 0.51 / 0.50 / 0.50 / 0.01
sf_241129.ttables_blocks_rows                                          : 1.09,1.18 : 1.09 / 1.18 / 1.14 / 1.14 / 0.05
sf_241129.ttables_blocks_rows_activity                                 : 1.84,1.72 : 1.72 / 1.84 / 1.78 / 1.78 / 0.06
sf_241129.ttables_columns                                              : 2.68,3.07 : 2.68 / 3.07 / 2.88 / 2.88 / 0.20
sf_241129.ttables_columns_blocks                                       : 1.43,0.92 : 0.92 / 1.43 / 1.17 / 1.17 / 0.25
sf_241129.ttables_columns_defaults_references                          : 6.06,6.13 : 6.06 / 6.13 / 6.10 / 6.10 / 0.03
sf_241129.ttables_creation_for_all_by_day                              : 0.12,0.10 : 0.10 / 0.12 / 0.11 / 0.11 / 0.01
sf_241129.ttables_creation_for_all_by_hour                             : 0.12,0.09 : 0.09 / 0.12 / 0.11 / 0.11 / 0.02
sf_241129.ttables_creation_for_all_by_minute                           : 0.04,0.04 : 0.04 / 0.04 / 0.04 / 0.04 / 0.00
sf_241129.ttables_creation_for_all_by_second                           : 0.04,0.04 : 0.04 / 0.04 / 0.04 / 0.04 / 0.00
sf_241129.ttables_creation_for_schemas_by_day                          : 0.11,0.11 : 0.11 / 0.11 / 0.11 / 0.11 / 0.00
sf_241129.ttables_creation_for_schemas_by_hour                         : 0.09,0.09 : 0.09 / 0.09 / 0.09 / 0.09 / 0.00
sf_241129.ttables_creation_for_schemas_by_minute                       : 0.04,0.04 : 0.04 / 0.04 / 0.04 / 0.04 / 0.00
sf_241129.ttables_creation_for_schemas_by_second                       : 0.04,0.04 : 0.04 / 0.04 / 0.04 / 0.04 / 0.00
sf_241129.ttables_stats_datatypes_encodings_by_count_and_blocks        : 1.91,1.83 : 1.83 / 1.91 / 1.87 / 1.87 / 0.04
sf_241129.ttables_stats_dists_sorts_for_all_by_blocks                  : 1.24,1.81 : 1.24 / 1.81 / 1.53 / 1.53 / 0.29
sf_241129.ttables_stats_dists_sorts_for_all_by_count                   : 0.76,0.71 : 0.71 / 0.76 / 0.73 / 0.73 / 0.02
sf_241129.ttables_stats_dists_sorts_for_schemas_by_blocks              : 1.28,0.97 : 0.97 / 1.28 / 1.13 / 1.13 / 0.15
sf_241129.ttables_stats_dists_sorts_for_schemas_by_count               : 0.35,0.35 : 0.35 / 0.35 / 0.35 / 0.35 / 0.00
sf_241129.ttables_zonemap                                              : 19.16,19.78 : 19.16 / 19.78 / 19.47 / 19.47 / 0.31
sf_241129.utils_most_recent_copy_error_for_current_user                : 0.21,0.33 : 0.21 / 0.33 / 0.27 / 0.27 / 0.06
sf_241129.utils_queries_benchmark                                      : 3.68,3.48 : 3.48 / 3.68 / 3.58 / 3.58 / 0.10
sf_241129.uusers                                                       : 0.60,0.49 : 0.49 / 0.60 / 0.54 / 0.54 / 0.05
sf_241129.uusers_default_privileges                                    : 0.02,0.01 : 0.01 / 0.02 / 0.01 / 0.01 / 0.00
sf_241129.uusers_privileges                                            : 8.82,11.20 : 8.82 / 11.20 / 10.01 / 10.01 / 1.19
sf_241129.vacuum_stats_for_all_by_all                                  : 5.77,7.31 : 5.77 / 7.31 / 6.54 / 6.54 / 0.77
sf_241129.vacuum_stats_for_all_by_day                                  : 4.25,5.04 : 4.25 / 5.04 / 4.65 / 4.65 / 0.39
sf_241129.vacuum_stats_for_all_by_hour                                 : 5.65,5.76 : 5.65 / 5.76 / 5.70 / 5.70 / 0.05
sf_241129.vacuum_stats_for_all_by_minute                               : 5.10,6.18 : 5.10 / 6.18 / 5.64 / 5.64 / 0.54
sf_241129.vacuum_stats_for_all_by_second                               : 8.25,8.09 : 8.09 / 8.25 / 8.17 / 8.17 / 0.08
sf_241129.vacuum_totals_for_all_by_all                                 : 0.36,0.35 : 0.35 / 0.36 / 0.36 / 0.36 / 0.00
sf_241129.vacuum_totals_for_all_by_day                                 : 0.33,0.32 : 0.32 / 0.33 / 0.33 / 0.33 / 0.00
sf_241129.vacuum_totals_for_all_by_hour                                : 0.35,0.36 : 0.35 / 0.36 / 0.35 / 0.35 / 0.01
sf_241129.vacuum_totals_for_all_by_minute                              : 0.33,0.35 : 0.33 / 0.35 / 0.34 / 0.34 / 0.01
sf_241129.vacuum_totals_for_all_by_second                              : 0.30,0.35 : 0.30 / 0.35 / 0.33 / 0.33 / 0.02
sf_241129.vacuum_totals_for_tables_by_all                              : 0.38,0.42 : 0.38 / 0.42 / 0.40 / 0.40 / 0.02
sf_241129.vacuum_totals_for_tables_by_day                              : 0.43,0.44 : 0.43 / 0.44 / 0.43 / 0.43 / 0.01
sf_241129.vacuum_totals_for_tables_by_hour                             : 0.48,0.43 : 0.43 / 0.48 / 0.45 / 0.45 / 0.03
sf_241129.vacuum_totals_for_tables_by_minute                           : 0.46,0.41 : 0.41 / 0.46 / 0.43 / 0.43 / 0.02
sf_241129.vacuum_totals_for_tables_by_second                           : 0.44,0.50 : 0.44 / 0.50 / 0.47 / 0.47 / 0.03
sf_241129.vacuum_totals_for_users_by_all                               : 0.34,0.35 : 0.34 / 0.35 / 0.34 / 0.34 / 0.00
sf_241129.vacuum_totals_for_users_by_day                               : 0.34,0.33 : 0.33 / 0.34 / 0.33 / 0.33 / 0.00
sf_241129.vacuum_totals_for_users_by_hour                              : 0.32,0.33 : 0.32 / 0.33 / 0.33 / 0.33 / 0.00
sf_241129.vacuum_totals_for_users_by_minute                            : 0.32,0.31 : 0.31 / 0.32 / 0.32 / 0.32 / 0.00
sf_241129.vacuum_totals_for_users_by_second                            : 0.35,0.32 : 0.32 / 0.35 / 0.33 / 0.33 / 0.01
sf_241129.views_late_binding                                           : 0.27,0.24 : 0.24 / 0.27 / 0.25 / 0.25 / 0.01
sf_241129.views_late_binding_columns                                   : 1.76,1.60 : 1.60 / 1.76 / 1.68 / 1.68 / 0.08
sf_241129.views_materialized                                           : 0.24,0.23 : 0.23 / 0.24 / 0.24 / 0.24 / 0.01
sf_241129.views_materialized_columns                                   : 0.64,0.67 : 0.64 / 0.67 / 0.66 / 0.66 / 0.01
sf_241129.views_materialized_table                                     : 1.31,1.30 : 1.30 / 1.31 / 1.30 / 1.30 / 0.00
sf_241129.views_materialized_table_blocks_rows                         : 1.89,2.23 : 1.89 / 2.23 / 2.06 / 2.06 / 0.17
sf_241129.views_normal                                                 : 0.24,0.41 : 0.24 / 0.41 / 0.32 / 0.32 / 0.08
sf_241129.views_normal_columns                                         : 0.77,0.71 : 0.71 / 0.77 / 0.74 / 0.74 / 0.03
sf_241129.views_text                                                   : 1.61,1.35 : 1.35 / 1.61 / 1.48 / 1.48 / 0.13
sf_241129.wqueues                                                      : 0.09,0.11 : 0.09 / 0.11 / 0.10 / 0.10 / 0.01
sf_241129.wqueues_memory                                               : 0.08,0.08 : 0.08 / 0.08 / 0.08 / 0.08 / 0.00
sf_241129.wqueues_qmr_log                                              : 0.15,0.15 : 0.15 / 0.15 / 0.15 / 0.15 / 0.00
sf_241129.wqueues_qmr_rules                                            : 0.05,0.07 : 0.05 / 0.07 / 0.06 / 0.06 / 0.01
sf_241129.wqueues_routing_rules                                        : 0.05,0.04 : 0.04 / 0.05 / 0.04 / 0.04 / 0.00
sf_241129.wqueues_totals_slot_utilization_by_all                       : 10.52,10.77 : 10.52 / 10.77 / 10.65 / 10.65 / 0.13
sf_241129.wqueues_totals_slot_utilization_by_day                       : 10.72,9.98 : 9.98 / 10.72 / 10.35 / 10.35 / 0.37
sf_241129.wqueues_totals_slot_utilization_by_day_as_table              : 11.57,10.39 : 10.39 / 11.57 / 10.98 / 10.98 / 0.59
sf_241129.wqueues_totals_slot_utilization_by_hour                      : 9.78,10.52 : 9.78 / 10.52 / 10.15 / 10.15 / 0.37
sf_241129.wqueues_totals_slot_utilization_by_minute                    : 9.48,9.85 : 9.48 / 9.85 / 9.67 / 9.67 / 0.19
sf_241129.wqueues_totals_slot_utilization_by_second                    : 8.35,9.76 : 8.35 / 9.76 / 9.05 / 9.05 / 0.71

Schema ro

The ro schema has no version in its name, for it is the master schema, which contains a single view and the minimal set of procedures to control RST installations and privileges.

The version string is a YYMMDD datestamp, which is the release date of the version.

There is one view, to list installed versions;

1. select * from ro.installed_versions;

There is a procedure (everything beginning with sp_ is a stored procedure) to uninstall a version;

1. ro.sp_uninstall_version( 'YYMMDD' );.

There are a set of procedures to grant and revoke privileges to or from a version to a group, to public, role, or a user;

1. ro.sp_grant_version_to_group( 'YYMMDD' );
2. ro.sp_grant_version_to_public( 'YYMMDD' );
3. ro.sp_grant_version_to_role( 'YYMMDD' );
4. ro.sp_grant_version_to_user( 'YYMMDD' );

There are matching procedures, to revoke privileges;

1. ro.sp_revoke_version_from_group( 'YYMMDD' );
2. ro.sp_revoke_version_from_public( 'YYMMDD' );
3. ro.sp_revoke_version_from_role( 'YYMMDD' );
4. ro.sp_revoke_version_from_user( 'YYMMDD' );

Additionally, there is also the concept of the versionless sf schema.

Where the schema names contain their version string, they are long. There has to be a unique identifier in the schema names so multiple versions can be concurrently installed, and so we have to bear this cross when it comes to scripting and use the long name of the lf schema, but the sf schema is intended for direct human use in an SQL client. The long schema name is a fundamental problem.

To address this, a versionless schema sf can be created, and it contains views which simply select * from every matching view in a versioned sf schema.

To create the versionless sf schema, call;

1. `call ro.sp_create_versionless_sf_schema_pointed_at_version( ‘YYMMDD’ );

To cascade drop the versionless sf schema, call;

1. call ro.sp_drop_versionless_sf_schema();

To manage privileges, the following procedures;

1. ro.sp_grant_versionless_sf_schema_to_group( 'YYMMDD' );
2. ro.sp_grant_versionless_sf_schema_to_public( 'YYMMDD' );
3. ro.sp_grant_versionless_sf_schema_to_role( 'YYMMDD' );
4. ro.sp_grant_versionless_sf_schema_to_user( 'YYMMDD' );
5. ro.sp_revoke_versionless_sf_schema_from_group( 'YYMMDD' );
6. ro.sp_revoke_versionless_sf_schema_from_public( 'YYMMDD' );
7. ro.sp_revoke_versionless_sf_schema_from_role( 'YYMMDD' );
8. ro.sp_revoke_versionless_sf_schema_from_user( 'YYMMDD' );

If you want to change where the versionless sf schema points, the schema must first be dropped, then created again, then privileges re-granted.

This is because it is practically certain that the prototype for at least some RST views will differ between releases, which will cause create or replace view to fail.

You can check what privileges have been granted by using the views which ship in the replacement system tables, for example like so;

1. select distinct group, substring(sschema from 5) as version from sf.groups_privileges where sschema ilike 'base_%';
2. select distinct uuser, substring(sschema from 5) as version from sf.users_privileges where sschema ilike 'base_%';
3. select distinct sschema, substring(sschema from 5) as version from sf.public_privileges where sschema ilike 'base_%';

(You could use a regex here to some effect, where regexp_instr( schema_name, '^(base|lf|sf)_[0-9]{6}$' ) != 0, but I wanted to keep the SQL straightforward.)

I’ve not yet published views for roles, so no query yet to examine grants to roles.

ro.installed_versions

Description

Columns

Column Descriptions

vversion

ro.sp_create_versionless_sf_schema_pointed_at_version

Description

Arguments

Argument Descriptions

version

ro.sp_drop_versionless_sf_schema

Description

Arguments

No arguments. ## ro.sp_grant_version_to_group

Description

Arguments

Argument Descriptions

version

group_name

ro.sp_grant_version_to_public

Description

Arguments

Argument Descriptions

version

ro.sp_grant_version_to_role

Description

Arguments

Argument Descriptions

version

role_name

ro.sp_grant_version_to_user

Description

Arguments

Argument Descriptions

version

user_name

ro.sp_grant_versionless_sf_schema_to_group

Description

Arguments

Argument Descriptions

group_name

ro.sp_grant_versionless_sf_schema_to_public

Description

Arguments

No arguments. ## ro.sp_grant_versionless_sf_schema_to_role

Description

Arguments

Argument Descriptions

role_name

ro.sp_grant_versionless_sf_schema_to_user

Description

Arguments

Argument Descriptions

user_name

ro.sp_revoke_version_from_group

Description

Arguments

Argument Descriptions

version

group_name

ro.sp_revoke_version_from_public

Description

Arguments

Argument Descriptions

version

ro.sp_revoke_version_from_role

Description

Arguments

Argument Descriptions

version

role_name

ro.sp_revoke_version_from_user

Description

Arguments

Argument Descriptions

version

user_name

ro.sp_revoke_versionless_sf_schema_from_group

Description

Arguments

Argument Descriptions

group_name

ro.sp_revoke_versionless_sf_schema_from_public

Description

Arguments

No arguments. ## ro.sp_revoke_versionless_sf_schema_from_role

Description

Arguments

Argument Descriptions

role_name

ro.sp_revoke_versionless_sf_schema_from_user

Description

Arguments

Argument Descriptions

user_name

ro.sp_uninstall_version

Description

Arguments

Argument Descriptions

version

Analyze

These views provide information about the ANALYZE command.

Firstly, there’s information about the table statistics state - good, stale or missing - for the cluster as a whole, or by schema.

(This information is provided on a per-table basis by the ttable views.)

Secondly, there are counts of how many ANALYZE commands, and of what type, were issued, with various _for types - database, table, user, etc.

lf_241129.analyze_totals_for_all_by_all

Description

Columns

Column Descriptions

number_manual_full_analyze

number_manual_predictatecolumn_analyze

number_manual_skipped_analyze

number_automatic_full_analyze

number_automatic_predictatecolumn_analyze

number_automatic_skipped_analyze

number_autoanalyze_full_analyze

number_autoanalyze_predictatecolumn_analyze

number_autoanalyze_skipped_analyze

number_total_full_analyze

number_total_predictatecolumn_analyze

number_total_skipped_analyze

lf_241129.analyze_totals_for_all_by_day

Description

Columns

Column Descriptions

start_ts

number_manual_full_analyze

number_manual_predictatecolumn_analyze

number_manual_skipped_analyze

number_automatic_full_analyze

number_automatic_predictatecolumn_analyze

number_automatic_skipped_analyze

number_autoanalyze_full_analyze

number_autoanalyze_predictatecolumn_analyze

number_autoanalyze_skipped_analyze

number_total_full_analyze

number_total_predictatecolumn_analyze

number_total_skipped_analyze

lf_241129.analyze_totals_for_all_by_hour

Description

Columns

Column Descriptions

start_ts

number_manual_full_analyze

number_manual_predictatecolumn_analyze

number_manual_skipped_analyze

number_automatic_full_analyze

number_automatic_predictatecolumn_analyze

number_automatic_skipped_analyze

number_autoanalyze_full_analyze

number_autoanalyze_predictatecolumn_analyze

number_autoanalyze_skipped_analyze

number_total_full_analyze

number_total_predictatecolumn_analyze

number_total_skipped_analyze

lf_241129.analyze_totals_for_all_by_minute

Description

Columns

Column Descriptions

start_ts

number_manual_full_analyze

number_manual_predictatecolumn_analyze

number_manual_skipped_analyze

number_automatic_full_analyze

number_automatic_predictatecolumn_analyze

number_automatic_skipped_analyze

number_autoanalyze_full_analyze

number_autoanalyze_predictatecolumn_analyze

number_autoanalyze_skipped_analyze

number_total_full_analyze

number_total_predictatecolumn_analyze

number_total_skipped_analyze

lf_241129.analyze_totals_for_all_by_second

Description

Columns

Column Descriptions

start_ts

number_manual_full_analyze

number_manual_predictatecolumn_analyze

number_manual_skipped_analyze

number_automatic_full_analyze

number_automatic_predictatecolumn_analyze

number_automatic_skipped_analyze

number_autoanalyze_full_analyze

number_autoanalyze_predictatecolumn_analyze

number_autoanalyze_skipped_analyze

number_total_full_analyze

number_total_predictatecolumn_analyze

number_total_skipped_analyze

lf_241129.analyze_totals_for_database_by_all

Description

Columns

Column Descriptions

database_name

number_manual_full_analyze

number_manual_predictatecolumn_analyze

number_manual_skipped_analyze

number_automatic_full_analyze

number_automatic_predictatecolumn_analyze

number_automatic_skipped_analyze

number_autoanalyze_full_analyze

number_autoanalyze_predictatecolumn_analyze

number_autoanalyze_skipped_analyze

number_total_full_analyze

number_total_predictatecolumn_analyze

number_total_skipped_analyze

lf_241129.analyze_totals_for_database_by_day

Description

Columns

Column Descriptions

database_name

start_ts

number_manual_full_analyze

number_manual_predictatecolumn_analyze

number_manual_skipped_analyze

number_automatic_full_analyze

number_automatic_predictatecolumn_analyze

number_automatic_skipped_analyze

number_autoanalyze_full_analyze

number_autoanalyze_predictatecolumn_analyze

number_autoanalyze_skipped_analyze

number_total_full_analyze

number_total_predictatecolumn_analyze

number_total_skipped_analyze

lf_241129.analyze_totals_for_database_by_hour

Description

Columns

Column Descriptions

database_name

start_ts

number_manual_full_analyze

number_manual_predictatecolumn_analyze

number_manual_skipped_analyze

number_automatic_full_analyze

number_automatic_predictatecolumn_analyze

number_automatic_skipped_analyze

number_autoanalyze_full_analyze

number_autoanalyze_predictatecolumn_analyze

number_autoanalyze_skipped_analyze

number_total_full_analyze

number_total_predictatecolumn_analyze

number_total_skipped_analyze

lf_241129.analyze_totals_for_database_by_minute

Description

Columns

Column Descriptions

database_name

start_ts

number_manual_full_analyze

number_manual_predictatecolumn_analyze

number_manual_skipped_analyze

number_automatic_full_analyze

number_automatic_predictatecolumn_analyze

number_automatic_skipped_analyze

number_autoanalyze_full_analyze

number_autoanalyze_predictatecolumn_analyze

number_autoanalyze_skipped_analyze

number_total_full_analyze

number_total_predictatecolumn_analyze

number_total_skipped_analyze

lf_241129.analyze_totals_for_database_by_second

Description

Columns

Column Descriptions

database_name

start_ts

number_manual_full_analyze

number_manual_predictatecolumn_analyze

number_manual_skipped_analyze

number_automatic_full_analyze

number_automatic_predictatecolumn_analyze

number_automatic_skipped_analyze

number_autoanalyze_full_analyze

number_autoanalyze_predictatecolumn_analyze

number_autoanalyze_skipped_analyze

number_total_full_analyze

number_total_predictatecolumn_analyze

number_total_skipped_analyze

lf_241129.analyze_totals_for_tables_by_all

Description

Columns

Column Descriptions

schema_id

schema_name

table_id

table_name

number_manual_full_analyze

number_manual_predictatecolumn_analyze

number_manual_skipped_analyze

number_automatic_full_analyze

number_automatic_predictatecolumn_analyze

number_automatic_skipped_analyze

number_autoanalyze_full_analyze

number_autoanalyze_predictatecolumn_analyze

number_autoanalyze_skipped_analyze

number_total_full_analyze

number_total_predictatecolumn_analyze

number_total_skipped_analyze

lf_241129.analyze_totals_for_tables_by_day

Description

Columns

Column Descriptions

schema_id

schema_name

table_id

table_name

start_ts

number_manual_full_analyze

number_manual_predictatecolumn_analyze

number_manual_skipped_analyze

number_automatic_full_analyze

number_automatic_predictatecolumn_analyze

number_automatic_skipped_analyze

number_autoanalyze_full_analyze

number_autoanalyze_predictatecolumn_analyze

number_autoanalyze_skipped_analyze

number_total_full_analyze

number_total_predictatecolumn_analyze

number_total_skipped_analyze

lf_241129.analyze_totals_for_tables_by_hour

Description

Columns

Column Descriptions

schema_id

schema_name

table_id

table_name

start_ts

number_manual_full_analyze

number_manual_predictatecolumn_analyze

number_manual_skipped_analyze

number_automatic_full_analyze

number_automatic_predictatecolumn_analyze

number_automatic_skipped_analyze

number_autoanalyze_full_analyze

number_autoanalyze_predictatecolumn_analyze

number_autoanalyze_skipped_analyze

number_total_full_analyze

number_total_predictatecolumn_analyze

number_total_skipped_analyze

lf_241129.analyze_totals_for_tables_by_minute

Description

Columns

Column Descriptions

schema_id

schema_name

table_id

table_name

start_ts

number_manual_full_analyze

number_manual_predictatecolumn_analyze

number_manual_skipped_analyze

number_automatic_full_analyze

number_automatic_predictatecolumn_analyze

number_automatic_skipped_analyze

number_autoanalyze_full_analyze

number_autoanalyze_predictatecolumn_analyze

number_autoanalyze_skipped_analyze

number_total_full_analyze

number_total_predictatecolumn_analyze

number_total_skipped_analyze

lf_241129.analyze_totals_for_tables_by_second

Description

Columns

Column Descriptions

schema_id

schema_name

table_id

table_name

start_ts

number_manual_full_analyze

number_manual_predictatecolumn_analyze

number_manual_skipped_analyze

number_automatic_full_analyze

number_automatic_predictatecolumn_analyze

number_automatic_skipped_analyze

number_autoanalyze_full_analyze

number_autoanalyze_predictatecolumn_analyze

number_autoanalyze_skipped_analyze

number_total_full_analyze

number_total_predictatecolumn_analyze

number_total_skipped_analyze

lf_241129.analyze_totals_for_users_by_all

Description

Columns

Column Descriptions

user_id

user_name

number_manual_full_analyze

number_manual_predictatecolumn_analyze

number_manual_skipped_analyze

number_automatic_full_analyze

number_automatic_predictatecolumn_analyze

number_automatic_skipped_analyze

number_autoanalyze_full_analyze

number_autoanalyze_predictatecolumn_analyze

number_autoanalyze_skipped_analyze

number_total_full_analyze

number_total_predictatecolumn_analyze

number_total_skipped_analyze

lf_241129.analyze_totals_for_users_by_day

Description

Columns

Column Descriptions

user_id

user_name

start_ts

number_manual_full_analyze

number_manual_predictatecolumn_analyze

number_manual_skipped_analyze

number_automatic_full_analyze

number_automatic_predictatecolumn_analyze

number_automatic_skipped_analyze

number_autoanalyze_full_analyze

number_autoanalyze_predictatecolumn_analyze

number_autoanalyze_skipped_analyze

number_total_full_analyze

number_total_predictatecolumn_analyze

number_total_skipped_analyze

lf_241129.analyze_totals_for_users_by_hour

Description

Columns

Column Descriptions

user_id

user_name

start_ts

number_manual_full_analyze

number_manual_predictatecolumn_analyze

number_manual_skipped_analyze

number_automatic_full_analyze

number_automatic_predictatecolumn_analyze

number_automatic_skipped_analyze

number_autoanalyze_full_analyze

number_autoanalyze_predictatecolumn_analyze

number_autoanalyze_skipped_analyze

number_total_full_analyze

number_total_predictatecolumn_analyze

number_total_skipped_analyze

lf_241129.analyze_totals_for_users_by_minute

Description

Columns

Column Descriptions

user_id

user_name

start_ts

number_manual_full_analyze

number_manual_predictatecolumn_analyze

number_manual_skipped_analyze

number_automatic_full_analyze

number_automatic_predictatecolumn_analyze

number_automatic_skipped_analyze

number_autoanalyze_full_analyze

number_autoanalyze_predictatecolumn_analyze

number_autoanalyze_skipped_analyze

number_total_full_analyze

number_total_predictatecolumn_analyze

number_total_skipped_analyze

lf_241129.analyze_totals_for_users_by_second

Description

Columns

Column Descriptions

user_id

user_name

start_ts

number_manual_full_analyze

number_manual_predictatecolumn_analyze

number_manual_skipped_analyze

number_automatic_full_analyze

number_automatic_predictatecolumn_analyze

number_automatic_skipped_analyze

number_autoanalyze_full_analyze

number_autoanalyze_predictatecolumn_analyze

number_autoanalyze_skipped_analyze

number_total_full_analyze

number_total_predictatecolumn_analyze

number_total_skipped_analyze

lf_241129.analyze_totals_status_for_all

Description

Columns

Column Descriptions

number_good_stats

number_stale_stats

number_missing_stats

number_total_stats

lf_241129.analyze_totals_status_for_schema

Description

Columns

Column Descriptions

schema_id

schema_name

number_good_stats

number_stale_stats

number_missing_stats

number_total_stats

sf_241129.analyze_totals_for_all_by_all

Description

Columns

Column Descriptions

manual

automatic

autoanalyze

total

sf_241129.analyze_totals_for_all_by_day

Description

Columns

Column Descriptions

start_ts

manual

automatic

autoanalyze

total

sf_241129.analyze_totals_for_all_by_hour

Description

Columns

Column Descriptions

start_ts

manual

automatic

autoanalyze

total

sf_241129.analyze_totals_for_all_by_minute

Description

Columns

Column Descriptions

start_ts

manual

automatic

autoanalyze

total

sf_241129.analyze_totals_for_all_by_second

Description

Columns

Column Descriptions

start_ts

manual

automatic

autoanalyze

total

sf_241129.analyze_totals_for_database_by_all

Description

Columns

Column Descriptions

dbname

manual

automatic

autoanalyze

total

sf_241129.analyze_totals_for_database_by_day

Description

Columns

Column Descriptions

dbname

start_ts

manual

automatic

autoanalyze

total

sf_241129.analyze_totals_for_database_by_hour

Description

Columns

Column Descriptions

dbname

start_ts

manual

automatic

autoanalyze

total

sf_241129.analyze_totals_for_database_by_minute

Description

Columns

Column Descriptions

dbname

start_ts

manual

automatic

autoanalyze

total

sf_241129.analyze_totals_for_database_by_second

Description

Columns

Column Descriptions

dbname

start_ts

manual

automatic

autoanalyze

total

sf_241129.analyze_totals_for_tables_by_all

Description

Columns

Column Descriptions

sschema

ttable

manual

automatic

autoanalyze

total

sf_241129.analyze_totals_for_tables_by_day

Description

Columns

Column Descriptions

sschema

ttable

start_ts

manual

automatic

autoanalyze

total

sf_241129.analyze_totals_for_tables_by_hour

Description

Columns

Column Descriptions

sschema

ttable

start_ts

manual

automatic

autoanalyze

total

sf_241129.analyze_totals_for_tables_by_minute

Description

Columns

Column Descriptions

sschema

ttable

start_ts

manual

automatic

autoanalyze

total

sf_241129.analyze_totals_for_tables_by_second

Description

Columns

Column Descriptions

sschema

ttable

start_ts

manual

automatic

autoanalyze

total

sf_241129.analyze_totals_for_users_by_all

Description

Columns

Column Descriptions

uuser

manual

automatic

autoanalyze

total

sf_241129.analyze_totals_for_users_by_day

Description

Columns

Column Descriptions

uuser

start_ts

manual

automatic

autoanalyze

total

sf_241129.analyze_totals_for_users_by_hour

Description

Columns

Column Descriptions

uuser

start_ts

manual

automatic

autoanalyze

total

sf_241129.analyze_totals_for_users_by_minute

Description

Columns

Column Descriptions

uuser

start_ts

manual

automatic

autoanalyze

total

sf_241129.analyze_totals_for_users_by_second

Description

Columns

Column Descriptions

uuser

start_ts

manual

automatic

autoanalyze

total

sf_241129.analyze_totals_status_for_all

Description

Columns

Column Descriptions

good

stale

missing

total

sf_241129.analyze_totals_status_for_schema

Description

Columns

Column Descriptions

sschema

good

stale

missing

total

Batches

Batches is the short name for commit batches.

When commit is issued, the transaction does not necessarily immediately to commit. Rather, Redshift groups up transactions which have issued commit into commit batches, and that group - batch - of transactions is committed as a whole.

The batch views provide information about commit batches.

Just remember on a busy system there’s a long delay, after the final time for the batch, until the commits actually return to the user, with that delay not recorded anywhere in the system tables.

lf_241129.batches

Description

Columns

Column Descriptions

batch_id

batch_startqueue

batch_leader_startwork

batch_worker_startwork

batch_endlocal

batch_worker_startglobal

batch_leader_endtime

batch_worker_endtime

batch_endtime

batch_queue_duration

batch_worker_local_duration

batch_worker_global_duration

batch_worker_total_duration

batch_worker_duration

batch_leader_and_worker_local_duration

batch_leader_duration

batch_exec_duration

batch_total_duration

number_batch_blocks

number_batch_headers

number_batch_transactions

sf_241129.batches

Description

Columns

Column Descriptions

bid

start_ts

end_ts

queue

leader

worker

exec

blks

hdrs

xids

Blocks

All I/O in Redshift is in one megabyte blocks, known as blocks for short.

As such, all disk I/O is in blocks, and so if for example a single row is written to a table, then one block is written to every column in that table, on the slice the row goes to.

Disk use then is measured in blocks, and these views provide information on the number of blocks in use, as well as providing counts of the numbers of rows that exist, on various _for types, such as node, slice, schema and so on.

lf_241129.blocks_rows_totals_for_cluster

Description

Columns

Column Descriptions

number_nodes

number_partial_slices

number_full_slices

number_sorted_blocks

number_desorted_blocks

number_unsorted_blocks

number_total_blocks

number_sorted_rows

number_desorted_rows

number_unsorted_rows

number_total_rows

lf_241129.blocks_rows_totals_for_node

Description

Columns

Column Descriptions

node_ordinal

number_partial_slices

number_full_slices

number_total_slices

number_sorted_blocks

number_desorted_blocks

number_unsorted_blocks

number_total_blocks

number_sorted_rows

number_desorted_rows

number_unsorted_rows

number_total_rows

lf_241129.blocks_rows_totals_for_schema

Description

Columns

Column Descriptions

schema_id

schema_name

number_sorted_blocks

number_desorted_blocks

number_unsorted_blocks

number_total_blocks

number_sorted_rows

number_desorted_rows

number_unsorted_rows

number_total_rows

lf_241129.blocks_rows_totals_for_slice

Description

Columns

Column Descriptions

node_ordinal

slice_ordinal

slice_type

number_sorted_blocks

number_desorted_blocks

number_unsorted_blocks

number_total_blocks

number_sorted_rows

number_desorted_rows

number_unsorted_rows

number_total_rows

lf_241129.blocks_rows_totals_for_table

Description

Columns

Column Descriptions

schema_id

schema_name

table_id

table_name

table_sort_type

number_sorted_blocks

number_desorted_blocks

number_unsorted_blocks

number_total_blocks

number_sorted_rows

number_desorted_rows

number_unsorted_rows

number_total_rows

lf_241129.blocks_rows_totals_for_tables_by_node

Description

Columns

Column Descriptions

schema_id

schema_name

table_id

table_name

table_distribution_type

table_distribution_auto_flag

node_ordinal

number_sorted_blocks

number_unsorted_blocks

number_total_blocks

number_sorted_rows

number_unsorted_rows

number_total_rows

lf_241129.blocks_rows_totals_for_tables_by_slice

Description

Columns

Column Descriptions

schema_id

schema_name

table_id

table_name

table_distribution_type

table_distribution_auto_flag

node_ordinal

slice_ordinal

slice_type

number_sorted_blocks

number_unsorted_blocks

number_total_blocks

number_sorted_rows

number_unsorted_rows

number_total_rows

lf_241129.blocks_rows_totals_for_user

Description

Columns

Column Descriptions

user_id

user_name

number_sorted_blocks

number_desorted_blocks

number_unsorted_blocks

number_total_blocks

number_sorted_rows

number_desorted_rows

number_unsorted_rows

number_total_rows

lf_241129.blocks_totals_for_tables_by_column

Description

Columns

Column Descriptions

schema_id

schema_name

table_id

table_name

column_ordinal

column_name

number_sorted_blocks

number_unsorted_blocks

number_total_blocks

sf_241129.blocks_rows_totals_for_cluster

Description

Columns

Column Descriptions

nodes

partial_slices

full_slices

sblks

dsblks

ublks

tblks

srows

dsrows

urows

trows

sf_241129.blocks_rows_totals_for_node

Description

Columns

Column Descriptions

node

slices

sblks

dsblks

ublks

tblks

srows

dsrows

urows

trows

sf_241129.blocks_rows_totals_for_schema

Description

Columns

Column Descriptions

sschema

sblks

sdblks

ublks

tblks

srows

sdrops

urows

trows

sf_241129.blocks_rows_totals_for_slice

Description

Columns

Column Descriptions

node

slice

ttype

sblks

dsblks

ublks

tblks

srows

dsrows

urows

trows

sf_241129.blocks_rows_totals_for_table

Description

Columns

Column Descriptions

sschema

ttable

sblks

dsblks

ublks

tblks

srows

dsrows

urows

trows

sf_241129.blocks_rows_totals_for_tables_by_node

Description

Columns

Column Descriptions

sschema

ttable

dist

a

n

sblks

ublks

tblks

srows

urows

trows

sf_241129.blocks_rows_totals_for_tables_by_slice

Description

Columns

Column Descriptions

sschema

ttable

dist

a

n

s

t

sblks

ublks

tblks

srows

urows

trows

sf_241129.blocks_rows_totals_for_user

Description

Columns

Column Descriptions

uuser

sblks

dsblks

ublks

tblks

srows

dsrows

urows

trows

sf_241129.blocks_totals_for_tables_by_column

Description

Columns

Column Descriptions

sschema

ttable

ccolumn

sblks

ublks

tblks

Ddatabases

This set of views provides information about the databases in the cluster.

The first letter of databases is doubled as this is a reserved word and as such cannot be tab completed in psql.

lf_241129.ddatabases

Description

Columns

Column Descriptions

database_id

database_name

user_id

user_name

isolation_method

sf_241129.ddatabases

Description

Columns

Column Descriptions

database_name

user_name

iisolation

Docs

This section contains the documentation for each function, procedure and view (but not yet tables).

Use sf.docs to read the doc page for a given object, like so;

select * from sf.docs where sschema = '[schema_name] and oobject = [object_name];`

sf_241129.docs

Description

Columns

Column Descriptions

sschema

oobject

ttype

doc

Ffunctions

This set of views provides information about functions in the cluster.

The first letter of functions is doubled as this is a reserved word and as such cannot be tab completed in psql.

Note that the long-form view lf.ffunctions show information about all functions in the cluster, where-as the short-form view excludes information about functions owned by user rdsdb.

There are untold thousands of functions owned by rdsdb, all the function you find in SQL, such as count(), min() and max(), with all their overloaded variants, where in the normal course of things my expectation is that users are interested only in the functions they themselves have defined.

lf_241129.ffunctions

Description

Columns

Column Descriptions

schema_id

schema_name

language_id

language_name

user_id

user_name

function_volatility

function_return_data_type_id

function_return_data_type_name

function_id

function_name

function_arguments_base_data_type_ids

function_arguments_base_data_type_names

lf_241129.ffunctions_text

Description

Columns

Column Descriptions

schema_id

schema_name

function_id

function_name

function_text

sf_241129.ffunctions

Description

Columns

Column Descriptions

sschema

ttype

uuser

vol

rreturn

nname

args

sf_241129.ffunctions_text

Description

Columns

Column Descriptions

fid

ttext

Fixed

These views are a veneer over the Redshift system tables, to providing consist column naming, correct flaws, inappropriate data type choices, and so on.

This work is best done in a veneer, otherwise it has to be repeated in every view using the Redshift system tables.

base_241129.fixed_pg_attribute

Description

Columns

Column Descriptions

object_id

column_name

column_ordinal

atttypmod

column_notnull_flag

base_241129.fixed_pg_attribute_for_tables

Description

Columns

Column Descriptions

table_id

column_name

column_ordinal

atttypmod

column_notnull_flag

base_241129.fixed_pg_attribute_for_views

Description

Columns

Column Descriptions

view_id

column_name

column_ordinal

atttypmod

column_notnull_flag

base_241129.fixed_pg_class

Description

Columns

Column Descriptions

object_id

object_name

schema_id

user_id

relnatts

relkind

base_241129.fixed_pg_class_for_tables

Description

Columns

Column Descriptions

table_id

table_name

schema_id

user_id

relnatts

base_241129.fixed_pg_class_for_views

Description

Columns

Column Descriptions

view_id

view_name

schema_id

user_id

relnatts

base_241129.fixed_pg_get_late_binding_view_cols

Description

Columns

Column Descriptions

attnum

attname

attrelid

atttypmod

atttypid

base_241129.fixed_pg_group

Description

Columns

Column Descriptions

group_id

group_name

base_241129.fixed_pg_language

Description

Columns

Column Descriptions

language_id

language_name

user_id

base_241129.fixed_pg_namespace

Description

Columns

Column Descriptions

schema_id

schema_name

user_id

base_241129.fixed_pg_proc

Description

Columns

Column Descriptions

object_id

object_name

schema_id

user_id

language_id

language_name

provolatile

prorettype

proretset

prosrc

proargtypes

base_241129.fixed_pg_proc_for_functions

Description

Columns

Column Descriptions

function_id

function_name

schema_id

user_id

language_id

language_name

provolatile

prorettype

proretset

function_text

proargtypes

base_241129.fixed_pg_proc_for_procedures

Description

Columns

Column Descriptions

procedure_id

procedure_name

schema_id

user_id

language_id

language_name

procedure_text

proargtypes

base_241129.fixed_pg_user

Description

Columns

Column Descriptions

user_id

user_name

base_241129.fixed_stl_commit_stats

Description

Columns

Column Descriptions

batch_id

transaction_id

node_ordinal

startqueue

startwork

endflush

endstage

endlocal

startglobal

endtime

newblocks

dirtyblocks

headers

base_241129.fixed_stl_ddltext

Description

Columns

Column Descriptions

user_id

transaction_id

session_id

queue_id

query_start_ts

query_end_ts

sequence

query_text

query_queue_duration

query_wlm_duration

query_compile_exec_duration

query_total_duration

base_241129.fixed_stl_load_errors

Description

Columns

Column Descriptions

column_name

reason

file_name

line_number

query_id

field_value

slice_ordinal

event_ts

table_id

column_full_data_type_name

user_id

base_241129.fixed_stl_query

Description

Columns

Column Descriptions

query_abort_flag

query_csc_flag

database_partial_name

query_end_ts

session_id

query_id

query_text

query_start_ts

user_id

transaction_id

query_total_duration

base_241129.fixed_stl_query_metrics

Description

Columns

Column Descriptions

query_number_blocks_read

query_number_blocks_to_disk

query_cpu_time

query_id

query_number_rows

queue_id

query_start_ts

user_id

base_241129.fixed_stl_querytext

Description

Columns

Column Descriptions

user_id

transaction_id

session_id

query_id

sequence

query_text

base_241129.fixed_stl_scan

Description

Columns

Column Descriptions

user_id

query_id

slice_ordinal

segment_ordinal

step_ordinal

scan_start_ts

scan_end_ts

tasknum

rows

bytes

fetches

type

table_id

is_rrscan

is_delayed_scan

rows_pre_filter

rows_pre_user_filter

perm_table_name

is_rlf_scan

is_rlf_scan_reason

num_em_blocks

checksum

runtime_filtering

scan_region

num_sortkey_as_predicate

row_fetcher_state

consumed_scan_ranges

work_stealing_reason

is_vectorized_scan

is_vectorized_scan_reason

row_fetcher_reason

topology_signature

use_tpm_partition

is_rrscan_expr

use_fwd_mtx_opt

scanned_mega_value

base_241129.fixed_stl_utilitytext

Description

Columns

Column Descriptions

user_id

transaction_id

session_id

queue_id

query_start_ts

query_end_ts

sequence

query_text

query_queue_duration

query_wlm_duration

query_compile_exec_duration

query_total_duration

base_241129.fixed_stl_vacuum_detail

Description

Columns

Column Descriptions

compact

empty_space_size

end_row

insufficient_local_blk_cnt

local_block_count

local_to_total_ratio

num_blocks_replaced

num_deleted_rows

num_new_blocks

num_new_rows

part

session_id

query_id

slice_ordinal

start_row

table_id

table_partition_number

total_block_io_estimate

user_id

window_num

transaction_id

base_241129.fixed_stl_wlm_query

Description

Columns

Column Descriptions

query_compile_exec_end_ts

query_compile_exec_start_ts

final_state

query_id

query_queue_end_ts

query_queue_start_ts

queue_id

query_wlm_end_ts

query_wlm_start_ts

slot_count

task_id

user_id

transaction_id

query_queue_duration

query_compile_exec_duration

query_wlm_duration

base_241129.fixed_stl_wlm_rule_action

Description

Columns

Column Descriptions

action

rule_action

query_id

event_ts

rule_name

queue_id

user_id

base_241129.fixed_stv_blocklist

Description

Columns

Column Descriptions

slice_ordinal

column_ordinal

table_id

block_ordinal

block_number_values

block_min_value

block_max_value

block_sorted_flag

base_241129.fixed_stv_inflight

Description

Columns

Column Descriptions

csc_flag

label

session_id

query_id

slice_ordinal

query_start_ts

text

user_id

transaction_id

base_241129.fixed_stv_query_metrics

Description

Columns

Column Descriptions

query_number_blocks_read

query_number_blocks_to_disk

query_cpu_time

query_id

query_number_rows

queue_id

query_start_ts

user_id

base_241129.fixed_stv_slices

Description

Columns

Column Descriptions

node_ordinal

slice_ordinal

slice_type

base_241129.fixed_stv_wlm_classification_config

Description

Columns

Column Descriptions

action

action_seq

queue_id

condition

id

base_241129.fixed_stv_wlm_qmr_config

Description

Columns

Column Descriptions

rule_action

action_value

metric_name

metric_operator

metric_value

rule_name

queue_id

base_241129.fixed_stv_wlm_query_state

Description

Columns

Column Descriptions

exec_time

query_id

query_priority

queue_time

queue_id

query_slot_count

query_state

task_id

wlm_start_time

transaction_id

base_241129.fixed_stv_wlm_service_class_config

Description

Columns

Column Descriptions

queue_csc_flag

max_execution_time

queue_name

num_query_tasks

query_group_wildcard_flag

query_working_mem

queue_id

user_group_wildcard_flag

user_role_wildcard_flag

base_241129.fixed_stv_wlm_service_class_state

Description

Columns

Column Descriptions

num_concurrency_scaling_queries

num_evicted_queries

num_executed_queries

num_executing_queries

num_queued_queries

num_serviced_queries

queue_id

base_241129.fixed_svl_compile

Description

Columns

Column Descriptions

compile_flag

segment_compile_end_ts

session_id

query_id

segment_ordinal

segment_compile_start_ts

user_id

transaction_id

segment_compile_duration