Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 01.01.2021 22: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 17426720 kB
MemAvailable 31407268 kB
Buffers 0 kB
Cached 14251136 kB
SwapCached 4864 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-01-01 22:27:06
DTS_END                         2021-01-01 22:27:06.3730
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/52928
TRN_ID                          239374
ATT_ID                          671
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: 9053.00 18076 1086360
customer order: creation 179.38 352 21525
customer order: refuse 14.59 371 1751
order to supplier: creation 47.11 1279 5653
order to supplier: removal 3.20 97334 384
invoice (draft): creation 46.77 3581 5612
invoice (draft): removal 51.58 726 6190
invoice accept: apply 42.20 18267 5064
invoice accept: cancel 46.46 800 5575
customer reserve: creation 3823.72 183 458846
customer reserve: removal 4500.43 55 540052
realization accept: apply 85.49 189 10259
realization accept: cancel 81.13 119 9736
payment from customer: creation 59.08 135 7089
payment from customer: removal 5.91 113 709
payment to supplier: creation 49.41 137 5929
payment to supplier: removal 3.78 59 454
service: total inventory turnovers 4.73 1160 568
service: total monetary turnovers 7.15 33 858
service: aggregate perf. data 0.85 19059 102
service: refresh index statistics 0.03 217568 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-01-2021 22:28:21 to 01-01-2021 22:28:23.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8715
TEST_TIME 2 7815
TEST_TIME 3 6095
TEST_TIME 4 6055
TEST_TIME 5 6185
TEST_TIME 6 6027
TEST_TIME 7 5829
TEST_TIME 8 5815
TEST_TIME 9 5760
TEST_TIME 10 5879
TEST_TIME 11 6013
TEST_TIME 12 5993
TEST_TIME 13 5941
TEST_TIME 14 5980
TEST_TIME 15 6617
TEST_TIME 16 6998
TEST_TIME 17 7210
TEST_TIME 18 7530
TEST_TIME 19 7861
TEST_TIME 20 8058
TEST_TIME 21 8424
TEST_TIME 22 8884
TEST_TIME 23 8972
TEST_TIME 24 9291
TEST_TIME 25 9832
TEST_TIME 26 10359
TEST_TIME 27 10365
TEST_TIME 28 10147
TEST_TIME 29 10123
TEST_TIME 30 9870
TEST_TIME 31 9896
TEST_TIME 32 9895
TEST_TIME 33 9876
TEST_TIME 34 9657
TEST_TIME 35 9636
TEST_TIME 36 9536
TEST_TIME 37 9747
TEST_TIME 38 9731
TEST_TIME 39 9574
TEST_TIME 40 9431
TEST_TIME 41 9449
TEST_TIME 42 9273
TEST_TIME 43 9330
TEST_TIME 44 9210
TEST_TIME 45 9189
TEST_TIME 46 9137
TEST_TIME 47 9133
TEST_TIME 48 9242
TEST_TIME 49 9208
TEST_TIME 50 9319
TEST_TIME 51 9248
TEST_TIME 52 9197
TEST_TIME 53 9253
TEST_TIME 54 9473
TEST_TIME 55 9429
TEST_TIME 56 9448
TEST_TIME 57 9505
TEST_TIME 58 9556
TEST_TIME 59 9639
TEST_TIME 60 9512
TEST_TIME 61 9421
TEST_TIME 62 9352
TEST_TIME 63 9320
TEST_TIME 64 9260
TEST_TIME 65 9254
TEST_TIME 66 9313
TEST_TIME 67 9282
TEST_TIME 68 9293
TEST_TIME 69 9208
TEST_TIME 70 9208
TEST_TIME 71 9218
TEST_TIME 72 9240
TEST_TIME 73 9204
TEST_TIME 74 9212
TEST_TIME 75 9252
TEST_TIME 76 9273
TEST_TIME 77 9301
TEST_TIME 78 9318
TEST_TIME 79 9300
TEST_TIME 80 9261
TEST_TIME 81 9352
TEST_TIME 82 9375
TEST_TIME 83 9408
TEST_TIME 84 9314
TEST_TIME 85 9273
TEST_TIME 86 9223
TEST_TIME 87 9226
TEST_TIME 88 9174
TEST_TIME 89 9165
TEST_TIME 90 9123
TEST_TIME 91 9085
TEST_TIME 92 9099
TEST_TIME 93 9090
TEST_TIME 94 9112
TEST_TIME 95 9112
TEST_TIME 96 9129
TEST_TIME 97 9172
TEST_TIME 98 9161
TEST_TIME 99 9174
TEST_TIME 100 9221
TEST_TIME 101 9203
TEST_TIME 102 9185
TEST_TIME 103 9194
TEST_TIME 104 9324
TEST_TIME 105 9325
TEST_TIME 106 9315
TEST_TIME 107 9257
TEST_TIME 108 9229
TEST_TIME 109 9186
TEST_TIME 110 9176
TEST_TIME 111 9136
TEST_TIME 112 9120
TEST_TIME 113 9114
TEST_TIME 114 9097
TEST_TIME 115 9094
TEST_TIME 116 9135
TEST_TIME 117 9114
TEST_TIME 118 9105
TEST_TIME 119 9105
TEST_TIME 120 9054

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 01-01-2021 22:28:24 to 01-01-2021 22:28:28.

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 1512360 1512360 0 0.00 0 25197 6 0 0
doc_list_biud 1512357 1512357 0 0.00 0 72187 25 0 0
sp_add_invoice_to_stock 5160 5064 96 1.86 25 169766 18268 0 96
sp_cancel_adding_invoice 5575 5575 0 0.00 4 69629 800 0 0
sp_cancel_client_order 1751 1751 0 0.00 5 10895 371 0 0
sp_cancel_customer_reserve 540052 540052 0 0.00 1 72188 55 0 0
sp_cancel_pay_from_customer 709 709 0 0.00 3 13039 114 0 0
sp_cancel_pay_to_supplier 454 454 0 0.00 3 2625 60 0 0
sp_cancel_supplier_invoice 6201 6190 11 0.17 1 14306 727 0 11
sp_cancel_supplier_order 384 384 0 0.00 11 994425 97334 0 0
sp_cancel_write_off 9736 9736 0 0.00 1 15200 120 0 0
sp_client_order 21525 21525 0 0.00 3 32724 352 0 0
sp_customer_reserve 458846 458846 0 0.00 0 78651 184 0 0
sp_fill_shopping_cart 32782 32782 0 0.00 1 16193 44 0 0
sp_fill_shopping_cart_clo_res 458845 458845 0 0.00 0 17126 16 0 0
sp_get_clo_for_invoice 5063 5063 0 0.00 0 29402 333 0 0
sp_kill_cost_storno 16474 16474 0 0.00 0 13132 54 0 0
sp_kill_qstorno_ret_qs2qd 1096414 1096414 0 0.00 0 72183 30 0 0
sp_kill_qty_storno 579009 579009 0 0.00 0 72187 65 0 0
sp_lock_selected_doc 21225 21225 0 0.00 0 8747 7 0 0
sp_make_cost_storno 28340 28340 0 0.00 0 24703 57 0 0
sp_multiply_rows_for_pdistr 28340 28340 0 0.00 0 7634 31 0 0
sp_multiply_rows_for_qdistr 21523 21523 0 0.00 0 32692 179 0 0
sp_pay_from_customer 7089 7089 0 0.00 4 13659 136 0 0
sp_pay_to_supplier 5929 5929 0 0.00 4 13742 137 0 0
sp_payment_common 13018 13018 0 0.00 1 13420 36 0 0
sp_qd_handle_on_cancel_clo 1751 1751 0 0.00 0 10888 333 0 0
sp_qd_handle_on_invoice_upd_sts 10638 10638 0 0.00 0 27613 313 0 0
sp_qd_handle_on_reserve_upd_sts 10258 10258 0 0.00 0 21377 58 0 0
sp_reserve_write_off 10259 10259 0 0.00 6 21395 190 0 0
sp_supplier_invoice 5612 5612 0 0.00 5 107285 3582 0 0
sp_supplier_order 5653 5653 0 0.00 5 23593 1280 0 0
srv_aggregate_perf_data 102 102 0 0.00 2616 167338 19059 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1285 121992 32310 0 0
srv_find_qd_qs_mism 1038597 1038597 0 0.00 0 19475 6 0 0
srv_make_invnt_saldo 568 568 0 0.00 45 44168 1161 0 0
srv_make_money_saldo 858 858 0 0.00 1 3858 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 102333 338144 217569 0 0
t$perf-abend:sp_add_invoice_to_stock 96 96 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5064 5064 0 0.00 0 15229 191 0 0
t$perf-norm:sp_cancel_adding_invoice 449 449 0 0.00 0 1687 74 0 0
t$perf-norm:sp_cancel_client_order 1751 1751 0 0.00 0 4895 17 0 0
t$perf-norm:sp_cancel_customer_reserve 708 708 0 0.00 0 5056 29 0 0
t$perf-norm:sp_cancel_pay_from_customer 709 709 0 0.00 0 2016 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 454 454 0 0.00 0 3739 26 0 0
t$perf-norm:sp_cancel_supplier_invoice 424 424 0 0.00 0 623 12 0 0
t$perf-norm:sp_cancel_supplier_order 384 384 0 0.00 0 23311 1708 0 0
t$perf-norm:sp_cancel_write_off 1025 1025 0 0.00 0 3350 12 0 0
t$perf-norm:sp_client_order 21525 21525 0 0.00 0 7468 19 0 0
t$perf-norm:sp_customer_reserve 999 999 0 0.00 0 2803 12 0 0
t$perf-norm:sp_pay_from_customer 7089 7089 0 0.00 0 4954 9 0 0
t$perf-norm:sp_pay_to_supplier 5929 5929 0 0.00 0 10079 13 0 0
t$perf-norm:sp_reserve_write_off 10259 10259 0 0.00 0 6705 13 0 0
t$perf-norm:sp_supplier_invoice 5612 5612 0 0.00 0 3013 20 0 0
t$perf-norm:sp_supplier_order 5653 5653 0 0.00 0 3871 17 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 177 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 2265 33 0 0
t$perf-norm:srv_make_invnt_saldo 568 568 0 0.00 0 3264 34 0 0
t$perf-norm:srv_make_money_saldo 858 858 0 0.00 0 2233 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10318 10126 192 1.86 0 15086 22 0 192
v_all_customers 38530 38530 0 0.00 0 19 1 0 0
v_all_suppliers 30824 30824 0 0.00 0 111 1 0 0
v_all_wares 43046 43046 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 898 898 0 0.00 0 632 7 0 0
v_cancel_client_order 3502 3502 0 0.00 0 4828 9 0 0
v_cancel_customer_prepayment 1418 1418 0 0.00 0 12990 22 0 0
v_cancel_customer_reserve 1416 1416 0 0.00 0 2098 5 0 0
v_cancel_payment_to_supplier 908 908 0 0.00 0 1713 6 0 0
v_cancel_supplier_invoice 870 848 22 2.52 0 1713 18 0 22
v_cancel_supplier_order 768 768 0 0.00 0 12880 28 0 0
v_cancel_write_off 2050 2050 0 0.00 0 15096 27 0 0
v_max_id_clo_ord 5650 5650 0 0.00 0 512 1 0 0
v_max_id_clo_res 999 999 0 0.00 0 2443 22 0 0
v_max_id_ord_sup 5607 5607 0 0.00 0 5599 7 0 0
v_max_non_paid_invoice 1774 1774 0 0.00 0 1237 3 0 0
v_max_non_paid_realizn 3921 3921 0 0.00 0 3232 6 0 0
v_min_id_clo_ord 5650 5650 0 0.00 0 8604 11 0 0
v_min_id_clo_res 999 999 0 0.00 0 9366 29 0 0
v_min_id_ord_sup 5607 5607 0 0.00 0 5206 8 0 0
v_min_non_paid_invoice 5929 5929 0 0.00 0 12620 21 0 0
v_min_non_paid_realizn 7088 7088 0 0.00 0 6621 22 0 0
v_our_firm 10850 10850 0 0.00 0 13 1 0 0
v_reserve_write_off 20516 20516 0 0.00 0 12882 8 0 0
x_lock_depdocs_on_canc_invoice 11341 11341 0 0.00 0 12691 110 0 0
x_lock_depdocs_on_canc_sup_ord 384 384 0 0.00 0 7280 324 0 0
x_make_qstorno_1000_1200 5653 5653 0 0.00 2 23561 1189 0 0
x_make_qstorno_1200_2000 5612 5612 0 0.00 1 106754 3419 0 0
x_make_qstorno_2100_3300 458846 458846 0 0.00 0 78616 165 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 01-01-2021 22:28:29 to 01-01-2021 22:28:33.

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:10 9 8192000000 8800800608 8812003328 6918096 0.084 2 1 2 0 7037472 56816 62560
19:57:18 19592 8192000000 10244504320 10554036224 965516496 10.543 76 55 109 1 986121344 2548576 18056272
19:57:47 34127 8192000000 10354054240 10671579136 1397337008 14.571 100 78 157 0 1426673056 4756704 24579344
19:58:33 27735 8192000000 10382514928 10705219584 1435827488 14.913 100 89 178 0 1471900464 7032880 29040096
19:59:14 21262 8192000000 10407835392 10734153728 1461724016 15.141 100 90 180 0 1498531360 7804048 29003296
19:59:43 9247 8192000000 10423193056 10748981248 1473048960 15.240 100 91 181 2 1510943248 8505632 29388656
20:00:10 24905 8192000000 10435537664 10769027072 1493344240 15.418 100 93 186 2 1532662448 9499488 29818720
20:00:48 25122 8192000000 10451104736 10784960512 1502922272 15.502 100 88 176 1 1541042864 10045632 28074960
20:01:21 18386 8192000000 10470283008 10811527168 1524313264 15.688 100 88 175 3 1562420832 10521824 27585744
20:01:56 10653 8192000000 10505591600 10851328000 1563875328 16.030 100 78 156 2 1598464000 10771328 23817344
20:02:24 14208 8192000000 10541486880 10895753216 1599210048 16.333 100 77 154 0 1633668112 11392288 23065776
20:02:44 13769 8192000000 10571259808 10931539968 1631237696 16.605 100 78 156 0 1666131184 11683648 23209840
20:03:07 11937 8192000000 10589616080 10953805824 1648680944 16.753 100 82 164 2 1685264208 12232784 24350480
20:03:26 12646 8192000000 10592891984 10961244160 1656784416 16.822 100 81 162 0 1693809680 12610992 24414272
20:03:47 9114 8192000000 10610490720 10979254272 1670838224 16.940 100 78 156 0 1705799248 11939392 23021632
20:04:03 8237 8192000000 10621988992 10997506048 1681543584 17.030 100 67 134 0 1712089168 11102912 19442672
20:04:24 6740 8192000000 10646368320 11019866112 1711578896 17.282 100 72 142 2 1743558592 11719072 20260624
20:04:38 8052 8192000000 10658240240 11037753344 1724565024 17.390 100 71 142 0 1756930224 11242080 21123120
20:04:53 6403 8192000000 10672837696 11048333312 1740540304 17.523 100 74 148 0 1772442912 11081120 20821488
20:05:07 5069 8192000000 10687049776 11065188352 1748979664 17.593 100 78 156 0 1783145232 11961936 22203632
20:05:21 6012 8192000000 10699303872 11079598080 1767650256 17.748 100 82 164 0 1803435904 12906240 22879408
20:05:33 3499 8192000000 10708637392 11091943424 1771085840 17.776 100 71 142 0 1804374704 13428704 19860160
20:05:45 3545 8192000000 10715945536 11098726400 1782407312 17.869 100 79 158 1 1818587296 13840816 22339168
20:05:55 10011 8192000000 10724537088 11109232640 1789079648 17.924 100 76 152 1 1824101264 13676928 21344688
20:06:14 5350 8192000000 10727096128 11111800832 1795032336 17.973 100 75 151 1 1828944560 13202816 20709408
20:06:26 3721 8192000000 10743664784 11130830848 1810800896 18.102 100 83 166 0 1847520304 12920160 23799248
20:06:38 3253 8192000000 10754398640 11142979584 1820663648 18.183 100 82 162 4 1856324496 12832384 22828464
20:06:49 3429 8192000000 10770255696 11155492864 1826505696 18.231 100 84 167 1 1862894960 13244992 23144272
20:06:59 2164 8192000000 10784049232 11168575488 1838886640 18.332 100 90 181 1 1877857120 13896912 25073568
20:07:08 2694 8192000000 10783136400 11169492992 1843248912 18.367 100 91 182 1 1882461008 13671568 25540528
20:07:18 3812 8192000000 10789286800 11175235584 1842409920 18.360 100 85 168 1 1879294704 13479872 23404912
20:07:28 2369 8192000000 10786122464 11176382464 1848568256 18.410 100 80 156 0 1883390960 12660272 22162432
20:07:38 2173 8192000000 10798836192 11189235712 1856689392 18.476 100 88 176 2 1895107040 13281472 25136176
20:07:47 1738 8192000000 10802597008 11189379072 1859691648 18.501 100 93 183 1 1899922160 14746544 25483968
20:07:55 1544 8192000000 10808912224 11198730240 1866450336 18.556 100 94 188 4 1907114144 14209920 26453888
20:08:03 2449 8192000000 10804258592 11199774720 1865104384 18.545 100 82 164 0 1901676464 13205216 23366864
20:08:12 3744 8192000000 10811214448 11204071424 1871662416 18.598 100 90 181 2 1910113168 13101408 25349344
20:08:23 6846 8192000000 10814095760 11208404992 1874649824 18.622 100 87 174 2 1913516384 13632976 25233584
20:08:36 2389 8192000000 10814159920 11208200192 1878049280 18.649 100 87 175 2 1915225168 11681360 25494528
20:08:45 2937 8192000000 10820189968 11214774272 1876894160 18.640 100 89 178 2 1913782096 12180400 24707536
20:08:55 2122 8192000000 10821922080 11212099584 1879105600 18.658 100 91 180 0 1917817088 13715824 24995664
20:09:03 1604 8192000000 10830687104 11222843392 1884786176 18.704 100 96 192 1 1927529664 15715056 27028432
20:09:12 2605 8192000000 10831271472 11222519808 1885664080 18.711 100 88 176 0 1924598336 14357520 24576736
20:09:21 1923 8192000000 10836770016 11227783168 1891925184 18.761 100 91 180 1 1931563424 14360752 25277488
20:09:29 1212 8192000000 10840335136 11232784384 1892555312 18.766 100 94 188 2 1933052896 13565040 26932544
20:09:36 1366 8192000000 10839674112 11230953472 1893482208 18.774 100 95 192 0 1933966416 13289360 27194848
20:09:44 1685 8192000000 10847126528 11239014400 1900546544 18.831 100 97 195 0 1940468144 12369808 27551792
20:09:52 1744 8192000000 10841902560 11237289984 1898280384 18.812 100 92 185 1 1935577200 11175456 26121360
20:10:00 23555 8192000000 10820302880 11230552064 1891087424 18.755 100 51 102 5 1914591552 8449472 15054656
20:10:33 10382 8192000000 10837674224 11235991552 1896747616 18.800 100 73 148 5 1926965488 8499712 21718160
20:10:50 4686 8192000000 10825554656 11234631680 1899755136 18.824 100 69 139 1 1929299040 9480416 20063488
20:11:01 8350 8192000000 10803093760 11228909568 1892990192 18.770 100 34 68 2 1910949504 8535424 9423888
20:11:15 6380 8192000000 10804564896 11230449664 1892298880 18.764 100 30 60 2 1908567808 8023312 8245616
20:11:30 9700 8192000000 10826855584 11239960576 1898016176 18.810 100 42 82 1 1916218624 6035328 12167120
20:11:46 4546 8192000000 10820563504 11242237952 1905514208 18.871 100 43 86 2 1924570688 6662592 12393888
20:11:57 11120 8192000000 10809701120 11239526400 1899722224 18.824 100 32 64 1 1916020064 7654672 8643168
20:12:15 8633 8192000000 10801262864 11235045376 1897404496 18.805 100 20 40 0 1909092208 5715216 5972496
20:12:31 13466 8192000000 10819056560 11245174784 1904792128 18.865 100 41 82 0 1922170560 5467040 11911392
20:12:52 54952 8192000000 10829931776 11254525952 1906726416 18.880 100 37 71 0 1920982016 4758160 9497440
20:13:57 14033 8192000000 10819754560 11252973568 1905496912 18.870 100 27 54 1 1918901424 6206496 7198016
20:14:17 7571 8192000000 10818592112 11256352768 1909958032 18.906 100 23 46 1 1922394928 6551440 5885456
20:14:31 3683 8192000000 10832168144 11261345792 1910693888 18.912 100 35 70 1 1928115744 7857168 9564688
20:14:45 7626 8192000000 10831512272 11262312448 1911303568 18.917 100 24 48 2 1924390272 6521488 6565216
20:15:02 6506 8192000000 10827508256 11264663552 1917656960 18.968 100 32 64 0 1933963264 6959696 9346608
20:15:16 6290 8192000000 10824244224 11262365696 1915057136 18.947 100 22 44 1 1927130784 5775376 6298272
20:15:28 11981 8192000000 10825885488 11263811584 1914699696 18.944 100 14 26 1 1923766208 5697536 3368976
20:15:46 9141 8192000000 10828449600 11272028160 1916130224 18.956 100 21 42 0 1927594912 6001040 5463648
20:16:02 13401 8192000000 10818254288 11260424192 1894245936 18.780 99 14 28 0 1903552064 5482672 3823456
20:16:22 14737 8192000000 10830585072 11262795776 1912251472 18.925 100 22 44 2 1928049392 9402624 6395296
20:16:45 8109 8192000000 10824653840 11254497280 1888219312 18.731 99 21 39 2 1904356000 10093392 6043296
20:17:00 13096 8192000000 10810361472 11249303552 1887547632 18.726 99 17 34 1 1898334112 6219856 4566624
20:17:21 21317 8192000000 10825793968 11247403008 1838014416 18.325 96 27 51 2 1854866528 9352464 7499648
20:17:48 65478 8192000000 10806708192 11232157696 1864376432 18.539 98 37 74 2 1880596224 5233232 10986560
20:19:04 12127 8192000000 10749808848 11175919616 1770813344 17.774 95 20 40 0 1782031120 5495808 5721968
20:19:23 7937 8192000000 10751653136 11176304640 1821446592 18.190 98 16 32 1 1831341552 5347232 4547728
20:19:37 6574 8192000000 10739505856 11161739264 1768744400 17.757 96 22 44 1 1780567120 5128960 6693760
20:19:52 7935 8192000000 10728006224 11143229440 1762006224 17.701 96 26 53 2 1774428544 5157392 7264928
20:20:06 6305 8192000000 10730988080 11153551360 1779452400 17.845 97 25 50 2 1792142160 5300144 7389616
20:20:20 9790 8192000000 10711022160 11132833792 1747267584 17.579 96 26 52 3 1759712816 4991664 7453568
20:20:37 12852 8192000000 10698784832 11116085248 1704319632 17.221 94 20 40 0 1715239712 4973728 5946352
20:20:56 7736 8192000000 10688202640 11097538560 1721592672 17.365 95 28 56 1 1739536512 9751664 8192176
20:21:10 10950 8192000000 10711889456 11120746496 1725907168 17.401 96 18 36 0 1736439104 5155696 5376240
20:21:31 9288 8192000000 10677122688 11094753280 1735254560 17.479 97 29 58 2 1750143808 5891216 8998032
20:21:48 9861 8192000000 10713359712 11127746560 1762532976 17.705 98 25 50 1 1775914992 5944048 7437968
20:22:04 9485 8192000000 10714810592 11125030912 1780345600 17.852 99 31 61 3 1795552640 5394064 9812976
20:22:24 13230 8192000000 10708660784 11126075392 1793372304 17.959 100 22 44 3 1804190672 4912896 5905472
20:22:48 72841 8192000000 10708657392 11137310720 1745220528 17.562 96 19 38 0 1755570448 4870864 5479056
20:24:09 9798 8192000000 10728544736 11148484608 1811648208 18.109 100 19 36 0 1822664864 5616016 5400640
20:24:28 8504 8192000000 10748930192 11171713024 1829833792 18.258 100 28 56 2 1843328304 6004816 7489696
20:24:44 8145 8192000000 10769806336 11178696704 1838561344 18.329 100 47 93 1 1859194496 7925360 12707792
20:24:58 8175 8192000000 10757034640 11175829504 1837781392 18.323 100 30 59 3 1850994816 5158816 8054608
20:25:14 9982 8192000000 10754204544 11179483136 1839847648 18.340 100 27 54 1 1853830912 5652080 8331184
20:25:30 5014 8192000000 10751274080 11178643456 1840116560 18.342 100 26 51 1 1853623152 5626160 7880432
20:25:44 8669 8192000000 10770237856 11184885760 1842552416 18.362 100 29 58 1 1856807056 5866800 8387840
20:26:02 7214 8192000000 10763523904 11186106368 1844378528 18.376 100 22 44 1 1856726720 6032496 6315696
20:26:20 5203 8192000000 10769625328 11191414784 1845968048 18.389 100 23 46 1 1858659760 5216656 7475056
20:26:33 10497 8192000000 10768709968 11191975936 1849093392 18.415 100 22 42 1 1861550976 5043344 7414240
20:26:51 13607 8192000000 10764130240 11197775872 1853941632 18.454 100 13 26 0 1863754528 5556400 4256496
20:27:14 14139 8192000000 10816343680 11222568960 1878692624 18.655 100 40 80 1 1896292320 6053776 11545920
20:27:37 17782 8192000000 10812732016 11228295168 1885166064 18.707 100 46 92 1 1906504720 8243456 13095200
20:28:09 13591 8192000000 10818222640 11237699584 1891159360 18.755 100 44 87 1 1911361216 8360352 11841504
20:28:30 12821 8192000000 10847734512 11252957184 1903647296 18.856 100 71 142 4 1933521264 9168640 20705328
20:28:49 70330 8192000000 10822214704 11257769984 1904817088 18.865 100 42 83 0 1924341184 7661376 11862720
20:30:09 37538 8192000000 10853796576 11275984896 1916221728 18.957 100 45 90 0 1938155424 8844672 13089024
20:31:10 35054 8192000000 10863178496 11291947008 1931663568 19.080 100 42 84 2 1954160752 9889440 12607744
20:31:52 3667 8192000000 10883832816 11302498304 1941613152 19.160 100 69 138 4 1975217248 13440144 20163952
20:32:03 3438 8192000000 10891706304 11305345024 1944134448 19.180 100 67 132 1 1978583008 15576464 18872096
20:32:14 25429 8192000000 10888969776 11311194112 1951911168 19.242 100 59 117 1 1982755648 13963088 16881392
20:32:51 3794 8192000000 10902687280 11322032128 1960005696 19.306 100 69 138 2 1995087840 14351792 20730352
20:33:11 14095 8192000000 10882628736 11304239104 1938156240 19.132 99 49 98 0 1966890896 14444864 14289792
20:33:41 6640 8192000000 10903724704 11327463424 1960982176 19.314 100 55 109 2 1997212048 20834752 15395120
20:33:55 13971 8192000000 10904240832 11328507904 1962721904 19.328 100 59 114 1 1996311760 16972864 16616992
20:34:19 6497 8192000000 10918943280 11337236480 1966919904 19.361 100 61 120 1 2005230576 20825856 17484816
20:34:34 12600 8192000000 10915347680 11340390400 1967818944 19.368 100 56 112 1 2006022160 21999536 16203680
20:35:08 8933 8192000000 10921811120 11345637376 1954438128 19.262 99 60 121 2 1997224112 24697280 18088704
20:35:23 14592 8192000000 10911903024 11342897152 1968409872 19.373 100 50 100 1 2008649856 24788688 15451296
20:35:47 14898 8192000000 10918442800 11352641536 1972536640 19.406 100 57 114 2 2018055008 27533216 17985152
20:36:40 15728 8192000000 10922216896 11353841664 1971416976 19.397 100 40 80 1 2009841264 26337440 12086848
20:37:07 9881 8192000000 10916398192 11354865664 1972428816 19.405 100 32 64 1 2010011136 27346400 10235920
20:37:31 6574 8192000000 10915216352 11352735744 1953950384 19.258 99 37 73 3 1989059088 24578544 10530160
20:37:52 8489 8192000000 10913779648 11340738560 1954012976 19.258 99 40 80 4 1992211840 25994480 12204384
20:38:10 5357 8192000000 10921094496 11349577728 1953339008 19.253 99 53 106 0 1996604368 26925152 16340208
20:38:35 5268 8192000000 10928214192 11358781440 1976153088 19.434 100 52 102 2 2019333728 27723840 15456800
20:38:53 5630 8192000000 10935208144 11368431616 1983014672 19.489 100 46 92 1 2022835072 25920224 13900176
20:39:09 8308 8192000000 10945457008 11375878144 1988823600 19.534 100 60 120 0 2035274768 27731312 18719856
20:39:25 6792 8192000000 10943734480 11376615424 1989367456 19.539 100 44 87 3 2031054448 27132352 14554640
20:39:44 3547 8192000000 10943058592 11371335680 1974952000 19.425 99 62 123 0 2020576816 27316208 18308608
20:39:54 6617 8192000000 10950561216 11376623616 1990992048 19.552 100 62 122 2 2037080704 27585536 18503120
20:40:08 12504 8192000000 10952791872 11379818496 1993638640 19.573 100 56 110 1 2038461152 27821536 17000976
20:40:31 2263 8192000000 10954050112 11374559232 1987454336 19.524 100 70 138 2 2036824528 28411536 20958656
20:40:42 9885 8192000000 10949372128 11376967680 1992122064 19.561 100 68 133 4 2043014432 30215056 20677312
20:41:03 4464 8192000000 10960840624 11388485632 1991503552 19.556 100 65 130 1 2042206128 31195472 19507104
20:41:14 2193 8192000000 10972613552 11387637760 2000707360 19.628 100 82 164 0 2060583440 35445120 24430960
20:41:24 3958 8192000000 10949112992 11374563328 1983147808 19.490 100 71 142 0 2041488208 36693472 21646928
20:41:43 2378 8192000000 10926660272 11331624960 1930313568 19.069 97 71 142 1 1989044848 36797504 21933776
20:41:53 2611 8192000000 10947152624 11350970368 1960445568 19.310 99 91 182 0 2028461360 39485680 28530112
20:42:02 2162 8192000000 10941953264 11345506304 1945259712 19.189 99 91 181 2 2014020000 41573408 27186880
20:42:11 2315 8192000000 10944446544 11354963968 1964219072 19.340 100 79 157 0 2027374480 39591312 23564096
20:42:19 2942 8192000000 10939631040 11358625792 1964540688 19.342 100 80 160 2 2028594752 40216000 23838064
20:42:29 4120 8192000000 10925557056 11340910592 1941085920 19.155 99 74 147 0 2002336496 38886144 22364432
20:42:41 3040 8192000000 10931141008 11335700480 1930656224 19.072 99 91 181 0 1995117104 37477504 26983376
20:42:53 1610 8192000000 10927574128 11338584064 1936636640 19.120 99 86 172 2 2001436128 38120016 26679472
20:43:03 3492 8192000000 10911998016 11326693376 1936301568 19.117 100 80 158 1 1997345568 36851088 24192912
20:43:13 1571 8192000000 10936186752 11344920576 1952671216 19.248 100 86 172 1 2018168768 37937136 27560416
20:43:23 2348 8192000000 10907234224 11315306496 1900453248 18.830 98 83 166 2 1963412752 37905744 25053760
20:43:32 4867 8192000000 10917004384 11331608576 1934752304 19.105 100 73 146 0 1997941792 39996720 23192768
20:43:45 3858 8192000000 10922927792 11341438976 1947077184 19.203 100 73 148 1 2011427120 41181792 23168144
20:43:56 3832 8192000000 10929243760 11344736256 1942537600 19.167 99 74 147 0 2005855936 40982800 22335536
20:44:08 6854 8192000000 10939494240 11349168128 1952238544 19.244 100 71 138 0 2014598944 41771312 20589088
20:44:22 1284 8192000000 10944426368 11347095552 1956232784 19.276 100 97 192 2 2026949616 40804400 29912432
20:44:30 8338 8192000000 10929718480 11338969088 1944985888 19.187 100 80 160 1 2012892272 43504032 24402352
20:44:45 5436 8192000000 10929610880 11337162752 1920117088 18.988 98 78 156 2 1983778192 39806688 23854416
20:44:58 2866 8192000000 10924874384 11328339968 1935931168 19.114 100 76 151 0 2002081808 41602528 24548112
20:45:09 3638 8192000000 10926071184 11340148736 1946326816 19.197 100 85 167 0 2018241360 45275504 26639040
20:45:23 2942 8192000000 10936688704 11346284544 1948441776 19.214 100 84 169 1 2021247104 46170016 26635312
20:45:34 2647 8192000000 10939406320 11347701760 1950037296 19.227 100 81 161 1 2022610960 47254720 25318944
20:45:43 1882 8192000000 10950365584 11359936512 1959250688 19.300 100 83 168 4 2031114736 44882416 26981632
20:45:55 2472 8192000000 10924206496 11337457664 1941751760 19.161 99 68 137 0 2007279840 43810992 21717088
20:46:05 3341 8192000000 10950765792 11360858112 1960498176 19.310 100 84 167 0 2034180640 46954864 26727600
20:46:16 4038 8192000000 10962852784 11379011584 1970958016 19.393 100 77 153 2 2044318832 48664064 24696752
20:46:29 1963 8192000000 10962158448 11368726528 1970577760 19.390 100 85 168 1 2038397040 42285920 25533360
20:46:39 1823 8192000000 10953249376 11364581376 1966121776 19.355 100 79 157 2 2032445552 42015808 24307968
20:46:50 3239 8192000000 10961230576 11378720768 1974275984 19.419 100 77 152 1 2042165088 44399744 23489360
20:47:03 11457 8192000000 10942365312 11381903360 1972729744 19.407 100 56 112 0 2036847216 46317088 17800384
20:47:22 25526 8192000000 10925065344 11365613568 1962017648 19.322 100 41 81 2 2015061040 39928320 13115072
20:47:56 4396 8192000000 10941289744 11370831872 1967073408 19.362 100 49 97 3 2024818768 42497888 15247472
20:48:11 6063 8192000000 10934578048 11365302272 1956617328 19.279 100 49 96 1 2018313728 45755760 15940640
20:48:25 3432 8192000000 10941531520 11366563840 1959020528 19.298 100 68 134 0 2027439472 46245104 22173840
20:48:36 2156 8192000000 10953956768 11370553344 1959324480 19.301 100 85 170 1 2032144688 45881472 26938736
20:48:49 6585 8192000000 10921923568 11352424448 1949589632 19.223 100 51 102 0 2003833872 38204752 16039488
20:49:02 4050 8192000000 10925912160 11357360128 1957356576 19.285 100 56 112 1 2014167152 38564080 18246496
20:49:16 7577 8192000000 10926866624 11360178176 1955841984 19.273 100 50 98 1 2012628944 40808672 15978288
20:49:38 31036 8192000000 10883272992 11335720960 1893665552 18.775 97 22 44 1 1940676960 39381168 7630240
20:50:16 12107 8192000000 10862914800 11314573312 1898024416 18.810 99 22 42 0 1939242704 33751776 7466512
20:50:44 13781 8192000000 10869951840 11310145536 1912388336 18.926 100 26 52 2 1954662544 32750528 9523680
20:51:11 19625 8192000000 10860106144 11310579712 1898321760 18.813 99 36 70 1 1943187552 33292192 11573600
20:51:43 18379 8192000000 10884568592 11334246400 1918566864 18.975 100 25 50 3 1958610336 31607424 8436048
20:52:11 28335 8192000000 10884497136 11340226560 1916360544 18.958 99 29 58 0 1961223920 33749568 11113808
20:52:54 21068 8192000000 10876090880 11331166208 1932607632 19.088 100 20 40 1 1959933904 20737296 6588976
20:53:55 47104 8192000000 10854466064 11307081728 1838663520 18.330 95 12 24 0 1856620112 13780896 4175696
20:54:50 36316 8192000000 10877156752 11318644736 1897832304 18.809 98 33 66 1 1913368992 6834912 8701776
20:56:00 78487 8192000000 10869191872 11316469760 1932384992 19.086 100 38 77 0 1953168400 9193616 11589792
20:57:28 13540 8192000000 10890872064 11316031488 1929673120 19.064 99 63 125 2 1956769200 8575392 18520688
20:57:48 22097 8192000000 10855811696 11292864512 1914641056 18.944 99 59 118 1 1944173984 13011792 16521136
20:58:21 23014 8192000000 10848742784 11285352448 1896242128 18.796 98 33 67 1 1917073088 10112384 10718576
20:58:52 88623 8192000000 10865359408 11320844288 1852665616 18.444 96 18 36 1 1869230128 12269408 4295104
21:00:39 73274 8192000000 10884894720 11328397312 1934858000 19.106 99 18 36 0 1956790400 16893616 5038784
21:01:58 37091 8192000000 10895632560 11342331904 1940752352 19.153 99 32 64 1 1961717216 12048480 8916384
21:02:45 24960 8192000000 10914040288 11353653248 1966867984 19.361 100 34 68 0 1989428480 12564832 9995664
21:03:23 38721 8192000000 10896154128 11349372928 1951503232 19.238 99 31 62 2 1975684352 14645088 9536032
21:04:08 50496 8192000000 10880760640 11355983872 1942074096 19.163 99 19 38 1 1965101376 16494592 6532688
21:05:06 22955 8192000000 10890140464 11366117376 1959674944 19.303 100 8 16 0 1979789360 17630608 2483808
21:05:35 22096 8192000000 10870223920 11338293248 1925165632 19.028 98 12 24 1 1937849104 9241152 3442320
21:06:04 45885 8192000000 10883269952 11346649088 1963003328 19.330 100 8 16 1 1972827872 7514464 2310080
21:06:56 84722 8192000000 10909455456 11366293504 1972100272 19.402 100 18 36 1 1986528096 9167808 5260016
21:08:27 88209 8192000000 10892813296 11366047744 1981938240 19.480 100 18 35 1 1997173312 9918128 5316944
21:10:07 38754 8192000000 10905949152 11361103872 1941219904 19.156 98 31 61 1 1961521008 12159056 8142048
21:10:59 46572 8192000000 10886064640 11353837568 1979786624 19.463 100 27 54 0 1996553840 8100832 8666384
21:13:19 23059 8192000000 10882908048 11340500992 1935078176 19.107 98 35 71 0 1951916704 6413696 10424832
21:13:58 68931 8192000000 10888604848 11364823040 1966922896 19.361 100 28 56 2 1984583648 9278384 8382368
21:15:56 63472 8192000000 10912985536 11371356160 1949840560 19.225 98 18 36 0 1967195600 12666480 4688560
21:17:10 121991 8192000000 10936048304 11395747840 1961740432 19.320 99 15 30 1 1980944336 15234960 3968944
21:19:22 93093 8192000000 10898217408 11364917248 1937354576 19.126 97 18 36 1 1962526896 19548016 5624304
21:21:02 85525 8192000000 10900974160 11350986752 1917874736 18.970 97 8 16 0 1939003200 19192976 1935488
21:22:36 57078 8192000000 10860689584 11315429376 1792497696 17.952 91 19 38 3 1806621472 9122944 5000832
21:23:39 77615 8192000000 10873145872 11328393216 1852080080 18.439 96 20 40 1 1875331712 17612816 5638816
21:25:26 46452 8192000000 10888654096 11346436096 1940158384 19.148 100 22 45 1 1963474896 16691584 6624928
21:26:27 84206 8192000000 10868386560 11324174336 1892668336 18.767 97 15 30 0 1915497440 18826688 4002416
21:28:19 49269 8192000000 10855565408 11318333440 1893721056 18.776 97 30 60 1 1908313520 6031472 8560992
21:29:14 52263 8192000000 10905793152 11347935232 1952537552 19.247 100 39 78 4 1974194496 10790160 10866784
21:30:24 26596 8192000000 10904941360 11367550976 1976594512 19.438 100 36 70 3 2003108016 16154384 10359120
21:31:12 42466 8192000000 10905623392 11374350336 1970238768 19.387 99 32 62 1 1997376592 18275424 8862400
21:32:11 74317 8192000000 10885904048 11356835840 1921976112 19.003 97 20 41 1 1948176736 19941968 6258656
21:33:37 33708 8192000000 10896455856 11383693312 1972312832 19.404 100 10 20 1 1993862016 18536688 3012496
21:34:19 49308 8192000000 10875799712 11363205120 1934841120 19.106 98 13 27 0 1952001008 13266272 3893616
21:35:22 67306 8192000000 10875707440 11346866176 1944047936 19.179 99 17 34 2 1959298608 10771536 4479136
21:36:36 39742 8192000000 10876670016 11345866752 1928188896 19.052 98 10 20 0 1941123312 10137264 2797152
21:37:24 75042 8192000000 10847290512 11307503616 1823191360 18.204 93 8 16 1 1832535408 7472384 1871664
21:38:46 47456 8192000000 10867539760 11328528384 1922305520 19.005 99 24 47 3 1939350272 10325008 6719744
21:39:40 63360 8192000000 10883263760 11342249984 1910257264 18.909 98 21 41 1 1926196400 10000368 5938768
21:40:50 53814 8192000000 10871300848 11342237696 1924892400 19.026 99 14 28 0 1943384352 14581872 3910080
21:41:50 80262 8192000000 10868446704 11337478144 1872523360 18.605 96 10 20 1 1891049840 15289696 3236784
21:43:17 56564 8192000000 10851541296 11309223936 1819206560 18.171 93 21 42 1 1838965920 13939936 5819424
21:44:25 63220 8192000000 10834364224 11312881664 1843274768 18.367 96 13 26 0 1861241440 14023024 3943648
21:45:40 59339 8192000000 10860335488 11313909760 1873324480 18.611 97 20 40 0 1887856352 9003008 5528864
21:46:56 28756 8192000000 10866966640 11310329856 1894928112 18.785 98 43 86 0 1918030176 10689312 12412752
21:47:31 32835 8192000000 10875620864 11317874688 1895173664 18.787 98 41 82 3 1917699536 11296608 11229264
21:48:12 38490 8192000000 10875408480 11340279808 1937140448 19.124 100 27 54 4 1962729552 17892192 7696912
21:50:10 106132 8192000000 10874689408 11344617472 1929527136 19.063 99 13 26 0 1947582416 14549680 3505600
21:52:02 66325 8192000000 10872460400 11341881344 1938204256 19.132 99 29 58 1 1956592272 10353728 8034288
21:53:14 55611 8192000000 10877751744 11330748416 1936284544 19.117 99 26 52 0 1954583248 11381056 6917648
21:54:22 21692 8192000000 10892047488 11344318464 1954667280 19.264 100 30 60 0 1976751504 13452032 8632192
21:56:14 60079 8192000000 10873748064 11354279936 1939545616 19.143 99 15 30 0 1957975104 14119728 4309760
21:57:20 51952 8192000000 10879273184 11345203200 1942511616 19.167 99 12 23 0 1954968032 9708208 2748208
21:58:49 46638 8192000000 10879617872 11354783744 1939836784 19.145 98 30 60 0 1955712368 8000032 7875552
21:59:45 87308 8192000000 10898848192 11368316928 1947968544 19.210 99 9 19 1 1961822320 12052832 1800944
22:01:19 81621 8192000000 10905894608 11371937792 1957816544 19.289 99 18 36 0 1974702608 12217936 4668128
22:02:47 35358 8192000000 10892847632 11359473664 1955920992 19.274 99 12 24 1 1975133328 15792864 3419472
22:03:36 68453 8192000000 10891089216 11355160576 1938967408 19.139 98 24 48 1 1961090304 15383856 6739040
22:04:50 59828 8192000000 10896370480 11361275904 1923680848 19.016 97 32 64 0 1941951376 9733408 8537120
22:05:59 45264 8192000000 10906045616 11375427584 1977395552 19.444 100 18 36 0 1993921024 11863616 4661856
22:07:00 72117 8192000000 10897141888 11365388288 1964524944 19.342 99 21 42 1 1986806352 16617952 5663456
22:08:19 60172 8192000000 10920014624 11377094656 1941789344 19.161 98 27 56 2 1961747328 12404688 7553296
22:09:25 53912 8192000000 10935815840 11393601536 1985825376 19.511 100 27 54 1 2014741360 21112720 7803264
22:10:26 79779 8192000000 10910891408 11408052224 1969045696 19.378 99 18 36 0 1995032464 20859136 5127632
22:11:52 103402 8192000000 10875125888 11338891264 1847500544 18.402 94 12 24 0 1867456928 16639024 3317360
22:13:53 40191 8192000000 10870187728 11316600832 1858329632 18.490 95 53 103 3 1882399472 8707744 15362096
22:14:52 96365 8192000000 10853458672 11312967680 1892810464 18.768 98 16 32 1 1904795744 7039520 4945760
22:16:37 34801 8192000000 10852716112 11302080512 1902359056 18.845 98 37 71 1 1922419888 10181104 9879728
22:17:44 58352 8192000000 10850463328 11324739584 1916973584 18.963 99 15 29 1 1928938272 8157776 3806912
22:18:49 35039 8192000000 10855993776 11326824448 1916304560 18.957 99 7 14 0 1928498992 9980608 2213824
22:19:57 57854 8192000000 10830412640 11297509376 1858264960 18.489 96 15 30 0 1871573024 9022976 4285088
22:21:52 62625 8192000000 10846040864 11324383232 1924494768 19.023 100 12 24 1 1943172976 15055520 3622688
22:23:02 62731 8192000000 10862270704 11344244736 1933328064 19.093 100 11 22 2 1948643856 11922048 3393744
22:24:16 38983 8192000000 10854771696 11323203584 1903341280 18.853 98 17 34 0 1919089200 11062224 4685696
22:25:26 51179 8192000000 10868863136 11333120000 1909266736 18.901 98 16 32 2 1926284416 12259440 4758240
22:26:24 48084 8192000000 9370365664 9658404864 521187632 5.981 27 7 14 0 531236496 7753360 2295504

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 01-01-2021 22:28:35 to 01-01-2021 22:29:06.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 96 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 01-01-2021 22:29:07 to 01-01-2021 22:29:09.

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          240457
MON$OLDEST_ACTIVE               240458
MON$OLDEST_SNAPSHOT             240458
MON$NEXT_TRANSACTION            240458
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                       2019968
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:208: 
:209: mscs-test-161.budzdorov.ru    Fri Jan  1 22:27:19 2021
:210:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:211: 
--- end of diff output ---

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

01.01.21 22:29:10. 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-01-01 22:29:12 No severe PSQL-related problems occured
01.01.21 22:29:13. End of report.