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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 58e1ddde69c44dad93d327777e5becec
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-05-09 08:45
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 4793.92
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 17259512 kB
MemAvailable 31398408 kB
Buffers 0 kB
Cached 14372640 kB
SwapCached 0 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-06-11 01:27:34
DTS_END                         2021-06-11 01:27:34.5840
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> X_MAKE_QSTORNO_1000_1200(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/44312
TRN_ID                          239006
ATT_ID                          681
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: 9381.92 25500 1125830
customer order: creation 171.60 359 20592
customer order: refuse 14.98 355 1798
order to supplier: creation 45.83 1297 5499
order to supplier: removal 3.40 112198 408
invoice (draft): creation 45.88 3355 5505
invoice (draft): removal 53.39 883 6407
invoice accept: apply 42.42 20749 5090
invoice accept: cancel 48.28 793 5793
customer reserve: creation 3924.10 204 470892
customer reserve: removal 4724.08 62 566890
realization accept: apply 83.62 164 10034
realization accept: cancel 93.76 107 11251
payment from customer: creation 58.96 96 7075
payment from customer: removal 6.18 87 741
payment to supplier: creation 49.49 104 5939
payment to supplier: removal 3.47 60 416
service: total inventory turnovers 5.00 1158 600
service: total monetary turnovers 6.63 29 795
service: aggregate perf. data 0.84 20010 101
service: refresh index statistics 0.03 347921 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-06-2021 01:28:35 to 11-06-2021 01:28:37.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3625
TEST_TIME 2 3750
TEST_TIME 3 4698
TEST_TIME 4 4669
TEST_TIME 5 5255
TEST_TIME 6 5417
TEST_TIME 7 5630
TEST_TIME 8 5742
TEST_TIME 9 5562
TEST_TIME 10 5796
TEST_TIME 11 5994
TEST_TIME 12 6370
TEST_TIME 13 6470
TEST_TIME 14 6597
TEST_TIME 15 7284
TEST_TIME 16 7252
TEST_TIME 17 7758
TEST_TIME 18 7750
TEST_TIME 19 7699
TEST_TIME 20 7635
TEST_TIME 21 8553
TEST_TIME 22 8410
TEST_TIME 23 8890
TEST_TIME 24 8942
TEST_TIME 25 9237
TEST_TIME 26 9403
TEST_TIME 27 9800
TEST_TIME 28 10420
TEST_TIME 29 11269
TEST_TIME 30 11015
TEST_TIME 31 11098
TEST_TIME 32 11016
TEST_TIME 33 10800
TEST_TIME 34 10735
TEST_TIME 35 10561
TEST_TIME 36 10575
TEST_TIME 37 10387
TEST_TIME 38 10307
TEST_TIME 39 10174
TEST_TIME 40 10131
TEST_TIME 41 10173
TEST_TIME 42 10346
TEST_TIME 43 10177
TEST_TIME 44 10108
TEST_TIME 45 10013
TEST_TIME 46 9939
TEST_TIME 47 9959
TEST_TIME 48 10109
TEST_TIME 49 10112
TEST_TIME 50 10050
TEST_TIME 51 10032
TEST_TIME 52 9972
TEST_TIME 53 9988
TEST_TIME 54 10008
TEST_TIME 55 10009
TEST_TIME 56 9981
TEST_TIME 57 9956
TEST_TIME 58 10099
TEST_TIME 59 10082
TEST_TIME 60 10040
TEST_TIME 61 9930
TEST_TIME 62 9803
TEST_TIME 63 9796
TEST_TIME 64 9762
TEST_TIME 65 9711
TEST_TIME 66 9825
TEST_TIME 67 9758
TEST_TIME 68 9663
TEST_TIME 69 9579
TEST_TIME 70 9688
TEST_TIME 71 9722
TEST_TIME 72 9699
TEST_TIME 73 9670
TEST_TIME 74 9736
TEST_TIME 75 9685
TEST_TIME 76 9672
TEST_TIME 77 9676
TEST_TIME 78 9864
TEST_TIME 79 9806
TEST_TIME 80 9764
TEST_TIME 81 9852
TEST_TIME 82 9848
TEST_TIME 83 9852
TEST_TIME 84 9844
TEST_TIME 85 9741
TEST_TIME 86 9730
TEST_TIME 87 9675
TEST_TIME 88 9706
TEST_TIME 89 9664
TEST_TIME 90 9674
TEST_TIME 91 9626
TEST_TIME 92 9552
TEST_TIME 93 9472
TEST_TIME 94 9552
TEST_TIME 95 9533
TEST_TIME 96 9503
TEST_TIME 97 9550
TEST_TIME 98 9501
TEST_TIME 99 9571
TEST_TIME 100 9562
TEST_TIME 101 9564
TEST_TIME 102 9544
TEST_TIME 103 9594
TEST_TIME 104 9613
TEST_TIME 105 9620
TEST_TIME 106 9633
TEST_TIME 107 9599
TEST_TIME 108 9559
TEST_TIME 109 9547
TEST_TIME 110 9486
TEST_TIME 111 9488
TEST_TIME 112 9460
TEST_TIME 113 9435
TEST_TIME 114 9397
TEST_TIME 115 9382
TEST_TIME 116 9395
TEST_TIME 117 9403
TEST_TIME 118 9393
TEST_TIME 119 9438
TEST_TIME 120 9383

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 11-06-2021 01:28:39 to 11-06-2021 01:28:42.

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 1561313 1561313 0 0.00 0 12125 7 0 0
doc_list_biud 1561313 1561313 0 0.00 0 81341 29 0 0
sp_add_invoice_to_stock 5243 5090 153 2.91 29 179040 20750 0 153
sp_cancel_adding_invoice 5793 5793 0 0.00 5 68754 794 0 0
sp_cancel_client_order 1798 1798 0 0.00 4 17497 355 0 0
sp_cancel_customer_reserve 566890 566890 0 0.00 1 42725 63 0 0
sp_cancel_pay_from_customer 741 741 0 0.00 3 4682 88 0 0
sp_cancel_pay_to_supplier 416 416 0 0.00 3 2825 61 0 0
sp_cancel_supplier_invoice 6420 6407 13 0.20 1 81352 884 0 13
sp_cancel_supplier_order 408 408 0 0.00 11 1040228 112198 0 0
sp_cancel_write_off 11251 11251 0 0.00 1 11549 108 0 0
sp_client_order 20592 20592 0 0.00 3 40680 360 0 0
sp_customer_reserve 470892 470892 0 0.00 0 40813 205 0 0
sp_fill_shopping_cart 31575 31575 0 0.00 1 11350 39 0 0
sp_fill_shopping_cart_clo_res 470888 470888 0 0.00 0 16178 15 0 0
sp_get_clo_for_invoice 5083 5083 0 0.00 0 20289 284 0 0
sp_kill_cost_storno 18201 18201 0 0.00 0 9175 57 0 0
sp_kill_qstorno_ret_qs2qd 1151846 1151846 0 0.00 0 81337 34 0 0
sp_kill_qty_storno 607663 607663 0 0.00 0 81339 73 0 0
sp_lock_selected_doc 21010 21010 0 0.00 0 7137 5 0 0
sp_make_cost_storno 28130 28130 0 0.00 0 9851 46 0 0
sp_multiply_rows_for_pdistr 28130 28130 0 0.00 0 9465 26 0 0
sp_multiply_rows_for_qdistr 20592 20592 0 0.00 0 40667 161 0 0
sp_pay_from_customer 7075 7075 0 0.00 3 7696 97 0 0
sp_pay_to_supplier 5939 5939 0 0.00 4 9785 104 0 0
sp_payment_common 13014 13014 0 0.00 1 6053 19 0 0
sp_qd_handle_on_cancel_clo 1798 1798 0 0.00 0 17485 324 0 0
sp_qd_handle_on_invoice_upd_sts 10875 10875 0 0.00 0 19237 333 0 0
sp_qd_handle_on_reserve_upd_sts 10034 10034 0 0.00 0 18343 56 0 0
sp_reserve_write_off 10034 10034 0 0.00 6 18357 165 0 0
sp_supplier_invoice 5505 5505 0 0.00 5 81348 3355 0 0
sp_supplier_order 5499 5499 0 0.00 5 28955 1297 0 0
srv_aggregate_perf_data 101 101 0 0.00 2598 227736 20011 0 0
srv_fill_mon_cache_memory 169 169 0 0.00 1062 124765 30106 0 0
srv_find_qd_qs_mism 1077412 1077412 0 0.00 0 11537 6 0 0
srv_make_invnt_saldo 600 600 0 0.00 18 66502 1159 0 0
srv_make_money_saldo 795 795 0 0.00 0 997 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 194120 485329 347922 0 0
t$perf-abend:sp_add_invoice_to_stock 153 153 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5090 5090 0 0.00 0 13109 194 0 0
t$perf-norm:sp_cancel_adding_invoice 394 394 0 0.00 1 14784 117 0 0
t$perf-norm:sp_cancel_client_order 1798 1798 0 0.00 0 4655 12 0 0
t$perf-norm:sp_cancel_customer_reserve 715 715 0 0.00 0 611 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 741 741 0 0.00 0 2974 17 0 0
t$perf-norm:sp_cancel_pay_to_supplier 416 416 0 0.00 0 6033 20 0 0
t$perf-norm:sp_cancel_supplier_invoice 363 363 0 0.00 0 744 16 0 0
t$perf-norm:sp_cancel_supplier_order 408 408 0 0.00 0 26275 1551 0 0
t$perf-norm:sp_cancel_write_off 1059 1059 0 0.00 0 534 4 0 0
t$perf-norm:sp_client_order 20592 20592 0 0.00 0 5879 17 0 0
t$perf-norm:sp_customer_reserve 1053 1053 0 0.00 0 2599 8 0 0
t$perf-norm:sp_pay_from_customer 7075 7075 0 0.00 0 6925 11 0 0
t$perf-norm:sp_pay_to_supplier 5939 5939 0 0.00 0 4831 11 0 0
t$perf-norm:sp_reserve_write_off 10034 10034 0 0.00 0 14308 11 0 0
t$perf-norm:sp_supplier_invoice 5505 5505 0 0.00 0 6361 20 0 0
t$perf-norm:sp_supplier_order 5499 5499 0 0.00 0 5685 17 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 473 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 169 169 0 0.00 0 4225 31 0 0
t$perf-norm:srv_make_invnt_saldo 600 600 0 0.00 0 7105 40 0 0
t$perf-norm:srv_make_money_saldo 795 795 0 0.00 0 8895 29 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 25 9 0 0
v_add_invoice_to_stock 10470 10164 306 2.92 0 6532 21 0 306
v_all_customers 37596 37596 0 0.00 0 103 1 0 0
v_all_suppliers 30666 30666 0 0.00 0 101 1 0 0
v_all_wares 41184 41184 0 0.00 0 86 1 0 0
v_cancel_adding_invoice 788 788 0 0.00 0 820 7 0 0
v_cancel_client_order 3596 3596 0 0.00 0 2903 5 0 0
v_cancel_customer_prepayment 1482 1482 0 0.00 0 4423 15 0 0
v_cancel_customer_reserve 1430 1430 0 0.00 0 4167 8 0 0
v_cancel_payment_to_supplier 832 832 0 0.00 0 2817 7 0 0
v_cancel_supplier_invoice 752 726 26 3.45 0 2852 20 0 26
v_cancel_supplier_order 816 816 0 0.00 0 2595 14 0 0
v_cancel_write_off 2118 2118 0 0.00 0 4486 18 0 0
v_max_id_clo_ord 5492 5492 0 0.00 0 504 1 0 0
v_max_id_clo_res 1053 1053 0 0.00 0 2588 14 0 0
v_max_id_ord_sup 5490 5490 0 0.00 0 4801 4 0 0
v_max_non_paid_invoice 1588 1588 0 0.00 0 280 2 0 0
v_max_non_paid_realizn 3789 3789 0 0.00 0 3694 3 0 0
v_min_id_clo_ord 5492 5492 0 0.00 0 4134 7 0 0
v_min_id_clo_res 1053 1053 0 0.00 0 1033 3 0 0
v_min_id_ord_sup 5490 5490 0 0.00 0 4495 6 0 0
v_min_non_paid_invoice 5939 5939 0 0.00 0 4858 11 0 0
v_min_non_paid_realizn 7075 7075 0 0.00 0 6051 11 0 0
v_our_firm 10160 10160 0 0.00 0 102 1 0 0
v_reserve_write_off 20068 20068 0 0.00 0 4645 6 0 0
x_lock_depdocs_on_canc_invoice 11837 11837 0 0.00 0 18850 128 0 0
x_lock_depdocs_on_canc_sup_ord 408 408 0 0.00 0 9369 395 0 0
x_make_qstorno_1000_1200 5499 5499 0 0.00 1 28949 1216 0 0
x_make_qstorno_1200_2000 5505 5505 0 0.00 2 77552 3216 0 0
x_make_qstorno_2100_3300 470892 470892 0 0.00 0 35980 187 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-06-2021 01:28:43 to 11-06-2021 01:28:47.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:38 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:44 8430 8192000000 10187521360 10480283648 778524000 8.678 63 46 92 0 796247728 2030816 15692912
22:58:00 28122 8192000000 10329772816 10644676608 1374747520 14.370 100 84 168 1 1406167232 4156528 27263184
22:58:41 29262 8192000000 10389654432 10711547904 1433284384 14.890 100 88 176 1 1468595248 6518192 28792672
22:59:19 25250 8192000000 10413478448 10741174272 1453813776 15.071 100 82 164 0 1488440944 7616224 27010944
22:59:57 13148 8192000000 10430014064 10760585216 1486662960 15.360 100 88 176 0 1523974368 8611152 28700256
23:00:18 22965 8192000000 10451059296 10782195712 1499733280 15.474 100 90 180 0 1538037584 8791856 29512448
23:00:50 13558 8192000000 10462070160 10796507136 1517223264 15.626 100 94 188 0 1556378096 9279984 29874848
23:01:16 14227 8192000000 10464437872 10804666368 1522572496 15.673 100 85 170 0 1560393360 10044288 27776576
23:01:41 22015 8192000000 10489969584 10836611072 1541492544 15.836 100 82 164 1 1577092960 9850496 25749920
23:02:12 18304 8192000000 10515624880 10864312320 1568353424 16.068 100 81 160 1 1604115808 10608720 25153664
23:02:40 19461 8192000000 10543511984 10893148160 1593280032 16.282 100 83 166 1 1629746672 10888704 25577936
23:03:08 8907 8192000000 10554576864 10912907264 1613402080 16.454 100 69 138 0 1644963168 10511920 21049168
23:03:24 10634 8192000000 10570932528 10931200000 1630243344 16.597 100 76 152 1 1664033408 10657600 23132464
23:03:44 12622 8192000000 10597291344 10959740928 1654906544 16.806 100 78 157 0 1689483296 11145520 23431232
23:04:05 10265 8192000000 10610478272 10979586048 1674242160 16.969 100 71 142 2 1706677696 11411040 21024496
23:04:22 8993 8192000000 10638705504 11004874752 1694851424 17.142 100 80 159 1 1729798336 11528784 23418128
23:04:40 9667 8192000000 10648011904 11021807616 1711771456 17.284 100 82 162 1 1748529040 12844224 23913360
23:05:00 6559 8192000000 10663719632 11036209152 1726992272 17.410 100 83 165 2 1763582432 12907712 23682448
23:05:16 7240 8192000000 10684882064 11056775168 1742428080 17.539 100 85 170 0 1779984624 12968832 24587712
23:05:31 6412 8192000000 10693592496 11072479232 1760231104 17.686 100 86 172 0 1797310480 12815072 24264304
23:05:46 5547 8192000000 10705688208 11084353536 1773884864 17.799 100 88 172 2 1811606992 13137904 24584224
23:05:58 6708 8192000000 10725331888 11102167040 1781971536 17.866 100 89 178 3 1820986352 14735040 24279776
23:06:11 4543 8192000000 10736675216 11114541056 1788772352 17.922 100 79 158 1 1825095984 14265728 22057904
23:06:23 3190 8192000000 10739987440 11119411200 1796517888 17.985 100 87 172 0 1834432144 14154128 23760128
23:06:33 4265 8192000000 10741798192 11125428224 1800634928 18.019 100 85 170 0 1838404560 14112688 23656944
23:06:44 4019 8192000000 10743215344 11122446336 1802606768 18.035 100 81 161 1 1840038064 13392800 24038496
23:06:55 3579 8192000000 10745596528 11128832000 1807643088 18.077 100 81 160 1 1842051232 12769568 21638576
23:07:06 2943 8192000000 10757359408 11134377984 1814846992 18.136 100 91 180 1 1854132352 14534720 24750640
23:07:15 8898 8192000000 10762074208 11151847424 1822694720 18.200 100 77 154 1 1857095936 13728448 20672768
23:07:32 6061 8192000000 10770225376 11158585344 1827722224 18.241 100 87 172 1 1865922256 14409856 23790176
23:07:44 2163 8192000000 10788143280 11170836480 1842296528 18.359 100 90 180 1 1882064992 14585792 25182672
23:07:53 2082 8192000000 10796839504 11182989312 1849374896 18.417 100 90 180 1 1889677648 15254192 25048560
23:08:02 2517 8192000000 10784860832 11173404672 1847225632 18.400 100 88 174 2 1886356144 14170944 24959568
23:08:11 1632 8192000000 10793993472 11179626496 1847708928 18.404 100 89 178 1 1885491152 11833328 25948896
23:08:19 2408 8192000000 10799375040 11184312320 1858167504 18.488 100 94 187 1 1896235392 11843488 26224400
23:08:28 1564 8192000000 10802155888 11191357440 1857614112 18.484 100 92 184 2 1897287728 13340128 26333488
23:08:36 1905 8192000000 10808795504 11193065472 1860954016 18.511 100 93 185 0 1900678400 13275888 26448496
23:08:44 1605 8192000000 10813135744 11199148032 1861641472 18.517 100 93 186 0 1902081376 14171856 26268048
23:08:52 1519 8192000000 10811141952 11196919808 1862370176 18.522 100 95 190 0 1903608528 14032592 27205760
23:09:00 1322 8192000000 10811706080 11198427136 1868976192 18.576 100 89 178 2 1906660704 12204576 25479936
23:09:07 1775 8192000000 10814779632 11204734976 1867627584 18.565 100 89 178 1 1905373264 11994576 25751104
23:09:15 5803 8192000000 10791318128 11205652480 1870068288 18.585 100 79 158 2 1905250656 12585664 22596704
23:09:35 21146 8192000000 10810129280 11205537792 1871335728 18.595 100 73 144 1 1901048224 8816480 20896016
23:10:03 2591 8192000000 10794563264 11210203136 1876680992 18.638 100 46 92 2 1899481664 9402464 13398208
23:10:13 3538 8192000000 10794989504 11215220736 1872890720 18.608 100 45 90 2 1896133104 9908064 13334320
23:10:23 6548 8192000000 10785177184 11208880128 1870784288 18.591 100 21 42 1 1883131136 6253328 6093520
23:10:36 7102 8192000000 10789634096 11213004800 1878228128 18.651 100 46 92 3 1899180128 8268464 12683536
23:10:50 4459 8192000000 10795889888 11219464192 1880362880 18.668 100 40 80 1 1900444304 8656976 11424448
23:11:02 7110 8192000000 10789379680 11215257600 1881155712 18.674 100 26 53 0 1895949680 6304192 8489776
23:11:17 6334 8192000000 10792436736 11221839872 1885680592 18.711 100 32 63 2 1901133200 6373888 9078720
23:11:33 9769 8192000000 10788398752 11221504000 1882271760 18.683 100 12 24 0 1891699648 5920128 3507760
23:11:51 9560 8192000000 10787224816 11221684224 1887052688 18.722 100 20 39 2 1898464768 5764544 5647536
23:12:08 9781 8192000000 10787003008 11225493504 1887158416 18.723 100 19 36 2 1898784864 6797056 4829392
23:12:24 12857 8192000000 10787320208 11225616384 1884483104 18.701 100 15 30 2 1894682880 5660944 4538832
23:12:47 62417 8192000000 10847800624 11248431104 1897675104 18.808 100 55 112 1 1920705952 6269744 16761104
23:13:55 7895 8192000000 10801287424 11239456768 1895553376 18.791 100 28 54 2 1910533536 7504768 7475392
23:14:11 10345 8192000000 10815254240 11243978752 1895723296 18.792 100 20 40 0 1906792656 5853840 5215520
23:14:29 4607 8192000000 10816333008 11251175424 1897995152 18.810 100 30 60 0 1914164048 7461392 8707504
23:14:42 5198 8192000000 10807995600 11245826048 1898796368 18.817 100 26 52 1 1913424464 6461696 8166400
23:14:55 7640 8192000000 10824039280 11248984064 1900944224 18.834 100 31 60 2 1915553872 5864752 8744896
23:15:09 6233 8192000000 10813449280 11248480256 1898871232 18.817 100 20 40 0 1910733088 6174656 5687200
23:15:22 8486 8192000000 10819959248 11252445184 1901137840 18.835 100 17 34 0 1915606960 9461584 5007536
23:15:37 9818 8192000000 10824368608 11255242752 1902749520 18.848 100 21 42 0 1913744800 4861056 6134224
23:15:57 5432 8192000000 10823921296 11259932672 1906060624 18.875 100 21 42 0 1922733952 10213120 6460208
23:16:08 5402 8192000000 10827649760 11261304832 1906799104 18.881 100 25 49 1 1920342272 6856480 6686688
23:16:21 10310 8192000000 10825020128 11260272640 1910291248 18.909 100 21 42 4 1923169216 6124256 6753712
23:16:41 21299 8192000000 10803709984 11224236032 1843260640 18.367 97 23 46 1 1855664448 5566656 6837152
23:17:08 70014 8192000000 10792066112 11229065216 1842145264 18.358 97 24 48 0 1854560416 4930928 7484224
23:18:25 7472 8192000000 10791145712 11217539072 1844927840 18.381 98 23 46 0 1857554112 6038224 6588048
23:18:42 4593 8192000000 10810094224 11229450240 1881409024 18.676 100 31 60 1 1897291072 7879568 8002480
23:18:53 5498 8192000000 10772778304 11199201280 1833766176 18.290 98 26 51 2 1846608608 5821024 7021408
23:19:07 7584 8192000000 10763806528 11195334656 1811937856 18.112 97 25 50 2 1824580976 5525952 7117168
23:19:21 6526 8192000000 10768892592 11188916224 1844431024 18.377 100 22 44 3 1857366624 6611600 6324000
23:19:35 8296 8192000000 10741755152 11168800768 1755665424 17.649 94 28 56 3 1769481168 5798624 8017120
23:19:50 7120 8192000000 10759848624 11191242752 1831490960 18.271 99 19 38 1 1842480048 5877040 5112048
23:20:03 8464 8192000000 10686263328 11110604800 1673484192 16.963 91 22 44 1 1685277168 4772256 7020720
23:20:20 10547 8192000000 10724320400 11144032256 1767258432 17.744 97 25 50 0 1780009968 5539360 7212176
23:20:37 12661 8192000000 10709188304 11118645248 1686095888 17.069 93 25 48 2 1698852336 5126112 7630336
23:20:56 13296 8192000000 10711355840 11128115200 1742307328 17.538 96 15 30 0 1752025904 5734240 3984336
23:21:18 5522 8192000000 10671480960 11082600448 1718473568 17.339 97 30 60 1 1733450800 5692752 9284480
23:21:32 48261 8192000000 10730955664 11131240448 1703520400 17.215 95 24 47 1 1719383616 9094144 6769072
23:22:26 52371 8192000000 10707524864 11125276672 1699285168 17.179 94 28 54 0 1712840144 5668704 7886272
23:23:26 8998 8192000000 10727772624 11149901824 1812670800 18.118 100 32 64 1 1828017024 6526000 8820224
23:23:44 4435 8192000000 10731746800 11151007744 1815248928 18.139 100 21 42 2 1827188864 5954704 5985232
23:23:55 10629 8192000000 10755919664 11171610624 1831233216 18.269 100 26 52 3 1844528768 6307472 6988080
23:24:13 6420 8192000000 10752137312 11176161280 1837767040 18.323 100 25 50 1 1851307536 6244192 7296304
23:24:27 7708 8192000000 10759377200 11181789184 1842220096 18.359 100 23 46 0 1854645040 5509200 6915744
23:24:42 9480 8192000000 10760335888 11185479680 1848089248 18.407 100 30 60 4 1862920384 6080624 8750512
23:24:58 12729 8192000000 10769949984 11191324672 1851227568 18.432 100 32 63 1 1866545808 5511552 9806688
23:25:17 8852 8192000000 10772219024 11198631936 1853245536 18.448 100 19 38 2 1863754512 5056352 5452624
23:25:33 6840 8192000000 10778970704 11193982976 1840441984 18.344 99 28 56 0 1854243376 4485920 9315472
23:25:46 7455 8192000000 10771208816 11199688704 1859533264 18.499 100 29 58 1 1874629168 7037728 8058176
23:26:00 9192 8192000000 10773286752 11201433600 1860695104 18.509 100 19 38 0 1871382784 5512272 5175408
23:26:17 13008 8192000000 10774460112 11205754880 1863046112 18.528 100 14 28 1 1872081520 5434272 3601136
23:26:36 8023 8192000000 10777450576 11212865536 1869883520 18.583 100 21 41 2 1881774592 6499056 5392016
23:26:53 11416 8192000000 10790808192 11220992000 1877964496 18.649 100 34 67 1 1893785904 5066976 10754432
23:27:11 90681 8192000000 10838257376 11261038592 1900805808 18.833 100 37 73 1 1916595744 5226768 10563168
23:28:59 2882 8192000000 10867813456 11282649088 1923761888 19.017 100 62 124 2 1953474496 12713712 16998896
23:29:09 22194 8192000000 10872071296 11289382912 1931506272 19.079 100 63 126 2 1959501664 9946336 18049056
23:29:38 40175 8192000000 10866798528 11301830656 1940231056 19.149 100 51 102 1 1967018000 12310624 14476320
23:30:30 21104 8192000000 10891545968 11313639424 1951920464 19.242 100 58 116 0 1983499968 15351104 16228400
23:30:59 16210 8192000000 10897537568 11320336384 1955675056 19.272 100 62 125 0 1989370928 15164880 18530992
23:31:32 9993 8192000000 10905323648 11329638400 1962436336 19.325 100 59 118 0 1997424176 18542912 16444928
23:31:48 10131 8192000000 10914282192 11334594560 1966596144 19.358 100 61 122 0 2003819328 19579056 17644128
23:32:11 4027 8192000000 10920005024 11345137664 1974528432 19.421 100 68 136 2 2013960544 19818464 19613648
23:32:23 4006 8192000000 10923285616 11343310848 1973988880 19.417 100 65 128 1 2010904928 18513088 18402960
23:32:35 14980 8192000000 10908656432 11343716352 1975279760 19.427 100 54 108 1 2010694896 19399520 16015616
23:33:03 14839 8192000000 10923365552 11356622848 1981832736 19.479 100 49 98 0 2018108528 21970464 14305328
23:33:28 4700 8192000000 10930017392 11358302208 1985126992 19.505 100 54 108 1 2022514784 21602672 15785120
23:33:51 11506 8192000000 10925274112 11361771520 1985129536 19.505 100 56 112 2 2025720976 23250896 17340544
23:34:25 7259 8192000000 10942346368 11374690304 1994463952 19.579 100 49 98 3 2031810528 22329312 15017264
23:34:41 23575 8192000000 10944849552 11386150912 2000965648 19.630 100 62 124 1 2042462720 22600544 18896528
23:35:18 13938 8192000000 10947599392 11393216512 2004972576 19.662 100 38 76 2 2039785056 23953312 10859168
23:35:39 15536 8192000000 10963349952 11401330688 2008938192 19.693 100 48 96 1 2049503088 25495152 15069744
23:36:02 3972 8192000000 10961154464 11398406144 2005186448 19.664 100 41 82 0 2045616320 27536832 12893040
23:36:12 3871 8192000000 10955763216 11384242176 1997836816 19.606 100 66 128 1 2045630752 28879920 18914016
23:36:27 7924 8192000000 10962290288 11393081344 2004033216 19.655 100 63 126 3 2053486880 30596848 18856816
23:36:43 4559 8192000000 10967636256 11385094144 1999910288 19.622 100 67 133 0 2049518080 29973808 19633984
23:37:00 5099 8192000000 10987458752 11401879552 2014848208 19.740 100 79 157 1 2071324528 33309488 23166832
23:37:12 4644 8192000000 10987428000 11405017088 2016300496 19.751 100 82 161 1 2074919504 34567008 24052000
23:37:24 1441 8192000000 10990906736 11410567168 2016622864 19.754 100 76 152 3 2072856784 33466832 22767088
23:37:34 10652 8192000000 10983932000 11413704704 2018852384 19.771 100 75 150 2 2073824832 33135712 21836736
23:37:52 5919 8192000000 10999539664 11415502848 2022445712 19.799 100 79 155 0 2079733008 34254384 23032912
23:38:06 2622 8192000000 10997120368 11419025408 2023391840 19.807 100 88 175 0 2084261248 34676992 26192416
23:38:15 2566 8192000000 10994988976 11420246016 2023445552 19.807 100 74 146 0 2080454288 35281824 21726912
23:38:26 4686 8192000000 10986628368 11412402176 2016084720 19.749 100 88 176 3 2078974272 36246000 26643552
23:38:39 8706 8192000000 10978386592 11406024704 1995621232 19.588 99 66 129 1 2052996528 37526688 19848608
23:38:58 5320 8192000000 10978682464 11414806528 2013418016 19.728 100 65 130 1 2070678384 36877104 20383264
23:39:14 9764 8192000000 10994276688 11423481856 2022590688 19.800 100 69 135 0 2081583232 37970880 21021664
23:39:31 5160 8192000000 10993470192 11422580736 2023766576 19.810 100 69 136 0 2080751392 36529648 20455168
23:39:44 1781 8192000000 11005953296 11431120896 2031521888 19.871 100 81 156 1 2094825680 39231568 24072224
23:39:53 3563 8192000000 11007170032 11433635840 2030100208 19.859 100 64 129 0 2089624448 39933312 19590928
23:40:04 3883 8192000000 11016679312 11444109312 2036782032 19.912 100 76 152 1 2101297040 41434784 23080224
23:40:15 3915 8192000000 11017499216 11445194752 2041229088 19.947 100 77 154 0 2106912256 42062272 23620896
23:40:27 2112 8192000000 11005826848 11427938304 2021499536 19.792 99 87 169 3 2090703008 42884016 26319456
23:40:37 13810 8192000000 10981577136 11417993216 2007693440 19.683 99 62 124 0 2069280672 42149968 19437264
23:41:02 7210 8192000000 11001391968 11433947136 2012378432 19.720 99 77 154 0 2082265280 45078192 24808656
23:41:17 3813 8192000000 10991279248 11417923584 1996765232 19.597 99 70 139 0 2062757600 44170736 21821632
23:41:31 2671 8192000000 10986583088 11408613376 1985196624 19.506 99 75 147 2 2055551776 47169648 23185504
23:41:40 3139 8192000000 10973695104 11390210048 1979856416 19.464 99 85 166 0 2054258688 48600944 25801328
23:41:50 2757 8192000000 10971864960 11393351680 1982462256 19.484 99 78 156 1 2056255712 50067584 23725872
23:42:01 2618 8192000000 10996551184 11410247680 1983833120 19.495 99 93 183 1 2064865520 52645664 28386736
23:42:12 3310 8192000000 10989685552 11411386368 1999417392 19.618 100 87 174 0 2076755936 51264608 26073936
23:42:25 2636 8192000000 10994745104 11417493504 2000092016 19.623 100 82 162 2 2074760288 50328592 24339680
23:42:35 5983 8192000000 10985461440 11405651968 1981210416 19.474 99 90 179 1 2056332512 48398272 26723824
23:42:48 4753 8192000000 10981835024 11406766080 1994968528 19.583 100 69 138 5 2065721824 49625920 21127376
23:43:01 6577 8192000000 10972499920 11397337088 1984513056 19.500 100 77 152 1 2059733376 50700736 24519584
23:43:18 3763 8192000000 10962748224 11379654656 1954328736 19.261 98 80 162 2 2031446944 49880352 27237856
23:43:34 4969 8192000000 10981111888 11403362304 1969134848 19.379 99 79 157 1 2046321040 52991280 24194912
23:43:53 3933 8192000000 10967074736 11390935040 1976738192 19.439 99 71 140 0 2057681888 58164208 22779488
23:44:07 1853 8192000000 11013255824 11424829440 1998654816 19.612 100 80 159 1 2083837600 60409376 24773408
23:44:16 1788 8192000000 11009751920 11422314496 1984372544 19.499 99 88 174 2 2073591120 61966368 27252208
23:44:27 10507 8192000000 10966780320 11391807488 1956405024 19.277 98 77 153 2 2042079600 62461888 23212688
23:44:46 3696 8192000000 10982189392 11401773056 1982801680 19.487 100 78 155 0 2065543696 58338592 24403424
23:44:58 7087 8192000000 10980985136 11396296704 1971649520 19.399 99 81 163 0 2049172720 52620592 24902608
23:45:13 2527 8192000000 10996373168 11408732160 1993966448 19.575 100 79 157 0 2071702016 54133760 23601808
23:45:22 3342 8192000000 10994500768 11411804160 1998625120 19.612 100 80 160 4 2077885856 54324720 24936016
23:45:33 2820 8192000000 11001978784 11415470080 1999048624 19.615 100 82 162 0 2077349984 54101264 24200096
23:45:45 1060 8192000000 11001014352 11413692416 1997621520 19.604 100 90 178 2 2079081472 54429248 27030704
23:45:54 4665 8192000000 10970933680 11386220544 1957361200 19.285 98 85 170 2 2038714992 55107920 26245872
23:46:07 2814 8192000000 10985234032 11401510912 1986486960 19.516 100 77 152 1 2065315888 55238896 23590032
23:46:18 1699 8192000000 10982082064 11390025728 1971203520 19.395 100 84 169 1 2054435088 56304880 26926688
23:46:26 4252 8192000000 10985084576 11400867840 1981754112 19.479 100 80 159 4 2064057888 57352208 24951568
23:46:38 3193 8192000000 11000517968 11413622784 1993996288 19.575 100 87 174 3 2081453264 60058192 27398784
23:46:48 2912 8192000000 10994864608 11409195008 1991048176 19.552 100 86 172 0 2077207440 59931744 26227520
23:46:59 4249 8192000000 11002940048 11411001344 1978802032 19.455 99 90 176 5 2066129296 60015872 27311392
23:47:13 7693 8192000000 11001735744 11416326144 1993489120 19.571 100 84 167 0 2082313120 62768560 26055440
23:47:31 1285 8192000000 11011419344 11422257152 1996714800 19.597 100 85 170 1 2086341392 63310272 26316320
23:47:39 3590 8192000000 11013820800 11421024256 1992137104 19.561 100 86 170 2 2081856736 63761104 25958528
23:47:53 2422 8192000000 11013762560 11424645120 1996556832 19.596 100 90 178 1 2090183360 66451632 27174896
23:48:02 4051 8192000000 11001883392 11418587136 1989813824 19.542 100 91 182 0 2085842992 67435968 28593200
23:48:15 1722 8192000000 10993080320 11405348864 1977567584 19.445 100 86 172 2 2072514304 68225696 26721024
23:48:23 2313 8192000000 10989488320 11409620992 1980036048 19.465 100 76 152 1 2073534080 69611648 23886384
23:48:46 14832 8192000000 10949451856 11393191936 1962121008 19.323 99 45 91 1 2026898176 49636768 15140400
23:49:23 20054 8192000000 10949333776 11395346432 1961831696 19.321 99 38 76 2 2028667808 53744288 13091824
23:49:50 6451 8192000000 10956416160 11389558784 1955528976 19.270 99 48 96 2 2028482768 57251888 15701904
23:50:06 9964 8192000000 10951719888 11396276224 1954864416 19.265 99 42 84 1 2029517696 59987408 14665872
23:50:24 20064 8192000000 10954626320 11411058688 1968705968 19.375 100 37 74 2 2042968176 60615968 13646240
23:50:52 19505 8192000000 10949855536 11398455296 1973237808 19.411 100 34 68 5 2035560896 50655424 11667664
23:51:22 26640 8192000000 10944907344 11392724992 1968809536 19.376 100 26 52 0 2033317776 55012944 9495296
23:52:04 14888 8192000000 10932156672 11376205824 1941210736 19.156 99 36 71 0 2008485808 54354896 12920176
23:52:29 8840 8192000000 10940669536 11382001664 1956794624 19.281 100 33 67 1 2021434240 52595856 12043760
23:52:58 10214 8192000000 10938653776 11389980672 1953886240 19.257 100 35 68 2 2020600016 55309632 11404144
23:53:16 15536 8192000000 10937162160 11386613760 1958168496 19.291 100 33 64 1 2027720224 58160848 11390880
23:53:40 29157 8192000000 10933220064 11396993024 1953183824 19.252 100 28 56 0 2026401920 62871040 10347056
23:54:23 27202 8192000000 10924874000 11388366848 1929318272 19.061 99 21 42 2 1991585744 54157536 8109936
23:55:06 18799 8192000000 10906088928 11365191680 1924946784 19.026 100 23 44 3 1991020096 57808176 8265136
23:55:32 15219 8192000000 10894289392 11366666240 1931836624 19.082 100 18 36 0 1987970784 49632112 6502048
23:57:01 16220 8192000000 10903415264 11331592192 1917064912 18.963 98 60 120 1 1941672944 5345488 19262544
23:57:24 38574 8192000000 10891485200 11338526720 1913174496 18.932 98 27 54 2 1933358000 12971312 7212192
23:58:15 56073 8192000000 10893058032 11367448576 1935895520 19.114 99 10 20 1 1964261472 25299728 3066224
23:59:33 68631 8192000000 10916706624 11345104896 1920705056 18.992 98 39 78 0 1947835232 15798544 11331632
00:00:51 105383 8192000000 10907010704 11347886080 1946496688 19.199 99 38 75 1 1969398112 12764864 10136560
00:02:45 51064 8192000000 10897056016 11356798976 1942104320 19.164 99 22 44 1 1959543488 11639888 5799280
00:03:51 19865 8192000000 10897800624 11367964672 1969358224 19.380 100 14 28 1 1987421424 13862704 4200496
00:04:48 54922 8192000000 10885619088 11346550784 1894952208 18.786 96 21 42 0 1914269712 13350160 5967344
00:05:50 46637 8192000000 10902897872 11372589056 1966134288 19.355 100 15 30 1 1990281152 19790432 4356432
00:06:45 34640 8192000000 10916499696 11370422272 1954632032 19.263 99 25 50 1 1982959664 19898752 8428880
00:07:26 33266 8192000000 10925343648 11364302848 1936353904 19.118 98 54 109 0 1973404464 20354432 16696128
00:08:07 19192 8192000000 10911215664 11367653376 1950855056 19.233 99 41 82 1 1984256960 20865936 12535968
00:08:37 29075 8192000000 10855722928 11326124032 1916937440 18.962 98 35 70 5 1944238912 16415680 10885792
00:10:08 55992 8192000000 10915680032 11378081792 1974003232 19.417 100 17 33 0 1992000240 12956080 5040928
00:11:14 72761 8192000000 10883331840 11361517568 1924558416 19.023 98 11 22 0 1945246704 17292624 3395664
00:12:42 67058 8192000000 10898412368 11372085248 1965612176 19.351 100 13 26 1 1988232496 18223296 4397024
00:13:55 48150 8192000000 10892240176 11374034944 1969013552 19.378 100 13 26 0 1991778448 18872480 3892416
00:14:50 69215 8192000000 10885409888 11366928384 1929541536 19.063 98 9 18 0 1945607296 13426080 2639680
00:16:06 53975 8192000000 10885774704 11363307520 1949818352 19.225 99 32 61 3 1965802368 7293488 8690528
00:17:06 82654 8192000000 10907818688 11370749952 1951144496 19.236 99 13 27 1 1964276208 9423440 3708272
00:18:35 28778 8192000000 10894598208 11345272832 1938511872 19.135 98 35 70 2 1956739904 7126368 11101664
00:19:14 21486 8192000000 10889800240 11344818176 1945359088 19.189 98 60 119 2 1971186816 8766112 17061616
00:19:54 43843 8192000000 10895354336 11361710080 1966249680 19.356 100 29 58 2 1985090640 10425120 8415840
00:20:45 36149 8192000000 10873749344 11338498048 1898830368 18.817 97 19 38 1 1917345696 13217856 5297472
00:21:28 59111 8192000000 10881879792 11354402816 1931860528 19.082 99 17 34 0 1947077136 10841872 4374736
00:22:35 71076 8192000000 10923306416 11381465088 1958861424 19.297 99 17 33 1 1975963808 11802176 5300208
00:23:56 46189 8192000000 10913925376 11385241600 1965593664 19.350 99 23 46 2 1988306960 16565408 6147888
00:25:10 85440 8192000000 10908107296 11377803264 1940105392 19.148 98 7 14 1 1953989552 12233552 1650608
00:27:12 104095 8192000000 10902058544 11364872192 1873013008 18.609 94 21 42 2 1887995856 8958560 6024288
00:29:57 94529 8192000000 10889357952 11373703168 1931882416 19.082 98 20 40 1 1956691408 18568752 6240240
00:31:38 28413 8192000000 10877326656 11354877952 1939662240 19.144 99 16 32 0 1963943664 19716496 4564928
00:32:14 51857 8192000000 10870283584 11344384000 1903617168 18.855 97 41 83 2 1934357104 19202512 11537424
00:33:14 47918 8192000000 10856504544 11340103680 1889165216 18.739 97 14 28 2 1904651728 11400304 4086208
00:35:07 92248 8192000000 10895342624 11367079936 1962229552 19.324 100 25 50 2 1981051232 11706688 7114992
00:36:46 61745 8192000000 10889046208 11384496128 1947597888 19.207 99 10 20 0 1964646144 14031344 3016912
00:38:25 66599 8192000000 10865840752 11352981504 1903258144 18.852 97 7 14 0 1914708512 8859376 2590992
00:40:33 88438 8192000000 10865161392 11346317312 1854697760 18.460 95 15 30 1 1871349232 12420880 4230592
00:42:13 45331 8192000000 10882278544 11342753792 1901215888 18.836 97 20 40 1 1915806144 9249584 5340672
00:43:13 36024 8192000000 10894489616 11355357184 1934380048 19.102 99 55 110 0 1964266544 14609856 15276640
00:44:00 32269 8192000000 10901865312 11359428608 1940004912 19.147 99 36 72 1 1972111392 22131456 9975024
00:44:43 53702 8192000000 10858466656 11329105920 1862767952 18.526 96 18 37 0 1888126000 20331952 5026096
00:46:26 32823 8192000000 10843222512 11296202752 1852716976 18.444 96 16 32 0 1866582944 9268352 4597616
00:47:05 23645 8192000000 10884815856 11335127040 1941159104 19.156 100 37 74 2 1963333824 11631792 10542928
00:47:36 24441 8192000000 10892650976 11347443712 1926993168 19.043 99 29 58 0 1950835056 15530576 8311312
00:48:06 62525 8192000000 10893178368 11363733504 1947887664 19.210 100 16 32 0 1972162976 19876672 4398640
00:49:15 66865 8192000000 10890105888 11351052288 1921584976 19.000 98 22 44 0 1938690048 11292704 5812368
00:50:32 56413 8192000000 10894211280 11346464768 1879821760 18.664 96 27 54 0 1902540752 15420208 7298784
00:51:35 124764 8192000000 10872072384 11339235328 1930514048 19.071 99 34 68 1 1953417376 13383840 9519488
00:53:47 60210 8192000000 10878375600 11337916416 1892568912 18.766 97 26 52 0 1912046192 12055120 7422160
00:55:14 39690 8192000000 10883211840 11365052416 1950343920 19.229 100 20 40 1 1972652960 16590128 5718912
00:56:02 32335 8192000000 10881602688 11367014400 1953297088 19.253 100 7 14 0 1969200176 13415600 2487488
00:56:46 37141 8192000000 10881374112 11357831168 1940217472 19.148 99 24 46 5 1959803904 12134016 7452416
00:57:32 62110 8192000000 10875950816 11351834624 1931800720 19.081 98 11 22 0 1944570800 9781392 2988688
00:58:45 63539 8192000000 10895630112 11368579072 1961687888 19.319 99 17 34 0 1974978480 8791904 4498688
01:00:22 90526 8192000000 10898973328 11356094464 1930995488 19.075 98 20 38 0 1950306976 13411712 5899776
01:02:06 100597 8192000000 10901946528 11370864640 1923878672 19.018 97 18 36 0 1939009312 10195648 4934992
01:03:52 76590 8192000000 10880416464 11355217920 1897467136 18.806 96 11 22 2 1911768464 11104000 3197328
01:05:22 38282 8192000000 10888465328 11343921152 1882377712 18.684 96 41 82 3 1908266944 14426240 11462992
01:06:13 43358 8192000000 10882365024 11352473600 1926549488 19.039 99 27 54 2 1946664352 12337840 7777024
01:07:03 118796 8192000000 10886852384 11353292800 1870639872 18.589 95 22 44 0 1887072304 10537248 5895184
01:09:09 57026 8192000000 10920610368 11374305280 1964738912 19.344 100 36 72 1 1990656608 15947808 9969888
01:10:13 40686 8192000000 10912339792 11389186048 1976581600 19.438 100 35 70 1 1998096480 12118976 9395904
01:11:01 50375 8192000000 10904826784 11367993344 1938221312 19.133 98 17 34 2 1955806384 12896192 4688880
01:12:00 72126 8192000000 10887529904 11365781504 1933290208 19.093 98 27 54 1 1956542880 15547232 7705440
01:13:20 65924 8192000000 10921796688 11350745088 1884396928 18.701 96 29 57 1 1901716880 9116960 8202992
01:14:35 20680 8192000000 10901995824 11350061056 1936909072 19.122 99 38 76 1 1958338464 10978496 10450896
01:15:12 56234 8192000000 10898105024 11354849280 1924058304 19.019 98 48 96 2 1952941936 15360576 13523056
01:16:41 95618 8192000000 10862567760 11338223616 1915042560 18.947 98 19 38 0 1932899152 12166576 5690016
01:18:23 47738 8192000000 10848782048 11331489792 1901479856 18.838 98 10 20 1 1913357184 9314352 2562976
01:20:05 47170 8192000000 10855940144 11337768960 1922294256 19.005 99 14 28 1 1934610256 8130608 4185392
01:20:59 15592 8192000000 10853889520 11338928128 1939588864 19.143 100 6 12 0 1949574032 7470112 2515056
01:21:20 19788 8192000000 10879314576 11348115456 1944340960 19.181 100 5 10 0 1952928336 7390048 1197328
01:21:52 66656 8192000000 10872567456 11348090880 1931080768 19.076 99 21 42 0 1945391600 8422176 5888656
01:23:36 57085 8192000000 10884445984 11347369984 1893083664 18.771 97 18 36 0 1906681952 8460624 5137664
01:24:43 59806 8192000000 10869163488 11334905856 1889625248 18.743 97 23 46 1 1908320320 12075056 6620016
01:25:54 76223 8192000000 10858778544 11343196160 1869804864 18.583 96 10 20 0 1885247440 12472960 2969616
01:27:16 25047 8192000000 9111294800 9341808640 273914528 3.235 15 2 4 0 279461616 5127328 419760

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 11-06-2021 01:28:49 to 11-06-2021 01:29:21.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 153 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

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

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          239359
MON$OLDEST_ACTIVE               239360
MON$OLDEST_SNAPSHOT             239360
MON$NEXT_TRANSACTION            239360
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                       2025568
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.33472 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33472 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33472 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33472 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 ---
:109: 
:110: mscs-test-161.budzdorov.ru    Fri Jun 11 01:27:44 2021
:111:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:112: 
:113: 
:114: mscs-test-161.budzdorov.ru    Fri Jun 11 01:27:44 2021
:115:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:116: 
:117: 
:118: mscs-test-161.budzdorov.ru    Fri Jun 11 01:27:49 2021
:119:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:120: 
--- end of diff output ---

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

11.06.21 01:29:25. 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-06-11 01:29:27 No severe PSQL-related problems occured
11.06.21 01:29:28. End of report.