Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 06.04.2021 22:28
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 df9f488d08424df294c459d6c283e9c3
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 2021-03-04 16:07
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.26
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 17133100 kB
MemAvailable 31396468 kB
Buffers 0 kB
Cached 14493068 kB
SwapCached 100 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 2021-04-06 22:27:28
DTS_END                         2021-04-06 22:27:28.1350
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_ADDING_INVOICE(33:5) ==> SP_ADD_INVOICE_TO_STOCK(139:30) ==> SP_CANCEL_WRITE_OFF(41:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/39644
TRN_ID                          247507
ATT_ID                          708
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: 9262.60 23851 1111512
customer order: creation 181.62 323 21794
customer order: refuse 15.37 340 1844
order to supplier: creation 49.73 1343 5968
order to supplier: removal 3.53 104430 424
invoice (draft): creation 47.79 3226 5735
invoice (draft): removal 52.35 862 6282
invoice accept: apply 42.60 17127 5112
invoice accept: cancel 47.13 821 5656
customer reserve: creation 3877.01 172 465241
customer reserve: removal 4633.88 62 556066
realization accept: apply 89.24 170 10709
realization accept: cancel 86.20 103 10344
payment from customer: creation 63.84 122 7661
payment from customer: removal 6.18 79 741
payment to supplier: creation 49.79 139 5975
payment to supplier: removal 3.48 102 418
service: total inventory turnovers 5.13 918 615
service: total monetary turnovers 6.88 40 826
service: aggregate perf. data 0.81 23001 97
service: refresh index statistics 0.03 323645 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 06-04-2021 22:28:37 to 06-04-2021 22:28:40.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2260
TEST_TIME 2 2995
TEST_TIME 3 3451
TEST_TIME 4 4578
TEST_TIME 5 5162
TEST_TIME 6 5471
TEST_TIME 7 5711
TEST_TIME 8 5955
TEST_TIME 9 6224
TEST_TIME 10 6295
TEST_TIME 11 6682
TEST_TIME 12 6632
TEST_TIME 13 6976
TEST_TIME 14 6998
TEST_TIME 15 7250
TEST_TIME 16 7272
TEST_TIME 17 7391
TEST_TIME 18 7641
TEST_TIME 19 7769
TEST_TIME 20 8044
TEST_TIME 21 7975
TEST_TIME 22 8149
TEST_TIME 23 8343
TEST_TIME 24 8534
TEST_TIME 25 8486
TEST_TIME 26 8605
TEST_TIME 27 8717
TEST_TIME 28 9319
TEST_TIME 29 10320
TEST_TIME 30 11089
TEST_TIME 31 10785
TEST_TIME 32 10816
TEST_TIME 33 10766
TEST_TIME 34 10694
TEST_TIME 35 10585
TEST_TIME 36 10461
TEST_TIME 37 10363
TEST_TIME 38 10274
TEST_TIME 39 10141
TEST_TIME 40 10049
TEST_TIME 41 9897
TEST_TIME 42 10124
TEST_TIME 43 10066
TEST_TIME 44 9944
TEST_TIME 45 10041
TEST_TIME 46 10104
TEST_TIME 47 10048
TEST_TIME 48 10018
TEST_TIME 49 9958
TEST_TIME 50 10072
TEST_TIME 51 10185
TEST_TIME 52 10207
TEST_TIME 53 10047
TEST_TIME 54 9931
TEST_TIME 55 9939
TEST_TIME 56 9846
TEST_TIME 57 9799
TEST_TIME 58 9776
TEST_TIME 59 9799
TEST_TIME 60 9739
TEST_TIME 61 9676
TEST_TIME 62 9590
TEST_TIME 63 9568
TEST_TIME 64 9583
TEST_TIME 65 9500
TEST_TIME 66 9558
TEST_TIME 67 9591
TEST_TIME 68 9578
TEST_TIME 69 9542
TEST_TIME 70 9599
TEST_TIME 71 9639
TEST_TIME 72 9646
TEST_TIME 73 9571
TEST_TIME 74 9607
TEST_TIME 75 9668
TEST_TIME 76 9703
TEST_TIME 77 9712
TEST_TIME 78 9692
TEST_TIME 79 9782
TEST_TIME 80 9767
TEST_TIME 81 9658
TEST_TIME 82 9654
TEST_TIME 83 9565
TEST_TIME 84 9552
TEST_TIME 85 9575
TEST_TIME 86 9533
TEST_TIME 87 9477
TEST_TIME 88 9429
TEST_TIME 89 9473
TEST_TIME 90 9405
TEST_TIME 91 9370
TEST_TIME 92 9391
TEST_TIME 93 9392
TEST_TIME 94 9379
TEST_TIME 95 9416
TEST_TIME 96 9376
TEST_TIME 97 9446
TEST_TIME 98 9424
TEST_TIME 99 9427
TEST_TIME 100 9422
TEST_TIME 101 9462
TEST_TIME 102 9457
TEST_TIME 103 9454
TEST_TIME 104 9516
TEST_TIME 105 9520
TEST_TIME 106 9581
TEST_TIME 107 9542
TEST_TIME 108 9465
TEST_TIME 109 9481
TEST_TIME 110 9431
TEST_TIME 111 9413
TEST_TIME 112 9386
TEST_TIME 113 9386
TEST_TIME 114 9373
TEST_TIME 115 9319
TEST_TIME 116 9309
TEST_TIME 117 9284
TEST_TIME 118 9269
TEST_TIME 119 9297
TEST_TIME 120 9263

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 06-04-2021 22:28:41 to 06-04-2021 22:28:45.

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 1543928 1543928 0 0.00 0 28582 6 0 0
doc_list_biud 1543928 1543928 0 0.00 0 56597 28 0 0
sp_add_invoice_to_stock 5306 5112 194 3.65 36 174852 17127 0 194
sp_cancel_adding_invoice 5656 5656 0 0.00 5 73382 822 0 0
sp_cancel_client_order 1844 1844 0 0.00 4 16423 341 0 0
sp_cancel_customer_reserve 556066 556066 0 0.00 1 34729 62 0 0
sp_cancel_pay_from_customer 741 741 0 0.00 3 4631 79 0 0
sp_cancel_pay_to_supplier 418 418 0 0.00 2 5781 102 0 0
sp_cancel_supplier_invoice 6297 6282 15 0.23 2 56662 863 0 15
sp_cancel_supplier_order 424 424 0 0.00 6 1123171 104431 0 0
sp_cancel_write_off 10344 10344 0 0.00 1 12655 104 0 0
sp_client_order 21794 21794 0 0.00 3 16437 323 0 0
sp_customer_reserve 465241 465241 0 0.00 0 91344 172 0 0
sp_fill_shopping_cart 33479 33479 0 0.00 1 13836 40 0 0
sp_fill_shopping_cart_clo_res 465237 465237 0 0.00 0 19459 12 0 0
sp_get_clo_for_invoice 5101 5101 0 0.00 0 19737 277 0 0
sp_kill_cost_storno 17159 17159 0 0.00 0 10872 60 0 0
sp_kill_qstorno_ret_qs2qd 1129182 1129182 0 0.00 0 56596 34 0 0
sp_kill_qty_storno 596426 596426 0 0.00 0 56596 72 0 0
sp_lock_selected_doc 21825 21825 0 0.00 0 7825 5 0 0
sp_make_cost_storno 29446 29446 0 0.00 0 28577 52 0 0
sp_multiply_rows_for_pdistr 29446 29446 0 0.00 0 7192 28 0 0
sp_multiply_rows_for_qdistr 21794 21794 0 0.00 0 16280 127 0 0
sp_pay_from_customer 7661 7661 0 0.00 4 24070 123 0 0
sp_pay_to_supplier 5975 5975 0 0.00 5 24175 140 0 0
sp_payment_common 13636 13636 0 0.00 1 24037 42 0 0
sp_qd_handle_on_cancel_clo 1844 1844 0 0.00 0 16407 309 0 0
sp_qd_handle_on_invoice_upd_sts 10757 10757 0 0.00 0 38871 331 0 0
sp_qd_handle_on_reserve_upd_sts 10709 10709 0 0.00 0 20047 48 0 0
sp_reserve_write_off 10709 10709 0 0.00 6 20179 170 0 0
sp_supplier_invoice 5735 5735 0 0.00 6 96492 3226 0 0
sp_supplier_order 5968 5968 0 0.00 4 25454 1344 0 0
srv_aggregate_perf_data 97 97 0 0.00 3240 511930 23001 0 0
srv_fill_mon_cache_memory 167 167 0 0.00 1391 147157 31431 0 0
srv_find_qd_qs_mism 1062790 1062790 0 0.00 0 13837 5 0 0
srv_make_invnt_saldo 615 615 0 0.00 39 46428 918 0 0
srv_make_money_saldo 826 826 0 0.00 1 13365 40 0 0
srv_recalc_idx_stat 4 4 0 0.00 211566 469861 323646 0 0
t$perf-abend:sp_add_invoice_to_stock 194 194 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5112 5112 0 0.00 0 11629 154 0 0
t$perf-norm:sp_cancel_adding_invoice 428 428 0 0.00 0 14381 113 0 0
t$perf-norm:sp_cancel_client_order 1844 1844 0 0.00 0 22355 27 0 0
t$perf-norm:sp_cancel_customer_reserve 708 708 0 0.00 0 12996 25 0 0
t$perf-norm:sp_cancel_pay_from_customer 741 741 0 0.00 0 2740 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 418 418 0 0.00 0 410 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 414 414 0 0.00 0 1822 23 0 0
t$perf-norm:sp_cancel_supplier_order 424 424 0 0.00 0 19877 1709 0 0
t$perf-norm:sp_cancel_write_off 1038 1038 0 0.00 0 2365 7 0 0
t$perf-norm:sp_client_order 21794 21794 0 0.00 0 14211 18 0 0
t$perf-norm:sp_customer_reserve 1053 1053 0 0.00 0 1756 6 0 0
t$perf-norm:sp_pay_from_customer 7661 7661 0 0.00 0 14007 15 0 0
t$perf-norm:sp_pay_to_supplier 5975 5975 0 0.00 0 11577 15 0 0
t$perf-norm:sp_reserve_write_off 10709 10709 0 0.00 0 19295 14 0 0
t$perf-norm:sp_supplier_invoice 5735 5735 0 0.00 0 8221 17 0 0
t$perf-norm:sp_supplier_order 5968 5968 0 0.00 0 13126 18 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 112 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 498 8 0 0
t$perf-norm:srv_make_invnt_saldo 615 615 0 0.00 0 811 28 0 0
t$perf-norm:srv_make_money_saldo 826 826 0 0.00 0 12893 28 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 16 6 0 0
v_add_invoice_to_stock 10590 10202 388 3.66 0 9253 20 0 388
v_all_customers 39918 39918 0 0.00 0 29 1 0 0
v_all_suppliers 31966 31966 0 0.00 0 27 1 0 0
v_all_wares 43584 43584 0 0.00 0 117 1 0 0
v_cancel_adding_invoice 856 856 0 0.00 0 3929 16 0 0
v_cancel_client_order 3688 3688 0 0.00 0 4655 8 0 0
v_cancel_customer_prepayment 1482 1482 0 0.00 0 4617 9 0 0
v_cancel_customer_reserve 1416 1416 0 0.00 0 878 3 0 0
v_cancel_payment_to_supplier 836 836 0 0.00 0 3108 12 0 0
v_cancel_supplier_invoice 858 828 30 3.49 0 306 15 0 30
v_cancel_supplier_order 848 848 0 0.00 0 199 3 0 0
v_cancel_write_off 2076 2076 0 0.00 0 3982 17 0 0
v_max_id_clo_ord 5968 5968 0 0.00 0 140 1 0 0
v_max_id_clo_res 1053 1053 0 0.00 0 1994 12 0 0
v_max_id_ord_sup 5719 5719 0 0.00 0 3892 5 0 0
v_max_non_paid_invoice 1679 1679 0 0.00 0 6985 12 0 0
v_max_non_paid_realizn 4044 4044 0 0.00 0 1994 4 0 0
v_min_id_clo_ord 5968 5968 0 0.00 0 4440 5 0 0
v_min_id_clo_res 1053 1053 0 0.00 0 4635 7 0 0
v_min_id_ord_sup 5719 5719 0 0.00 0 6940 7 0 0
v_min_non_paid_invoice 5975 5975 0 0.00 0 23975 28 0 0
v_min_non_paid_realizn 7661 7661 0 0.00 0 14287 26 0 0
v_our_firm 10900 10900 0 0.00 0 16 1 0 0
v_reserve_write_off 21418 21418 0 0.00 0 10019 9 0 0
x_lock_depdocs_on_canc_invoice 11524 11524 0 0.00 0 26454 134 0 0
x_lock_depdocs_on_canc_sup_ord 424 424 0 0.00 0 7359 366 0 0
x_make_qstorno_1000_1200 5968 5968 0 0.00 1 25447 1263 0 0
x_make_qstorno_1200_2000 5735 5735 0 0.00 3 96477 3080 0 0
x_make_qstorno_2100_3300 465241 465241 0 0.00 0 91341 157 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-04-2021 22:28:46 to 06-04-2021 22:28:50.

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
19:57:31 3 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:38 18183 8192000000 10240920912 10543575040 869647488 9.597 68 49 97 0 887309664 2274448 15387728
19:58:02 35819 8192000000 10345426816 10657456128 1391345616 14.518 100 87 174 0 1424858480 4796208 28716656
19:58:50 27359 8192000000 10373875552 10695155712 1424753552 14.815 100 84 168 0 1459971456 6678064 28539840
19:59:29 22565 8192000000 10400793760 10727100416 1454786400 15.080 100 90 180 0 1491916752 7153664 29976688
20:00:04 24882 8192000000 10432434768 10762092544 1478521504 15.288 100 81 162 0 1513052768 7940448 26590816
20:00:38 16143 8192000000 10443833920 10776682496 1500418928 15.480 100 85 170 0 1536381168 8528848 27433392
20:01:06 23698 8192000000 10475275952 10811383808 1525113344 15.695 100 90 180 0 1563000784 9299520 28587920
20:01:39 9391 8192000000 10482878080 10823487488 1539034080 15.815 100 82 164 1 1574031984 9725344 25272560
20:02:03 15155 8192000000 10498664272 10849492992 1556233920 15.964 100 73 146 1 1588231648 9952800 22044928
20:02:29 18039 8192000000 10524823472 10878353408 1587628624 16.234 100 78 156 1 1621614688 10347584 23638480
20:02:56 14280 8192000000 10568666384 10926268416 1616808992 16.483 100 74 148 1 1649089952 10384192 21896768
20:03:23 13077 8192000000 10591701040 10958168064 1646077168 16.731 100 79 158 0 1685026016 15532544 23416304
20:03:50 11277 8192000000 10608120304 10972266496 1677868880 16.999 100 81 163 1 1714117584 12549952 23698752
20:04:12 8484 8192000000 10643256976 11008049152 1694815808 17.142 100 86 172 0 1732892176 12894848 25181520
20:04:27 11152 8192000000 10644238656 11016667136 1708313504 17.255 100 81 162 2 1744617920 12944256 23360160
20:04:48 7379 8192000000 10664189344 11036041216 1726918128 17.410 100 83 166 0 1763021440 12390880 23712432
20:05:03 6433 8192000000 10676943712 11048767488 1733788944 17.467 100 77 152 1 1768582368 12369184 22424240
20:05:18 7149 8192000000 10678811408 11060809728 1743457120 17.547 100 71 141 1 1776064512 11293872 21313520
20:05:32 5787 8192000000 10692606848 11071643648 1761520416 17.697 100 82 159 2 1795631280 11471408 22639456
20:05:47 6066 8192000000 10707170832 11083722752 1770532928 17.771 100 91 182 1 1809155376 12866320 25756128
20:06:00 6400 8192000000 10715410656 11093716992 1779473872 17.845 100 83 163 1 1815519760 13590000 22455888
20:06:14 3532 8192000000 10725953008 11103199232 1785748672 17.897 100 84 168 0 1822797552 13129232 23919648
20:06:25 3737 8192000000 10736208848 11112988672 1793873024 17.964 100 92 182 0 1833598064 14538480 25186560
20:06:36 3392 8192000000 10739619088 11119366144 1799985440 18.014 100 92 183 0 1840073552 15167968 24920144
20:06:46 3013 8192000000 10746902288 11128340480 1802266048 18.033 100 88 174 0 1841349376 14825568 24257760
20:06:56 3277 8192000000 10751385824 11133046784 1806396048 18.066 100 85 170 0 1844352416 14395024 23561344
20:07:05 3195 8192000000 10748711728 11130925056 1812203840 18.114 100 92 186 2 1851316704 14115088 24997776
20:07:21 3031 8192000000 10748574064 11135066112 1811200128 18.106 100 84 166 1 1848804128 14111792 23492208
20:07:33 2707 8192000000 10773550928 11157221376 1828651200 18.248 100 91 183 2 1868026512 13901984 25473328
20:07:42 2098 8192000000 10776024064 11161071616 1832286240 18.278 100 85 170 2 1869694048 12711408 24696400
20:07:51 2208 8192000000 10790077088 11172884480 1839169680 18.334 100 91 182 1 1878934816 13837712 25927424
20:07:59 2409 8192000000 10785290272 11173470208 1840200112 18.342 100 86 172 0 1878975904 14687136 24088656
20:08:08 2240 8192000000 10799832496 11183120384 1855228800 18.465 100 88 176 0 1893416416 13684288 24503328
20:08:17 1913 8192000000 10801802912 11190505472 1857757680 18.485 100 84 170 1 1894519760 13422928 23339152
20:08:25 1831 8192000000 10803026816 11193245696 1860778720 18.510 100 96 191 1 1900888288 13568640 26540928
20:08:33 1462 8192000000 10808462560 11197468672 1864444400 18.539 100 94 188 0 1904450960 13352400 26654160
20:08:41 2045 8192000000 10811441248 11199680512 1864706384 18.541 100 97 193 1 1906422512 13837728 27878400
20:08:50 2450 8192000000 10801364832 11193896960 1867626144 18.565 100 92 184 1 1907106864 12192160 27288560
20:08:58 1423 8192000000 10818956992 11202977792 1868662304 18.573 100 92 184 3 1907689952 13345712 25681936
20:09:06 12047 8192000000 10780420272 11198922752 1864986960 18.544 100 62 124 1 1894596128 11785088 17824080
20:09:36 16354 8192000000 10771209008 11195981824 1866199808 18.554 100 29 58 0 1880400560 6704416 7496336
20:09:59 6885 8192000000 10774996496 11202256896 1868228976 18.570 100 24 48 4 1882445520 7102704 7113840
20:10:17 3480 8192000000 10792965552 11207540736 1876367072 18.636 100 51 102 2 1899610384 9047952 14195360
20:10:29 6039 8192000000 10807808560 11216228352 1879465760 18.661 100 49 96 3 1902225024 9785008 12974256
20:10:42 3383 8192000000 10809027824 11216908288 1881875872 18.680 100 50 97 1 1905451088 9998944 13576272
20:10:52 5817 8192000000 10791690640 11216904192 1882627968 18.686 100 32 64 0 1899556816 8187808 8741040
20:11:06 7951 8192000000 10794663200 11219525632 1879937552 18.665 100 28 56 2 1898717216 10579792 8199872
20:11:22 6738 8192000000 10785756784 11219009536 1881821744 18.680 100 12 24 0 1890458000 5669456 2966800
20:11:38 8143 8192000000 10808507712 11232821248 1888593520 18.734 100 17 34 0 1899411872 5607728 5210624
20:11:55 5176 8192000000 10796260272 11229769728 1893341328 18.773 100 31 63 2 1912826832 10985152 8500352
20:12:07 11250 8192000000 10800664416 11235168256 1894588672 18.783 100 17 34 0 1904878816 5833808 4456336
20:12:24 11350 8192000000 10812040480 11237953536 1898168848 18.812 100 35 69 4 1913682320 5728080 9785392
20:12:42 11805 8192000000 10801638432 11238023168 1898476528 18.814 100 28 55 1 1912306624 6070768 7759328
20:13:00 75401 8192000000 10823318944 11249242112 1900576448 18.831 100 34 68 1 1915732768 6031280 9125040
20:14:26 7887 8192000000 10819595664 11253026816 1905075792 18.867 100 25 50 2 1918526368 6771376 6679200
20:14:41 2944 8192000000 10832611360 11258449920 1909529248 18.903 100 48 96 1 1930914128 7604000 13780880
20:14:52 5026 8192000000 10831771296 11256266752 1910327376 18.909 100 36 71 0 1928004096 7737072 9939648
20:15:04 6119 8192000000 10820521776 11257327616 1911532992 18.919 100 37 74 1 1928814992 6021472 11260528
20:15:17 5760 8192000000 10820843392 11243601920 1885418432 18.709 99 31 58 3 1900566288 5644224 9503632
20:15:31 7890 8192000000 10813678832 11245834240 1898643664 18.815 100 18 36 4 1909936560 6010032 5282864
20:15:46 5367 8192000000 10813187968 11251245056 1904281008 18.861 100 32 64 0 1920203616 6091408 9831200
20:15:59 9119 8192000000 10817941248 11252928512 1886879296 18.721 99 20 39 1 1897875952 5533616 5463040
20:16:14 9486 8192000000 10816877792 11255951360 1904194560 18.860 100 17 34 1 1914238656 5270736 4773360
20:16:30 7884 8192000000 10822693232 11249565696 1902092192 18.843 100 19 38 2 1914520912 7286368 5142352
20:16:50 6906 8192000000 10809909504 11248472064 1890767184 18.752 99 28 57 0 1905098752 6068768 8262800
20:17:07 7676 8192000000 10808105360 11246358528 1886213264 18.715 99 16 31 0 1896410112 4855248 5341600
20:17:21 11922 8192000000 10807389872 11233878016 1850022368 18.422 97 31 60 5 1863885664 5365936 8497360
20:17:41 44269 8192000000 10765018096 11196608512 1774096976 17.801 94 16 33 3 1787721968 9020448 4604544
20:18:42 23971 8192000000 10769688832 11203477504 1816482720 18.149 97 24 48 1 1833196720 10257392 6456608
20:19:13 7114 8192000000 10731767248 11150528512 1692931328 17.126 92 24 48 0 1705474304 5842432 6700544
20:19:26 4407 8192000000 10740103472 11157782528 1798251392 18.000 98 24 48 2 1811174624 6060512 6862720
20:19:37 5514 8192000000 10711519968 11119906816 1770921312 17.775 97 31 62 1 1786955296 5964400 10069584
20:19:50 7437 8192000000 10729327392 11150651392 1783768368 17.881 98 22 44 0 1796214960 6261568 6185024
20:20:05 7801 8192000000 10729123392 11144781824 1760380336 17.688 97 24 48 0 1773146752 5405760 7360656
20:20:23 6398 8192000000 10738832480 11158863872 1820923616 18.185 100 34 66 3 1837490992 6614752 9952624
20:20:37 5057 8192000000 10702933776 11111178240 1720506736 17.356 95 29 59 1 1734587264 5980512 8100016
20:20:49 3989 8192000000 10716142752 11130683392 1755590304 17.648 97 35 69 6 1771344848 5711856 10042688
20:21:01 5700 8192000000 10725167664 11143602176 1790109024 17.933 99 24 49 2 1802980896 5748288 7123584
20:21:15 5659 8192000000 10742573296 11159830528 1807504992 18.075 99 32 64 2 1822504288 4788240 10211056
20:21:30 7267 8192000000 10737256688 11148210176 1779899312 17.849 98 31 61 5 1803000720 14411728 8689680
20:21:44 9937 8192000000 10731177344 11156013056 1812635584 18.117 100 21 42 1 1824195984 5686048 5874352
20:22:01 11790 8192000000 10738426320 11158376448 1787497376 17.911 98 21 42 2 1799437744 4992192 6948176
20:22:19 72645 8192000000 10725738128 11149131776 1753060432 17.627 96 35 70 2 1768987280 6245760 9681088
20:23:38 10317 8192000000 10753976272 11172720640 1827150272 18.236 100 28 56 1 1841378752 6203152 8025328
20:23:55 10377 8192000000 10762325376 11179597824 1838621232 18.330 100 31 62 1 1853552032 6605664 8325136
20:24:12 9082 8192000000 10747307904 11165990912 1826437216 18.230 99 41 82 4 1845048208 7539152 11071840
20:24:27 5511 8192000000 10745035440 11159232512 1819611616 18.175 99 29 58 7 1833968640 4925664 9431360
20:24:40 7355 8192000000 10760935520 11180408832 1841149952 18.350 100 26 50 1 1859151680 10739040 7262688
20:24:53 5423 8192000000 10764007440 11185061888 1847196496 18.399 100 35 70 1 1863371760 6689008 9486256
20:25:06 10711 8192000000 10764007104 11189694464 1850113568 18.423 100 25 50 0 1862847568 5698864 7035136
20:25:25 8739 8192000000 10767905568 11197644800 1857098880 18.480 100 21 42 0 1869191104 5548800 6543424
20:25:43 5480 8192000000 10783636544 11207151616 1865627616 18.549 100 31 61 2 1879362688 5709600 8025472
20:25:57 8165 8192000000 10780095008 11209162752 1865570080 18.548 100 15 30 1 1875177280 5451472 4155728
20:26:12 7541 8192000000 10788078640 11213602816 1870133680 18.585 100 22 43 2 1882044064 5294960 6615424
20:26:29 5294 8192000000 10780054000 11213975552 1871884208 18.600 100 27 54 2 1884936752 5232272 7820272
20:26:40 10328 8192000000 10787689344 11218931712 1870060544 18.585 100 16 32 1 1880019840 5894480 4064816
20:26:58 61653 8192000000 10813232656 11233968128 1881375472 18.676 100 27 54 2 1894519296 5098992 8044832
20:28:07 60444 8192000000 10832925504 11261956096 1914293504 18.941 100 45 90 0 1934872768 7965200 12614064
20:29:30 33169 8192000000 10857224944 11287474176 1925397936 19.030 100 38 76 0 1950257072 14600432 10258704
20:30:15 25233 8192000000 10864465408 11295985664 1939352656 19.142 100 43 84 0 1962278448 11105760 11820032
20:30:50 18573 8192000000 10874415504 11305848832 1945961696 19.194 100 45 90 1 1975077472 15813520 13302256
20:31:18 9533 8192000000 10888840368 11318087680 1953321008 19.253 100 57 113 2 1981666592 12136592 16208992
20:31:37 12014 8192000000 10892901568 11322687488 1955637776 19.271 100 43 83 4 1981611344 13226464 12747104
20:31:56 40893 8192000000 10881702912 11311284224 1939642944 19.144 99 48 96 2 1967736224 15080656 13012624
20:32:44 31057 8192000000 10888450224 11325890560 1958714768 19.296 100 40 81 1 1984776880 14050448 12011664
20:33:34 16189 8192000000 10905797680 11336634368 1966986512 19.362 100 51 100 2 1994751168 13091600 14673056
20:33:59 9262 8192000000 10914176064 11335639040 1965653872 19.351 100 46 91 0 1993235520 13911120 13670528
20:34:21 10374 8192000000 10892010816 11319537664 1931954416 19.083 98 48 93 2 1958652688 13234256 13464016
20:34:42 9419 8192000000 10919385184 11345670144 1968192928 19.371 100 54 108 1 2000601680 16993488 15415264
20:34:58 5103 8192000000 10910556512 11342790656 1973047872 19.410 100 50 100 0 2004384192 17274768 14061552
20:35:12 8901 8192000000 10920392336 11352543232 1982348960 19.483 100 68 136 3 2019053744 17225200 19479584
20:35:29 11975 8192000000 10914125200 11341361152 1965862928 19.353 100 58 115 2 2000578976 18548688 16167360
20:35:48 5546 8192000000 10917400320 11347959808 1976592832 19.438 100 53 106 1 2009922160 17333120 15996208
20:36:00 5759 8192000000 10935002336 11356819456 1981856864 19.479 100 66 131 0 2018804768 17617120 19330784
20:36:15 5927 8192000000 10936253328 11358679040 1986594928 19.517 100 70 140 0 2026647024 20131584 19920512
20:36:30 4110 8192000000 10949454304 11363688448 1989427152 19.539 100 72 145 3 2030582976 20168128 20987696
20:36:42 3158 8192000000 10957183040 11379777536 1997035472 19.599 100 78 155 1 2038841184 19115184 22690528
20:36:52 3251 8192000000 10948928352 11369226240 1990077184 19.544 100 75 150 1 2033460768 21724272 21659312
20:37:04 6617 8192000000 10957150592 11372179456 1991037072 19.552 100 78 151 1 2035387008 23011040 21338896
20:37:21 7843 8192000000 10950404672 11381207040 1991676096 19.557 100 68 136 0 2036327872 25539360 19112416
20:37:38 8224 8192000000 10947040512 11375726592 1995933968 19.591 100 64 126 0 2039629936 24941200 18754768
20:37:55 9098 8192000000 10938461488 11360210944 1977133840 19.442 99 73 146 1 2023364576 24911440 21319296
20:38:13 10221 8192000000 10954560864 11384201216 1995288736 19.586 100 60 120 0 2039271920 26420704 17562480
20:38:32 3377 8192000000 10963582304 11387133952 1985243088 19.506 99 71 144 2 2030897408 24400960 21253360
20:38:43 5659 8192000000 10949442928 11381788672 1978257856 19.451 99 73 145 2 2027680560 28159984 21262720
20:38:56 7511 8192000000 10948686848 11380002816 1983327584 19.491 99 69 136 3 2030670784 26151760 21191440
20:39:13 1682 8192000000 10960137776 11381481472 1994388448 19.578 100 84 170 2 2047313216 27186176 25738592
20:39:21 3804 8192000000 10963304496 11386384384 1994952576 19.583 100 76 148 1 2046673568 28437408 23283584
20:39:34 3509 8192000000 10963060800 11386400768 1991476528 19.555 100 68 136 0 2043568736 31062176 21030032
20:39:47 9547 8192000000 10949919488 11374292992 1969361920 19.380 99 60 120 3 2020686976 32329568 18995488
20:40:07 4177 8192000000 10967680464 11393032192 1995467760 19.587 100 58 113 1 2048773696 35309984 17995952
20:40:32 8836 8192000000 10961133344 11387887616 1990546864 19.548 100 67 135 1 2050618832 38362416 21709552
20:40:50 3444 8192000000 10945249792 11373797376 1981459232 19.476 100 63 126 1 2031700544 30462656 19778656
20:41:02 4388 8192000000 10946414608 11377819648 1987421216 19.523 100 49 96 0 2033253968 30397552 15435200
20:41:16 9671 8192000000 10956979120 11392819200 1993116512 19.568 100 52 103 1 2042708400 33392512 16199376
20:41:37 6094 8192000000 10963124688 11393003520 1979836016 19.463 99 69 135 1 2034812800 34236320 20740464
20:41:51 15696 8192000000 10956220048 11384733696 1978131760 19.450 99 68 133 0 2034125056 36163376 19829920
20:42:21 2189 8192000000 10975072240 11402375168 1999434080 19.618 100 70 140 3 2063610384 43048896 21127408
20:42:33 6115 8192000000 10983113024 11414462464 2007482384 19.682 100 64 127 1 2070636944 42970704 20183856
20:42:48 3058 8192000000 10990514336 11406733312 2013339744 19.728 100 80 155 1 2074065168 36458304 24267120
20:42:58 4577 8192000000 10995288912 11409977344 2007672336 19.683 100 76 150 2 2073602672 41477968 24452368
20:43:11 6097 8192000000 10987951168 11411361792 2006501280 19.674 100 72 143 3 2071669904 42779504 22389120
20:43:25 1390 8192000000 10976355904 11392122880 1977650032 19.446 99 79 157 2 2045508224 43605808 24252384
20:43:34 1624 8192000000 10990850608 11409760256 2000765376 19.629 100 88 177 0 2077454000 49257184 27431440
20:43:43 5695 8192000000 10983205664 11406524416 1982372352 19.483 99 77 153 2 2056138480 50070256 23695872
20:43:58 1815 8192000000 10986066112 11400871936 1981025248 19.473 99 88 176 0 2053324464 45869488 26429728
20:44:09 2557 8192000000 10996724672 11414970368 2002080560 19.639 100 78 157 0 2073710416 47411024 24218832
20:44:20 9668 8192000000 10980792384 11407003648 1981510608 19.477 99 70 140 3 2053444624 50724944 21209072
20:44:39 5437 8192000000 10975408160 11397586944 1969322448 19.380 99 69 138 0 2043476016 51939888 22213680
20:44:55 2029 8192000000 10986177872 11399720960 1985974784 19.512 100 83 166 2 2062616592 49829120 26812688
20:45:06 1589 8192000000 10971771824 11379916800 1971453872 19.397 100 82 166 3 2047014144 49787600 25772672
20:45:14 7166 8192000000 10966984208 11389255680 1978553472 19.453 100 72 144 3 2052398976 51842416 22003088
20:45:29 3030 8192000000 10967133360 11388657664 1977741616 19.447 100 74 147 2 2053316272 52243200 23331456
20:45:39 3041 8192000000 10983291168 11402002432 1986935488 19.520 100 85 169 0 2064722768 52335600 25451680
20:45:49 1547 8192000000 10974676912 11391418368 1971029856 19.394 99 83 165 1 2046977968 50823712 25124400
20:45:59 4994 8192000000 10954549024 11369365504 1943387296 19.174 99 75 150 1 2018079360 50508432 24183632
20:46:12 2855 8192000000 10974192384 11392131072 1975310528 19.428 100 71 142 1 2051462592 53933040 22219024
20:46:25 5334 8192000000 10965139520 11380465664 1962516160 19.326 99 77 153 2 2039192560 53142528 23533872
20:46:37 3098 8192000000 10954179632 11364827136 1942389328 19.166 98 88 174 0 2022977712 54092432 26495952
20:46:50 3358 8192000000 10948936416 11354546176 1925974272 19.035 98 73 146 2 2005691056 56407088 23309696
20:47:00 1551 8192000000 10944860944 11355897856 1944860736 19.186 100 87 171 1 2027113808 55041088 27211984
20:47:08 5959 8192000000 10945269184 11364081664 1936182032 19.116 99 65 130 0 2011878624 55088256 20608336
20:47:21 5230 8192000000 10936112016 11349716992 1928939536 19.058 99 69 136 3 2002650000 53509568 20200896
20:47:34 3830 8192000000 10931241248 11365855232 1952378144 19.245 100 60 119 5 2026809184 55139584 19291456
20:47:48 11518 8192000000 10945506560 11368550400 1943374656 19.174 99 54 106 1 2013816304 54399616 16042032
20:48:08 2359 8192000000 10972605616 11393187840 1971450800 19.397 100 65 130 0 2053294256 61746976 20096480
20:48:20 3898 8192000000 10968220416 11395923968 1975648576 19.430 100 57 114 0 2052326528 58847952 17830000
20:48:30 7690 8192000000 10964760384 11396472832 1959936016 19.306 99 56 110 1 2037079344 59814480 17328848
20:48:50 6420 8192000000 10943373216 11378331648 1944093728 19.179 99 48 96 1 2022853904 62471456 16288720
20:49:08 7930 8192000000 10935182208 11373633536 1949614512 19.223 100 42 84 0 2022450736 58856464 13979760
20:49:26 11572 8192000000 10920107408 11352989696 1932646096 19.088 99 35 70 2 2004694624 59953152 12095376
20:49:47 6594 8192000000 10944022752 11377152000 1935717984 19.113 99 44 88 0 2011285456 61036784 14530688
20:50:00 4849 8192000000 10937942592 11355938816 1919100848 18.980 98 59 118 1 2000428384 61801872 19525664
20:50:13 10318 8192000000 10930816144 11371577344 1946350224 19.197 100 45 90 2 2026287632 63975488 15961920
20:50:32 15876 8192000000 10923890608 11359793152 1909011440 18.899 98 37 74 2 1981707296 60237152 12458704
20:51:01 8094 8192000000 10926154176 11366174720 1941195456 19.156 100 37 70 3 2013648976 60447840 12005680
20:51:20 10598 8192000000 10940674928 11369664512 1942717968 19.168 100 38 76 1 2015152720 59900144 12534608
20:51:56 25128 8192000000 10935250176 11383320576 1947442432 19.206 100 30 60 0 2017843072 60115104 10285536
20:52:30 15933 8192000000 10937727024 11381301248 1951275072 19.237 100 31 62 0 2024639136 62466608 10897456
20:53:03 11621 8192000000 10930297040 11376918528 1948814832 19.217 100 38 76 2 2027479888 65537488 13127568
20:53:40 26376 8192000000 10937180880 11391119360 1945707584 19.192 100 24 48 2 2026587264 72300528 8579152
20:54:41 15015 8192000000 10916858704 11376443392 1907597984 18.887 99 24 48 0 1993490128 76120080 9772064
20:55:14 9751 8192000000 10925292672 11379109888 1922581168 19.008 100 29 58 3 2006889344 73790720 10517456
20:55:33 21512 8192000000 10929009920 11393769472 1930178416 19.068 100 20 40 0 2011479136 73057232 8243488
20:56:13 25782 8192000000 10938316432 11396915200 1933702112 19.096 100 25 50 2 2018284784 75623584 8959088
20:56:46 12142 8192000000 10934737376 11384225792 1941919680 19.162 100 27 54 3 2004969088 54258032 8791376
20:57:07 23347 8192000000 10888586960 11337351168 1945529120 19.191 100 41 83 2 1986726336 29363536 11833680
20:57:59 76570 8192000000 10891511232 11338473472 1933943872 19.098 99 25 50 0 1960158336 19133408 7081056
20:59:23 6231 8192000000 10892720864 11339673600 1929890432 19.066 99 27 52 2 1957387120 20071760 7424928
20:59:36 8095 8192000000 10889654944 11344916480 1949613936 19.223 100 26 52 0 1979338784 21825024 7899824
20:59:54 42335 8192000000 10878090496 11339829248 1931428848 19.078 99 24 46 2 1953384976 15259664 6696464
21:01:00 57778 8192000000 10879824800 11344478208 1951321808 19.237 100 8 16 0 1966784688 13318272 2144608
21:02:04 50775 8192000000 10882674560 11347759104 1958302592 19.293 100 13 25 0 1970536672 8976144 3257936
21:03:01 97356 8192000000 10875523424 11333419008 1844692528 18.379 94 12 23 0 1853881760 6329456 2859776
21:05:11 93150 8192000000 10897834080 11362398208 1961336976 19.317 100 35 71 2 1980567136 9426656 9803504
21:06:55 59309 8192000000 10898906352 11358679040 1928950944 19.058 98 21 42 1 1944259904 9685984 5622976
21:08:00 75834 8192000000 10906199936 11374039040 1952955488 19.250 99 22 43 2 1981556960 21417600 7183872
21:09:25 97400 8192000000 10907880960 11373301760 1950528224 19.231 99 11 22 0 1966147824 12268464 3351136
21:11:09 147157 8192000000 10894116176 11364818944 1913253184 18.933 97 8 16 1 1932978112 17227952 2496976
21:13:45 112571 8192000000 10912422576 11359047680 1926584384 19.040 98 12 22 3 1942555968 13268608 2702976
21:15:44 89937 8192000000 10921054672 11385438208 1963257568 19.332 100 11 22 0 1976329296 10219904 2851824
21:17:21 117336 8192000000 10900366160 11386068992 1913022960 18.931 97 11 22 0 1938975088 22001488 3950640
21:19:29 67892 8192000000 10892924688 11373973504 1927836368 19.050 98 9 18 0 1954608112 24479472 2292272
21:21:24 93073 8192000000 10891402160 11349204992 1888140544 18.731 96 26 52 0 1903907136 7929760 7836832
21:23:06 9849 8192000000 10924501584 11347324928 1959289264 19.300 100 81 160 1 1991800608 9385280 23126064
21:23:35 82228 8192000000 10884189232 11343310848 1939351392 19.142 99 35 69 4 1957371408 8531200 9488816
21:25:04 6635 8192000000 10867484688 11334885376 1930242560 19.069 99 15 30 1 1941101488 6775376 4083552
21:25:17 8980 8192000000 10856381280 11329986560 1943088768 19.171 100 18 36 1 1955122448 7398240 4635440
21:25:36 17622 8192000000 10852323728 11301072896 1901598384 18.839 98 11 22 0 1910573328 5801184 3173760
21:26:03 58583 8192000000 10879930864 11344388096 1936438896 19.118 99 48 94 0 1959921872 9724496 13758480
21:27:36 32929 8192000000 10888114160 11352838144 1964116672 19.339 100 25 50 1 1979047584 8355680 6575232
21:29:16 54280 8192000000 10883321472 11354746880 1944833344 19.185 99 19 38 1 1960946064 10970320 5142400
21:30:20 29800 8192000000 10868490720 11345448960 1925441248 19.030 98 8 16 0 1936528544 8858464 2228832
21:30:56 25637 8192000000 10862708944 11335499776 1911138688 18.916 98 12 24 0 1929159840 14550176 3470976
21:31:28 70564 8192000000 10870383136 11347869696 1949419360 19.222 100 15 30 1 1965544992 11486432 4639200
21:32:51 54651 8192000000 10858482000 11344801792 1899366368 18.821 97 12 20 2 1910072544 8191392 2514784
21:33:52 73511 8192000000 10855985568 11327889408 1798146224 17.999 92 11 22 0 1812059600 10962720 2950656
21:35:12 36507 8192000000 10852353984 11321528320 1897511568 18.806 98 12 24 0 1908803424 8192368 3099488
21:36:00 17978 8192000000 10869265440 11328888832 1930058704 19.067 99 52 101 4 1953158528 7734624 15365200
21:36:25 35054 8192000000 10892339904 11348803584 1945244416 19.189 100 40 79 2 1966955792 10606128 11105248
21:37:25 26408 8192000000 10872731376 11329245184 1907234800 18.884 98 29 58 0 1924788416 9780928 7772688
21:37:58 73858 8192000000 10837502592 11300032512 1779297456 17.844 92 7 14 0 1790345728 9352960 1695312
21:39:18 68162 8192000000 10868763216 11332251648 1879345520 18.660 97 13 26 1 1893168160 9514368 4308272
21:40:45 44773 8192000000 10880297808 11334631424 1909208848 18.900 98 30 58 2 1931214480 13461984 8543648
21:41:39 46950 8192000000 10861713168 11338842112 1898667760 18.816 98 12 24 1 1914133472 11677872 3787840
21:42:35 71534 8192000000 10852666096 11325157376 1857098016 18.480 96 27 55 1 1878640336 13643536 7898784
21:43:52 138662 8192000000 10874896448 11337277440 1846674032 18.395 95 14 28 0 1869236080 18192352 4369696
21:46:21 45761 8192000000 10889636608 11337871360 1923387104 19.014 99 18 36 1 1937604912 9326064 4891744
21:47:18 105046 8192000000 10882194288 11346755584 1950356832 19.229 100 28 56 0 1968408368 10302016 7749520
21:49:21 91375 8192000000 10880605952 11355398144 1940512512 19.151 99 17 34 1 1955514112 10385312 4616288
21:50:59 15306 8192000000 10885184048 11358244864 1956579328 19.279 100 18 36 0 1972673856 11513104 4581424
21:51:20 50169 8192000000 10861378656 11340267520 1931718240 19.081 99 27 53 0 1948820256 9112736 7989280
21:52:28 41746 8192000000 10865485920 11340193792 1941407088 19.158 100 9 18 1 1954982480 11318800 2256592
21:53:16 27690 8192000000 10879394528 11349573632 1951526608 19.239 100 17 34 1 1962844576 6939872 4378096
21:54:00 72095 8192000000 10903839680 11371036672 1946252240 19.197 99 12 24 0 1962886784 13365904 3268640
21:56:02 98270 8192000000 10885887568 11375513600 1934319584 19.101 98 16 32 2 1953778432 14984912 4473936
21:57:51 42715 8192000000 10895923552 11372228608 1955489872 19.270 99 17 34 0 1973336016 13007120 4839024
21:58:43 45150 8192000000 10881866304 11364982784 1954320928 19.261 99 13 26 0 1967279024 9147728 3810368
21:59:41 89920 8192000000 10897296736 11374620672 1957277968 19.284 99 7 14 0 1971177520 11958464 1941088
22:01:17 68749 8192000000 10895808832 11381620736 1946638768 19.200 98 26 52 1 1968656048 13902384 8114896
22:02:32 39840 8192000000 10894698800 11366494208 1941446960 19.158 98 13 26 0 1956023728 10705968 3870800
22:03:19 36672 8192000000 10904502128 11367886848 1958789536 19.296 99 32 64 1 1977836496 9142800 9904160
22:04:02 55170 8192000000 10873565024 11358347264 1896492048 18.798 96 29 56 0 1915381088 9628640 9260400
22:05:04 27898 8192000000 10904273248 11370303488 1965797888 19.352 100 27 55 1 1980602736 6861136 7943712
22:05:41 32799 8192000000 10923978832 11379933184 1964958368 19.345 99 43 85 2 1986208608 8497472 12752768
22:06:23 62980 8192000000 10895237984 11361333248 1927675328 19.048 97 30 60 1 1946872016 10899888 8296800
22:07:38 58042 8192000000 10888241024 11370676224 1935364720 19.110 98 18 36 0 1957418208 16513824 5539664
22:09:17 35649 8192000000 10874409312 11334201344 1887713904 18.727 96 34 68 0 1907367152 10304976 9348272
22:10:15 72358 8192000000 10874337664 11356188672 1885044704 18.706 96 23 46 1 1912064160 20275888 6743568
22:11:42 26669 8192000000 10890928736 11346948096 1912608064 18.928 98 20 40 0 1925881872 7437296 5836512
22:12:15 34508 8192000000 10885024144 11353792512 1926165232 19.036 98 43 85 2 1951034960 12675424 12194304
22:12:56 51647 8192000000 10887799696 11361173504 1938063216 19.131 99 23 44 2 1957756352 13347072 6346064
22:13:54 84512 8192000000 10863474176 11339468800 1898312432 18.813 97 12 24 1 1915635552 13780288 3542832
22:15:24 82088 8192000000 10866903888 11351076864 1910449360 18.910 98 17 34 0 1930840544 15569680 4821504
22:16:53 38750 8192000000 10877935696 11338375168 1907728288 18.888 98 24 47 2 1923963008 10032848 6201872
22:17:38 67624 8192000000 10871600448 11356286976 1941315696 19.157 99 22 44 1 1958487312 11375520 5796096
22:18:53 63448 8192000000 10858106480 11341004800 1897623376 18.807 97 13 24 1 1914426496 12829584 3973536
22:20:02 51231 8192000000 10855695280 11332386816 1900474304 18.830 98 20 39 3 1920964240 14198272 6291664
22:21:08 41266 8192000000 10831805280 11307413504 1884277296 18.700 97 9 17 1 1895267376 8210016 2780064
22:23:26 69763 8192000000 10845101280 11319554048 1838289760 18.327 95 11 22 0 1851005600 9582400 3133440
22:25:10 58582 8192000000 10884704992 11353886720 1944720272 19.184 100 21 43 0 1967626432 16507392 6398768
22:26:22 48187 8192000000 10860770896 11327954944 1897180624 18.804 97 26 52 1 1918718336 13791360 7746352
22:27:16 17157 8192000000 9380665360 9673412608 532063648 6.098 28 9 12 3 539677728 5260816 2353264

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 06-04-2021 22:28:52 to 06-04-2021 22:29:24.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 194 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 06-04-2021 22:29:25 to 06-04-2021 22:29:26.

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          247789
MON$OLDEST_ACTIVE               247790
MON$OLDEST_SNAPSHOT             247790
MON$NEXT_TRANSACTION            247790
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                       2044256
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.33441 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33441 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33441 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33441 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 ---
:24: 
:25: mscs-test-161.budzdorov.ru    Tue Apr  6 22:27:35 2021
:26:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:27: 
:28: 
:29: mscs-test-161.budzdorov.ru    Tue Apr  6 22:27:36 2021
:30:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:31: 
:32: 
:33: mscs-test-161.budzdorov.ru    Tue Apr  6 22:27:45 2021
:34:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:35: 
--- end of diff output ---

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

06.04.21 22:29:27. 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
2021-04-06 22:29:30 No severe PSQL-related problems occured
06.04.21 22:29:31. End of report.