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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17121880 kB
MemAvailable 31252156 kB
Buffers 0 kB
Cached 14552092 kB
SwapCached 4868 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-28 22:27:12
DTS_END                         2021-01-28 22:27:12.3380
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/45496
TRN_ID                          248909
ATT_ID                          708
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 120 minutes: 9365.94 20863 1123913
customer order: creation 184.20 343 22104
customer order: refuse 15.96 380 1915
order to supplier: creation 48.47 1272 5816
order to supplier: removal 3.68 86942 441
invoice (draft): creation 49.87 3236 5984
invoice (draft): removal 51.43 758 6171
invoice accept: apply 44.07 17082 5288
invoice accept: cancel 47.13 794 5656
customer reserve: creation 4012.58 171 481509
customer reserve: removal 4594.91 54 551389
realization accept: apply 90.13 179 10815
realization accept: cancel 86.08 110 10329
payment from customer: creation 63.02 113 7562
payment from customer: removal 6.22 98 746
payment to supplier: creation 51.57 128 6188
payment to supplier: removal 3.58 77 430
service: total inventory turnovers 5.28 1006 633
service: total monetary turnovers 6.92 74 830
service: aggregate perf. data 0.86 18733 103
service: refresh index statistics 0.03 285705 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3731
TEST_TIME 2 6873
TEST_TIME 3 6522
TEST_TIME 4 6552
TEST_TIME 5 6070
TEST_TIME 6 6090
TEST_TIME 7 6004
TEST_TIME 8 6225
TEST_TIME 9 6392
TEST_TIME 10 6446
TEST_TIME 11 6643
TEST_TIME 12 7001
TEST_TIME 13 7103
TEST_TIME 14 7169
TEST_TIME 15 7582
TEST_TIME 16 7639
TEST_TIME 17 8157
TEST_TIME 18 8732
TEST_TIME 19 9092
TEST_TIME 20 9292
TEST_TIME 21 9293
TEST_TIME 22 9336
TEST_TIME 23 9570
TEST_TIME 24 10001
TEST_TIME 25 10390
TEST_TIME 26 11080
TEST_TIME 27 11197
TEST_TIME 28 11257
TEST_TIME 29 11032
TEST_TIME 30 11169
TEST_TIME 31 10958
TEST_TIME 32 10708
TEST_TIME 33 10608
TEST_TIME 34 10646
TEST_TIME 35 10697
TEST_TIME 36 10575
TEST_TIME 37 10413
TEST_TIME 38 10361
TEST_TIME 39 10298
TEST_TIME 40 10293
TEST_TIME 41 10420
TEST_TIME 42 10268
TEST_TIME 43 10126
TEST_TIME 44 10013
TEST_TIME 45 9894
TEST_TIME 46 10008
TEST_TIME 47 10011
TEST_TIME 48 9941
TEST_TIME 49 10049
TEST_TIME 50 9986
TEST_TIME 51 9981
TEST_TIME 52 10129
TEST_TIME 53 10096
TEST_TIME 54 10044
TEST_TIME 55 10133
TEST_TIME 56 10172
TEST_TIME 57 10108
TEST_TIME 58 10101
TEST_TIME 59 10143
TEST_TIME 60 10072
TEST_TIME 61 10013
TEST_TIME 62 9956
TEST_TIME 63 9871
TEST_TIME 64 9837
TEST_TIME 65 9788
TEST_TIME 66 9800
TEST_TIME 67 9735
TEST_TIME 68 9829
TEST_TIME 69 9894
TEST_TIME 70 9898
TEST_TIME 71 9893
TEST_TIME 72 9913
TEST_TIME 73 9917
TEST_TIME 74 9879
TEST_TIME 75 9868
TEST_TIME 76 9967
TEST_TIME 77 9960
TEST_TIME 78 9997
TEST_TIME 79 10032
TEST_TIME 80 10083
TEST_TIME 81 9984
TEST_TIME 82 9949
TEST_TIME 83 9872
TEST_TIME 84 9799
TEST_TIME 85 9870
TEST_TIME 86 9813
TEST_TIME 87 9774
TEST_TIME 88 9721
TEST_TIME 89 9651
TEST_TIME 90 9607
TEST_TIME 91 9610
TEST_TIME 92 9643
TEST_TIME 93 9614
TEST_TIME 94 9627
TEST_TIME 95 9685
TEST_TIME 96 9657
TEST_TIME 97 9676
TEST_TIME 98 9658
TEST_TIME 99 9669
TEST_TIME 100 9638
TEST_TIME 101 9754
TEST_TIME 102 9770
TEST_TIME 103 9731
TEST_TIME 104 9770
TEST_TIME 105 9753
TEST_TIME 106 9796
TEST_TIME 107 9725
TEST_TIME 108 9676
TEST_TIME 109 9645
TEST_TIME 110 9625
TEST_TIME 111 9613
TEST_TIME 112 9575
TEST_TIME 113 9547
TEST_TIME 114 9500
TEST_TIME 115 9465
TEST_TIME 116 9439
TEST_TIME 117 9416
TEST_TIME 118 9425
TEST_TIME 119 9435
TEST_TIME 120 9367

Performance per minute, chart


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

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 1570114 1570114 0 0.00 0 13705 6 0 0
doc_list_biud 1570114 1570114 0 0.00 0 38693 25 0 0
sp_add_invoice_to_stock 5398 5288 110 2.03 26 175107 17083 0 110
sp_cancel_adding_invoice 5656 5656 0 0.00 5 56422 795 0 0
sp_cancel_client_order 1915 1915 0 0.00 4 11032 380 0 0
sp_cancel_customer_reserve 551389 551389 0 0.00 1 24129 55 0 0
sp_cancel_pay_from_customer 746 746 0 0.00 3 7053 99 0 0
sp_cancel_pay_to_supplier 430 430 0 0.00 3 4387 78 0 0
sp_cancel_supplier_invoice 6181 6171 10 0.16 2 38697 759 0 10
sp_cancel_supplier_order 441 441 0 0.00 7 961618 86943 0 0
sp_cancel_write_off 10329 10329 0 0.00 1 8718 111 0 0
sp_client_order 22104 22104 0 0.00 4 20974 343 0 0
sp_customer_reserve 481509 481509 0 0.00 0 123620 171 0 0
sp_fill_shopping_cart 33874 33874 0 0.00 1 11302 35 0 0
sp_fill_shopping_cart_clo_res 481506 481506 0 0.00 0 14238 12 0 0
sp_get_clo_for_invoice 5283 5283 0 0.00 0 16203 248 0 0
sp_kill_cost_storno 17161 17161 0 0.00 0 6332 52 0 0
sp_kill_qstorno_ret_qs2qd 1119719 1119719 0 0.00 0 38691 30 0 0
sp_kill_qty_storno 591999 591999 0 0.00 0 38692 66 0 0
sp_lock_selected_doc 22355 22355 0 0.00 0 9119 8 0 0
sp_make_cost_storno 29848 29848 0 0.00 0 12092 53 0 0
sp_multiply_rows_for_pdistr 29848 29848 0 0.00 0 7460 27 0 0
sp_multiply_rows_for_qdistr 22104 22104 0 0.00 0 19648 158 0 0
sp_pay_from_customer 7562 7562 0 0.00 4 23478 114 0 0
sp_pay_to_supplier 6188 6188 0 0.00 5 16920 129 0 0
sp_payment_common 13750 13750 0 0.00 1 23442 29 0 0
sp_qd_handle_on_cancel_clo 1915 1915 0 0.00 0 11025 347 0 0
sp_qd_handle_on_invoice_upd_sts 10939 10939 0 0.00 0 21186 334 0 0
sp_qd_handle_on_reserve_upd_sts 10815 10815 0 0.00 0 15493 61 0 0
sp_reserve_write_off 10815 10815 0 0.00 6 15556 180 0 0
sp_supplier_invoice 5984 5984 0 0.00 6 80960 3236 0 0
sp_supplier_order 5816 5816 0 0.00 5 30435 1273 0 0
srv_aggregate_perf_data 103 103 0 0.00 2871 135719 18734 0 0
srv_fill_mon_cache_memory 167 167 0 0.00 1178 141209 31974 0 0
srv_find_qd_qs_mism 1073609 1073609 0 0.00 0 13705 6 0 0
srv_make_invnt_saldo 633 633 0 0.00 28 29940 1006 0 0
srv_make_money_saldo 830 830 0 0.00 0 32607 74 0 0
srv_recalc_idx_stat 4 4 0 0.00 154409 413018 285705 0 0
t$perf-abend:sp_add_invoice_to_stock 110 110 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5288 5288 0 0.00 0 22140 169 0 0
t$perf-norm:sp_cancel_adding_invoice 496 496 0 0.00 0 4691 93 0 0
t$perf-norm:sp_cancel_client_order 1915 1915 0 0.00 0 5998 19 0 0
t$perf-norm:sp_cancel_customer_reserve 708 708 0 0.00 0 5935 25 0 0
t$perf-norm:sp_cancel_pay_from_customer 746 746 0 0.00 0 6887 18 0 0
t$perf-norm:sp_cancel_pay_to_supplier 430 430 0 0.00 0 1426 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 436 436 0 0.00 0 3960 23 0 0
t$perf-norm:sp_cancel_supplier_order 441 441 0 0.00 0 30275 1397 0 0
t$perf-norm:sp_cancel_write_off 1097 1097 0 0.00 0 8611 19 0 0
t$perf-norm:sp_client_order 22104 22104 0 0.00 0 10830 16 0 0
t$perf-norm:sp_customer_reserve 1007 1007 0 0.00 0 2213 10 0 0
t$perf-norm:sp_pay_from_customer 7562 7562 0 0.00 0 7910 9 0 0
t$perf-norm:sp_pay_to_supplier 6188 6188 0 0.00 0 12715 8 0 0
t$perf-norm:sp_reserve_write_off 10815 10815 0 0.00 0 9228 12 0 0
t$perf-norm:sp_supplier_invoice 5984 5984 0 0.00 0 3162 13 0 0
t$perf-norm:sp_supplier_order 5816 5816 0 0.00 0 5856 15 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 719 22 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 6211 48 0 0
t$perf-norm:srv_make_invnt_saldo 633 633 0 0.00 0 980 24 0 0
t$perf-norm:srv_make_money_saldo 830 830 0 0.00 0 689 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 1473 372 0 0
v_add_invoice_to_stock 10762 10542 220 2.04 0 6966 19 0 220
v_all_customers 39956 39956 0 0.00 0 100 1 0 0
v_all_suppliers 32282 32282 0 0.00 0 17 1 0 0
v_all_wares 44196 44196 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 992 992 0 0.00 0 2177 13 0 0
v_cancel_client_order 3830 3830 0 0.00 0 8768 8 0 0
v_cancel_customer_prepayment 1492 1492 0 0.00 0 6190 15 0 0
v_cancel_customer_reserve 1416 1416 0 0.00 0 2092 6 0 0
v_cancel_payment_to_supplier 860 860 0 0.00 0 4285 14 0 0
v_cancel_supplier_invoice 892 872 20 2.24 0 1824 17 0 20
v_cancel_supplier_order 882 882 0 0.00 0 1075 4 0 0
v_cancel_write_off 2194 2194 0 0.00 0 5348 16 0 0
v_max_id_clo_ord 5816 5816 0 0.00 0 9569 4 0 0
v_max_id_clo_res 1007 1007 0 0.00 0 3245 17 0 0
v_max_id_ord_sup 5960 5960 0 0.00 0 3232 3 0 0
v_max_non_paid_invoice 1823 1823 0 0.00 0 467 3 0 0
v_max_non_paid_realizn 4163 4163 0 0.00 0 2204 4 0 0
v_min_id_clo_ord 5816 5816 0 0.00 0 3347 6 0 0
v_min_id_clo_res 1007 1007 0 0.00 0 9378 13 0 0
v_min_id_ord_sup 5960 5960 0 0.00 0 3422 8 0 0
v_min_non_paid_invoice 6188 6188 0 0.00 0 6575 13 0 0
v_min_non_paid_realizn 7562 7562 0 0.00 0 6975 15 0 0
v_our_firm 11038 11038 0 0.00 0 12 1 0 0
v_reserve_write_off 21630 21630 0 0.00 0 6616 7 0 0
x_lock_depdocs_on_canc_invoice 11391 11391 0 0.00 0 19118 111 0 0
x_lock_depdocs_on_canc_sup_ord 441 441 0 0.00 0 15234 339 0 0
x_make_qstorno_1000_1200 5816 5816 0 0.00 1 30410 1197 0 0
x_make_qstorno_1200_2000 5984 5984 0 0.00 2 78115 3102 0 0
x_make_qstorno_2100_3300 481509 481509 0 0.00 0 123595 157 0 0

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

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:16 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:22 26022 8192000000 10292072208 10601701376 898266496 9.881 70 57 114 0 919592912 2650592 18675824
19:57:58 40843 8192000000 10357956240 10676420608 1398095104 14.578 100 88 176 1 1432264160 5418240 28750816
19:58:48 35588 8192000000 10395611424 10721288192 1446239520 15.005 100 88 176 0 1481787392 6987488 28560384
19:59:31 31619 8192000000 10415951872 10746802176 1467437152 15.191 100 90 180 1 1504913696 7824048 29652496
20:00:12 7238 8192000000 10425406448 10755944448 1481958128 15.319 100 89 178 0 1519209024 8120416 29130480
20:00:30 19063 8192000000 10444194192 10779201536 1495027104 15.433 100 87 174 1 1531792032 8233168 28531760
20:01:03 20418 8192000000 10466540192 10805305344 1523348720 15.679 100 89 178 0 1560712000 8970640 28392640
20:01:31 16876 8192000000 10478834096 10823524352 1536889984 15.797 100 79 159 0 1570987024 9126816 24970224
20:01:56 10564 8192000000 10502233568 10851794944 1559987760 15.996 100 78 156 1 1593018528 8776128 24254640
20:02:19 12156 8192000000 10525845264 10882736128 1591239856 16.264 100 71 139 2 1621063376 8920336 20903184
20:02:40 8641 8192000000 10555133648 10914430976 1613405824 16.454 100 68 136 2 1643915072 10145872 20363376
20:02:57 13428 8192000000 10578552480 10940887040 1637828016 16.661 100 77 154 2 1671424704 10792512 22804176
20:03:21 10338 8192000000 10589470800 10957590528 1660599504 16.854 100 77 154 0 1694133904 11053360 22481040
20:03:38 8644 8192000000 10612083664 10977374208 1676472048 16.988 100 79 158 1 1711442528 11689488 23280992
20:03:57 7567 8192000000 10627879968 10998820864 1691877728 17.117 100 70 140 3 1723520320 11895568 19747024
20:04:12 6990 8192000000 10642834464 11012669440 1712066112 17.286 100 84 168 0 1748788208 12667616 24054480
20:04:28 6885 8192000000 10659998640 11037650944 1723074480 17.378 100 83 166 0 1759328032 12600496 23653056
20:04:41 7788 8192000000 10689341312 11062444032 1735575424 17.482 100 78 155 1 1769959776 12291840 22092512
20:04:56 5463 8192000000 10694814240 11070930944 1753763168 17.633 100 74 147 4 1786987136 12128384 21095584
20:05:08 5859 8192000000 10712398176 11088322560 1765798096 17.732 100 75 151 0 1799044080 11839440 21406544
20:05:22 5551 8192000000 10712368224 11093127168 1776849088 17.824 100 78 155 1 1811196944 13288080 21059776
20:05:34 4505 8192000000 10718962848 11098128384 1778779552 17.839 100 78 154 1 1813947488 13783568 21384368
20:05:46 4468 8192000000 10730338912 11111047168 1787945872 17.915 100 84 167 1 1825568080 14353824 23268384
20:05:57 3088 8192000000 10737940288 11116945408 1794496400 17.969 100 85 170 2 1832167216 14246976 23423840
20:06:06 11157 8192000000 10738094816 11125534720 1799284352 18.008 100 74 148 0 1833285328 13673280 20327696
20:06:25 3683 8192000000 10750292032 11136442368 1802622624 18.035 100 79 156 1 1837296576 12758368 21915584
20:06:35 2552 8192000000 10758166320 11143348224 1824728096 18.216 100 76 152 1 1858510560 12068944 21713520
20:06:45 2326 8192000000 10771003936 11159478272 1833166624 18.285 100 81 163 2 1868723232 12696672 22859936
20:06:54 2673 8192000000 10776651904 11164557312 1840237648 18.343 100 94 185 3 1879133792 12429232 26466912
20:07:03 2215 8192000000 10782130256 11167580160 1843827696 18.372 100 89 178 0 1880575280 11430352 25317232
20:07:12 2466 8192000000 10790982512 11174178816 1847480336 18.402 100 85 166 3 1884666768 13424608 23761824
20:07:21 1947 8192000000 10795452944 11182780416 1848558576 18.410 100 87 175 0 1886529472 14308624 23662272
20:07:29 1847 8192000000 10797188688 11182645248 1851212560 18.432 100 90 181 0 1891056144 14435456 25408128
20:07:37 1881 8192000000 10792370560 11176398848 1854103280 18.455 100 93 186 0 1894632672 14666736 25862656
20:07:45 1634 8192000000 10804740208 11190456320 1857607520 18.484 100 94 187 1 1898642784 15656544 25378720
20:07:54 1818 8192000000 10805876464 11195129856 1861910320 18.519 100 89 180 2 1900899792 14292960 24696512
20:08:02 1041 8192000000 10804010800 11192066048 1865983072 18.552 100 87 175 1 1905323200 14381424 24958704
20:08:09 7723 8192000000 10792120496 11196407808 1867389408 18.563 100 76 152 0 1901809504 13597504 20822592
20:08:31 4370 8192000000 10795199808 11196452864 1866707648 18.558 100 73 145 1 1899924000 12990752 20225600
20:08:42 2950 8192000000 10774746016 11193401344 1862621952 18.525 100 46 92 0 1886462992 10164224 13676816
20:08:52 9749 8192000000 10778387520 11193745408 1863876160 18.535 100 39 79 1 1881263376 6226432 11160784
20:09:08 6511 8192000000 10778726192 11199459328 1866866576 18.559 100 42 83 1 1887731952 8992272 11873104
20:09:21 1848 8192000000 10795794640 11203735552 1873819760 18.615 100 60 122 4 1898567792 7741920 17006112
20:09:32 12970 8192000000 10780606832 11199647744 1866308832 18.554 100 22 44 2 1879442864 6655664 6478368
20:09:52 6759 8192000000 10775945056 11198451712 1867148400 18.561 100 24 48 4 1880829072 6377168 7303504
20:10:05 7658 8192000000 10771493408 11202170880 1867771152 18.566 100 17 34 0 1878441424 6006080 4664192
20:10:24 10569 8192000000 10769064768 11205578752 1875084320 18.625 100 25 48 0 1888695040 6585024 7025696
20:10:45 9270 8192000000 10783470976 11212226560 1872474640 18.604 100 14 27 2 1881936416 5639120 3822656
20:11:01 8399 8192000000 10782709744 11215761408 1879633504 18.662 100 22 44 2 1893114800 6651568 6829728
20:11:18 8026 8192000000 10789343296 11221262336 1883930816 18.697 100 20 40 0 1899590800 10424464 5235520
20:11:32 60756 8192000000 10802066288 11226730496 1887278064 18.724 100 24 48 0 1899528032 5129440 7120528
20:12:41 22970 8192000000 10811337152 11239743488 1890181200 18.747 100 28 55 1 1904540000 6653168 7705632
20:13:13 5066 8192000000 10815979040 11252531200 1894237808 18.780 100 27 54 1 1908762656 7528960 6995888
20:13:24 3925 8192000000 10827048512 11246358528 1900773328 18.833 100 43 85 2 1920671760 6803536 13094896
20:13:37 5442 8192000000 10827227776 11252846592 1901738688 18.840 100 36 72 1 1923863152 11713584 10410880
20:13:49 8830 8192000000 10812372256 11246243840 1902361264 18.845 100 29 58 4 1917279984 7018848 7899872
20:14:04 4099 8192000000 10829983168 11255427072 1903500992 18.854 100 30 60 0 1919390784 7138848 8750944
20:14:16 3042 8192000000 10825020512 11253460992 1903699328 18.856 100 25 48 1 1916092896 5177648 7215920
20:14:27 3886 8192000000 10836800000 11260571648 1908679616 18.896 100 28 56 0 1923680960 6491248 8510096
20:14:44 11091 8192000000 10819055312 11257663488 1910368576 18.910 100 23 46 1 1923109936 5774336 6967024
20:15:01 7692 8192000000 10811602512 11246698496 1884314224 18.700 99 10 20 1 1892140160 4924064 2901872
20:15:15 11638 8192000000 10810697216 11252113408 1906078480 18.875 100 23 46 1 1918557712 6095872 6383360
20:15:34 16233 8192000000 10813672880 11252482048 1894277728 18.780 99 20 40 0 1905972608 6064352 5630528
20:15:57 7490 8192000000 10832661840 11262533632 1909765968 18.905 100 21 41 1 1921097680 5781552 5550160
20:16:16 60532 8192000000 10843253952 11255521280 1882666752 18.687 98 46 91 0 1902763216 6026736 14069728
20:17:23 10795 8192000000 10809468304 11251273728 1888036784 18.730 99 16 32 0 1898570528 5886848 4646896
20:17:40 7803 8192000000 10796085552 11221778432 1825879616 18.226 96 30 61 1 1840724544 5708512 9136416
20:17:54 6858 8192000000 10797801888 11221569536 1863075536 18.528 99 41 82 3 1885202656 11002400 11124720
20:18:07 3478 8192000000 10795890560 11224264704 1875049040 18.625 100 45 88 1 1898895424 11946800 11899584
20:18:19 3747 8192000000 10755628832 11181637632 1813833008 18.127 97 28 55 2 1828156176 6464096 7859072
20:18:32 5112 8192000000 10737735408 11157651456 1797773984 17.996 98 28 56 0 1811997472 5993008 8230480
20:18:43 9518 8192000000 10734901280 11155742720 1774650592 17.805 97 25 50 2 1787522816 5905760 6966464
20:19:00 6725 8192000000 10725070464 11142946816 1752579904 17.623 96 21 41 0 1764384400 5974848 5829648
20:19:13 8799 8192000000 10727346336 11140620288 1746975744 17.577 96 26 52 1 1760265712 5046960 8243008
20:19:28 8053 8192000000 10701481600 11121930240 1775296720 17.811 99 21 42 1 1787772496 6934224 5541552
20:19:44 6156 8192000000 10684882912 11100487680 1732789120 17.459 97 28 56 2 1746467344 5666752 8011472
20:20:00 5696 8192000000 10686184608 11104247808 1774773120 17.806 100 18 36 1 1784923808 5469152 4681536
20:20:13 10871 8192000000 10712480256 11130089472 1778713712 17.839 99 14 28 0 1788356656 5648800 3994144
20:20:30 12079 8192000000 10716040224 11140698112 1790314912 17.934 99 15 30 1 1800366304 5547632 4503760
20:20:54 13662 8192000000 10704136672 11115311104 1754665424 17.640 97 21 42 1 1765936896 5543248 5728224
20:21:14 69307 8192000000 10674793136 11093651456 1641202240 16.690 91 22 44 0 1652222304 5099408 5920656
20:22:33 9511 8192000000 10716430032 11130597376 1778563040 17.838 99 22 44 0 1790795168 6295760 5936368
20:22:51 5256 8192000000 10717486960 11143172096 1805174736 18.056 100 34 66 0 1825682080 11517264 8990080
20:23:02 8044 8192000000 10758053584 11177897984 1828367984 18.246 100 41 82 0 1850955744 11662080 10925680
20:23:17 3730 8192000000 10756680688 11175792640 1824395216 18.214 99 32 64 1 1843940368 10696000 8849152
20:23:27 6048 8192000000 10754959872 11177054208 1837603072 18.321 100 18 36 0 1848746720 6107328 5036320
20:23:42 4617 8192000000 10771499280 11190108160 1846975888 18.398 100 23 44 1 1862842928 10027552 5839488
20:23:53 7130 8192000000 10763746288 11192786944 1855756800 18.469 100 26 51 4 1870075136 6884256 7434080
20:24:07 12837 8192000000 10762716608 11195523072 1855485712 18.467 100 13 26 2 1868138032 9430400 3221920
20:24:26 7117 8192000000 10775977312 11205353472 1864323008 18.538 100 30 58 2 1879388816 6122736 8943072
20:24:39 7392 8192000000 10781989968 11209400320 1869872672 18.583 100 24 48 1 1882252576 5490640 6889264
20:24:56 8466 8192000000 10784273664 11217256448 1874842400 18.623 100 24 47 1 1887445200 5314016 7288784
20:25:11 16943 8192000000 10791695488 11220701184 1874556080 18.621 100 19 36 2 1886153888 5259968 6337840
20:25:38 7700 8192000000 10784807296 11221319680 1877367584 18.644 100 26 52 1 1890082096 5681920 7032592
20:25:52 9303 8192000000 10793223296 11226767360 1879188032 18.659 100 19 38 3 1890287296 5874656 5224608
20:26:08 16537 8192000000 10790127056 11214516224 1871648320 18.598 99 37 72 4 1888167952 4949520 11570112
20:26:32 64473 8192000000 10855691696 11267059712 1897682608 18.808 100 50 96 2 1916470880 5089536 13698736
20:27:44 11826 8192000000 10857521472 11270574080 1920341184 18.990 100 65 130 0 1948549536 9295760 18912592
20:28:33 28891 8192000000 10874557632 11292987392 1932105184 19.084 100 59 116 2 1959581200 10855616 16620400
20:29:10 23363 8192000000 10871057152 11302367232 1941080032 19.155 100 46 89 3 1966505472 12881424 12544016
20:29:40 8155 8192000000 10887729808 11314745344 1950127872 19.227 100 55 110 0 1977877008 12560096 15189040
20:29:56 3335 8192000000 10896973568 11318554624 1956889072 19.281 100 64 127 2 1987497696 13017888 17590736
20:30:08 15900 8192000000 10893212592 11323031552 1958697712 19.296 100 51 102 1 1986320864 13114928 14508224
20:30:32 27028 8192000000 10898194960 11330859008 1962986272 19.330 100 48 96 0 1990144880 13826800 13331808
20:31:08 4474 8192000000 10905968960 11336351744 1967989024 19.369 100 48 96 2 1996776176 14964160 13822992
20:31:24 17364 8192000000 10913627680 11343691776 1971102176 19.394 100 43 84 2 1998877904 14702336 13073392
20:32:27 2894 8192000000 10932104912 11355316224 1984644448 19.501 100 62 125 0 2020071408 16803024 18623936
20:32:47 13487 8192000000 10920674208 11358461952 1988217872 19.530 100 55 110 0 2022455360 18639840 15597648
20:33:07 12735 8192000000 10935044880 11367157760 1990087776 19.544 100 51 100 2 2024552368 19339328 15125264
20:33:30 12209 8192000000 10943596464 11372822528 1996958576 19.599 100 65 129 2 2035633312 18927936 19746800
20:33:50 5731 8192000000 10939354368 11367952384 1990076544 19.544 100 61 121 1 2028238272 19710352 18451376
20:34:05 16155 8192000000 10943130256 11376705536 1995894208 19.590 100 53 106 2 2031666784 20321744 15450832
20:34:30 2895 8192000000 10970837280 11385888768 2009161152 19.695 100 79 158 1 2053850688 21249808 23439728
20:34:39 4385 8192000000 10962316192 11387092992 2007055296 19.678 100 70 140 1 2050262368 22300080 20906992
20:34:51 16675 8192000000 10967998448 11392708608 2011364480 19.712 100 74 148 1 2056451360 23630816 21456064
20:35:16 10376 8192000000 10950010384 11377483776 1992537152 19.564 99 66 130 0 2036625200 23551680 20536368
20:35:44 4956 8192000000 10965209744 11396354048 2011210992 19.711 100 56 112 2 2052583920 23809968 17562960
20:36:00 10846 8192000000 10959907280 11400974336 2012115792 19.718 100 41 82 2 2051520432 26389424 13015216
20:36:18 9205 8192000000 10972956944 11407568896 2019841808 19.779 100 50 99 1 2060294800 25107888 15345104
20:36:36 3332 8192000000 10978112688 11406843904 2023176624 19.805 100 66 131 2 2067883360 25088992 19617744
20:36:49 7730 8192000000 10983565424 11415134208 2027181536 19.837 100 61 122 0 2072284864 27026768 18076560
20:37:08 7652 8192000000 10985743456 11419938816 2029862272 19.858 100 67 134 3 2078941248 28413648 20665328
20:37:23 6152 8192000000 10978141600 11412316160 2008393680 19.689 99 62 124 1 2055414032 28264640 18755712
20:37:38 3763 8192000000 10983157104 11415269376 2027489344 19.839 100 61 121 1 2074708592 28864784 18354464
20:37:52 4369 8192000000 10958889072 11382910976 1979153168 19.458 98 73 146 0 2031313648 29504640 22655840
20:38:05 5690 8192000000 10959468544 11386376192 1995745584 19.589 100 63 125 1 2045888272 31242528 18900160
20:38:19 4651 8192000000 10981108064 11402043392 2009991680 19.701 100 75 149 3 2064381728 32217968 22172080
20:38:30 2585 8192000000 10992903776 11411791872 2020538784 19.784 100 80 160 0 2078807840 34028112 24240944
20:38:40 2950 8192000000 10992566560 11421175808 2024496176 19.815 100 73 147 1 2080678656 34237184 21945296
20:38:52 4149 8192000000 10995236400 11416580096 2020554224 19.785 100 72 144 1 2077450560 34428240 22468096
20:39:05 7345 8192000000 10954377952 11366371328 1980214336 19.466 99 73 146 0 2033713216 31355712 22143168
20:39:23 6630 8192000000 10964714864 11395026944 2002720768 19.644 100 69 138 3 2055128032 31659760 20747504
20:39:39 2794 8192000000 10970285344 11391684608 1988417280 19.531 99 66 130 2 2038838672 31027680 19393712
20:39:51 4150 8192000000 10982996704 11404767232 2015274720 19.743 100 77 154 1 2071916352 33309504 23332128
20:40:01 1391 8192000000 10984065008 11406815232 2010316304 19.704 100 80 157 3 2070199920 34685536 25198080
20:40:10 2264 8192000000 10977413024 11395584000 1996990912 19.599 99 73 143 3 2051098704 32739984 21367808
20:40:24 2696 8192000000 10963824240 11388067840 1984732000 19.502 99 75 150 0 2042431280 33719088 23980192
20:40:34 2352 8192000000 10946534368 11368660992 1982057488 19.481 100 71 142 2 2038579808 34852816 21669504
20:40:44 5191 8192000000 10959084192 11377917952 1978668544 19.454 100 69 140 0 2040566432 40515216 21382672
20:40:59 2504 8192000000 10966627248 11383521280 1983279088 19.491 100 87 169 2 2047012736 37095200 26638448
20:41:10 7371 8192000000 10960092960 11387797504 1989637648 19.541 100 71 143 0 2049814400 38012176 22164576
20:41:29 2838 8192000000 10981563536 11395309568 1992062080 19.560 100 87 171 3 2056883248 38898464 25922704
20:41:40 10266 8192000000 10955806560 11378049024 1980171760 19.466 100 66 132 1 2041528608 40956656 20400192
20:41:57 1348 8192000000 10973838224 11383279616 1982999744 19.488 100 76 150 1 2050643312 44197584 23445984
20:42:06 2384 8192000000 10986960016 11405316096 2000603728 19.627 100 89 177 2 2072546704 44223360 27719616
20:42:16 4150 8192000000 10958027824 11377008640 1963905344 19.337 98 72 144 2 2026747904 41408416 21434144
20:42:29 1999 8192000000 10982548704 11395702784 1994350576 19.578 100 88 175 0 2064780480 43425328 27004576
20:42:38 5133 8192000000 10971942208 11388600320 1990467392 19.547 100 78 156 1 2058220656 43028368 24724896
20:42:50 3200 8192000000 10981783760 11399073792 1995097664 19.584 100 89 178 0 2066223872 43118736 28007472
20:43:01 1944 8192000000 10972170672 11385360384 1982016624 19.481 100 80 160 1 2052079760 45595904 24467232
20:43:11 5335 8192000000 10989504880 11402739712 1994308384 19.578 100 89 177 2 2069149872 47650144 27191344
20:43:27 4565 8192000000 10936860288 11351203840 1943681280 19.176 98 74 148 0 2015422736 48361552 23379904
20:43:44 3826 8192000000 10981281136 11399467008 1985801552 19.511 100 78 154 3 2062357296 52064448 24491296
20:43:54 1175 8192000000 10973287120 11385765888 1977058192 19.441 100 83 166 2 2056982256 52056224 27867840
20:44:03 5645 8192000000 10949381168 11360452608 1954341088 19.261 100 73 145 1 2029060096 51878592 22840416
20:44:18 2885 8192000000 10959629968 11372261376 1968270192 19.372 100 80 159 1 2041482928 48004592 25208144
20:44:27 2496 8192000000 10953245152 11371180032 1966375824 19.357 100 73 147 1 2039409808 49450080 23583904
20:44:36 3291 8192000000 10955528768 11374018560 1945498912 19.191 99 71 142 0 2017181904 49286704 22396288
20:44:48 2894 8192000000 10956426976 11359854592 1947182752 19.204 99 81 160 0 2024655488 51328496 26144240
20:44:57 5305 8192000000 10938489776 11357609984 1953628080 19.255 100 66 130 1 2024840096 50315760 20896256
20:45:12 11188 8192000000 10932049552 11359428608 1936844384 19.122 99 57 113 1 2003577808 47607456 19125968
20:45:31 8146 8192000000 10931453136 11354263552 1951617376 19.239 100 60 120 1 2017934272 46907616 19409280
20:45:52 23119 8192000000 10913253664 11361456128 1941390544 19.158 99 38 77 2 2000857856 46658256 12809056
20:46:23 13162 8192000000 10907272768 11349520384 1948492976 19.214 100 34 67 3 1995532944 35979616 11060352
20:46:49 18605 8192000000 10907481376 11350065152 1930988960 19.075 99 32 64 1 1981843312 39882480 10971872
20:47:16 12379 8192000000 10902429280 11342655488 1930650528 19.072 99 31 62 0 1980368688 39609584 10108576
20:47:35 12482 8192000000 10917930544 11356770304 1938914528 19.138 99 33 66 1 1988289312 38710448 10664336
20:47:57 13233 8192000000 10886057072 11324821504 1913416240 18.934 98 33 64 2 1958461776 34202272 10843264
20:48:16 22303 8192000000 10898841408 11341070336 1937265968 19.125 100 24 48 1 1980572960 35181424 8125568
20:48:45 17230 8192000000 10916373536 11358007296 1955562880 19.271 100 31 62 2 2004026896 38210784 10253232
20:49:09 18985 8192000000 10915283840 11357396992 1939529744 19.143 99 30 59 3 1990386128 40922112 9934272
20:49:35 15720 8192000000 10918673344 11363885056 1937163488 19.124 99 29 58 2 1992956896 45704848 10088560
20:50:04 20253 8192000000 10917853728 11358302208 1931600944 19.080 99 31 61 0 1983008144 40949776 10457424
20:50:34 11438 8192000000 10904616256 11346268160 1916412080 18.958 99 35 68 5 1970874112 42635296 11826736
20:50:54 19120 8192000000 10915899232 11353460736 1921505616 18.999 99 30 60 0 1978898336 45942592 11450128
20:51:20 24303 8192000000 10911572080 11355791360 1920441936 18.990 99 31 63 2 1985141648 52805552 11894160
20:51:57 22478 8192000000 10878947408 11345207296 1916586592 18.959 99 18 36 2 1962234128 39352192 6295344
20:52:30 28029 8192000000 10872286544 11327369216 1907594896 18.887 99 14 28 0 1942439168 29804048 5040224
20:53:04 30820 8192000000 10874306608 11321778176 1889390240 18.741 98 15 30 0 1932721392 37968912 5362240
20:53:49 41111 8192000000 10848205456 11309731840 1897409968 18.805 99 13 26 0 1914244016 12961488 3872560
20:54:44 41948 8192000000 10850069072 11291000832 1880057312 18.666 98 33 68 1 1897315792 7108416 10150064
20:55:35 39465 8192000000 10843271824 11303321600 1899512752 18.822 99 16 32 0 1919173360 14853792 4806816
20:56:45 66458 8192000000 10866335632 11335483392 1931001104 19.075 100 8 16 0 1950302352 16708080 2593168
20:58:02 116389 8192000000 10872295632 11326808064 1889233264 18.740 97 17 33 1 1907048080 13544576 4270240
21:00:29 122361 8192000000 10881892928 11340255232 1871114176 18.593 96 28 54 1 1896857504 18103440 7639888
21:02:39 141209 8192000000 10893360928 11341332480 1929939680 19.066 99 34 68 0 1948737040 9119440 9677920
21:05:07 51369 8192000000 10903090368 11360727040 1936738512 19.121 99 21 42 1 1950553632 7801120 6014000
21:06:08 25404 8192000000 10899902736 11352141824 1943651600 19.176 99 28 52 6 1961104640 9741808 7711232
21:07:00 8965 8192000000 10914321040 11358683136 1952289552 19.245 99 59 117 3 1980229664 10793936 17146176
21:07:21 33042 8192000000 10907623696 11373936640 1970410240 19.389 100 47 94 0 2002285456 17533488 14341728
21:08:08 22017 8192000000 10909148448 11372847104 1975383536 19.428 100 40 80 1 2002160752 14873088 11904128
21:09:14 44728 8192000000 10918705328 11385536512 1984570096 19.501 100 13 26 0 2000349888 12335648 3444144
21:10:57 62117 8192000000 10934631168 11402113024 2002137472 19.640 100 19 38 0 2020915248 12872320 5905456
21:12:05 50110 8192000000 10930831872 11404267520 2002421808 19.642 100 18 36 1 2022149712 14165600 5562304
21:13:04 40614 8192000000 10920880480 11407298560 1979717440 19.462 99 19 38 2 2001219248 15740064 5761744
21:13:51 44604 8192000000 10930649600 11415474176 1986973552 19.520 100 3 6 0 1999783488 12123952 685984
21:14:41 67626 8192000000 10935210048 11401125888 2003207296 19.648 100 20 40 0 2024475840 15546432 5722112
21:15:59 32732 8192000000 10926280864 11392503808 1979729376 19.463 99 26 52 0 1997705984 10809552 7167056
21:16:40 37926 8192000000 10922145792 11391922176 1951752160 19.240 98 19 38 0 1965737440 8766976 5218304
21:17:24 52441 8192000000 10919815376 11384279040 1972961664 19.409 99 27 52 0 1989543392 9343792 7237936
21:18:27 65664 8192000000 10918834976 11384041472 1953110816 19.251 98 19 38 1 1971367792 12786880 5470096
21:19:39 65255 8192000000 10891451840 11362414592 1904800928 18.865 96 17 34 0 1921551360 11995344 4755088
21:20:51 36146 8192000000 10922429504 11372253184 1970586192 19.390 100 26 49 0 1988417872 10998672 6833008
21:21:34 107146 8192000000 10913960976 11393908736 1957926064 19.290 99 21 42 0 1977958816 14389616 5643136
21:23:28 63130 8192000000 10905578592 11366887424 1918667296 18.976 97 21 42 1 1934526080 10123776 5735008
21:24:45 35223 8192000000 10901023888 11346075648 1884488672 18.701 96 34 69 0 1902261264 8383680 9388912
21:25:30 40851 8192000000 10883061920 11328753664 1857513920 18.483 95 30 60 1 1874628192 8773952 8340320
21:26:19 44195 8192000000 10872006864 11329933312 1881928544 18.681 97 27 55 0 1901018608 11631136 7458928
21:27:09 43368 8192000000 10840485152 11302150144 1903783136 18.857 99 9 18 2 1917203088 11039712 2380240
21:28:27 67570 8192000000 10835546816 11288731648 1780386880 17.853 92 22 44 1 1795248160 8662320 6198960
21:29:43 53328 8192000000 10850702832 11319590912 1926606752 19.040 100 22 44 2 1945061440 12287040 6167648
21:30:43 20061 8192000000 10862177952 11319263232 1919462064 18.983 99 29 58 0 1940877536 12725040 8690432
21:31:12 71172 8192000000 10815259056 11283271680 1835748960 18.306 95 15 30 0 1851803184 11649968 4404256
21:32:31 62055 8192000000 10845402352 11320143872 1873101440 18.609 98 10 20 0 1887240080 11295680 2842960
21:33:39 88105 8192000000 10843174224 11300151296 1837828432 18.323 95 15 30 0 1857626048 14385168 5412448
21:35:24 78042 8192000000 10835565280 11295735808 1833177440 18.285 96 19 38 1 1848688416 9670912 5840064
21:36:57 60330 8192000000 10853756736 11289042944 1834073168 18.293 96 26 52 1 1853362848 11317008 7972672
21:38:06 53609 8192000000 10830983728 11298668544 1852311840 18.441 97 16 31 2 1866595504 9291328 4992336
21:39:17 47640 8192000000 10836021440 11305209856 1871799328 18.599 98 40 81 1 1899911456 16509824 11602304
21:40:29 73156 8192000000 10844050464 11295731712 1818908096 18.169 95 23 46 1 1834996432 9286672 6801664
21:41:50 29113 8192000000 10875842224 11312971776 1897810672 18.809 99 37 72 1 1920817440 13618864 9387904
21:42:25 28408 8192000000 10871199600 11329093632 1925028112 19.027 100 36 71 1 1952075216 17054960 9992144
21:43:04 33044 8192000000 10858395184 11345039360 1905558160 18.871 99 9 18 0 1925741040 17707488 2475392
21:43:54 48047 8192000000 10873892944 11324395520 1876447792 18.636 97 20 40 1 1891664112 9611456 5604864
21:44:48 42531 8192000000 10863469552 11331854336 1906246160 18.877 99 24 48 1 1927953360 15380096 6327104
21:45:37 36115 8192000000 10878571488 11331719168 1928500384 19.055 100 13 26 1 1942070912 9693696 3876832
21:46:40 62044 8192000000 10871184944 11345817600 1900501728 18.830 98 11 22 0 1915550944 11968464 3080752
21:47:59 106190 8192000000 10853301744 11329384448 1920013168 18.987 99 14 28 0 1933726736 9642976 4070592
21:50:02 56240 8192000000 10885319184 11358203904 1955750176 19.272 100 26 52 0 1975490192 12306832 7433184
21:51:05 30574 8192000000 10888443648 11336314880 1930763264 19.073 99 24 46 1 1948548384 11115712 6669408
21:51:42 74713 8192000000 10869456320 11354349568 1925628736 19.032 99 10 20 0 1939326848 10824864 2873248
21:53:07 26241 8192000000 10866695216 11357736960 1948291696 19.213 100 3 7 0 1958187952 9237424 658832
21:53:39 35560 8192000000 10859592400 11336327168 1912155584 18.924 98 14 28 2 1925112992 9507024 3450384
21:54:39 61845 8192000000 10857662768 11334356992 1910872096 18.914 98 12 25 0 1920260688 5968816 3419776
21:56:46 74661 8192000000 10889914928 11370270720 1960825104 19.313 100 18 36 1 1978367312 12993168 4549040
21:58:34 46055 8192000000 10896340608 11375177728 1952790832 19.249 99 15 30 0 1969468496 12481328 4196336
21:59:27 52097 8192000000 10909671392 11389374464 1974316656 19.420 100 16 32 1 1988664224 9995904 4351664
22:00:30 50038 8192000000 10917467904 11380518912 1959813408 19.305 99 21 42 1 1976114768 10492624 5808736
22:01:32 64909 8192000000 10910028752 11393695744 1982055840 19.481 100 19 38 1 2001345632 14063456 5226336
22:02:43 34254 8192000000 10919894432 11385147392 1974985216 19.425 99 27 54 1 1991081888 8169552 7927120
22:03:24 44481 8192000000 10915057504 11373981696 1929919536 19.066 97 20 40 1 1943479040 8173856 5385648
22:04:19 83102 8192000000 10932210176 11388272640 1921585040 19.000 97 19 38 0 1937887488 10865472 5436976
22:05:48 30590 8192000000 10932203472 11392823296 1969483456 19.381 99 38 75 1 1993235216 13441184 10310576
22:06:41 30658 8192000000 10931675424 11396804608 1984545376 19.501 100 32 64 0 2011883568 17946064 9392128
22:07:18 68717 8192000000 10922798448 11403628544 1948231856 19.212 98 19 38 0 1969822240 16511552 5078832
22:08:37 74036 8192000000 10901407280 11378352128 1924962720 19.027 97 12 22 2 1940901184 12485184 3453280
22:10:00 56054 8192000000 10927626272 11380195328 1930203024 19.069 97 32 64 2 1948347472 9287472 8856976
22:11:16 59704 8192000000 10890720576 11351949312 1904189936 18.860 97 22 44 0 1925098096 14724560 6183600
22:12:23 98428 8192000000 10886402496 11364941824 1890604752 18.751 97 21 42 1 1911040064 14947440 5487872
22:14:08 90432 8192000000 10874132528 11350663168 1944102496 19.179 100 20 40 1 1961113120 11233840 5776784
22:16:11 41531 8192000000 10844015280 11316674560 1874357440 18.620 96 9 18 0 1885737664 8849536 2530688
22:16:59 25221 8192000000 10853379072 11331514368 1932503056 19.087 100 13 25 1 1946497008 10096080 3897872
22:17:35 61212 8192000000 10848501120 11332014080 1912974000 18.931 99 6 12 0 1924885296 10152096 1759200
22:18:43 11631 8192000000 10848865808 11334660096 1927960240 19.051 100 7 14 1 1940996688 10945360 2091088
22:19:01 37481 8192000000 10847216128 11316621312 1871953424 18.600 97 18 36 1 1883455728 6714784 4787520
22:19:49 31069 8192000000 10870141824 11337625600 1939072336 19.139 100 18 36 0 1950516080 6160320 5283424
22:20:27 86621 8192000000 10838243520 11306745856 1831262528 18.270 94 17 34 0 1842027600 6125664 4639408
22:22:00 50440 8192000000 10829219952 11308802048 1888743296 18.736 98 22 43 1 1903342816 7961376 6638144
22:23:11 54026 8192000000 10836308304 11315781632 1901681136 18.840 99 8 16 0 1910883888 6839488 2363264
22:24:12 42907 8192000000 10835596944 11307040768 1888714416 18.735 98 13 26 0 1900429456 8375760 3339280
22:25:01 28894 8192000000 10862466064 11326394368 1928760800 19.057 100 24 48 4 1943164816 7194384 7209632
22:25:41 26237 8192000000 10831107664 11292172288 1815419440 18.140 94 26 52 0 1830900432 8300416 7180576
22:26:18 55810 8192000000 10750902496 11217297408 1754181568 17.636 92 25 48 1 1772638496 11658368 6798560

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 28-01-2021 22:28:40 to 28-01-2021 22:29:12.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 110 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

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

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          248106
MON$OLDEST_ACTIVE               249515
MON$OLDEST_SNAPSHOT             249515
MON$NEXT_TRANSACTION            249515
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                       2030816
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.33404 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33404 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33404 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33404 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 ---
:148: 
:149: mscs-test-161.budzdorov.ru    Thu Jan 28 22:27:17 2021
:150:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:151: 
:152: 
:153: mscs-test-161.budzdorov.ru    Thu Jan 28 22:27:23 2021
:154:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:155: 
:156: 
:157: mscs-test-161.budzdorov.ru    Thu Jan 28 22:27:23 2021
:158:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:159: 
--- end of diff output ---

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

28.01.21 22:29:16. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-01-28 22:29:18 No severe PSQL-related problems occured
28.01.21 22:29:19. End of report.