Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 22.06.2021 16:29
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 17090604 kB
MemAvailable 31397884 kB
Buffers 0 kB
Cached 14610520 kB
SwapCached 2432 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-22 16:27:37
DTS_END                         2021-06-22 16:27:37.9400
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/56756
TRN_ID                          243311
ATT_ID                          639
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: 9373.71 21611 1124845
customer order: creation 174.83 338 20980
customer order: refuse 14.15 370 1698
order to supplier: creation 46.67 1297 5600
order to supplier: removal 3.49 95202 419
invoice (draft): creation 47.40 3161 5688
invoice (draft): removal 53.18 777 6382
invoice accept: apply 42.68 17310 5121
invoice accept: cancel 48.03 790 5764
customer reserve: creation 3953.13 171 474376
customer reserve: removal 4682.18 56 561861
realization accept: apply 83.82 206 10058
realization accept: cancel 91.31 102 10957
payment from customer: creation 60.86 117 7303
payment from customer: removal 5.92 78 710
payment to supplier: creation 50.46 140 6055
payment to supplier: removal 3.44 76 413
service: total inventory turnovers 4.72 1151 567
service: total monetary turnovers 6.68 25 802
service: aggregate perf. data 0.73 25349 87
service: refresh index statistics 0.03 285509 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-06-2021 16:30:04 to 22-06-2021 16:30:06.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2813
TEST_TIME 2 3463
TEST_TIME 3 3351
TEST_TIME 4 4223
TEST_TIME 5 4346
TEST_TIME 6 4192
TEST_TIME 7 4373
TEST_TIME 8 4604
TEST_TIME 9 5076
TEST_TIME 10 5333
TEST_TIME 11 5854
TEST_TIME 12 6100
TEST_TIME 13 6474
TEST_TIME 14 6929
TEST_TIME 15 7420
TEST_TIME 16 7458
TEST_TIME 17 7668
TEST_TIME 18 8289
TEST_TIME 19 8297
TEST_TIME 20 8550
TEST_TIME 21 8735
TEST_TIME 22 8739
TEST_TIME 23 8777
TEST_TIME 24 8953
TEST_TIME 25 9771
TEST_TIME 26 9932
TEST_TIME 27 10000
TEST_TIME 28 10257
TEST_TIME 29 10935
TEST_TIME 30 10777
TEST_TIME 31 10619
TEST_TIME 32 10633
TEST_TIME 33 10826
TEST_TIME 34 10828
TEST_TIME 35 10672
TEST_TIME 36 10386
TEST_TIME 37 10372
TEST_TIME 38 10312
TEST_TIME 39 10298
TEST_TIME 40 10179
TEST_TIME 41 10098
TEST_TIME 42 10017
TEST_TIME 43 10051
TEST_TIME 44 10028
TEST_TIME 45 9951
TEST_TIME 46 10226
TEST_TIME 47 10104
TEST_TIME 48 10202
TEST_TIME 49 10021
TEST_TIME 50 9957
TEST_TIME 51 10036
TEST_TIME 52 9941
TEST_TIME 53 9986
TEST_TIME 54 9879
TEST_TIME 55 9977
TEST_TIME 56 9967
TEST_TIME 57 9926
TEST_TIME 58 9974
TEST_TIME 59 9961
TEST_TIME 60 9951
TEST_TIME 61 9995
TEST_TIME 62 10042
TEST_TIME 63 10073
TEST_TIME 64 10063
TEST_TIME 65 10153
TEST_TIME 66 10009
TEST_TIME 67 9950
TEST_TIME 68 9948
TEST_TIME 69 9843
TEST_TIME 70 9806
TEST_TIME 71 9816
TEST_TIME 72 9752
TEST_TIME 73 9695
TEST_TIME 74 9678
TEST_TIME 75 9642
TEST_TIME 76 9598
TEST_TIME 77 9594
TEST_TIME 78 9608
TEST_TIME 79 9638
TEST_TIME 80 9613
TEST_TIME 81 9608
TEST_TIME 82 9612
TEST_TIME 83 9580
TEST_TIME 84 9559
TEST_TIME 85 9540
TEST_TIME 86 9662
TEST_TIME 87 9691
TEST_TIME 88 9693
TEST_TIME 89 9758
TEST_TIME 90 9762
TEST_TIME 91 9769
TEST_TIME 92 9754
TEST_TIME 93 9690
TEST_TIME 94 9716
TEST_TIME 95 9657
TEST_TIME 96 9601
TEST_TIME 97 9546
TEST_TIME 98 9578
TEST_TIME 99 9554
TEST_TIME 100 9544
TEST_TIME 101 9525
TEST_TIME 102 9475
TEST_TIME 103 9491
TEST_TIME 104 9477
TEST_TIME 105 9498
TEST_TIME 106 9486
TEST_TIME 107 9558
TEST_TIME 108 9553
TEST_TIME 109 9546
TEST_TIME 110 9542
TEST_TIME 111 9621
TEST_TIME 112 9615
TEST_TIME 113 9591
TEST_TIME 114 9533
TEST_TIME 115 9524
TEST_TIME 116 9471
TEST_TIME 117 9471
TEST_TIME 118 9441
TEST_TIME 119 9424
TEST_TIME 120 9374

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 22-06-2021 16:30:07 to 22-06-2021 16:30:11.

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 1564650 1564650 0 0.00 0 24269 6 0 0
doc_list_biud 1564650 1564650 0 0.00 0 44290 26 0 0
sp_add_invoice_to_stock 5245 5121 124 2.36 31 166642 17310 0 124
sp_cancel_adding_invoice 5764 5764 0 0.00 6 78119 791 0 0
sp_cancel_client_order 1698 1698 0 0.00 4 13637 370 0 0
sp_cancel_customer_reserve 561861 561861 0 0.00 1 44291 56 0 0
sp_cancel_pay_from_customer 710 710 0 0.00 2 6994 79 0 0
sp_cancel_pay_to_supplier 413 413 0 0.00 3 5014 76 0 0
sp_cancel_supplier_invoice 6390 6382 8 0.12 2 18517 778 0 8
sp_cancel_supplier_order 419 419 0 0.00 4 976626 95203 0 0
sp_cancel_write_off 10957 10957 0 0.00 1 11117 102 0 0
sp_client_order 20980 20980 0 0.00 3 16550 338 0 0
sp_customer_reserve 474376 474376 0 0.00 0 41766 172 0 0
sp_fill_shopping_cart 32246 32246 0 0.00 1 16746 34 0 0
sp_fill_shopping_cart_clo_res 474376 474376 0 0.00 0 18003 13 0 0
sp_get_clo_for_invoice 5120 5120 0 0.00 0 12903 247 0 0
sp_kill_cost_storno 17844 17844 0 0.00 0 24253 54 0 0
sp_kill_qstorno_ret_qs2qd 1141480 1141480 0 0.00 0 44288 31 0 0
sp_kill_qty_storno 602259 602259 0 0.00 0 44290 67 0 0
sp_lock_selected_doc 20932 20932 0 0.00 0 7441 3 0 0
sp_make_cost_storno 28536 28536 0 0.00 0 14907 59 0 0
sp_multiply_rows_for_pdistr 28536 28536 0 0.00 0 14725 29 0 0
sp_multiply_rows_for_qdistr 20980 20980 0 0.00 0 10865 133 0 0
sp_pay_from_customer 7303 7303 0 0.00 4 14377 117 0 0
sp_pay_to_supplier 6055 6055 0 0.00 4 13305 141 0 0
sp_payment_common 13358 13358 0 0.00 2 14370 39 0 0
sp_qd_handle_on_cancel_clo 1698 1698 0 0.00 0 13631 336 0 0
sp_qd_handle_on_invoice_upd_sts 10884 10884 0 0.00 0 16158 336 0 0
sp_qd_handle_on_reserve_upd_sts 10058 10058 0 0.00 0 15880 67 0 0
sp_reserve_write_off 10058 10058 0 0.00 7 16595 207 0 0
sp_supplier_invoice 5688 5688 0 0.00 6 86556 3161 0 0
sp_supplier_order 5600 5600 0 0.00 4 44680 1298 0 0
srv_aggregate_perf_data 87 87 0 0.00 2555 272588 25349 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 1803 158471 33242 0 0
srv_find_qd_qs_mism 1076223 1076223 0 0.00 0 14174 5 0 0
srv_make_invnt_saldo 567 567 0 0.00 44 53885 1152 0 0
srv_make_money_saldo 802 802 0 0.00 1 1785 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 115957 406271 285509 0 0
t$perf-abend:sp_add_invoice_to_stock 124 124 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5121 5121 0 0.00 0 12772 164 0 0
t$perf-norm:sp_cancel_adding_invoice 423 423 0 0.00 0 5691 118 0 0
t$perf-norm:sp_cancel_client_order 1698 1698 0 0.00 0 2249 17 0 0
t$perf-norm:sp_cancel_customer_reserve 673 673 0 0.00 0 2844 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 710 710 0 0.00 0 2410 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 413 413 0 0.00 0 2207 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 402 402 0 0.00 0 3680 27 0 0
t$perf-norm:sp_cancel_supplier_order 419 419 0 0.00 0 38418 1696 0 0
t$perf-norm:sp_cancel_write_off 1016 1016 0 0.00 0 1448 9 0 0
t$perf-norm:sp_client_order 20980 20980 0 0.00 0 12641 22 0 0
t$perf-norm:sp_customer_reserve 1028 1028 0 0.00 0 4040 8 0 0
t$perf-norm:sp_pay_from_customer 7303 7303 0 0.00 0 8619 16 0 0
t$perf-norm:sp_pay_to_supplier 6055 6055 0 0.00 0 12785 15 0 0
t$perf-norm:sp_reserve_write_off 10058 10058 0 0.00 0 7989 17 0 0
t$perf-norm:sp_supplier_invoice 5688 5688 0 0.00 0 6200 17 0 0
t$perf-norm:sp_supplier_order 5600 5600 0 0.00 0 7309 18 0 0
t$perf-norm:srv_aggregate_perf_data 87 87 0 0.00 0 70 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 8811 91 0 0
t$perf-norm:srv_make_invnt_saldo 567 567 0 0.00 0 2030 25 0 0
t$perf-norm:srv_make_money_saldo 802 802 0 0.00 0 2014 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 57 22 0 0
v_add_invoice_to_stock 10488 10240 248 2.36 0 4758 21 0 248
v_all_customers 38894 38894 0 0.00 0 17 1 0 0
v_all_suppliers 31174 31174 0 0.00 0 50 1 0 0
v_all_wares 41960 41960 0 0.00 0 121 1 0 0
v_cancel_adding_invoice 846 846 0 0.00 0 2882 10 0 0
v_cancel_client_order 3396 3396 0 0.00 0 3214 11 0 0
v_cancel_customer_prepayment 1420 1420 0 0.00 0 2828 6 0 0
v_cancel_customer_reserve 1346 1346 0 0.00 0 3277 11 0 0
v_cancel_payment_to_supplier 826 826 0 0.00 0 2405 8 0 0
v_cancel_supplier_invoice 820 804 16 1.95 0 3543 22 0 16
v_cancel_supplier_order 838 838 0 0.00 0 3279 14 0 0
v_cancel_write_off 2032 2032 0 0.00 0 4973 18 0 0
v_max_id_clo_ord 5597 5597 0 0.00 0 1304 2 0 0
v_max_id_clo_res 1028 1028 0 0.00 0 1515 10 0 0
v_max_id_ord_sup 5669 5669 0 0.00 0 5841 4 0 0
v_max_non_paid_invoice 1734 1734 0 0.00 0 829 3 0 0
v_max_non_paid_realizn 3683 3683 0 0.00 0 2135 4 0 0
v_min_id_clo_ord 5597 5597 0 0.00 0 1884 5 0 0
v_min_id_clo_res 1028 1028 0 0.00 0 3368 14 0 0
v_min_id_ord_sup 5669 5669 0 0.00 0 6182 6 0 0
v_min_non_paid_invoice 6055 6055 0 0.00 0 13239 26 0 0
v_min_non_paid_realizn 7303 7303 0 0.00 0 14366 27 0 0
v_our_firm 10306 10306 0 0.00 0 20 1 0 0
v_reserve_write_off 20116 20116 0 0.00 0 4680 10 0 0
x_lock_depdocs_on_canc_invoice 11744 11744 0 0.00 0 15037 111 0 0
x_lock_depdocs_on_canc_sup_ord 419 419 0 0.00 0 4787 330 0 0
x_make_qstorno_1000_1200 5600 5600 0 0.00 2 44660 1220 0 0
x_make_qstorno_1200_2000 5688 5688 0 0.00 3 86541 3047 0 0
x_make_qstorno_2100_3300 474376 474376 0 0.00 0 41765 157 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-06-2021 16:30:12 to 22-06-2021 16:30:16.

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:41 2 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
13:57:47 4638 8192000000 10043468816 10317512704 844326720 9.343 68 55 114 0 865202048 2380896 18494432
13:58:00 24583 8192000000 10312886736 10631540736 1362595792 14.261 100 83 167 0 1393622416 4118912 26907712
13:58:35 17741 8192000000 10369377456 10691784704 1421916128 14.790 100 86 173 0 1455968096 5536000 28515968
13:59:04 22481 8192000000 10405602592 10731745280 1455807296 15.089 100 82 165 0 1488935760 6320800 26807664
13:59:38 10370 8192000000 10420383280 10750423040 1477635632 15.281 100 87 174 0 1512846560 7147328 28063600
14:00:06 28623 8192000000 10460463072 10794848256 1510433312 15.567 100 92 184 2 1547936448 7997760 29505376
14:00:51 25770 8192000000 10476361536 10816917504 1532098848 15.755 100 86 172 0 1568301424 9046224 27156352
14:01:30 11920 8192000000 10493957776 10840682496 1556846656 15.969 100 79 158 1 1589768240 8909072 24012512
14:01:56 10895 8192000000 10526089008 10871816192 1577510304 16.147 100 83 166 1 1612194672 9392064 25292304
14:02:20 11714 8192000000 10537278656 10893791232 1598360608 16.325 100 75 150 0 1630757200 9451136 22945456
14:02:42 14097 8192000000 10561760064 10919383040 1619749856 16.508 100 77 154 0 1652744144 9904800 23089488
14:03:10 10995 8192000000 10583810560 10944393216 1648656832 16.753 100 89 178 1 1686021296 10494640 26869824
14:03:28 8044 8192000000 10612230768 10974334976 1666663472 16.905 100 85 170 2 1702759184 10709888 25385824
14:03:47 11052 8192000000 10627958512 10996842496 1689136432 17.094 100 75 150 2 1722563968 11167296 22260240
14:04:07 8659 8192000000 10653108464 11025604608 1711570336 17.282 100 77 153 0 1745332960 11681792 22080832
14:04:24 7979 8192000000 10668015408 11036958720 1731062336 17.444 100 85 169 1 1767908224 12321632 24524256
14:04:41 7218 8192000000 10681824656 11056447488 1740647072 17.524 100 84 168 0 1777562032 12530752 24384208
14:04:56 7167 8192000000 10693866800 11069411328 1753607824 17.631 100 87 174 2 1791742576 13488224 24646528
14:05:11 6188 8192000000 10708221008 11084435456 1767843968 17.749 100 87 174 0 1806986320 13674000 25468352
14:05:24 6603 8192000000 10719298896 11100930048 1776105136 17.817 100 82 164 0 1813521296 13992944 23423216
14:05:38 6172 8192000000 10725688208 11104591872 1785572256 17.895 100 76 152 0 1819712384 13236720 20903408
14:05:52 4544 8192000000 10730389520 11110977536 1796006992 17.981 100 86 171 1 1832696528 13119008 23570528
14:06:03 4134 8192000000 10735158112 11121061888 1801524384 18.026 100 82 165 0 1838412224 13609776 23278064
14:06:14 4653 8192000000 10745871376 11128991744 1810581408 18.101 100 84 169 1 1847584832 13463200 23540224
14:06:25 3238 8192000000 10759533328 11140308992 1813105632 18.121 100 83 166 1 1848865920 12820416 22939872
14:06:35 3462 8192000000 10758872080 11143278592 1823060224 18.203 100 89 179 2 1862036704 14296544 24679936
14:06:45 4026 8192000000 10764364608 11149541376 1824808768 18.217 100 88 173 0 1862212816 13744064 23659984
14:07:02 2997 8192000000 10765154912 11154714624 1828092608 18.244 100 83 166 0 1865477072 14757696 22626768
14:07:12 2462 8192000000 10784372416 11169579008 1843282800 18.368 100 92 184 4 1883555392 14511280 25761312
14:07:21 2380 8192000000 10783896416 11170787328 1847759936 18.404 100 92 182 2 1888071824 14573648 25738240
14:07:29 1897 8192000000 10784362800 11171049472 1844791920 18.380 100 84 167 0 1882217120 14089824 23335376
14:07:38 2833 8192000000 10787623968 11179061248 1847584768 18.402 100 87 174 1 1886197648 14344240 24268640
14:07:48 1745 8192000000 10794229632 11181060096 1854916048 18.462 100 88 174 0 1892765344 13535888 24313408
14:07:56 2470 8192000000 10802799920 11191119872 1862836640 18.526 100 87 174 0 1900079824 13151728 24091456
14:08:06 2873 8192000000 10811310944 11201052672 1864047312 18.536 100 87 175 1 1902931568 14465264 24418992
14:08:15 2088 8192000000 10809425232 11199078400 1870130688 18.585 100 89 177 2 1908757520 13609312 25017520
14:08:24 1582 8192000000 10818655696 11205259264 1873302544 18.611 100 94 188 0 1913429808 14212512 25914752
14:08:32 1963 8192000000 10816844768 11204747264 1871316240 18.595 100 92 184 0 1912044064 14626016 26101808
14:08:41 1073 8192000000 10816329776 11203350528 1872398160 18.604 100 92 186 0 1911159648 13002384 25759104
14:08:48 1247 8192000000 10816992784 11206320128 1873517712 18.613 100 94 188 0 1913111488 13170512 26423264
14:08:56 23018 8192000000 10797021712 11203739648 1874065776 18.617 100 82 164 1 1911544672 13609328 23869568
14:09:25 16590 8192000000 10806003888 11205140480 1875501600 18.629 100 73 144 2 1905079472 8706464 20871408
14:09:49 2445 8192000000 10825589072 11221041152 1880982272 18.673 100 90 180 2 1917431632 9861584 26587776
14:09:57 9512 8192000000 10805146624 11215847424 1877184384 18.642 100 69 138 1 1907215520 10921664 19109472
14:10:14 10226 8192000000 10794584832 11219505152 1877465104 18.645 100 54 108 0 1908361248 16045168 14850976
14:10:38 6153 8192000000 10792691632 11204644864 1873601632 18.613 100 27 54 3 1886819008 5268320 7949056
14:10:51 5915 8192000000 10788554432 11216703488 1878185744 18.650 100 32 64 1 1894708400 6922336 9600320
14:11:04 3229 8192000000 10799150608 11226898432 1882032736 18.682 100 36 72 1 1904066576 12167072 9866768
14:11:14 6147 8192000000 10795749648 11219939328 1881828160 18.680 100 25 50 2 1895724720 6758448 7138112
14:11:29 9368 8192000000 10796029440 11225690112 1886534912 18.718 100 23 46 2 1898701584 5728224 6438448
14:11:45 7563 8192000000 10802004432 11229720576 1889078480 18.738 100 28 56 0 1904295232 7354624 7862128
14:12:00 7066 8192000000 10798251952 11230228480 1890700368 18.751 100 35 70 2 1907175072 7488128 8986576
14:12:16 7758 8192000000 10796216704 11230195712 1890816528 18.752 100 20 40 0 1902725328 6386800 5522000
14:12:31 5455 8192000000 10807424992 11237265408 1893650624 18.775 100 21 42 1 1905967216 6581504 5735088
14:12:43 9623 8192000000 10796291424 11236114432 1893249952 18.772 100 19 38 1 1904075536 5881968 4943616
14:13:02 10454 8192000000 10800091056 11233972224 1893684896 18.775 100 14 28 0 1903034384 5644784 3704704
14:13:19 12375 8192000000 10805172800 11242905600 1896341936 18.797 100 21 43 1 1911735648 9860816 5532896
14:13:39 15989 8192000000 10801179680 11238944768 1895418736 18.789 100 14 28 0 1909577344 10408640 3749968
14:14:03 14661 8192000000 10825179504 11246190592 1901201936 18.836 100 23 47 0 1913771552 4879984 7689632
14:14:24 59277 8192000000 10823415296 11253882880 1901728528 18.840 100 28 54 2 1914498784 5549344 7220912
14:15:33 20059 8192000000 10822271536 11258040320 1905607760 18.871 100 25 50 0 1919191088 6208192 7375136
14:16:03 5295 8192000000 10837342528 11264053248 1909645408 18.904 100 28 56 1 1923741984 6580480 7516096
14:16:17 4991 8192000000 10825192096 11263451136 1910266944 18.909 100 28 56 1 1924614432 5942928 8404560
14:16:30 4243 8192000000 10829194304 11263447040 1912848176 18.930 100 35 68 0 1928980928 6707360 9425392
14:16:41 6060 8192000000 10828776304 11267645440 1915169280 18.948 100 22 44 2 1927682224 5968800 6544144
14:16:56 10859 8192000000 10819517152 11258273792 1878401744 18.652 98 22 44 1 1890618208 6440832 5775632
14:17:14 8818 8192000000 10810198032 11241136128 1852166400 18.440 97 25 50 2 1869230752 9970880 7093472
14:17:29 9927 8192000000 10815406672 11252285440 1896602112 18.799 100 13 26 2 1906056480 5086688 4367680
14:17:45 7023 8192000000 10801817024 11235229696 1886102752 18.714 100 21 39 2 1897697184 5960672 5633760
14:18:03 10695 8192000000 10778656160 11206492160 1859777568 18.501 99 10 20 0 1867766480 5155680 2833232
14:18:23 15463 8192000000 10749158848 11182379008 1748330112 17.588 93 13 26 1 1756970880 4461568 4179200
14:18:45 10472 8192000000 10742629296 11168460800 1774683280 17.806 96 27 54 2 1788492192 5370720 8438192
14:19:01 11144 8192000000 10713611728 11142344704 1731369168 17.447 94 17 34 0 1742055408 5800064 4886176
14:19:19 70893 8192000000 10722280800 11140046848 1695163296 17.145 92 41 82 0 1713682240 5810624 12708320
14:20:36 13822 8192000000 10730085280 11155279872 1765861376 17.733 97 19 38 0 1776805184 5735040 5208768
14:20:57 6573 8192000000 10727170256 11140595712 1786036528 17.899 98 24 48 2 1799143472 6743408 6363536
14:21:10 3778 8192000000 10714534368 11120758784 1778051360 17.833 99 22 45 4 1789996000 5461568 6483072
14:21:24 4517 8192000000 10693429232 11105722368 1712398784 17.289 95 23 43 2 1724796752 4749088 7648880
14:21:35 6585 8192000000 10668416000 11087540224 1717777776 17.334 97 25 50 0 1732149040 6380192 7991072
14:21:48 8979 8192000000 10704931216 11121750016 1759595600 17.681 98 25 50 2 1772595440 5524384 7475456
14:22:04 4963 8192000000 10725165232 11138965504 1792575184 17.953 99 21 43 1 1803256672 4204240 6477248
14:22:18 11198 8192000000 10720787280 11139432448 1774832912 17.807 98 10 20 0 1782874096 4764304 3276880
14:22:37 8449 8192000000 10711757440 11133362176 1790440592 17.935 99 31 62 1 1805850176 5377152 10032432
14:22:53 7247 8192000000 10727897728 11142565888 1778225744 17.835 98 24 48 0 1790775296 6041008 6508544
14:23:11 7961 8192000000 10742058624 11159154688 1817428960 18.157 100 15 30 0 1826806928 5000384 4377584
14:23:31 12521 8192000000 10740225712 11168317440 1818025024 18.162 99 21 40 0 1829683392 5594944 6063424
14:23:53 8485 8192000000 10747682000 11174768640 1836452912 18.312 100 19 38 1 1847259264 5557616 5248736
14:24:08 76941 8192000000 10769852688 11183624192 1825433536 18.222 99 25 50 0 1837597184 5335408 6828240
14:25:31 12742 8192000000 10767819216 11186925568 1846878144 18.397 100 16 32 1 1856121680 5436128 3807408
14:25:50 6723 8192000000 10771823872 11196669952 1854095424 18.455 100 31 62 0 1869853136 7610192 8147520
14:26:03 6771 8192000000 10776891440 11199770624 1860671840 18.509 100 32 63 0 1876056096 6423520 8960736
14:26:16 6910 8192000000 10777151840 11202670592 1861595824 18.516 100 22 44 2 1872578000 5002720 5979456
14:26:29 7546 8192000000 10792031328 11207970816 1862213664 18.521 100 27 54 0 1877370512 6243424 8913424
14:26:43 9164 8192000000 10777374880 11205763072 1863148064 18.529 100 26 48 2 1875407168 4544736 7714368
14:27:02 6942 8192000000 10786173376 11216896000 1873509760 18.613 100 15 27 1 1881478704 4740224 3228720
14:27:16 15266 8192000000 10803855840 11233067008 1888575792 18.734 100 17 34 0 1897667696 4338704 4753200
14:27:41 39171 8192000000 10824974816 11247513600 1904937408 18.866 100 44 88 0 1923982304 5385632 13659264
14:28:31 6890 8192000000 10849440656 11267874816 1918935504 18.978 100 55 110 3 1942891552 9283024 14673024
14:28:48 3606 8192000000 10863280480 11275440128 1924828400 19.026 100 60 118 1 1951817776 10502304 16487072
14:29:00 19639 8192000000 10867852576 11283550208 1927439872 19.046 100 53 106 0 1953980176 11178640 15361664
14:29:29 14678 8192000000 10869580608 11288662016 1936803120 19.121 100 58 115 1 1968060224 14600720 16656384
14:29:56 5430 8192000000 10882377056 11297230848 1937782112 19.129 100 53 104 1 1967229808 13482624 15965072
14:30:10 26043 8192000000 10897166880 11312508928 1943028688 19.171 100 55 110 0 1973601376 15301264 15271424
14:30:46 55469 8192000000 10893442080 11322327040 1948835408 19.217 100 54 106 0 1984196784 20101296 15260080
14:31:57 53049 8192000000 10866154448 11311144960 1932843520 19.090 99 24 48 0 1958119616 17878288 7397808
14:32:57 14554 8192000000 10902008368 11325739008 1954254272 19.260 100 44 88 1 1985287808 17383008 13650528
14:33:19 14290 8192000000 10903352864 11329785856 1942152880 19.164 99 40 80 1 1971811440 18541264 11117296
14:33:42 20700 8192000000 10903999984 11338977280 1964302592 19.340 100 38 76 0 1994326880 19317328 10706960
14:34:10 16417 8192000000 10912104944 11350867968 1971064608 19.394 100 35 70 0 2000508496 19177680 10266208
14:34:36 4142 8192000000 10932601072 11352059904 1980148048 19.466 100 54 106 3 2014377360 19226928 15002384
14:34:47 10219 8192000000 10930904272 11363135488 1989310496 19.538 100 62 124 1 2028638000 21311344 18016160
14:35:05 5419 8192000000 10958922464 11373555712 1993721088 19.573 100 77 153 0 2038237872 22501440 22015344
14:35:18 10929 8192000000 10946465920 11370639360 1993352672 19.570 100 59 116 0 2032761888 22938848 16470368
14:35:39 2152 8192000000 10953760768 11380355072 2001344512 19.633 100 74 147 0 2046137664 23338288 21454864
14:35:54 4999 8192000000 10933203920 11355041792 1976964992 19.441 99 67 132 2 2020579472 24018032 19596448
14:36:06 6928 8192000000 10944267248 11365171200 1974075056 19.418 99 74 146 2 2020779296 25067568 21636672
14:36:20 3054 8192000000 10967268160 11377278976 1991780464 19.558 100 77 154 0 2041383088 26939648 22662976
14:36:30 4377 8192000000 10960950496 11383042048 1995548608 19.588 100 77 154 1 2048338960 29723408 23066944
14:36:42 2948 8192000000 10965078576 11386916864 1997565872 19.604 100 71 142 0 2049985440 31043920 21375648
14:36:53 10627 8192000000 10958900080 11387981824 2000806704 19.629 100 60 120 0 2046147408 27577680 17763024
14:37:10 8786 8192000000 10959472528 11392917504 2005344848 19.665 100 61 120 2 2051211504 27812464 18054192
14:37:27 10085 8192000000 10966330208 11398512640 2006431760 19.673 100 57 114 1 2053231360 29406656 17392944
14:37:47 4252 8192000000 10965799072 11401531392 2013862672 19.732 100 68 133 1 2063549616 29178928 20508016
14:38:04 8886 8192000000 10975949824 11407908864 2014500304 19.737 100 69 136 0 2064110608 29363936 20246368
14:38:22 6444 8192000000 10973907600 11409145856 2016498512 19.753 100 60 120 0 2064579504 29679168 18401824
14:38:38 3562 8192000000 10985328560 11406540800 2000869840 19.630 99 72 144 2 2052917424 29961696 22085888
14:38:50 4987 8192000000 10969523760 11405135872 2012210224 19.719 100 56 111 2 2059331168 28863184 18257760
14:39:04 4084 8192000000 10986750112 11414945792 2013619344 19.730 100 67 132 1 2063877344 30097408 20160592
14:39:15 3533 8192000000 10981101808 11405307904 1997725760 19.605 99 82 164 1 2055198064 32360880 25111424
14:39:30 13936 8192000000 10959573056 11392860160 1998146016 19.608 100 66 133 1 2051515984 33190400 20179568
14:39:52 12011 8192000000 10963491360 11393720320 1996481232 19.595 100 57 110 2 2043879632 30442080 16956320
14:40:11 13919 8192000000 10960172736 11398864896 2001582192 19.635 100 44 88 2 2045432576 30566032 13284352
14:40:35 6227 8192000000 10971800320 11398897664 2000589872 19.627 100 69 138 0 2056136224 34204544 21341808
14:40:51 5231 8192000000 10942360080 11368534016 1976261168 19.435 99 68 136 0 2027264352 30325024 20678160
14:41:04 3072 8192000000 10948619488 11372965888 1966458144 19.357 99 76 152 2 2020734208 31634832 22641232
14:41:19 1838 8192000000 10930354640 11358257152 1970173200 19.387 99 74 148 3 2019399152 27070752 22155200
14:41:27 11585 8192000000 10911817264 11351736320 1947449440 19.206 99 56 111 0 1993842608 29685856 16707312
14:41:49 5774 8192000000 10900581920 11330809856 1934079232 19.099 99 55 110 0 1980221312 28650816 17491264
14:42:07 3793 8192000000 10929715392 11355668480 1960415520 19.309 100 71 143 1 2015820848 33031632 22373696
14:42:18 6483 8192000000 10911588368 11348402176 1935794208 19.113 99 51 102 0 1986140912 34091296 16255408
14:42:32 12216 8192000000 10897220384 11337056256 1913212240 18.932 98 51 102 0 1963518832 34273008 16033584
14:42:53 13059 8192000000 10898042736 11340173312 1940980240 19.155 100 36 72 3 1987557216 35463008 11113968
14:43:16 18624 8192000000 10901407232 11339329536 1921457536 18.999 99 50 100 1 1975377280 37886304 16033440
14:43:44 2635 8192000000 10923043360 11353567232 1954505248 19.262 100 60 120 1 2011904720 38823184 18576288
14:43:53 8161 8192000000 10935922288 11361034240 1941536512 19.159 99 61 122 1 2004655728 43718112 19401104
14:44:08 3050 8192000000 10938765792 11357229056 1957895568 19.289 100 74 148 0 2020900464 41155056 21849840
14:44:18 4083 8192000000 10942183168 11366580224 1963985120 19.338 100 79 157 1 2030990384 43005616 23999648
14:44:30 2790 8192000000 10946367808 11364376576 1961236656 19.316 100 80 159 0 2029647840 42997408 25413776
14:44:42 3082 8192000000 10914893936 11330994176 1913480720 18.935 98 79 156 2 1977991904 40923664 23587520
14:44:55 7678 8192000000 10936745408 11342532608 1943387296 19.174 100 90 179 4 2011331520 41183488 26760736
14:45:11 1801 8192000000 10922507216 11330523136 1921260576 18.997 99 92 184 0 1990844880 41449504 28134800
14:45:20 2321 8192000000 10936141232 11340853248 1946978576 19.202 100 85 167 0 2011843168 39724784 25139808
14:45:29 2208 8192000000 10927817344 11340926976 1942478688 19.167 100 83 167 0 2008373456 39429600 26465168
14:45:39 3029 8192000000 10901754944 11324493824 1927189184 19.044 100 58 116 2 1984597408 39145472 18262752
14:45:51 8822 8192000000 10904109888 11330883584 1936074848 19.115 100 51 102 2 1987288448 34927488 16286112
14:46:08 5493 8192000000 10914281840 11338874880 1946229856 19.196 100 61 122 0 2001639072 36533808 18875408
14:46:24 5296 8192000000 10905495248 11329404928 1932970608 19.091 100 63 126 1 1992403824 38429600 21003616
14:46:44 7874 8192000000 10890919136 11328450560 1921749920 19.001 99 46 92 0 1972222560 35958992 14513648
14:47:08 5006 8192000000 10893110944 11317690368 1909866656 18.906 99 58 114 1 1971234976 43424336 17943984
14:47:20 8913 8192000000 10891125168 11327553536 1930652256 19.072 100 39 78 0 1979321008 36004336 12664416
14:47:36 13596 8192000000 10881317008 11320844288 1919827696 18.985 99 41 82 0 1968041120 34515296 13698128
14:47:57 7522 8192000000 10907600640 11342012416 1940578656 19.151 100 35 69 1 1988613648 36117120 11917872
14:48:16 10278 8192000000 10911599920 11350880256 1947376592 19.206 100 40 80 1 1999413424 39751152 12285680
14:48:36 13018 8192000000 10928052336 11365339136 1956391184 19.277 100 36 72 0 2004691840 36712640 11588016
14:48:56 16934 8192000000 10915147488 11363688448 1955684704 19.272 100 33 67 0 2003758720 37167344 10906672
14:49:22 22477 8192000000 10919422368 11362398208 1943499728 19.175 99 34 68 2 1990631792 35979040 11153024
14:49:51 14000 8192000000 10928904304 11368976384 1946299920 19.197 99 41 83 2 2001005776 41156304 13549552
14:50:19 24805 8192000000 10929743616 11372425216 1941483568 19.159 99 36 70 0 1998376656 44467696 12425392
14:50:51 10869 8192000000 10938298368 11377692672 1958379840 19.293 100 37 74 0 2017523168 46253696 12889632
14:51:15 14412 8192000000 10935674512 11379580928 1959968816 19.306 100 33 64 2 2017768048 45854352 11944880
14:51:36 12955 8192000000 10904213344 11341864960 1906901776 18.882 97 36 73 0 1965599264 46409232 12288256
14:52:00 10561 8192000000 10926311280 11373817856 1947080512 19.203 100 43 87 2 2008182416 46738224 14363680
14:52:18 10375 8192000000 10923647168 11373961216 1950771104 19.233 100 27 54 2 2007404704 46172368 10461232
14:52:39 23366 8192000000 10910483344 11362877440 1935455488 19.110 99 25 51 1 1976434400 32562720 8416192
14:53:14 6590 8192000000 10901529184 11349372928 1945128464 19.188 100 35 68 1 1985147184 28620992 11397728
14:53:28 21529 8192000000 10912704320 11358216192 1951573488 19.239 100 31 62 1 1992586352 31217408 9795456
14:53:59 21707 8192000000 10907115680 11364864000 1957212512 19.284 100 21 42 1 1995903872 31755200 6936160
14:54:31 38477 8192000000 10870066304 11325685760 1841798608 18.355 95 19 38 1 1885015872 36441088 6776176
14:55:16 36752 8192000000 10875401888 11326873600 1909267360 18.901 100 14 28 3 1955812272 40692048 5852864
14:56:27 34424 8192000000 10884465744 11333709824 1929826576 19.065 100 22 44 0 1968081248 31481584 6773088
14:57:08 41980 8192000000 10880924656 11315679232 1912142592 18.924 98 35 71 1 1928242176 6506032 9593552
14:57:57 25657 8192000000 10891147024 11335557120 1953295856 19.253 100 33 64 2 1972729856 9234768 10199232
14:58:29 23060 8192000000 10874788304 11318165504 1920309328 18.989 98 37 74 1 1941000992 10191808 10499856
14:59:12 33195 8192000000 10892371904 11352375296 1928735552 19.057 99 12 24 1 1943819040 12157664 2925824
14:59:52 64952 8192000000 10891513840 11364392960 1935548288 19.111 99 7 15 1 1955178160 17787664 1842208
15:01:11 110327 8192000000 10895926560 11352711168 1925704176 19.033 98 17 33 1 1948036720 17047984 5284560
15:03:45 52270 8192000000 10919001456 11351699456 1928264144 19.053 98 43 84 0 1951482624 10306720 12911760
15:04:44 34926 8192000000 10898359728 11359551488 1948997456 19.218 99 41 77 2 1970061936 9553664 11510816
15:05:27 67683 8192000000 10902568688 11384225792 1972847872 19.408 100 19 38 1 1995071120 16711840 5511408
15:06:41 47065 8192000000 10910985808 11387416576 1977884672 19.448 100 9 18 0 1996388784 16173488 2330624
15:07:34 4160 8192000000 10914263792 11381489664 1978135888 19.450 100 24 48 1 2001201552 16021712 7043952
15:07:48 13277 8192000000 10915146864 11370328064 1969968640 19.385 99 35 69 1 1992503616 12781792 9753184
15:08:11 8674 8192000000 10930822368 11391508480 1994252480 19.577 100 30 60 1 2018559568 15675584 8631504
15:08:40 16323 8192000000 10924257904 11386159104 1993042768 19.568 100 34 68 0 2019377232 15547376 10787088
15:09:04 14298 8192000000 10927149568 11383451648 1972485200 19.405 99 26 52 1 1997110608 16679920 7945488
15:09:26 32485 8192000000 10947298864 11401535488 1999055680 19.615 100 30 60 1 2029638768 20665792 9917296
15:10:20 70250 8192000000 10953859632 11420807168 1999205680 19.616 100 47 94 1 2039443872 25312848 14925344
15:11:45 66192 8192000000 10936825520 11410731008 1978377888 19.452 99 15 30 0 2014369968 31244064 4748016
15:14:20 39702 8192000000 10896282944 11370115072 1928948464 19.058 97 12 24 0 1951025216 18328688 3748064
15:15:06 54731 8192000000 10893427680 11387785216 1974013920 19.417 100 17 37 1 2000149904 20141952 5994032
15:16:11 50043 8192000000 10909773120 11373428736 1954659216 19.264 99 21 40 1 1972072656 11685920 5727520
15:17:08 61249 8192000000 10904323296 11391201280 1974078288 19.418 100 7 14 0 1993943792 17878928 1986576
15:19:15 42971 8192000000 10900794208 11365515264 1943620464 19.176 98 22 44 1 1957698288 7929088 6148736
15:20:11 68294 8192000000 10932387776 11381710848 1956896912 19.281 99 20 40 1 1971518624 9086816 5534896
15:21:25 15966 8192000000 10927171744 11385241600 1988316400 19.530 100 62 124 0 2016446096 9883344 18246352
15:21:50 41745 8192000000 10923503200 11380457472 1974948128 19.425 100 24 46 3 1994798848 13683632 6167088
15:22:43 59374 8192000000 10916191712 11381071872 1962375552 19.325 99 16 31 1 1980987248 14124672 4487024
15:23:49 61510 8192000000 10904354560 11369541632 1929624752 19.064 97 17 34 1 1944241664 9555232 5061680
15:25:04 44887 8192000000 10901412976 11370434560 1956167184 19.276 99 15 30 0 1970300992 9914688 4219120
15:25:56 78586 8192000000 10876863184 11342471168 1814792208 18.135 92 25 50 1 1834451632 13074416 6585008
15:27:22 72853 8192000000 10872586992 11348279296 1880956272 18.673 96 23 46 0 1902208688 15299520 5952896
15:28:41 58590 8192000000 10889703712 11363434496 1923873728 19.018 98 24 47 1 1942151024 11932256 6345040
15:29:47 83309 8192000000 10804869584 11266088960 1752141792 17.619 90 8 15 1 1768832992 15012656 1678544
15:31:20 104811 8192000000 10870216992 11344154624 1843063328 18.366 96 11 22 1 1864515488 18506624 2945536
15:33:11 76646 8192000000 10819312752 11257032704 1859054784 18.496 97 18 36 1 1879431184 14963200 5413200
15:34:42 66650 8192000000 10874444944 11319201792 1868818288 18.575 97 31 61 1 1890370224 12881056 8670880
15:35:58 49152 8192000000 10856256528 11312652288 1912826400 18.929 99 37 74 0 1934323920 11558656 9938864
15:36:58 16101 8192000000 10854818320 11314642944 1913678400 18.936 99 38 76 0 1934062416 9606528 10777488
15:37:20 13301 8192000000 10867732544 11320545280 1930408912 19.070 100 36 72 3 1948399056 7866432 10123712
15:37:40 35670 8192000000 10852114624 11324899328 1919345568 18.982 99 49 98 1 1945430768 11959680 14125520
15:38:24 61840 8192000000 10860682048 11328397312 1897610112 18.807 98 14 28 2 1908745360 7086080 4049168
15:39:39 71972 8192000000 10871007776 11330609152 1908036304 18.891 98 19 38 0 1925241008 11016880 6187824
15:40:59 40724 8192000000 10874961232 11351642112 1949979472 19.226 100 11 22 0 1969095120 15982560 3133088
15:42:33 41869 8192000000 10889371264 11373047808 1955138624 19.267 100 16 31 0 1978626288 18807408 4680256
15:44:24 45967 8192000000 10884245056 11363954688 1951899808 19.242 99 25 51 1 1970706752 11746288 7060656
15:45:20 72813 8192000000 10885788384 11389493248 1960307088 19.308 100 12 24 0 1977458720 13449872 3701760
15:46:46 76144 8192000000 10855112672 11333255168 1882146864 18.682 96 18 36 1 1895306288 8253488 4905936
15:48:08 63057 8192000000 10869700688 11348258816 1903344800 18.853 98 9 18 1 1914499520 8529280 2625440
15:49:19 28839 8192000000 10861969648 11334410240 1894421776 18.781 97 31 62 0 1911372080 7750960 9199344
15:49:57 68395 8192000000 10880734992 11335532544 1865914080 18.551 96 26 52 0 1880992160 7504320 7573760
15:51:12 27639 8192000000 10889876704 11354738688 1947450704 19.206 100 44 89 0 1975460800 15596240 12413856
15:51:46 94696 8192000000 10869910976 11343691776 1888534784 18.734 97 18 36 0 1911879760 18082640 5262336
15:53:27 40893 8192000000 10869980224 11340513280 1904322160 18.861 98 17 34 0 1925150064 15472192 5355712
15:54:14 83001 8192000000 10857547584 11333750784 1879191232 18.659 97 13 26 2 1899428752 16676624 3560896
15:55:45 65917 8192000000 10868751808 11352870912 1886015184 18.714 98 15 28 1 1910789952 20832176 3942592
15:56:57 56941 8192000000 10893157216 11352387584 1948433264 19.214 100 14 28 1 1966726352 14910336 3382752
15:58:05 59232 8192000000 10876648832 11343134720 1897750672 18.808 97 20 40 0 1912592112 9440464 5400976
15:59:17 22940 8192000000 10902048528 11365863424 1947355952 19.205 99 34 68 1 1966488272 9837968 9294352
15:59:53 129827 8192000000 10870984096 11349573632 1911176416 18.916 98 22 44 2 1929016608 11494720 6345472
16:02:21 59899 8192000000 10877718944 11354324992 1940800272 19.153 99 18 36 0 1956158416 10089600 5268544
16:03:32 98399 8192000000 10881193984 11365150720 1943640880 19.176 99 12 24 0 1963372160 16000480 3730800
16:05:19 89763 8192000000 10886623856 11376037888 1964598768 19.343 100 13 25 1 1978825104 10783840 3442496
16:07:42 60781 8192000000 10900182416 11372990464 1951741904 19.240 99 16 32 0 1962289568 6715744 3831920
16:08:52 82963 8192000000 10887781120 11370033152 1926259008 19.037 97 32 62 1 1946570416 11571040 8740368
16:10:27 63936 8192000000 10882914400 11358830592 1909441552 18.902 97 18 36 1 1926204480 11878528 4884400
16:11:37 49646 8192000000 10888234064 11371077632 1937236784 19.125 99 14 28 1 1954360896 13164832 3959280
16:12:37 32148 8192000000 10885670384 11353751552 1922356928 19.006 98 29 58 0 1945846464 15308080 8181456
16:13:16 37920 8192000000 10889467120 11358056448 1945763536 19.193 99 34 68 3 1967110624 11342144 10004944
16:14:03 72053 8192000000 10869726848 11354247168 1913426352 18.934 98 11 22 1 1929891200 13078832 3386016
16:15:22 45017 8192000000 10870824032 11334602752 1870821440 18.591 96 10 20 0 1884045536 10474320 2749776
16:16:18 133710 8192000000 10898661824 11394478080 1935674368 19.112 99 9 18 0 1955108512 16762480 2671664
16:18:38 158471 8192000000 10872219504 11346272256 1912612320 18.928 97 16 31 0 1930554256 13798512 4143424
16:21:51 88590 8192000000 10817670592 11288219648 1678186560 17.002 86 15 30 0 1688434688 6164672 4083456
16:23:36 39043 8192000000 10817884976 11274465280 1864784864 18.542 98 39 77 2 1883841104 8738688 10317552
16:24:22 47335 8192000000 10830669696 11303043072 1876402544 18.636 98 28 58 2 1892213216 6246480 9564192
16:25:25 94585 8192000000 10841924896 11324534784 1895683744 18.792 99 9 17 2 1908598752 10070272 2844736
16:27:06 36869 8192000000 9535075024 9851224064 676787808 7.631 35 6 12 0 692261168 13976784 1496576

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 22-06-2021 16:30:17 to 22-06-2021 16:30:49.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 124 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 22-06-2021 16:30:50 to 22-06-2021 16:30:52.

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          242872
MON$OLDEST_ACTIVE               243636
MON$OLDEST_SNAPSHOT             243636
MON$NEXT_TRANSACTION            243636
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                       2047520
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.33475 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33475 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33475 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33475 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 ---
:210: 
:211: mscs-test-161.budzdorov.ru    Tue Jun 22 16:27:46 2021
:212:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:213: 
:214: 
:215: mscs-test-161.budzdorov.ru    Tue Jun 22 16:27:56 2021
:216:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:217: 
--- end of diff output ---

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

22.06.21 16:30:53. 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-22 16:30:55 No severe PSQL-related problems occured
22.06.21 16:30:56. End of report.