Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 17.12.2020 01:27
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17280996 kB
MemAvailable 31487884 kB
Buffers 0 kB
Cached 14378624 kB
SwapCached 3712 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-17 01:27:07
DTS_END                         2020-12-17 01:27:07.7420
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/55558
TRN_ID                          254544
ATT_ID                          691
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 120 minutes: 9728.67 20612 1167440
customer order: creation 182.82 352 21938
customer order: refuse 15.46 270 1855
order to supplier: creation 48.46 1117 5815
order to supplier: removal 3.53 93900 423
invoice (draft): creation 47.48 2901 5698
invoice (draft): removal 54.71 632 6565
invoice accept: apply 44.51 17624 5341
invoice accept: cancel 49.79 719 5975
customer reserve: creation 4090.19 176 490823
customer reserve: removal 4878.82 54 585458
realization accept: apply 89.36 157 10723
realization accept: cancel 86.38 107 10365
payment from customer: creation 62.89 98 7547
payment from customer: removal 5.73 116 687
payment to supplier: creation 52.03 112 6244
payment to supplier: removal 3.70 68 444
service: total inventory turnovers 4.81 1009 577
service: total monetary turnovers 7.11 34 853
service: aggregate perf. data 0.88 20582 105
service: refresh index statistics 0.03 272202 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 17-12-2020 01:27:58 to 17-12-2020 01:28:01.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9057
TEST_TIME 2 6920
TEST_TIME 3 8214
TEST_TIME 4 6788
TEST_TIME 5 6111
TEST_TIME 6 5967
TEST_TIME 7 6533
TEST_TIME 8 6739
TEST_TIME 9 6620
TEST_TIME 10 6798
TEST_TIME 11 7118
TEST_TIME 12 7696
TEST_TIME 13 7821
TEST_TIME 14 8234
TEST_TIME 15 8369
TEST_TIME 16 8932
TEST_TIME 17 9593
TEST_TIME 18 9469
TEST_TIME 19 9468
TEST_TIME 20 9657
TEST_TIME 21 10272
TEST_TIME 22 11043
TEST_TIME 23 11736
TEST_TIME 24 12270
TEST_TIME 25 12196
TEST_TIME 26 11882
TEST_TIME 27 11605
TEST_TIME 28 11400
TEST_TIME 29 11270
TEST_TIME 30 11181
TEST_TIME 31 11059
TEST_TIME 32 10933
TEST_TIME 33 10967
TEST_TIME 34 10844
TEST_TIME 35 10798
TEST_TIME 36 10758
TEST_TIME 37 10749
TEST_TIME 38 10572
TEST_TIME 39 10691
TEST_TIME 40 10719
TEST_TIME 41 10698
TEST_TIME 42 10682
TEST_TIME 43 10737
TEST_TIME 44 10656
TEST_TIME 45 10694
TEST_TIME 46 10657
TEST_TIME 47 10700
TEST_TIME 48 10705
TEST_TIME 49 10657
TEST_TIME 50 10590
TEST_TIME 51 10633
TEST_TIME 52 10650
TEST_TIME 53 10482
TEST_TIME 54 10392
TEST_TIME 55 10365
TEST_TIME 56 10291
TEST_TIME 57 10225
TEST_TIME 58 10199
TEST_TIME 59 10154
TEST_TIME 60 10091
TEST_TIME 61 10184
TEST_TIME 62 10165
TEST_TIME 63 10177
TEST_TIME 64 10120
TEST_TIME 65 10306
TEST_TIME 66 10309
TEST_TIME 67 10229
TEST_TIME 68 10275
TEST_TIME 69 10248
TEST_TIME 70 10282
TEST_TIME 71 10324
TEST_TIME 72 10334
TEST_TIME 73 10340
TEST_TIME 74 10354
TEST_TIME 75 10318
TEST_TIME 76 10257
TEST_TIME 77 10177
TEST_TIME 78 10199
TEST_TIME 79 10154
TEST_TIME 80 10192
TEST_TIME 81 10113
TEST_TIME 82 10064
TEST_TIME 83 10021
TEST_TIME 84 9970
TEST_TIME 85 9983
TEST_TIME 86 9993
TEST_TIME 87 9987
TEST_TIME 88 9970
TEST_TIME 89 10004
TEST_TIME 90 10020
TEST_TIME 91 10003
TEST_TIME 92 10008
TEST_TIME 93 10050
TEST_TIME 94 10123
TEST_TIME 95 10110
TEST_TIME 96 10069
TEST_TIME 97 10190
TEST_TIME 98 10178
TEST_TIME 99 10192
TEST_TIME 100 10162
TEST_TIME 101 10079
TEST_TIME 102 10063
TEST_TIME 103 10094
TEST_TIME 104 10035
TEST_TIME 105 9988
TEST_TIME 106 9978
TEST_TIME 107 9936
TEST_TIME 108 9933
TEST_TIME 109 9919
TEST_TIME 110 9846
TEST_TIME 111 9802
TEST_TIME 112 9834
TEST_TIME 113 9825
TEST_TIME 114 9816
TEST_TIME 115 9804
TEST_TIME 116 9787
TEST_TIME 117 9784
TEST_TIME 118 9765
TEST_TIME 119 9800
TEST_TIME 120 9740

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 17-12-2020 01:28:02 to 17-12-2020 01:28:05.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1622208 1622208 0 0.00 0 13222 6 0 0
doc_list_biud 1622181 1622181 0 0.00 0 38598 24 0 0
sp_add_invoice_to_stock 5473 5341 132 2.41 34 276422 17624 0 132
sp_cancel_adding_invoice 5975 5975 0 0.00 5 79539 720 0 0
sp_cancel_client_order 1855 1855 0 0.00 4 9757 270 0 0
sp_cancel_customer_reserve 585458 585458 0 0.00 1 24234 55 0 0
sp_cancel_pay_from_customer 687 687 0 0.00 2 9215 117 0 0
sp_cancel_pay_to_supplier 444 444 0 0.00 3 3063 69 0 0
sp_cancel_supplier_invoice 6573 6565 8 0.12 1 38604 632 0 8
sp_cancel_supplier_order 423 423 0 0.00 15 973906 93901 0 0
sp_cancel_write_off 10365 10365 0 0.00 1 10666 107 0 0
sp_client_order 21938 21938 0 0.00 3 55954 352 0 0
sp_customer_reserve 490823 490823 0 0.00 0 150448 177 0 0
sp_fill_shopping_cart 33446 33446 0 0.00 1 14395 34 0 0
sp_fill_shopping_cart_clo_res 490795 490795 0 0.00 0 17815 13 0 0
sp_get_clo_for_invoice 5307 5307 0 0.00 0 32719 296 0 0
sp_kill_cost_storno 17471 17471 0 0.00 0 7828 52 0 0
sp_kill_qstorno_ret_qs2qd 1188269 1188269 0 0.00 0 38595 29 0 0
sp_kill_qty_storno 626670 626670 0 0.00 0 38597 62 0 0
sp_lock_selected_doc 22108 22108 0 0.00 0 9203 8 0 0
sp_make_cost_storno 29820 29820 0 0.00 0 13213 39 0 0
sp_multiply_rows_for_pdistr 29820 29820 0 0.00 0 11798 24 0 0
sp_multiply_rows_for_qdistr 21938 21938 0 0.00 0 55821 154 0 0
sp_pay_from_customer 7547 7547 0 0.00 4 21008 98 0 0
sp_pay_to_supplier 6244 6244 0 0.00 5 13232 112 0 0
sp_payment_common 13791 13791 0 0.00 1 20970 24 0 0
sp_qd_handle_on_cancel_clo 1855 1855 0 0.00 0 9749 245 0 0
sp_qd_handle_on_invoice_upd_sts 11282 11282 0 0.00 0 12093 269 0 0
sp_qd_handle_on_reserve_upd_sts 10722 10722 0 0.00 0 16070 54 0 0
sp_reserve_write_off 10723 10723 0 0.00 6 18250 158 0 0
sp_supplier_invoice 5698 5698 0 0.00 6 90566 2901 0 0
sp_supplier_order 5815 5815 0 0.00 5 40746 1117 0 0
srv_aggregate_perf_data 106 105 1 0.94 2782 335658 20583 0 1
srv_fill_mon_cache_memory 153 153 0 0.00 1312 191134 35435 0 0
srv_find_qd_qs_mism 1116981 1116981 0 0.00 0 9093 6 0 0
srv_make_invnt_saldo 577 577 0 0.00 43 49956 1009 0 0
srv_make_money_saldo 853 853 0 0.00 1 7140 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 181127 359285 272202 0 0
t$perf-abend:sp_add_invoice_to_stock 132 132 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5341 5341 0 0.00 0 8497 150 0 0
t$perf-norm:sp_cancel_adding_invoice 419 419 0 0.00 0 3401 67 0 0
t$perf-norm:sp_cancel_client_order 1855 1855 0 0.00 0 5285 10 0 0
t$perf-norm:sp_cancel_customer_reserve 788 788 0 0.00 0 1205 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 687 687 0 0.00 0 821 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 444 444 0 0.00 0 1538 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 431 431 0 0.00 0 520 10 0 0
t$perf-norm:sp_cancel_supplier_order 423 423 0 0.00 0 32109 1554 0 0
t$perf-norm:sp_cancel_write_off 1033 1033 0 0.00 0 4949 17 0 0
t$perf-norm:sp_client_order 21938 21938 0 0.00 0 8035 13 0 0
t$perf-norm:sp_customer_reserve 1023 1023 0 0.00 0 6852 12 0 0
t$perf-norm:sp_pay_from_customer 7547 7547 0 0.00 0 3863 8 0 0
t$perf-norm:sp_pay_to_supplier 6244 6244 0 0.00 0 5758 11 0 0
t$perf-norm:sp_reserve_write_off 10723 10723 0 0.00 0 6358 11 0 0
t$perf-norm:sp_supplier_invoice 5698 5698 0 0.00 0 4326 16 0 0
t$perf-norm:sp_supplier_order 5815 5815 0 0.00 0 4674 13 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 342 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 153 153 0 0.00 0 1661 20 0 0
t$perf-norm:srv_make_invnt_saldo 577 577 0 0.00 0 4151 26 0 0
t$perf-norm:srv_make_money_saldo 853 853 0 0.00 0 610 9 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 7 4 0 0
v_add_invoice_to_stock 10876 10612 264 2.42 0 10466 22 0 264
v_all_customers 39882 39882 0 0.00 0 30 1 0 0
v_all_suppliers 31756 31756 0 0.00 0 153 1 0 0
v_all_wares 43876 43876 0 0.00 0 26 1 0 0
v_cancel_adding_invoice 838 838 0 0.00 0 1738 8 0 0
v_cancel_client_order 3710 3710 0 0.00 0 6680 5 0 0
v_cancel_customer_prepayment 1374 1374 0 0.00 0 6751 13 0 0
v_cancel_customer_reserve 1576 1576 0 0.00 0 3338 9 0 0
v_cancel_payment_to_supplier 888 888 0 0.00 0 1629 7 0 0
v_cancel_supplier_invoice 878 862 16 1.82 0 3824 20 0 16
v_cancel_supplier_order 846 846 0 0.00 0 4529 10 0 0
v_cancel_write_off 2066 2066 0 0.00 0 2670 18 0 0
v_max_id_clo_ord 5813 5813 0 0.00 0 1896 2 0 0
v_max_id_clo_res 1023 1023 0 0.00 0 1032 6 0 0
v_max_id_ord_sup 5695 5695 0 0.00 0 6380 6 0 0
v_max_non_paid_invoice 1874 1874 0 0.00 0 916 4 0 0
v_max_non_paid_realizn 4045 4045 0 0.00 0 5061 5 0 0
v_min_id_clo_ord 5813 5813 0 0.00 0 2837 4 0 0
v_min_id_clo_res 1023 1023 0 0.00 0 6090 11 0 0
v_min_id_ord_sup 5695 5695 0 0.00 0 5465 4 0 0
v_min_non_paid_invoice 6244 6244 0 0.00 0 5664 13 0 0
v_min_non_paid_realizn 7547 7547 0 0.00 0 4608 12 0 0
v_our_firm 10998 10998 0 0.00 0 16 1 0 0
v_reserve_write_off 21444 21444 0 0.00 0 3965 7 0 0
x_lock_depdocs_on_canc_invoice 12109 12109 0 0.00 0 19542 114 0 0
x_lock_depdocs_on_canc_sup_ord 423 423 0 0.00 0 3209 270 0 0
x_make_qstorno_1000_1200 5815 5815 0 0.00 2 40737 1052 0 0
x_make_qstorno_1200_2000 5698 5698 0 0.00 3 88662 2778 0 0
x_make_qstorno_2100_3300 490823 490823 0 0.00 0 149494 161 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 17-12-2020 01:28:06 to 17-12-2020 01:28:11.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:11 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:17 14697 8192000000 10222094544 10523435008 779612912 8.689 63 45 90 1 796227872 2106992 14507968
22:57:40 16481 8192000000 10307910976 10624266240 1362017568 14.255 100 83 167 0 1393081904 4300576 26763760
22:58:11 17398 8192000000 10350127888 10670940160 1402623120 14.618 100 87 174 1 1437533072 5678240 29231712
22:58:38 22571 8192000000 10384215984 10712170496 1429961264 14.861 100 81 162 0 1463238256 6594000 26682992
22:59:14 9613 8192000000 10413463088 10744655872 1470601856 15.219 100 85 170 0 1505783856 7540784 27641216
22:59:40 16484 8192000000 10455785072 10790592512 1498411328 15.462 100 89 178 0 1535411888 8162928 28837632
23:00:06 22555 8192000000 10469500848 10808385536 1525569808 15.699 100 87 174 1 1562251968 8961744 27720416
23:00:42 20472 8192000000 10485356272 10826727424 1537759488 15.804 100 84 168 0 1574111568 9634912 26717168
23:01:10 9599 8192000000 10505249616 10851115008 1556146144 15.963 100 84 168 0 1592771008 10111376 26513488
23:01:30 18952 8192000000 10517993936 10874368000 1580511520 16.173 100 71 140 1 1612869840 11173936 21184384
23:01:56 12940 8192000000 10557194560 10910072832 1608439712 16.411 100 81 160 2 1643646528 11126896 24079920
23:02:16 9785 8192000000 10575694992 10931474432 1633515744 16.625 100 94 188 0 1673933136 12307728 28109664
23:02:33 11060 8192000000 10579122464 10942169088 1639820176 16.678 100 77 154 0 1675139056 12205232 23113648
23:02:56 9575 8192000000 10594740320 10960773120 1652052016 16.782 100 78 155 0 1686921904 12546720 22323168
23:03:18 10801 8192000000 10627664752 10991202304 1676719984 16.990 100 77 154 1 1712366288 12261280 23385024
23:03:38 6835 8192000000 10658905312 11023515648 1708387424 17.255 100 90 176 0 1747744080 13369792 25986864
23:03:52 5543 8192000000 10651414768 11026804736 1711008656 17.277 100 78 156 2 1745957264 12350224 22598384
23:04:05 5842 8192000000 10654124448 11029757952 1726163744 17.404 100 84 168 0 1763020832 12464288 24392800
23:04:20 5824 8192000000 10672931232 11048173568 1732308944 17.455 100 78 157 1 1765618912 11814480 21495488
23:04:32 5094 8192000000 10691439424 11065131008 1747234672 17.579 100 86 172 0 1784958512 13391424 24332416
23:04:44 3715 8192000000 10704300784 11077984256 1761323712 17.695 100 85 171 2 1798604464 13318000 23962752
23:04:55 3981 8192000000 10716634704 11089920000 1768078880 17.751 100 87 174 0 1806568768 13996864 24493024
23:05:07 3854 8192000000 10721118688 11097186304 1779024800 17.841 100 83 166 0 1816102384 13995120 23082464
23:05:17 3580 8192000000 10719375040 11102294016 1786330048 17.902 100 80 158 1 1821574320 12972336 22271936
23:05:28 2384 8192000000 10732923888 11111292928 1794489184 17.969 100 93 186 0 1835974704 14364960 27120560
23:05:37 2043 8192000000 10742220336 11121922048 1803482160 18.042 100 87 174 1 1841306912 12979680 24845072
23:05:46 5019 8192000000 10753394608 11134427136 1807525024 18.076 100 83 164 0 1844170832 13756560 22889248
23:05:57 4768 8192000000 10760273264 11147943936 1816244912 18.147 100 79 156 1 1851200112 13024256 21930944
23:06:09 2032 8192000000 10774292672 11163258880 1836711440 18.314 100 90 177 0 1874810112 13072336 25026336
23:06:17 2091 8192000000 10773438432 11163361280 1839313168 18.335 100 84 169 0 1875544448 12487312 23743968
23:06:26 2065 8192000000 10786316832 11174805504 1848813632 18.412 100 92 182 2 1886944304 12256640 25874032
23:06:34 2341 8192000000 10799655376 11182579712 1852189952 18.440 100 94 188 1 1892380832 13307920 26882960
23:06:43 1615 8192000000 10801343424 11190284288 1856753264 18.477 100 95 191 1 1898514544 14272912 27488368
23:06:50 1167 8192000000 10809078976 11194544128 1861274208 18.514 100 89 179 1 1898391568 12243264 24874096
23:06:58 1522 8192000000 10805890256 11197546496 1869291408 18.579 100 96 191 3 1909050288 12363968 27394912
23:07:06 1005 8192000000 10812878080 11202084864 1866567264 18.556 100 90 180 0 1905873184 13912384 25393536
23:07:13 1704 8192000000 10818572976 11205132288 1868974912 18.576 100 90 179 1 1908817616 14578288 25264416
23:07:21 1309 8192000000 10815739552 11206164480 1873022096 18.609 100 90 185 0 1912048384 14232768 24793520
23:07:29 24676 8192000000 10808270304 11209646080 1874607872 18.622 100 83 166 1 1912106080 13853056 23645152
23:08:00 3645 8192000000 10791129408 11200630784 1869061120 18.577 100 51 102 0 1894024528 10394816 14568592
23:08:10 5766 8192000000 10776678736 11203526656 1871496960 18.596 100 47 93 3 1892246864 8510160 12239744
23:08:25 7177 8192000000 10777357152 11201441792 1871556320 18.597 100 36 74 5 1888733200 7419568 9757312
23:08:39 4675 8192000000 10785172496 11210158080 1873646416 18.614 100 29 58 1 1889274672 7516640 8111616
23:08:52 9886 8192000000 10800190768 11218558976 1879483424 18.661 100 31 62 0 1895221872 6905344 8833104
23:09:13 6620 8192000000 10793734816 11225583616 1880828512 18.672 100 25 50 2 1894966160 7419280 6718368
23:09:25 13691 8192000000 10789566528 11219525632 1881041984 18.674 100 22 44 0 1893730848 6634448 6054416
23:09:47 10058 8192000000 10785152544 11219148800 1883123120 18.690 100 15 29 0 1892965984 5600656 4242208
23:10:03 7516 8192000000 10793047968 11225538560 1882218784 18.683 100 21 42 1 1898779808 10713744 5847280
23:10:19 12354 8192000000 10808791280 11228643328 1895076320 18.787 100 30 59 0 1909409808 4777152 9556336
23:10:40 65801 8192000000 10812996048 11243065344 1889821632 18.744 100 34 68 3 1905212160 5653088 9737440
23:12:01 4209 8192000000 10813880080 11245555712 1895065296 18.787 100 29 56 1 1910011600 7241040 7705264
23:12:14 6896 8192000000 10833327040 11261902848 1899117344 18.819 100 29 58 0 1926601728 19925168 7559216
23:12:27 6199 8192000000 10834066128 11258155008 1901332944 18.837 100 32 64 1 1921635504 11759808 8542752
23:12:39 6277 8192000000 10820969680 11256676352 1907712480 18.888 100 36 73 2 1924869856 6575328 10582048
23:12:53 5000 8192000000 10822008112 11255390208 1906101536 18.875 100 26 52 2 1920209136 5649520 8458080
23:13:07 8776 8192000000 10824472560 11259408384 1906253920 18.877 100 20 40 3 1917803408 5608432 5941056
23:13:24 8776 8192000000 10817689968 11257667584 1907178704 18.884 100 19 38 2 1918161472 6024688 4958080
23:13:39 9153 8192000000 10832293936 11262763008 1907291600 18.885 100 20 40 1 1918135408 5123168 5720640
23:13:58 12953 8192000000 10827953616 11261194240 1907795920 18.889 100 14 29 1 1917358400 5656960 3905520
23:14:17 6266 8192000000 10800870176 11234398208 1870143664 18.585 98 23 46 0 1882612624 5963536 6505424
23:14:33 10974 8192000000 10814578352 11246018560 1882701504 18.687 99 27 55 0 1900074720 9253248 8119968
23:14:54 15287 8192000000 10804207952 11225714688 1845999184 18.390 97 31 61 2 1860924096 5187040 9737872
23:15:18 59107 8192000000 10793638624 11229892608 1849279904 18.416 98 25 50 1 1862103232 5465728 7357600
23:16:25 12213 8192000000 10754397776 11184656384 1771734400 17.781 95 17 34 2 1781948640 5298624 4915616
23:16:43 7088 8192000000 10761092464 11188277248 1819758800 18.176 98 16 32 2 1829727616 5159440 4809376
23:16:57 7912 8192000000 10743489552 11170783232 1787660464 17.913 97 12 24 0 1795988176 5126832 3200880
23:17:12 6310 8192000000 10711911392 11132096512 1724000256 17.386 94 22 45 1 1735178640 5142000 6036384
23:17:29 13006 8192000000 10721190576 11148439552 1785822160 17.897 98 23 46 1 1798104992 5615488 6667344
23:17:52 7983 8192000000 10749474208 11171209216 1772770704 17.790 96 23 46 1 1789001488 10069152 6161632
23:18:06 10614 8192000000 10718073200 11134570496 1731738304 17.450 95 15 28 1 1740478368 5039984 3700080
23:18:29 7067 8192000000 10720929600 11131125760 1742145456 17.536 96 20 41 0 1757150576 9242992 5762128
23:18:46 9279 8192000000 10672628496 11081764864 1707375584 17.247 95 32 64 0 1722070352 4960352 9734416
23:19:01 9349 8192000000 10692784544 11106504704 1739891616 17.518 98 30 62 1 1754671296 5619856 9159824
23:19:17 10690 8192000000 10689499712 11100495872 1694578704 17.140 95 23 46 0 1707534640 5967264 6988672
23:19:34 9274 8192000000 10709197424 11127857152 1790906128 17.939 100 23 45 0 1801983696 4815904 6261664
23:19:54 80205 8192000000 10688711424 11112923136 1742694944 17.541 96 36 72 1 1758766800 5903104 10168752
23:21:21 6914 8192000000 10726802864 11149729792 1813932832 18.128 100 22 43 1 1825567344 4979312 6655200
23:21:38 8435 8192000000 10762229904 11174244352 1838291232 18.327 100 34 68 2 1853931136 5435616 10204288
23:21:54 9054 8192000000 10766165984 11184066560 1842729648 18.363 100 34 68 0 1858935616 5852096 10353872
23:22:10 4339 8192000000 10761613120 11185946624 1845485984 18.385 100 30 60 0 1861538640 6839696 9212960
23:22:21 9253 8192000000 10755797312 11187249152 1847217728 18.400 100 23 46 1 1860263088 6163728 6881632
23:22:39 3124 8192000000 10763031552 11177492480 1831186560 18.269 99 37 74 2 1849759856 8237936 10335360
23:22:50 8823 8192000000 10770824528 11188006912 1845788720 18.388 100 25 50 0 1858520336 5393152 7338464
23:23:05 11554 8192000000 10773789472 11192086528 1849235296 18.416 100 23 46 1 1861732080 5786768 6710016
23:23:24 9656 8192000000 10774679168 11198705664 1856390176 18.474 100 26 49 1 1870201232 6716096 7094960
23:23:40 9202 8192000000 10778863088 11203137536 1859655456 18.500 100 25 50 0 1872983040 5268752 8058832
23:23:59 9592 8192000000 10773306080 11205607424 1863061104 18.528 100 27 54 1 1876973408 5295376 8616928
23:24:16 7608 8192000000 10771903424 11205042176 1862290608 18.522 100 13 26 2 1871208080 5224224 3693248
23:24:34 17564 8192000000 10767416256 11206639616 1866213264 18.554 100 10 20 0 1874939200 5635040 3090896
23:24:57 9902 8192000000 10789929920 11219025920 1874016976 18.617 100 31 64 2 1888542160 5877328 8647856
23:25:20 63146 8192000000 10785392880 11222994944 1874275936 18.619 100 19 38 0 1885675104 5693456 5705712
23:26:29 11404 8192000000 10791273008 11223756800 1878707088 18.655 100 26 52 2 1891827600 6266832 6853680
23:26:47 6611 8192000000 10789226496 11225939968 1880937744 18.673 100 22 44 1 1894069152 6940032 6191376
23:27:00 8963 8192000000 10816109648 11238899712 1890080320 18.746 100 36 72 1 1906486480 6588496 9817664
23:27:20 10756 8192000000 10837859792 11254431744 1902210704 18.844 100 44 88 2 1922669936 8092320 12366912
23:27:38 12043 8192000000 10842076560 11262803968 1911280768 18.917 100 54 108 1 1935914144 8800464 15832912
23:27:58 14709 8192000000 10849689088 11271507968 1919084080 18.980 100 56 110 2 1943398768 9291696 15022992
23:28:21 21869 8192000000 10852170032 11272843264 1922397360 19.006 100 52 102 2 1947339760 10743920 14198480
23:28:50 24135 8192000000 10859856512 11280236544 1923709648 19.017 100 40 80 0 1944621760 9928912 10983200
23:29:25 17537 8192000000 10869838976 11295080448 1936210208 19.117 100 46 92 0 1959927248 10281424 13435616
23:29:54 26264 8192000000 10889315632 11318145024 1949078624 19.219 100 40 79 2 1977273264 16070624 12124016
23:30:28 6651 8192000000 10890612048 11315331072 1945101808 19.187 100 54 108 0 1977290592 16102128 16086656
23:30:43 12246 8192000000 10888480816 11320197120 1953095680 19.251 100 47 94 2 1982210576 15753072 13361824
23:31:04 46450 8192000000 10907137536 11340922880 1966598368 19.358 100 51 102 1 2003190864 21256736 15335760
23:32:08 11823 8192000000 10888583072 11315851264 1930084560 19.068 98 46 91 1 1965352304 21594240 13673504
23:32:28 11284 8192000000 10910780448 11338215424 1960625104 19.311 100 59 117 0 2000865024 23553664 16686256
23:32:47 8434 8192000000 10915246896 11341254656 1965703696 19.351 100 55 109 2 2005163648 24073216 15386736
23:33:08 21490 8192000000 10926920480 11356319744 1973322368 19.412 100 50 100 1 2012940784 25165152 14453264
23:33:39 12198 8192000000 10927615008 11356655616 1973964560 19.417 100 48 96 0 2017504752 28953888 14586304
23:33:58 9238 8192000000 10929443152 11357691904 1960457456 19.310 99 47 94 1 2004688048 30180544 14050048
23:34:21 1637 8192000000 10926725552 11339780096 1965122496 19.347 100 82 164 2 2022451152 32505360 24823296
23:34:29 4649 8192000000 10937723200 11356188672 1970467248 19.389 100 64 126 0 2022948640 33574496 18906896
23:34:43 6754 8192000000 10938418496 11364986880 1976421424 19.436 100 70 140 1 2033696000 36744752 20529824
23:34:59 2834 8192000000 10934140880 11361882112 1978697936 19.454 100 58 115 0 2027422320 31791904 16932480
23:35:21 9461 8192000000 10947489552 11380576256 1987737568 19.526 100 63 126 3 2046501120 39614000 19149552
23:35:42 3868 8192000000 10939612144 11371499520 1982946528 19.488 100 51 101 2 2036814144 37918416 15949200
23:35:54 14287 8192000000 10950995472 11379601408 1985825184 19.511 100 59 118 0 2037045184 33732528 17487472
23:36:17 4259 8192000000 10962825440 11383123968 1994074816 19.576 100 78 154 1 2051613280 35325552 22212912
23:36:31 10515 8192000000 10961754976 11377696768 1974010112 19.417 99 64 126 0 2028307632 35495664 18801856
23:36:50 2123 8192000000 10971322272 11393232896 1997131696 19.600 100 68 135 1 2054939440 38167008 19640736
23:37:00 2484 8192000000 10971991408 11389759488 1996045920 19.592 100 75 150 2 2057271104 38491232 22733952
23:37:10 1941 8192000000 10975214928 11383205888 1989514656 19.540 100 90 175 3 2055414976 39487872 26412448
23:37:20 6900 8192000000 10962620064 11378565120 1979989152 19.465 100 85 170 0 2047401872 41993024 25419696
23:37:36 3947 8192000000 10962252976 11384758272 1987894896 19.527 100 73 139 1 2051028256 41655568 21477792
23:37:49 4982 8192000000 10970472192 11393740800 1989909904 19.543 100 58 116 2 2050917296 43141760 17865632
23:38:05 3591 8192000000 10963876128 11390345216 1990836208 19.550 100 67 130 2 2056743984 45818720 20089056
23:38:17 4594 8192000000 10979064832 11398696960 1994191200 19.577 100 69 136 0 2061565248 46381520 20992528
23:38:28 1969 8192000000 10985124944 11394654208 1988494272 19.532 100 77 155 0 2058319632 45573360 24252000
23:38:38 3431 8192000000 10966881216 11381723136 1966702992 19.359 99 83 166 0 2042509680 49949584 25857104
23:38:48 2556 8192000000 10978527616 11391807488 1983268048 19.491 100 84 168 1 2061911664 53056544 25587072
23:38:58 1312 8192000000 10968317824 11373617152 1963858112 19.337 99 84 168 0 2044115248 53969088 26288048
23:39:09 1592 8192000000 10944737296 11355025408 1951398048 19.238 99 77 154 1 2029712512 54124240 24190224
23:39:17 1788 8192000000 10968222000 11375828992 1972548080 19.406 100 83 165 0 2050736368 53011792 25176496
23:39:26 3366 8192000000 10963631152 11374809088 1967613216 19.367 100 74 146 0 2047058208 57376352 22068640
23:39:36 11861 8192000000 10964832992 11385085952 1975528464 19.429 100 73 146 1 2052193344 54042832 22622048
23:39:55 4878 8192000000 10945137200 11367669760 1944332176 19.181 99 61 122 0 2020184928 56413952 19438800
23:40:08 3377 8192000000 10961432048 11384856576 1967230000 19.363 100 70 136 0 2046150880 56665840 22255040
23:40:20 4427 8192000000 10952750464 11369811968 1940621472 19.152 99 65 127 1 2018136848 57044720 20470656
23:40:36 8761 8192000000 10933836592 11356659712 1915020224 18.947 98 59 118 1 1992756032 59270880 18464928
23:40:53 3852 8192000000 10951009568 11369435136 1950638752 19.232 100 65 127 0 2031049232 60283168 20127312
23:41:04 6438 8192000000 10938826912 11360567296 1927958608 19.051 99 61 122 4 2011014288 62630768 20424912
23:41:20 1948 8192000000 10945878688 11355025408 1932049664 19.083 99 63 124 1 2005465632 53673600 19742368
23:41:29 15703 8192000000 10941179536 11357863936 1939090816 19.140 99 71 143 2 2015412528 54480496 21841216
23:41:53 12397 8192000000 10929620176 11351433216 1894910592 18.785 97 56 112 2 1972273216 58898912 18463712
23:42:15 11630 8192000000 10936121312 11351728128 1919353632 18.982 99 58 116 0 1994136736 56262512 18520592
23:42:34 5487 8192000000 10935511088 11354660864 1927724320 19.049 99 58 112 0 2002230576 56947824 17558432
23:42:46 2125 8192000000 10932919312 11344957440 1904129632 18.859 98 81 160 3 1987190480 58655408 24405440
23:42:55 2313 8192000000 10945177488 11352006656 1925036960 19.027 99 88 178 1 2013547312 60734448 27775904
23:43:04 3436 8192000000 10957938896 11366563840 1951469792 19.238 100 84 163 3 2039576912 61500896 26606224
23:43:14 4310 8192000000 10975605504 11386884096 1959680272 19.303 100 83 166 2 2050239632 64281344 26278016
23:43:30 4039 8192000000 10988241920 11400384512 1973197584 19.411 100 77 153 1 2065426032 67375552 24852896
23:43:41 2513 8192000000 10952193424 11363659776 1950146208 19.228 99 76 153 2 2030822800 56316080 24360512
23:43:51 2648 8192000000 10984106848 11391287296 1972241840 19.403 100 87 174 0 2060922672 61716384 26964448
23:44:01 3919 8192000000 10969854544 11379675136 1954786992 19.265 99 81 162 0 2042073360 60514928 26771440
23:44:12 2488 8192000000 10974306992 11379703808 1963725536 19.336 100 84 168 2 2051242960 60924800 26592624
23:44:22 3671 8192000000 10956800976 11369213952 1935947936 19.114 99 69 139 1 2019836816 61616176 22272704
23:44:41 12513 8192000000 10936641392 11377160192 1955049488 19.267 100 44 87 0 2029562368 59920976 14591904
23:45:02 15954 8192000000 10943791376 11377545216 1961957760 19.322 100 39 79 1 2031069200 55750128 13361312
23:45:24 13732 8192000000 10954209536 11392778240 1970192896 19.387 100 40 80 1 2039911520 56187424 13531200
23:45:59 16121 8192000000 10965961120 11400511488 1975338528 19.428 100 37 74 1 2043053184 55297392 12417264
23:46:28 11659 8192000000 10956629056 11394756608 1971188432 19.395 100 32 64 2 2038625328 56333664 11103232
23:46:50 21709 8192000000 10965247776 11399487488 1978179920 19.450 100 32 64 0 2045366272 56128640 11057712
23:47:28 21876 8192000000 10965419584 11415523328 1976590304 19.438 100 32 64 1 2049689168 61784160 11314704
23:48:17 13797 8192000000 10948395056 11417862144 1959436064 19.302 100 22 44 0 2034053312 66310672 8306576
23:48:42 19779 8192000000 10944548176 11401691136 1958049952 19.291 100 22 44 0 2018482288 52550544 7881792
23:49:14 20309 8192000000 10923518448 11401924608 1955733744 19.272 100 21 42 1 2023877760 60238496 7905520
23:50:05 47317 8192000000 10906384256 11379052544 1929806432 19.065 99 12 24 1 1979278928 45116224 4356272
23:50:59 46800 8192000000 10839354512 11303686144 1826450592 18.230 94 4 8 0 1845819248 18322672 1045984
23:51:53 96379 8192000000 10836432624 11277029376 1793889760 17.964 93 10 20 0 1811991456 15725680 2376016
23:53:43 149967 8192000000 10858774256 11320664064 1930629088 19.072 100 35 70 0 1952115008 12153616 9332304
23:56:19 36284 8192000000 10878475008 11329482752 1946545808 19.199 100 35 70 4 1964196128 8044096 9606224
23:57:02 94097 8192000000 10905899568 11346767872 1907328720 18.885 97 14 27 0 1923429824 12299872 3801232
23:58:59 67674 8192000000 10897412400 11360169984 1962688208 19.327 100 18 36 0 1986809536 19192656 4928672
00:00:57 21654 8192000000 10914381984 11356258304 1952562272 19.247 99 32 64 0 1978514624 16358896 9593456
00:01:28 29521 8192000000 10915865776 11366912000 1980515664 19.469 100 36 69 3 2005822032 14924384 10381984
00:02:27 191097 8192000000 10911338240 11372498944 1978113488 19.450 99 22 44 0 2003727120 19044704 6568928
00:05:45 98711 8192000000 10913734400 11384328192 1993397616 19.571 100 14 28 0 2015218384 17599056 4221712
00:07:30 51305 8192000000 10934412096 11394093056 1994900880 19.583 100 15 30 0 2009184176 10383344 3899952
00:08:28 64044 8192000000 10928704976 11398082560 2001181136 19.632 100 24 48 4 2019395536 11311536 6902864
00:09:40 66077 8192000000 10895829792 11378319360 1939760304 19.145 97 13 26 0 1954826272 11577088 3488880
00:10:58 34079 8192000000 10929014192 11374727168 1977299184 19.443 99 59 116 3 2005319456 10911216 17109056
00:11:39 52086 8192000000 10912450768 11383418880 1982466304 19.484 100 22 44 0 2000130528 11541392 6122832
00:12:53 80568 8192000000 10900545936 11366199296 1908183760 18.892 96 17 34 0 1924962176 11484976 5293440
00:14:23 75624 8192000000 10877658768 11346878464 1883496416 18.693 95 16 32 0 1899307472 11495840 4315216
00:15:46 25085 8192000000 10911310576 11358265344 1956546656 19.279 99 27 54 0 1973855872 9176832 8132384
00:16:17 52901 8192000000 10912726256 11356057600 1920395936 18.990 97 26 52 2 1936302864 8703760 7203168
00:17:25 11934 8192000000 10929563440 11376730112 1966330016 19.356 99 36 72 1 1985610304 9319440 9960848
00:17:44 42241 8192000000 10898783200 11365244928 1919745152 18.985 97 26 52 1 1937530656 10784368 7001136
00:18:33 48329 8192000000 10884532384 11340759040 1908745728 18.897 97 18 36 1 1924443616 9568432 6129456
00:19:32 97551 8192000000 10860050416 11317354496 1895390448 18.789 96 22 44 2 1910742496 9172816 6179232
00:21:30 38629 8192000000 10868811296 11327832064 1872715728 18.606 95 29 58 1 1888183744 7798304 7669712
00:22:15 56289 8192000000 10885304992 11345661952 1923765632 19.017 98 32 64 0 1945020320 12188368 9066320
00:23:23 18245 8192000000 10866741808 11321556992 1899143568 18.819 97 31 63 1 1918163952 10241616 8778768
00:23:48 34020 8192000000 10870211824 11330400256 1909824656 18.905 98 34 68 1 1935112384 15234816 10052912
00:25:39 54885 8192000000 10873145216 11355410432 1934375792 19.102 99 14 27 1 1955263680 17117648 3770240
00:26:54 102644 8192000000 10852516880 11336331264 1894475680 18.782 97 21 42 1 1917882128 17173376 6233072
00:28:52 50849 8192000000 10860481408 11315585024 1883197824 18.691 97 10 20 0 1895283008 9132032 2953152
00:29:51 30483 8192000000 10857326656 11315191808 1921742032 19.001 99 33 64 1 1940393120 10106400 8544688
00:30:27 44675 8192000000 10845193408 11311804416 1900872736 18.833 99 15 30 1 1916395360 11707536 3815088
00:31:18 80275 8192000000 10868514080 11328278528 1817454160 18.157 93 21 42 0 1841420432 17426448 6539824
00:33:29 47499 8192000000 10879319744 11333623808 1890219712 18.748 97 16 32 2 1903453600 8680064 4553824
00:34:25 38872 8192000000 10889255552 11327184896 1895774896 18.792 97 49 99 0 1920291664 11653616 12863152
00:35:12 28046 8192000000 10864665424 11326537728 1900894272 18.833 98 34 68 5 1925134400 14850656 9389472
00:35:48 29476 8192000000 10864523760 11307196416 1884431152 18.701 98 33 65 2 1904916112 11505152 8979808
00:36:28 22239 8192000000 10878173968 11323871232 1915784512 18.953 99 33 64 2 1934304528 9887440 8632576
00:36:58 54361 8192000000 10885994224 11344490496 1925292704 19.029 99 35 70 0 1950168992 15098528 9777760
00:38:05 108319 8192000000 10875004944 11338162176 1875132416 18.626 96 24 48 0 1898924848 16997440 6794992
00:40:05 63425 8192000000 10884029616 11348221952 1949376496 19.222 100 26 52 0 1967613872 11083056 7154320
00:41:28 110292 8192000000 10907505984 11371929600 1949638112 19.224 99 17 34 1 1970292160 15660528 4993520
00:43:26 122786 8192000000 10905674240 11371753472 1967755920 19.368 100 21 42 0 1990656624 16806336 6094368
00:45:37 52671 8192000000 10909098640 11373326336 1977044624 19.441 100 17 34 0 1995595008 13664640 4885744
00:46:37 47328 8192000000 10896192080 11376394240 1978558144 19.453 100 21 42 1 1996316112 11589744 6168224
00:47:30 70822 8192000000 10884260800 11366477824 1923936544 19.018 97 17 34 1 1943147936 13530592 5680800
00:48:47 84051 8192000000 10901229952 11374989312 1932627728 19.088 98 10 20 0 1948494320 12938832 2927760
00:50:28 61625 8192000000 10866982352 11346673664 1928812512 19.057 98 15 30 2 1951083968 17304896 4966560
00:51:48 54161 8192000000 10896715824 11376087040 1962209440 19.324 100 14 28 0 1980200320 14234960 3755920
00:52:54 76608 8192000000 10900857968 11379499008 1970859712 19.392 100 10 20 0 1986992096 13685024 2447360
00:54:40 85325 8192000000 10910955968 11372359680 1934487632 19.103 98 11 22 1 1949703056 11741408 3474016
00:56:12 65896 8192000000 10902565360 11375988736 1941885408 19.162 98 20 40 0 1961664560 13725168 6053984
00:57:34 27990 8192000000 10912366480 11384098816 1986519904 19.516 100 48 96 2 2008945232 8628288 13797040
00:58:08 67943 8192000000 10930182752 11404713984 2001723424 19.636 100 21 42 0 2019436544 11703456 6009664
00:59:22 53410 8192000000 10918407616 11391393792 1959469728 19.302 98 20 39 3 1974525296 9299856 5755712
01:00:32 73219 8192000000 10911414832 11387711488 1943876528 19.178 98 20 40 0 1968084816 19094352 5113936
01:01:52 83494 8192000000 10919454560 11377299456 1916529792 18.959 97 8 16 0 1934127936 15692448 1905696
01:03:26 16631 8192000000 10918752752 11364315136 1923713072 19.017 97 50 100 0 1950681728 13150480 13818176
01:03:51 38211 8192000000 10914515328 11375616000 1934938032 19.106 98 38 76 1 1964687376 19355296 10394048
01:04:44 44957 8192000000 10896518064 11384602624 1960725824 19.312 100 12 24 1 1987314288 23439648 3148816
01:05:37 94972 8192000000 10895596160 11358523392 1917008560 18.963 97 14 28 1 1932908384 12066608 3833216
01:07:19 69441 8192000000 10854203856 11319083008 1857912528 18.486 95 19 38 0 1874783920 11792992 5078400
01:08:52 135631 8192000000 10852666192 11321954304 1844418944 18.377 95 19 36 1 1861434896 11569648 5446304
01:12:07 86151 8192000000 10831438928 11299631104 1852221344 18.440 96 11 22 0 1866022160 10942704 2858112
01:13:46 65874 8192000000 10835710304 11308847104 1881904352 18.680 98 8 17 1 1895999056 11945088 2149616
01:15:00 75614 8192000000 10814735632 11290816512 1821313104 18.188 95 21 42 1 1839963008 12774192 5875712
01:16:22 44842 8192000000 10826524112 11306524672 1913553104 18.935 100 18 36 2 1930982224 11715456 5713664
01:17:17 50411 8192000000 10859802656 11326062592 1921646272 19.000 100 10 20 1 1932562880 8211920 2704688
01:18:32 38652 8192000000 10855627680 11329142784 1918938880 18.978 99 15 30 1 1935963648 12338112 4686656
01:19:34 57861 8192000000 10833604256 11311595520 1907255728 18.885 99 8 16 0 1919491312 9554944 2680640
01:20:47 65577 8192000000 10827645696 11296595968 1847802752 18.404 96 10 19 0 1858387392 8061520 2523120
01:22:06 22345 8192000000 10828381200 11283468288 1853038112 18.447 97 30 57 0 1867740992 6875632 7827248
01:22:38 35137 8192000000 10847174944 11287089152 1862878928 18.527 98 28 56 1 1879513920 8657104 7977888
01:23:21 18755 8192000000 10836980448 11289649152 1903451280 18.854 100 37 75 1 1924628464 10565152 10612032
01:23:47 20495 8192000000 10831700672 11265986560 1854087408 18.455 97 40 80 0 1874475728 9310960 11077360
01:24:14 24477 8192000000 10837857072 11282935808 1883146848 18.691 99 34 68 0 1903361344 10782928 9431568
01:24:45 36380 8192000000 10831359488 11286224896 1831907600 18.275 96 35 70 0 1856374448 14543920 9922928
01:25:28 57744 8192000000 10848547744 11305435136 1910094480 18.907 100 25 50 1 1932765232 15575472 7095280
01:26:44 28399 8192000000 9194923344 9442267136 354528896 4.148 19 11 19 1 361932976 4365536 3038544

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 17-12-2020 01:28:12 to 17-12-2020 01:28:43.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 132 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 17-12-2020 01:28:44 to 17-12-2020 01:28:46.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          254867
MON$OLDEST_ACTIVE               254868
MON$OLDEST_SNAPSHOT             254868
MON$NEXT_TRANSACTION            254868
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       2039840
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33400 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33400 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33400 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33400 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

Final processing ISQL logs in /var/tmp/logs-oltp30 according to config parameter 'remove_isql_logs'

17.12.20 01:28:47. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2020-12-17 01:28:49 No severe PSQL-related problems occured
17.12.20 01:28:50. End of report.