Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 09.02.2021 16: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 16855384 kB
MemAvailable 31181356 kB
Buffers 0 kB
Cached 14813056 kB
SwapCached 4780 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-02-09 16:27:17
DTS_END                         2021-02-09 16:27:17.9580
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/54702
TRN_ID                          238261
ATT_ID                          666
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: 9624.71 18777 1154965
customer order: creation 167.78 384 20134
customer order: refuse 14.38 351 1726
order to supplier: creation 43.99 1481 5279
order to supplier: removal 3.65 104730 438
invoice (draft): creation 45.33 3374 5440
invoice (draft): removal 57.78 719 6934
invoice accept: apply 40.61 18353 4873
invoice accept: cancel 52.10 805 6252
customer reserve: creation 3809.66 178 457159
customer reserve: removal 5083.07 58 609968
realization accept: apply 81.47 183 9777
realization accept: cancel 100.36 117 12043
payment from customer: creation 56.96 118 6835
payment from customer: removal 5.45 105 654
payment to supplier: creation 47.34 120 5681
payment to supplier: removal 3.33 72 400
service: total inventory turnovers 4.51 1408 541
service: total monetary turnovers 6.11 44 733
service: aggregate perf. data 0.78 22492 94
service: refresh index statistics 0.03 220454 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 09-02-2021 16:27:54 to 09-02-2021 16:27:56.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8498
TEST_TIME 2 5456
TEST_TIME 3 5376
TEST_TIME 4 5227
TEST_TIME 5 5318
TEST_TIME 6 5109
TEST_TIME 7 5554
TEST_TIME 8 5650
TEST_TIME 9 6112
TEST_TIME 10 6580
TEST_TIME 11 6603
TEST_TIME 12 6774
TEST_TIME 13 6920
TEST_TIME 14 6779
TEST_TIME 15 6896
TEST_TIME 16 7489
TEST_TIME 17 7275
TEST_TIME 18 7415
TEST_TIME 19 7984
TEST_TIME 20 7981
TEST_TIME 21 7946
TEST_TIME 22 8689
TEST_TIME 23 8974
TEST_TIME 24 8926
TEST_TIME 25 9211
TEST_TIME 26 9401
TEST_TIME 27 9502
TEST_TIME 28 9995
TEST_TIME 29 11396
TEST_TIME 30 11330
TEST_TIME 31 11194
TEST_TIME 32 11194
TEST_TIME 33 11183
TEST_TIME 34 11141
TEST_TIME 35 11222
TEST_TIME 36 10924
TEST_TIME 37 10808
TEST_TIME 38 10730
TEST_TIME 39 10602
TEST_TIME 40 10644
TEST_TIME 41 10519
TEST_TIME 42 10477
TEST_TIME 43 10385
TEST_TIME 44 10321
TEST_TIME 45 10263
TEST_TIME 46 10284
TEST_TIME 47 10338
TEST_TIME 48 10218
TEST_TIME 49 10085
TEST_TIME 50 10018
TEST_TIME 51 9998
TEST_TIME 52 9890
TEST_TIME 53 9781
TEST_TIME 54 9790
TEST_TIME 55 9707
TEST_TIME 56 9688
TEST_TIME 57 9639
TEST_TIME 58 9698
TEST_TIME 59 9690
TEST_TIME 60 9638
TEST_TIME 61 9721
TEST_TIME 62 9782
TEST_TIME 63 9845
TEST_TIME 64 9888
TEST_TIME 65 9978
TEST_TIME 66 9898
TEST_TIME 67 9977
TEST_TIME 68 10081
TEST_TIME 69 10073
TEST_TIME 70 10143
TEST_TIME 71 10008
TEST_TIME 72 9956
TEST_TIME 73 9890
TEST_TIME 74 9829
TEST_TIME 75 9884
TEST_TIME 76 9870
TEST_TIME 77 9806
TEST_TIME 78 9769
TEST_TIME 79 9696
TEST_TIME 80 9619
TEST_TIME 81 9607
TEST_TIME 82 9618
TEST_TIME 83 9570
TEST_TIME 84 9559
TEST_TIME 85 9546
TEST_TIME 86 9526
TEST_TIME 87 9518
TEST_TIME 88 9569
TEST_TIME 89 9631
TEST_TIME 90 9691
TEST_TIME 91 9655
TEST_TIME 92 9686
TEST_TIME 93 9781
TEST_TIME 94 9851
TEST_TIME 95 9913
TEST_TIME 96 9858
TEST_TIME 97 9966
TEST_TIME 98 9914
TEST_TIME 99 9832
TEST_TIME 100 9802
TEST_TIME 101 9788
TEST_TIME 102 9740
TEST_TIME 103 9749
TEST_TIME 104 9712
TEST_TIME 105 9665
TEST_TIME 106 9638
TEST_TIME 107 9570
TEST_TIME 108 9541
TEST_TIME 109 9599
TEST_TIME 110 9612
TEST_TIME 111 9623
TEST_TIME 112 9620
TEST_TIME 113 9609
TEST_TIME 114 9661
TEST_TIME 115 9676
TEST_TIME 116 9651
TEST_TIME 117 9651
TEST_TIME 118 9668
TEST_TIME 119 9697
TEST_TIME 120 9632

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 09-02-2021 16:27:58 to 09-02-2021 16:28:01.

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 1578913 1578913 0 0.00 0 33114 6 0 0
doc_list_biud 1578913 1578913 0 0.00 0 39767 28 0 0
sp_add_invoice_to_stock 4980 4873 107 2.14 35 185651 18353 0 107
sp_cancel_adding_invoice 6252 6252 0 0.00 5 64710 805 0 0
sp_cancel_client_order 1726 1726 0 0.00 4 18212 351 0 0
sp_cancel_customer_reserve 609968 609968 0 0.00 1 39768 59 0 0
sp_cancel_pay_from_customer 654 654 0 0.00 3 4850 105 0 0
sp_cancel_pay_to_supplier 400 400 0 0.00 3 4194 72 0 0
sp_cancel_supplier_invoice 6940 6934 6 0.08 1 13940 720 0 6
sp_cancel_supplier_order 438 438 0 0.00 6 1112154 104730 0 0
sp_cancel_write_off 12043 12043 0 0.00 1 21637 117 0 0
sp_client_order 20134 20134 0 0.00 4 45653 384 0 0
sp_customer_reserve 457159 457159 0 0.00 0 91889 179 0 0
sp_fill_shopping_cart 30847 30847 0 0.00 1 12323 38 0 0
sp_fill_shopping_cart_clo_res 457151 457151 0 0.00 0 13073 14 0 0
sp_get_clo_for_invoice 4864 4864 0 0.00 0 30958 334 0 0
sp_kill_cost_storno 19349 19349 0 0.00 0 11544 62 0 0
sp_kill_qstorno_ret_qs2qd 1239351 1239351 0 0.00 0 39765 31 0 0
sp_kill_qty_storno 652002 652002 0 0.00 0 39767 68 0 0
sp_lock_selected_doc 20292 20292 0 0.00 0 9587 5 0 0
sp_make_cost_storno 27157 27157 0 0.00 0 13893 55 0 0
sp_multiply_rows_for_pdistr 27157 27157 0 0.00 0 9010 30 0 0
sp_multiply_rows_for_qdistr 20134 20134 0 0.00 0 45641 163 0 0
sp_pay_from_customer 6835 6835 0 0.00 4 19789 118 0 0
sp_pay_to_supplier 5681 5681 0 0.00 5 16911 120 0 0
sp_payment_common 12516 12516 0 0.00 1 19319 33 0 0
sp_qd_handle_on_cancel_clo 1726 1726 0 0.00 0 18205 322 0 0
sp_qd_handle_on_invoice_upd_sts 11116 11116 0 0.00 0 31743 348 0 0
sp_qd_handle_on_reserve_upd_sts 9777 9777 0 0.00 0 21691 64 0 0
sp_reserve_write_off 9777 9777 0 0.00 6 21761 184 0 0
sp_supplier_invoice 5440 5440 0 0.00 6 61917 3375 0 0
sp_supplier_order 5279 5279 0 0.00 6 46397 1482 0 0
srv_aggregate_perf_data 94 94 0 0.00 2766 364592 22492 0 0
srv_fill_mon_cache_memory 164 164 0 0.00 983 183693 31754 0 0
srv_find_qd_qs_mism 1108676 1108676 0 0.00 0 33069 5 0 0
srv_make_invnt_saldo 541 541 0 0.00 30 129468 1408 0 0
srv_make_money_saldo 733 733 0 0.00 1 8992 45 0 0
srv_recalc_idx_stat 4 4 0 0.00 113954 350721 220455 0 0
t$perf-abend:sp_add_invoice_to_stock 107 107 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4874 4874 0 0.00 0 11977 167 0 0
t$perf-norm:sp_cancel_adding_invoice 439 439 0 0.00 0 9110 96 0 0
t$perf-norm:sp_cancel_client_order 1726 1726 0 0.00 0 8353 17 0 0
t$perf-norm:sp_cancel_customer_reserve 633 633 0 0.00 0 9406 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 654 654 0 0.00 0 449 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 400 400 0 0.00 0 8223 22 0 0
t$perf-norm:sp_cancel_supplier_invoice 384 384 0 0.00 0 1132 10 0 0
t$perf-norm:sp_cancel_supplier_order 438 438 0 0.00 0 21556 1571 0 0
t$perf-norm:sp_cancel_write_off 978 978 0 0.00 0 930 6 0 0
t$perf-norm:sp_client_order 20134 20134 0 0.00 0 14993 19 0 0
t$perf-norm:sp_customer_reserve 1027 1027 0 0.00 0 2767 8 0 0
t$perf-norm:sp_pay_from_customer 6835 6835 0 0.00 0 6533 8 0 0
t$perf-norm:sp_pay_to_supplier 5681 5681 0 0.00 0 7271 11 0 0
t$perf-norm:sp_reserve_write_off 9777 9777 0 0.00 0 12593 12 0 0
t$perf-norm:sp_supplier_invoice 5440 5440 0 0.00 0 9797 23 0 0
t$perf-norm:sp_supplier_order 5279 5279 0 0.00 0 3890 14 0 0
t$perf-norm:srv_aggregate_perf_data 94 94 0 0.00 0 1656 31 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 626 5 0 0
t$perf-norm:srv_make_invnt_saldo 541 541 0 0.00 0 972 22 0 0
t$perf-norm:srv_make_money_saldo 733 733 0 0.00 0 419 11 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 4 0 0
v_add_invoice_to_stock 9942 9728 214 2.15 0 4794 17 0 214
v_all_customers 37156 37156 0 0.00 0 190 1 0 0
v_all_suppliers 29886 29886 0 0.00 0 195 1 0 0
v_all_wares 40268 40268 0 0.00 0 14 1 0 0
v_cancel_adding_invoice 878 878 0 0.00 0 3776 10 0 0
v_cancel_client_order 3452 3452 0 0.00 0 3303 6 0 0
v_cancel_customer_prepayment 1308 1308 0 0.00 0 3347 14 0 0
v_cancel_customer_reserve 1266 1266 0 0.00 0 197 3 0 0
v_cancel_payment_to_supplier 800 800 0 0.00 0 949 4 0 0
v_cancel_supplier_invoice 780 768 12 1.53 0 2027 21 0 12
v_cancel_supplier_order 876 876 0 0.00 0 1246 5 0 0
v_cancel_write_off 1956 1956 0 0.00 0 3102 14 0 0
v_max_id_clo_ord 5279 5279 0 0.00 0 3115 2 0 0
v_max_id_clo_res 1027 1027 0 0.00 0 2148 15 0 0
v_max_id_ord_sup 5434 5434 0 0.00 0 8790 5 0 0
v_max_non_paid_invoice 1451 1451 0 0.00 0 429 3 0 0
v_max_non_paid_realizn 3342 3342 0 0.00 0 3065 4 0 0
v_min_id_clo_ord 5279 5279 0 0.00 0 4946 8 0 0
v_min_id_clo_res 1027 1027 0 0.00 0 5420 16 0 0
v_min_id_ord_sup 5434 5434 0 0.00 0 5621 7 0 0
v_min_non_paid_invoice 5681 5681 0 0.00 0 6526 18 0 0
v_min_non_paid_realizn 6835 6835 0 0.00 0 19315 26 0 0
v_our_firm 10098 10098 0 0.00 0 19 1 0 0
v_reserve_write_off 19552 19552 0 0.00 0 5185 6 0 0
x_lock_depdocs_on_canc_invoice 12802 12802 0 0.00 0 14172 104 0 0
x_lock_depdocs_on_canc_sup_ord 438 438 0 0.00 0 15105 348 0 0
x_make_qstorno_1000_1200 5279 5279 0 0.00 2 46384 1394 0 0
x_make_qstorno_1200_2000 5440 5440 0 0.00 2 61791 3244 0 0
x_make_qstorno_2100_3300 457159 457159 0 0.00 0 91888 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-02-2021 16:28:02 to 09-02-2021 16:28:06.

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
13:57:21 6 8192000000 8816545664 8831733760 20395056 0.248 4 4 5 0 20694272 87456 211760
13:57:28 17134 8192000000 10242423152 10545188864 935051920 10.244 74 64 128 0 960034688 2666000 22316768
13:57:53 26334 8192000000 10316289648 10632572928 1374762128 14.370 100 85 170 0 1407378976 4737216 27879632
13:58:30 37650 8192000000 10379337744 10698887168 1423378096 14.803 100 90 180 0 1459036784 5939040 29719648
13:59:18 14652 8192000000 10395927952 10719399936 1452681680 15.061 100 88 176 0 1488311648 6807472 28822496
13:59:49 23435 8192000000 10431449056 10759282688 1478903248 15.292 100 89 178 0 1515871664 7501072 29467344
14:00:25 31965 8192000000 10457968928 10792497152 1508007616 15.546 100 85 170 0 1543114672 8257184 26849872
14:01:05 20491 8192000000 10491958704 10834722816 1544122960 15.859 100 88 176 0 1581039744 8980992 27935792
14:01:34 21673 8192000000 10512696784 10869133312 1572085424 16.100 100 74 148 0 1604776560 9663680 23027456
14:02:04 16240 8192000000 10557988512 10913685504 1615085232 16.468 100 78 156 2 1649130432 10284304 23760896
14:02:28 10973 8192000000 10579864160 10936184832 1632875040 16.619 100 78 156 0 1667298480 10340304 24083136
14:02:52 10130 8192000000 10585903168 10950430720 1651400976 16.776 100 74 146 3 1684098576 10844016 21853584
14:03:12 15261 8192000000 10607803968 10975219712 1671670960 16.947 100 69 138 1 1702383424 10734640 19977824
14:03:34 10902 8192000000 10621362992 10993672192 1694514272 17.139 100 74 148 2 1727555104 11756352 21284480
14:03:53 10257 8192000000 10656300672 11031388160 1710280368 17.271 100 72 144 0 1742201984 11456384 20465232
14:04:11 6535 8192000000 10667302992 11044347904 1729160944 17.429 100 77 152 2 1763532096 12240240 22130912
14:04:25 6065 8192000000 10670687808 11048722432 1734827664 17.476 100 74 148 1 1768004784 12274752 20902368
14:04:40 6975 8192000000 10681862624 11058806784 1748901104 17.592 100 81 162 0 1784950608 12248448 23801056
14:04:54 4347 8192000000 10689266400 11066974208 1754859072 17.642 100 78 156 0 1790535744 12888912 22787760
14:05:07 5040 8192000000 10698069184 11078328320 1761886752 17.700 100 71 142 0 1795471792 13594768 19990272
14:05:20 3587 8192000000 10707597184 11089674240 1773438224 17.795 100 82 164 1 1810905984 14576464 22891296
14:05:30 9585 8192000000 10706330384 11094798336 1776528640 17.821 100 78 153 3 1811278352 13154128 21595584
14:05:48 3596 8192000000 10732742752 11117576192 1791797984 17.947 100 80 159 2 1827055632 12982064 22275584
14:05:58 3464 8192000000 10742701376 11127283712 1809905600 18.095 100 82 163 3 1847102672 12638624 24558448
14:06:09 2736 8192000000 10751849264 11137376256 1819629424 18.175 100 81 163 1 1854504464 12122496 22752544
14:06:18 2866 8192000000 10756228256 11143131136 1820736448 18.184 100 81 162 1 1855984368 12532368 22715552
14:06:29 2652 8192000000 10763465776 11153448960 1829412688 18.255 100 81 161 1 1864962384 12978592 22571104
14:06:38 2614 8192000000 10779138512 11162566656 1832010688 18.276 100 90 179 0 1870487952 12992880 25484384
14:06:47 3097 8192000000 10779686256 11164106752 1836411840 18.312 100 93 187 1 1875978944 13795616 25771488
14:06:56 1988 8192000000 10775316352 11159023616 1836488448 18.312 100 92 181 0 1876228448 13774640 25965360
14:07:05 1556 8192000000 10786506336 11170820096 1838177760 18.326 100 85 168 0 1877472224 14038368 25256096
14:07:13 1494 8192000000 10783017968 11167567872 1841603648 18.354 100 87 174 0 1880023152 14564336 23855168
14:07:21 2015 8192000000 10786082752 11175239680 1844540112 18.378 100 81 162 1 1879894144 12488176 22865856
14:07:30 2614 8192000000 10804181136 11189411840 1854474208 18.458 100 86 170 2 1891398272 12450272 24473792
14:07:39 2333 8192000000 10800656672 11186016256 1860352784 18.506 100 94 188 1 1899889792 12752832 26784176
14:07:48 1298 8192000000 10809413776 11194056704 1859322912 18.498 100 91 184 1 1899212384 13408368 26481104
14:07:56 1184 8192000000 10806477296 11192573952 1858988400 18.495 100 88 174 0 1898102784 14483136 24631248
14:08:03 1582 8192000000 10811308112 11195707392 1864191488 18.537 100 96 193 0 1905965808 15052384 26721936
14:08:11 5276 8192000000 10786693664 11189633024 1859266384 18.497 100 60 121 1 1887401536 11535680 16599472
14:08:24 48226 8192000000 10790761792 11194867712 1859829280 18.502 100 55 110 1 1884958704 7864096 17265328
14:09:19 11199 8192000000 10777971536 11195215872 1868788080 18.574 100 72 144 1 1897998464 8188496 21021888
14:09:37 7626 8192000000 10776209728 11206643712 1865209632 18.545 100 29 58 1 1881981264 9006144 7765488
14:09:51 7080 8192000000 10773273856 11201175552 1869517744 18.580 100 33 62 5 1887461680 9404032 8539904
14:10:05 4073 8192000000 10780466384 11207094272 1869825552 18.583 100 23 47 0 1883824320 7045664 6953104
14:10:15 8055 8192000000 10784545120 11211915264 1870864896 18.591 100 17 34 1 1880907328 5296896 4745536
14:10:30 7299 8192000000 10801270080 11222474752 1881304576 18.676 100 35 70 2 1898148032 6252608 10590848
14:10:46 11920 8192000000 10782571632 11219832832 1880655760 18.670 100 17 34 1 1891306832 6076496 4574576
14:11:05 5775 8192000000 10796762864 11228114944 1887492896 18.726 100 32 64 2 1902825712 6385488 8947328
14:11:17 6327 8192000000 10801296000 11230912512 1892359280 18.765 100 24 48 0 1905458912 6381936 6717696
14:11:29 10080 8192000000 10802106016 11234025472 1890655136 18.751 100 18 35 3 1901034624 5479424 4900064
14:11:46 8325 8192000000 10812385360 11244298240 1897461696 18.806 100 25 49 1 1913835440 9874288 6499456
14:12:00 10631 8192000000 10808887840 11249549312 1902430528 18.846 100 20 40 3 1918509952 10943776 5135648
14:12:23 14192 8192000000 10811589824 11247980544 1906295600 18.877 100 14 28 1 1916117584 5826432 3995552
14:12:46 6821 8192000000 10818139584 11253411840 1908865360 18.898 100 14 28 1 1918244272 5314368 4064544
14:13:01 6929 8192000000 10816461136 11249336320 1908479472 18.894 100 16 32 0 1918971392 5622016 4869904
14:13:15 23722 8192000000 10832422752 11258322944 1915872240 18.954 100 22 44 1 1927212272 5357232 5982800
14:13:46 69330 8192000000 10829669840 11264102400 1917795696 18.969 100 27 53 2 1931856240 5266128 8794416
14:15:04 7328 8192000000 10835645424 11268526080 1916356576 18.958 100 17 34 0 1928559936 6523056 5680304
14:15:20 8018 8192000000 10834466560 11269431296 1918498672 18.975 100 23 46 0 1930847008 6137536 6210800
14:15:35 5349 8192000000 10832262448 11263152128 1902316768 18.845 99 38 77 2 1921631488 8144448 11170272
14:15:47 2638 8192000000 10847014176 11265748992 1917834816 18.969 100 39 77 3 1935772624 6454864 11482944
14:15:57 8799 8192000000 10819088656 11251507200 1879041424 18.657 98 20 40 0 1890434080 5422240 5970416
14:16:12 7594 8192000000 10819531840 11248848896 1869029040 18.576 98 24 46 2 1881010992 5948288 6033664
14:16:32 6384 8192000000 10803604352 11241467904 1896133376 18.795 100 26 50 0 1910506272 6168368 8204528
14:16:45 7560 8192000000 10794631424 11224821760 1840203888 18.342 97 20 40 1 1851513984 6114416 5195680
14:16:58 9458 8192000000 10797180912 11232460800 1859221552 18.497 98 20 40 0 1871059280 6450640 5387088
14:17:17 10523 8192000000 10776079216 11204915200 1795791808 17.979 95 14 28 0 1805277328 5183440 4302080
14:17:44 5293 8192000000 10781277584 11214278656 1856841120 18.478 99 26 53 1 1871324832 7085040 7398672
14:17:57 9480 8192000000 10802296816 11229749248 1846168544 18.391 98 22 43 0 1857645152 5374496 6102112
14:18:16 7366 8192000000 10774049312 11195346944 1796633136 17.986 96 21 42 0 1808317552 5494384 6190032
14:18:31 11838 8192000000 10755706272 11179896832 1796446512 17.985 97 15 30 0 1805434176 5228528 3759136
14:18:49 58931 8192000000 10730357488 11153240064 1731521120 17.448 93 31 62 0 1745885008 5644560 8719328
14:19:57 11871 8192000000 10663992672 11067408384 1594377984 16.291 88 18 36 0 1604422288 5383248 4661056
14:20:18 7028 8192000000 10723632240 11130351616 1788856512 17.922 100 28 56 2 1807094064 10807376 7430176
14:20:33 5486 8192000000 10688140800 11095449600 1708891712 17.259 95 33 66 4 1724243168 6562384 8789072
14:20:45 9736 8192000000 10711415648 11123736576 1741851648 17.534 97 23 47 4 1754548640 5756496 6940496
14:21:04 4529 8192000000 10713708960 11131797504 1793885200 17.964 99 28 55 1 1808551600 6640176 8026224
14:21:15 8125 8192000000 10738826544 11143065600 1756372864 17.654 97 33 66 2 1770947008 4937136 9637008
14:21:30 10012 8192000000 10723362928 11142291456 1778962032 17.841 98 28 56 0 1797835616 9394880 9478704
14:21:49 6930 8192000000 10706164880 11120144384 1771806512 17.782 98 37 74 1 1792609568 10053184 10749872
14:22:05 8175 8192000000 10724183888 11139436544 1790106480 17.933 99 27 56 2 1803847840 5702992 8038368
14:22:19 5550 8192000000 10730629408 11158683648 1820172544 18.179 100 28 57 0 1834797168 6596672 8027952
14:22:32 6889 8192000000 10753087872 11173597184 1833225040 18.286 100 22 44 0 1845812928 5634144 6953744
14:22:46 8602 8192000000 10765764720 11180183552 1838097312 18.325 100 30 61 1 1852777744 5058272 9622160
14:23:03 9502 8192000000 10765868128 11192893440 1849443920 18.418 100 15 30 0 1859498768 5585392 4469456
14:23:20 52359 8192000000 10770833632 11198758912 1857977264 18.487 100 26 52 1 1871783952 5216624 8590064
14:24:24 20289 8192000000 10773712016 11204145152 1857916816 18.486 100 20 40 1 1873860560 10598720 5345024
14:24:55 11089 8192000000 10773401616 11204710400 1861286304 18.514 100 27 54 4 1875140944 6408960 7445680
14:25:13 9223 8192000000 10780888816 11206541312 1864474032 18.540 100 30 60 1 1879401936 6423696 8504208
14:25:30 6172 8192000000 10785724560 11211251712 1868213856 18.570 100 30 58 2 1882579904 6577120 7788928
14:25:43 10233 8192000000 10785354512 11212963840 1866555056 18.556 100 21 42 0 1877843536 5629168 5659312
14:26:01 6378 8192000000 10804380160 11222163456 1872728864 18.606 100 28 55 3 1886719296 5540416 8450016
14:26:15 11826 8192000000 10790221152 11218583552 1875384160 18.628 100 26 52 2 1888774656 5455584 7934912
14:26:35 11364 8192000000 10801704320 11226734592 1877066704 18.641 100 26 52 1 1890866560 5100656 8699200
14:26:53 12119 8192000000 10809316096 11227738112 1882632160 18.686 100 29 56 3 1896064768 4926560 8506048
14:27:12 11402 8192000000 10833298208 11249946624 1898751488 18.816 100 34 66 1 1913356496 5566928 9038080
14:27:34 34612 8192000000 10841686064 11263483904 1915859600 18.954 100 34 68 0 1930721600 5431552 9430448
14:28:36 10552 8192000000 10864265424 11288170496 1934202144 19.100 100 44 86 2 1958187984 11053696 12932144
14:28:54 4753 8192000000 10876031440 11297136640 1939784144 19.145 100 49 98 4 1966726832 12379664 14563024
14:29:08 86273 8192000000 10888395920 11323121664 1957752896 19.288 100 55 110 1 1989460720 15483312 16224512
14:30:41 42407 8192000000 10884369024 11329306624 1955759728 19.272 100 32 64 0 1982503248 17481648 9261872
14:31:31 31621 8192000000 10890180592 11335671808 1958092816 19.291 100 27 54 1 1986548656 21023952 7431888
14:32:20 30976 8192000000 10909285536 11349676032 1966312688 19.356 100 31 62 0 1992461040 16843008 9305344
14:32:58 30369 8192000000 10923446704 11359797248 1978515920 19.453 100 40 78 1 2008195184 18433616 11245648
14:33:38 7059 8192000000 10932450800 11362050048 1986580400 19.517 100 50 100 1 2020886336 19248512 15057424
14:33:53 8569 8192000000 10921936704 11351261184 1969321744 19.380 99 56 112 2 2009524880 23823216 16379920
14:34:20 14441 8192000000 10913478576 11349577728 1946540528 19.199 98 51 102 0 1984549776 22671536 15337712
14:34:46 22322 8192000000 10921679568 11359993856 1975779776 19.431 100 40 80 1 2011610400 23809968 12020656
14:35:19 15796 8192000000 10911252192 11353387008 1960898160 19.313 99 40 80 1 1994747200 21487472 12361568
14:35:43 10425 8192000000 10934445632 11371905024 1981757536 19.479 100 49 98 2 2027183696 31077248 14348912
14:36:19 9484 8192000000 10937960016 11377721344 1990272560 19.546 100 41 82 3 2025759104 23127248 12359296
14:36:35 7399 8192000000 10959799984 11389313024 2001390640 19.634 100 60 117 3 2043677680 24075104 18211936
14:36:50 4118 8192000000 10961640224 11391639552 2005537696 19.666 100 69 138 0 2050069248 24181072 20350480
14:37:03 5680 8192000000 10966827456 11391008768 2009281952 19.696 100 72 143 1 2050095488 19569808 21243728
14:37:15 3538 8192000000 10953257952 11384434688 2004842800 19.661 100 73 144 0 2047206080 20875456 21487824
14:37:27 11007 8192000000 10950835312 11375525888 1968327680 19.372 98 70 141 1 2010870816 21815616 20727520
14:37:48 9446 8192000000 10956602592 11393081344 2000383264 19.626 100 56 111 0 2043128480 25990048 16755168
14:38:04 3938 8192000000 10960882256 11390218240 2003691424 19.652 100 56 113 0 2043038224 21824560 17522240
14:38:15 15145 8192000000 10949816464 11375796224 1977596704 19.446 99 60 120 1 2018531216 22863840 18070672
14:38:42 9332 8192000000 10952894368 11385212928 1994700720 19.581 100 67 134 2 2038161680 23036480 20424480
14:39:01 4189 8192000000 10941596880 11370135552 1971023072 19.394 99 67 134 1 2016133776 24928736 20181968
14:39:14 15431 8192000000 10946741440 11376754688 1990862608 19.551 100 63 124 0 2032956176 23673200 18420368
14:39:55 5893 8192000000 10948475280 11386142720 1980935520 19.472 99 50 99 0 2022935952 26497568 15502864
14:40:09 13272 8192000000 10931060976 11369005056 1978858800 19.456 100 52 103 1 2021262400 26818448 15585152
14:40:33 5250 8192000000 10922024896 11355844608 1944199696 19.180 98 46 92 2 1985922624 26962480 14760448
14:40:47 10182 8192000000 10937471040 11361370112 1973266448 19.411 100 60 119 2 2015889424 24642400 17980576
14:41:04 9306 8192000000 10941432816 11375820800 1984902448 19.503 100 48 96 0 2028207872 27896144 15409280
14:41:26 12769 8192000000 10947226240 11382214656 1988247600 19.530 100 57 114 0 2035125408 29334224 17543584
14:41:45 5285 8192000000 10942820192 11372806144 1980247968 19.467 99 58 116 1 2027957728 29890544 17819216
14:41:59 3806 8192000000 10952881552 11370426368 1965085856 19.346 99 82 164 0 2022079456 32054016 24939584
14:42:10 3246 8192000000 10974260096 11387727872 1989230064 19.538 100 72 144 1 2045660304 34842768 21587472
14:42:21 2095 8192000000 10953715616 11362549760 1971337344 19.396 99 90 176 0 2033983472 36099776 26546352
14:42:31 4815 8192000000 10952257104 11376005120 1968086928 19.370 99 73 147 1 2028371520 37644032 22640560
14:42:44 5575 8192000000 10953829824 11372777472 1975824304 19.432 100 83 164 1 2040874672 39286240 25764128
14:42:57 3488 8192000000 10949584112 11371106304 1972459664 19.405 100 78 156 2 2036350992 39643728 24247600
14:43:08 1753 8192000000 10955152960 11371958272 1974744576 19.423 100 71 141 2 2035359056 38646032 21968448
14:43:18 3738 8192000000 10948335856 11370663936 1970337088 19.388 100 66 132 0 2029604592 38584800 20682704
14:43:28 3351 8192000000 10964216048 11381911552 1968852704 19.376 99 86 172 0 2033700784 38093568 26754512
14:43:40 1623 8192000000 10963063216 11371241472 1964705680 19.343 99 86 170 1 2028784800 38604528 25474592
14:43:48 3634 8192000000 10953710208 11367518208 1954513328 19.262 99 88 175 1 2020365312 38350528 27501456
14:43:59 6197 8192000000 10929362672 11357487104 1947607664 19.207 99 57 114 3 2003454304 37973568 17873072
14:44:14 4058 8192000000 10950551472 11365707776 1965264256 19.348 100 76 149 1 2027834224 39445824 23124144
14:44:25 3734 8192000000 10944670304 11361660928 1949471168 19.222 99 72 144 1 2013392736 41208096 22713472
14:44:39 5571 8192000000 10946846304 11361099776 1956923520 19.282 100 71 141 0 2024856544 45238368 22694656
14:44:53 3872 8192000000 10964197568 11379773440 1973461952 19.413 100 80 159 0 2045506032 47404288 24639792
14:45:06 3122 8192000000 10971714352 11386028032 1978011504 19.449 100 81 163 1 2051892976 48429408 25452064
14:45:17 3399 8192000000 10965452976 11372175360 1965817152 19.352 100 87 173 0 2043520288 50677168 27025968
14:45:30 1368 8192000000 10977533536 11381723136 1972591632 19.406 100 91 182 1 2053721248 52665056 28464560
14:45:38 1749 8192000000 10984524256 11390922752 1979023824 19.457 100 86 171 1 2060021712 54588848 26409040
14:45:48 4608 8192000000 10989539344 11397709824 1984139792 19.497 100 88 176 0 2065342400 54213904 26988704
14:46:00 2386 8192000000 10971912832 11382718464 1962643744 19.327 99 86 168 1 2042492960 54194496 25654720
14:46:09 2190 8192000000 10956273312 11367981056 1954712336 19.264 99 87 175 0 2037229440 55188832 27328272
14:46:18 3539 8192000000 10939502768 11360329728 1948049824 19.211 99 60 119 1 2014356336 47614736 18691776
14:46:31 7236 8192000000 10962925184 11374153728 1970383936 19.388 100 76 150 2 2039382400 45642656 23355808
14:46:45 2543 8192000000 10973497712 11380764672 1970109904 19.386 100 83 165 0 2044069968 47595008 26365056
14:46:55 1972 8192000000 10987933568 11393396736 1984942992 19.504 100 93 186 0 2063741392 49688752 29109648
14:47:04 981 8192000000 10993103808 11397103616 1995619776 19.588 100 96 190 5 2077294048 50876208 30798064
14:47:13 2398 8192000000 10979499056 11391463424 1980500160 19.469 100 80 161 2 2057612144 51364000 25747984
14:47:25 4632 8192000000 10979852032 11399057408 1982131840 19.482 100 79 158 0 2059816048 52320144 25364064
14:47:36 3724 8192000000 10975637552 11391119360 1975531408 19.429 100 79 158 3 2055688816 54159616 25997792
14:47:50 3302 8192000000 10979623872 11388284928 1975002192 19.425 100 81 163 4 2055480368 54656736 25821440
14:48:04 2320 8192000000 10988910160 11401834496 1986680560 19.518 100 82 164 1 2070363872 56154432 27528880
14:48:15 1297 8192000000 10995495632 11402444800 1985202128 19.506 100 92 185 2 2073562880 58219440 30141312
14:48:27 2139 8192000000 10997225168 11400351744 1976855904 19.440 100 89 178 2 2068301264 61998656 29446704
14:48:36 4277 8192000000 10993389008 11405836288 1981116144 19.474 100 81 161 1 2072882816 65563040 26203632
14:48:48 3143 8192000000 11001398784 11411599360 1984981776 19.504 100 89 176 1 2079805232 65574624 29248832
14:48:59 1957 8192000000 11007732352 11421405184 1993165488 19.569 100 81 162 4 2089946448 70080656 26700304
14:49:09 3657 8192000000 11007441424 11425542144 1992106304 19.560 100 82 164 1 2089204368 70611568 26486496
14:49:19 2063 8192000000 11007089696 11423551488 1995773696 19.589 100 85 169 1 2095043936 71601712 27668528
14:49:30 2526 8192000000 11018726384 11438379008 1997420080 19.602 100 76 151 0 2097552336 75720336 24411920
14:49:44 14717 8192000000 10976323984 11413061632 1974539136 19.421 99 50 98 1 2049486416 57099776 17847504
14:50:06 10084 8192000000 10958239296 11393466368 1944332672 19.181 98 46 92 0 2018481088 58418320 15730096
14:50:25 11965 8192000000 10962891392 11407491072 1975157760 19.426 100 48 96 0 2052219984 60664464 16397760
14:50:44 13251 8192000000 10962540048 11388510208 1954504064 19.262 99 53 104 0 2027661024 54560800 18596160
14:51:04 35257 8192000000 10954113024 11394183168 1973930736 19.417 100 42 84 1 2040034192 51522400 14581056
14:51:50 5222 8192000000 10968538480 11405512704 1982064880 19.481 100 46 92 3 2052983728 55112048 15806800
14:52:16 13480 8192000000 10963405168 11411611648 1983433616 19.492 100 39 78 0 2050355904 53557280 13365008
14:52:41 10678 8192000000 10967625392 11413024768 1979744464 19.463 100 32 64 1 2047146848 56095856 11306528
14:53:05 22274 8192000000 10954876256 11421351936 1978328688 19.451 100 29 58 1 2041765872 53453056 9984128
14:53:57 19181 8192000000 10957209504 11415150592 1971198768 19.395 100 22 44 1 2040218672 61138768 7881136
14:55:34 28235 8192000000 10942137232 11421323264 1943282192 19.173 100 18 36 0 2020192496 70093696 6816608
14:56:18 81997 8192000000 10888229840 11354734592 1914241264 18.941 98 15 30 0 1939349696 21397168 3711264
14:57:50 76615 8192000000 10874479792 11329478656 1859300736 18.498 95 15 30 0 1883525616 19881712 4343168
15:01:29 103417 8192000000 10847747680 11321339904 1851585744 18.435 95 8 15 1 1873730816 19718160 2426912
15:03:32 120738 8192000000 10880522480 11343523840 1929230368 19.061 99 31 62 1 1947342400 9873408 8238624
15:05:48 89817 8192000000 10903736528 11362729984 1947195376 19.204 99 23 46 1 1968715744 15288320 6232048
15:07:33 183690 8192000000 10918689216 11369885696 1934878080 19.106 98 26 52 0 1958605856 16473840 7253936
15:11:54 45613 8192000000 10934431872 11395239936 1990671248 19.549 100 18 36 1 2005416304 9629936 5115120
15:12:51 32301 8192000000 10912461952 11385806848 1989632896 19.541 100 30 58 4 2006756976 8398160 8725920
15:13:30 20271 8192000000 10938980800 11393507328 1993644672 19.573 100 33 64 1 2013398144 10890784 8862688
15:14:07 50365 8192000000 10900372048 11384082432 1972012272 19.401 99 21 42 2 1989100912 11250688 5837952
15:15:12 35262 8192000000 10893478208 11367657472 1959950288 19.306 99 7 14 0 1968757536 7055056 1752192
15:15:54 39002 8192000000 10894679552 11367096320 1958911504 19.297 99 10 20 0 1967806160 6061920 2832736
15:16:50 63682 8192000000 10890319104 11366891520 1970725072 19.391 100 19 39 0 1984617648 8719968 5172608
15:18:03 44360 8192000000 10899787744 11381436416 1979195120 19.458 100 14 28 0 1992542752 9589792 3757840
15:18:56 16426 8192000000 10894840208 11384184832 1979301536 19.459 100 7 14 1 1991068272 9695344 2071392
15:19:32 72541 8192000000 10911933520 11373412352 1981529776 19.477 100 22 44 0 1994247472 6251344 6466352
15:20:50 56709 8192000000 10902015904 11381239808 1983357968 19.491 100 10 20 1 1994562160 8549136 2655056
15:21:54 47938 8192000000 10872397408 11364274176 1920938096 18.994 97 12 24 0 1933541616 9277952 3325568
15:22:50 44787 8192000000 10879366896 11367321600 1930518528 19.071 98 4 8 0 1940158736 8666848 973360
15:23:42 62220 8192000000 10896873296 11373051904 1955681552 19.272 99 17 33 0 1969834336 8959008 5193776
15:24:53 51893 8192000000 10910928672 11390943232 1980887856 19.472 100 19 38 0 1994695232 7697888 6109488
15:25:51 44303 8192000000 10911378768 11380285440 1954674480 19.264 98 30 60 2 1971568960 8805248 8089232
15:26:45 24343 8192000000 10907663360 11371421696 1958912192 19.297 99 27 54 0 1974561456 8465120 7184144
15:27:16 11525 8192000000 10933780512 11379040256 1960831408 19.313 99 46 92 0 1985984448 12154976 12998064
15:27:35 38340 8192000000 10906880192 11373637632 1944714368 19.184 98 41 82 1 1971390800 15572448 11103984
15:28:20 74911 8192000000 10900378560 11393466368 1912945840 18.930 97 23 46 1 1936868944 17405920 6517184
15:29:56 58641 8192000000 10910708272 11385823232 1937483248 19.127 98 15 28 1 1959617504 18507008 3627248
15:31:01 92135 8192000000 10876544176 11359895552 1838922384 18.332 93 13 26 1 1856158528 14302656 2933488
15:32:39 68263 8192000000 10911486576 11363995648 1927062864 19.043 97 25 50 2 1943426128 9519152 6844112
15:33:58 60211 8192000000 10931525568 11417395200 1991262880 19.554 100 17 34 3 2015139456 18969648 4906928
15:35:06 101340 8192000000 10889394224 11370209280 1803488256 18.043 91 16 32 1 1827633584 19110912 5034416
15:36:54 123972 8192000000 10860406128 11324678144 1851743648 18.436 94 8 16 1 1864890656 10536864 2610144
15:39:12 67009 8192000000 10869741088 11318657024 1849594336 18.419 95 32 64 3 1865513424 6984944 8934144
15:40:27 63982 8192000000 10886026080 11339456512 1906768512 18.881 98 43 86 0 1932935248 14123040 12043696
15:41:37 23666 8192000000 10886927552 11345596416 1946612112 19.199 100 38 76 2 1972013040 14732656 10668272
15:42:09 62089 8192000000 10834851552 11315585024 1854851904 18.462 96 24 48 2 1878088928 15899664 7337360
15:43:17 68969 8192000000 10834767872 11326603264 1880215008 18.667 98 7 14 0 1896013408 14230784 1567616
15:44:32 9945 8192000000 10841438320 11331194880 1916381552 18.958 100 6 12 0 1936448032 18651472 1415008
15:44:48 47290 8192000000 10845652400 11316436992 1888423088 18.733 98 14 28 1 1905787776 12966992 4397696
15:45:45 63874 8192000000 10846784064 11319017472 1926354432 19.038 100 17 35 0 1938869792 7653984 4861376
15:46:56 86819 8192000000 10852066880 11332624384 1902396704 18.846 98 23 45 0 1919965712 10540944 7028064
15:48:41 25529 8192000000 10865980352 11343216640 1942112672 19.164 100 22 44 0 1961377376 13045088 6219616
15:49:27 31065 8192000000 10841483312 11312103424 1904385360 18.862 98 26 52 0 1921855744 10137856 7332528
15:50:09 71224 8192000000 10851947632 11335221248 1907398160 18.886 98 11 23 0 1918338848 7104864 3835824
15:51:42 44756 8192000000 10881244352 11351433216 1955077984 19.267 100 19 38 0 1969919728 9647568 5194176
15:52:33 54225 8192000000 10887660800 11363635200 1947036384 19.203 99 27 54 0 1968619552 14000176 7582992
15:53:46 22944 8192000000 10897328592 11366825984 1952904928 19.250 99 34 67 0 1976092288 13682864 9504496
15:54:24 35075 8192000000 10902181824 11364118528 1954522496 19.262 99 24 49 1 1980217168 18494608 7200064
15:55:09 72443 8192000000 10912067360 11368357888 1931389520 19.078 98 18 36 2 1949702896 13049392 5263984
15:56:31 35550 8192000000 10896271824 11366535168 1955292592 19.269 100 30 60 0 1977445312 13663120 8489600
15:57:13 54611 8192000000 10894168656 11363827712 1908412880 18.894 97 19 38 1 1923630832 10486064 4731888
15:58:13 29997 8192000000 10911259968 11374460928 1957634320 19.287 99 39 77 0 1977014912 9557520 9823072
15:58:52 18512 8192000000 10923731664 11388231680 1973317024 19.412 99 40 80 0 2002696576 17855040 11524512
15:59:23 33496 8192000000 10924812816 11388727296 1962952672 19.330 99 25 49 2 1990100912 19796832 7351408
16:00:03 78114 8192000000 10918526656 11412660224 1962368096 19.325 99 10 20 1 1997748528 32438240 2942192
16:01:31 66592 8192000000 10918021680 11402227712 1974198800 19.419 100 11 22 0 2007927888 30880784 2848304
16:02:46 53420 8192000000 10927818416 11385798656 1952484832 19.246 99 29 58 1 1974874640 14242704 8147104
16:03:47 10131 8192000000 10937035440 11389243392 1988338128 19.531 100 47 92 0 2013224144 11883328 13002688
16:04:09 14095 8192000000 10927028272 11390861312 1974088912 19.418 99 41 82 0 2002323232 16346576 11887744
16:05:47 86125 8192000000 10911630528 11373588480 1941630976 19.160 98 23 46 0 1963042432 15154064 6257392
16:07:19 62236 8192000000 10888113776 11339952128 1896815584 18.801 96 28 56 1 1912708384 7809328 8083472
16:08:31 44655 8192000000 10912689424 11368566784 1955702688 19.272 99 58 116 0 1984998240 12660048 16635504
16:09:26 11817 8192000000 10913834368 11372589056 1969223600 19.379 100 49 98 1 1995911664 12838224 13849840
16:09:45 39671 8192000000 10888854016 11370385408 1970105120 19.386 100 29 57 0 1990107040 12158304 7843616
16:10:31 26925 8192000000 10906803888 11378036736 1973352704 19.412 100 13 26 2 1985430576 8457392 3620480
16:11:04 43138 8192000000 10897523120 11379400704 1959535136 19.302 99 14 27 0 1969170848 6173952 3461760
16:12:01 41365 8192000000 10907384208 11371589632 1937582720 19.127 98 13 25 0 1949322176 8301088 3438368
16:12:50 47068 8192000000 10886993856 11365244928 1953782400 19.257 99 36 72 0 1976787424 12633376 10371648
16:14:39 54246 8192000000 10906209120 11383209984 1971742896 19.399 100 19 38 0 1994056800 16650032 5663872
16:15:53 75858 8192000000 10894062400 11385901056 1954307152 19.261 99 13 26 0 1976095776 17811056 3977568
16:17:15 96757 8192000000 10884997168 11371368448 1872656816 18.606 95 11 22 0 1890125584 14402144 3066624
16:18:58 41715 8192000000 10899374112 11370819584 1950437856 19.230 99 20 40 1 1968721552 12711024 5572672
16:19:47 42114 8192000000 10913899744 11369476096 1942441232 19.166 99 24 48 3 1961272352 11684336 7146784
16:20:36 81198 8192000000 10872718768 11359719424 1869891616 18.583 95 17 34 1 1885988752 11283856 4813280
16:22:04 83349 8192000000 10860793360 11337048064 1852763760 18.445 95 17 34 0 1869152784 11889056 4499968
16:23:34 51718 8192000000 10880321392 11339870208 1896781472 18.800 97 21 43 0 1916419808 13390304 6248032
16:24:36 61638 8192000000 10839082544 11307352064 1851724928 18.436 96 27 54 2 1873116464 14148208 7243328
16:25:49 93100 8192000000 9840809056 10196451328 933221616 10.226 48 11 21 0 942192784 6091952 2879216

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 09-02-2021 16:28:08 to 09-02-2021 16:28:40.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 107 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 09-02-2021 16:28:41 to 09-02-2021 16:28:43.

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          238652
MON$OLDEST_ACTIVE               238653
MON$OLDEST_SNAPSHOT             238653
MON$NEXT_TRANSACTION            238653
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                       2054368
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

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

Database validation

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

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

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

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

09.02.21 16:28:44. 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-02-09 16:28:46 No severe PSQL-related problems occured
09.02.21 16:28:47. End of report.