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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17225800 kB
MemAvailable 31332972 kB
Buffers 0 kB
Cached 14495544 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-22 01:27:11
DTS_END                         2021-01-22 01:27:11.4100
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/51662
TRN_ID                          240634
ATT_ID                          647
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: 9467.29 21222 1136075
customer order: creation 178.10 337 21372
customer order: refuse 15.45 305 1854
order to supplier: creation 47.48 1247 5697
order to supplier: removal 3.41 102334 409
invoice (draft): creation 46.67 3315 5600
invoice (draft): removal 53.44 774 6413
invoice accept: apply 42.63 17051 5115
invoice accept: cancel 48.09 804 5771
customer reserve: creation 3972.79 167 476735
customer reserve: removal 4759.63 57 571155
realization accept: apply 85.33 190 10239
realization accept: cancel 82.37 99 9884
payment from customer: creation 60.69 103 7283
payment from customer: removal 6.08 82 729
payment to supplier: creation 49.07 114 5888
payment to supplier: removal 3.88 67 466
service: total inventory turnovers 4.80 1104 576
service: total monetary turnovers 6.58 25 790
service: aggregate perf. data 0.79 19082 95
service: refresh index statistics 0.03 277178 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5940
TEST_TIME 2 6426
TEST_TIME 3 5838
TEST_TIME 4 6216
TEST_TIME 5 6245
TEST_TIME 6 6642
TEST_TIME 7 6376
TEST_TIME 8 6638
TEST_TIME 9 6663
TEST_TIME 10 7036
TEST_TIME 11 7285
TEST_TIME 12 7528
TEST_TIME 13 7420
TEST_TIME 14 7613
TEST_TIME 15 7719
TEST_TIME 16 8051
TEST_TIME 17 8230
TEST_TIME 18 8352
TEST_TIME 19 8542
TEST_TIME 20 8483
TEST_TIME 21 8420
TEST_TIME 22 9526
TEST_TIME 23 9445
TEST_TIME 24 9533
TEST_TIME 25 10280
TEST_TIME 26 10540
TEST_TIME 27 11051
TEST_TIME 28 10771
TEST_TIME 29 10997
TEST_TIME 30 10987
TEST_TIME 31 10789
TEST_TIME 32 10995
TEST_TIME 33 10951
TEST_TIME 34 10859
TEST_TIME 35 10691
TEST_TIME 36 10557
TEST_TIME 37 10452
TEST_TIME 38 10491
TEST_TIME 39 10319
TEST_TIME 40 10252
TEST_TIME 41 10124
TEST_TIME 42 10268
TEST_TIME 43 10169
TEST_TIME 44 10059
TEST_TIME 45 10039
TEST_TIME 46 10029
TEST_TIME 47 9893
TEST_TIME 48 9952
TEST_TIME 49 9955
TEST_TIME 50 9972
TEST_TIME 51 9924
TEST_TIME 52 9976
TEST_TIME 53 10038
TEST_TIME 54 10033
TEST_TIME 55 10033
TEST_TIME 56 10012
TEST_TIME 57 10035
TEST_TIME 58 10125
TEST_TIME 59 10075
TEST_TIME 60 10119
TEST_TIME 61 10122
TEST_TIME 62 10122
TEST_TIME 63 9976
TEST_TIME 64 9842
TEST_TIME 65 9911
TEST_TIME 66 9838
TEST_TIME 67 9760
TEST_TIME 68 9743
TEST_TIME 69 9682
TEST_TIME 70 9754
TEST_TIME 71 9769
TEST_TIME 72 9708
TEST_TIME 73 9741
TEST_TIME 74 9700
TEST_TIME 75 9773
TEST_TIME 76 9737
TEST_TIME 77 9738
TEST_TIME 78 9807
TEST_TIME 79 9780
TEST_TIME 80 9909
TEST_TIME 81 9949
TEST_TIME 82 9934
TEST_TIME 83 9876
TEST_TIME 84 9795
TEST_TIME 85 9789
TEST_TIME 86 9728
TEST_TIME 87 9741
TEST_TIME 88 9684
TEST_TIME 89 9630
TEST_TIME 90 9615
TEST_TIME 91 9553
TEST_TIME 92 9552
TEST_TIME 93 9567
TEST_TIME 94 9620
TEST_TIME 95 9626
TEST_TIME 96 9601
TEST_TIME 97 9576
TEST_TIME 98 9753
TEST_TIME 99 9724
TEST_TIME 100 9690
TEST_TIME 101 9718
TEST_TIME 102 9703
TEST_TIME 103 9761
TEST_TIME 104 9758
TEST_TIME 105 9732
TEST_TIME 106 9777
TEST_TIME 107 9781
TEST_TIME 108 9734
TEST_TIME 109 9707
TEST_TIME 110 9675
TEST_TIME 111 9675
TEST_TIME 112 9626
TEST_TIME 113 9590
TEST_TIME 114 9607
TEST_TIME 115 9630
TEST_TIME 116 9588
TEST_TIME 117 9537
TEST_TIME 118 9543
TEST_TIME 119 9542
TEST_TIME 120 9476

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 22-01-2021 01:28:52 to 22-01-2021 01:28:55.

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 1576561 1576561 0 0.00 0 22789 6 0 0
doc_list_biud 1576561 1576561 0 0.00 0 51121 26 0 0
sp_add_invoice_to_stock 5270 5115 155 2.94 42 166360 17052 0 155
sp_cancel_adding_invoice 5771 5771 0 0.00 4 104721 805 0 0
sp_cancel_client_order 1854 1854 0 0.00 4 9224 305 0 0
sp_cancel_customer_reserve 571155 571155 0 0.00 1 51124 58 0 0
sp_cancel_pay_from_customer 729 729 0 0.00 3 3615 83 0 0
sp_cancel_pay_to_supplier 466 466 0 0.00 3 3151 68 0 0
sp_cancel_supplier_invoice 6428 6413 15 0.23 1 24126 775 0 15
sp_cancel_supplier_order 409 409 0 0.00 8 1023645 102334 0 0
sp_cancel_write_off 9884 9884 0 0.00 1 13450 100 0 0
sp_client_order 21372 21372 0 0.00 3 38849 338 0 0
sp_customer_reserve 476735 476735 0 0.00 0 48856 168 0 0
sp_fill_shopping_cart 32663 32663 0 0.00 1 19076 36 0 0
sp_fill_shopping_cart_clo_res 476712 476712 0 0.00 0 21344 14 0 0
sp_get_clo_for_invoice 5091 5091 0 0.00 0 24900 255 0 0
sp_kill_cost_storno 16850 16850 0 0.00 0 4136 52 0 0
sp_kill_qstorno_ret_qs2qd 1159016 1159016 0 0.00 0 50953 31 0 0
sp_kill_qty_storno 610816 610816 0 0.00 0 51120 68 0 0
sp_lock_selected_doc 21383 21383 0 0.00 0 9565 5 0 0
sp_make_cost_storno 28501 28501 0 0.00 0 22770 53 0 0
sp_multiply_rows_for_pdistr 28501 28501 0 0.00 0 8063 29 0 0
sp_multiply_rows_for_qdistr 21372 21372 0 0.00 0 9649 150 0 0
sp_pay_from_customer 7283 7283 0 0.00 4 22794 104 0 0
sp_pay_to_supplier 5888 5888 0 0.00 5 19637 114 0 0
sp_payment_common 13171 13171 0 0.00 1 13123 26 0 0
sp_qd_handle_on_cancel_clo 1854 1854 0 0.00 0 9187 277 0 0
sp_qd_handle_on_invoice_upd_sts 10862 10862 0 0.00 0 38751 339 0 0
sp_qd_handle_on_reserve_upd_sts 10239 10239 0 0.00 0 23562 69 0 0
sp_reserve_write_off 10239 10239 0 0.00 6 23576 190 0 0
sp_supplier_invoice 5600 5600 0 0.00 7 86527 3315 0 0
sp_supplier_order 5697 5697 0 0.00 5 29870 1247 0 0
srv_aggregate_perf_data 95 95 0 0.00 2641 133149 19082 0 0
srv_fill_mon_cache_memory 160 160 0 0.00 1017 137956 32632 0 0
srv_find_qd_qs_mism 1086520 1086520 0 0.00 0 16488 6 0 0
srv_make_invnt_saldo 576 576 0 0.00 17 67071 1105 0 0
srv_make_money_saldo 790 790 0 0.00 0 3744 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 158432 377861 277178 0 0
t$perf-abend:sp_add_invoice_to_stock 155 155 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5115 5115 0 0.00 0 35807 183 0 0
t$perf-norm:sp_cancel_adding_invoice 402 402 0 0.00 0 5317 88 0 0
t$perf-norm:sp_cancel_client_order 1854 1854 0 0.00 0 8840 23 0 0
t$perf-norm:sp_cancel_customer_reserve 708 708 0 0.00 0 3912 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 729 729 0 0.00 0 898 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 466 466 0 0.00 0 5509 25 0 0
t$perf-norm:sp_cancel_supplier_invoice 440 440 0 0.00 0 1626 18 0 0
t$perf-norm:sp_cancel_supplier_order 409 409 0 0.00 0 25335 1733 0 0
t$perf-norm:sp_cancel_write_off 1045 1045 0 0.00 0 6996 22 0 0
t$perf-norm:sp_client_order 21372 21372 0 0.00 0 35654 20 0 0
t$perf-norm:sp_customer_reserve 1054 1054 0 0.00 0 3504 13 0 0
t$perf-norm:sp_pay_from_customer 7283 7283 0 0.00 0 11152 16 0 0
t$perf-norm:sp_pay_to_supplier 5888 5888 0 0.00 0 7024 13 0 0
t$perf-norm:sp_reserve_write_off 10239 10239 0 0.00 0 7018 11 0 0
t$perf-norm:sp_supplier_invoice 5600 5600 0 0.00 0 5864 16 0 0
t$perf-norm:sp_supplier_order 5697 5697 0 0.00 0 8611 16 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 310 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 192 5 0 0
t$perf-norm:srv_make_invnt_saldo 576 576 0 0.00 0 1130 20 0 0
t$perf-norm:srv_make_money_saldo 790 790 0 0.00 0 1646 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 2 2 0 0
v_add_invoice_to_stock 10492 10182 310 2.95 0 6960 20 0 310
v_all_customers 38310 38310 0 0.00 0 90 1 0 0
v_all_suppliers 31218 31218 0 0.00 0 96 1 0 0
v_all_wares 42744 42744 0 0.00 0 180 1 0 0
v_cancel_adding_invoice 804 804 0 0.00 0 2061 9 0 0
v_cancel_client_order 3708 3708 0 0.00 0 1613 3 0 0
v_cancel_customer_prepayment 1458 1458 0 0.00 0 2440 9 0 0
v_cancel_customer_reserve 1416 1416 0 0.00 0 2510 7 0 0
v_cancel_payment_to_supplier 932 932 0 0.00 0 2565 7 0 0
v_cancel_supplier_invoice 910 880 30 3.29 0 2054 17 0 30
v_cancel_supplier_order 818 818 0 0.00 0 495 4 0 0
v_cancel_write_off 2090 2090 0 0.00 0 1229 11 0 0
v_max_id_clo_ord 5697 5697 0 0.00 0 2191 1 0 0
v_max_id_clo_res 1054 1054 0 0.00 0 3835 17 0 0
v_max_id_ord_sup 5594 5594 0 0.00 0 6341 6 0 0
v_max_non_paid_invoice 1570 1570 0 0.00 0 1801 3 0 0
v_max_non_paid_realizn 4135 4135 0 0.00 0 2435 3 0 0
v_min_id_clo_ord 5697 5697 0 0.00 0 3087 5 0 0
v_min_id_clo_res 1054 1054 0 0.00 0 2431 9 0 0
v_min_id_ord_sup 5594 5594 0 0.00 0 5468 7 0 0
v_min_non_paid_invoice 5888 5888 0 0.00 0 5439 14 0 0
v_min_non_paid_realizn 7283 7283 0 0.00 0 6815 14 0 0
v_our_firm 10730 10730 0 0.00 0 90 1 0 0
v_reserve_write_off 20478 20478 0 0.00 0 3421 6 0 0
x_lock_depdocs_on_canc_invoice 11744 11744 0 0.00 0 19039 110 0 0
x_lock_depdocs_on_canc_sup_ord 409 409 0 0.00 0 13627 413 0 0
x_make_qstorno_1000_1200 5697 5697 0 0.00 1 29835 1173 0 0
x_make_qstorno_1200_2000 5600 5600 0 0.00 3 82490 3179 0 0
x_make_qstorno_2100_3300 476735 476735 0 0.00 0 48854 152 0 0

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

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:15 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:21 7741 8192000000 10160769984 10461503488 998207920 10.861 81 52 102 0 1018003728 2728448 17067360
22:57:39 27323 8192000000 10328639968 10643378176 1367278576 14.303 100 84 168 1 1399171168 4231424 27661168
22:58:15 23169 8192000000 10368537632 10690617344 1422850416 14.798 100 85 170 0 1456190400 5994944 27345040
22:58:47 20632 8192000000 10403141952 10732007424 1454803856 15.080 100 87 172 2 1489635184 7100848 27730480
22:59:21 17270 8192000000 10440736784 10768728064 1493108864 15.416 100 94 188 0 1531278272 8064832 30104576
22:59:47 30881 8192000000 10459952608 10793852928 1507314048 15.540 100 90 180 0 1545398288 9181936 28902304
23:00:31 27183 8192000000 10478861440 10817982464 1534766928 15.778 100 94 188 1 1574358800 10193280 29398592
23:01:05 18949 8192000000 10489087904 10834030592 1550669312 15.916 100 87 174 1 1588311088 10528384 27113392
23:01:33 14785 8192000000 10516293264 10858176512 1564400720 16.034 100 81 161 2 1600201280 10897696 24902864
23:01:58 11754 8192000000 10528063472 10878685184 1589754528 16.252 100 83 166 1 1625719552 11312448 24652576
23:02:20 16018 8192000000 10557706608 10913755136 1608363776 16.411 100 76 152 2 1642394336 11384352 22646208
23:02:45 13221 8192000000 10576288480 10933223424 1630134944 16.596 100 81 162 0 1666597552 12402352 24060256
23:03:08 10476 8192000000 10585267360 10944126976 1643156976 16.706 100 85 169 0 1681406448 13332496 24916976
23:03:26 8103 8192000000 10588245728 10953785344 1651409072 16.776 100 77 154 0 1687835616 13201488 23225056
23:03:43 8255 8192000000 10610677248 10978844672 1666339296 16.902 100 65 130 1 1697361872 12130400 18892176
23:04:02 8422 8192000000 10631144960 11005849600 1694343216 17.138 100 77 155 2 1729149552 12267648 22538688
23:04:18 7276 8192000000 10644525824 11016499200 1707310256 17.246 100 76 151 2 1742051152 12862768 21878128
23:04:32 6825 8192000000 10658986320 11030958080 1714512336 17.306 100 79 158 0 1750194400 12942016 22740048
23:04:46 8159 8192000000 10671382160 11046764544 1724100704 17.386 100 75 150 0 1757932240 12185344 21646192
23:05:02 6640 8192000000 10680417600 11057336320 1738392048 17.505 100 73 146 1 1772502512 13347952 20762512
23:05:16 6621 8192000000 10690677504 11068788736 1754396384 17.638 100 85 169 2 1792471984 13947712 24127888
23:05:29 5958 8192000000 10700361696 11084931072 1767822816 17.749 100 79 158 3 1801672736 11931808 21918112
23:05:43 10812 8192000000 10697519456 11085336576 1770571200 17.772 100 77 155 1 1804619040 11995632 22052208
23:06:03 5695 8192000000 10709903936 11098329088 1782082896 17.867 100 69 138 0 1812262736 11188512 18991328
23:06:15 3765 8192000000 10740986480 11129081856 1801832976 18.029 100 83 164 1 1837915024 12654176 23427872
23:06:25 2718 8192000000 10747210240 11135803392 1814874544 18.136 100 81 162 0 1851080928 12598064 23608320
23:06:34 2571 8192000000 10749770592 11140804608 1813818352 18.127 100 70 139 3 1844947904 11476208 19653344
23:06:43 3376 8192000000 10759508352 11149258752 1825638640 18.224 100 74 146 1 1858157344 11654272 20864432
23:06:54 3138 8192000000 10780837920 11164610560 1831606800 18.272 100 94 187 3 1872333168 14910976 25815392
23:07:04 3276 8192000000 10782898288 11166318592 1835773328 18.306 100 88 176 2 1875616096 14839200 25003568
23:07:13 2121 8192000000 10787985968 11172061184 1842218640 18.359 100 93 183 1 1884116416 15763760 26134016
23:07:22 2348 8192000000 10785808192 11175489536 1844177280 18.375 100 87 175 0 1882486208 13899648 24409280
23:07:31 2059 8192000000 10794203136 11178700800 1850042768 18.422 100 87 178 0 1887002864 13183472 23776624
23:07:40 2204 8192000000 10789033552 11175833600 1849433680 18.418 100 89 172 1 1886937920 12370096 25134144
23:07:49 2073 8192000000 10790839376 11184222208 1852146544 18.440 100 87 172 1 1889245056 12531520 24566992
23:07:58 2033 8192000000 10800432080 11190403072 1858777856 18.493 100 93 188 2 1898280320 12706288 26796176
23:08:06 2040 8192000000 10800355280 11192041472 1861893088 18.519 100 87 173 0 1899336544 12639216 24804240
23:08:14 1782 8192000000 10812633456 11198726144 1870743152 18.590 100 94 190 2 1909218368 11463728 27011488
23:08:23 1431 8192000000 10816765568 11205263360 1872278576 18.603 100 95 191 1 1913006208 13542000 27185632
23:08:30 26581 8192000000 10811901200 11213447168 1866463296 18.556 100 60 119 1 1893766976 10970080 16333600
23:09:05 9696 8192000000 10805992208 11206356992 1872428768 18.604 100 84 168 0 1907187584 10873152 23885664
23:09:21 1514 8192000000 10818282816 11211091968 1873846464 18.615 100 84 166 0 1907204336 10028672 23329200
23:09:29 5848 8192000000 10804672336 11205545984 1877064928 18.641 100 80 160 1 1910411824 10646176 22700720
23:09:42 2994 8192000000 10796124224 11209179136 1869059504 18.577 100 46 92 0 1892449648 11038272 12351872
23:09:51 5010 8192000000 10794212384 11207458816 1872407104 18.604 100 55 110 4 1897849872 10355008 15087760
23:10:06 3362 8192000000 10805239552 11215331328 1877914112 18.648 100 57 114 0 1902709520 9487552 15307856
23:10:16 6543 8192000000 10778046592 11206815744 1872923856 18.608 100 40 80 0 1892510576 7878144 11708576
23:10:30 4763 8192000000 10799384400 11210797056 1875338656 18.627 100 40 79 4 1892611296 6713296 10559344
23:10:41 7246 8192000000 10775464992 11210129408 1876812416 18.639 100 25 50 1 1890552176 7470144 6269616
23:10:56 9321 8192000000 10789477120 11216666624 1877686864 18.646 100 22 44 0 1890484816 6836688 5961264
23:11:15 6937 8192000000 10791937776 11226558464 1883727280 18.695 100 26 52 0 1901762544 10379504 7655760
23:11:28 6072 8192000000 10791311136 11225161728 1886409728 18.717 100 24 48 2 1900304080 5728000 8166352
23:11:43 8829 8192000000 10792508352 11225796608 1887778192 18.728 100 26 52 2 1901996032 7159232 7058608
23:12:00 4804 8192000000 10805949072 11230273536 1889763328 18.744 100 35 69 2 1906617488 6375872 10478288
23:12:12 11965 8192000000 10794835536 11231068160 1888612944 18.735 100 22 44 0 1901337088 6576192 6147952
23:12:32 9236 8192000000 10802047504 11234099200 1889117040 18.739 100 16 33 1 1899565824 5970768 4478016
23:12:50 9603 8192000000 10791692192 11228803072 1890442352 18.749 100 17 34 0 1900943216 5630192 4870672
23:13:06 66934 8192000000 10855129520 11260633088 1902160304 18.844 100 53 106 2 1923752992 6114496 15478192
23:14:19 4839 8192000000 10822993264 11253313536 1903594528 18.855 100 52 104 2 1932732224 14823632 14314064
23:14:31 6412 8192000000 10822613792 11251556352 1904429968 18.862 100 25 50 1 1917799168 6096704 7272496
23:14:44 4082 8192000000 10833651056 11259133952 1910020480 18.907 100 44 89 1 1930303552 7775456 12507616
23:14:54 6114 8192000000 10834370336 11262476288 1915604400 18.952 100 50 100 2 1937400624 7304928 14491296
23:15:09 6538 8192000000 10821653392 11261423616 1913368960 18.934 100 26 52 2 1927228128 6439760 7419408
23:15:23 4421 8192000000 10838549664 11270389760 1916516432 18.959 100 35 70 0 1933718048 7201184 10000432
23:15:35 4951 8192000000 10839242368 11270184960 1916733584 18.961 100 28 57 0 1931961648 6830784 8397280
23:15:46 10139 8192000000 10825344992 11253764096 1898211408 18.812 99 22 44 0 1910240384 5495136 6533840
23:16:03 7896 8192000000 10817969600 11256213504 1890632400 18.751 99 16 32 1 1901316064 6104000 4579664
23:16:21 53444 8192000000 10820393264 11249463296 1872503952 18.605 98 32 64 1 1888092992 4808880 10780160
23:17:22 8649 8192000000 10820239728 11253891072 1903015824 18.851 100 31 63 3 1918978224 7511936 8450464
23:17:37 9935 8192000000 10818514032 11249602560 1891912016 18.761 99 26 52 0 1905940032 7092800 6935216
23:17:54 4084 8192000000 10805883104 11225341952 1850495616 18.426 98 44 87 2 1870260000 7031888 12732496
23:18:05 5772 8192000000 10799200880 11219202048 1860238880 18.505 99 22 44 2 1873396544 6416512 6741152
23:18:19 6116 8192000000 10781450432 11198554112 1860275600 18.506 99 35 70 0 1877807728 7251072 10281056
23:18:31 5782 8192000000 10768406016 11197665280 1818838016 18.168 97 25 50 0 1833124672 7215888 7070768
23:18:45 7429 8192000000 10758946528 11185885184 1809020896 18.088 97 24 48 0 1822797504 6812272 6964336
23:18:58 11650 8192000000 10756122784 11182153728 1828692736 18.249 99 17 34 2 1839946480 6072768 5180976
23:19:16 6273 8192000000 10739394864 11150368768 1756310224 17.654 95 25 50 0 1769106976 4794704 8002048
23:19:29 9505 8192000000 10731007584 11155238912 1753109904 17.627 95 15 30 1 1762119440 4796240 4213296
23:19:48 15538 8192000000 10691174000 11104452608 1641055888 16.689 90 17 32 2 1651578352 5385744 5136720
23:20:10 12478 8192000000 10688815264 11104821248 1705332512 17.230 95 23 45 2 1717262832 5337568 6592752
23:20:29 72894 8192000000 10676506144 11085619200 1592215616 16.273 88 33 64 1 1606610496 4995872 9399008
23:21:49 12868 8192000000 10687784784 11099246592 1668292384 16.919 93 33 66 0 1688219376 10743088 9183904
23:22:08 6259 8192000000 10707340256 11119296512 1773122896 17.793 99 39 76 2 1790919024 7101616 10694512
23:22:23 8979 8192000000 10715411088 11134132224 1801206816 18.024 100 32 63 2 1816155888 5989584 8959488
23:22:38 6603 8192000000 10718334944 11139330048 1788222112 17.917 99 23 46 2 1801004672 6277216 6505344
23:22:51 9906 8192000000 10732180656 11152031744 1801009392 18.022 99 28 56 1 1815825680 6119200 8697088
23:23:10 9724 8192000000 10745055616 11160788992 1807353376 18.074 99 26 51 3 1821469488 5481120 8634992
23:23:26 9529 8192000000 10749919696 11171233792 1815323040 18.139 99 24 49 0 1827602624 5411152 6868432
23:23:43 7293 8192000000 10766891936 11180613632 1841003968 18.349 100 26 52 4 1853987664 6297968 6685728
23:23:57 8201 8192000000 10781399120 11200675840 1852259552 18.440 100 34 68 0 1868615312 6285056 10070704
23:24:13 16024 8192000000 10768242928 11197390848 1853240928 18.448 100 26 52 1 1866307168 5409808 7656432
23:24:37 8577 8192000000 10767922848 11201400832 1859919824 18.503 100 24 48 2 1872606992 5948000 6739168
23:24:53 8171 8192000000 10773044272 11205369856 1860997136 18.511 100 12 24 1 1869835648 5019024 3819488
23:25:09 42055 8192000000 10769570800 11207274496 1864165904 18.537 100 16 32 0 1874406480 5381440 4859136
23:26:15 16017 8192000000 10774838032 11208720384 1867066368 18.561 100 26 52 1 1880254640 6379152 6809120
23:26:38 10111 8192000000 10780199040 11213922304 1867966480 18.568 100 23 46 1 1880115856 6069936 6079440
23:26:57 11355 8192000000 10820668560 11229691904 1879566816 18.662 100 27 54 0 1891799136 4754800 7477520
23:27:16 20677 8192000000 10831488112 11251482624 1899743808 18.824 100 48 96 3 1919712064 6523488 13444768
23:28:01 16867 8192000000 10841117392 11263225856 1916035152 18.955 100 52 103 0 1939354336 9060512 14258672
23:28:28 17900 8192000000 10865511584 11286151168 1926095344 19.036 100 56 109 1 1952276192 10600608 15580240
23:28:58 25917 8192000000 10877722464 11295916032 1934414960 19.102 100 61 122 2 1963700848 12524896 16760992
23:29:32 19565 8192000000 10875920032 11298746368 1940268928 19.149 100 47 94 0 1965272560 10971376 14032256
23:29:58 17341 8192000000 10876422912 11303313408 1943358032 19.174 100 41 82 0 1965107184 10063600 11685552
23:30:23 15199 8192000000 10894919328 11318255616 1949802208 19.225 100 49 98 1 1975002016 11031120 14168688
23:30:46 4340 8192000000 10899149856 11325362176 1953206032 19.252 100 54 108 0 1987239456 18983184 15050240
23:31:05 11845 8192000000 10894907888 11320188928 1958278640 19.292 100 53 106 1 1989244752 16003216 14962896
23:31:29 10937 8192000000 10905846064 11328765952 1960658288 19.311 100 53 106 1 1996121120 19627728 15835104
23:32:02 19493 8192000000 10903548688 11333476352 1963650784 19.335 100 45 88 0 1992811776 15485616 13675376
23:32:28 59146 8192000000 10902972688 11345637376 1963449072 19.333 100 37 74 0 1996065648 21185424 11431152
23:33:39 41380 8192000000 10891860688 11348082688 1968627888 19.375 100 26 52 3 1993631664 16825856 8177920
23:34:46 11018 8192000000 10918590736 11357126656 1976042000 19.433 100 37 73 1 2004560688 16937088 11581600
23:35:04 13149 8192000000 10929270736 11365171200 1984284496 19.499 100 51 100 1 2018429184 18989632 15155056
23:35:29 4571 8192000000 10930323280 11365920768 1987079536 19.521 100 50 101 0 2019655184 17645120 14930528
23:35:40 5128 8192000000 10934780576 11371114496 1989459872 19.540 100 52 104 1 2023536176 19119568 14956736
23:35:54 5169 8192000000 10953059600 11382095872 1994603040 19.580 100 59 119 3 2032998000 21266432 17128528
23:36:12 4996 8192000000 10951945040 11382480896 2000447904 19.626 100 70 138 1 2042165760 21094512 20623344
23:36:28 9531 8192000000 10966653040 11392737280 2000464240 19.626 100 64 126 0 2042452080 23554832 18433008
23:36:49 8967 8192000000 10939392352 11372150784 1986620576 19.517 99 58 115 1 2027667776 23963280 17083920
23:37:11 8822 8192000000 10950441712 11384381440 1997212800 19.601 100 62 122 2 2040568032 24778752 18576480
23:37:29 4101 8192000000 10959702816 11394314240 2003218960 19.648 100 63 125 1 2049676496 26405456 20052080
23:37:41 2444 8192000000 10961308864 11385573376 1996091552 19.592 100 77 153 1 2047690832 28091136 23508144
23:37:51 8564 8192000000 10951455200 11383664640 1994311360 19.578 100 60 117 1 2038416592 25378096 18727136
23:38:08 18760 8192000000 10951138560 11395579904 1999147264 19.616 100 43 86 1 2041539424 28850528 13541632
23:38:37 7010 8192000000 10952782048 11387998208 1998082176 19.608 100 57 114 2 2038021120 21735248 18203696
23:38:51 15549 8192000000 10930855824 11368620032 1975459056 19.429 99 51 102 1 2014915904 23696096 15760752
23:39:19 7027 8192000000 10946248176 11385016320 1996581568 19.596 100 54 103 1 2034215520 22140800 15493152
23:39:35 5077 8192000000 10958174432 11389829120 2001964112 19.638 100 61 120 2 2044386048 23513664 18908272
23:39:48 2255 8192000000 10975310768 11404505088 2013827824 19.732 100 76 150 2 2062361104 24811552 23721728
23:39:59 9222 8192000000 10956465712 11396747264 2004382624 19.657 100 57 114 3 2046920144 25304768 17232752
23:40:19 3162 8192000000 10968843088 11402805248 2009105792 19.694 100 56 111 0 2053663312 27785072 16772448
23:40:30 10747 8192000000 10977627728 11411443712 2015124048 19.742 100 65 130 0 2061140080 26655040 19360992
23:40:49 12214 8192000000 10977402624 11410214912 2013885088 19.732 100 61 120 0 2061888112 29799904 18203120
23:41:12 1574 8192000000 10994249168 11409108992 2009910432 19.701 99 89 177 1 2069650288 32275088 27464768
23:41:23 8099 8192000000 10990615328 11423518720 2023379184 19.807 100 62 125 3 2075387808 32116608 19892016
23:41:40 3408 8192000000 10990131184 11413839872 2012147328 19.718 99 82 163 0 2070397200 32206848 26043024
23:41:51 3677 8192000000 11008099600 11430453248 2028782848 19.849 100 81 162 2 2089282416 35098864 25400704
23:42:05 2113 8192000000 11009121760 11428003840 2023952576 19.811 100 84 164 2 2085430560 35577344 25900640
23:42:14 3470 8192000000 10993467504 11424350208 2023320768 19.806 100 67 134 0 2079127072 35284144 20522160
23:42:28 6258 8192000000 10998216272 11424968704 2024946320 19.819 100 77 155 3 2085718112 36260656 24511136
23:42:41 4618 8192000000 11007185520 11426693120 2022350208 19.799 100 81 160 0 2083532000 36039472 25142320
23:42:55 5036 8192000000 11002681744 11432648704 2014118480 19.734 99 74 147 0 2073408064 36071408 23218176
23:43:08 1583 8192000000 10998898672 11428126720 2026886352 19.834 100 78 154 2 2085457840 34311856 24259632
23:43:16 2537 8192000000 10998398560 11427500032 2028246528 19.845 100 73 144 0 2080450000 29395232 22808240
23:43:26 2804 8192000000 10998068272 11421184000 1997498064 19.603 98 83 163 1 2054984512 31027088 26459360
23:43:36 2432 8192000000 10986434128 11406798848 1996400080 19.594 99 82 161 2 2052742400 31872688 24469632
23:43:47 3476 8192000000 10981895728 11401981952 2008858000 19.693 100 89 178 0 2069460560 32754512 27848048
23:44:02 8016 8192000000 10965515984 11388510208 1961768560 19.320 98 76 152 4 2021700688 35229264 24702864
23:44:21 1277 8192000000 10980138336 11396157440 1997731456 19.605 100 89 176 0 2060320000 36322256 26266288
23:44:30 6499 8192000000 10981360256 11403776000 2003241856 19.648 100 84 168 0 2068072928 38130752 26700320
23:44:43 2694 8192000000 10980037360 11399827456 1995265392 19.585 100 79 157 1 2059785552 39642816 24877344
23:44:52 2479 8192000000 10947276560 11361742848 1956098096 19.275 98 81 160 2 2019861904 38902544 24861264
23:45:02 1017 8192000000 10968734256 11387084800 1987707088 19.526 100 77 156 0 2048137456 36269008 24161360
23:45:11 4405 8192000000 10976194112 11403649024 2001472672 19.634 100 69 138 1 2059701984 36812448 21416864
23:45:24 3460 8192000000 10974660960 11403767808 2004224736 19.656 100 65 130 0 2061358208 36537472 20596000
23:45:34 3766 8192000000 10968787200 11400785920 2000996848 19.631 100 66 132 0 2056940384 34865584 21077952
23:45:59 3810 8192000000 10975491776 11393806336 1996954432 19.599 100 78 152 1 2055483808 35617472 22911904
23:46:09 5262 8192000000 10948380256 11367096320 1960555584 19.310 98 60 120 0 2014808736 36076576 18176576
23:46:25 10513 8192000000 10959674192 11394203648 1986001744 19.512 100 55 110 0 2043710896 40740704 16968448
23:46:46 12238 8192000000 10958059952 11402235904 1990358192 19.547 100 37 73 2 2037513040 35075200 12079648
23:47:05 8541 8192000000 10951773568 11393142784 1971281856 19.396 99 40 79 0 2018918992 34935152 12701984
23:47:20 10025 8192000000 10943147216 11385081856 1980636992 19.470 100 34 68 0 2029885968 37066720 12182256
23:47:54 11381 8192000000 10946942064 11381112832 1959191344 19.300 99 60 120 0 2022749648 42530672 21027632
23:48:16 5693 8192000000 10974231376 11398918144 1984248144 19.498 100 71 140 3 2053496096 45218816 24029136
23:48:30 7028 8192000000 10969872144 11387551744 1959856320 19.305 99 78 155 2 2031055872 45959200 25240352
23:48:45 1890 8192000000 10967709952 11388428288 1978082048 19.450 100 83 168 0 2052658512 48242144 26334320
23:48:54 1324 8192000000 10957831472 11376775168 1950861376 19.233 99 83 166 4 2029703520 52314544 26527600
23:49:03 3423 8192000000 10961757520 11391713280 1968347328 19.372 100 65 130 0 2045629024 56108176 21173520
23:49:17 10154 8192000000 10934709520 11387056128 1962339680 19.325 100 33 66 0 2018696704 44973248 11383776
23:49:34 18065 8192000000 10908027152 11366428672 1937976720 19.131 99 28 56 0 1987981104 40372496 9631888
23:50:00 14910 8192000000 10905662192 11346808832 1913562144 18.935 98 36 70 1 1960998000 35853712 11582144
23:50:32 14780 8192000000 10891294176 11338670080 1913088208 18.931 99 35 70 0 1965691488 40115728 12487552
23:51:00 14731 8192000000 10880184160 11325894656 1871029840 18.593 97 28 56 0 1924927472 43064432 10833200
23:51:21 8831 8192000000 10891697424 11339419648 1919015312 18.979 100 28 56 0 1977339120 47295600 11028208
23:51:36 8101 8192000000 10894534960 11340722176 1912994320 18.931 100 25 50 1 1975162688 52126144 10042224
23:51:51 19418 8192000000 10879995792 11332956160 1918627872 18.976 100 22 44 2 1976905376 50022480 8255024
23:52:41 38585 8192000000 10855965248 11317678080 1899688656 18.824 100 21 42 2 1943584784 37088960 6807168
23:53:26 24973 8192000000 10858827536 11323650048 1903994448 18.858 100 21 40 2 1948816640 38376960 6445232
23:53:58 62870 8192000000 10821055456 11280859136 1832088016 18.276 96 10 20 1 1845455968 10598224 2769728
23:55:08 99701 8192000000 10850146720 11313856512 1869622288 18.581 98 19 38 0 1892685536 17950224 5113024
23:56:54 96959 8192000000 10871816464 11326164992 1873526064 18.613 97 9 17 0 1893813888 18760000 1527824
23:58:37 86399 8192000000 10879610464 11339694080 1906916976 18.882 98 17 34 0 1931495104 19947696 4630432
00:00:12 81696 8192000000 10871867664 11333767168 1929541920 19.063 99 14 28 2 1945650432 11727424 4381088
00:01:41 46071 8192000000 10872526560 11331985408 1935164592 19.108 99 25 49 1 1951155344 8262112 7728640
00:02:34 137956 8192000000 10889900880 11342311424 1902180560 18.844 97 28 56 0 1921874736 11376880 8317296
00:05:03 33084 8192000000 10883890096 11336056832 1914914576 18.946 98 42 81 0 1939512096 12678496 11919024
00:05:44 23869 8192000000 10848855360 11311423488 1920698496 18.992 99 20 39 3 1938955088 12208832 6047760
00:06:15 56472 8192000000 10876211088 11334221824 1943885152 19.178 100 23 46 2 1959177392 8203568 7088672
00:07:20 1548 8192000000 10899263232 11350589440 1960242224 19.308 100 34 68 0 1979641536 10067536 9331776
00:07:29 14224 8192000000 10916676688 11357671424 1952973296 19.250 99 60 119 3 1984480352 13972880 17534176
00:07:53 31608 8192000000 10897990720 11357122560 1956427792 19.278 100 31 62 0 1978448768 13118832 8902144
00:08:36 54843 8192000000 10909096128 11371958272 1964957200 19.345 100 49 97 1 1996477472 17467104 14053168
00:09:56 58017 8192000000 10900223552 11375534080 1961583312 19.319 100 8 16 0 1985458896 21730320 2145264
00:11:01 31138 8192000000 10905459952 11371843584 1972676288 19.407 100 12 25 1 1998604880 22381552 3547040
00:11:42 35569 8192000000 10894442816 11368919040 1934123776 19.100 98 7 15 0 1954435792 18332032 1979984
00:12:24 49684 8192000000 10892566592 11366879232 1924125584 19.020 98 7 14 1 1944713728 18454192 2133952
00:13:20 15671 8192000000 10895766480 11374301184 1965367488 19.349 100 9 18 0 1985299568 17119712 2812368
00:13:51 25007 8192000000 10899247152 11383205888 1966889536 19.361 100 10 20 0 1989497952 18899376 3709040
00:14:42 42022 8192000000 10887588768 11366281216 1947379712 19.206 99 21 43 1 1967801456 13769888 6651856
00:15:55 66233 8192000000 10898010736 11381706752 1964965696 19.345 100 10 20 2 1980960176 13135136 2859344
00:17:21 47039 8192000000 10898159584 11372601344 1952824880 19.249 99 12 24 0 1972602576 16409120 3368576
00:18:15 33517 8192000000 10907778544 11368734720 1954382880 19.261 99 18 36 2 1967233136 7887344 4962912
00:18:55 49215 8192000000 10897114640 11374211072 1952925776 19.250 99 17 34 0 1971799120 14056144 4817200
00:19:55 72057 8192000000 10901123760 11371720704 1952979312 19.250 99 22 42 2 1974588672 15985536 5623824
00:21:14 30011 8192000000 10922130576 11377545216 1977410400 19.444 100 42 84 0 1999980176 9936512 12633264
00:21:55 22329 8192000000 10910803472 11373699072 1975690464 19.431 100 29 58 3 1993034576 9744112 7600000
00:22:29 57698 8192000000 10915080992 11387699200 1983811456 19.495 100 28 56 1 2001503392 9942944 7748992
00:23:37 28563 8192000000 10950803280 11391012864 1996855920 19.598 100 44 88 1 2017770608 7936448 12978240
00:24:18 35086 8192000000 10936217024 11398090752 1981715440 19.478 99 34 68 2 2004115568 13086688 9313440
00:25:03 37263 8192000000 10931141344 11403329536 1992111936 19.560 100 13 26 2 2009333952 13760384 3461632
00:25:48 52251 8192000000 10945998208 11391053824 1977548656 19.445 99 31 62 2 2000978608 14469872 8960080
00:26:46 48887 8192000000 10924995568 11390771200 1938397264 19.134 97 24 48 0 1956249600 10941248 6911088
00:27:47 114272 8192000000 10856644912 11319541760 1669612240 16.930 84 12 24 1 1684342576 11524240 3206096
00:29:48 92059 8192000000 10877807616 11333111808 1902848848 18.849 98 23 45 2 1922801616 13527856 6424912
00:32:02 80054 8192000000 10877811856 11344588800 1950203104 19.228 100 20 40 1 1966423728 10723952 5496672
00:33:30 82429 8192000000 10840081552 11311980544 1820971920 18.186 93 10 20 1 1835300992 11866720 2462352
00:35:01 46063 8192000000 10843501424 11320848384 1904997072 18.866 99 3 6 0 1919348416 13582304 769040
00:35:53 43999 8192000000 10849069904 11313856512 1904021744 18.859 99 3 6 0 1918169712 13332016 815952
00:36:53 42766 8192000000 10835780128 11300290560 1860702992 18.509 96 17 35 1 1879616768 13605168 5308608
00:37:46 61280 8192000000 10829076112 11284549632 1788020320 17.915 93 21 42 2 1802802992 8716688 6065984
00:38:54 37153 8192000000 10869548400 11314216960 1914636304 18.944 100 18 37 2 1926360704 6600976 5123424
00:39:40 77275 8192000000 10864372976 11336278016 1885697040 18.711 97 29 58 1 1902942608 9316880 7928688
00:41:04 31449 8192000000 10870297648 11323928576 1909194256 18.900 98 21 42 0 1923038528 8289328 5554944
00:41:47 75426 8192000000 10863046816 11327672320 1866897520 18.559 96 31 62 0 1886622176 11367728 8356928
00:43:15 32854 8192000000 10870102576 11321634816 1883101648 18.690 97 39 78 0 1907061824 13484448 10475728
00:43:56 37987 8192000000 10870620464 11324489728 1897926176 18.810 98 38 76 1 1923913104 15266624 10720304
00:45:04 63889 8192000000 10863643456 11299119104 1835437856 18.304 95 12 25 2 1851642096 13010832 3193408
00:46:16 26226 8192000000 10868280080 11321466880 1910530544 18.911 99 37 74 0 1933263568 12384160 10348864
00:46:49 82733 8192000000 10871068688 11350708224 1919769152 18.985 99 7 14 1 1940291024 18796176 1725696
00:48:19 97357 8192000000 10881497808 11327295488 1868165616 18.569 96 20 39 2 1891601664 17995360 5440688
00:50:07 46648 8192000000 10868685264 11334823936 1925938576 19.034 99 36 72 0 1949366880 13565136 9863168
00:51:37 83404 8192000000 10880013360 11342761984 1899125680 18.819 98 17 34 0 1916874576 13041008 4707888
00:53:07 34361 8192000000 10863782880 11334742016 1939189760 19.140 100 15 30 1 1953742688 10665568 3887360
00:53:49 31540 8192000000 10872545216 11325075456 1923170896 19.012 99 36 70 4 1941553120 8272752 10109472
00:54:49 57593 8192000000 10863932416 11339128832 1920767888 18.993 99 13 26 0 1934149776 9603280 3778608
00:55:55 97087 8192000000 10879586912 11361705984 1909210224 18.900 98 9 18 1 1926620048 14714592 2695232
00:59:33 58556 8192000000 10874689424 11347214336 1914684160 18.944 98 14 28 2 1933457664 14791696 3981808
01:00:37 57547 8192000000 10893677264 11369099264 1961209248 19.316 100 9 18 0 1974856928 11385696 2261984
01:01:42 74059 8192000000 10930026544 11390332928 1977539744 19.445 100 17 34 0 1995327184 13032864 4754576
01:03:19 34919 8192000000 10919013200 11392315392 1977597568 19.446 99 28 56 0 1999549792 12820880 9131344
01:04:02 63911 8192000000 10937217488 11414335488 2000328960 19.625 100 22 44 0 2029061680 21949664 6783056
01:05:31 107753 8192000000 10926774208 11379249152 1929956768 19.067 97 19 38 0 1947247440 11990912 5299760
01:07:33 29867 8192000000 10904245376 11366719488 1943468224 19.174 98 33 66 1 1962113792 9678848 8966720
01:08:45 40607 8192000000 10896732288 11356946432 1920549824 18.991 97 28 56 0 1941622016 13108528 7963664
01:09:53 31270 8192000000 10913231840 11376820224 1928977136 19.059 98 26 52 3 1954054080 17345856 7731088
01:10:31 63323 8192000000 10894622944 11384057856 1965937632 19.353 100 18 36 0 1992840400 21510672 5392096
01:11:48 50488 8192000000 10911448480 11368411136 1946287616 19.197 99 22 44 2 1964216400 11967712 5961072
01:12:50 38919 8192000000 10878502208 11352981504 1869136960 18.577 95 25 50 0 1897457936 21701040 6619936
01:13:36 89910 8192000000 10884468848 11362664448 1869552672 18.581 96 5 10 0 1892735680 22243232 939776
01:15:12 117248 8192000000 10870443200 11344965632 1909325088 18.901 98 21 43 1 1926795840 11067552 6403200
01:17:17 37826 8192000000 10884704224 11345735680 1934369552 19.102 99 34 68 0 1952923376 8994672 9559152
01:18:01 24501 8192000000 10871476272 11345477632 1951782800 19.241 100 25 50 1 1969029072 10419104 6827168
01:18:47 53735 8192000000 10864427920 11342544896 1914979968 18.947 98 13 26 0 1926183888 7186672 4017248
01:20:06 61514 8192000000 10864162272 11333857280 1892742144 18.768 97 14 29 0 1908720528 11918384 4060000
01:22:39 50187 8192000000 10829982576 11304984576 1891490608 18.758 98 15 30 0 1909731664 13358976 4882080
01:23:42 55992 8192000000 10824161680 11289387008 1855957104 18.470 96 21 42 0 1870746032 8330736 6458192
01:24:49 64945 8192000000 10837789136 11320487936 1916203120 18.956 100 15 30 0 1932186496 11143472 4839904
01:26:01 76951 8192000000 9936337584 10315014144 1048626192 11.347 54 10 20 0 1057329392 6235296 2467904

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-01-2021 01:29:02 to 22-01-2021 01:29:34.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 155 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

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

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          240576
MON$OLDEST_ACTIVE               240972
MON$OLDEST_SNAPSHOT             240972
MON$NEXT_TRANSACTION            240972
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                       2027488
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.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 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 ---
:225: 
:226: mscs-test-161.budzdorov.ru    Fri Jan 22 01:27:25 2021
:227:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:228: 
--- end of diff output ---

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

22.01.21 01:29:38. 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-22 01:29:40 No severe PSQL-related problems occured
22.01.21 01:29:41. End of report.