Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 23.03.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 df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
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.26
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 17561480 kB
MemAvailable 31500792 kB
Buffers 0 kB
Cached 14089020 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-23 01:27:21
DTS_END                         2021-03-23 01:27:21.7200
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_MAKE_INVNT_SALDO(40:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/35072
TRN_ID                          235081
ATT_ID                          661
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: 9300.44 18811 1116053
customer order: creation 170.43 357 20451
customer order: refuse 14.56 347 1747
order to supplier: creation 44.58 1318 5349
order to supplier: removal 3.63 115952 436
invoice (draft): creation 46.25 3380 5550
invoice (draft): removal 52.72 977 6326
invoice accept: apply 41.47 18215 4976
invoice accept: cancel 47.38 879 5685
customer reserve: creation 3906.24 176 468749
customer reserve: removal 4684.84 70 562181
realization accept: apply 83.28 190 9993
realization accept: cancel 76.93 130 9232
payment from customer: creation 58.23 108 6988
payment from customer: removal 5.58 76 669
payment to supplier: creation 48.58 127 5830
payment to supplier: removal 3.54 93 425
service: total inventory turnovers 4.73 1017 568
service: total monetary turnovers 6.68 39 802
service: aggregate perf. data 0.77 21503 92
service: refresh index statistics 0.03 211266 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 23-03-2021 01:28:21 to 23-03-2021 01:28:23.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5653
TEST_TIME 2 5572
TEST_TIME 3 5042
TEST_TIME 4 4953
TEST_TIME 5 5059
TEST_TIME 6 5913
TEST_TIME 7 5982
TEST_TIME 8 6004
TEST_TIME 9 6267
TEST_TIME 10 6696
TEST_TIME 11 6978
TEST_TIME 12 6847
TEST_TIME 13 7061
TEST_TIME 14 7101
TEST_TIME 15 6972
TEST_TIME 16 7019
TEST_TIME 17 7206
TEST_TIME 18 8007
TEST_TIME 19 8063
TEST_TIME 20 8114
TEST_TIME 21 8613
TEST_TIME 22 8786
TEST_TIME 23 9181
TEST_TIME 24 9268
TEST_TIME 25 9214
TEST_TIME 26 9509
TEST_TIME 27 10360
TEST_TIME 28 11701
TEST_TIME 29 11493
TEST_TIME 30 11386
TEST_TIME 31 11199
TEST_TIME 32 10968
TEST_TIME 33 10783
TEST_TIME 34 10947
TEST_TIME 35 10848
TEST_TIME 36 10679
TEST_TIME 37 10589
TEST_TIME 38 10482
TEST_TIME 39 10472
TEST_TIME 40 10415
TEST_TIME 41 10272
TEST_TIME 42 10512
TEST_TIME 43 10602
TEST_TIME 44 10471
TEST_TIME 45 10340
TEST_TIME 46 10158
TEST_TIME 47 10151
TEST_TIME 48 10109
TEST_TIME 49 10106
TEST_TIME 50 10063
TEST_TIME 51 9982
TEST_TIME 52 9948
TEST_TIME 53 10067
TEST_TIME 54 10034
TEST_TIME 55 10027
TEST_TIME 56 10060
TEST_TIME 57 10076
TEST_TIME 58 10150
TEST_TIME 59 10151
TEST_TIME 60 10065
TEST_TIME 61 10282
TEST_TIME 62 10172
TEST_TIME 63 10078
TEST_TIME 64 10040
TEST_TIME 65 9942
TEST_TIME 66 9960
TEST_TIME 67 9878
TEST_TIME 68 9797
TEST_TIME 69 9714
TEST_TIME 70 9689
TEST_TIME 71 9592
TEST_TIME 72 9507
TEST_TIME 73 9484
TEST_TIME 74 9662
TEST_TIME 75 9723
TEST_TIME 76 9706
TEST_TIME 77 9669
TEST_TIME 78 9690
TEST_TIME 79 9674
TEST_TIME 80 9672
TEST_TIME 81 9639
TEST_TIME 82 9705
TEST_TIME 83 9661
TEST_TIME 84 9741
TEST_TIME 85 9733
TEST_TIME 86 9712
TEST_TIME 87 9789
TEST_TIME 88 9705
TEST_TIME 89 9656
TEST_TIME 90 9639
TEST_TIME 91 9617
TEST_TIME 92 9601
TEST_TIME 93 9546
TEST_TIME 94 9477
TEST_TIME 95 9428
TEST_TIME 96 9492
TEST_TIME 97 9513
TEST_TIME 98 9507
TEST_TIME 99 9505
TEST_TIME 100 9513
TEST_TIME 101 9568
TEST_TIME 102 9536
TEST_TIME 103 9525
TEST_TIME 104 9534
TEST_TIME 105 9549
TEST_TIME 106 9575
TEST_TIME 107 9544
TEST_TIME 108 9546
TEST_TIME 109 9480
TEST_TIME 110 9463
TEST_TIME 111 9421
TEST_TIME 112 9410
TEST_TIME 113 9388
TEST_TIME 114 9353
TEST_TIME 115 9309
TEST_TIME 116 9310
TEST_TIME 117 9352
TEST_TIME 118 9324
TEST_TIME 119 9352
TEST_TIME 120 9303

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 23-03-2021 01:28:25 to 23-03-2021 01:28:28.

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 1548425 1548425 0 0.00 0 26716 7 0 0
doc_list_biud 1548425 1548425 0 0.00 0 55888 32 0 0
sp_add_invoice_to_stock 5044 4976 68 1.34 37 201952 18215 0 68
sp_cancel_adding_invoice 5685 5685 0 0.00 5 88666 880 0 0
sp_cancel_client_order 1747 1747 0 0.00 4 10611 347 0 0
sp_cancel_customer_reserve 562181 562181 0 0.00 1 55891 71 0 0
sp_cancel_pay_from_customer 669 669 0 0.00 3 4669 77 0 0
sp_cancel_pay_to_supplier 425 425 0 0.00 3 6727 94 0 0
sp_cancel_supplier_invoice 6329 6326 3 0.04 1 29718 977 0 3
sp_cancel_supplier_order 436 436 0 0.00 5 1157312 115952 0 0
sp_cancel_write_off 9232 9232 0 0.00 1 20053 131 0 0
sp_client_order 20451 20451 0 0.00 4 15035 357 0 0
sp_customer_reserve 468749 468749 0 0.00 0 80159 177 0 0
sp_fill_shopping_cart 31321 31321 0 0.00 1 18545 36 0 0
sp_fill_shopping_cart_clo_res 468744 468744 0 0.00 0 12357 14 0 0
sp_get_clo_for_invoice 4971 4971 0 0.00 0 37208 285 0 0
sp_kill_cost_storno 16011 16011 0 0.00 0 15909 67 0 0
sp_kill_qstorno_ret_qs2qd 1140356 1140356 0 0.00 0 55884 38 0 0
sp_kill_qty_storno 600571 600571 0 0.00 0 55887 82 0 0
sp_lock_selected_doc 20696 20696 0 0.00 0 9534 5 0 0
sp_make_cost_storno 27782 27782 0 0.00 0 13180 49 0 0
sp_multiply_rows_for_pdistr 27782 27782 0 0.00 0 9374 32 0 0
sp_multiply_rows_for_qdistr 20451 20451 0 0.00 0 13064 165 0 0
sp_pay_from_customer 6988 6988 0 0.00 4 15834 108 0 0
sp_pay_to_supplier 5830 5830 0 0.00 5 12387 127 0 0
sp_payment_common 12818 12818 0 0.00 1 15804 38 0 0
sp_qd_handle_on_cancel_clo 1747 1747 0 0.00 0 10569 321 0 0
sp_qd_handle_on_invoice_upd_sts 10656 10656 0 0.00 0 16767 344 0 0
sp_qd_handle_on_reserve_upd_sts 9993 9993 0 0.00 0 17758 63 0 0
sp_reserve_write_off 9993 9993 0 0.00 6 17827 191 0 0
sp_supplier_invoice 5550 5550 0 0.00 6 83077 3381 0 0
sp_supplier_order 5349 5349 0 0.00 5 38078 1318 0 0
srv_aggregate_perf_data 92 92 0 0.00 2686 348494 21504 0 0
srv_fill_mon_cache_memory 166 166 0 0.00 1465 120083 31993 0 0
srv_find_qd_qs_mism 1067554 1067554 0 0.00 0 26714 6 0 0
srv_make_invnt_saldo 568 568 0 0.00 30 56924 1017 0 0
srv_make_money_saldo 802 802 0 0.00 0 15078 39 0 0
srv_recalc_idx_stat 4 4 0 0.00 111798 296624 211266 0 0
t$perf-abend:sp_add_invoice_to_stock 68 68 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 3 3 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4976 4976 0 0.00 0 19902 171 0 0
t$perf-norm:sp_cancel_adding_invoice 409 409 0 0.00 0 2975 96 0 0
t$perf-norm:sp_cancel_client_order 1747 1747 0 0.00 0 8698 23 0 0
t$perf-norm:sp_cancel_customer_reserve 652 652 0 0.00 0 10141 25 0 0
t$perf-norm:sp_cancel_pay_from_customer 669 669 0 0.00 0 2734 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 425 425 0 0.00 0 6969 23 0 0
t$perf-norm:sp_cancel_supplier_invoice 395 395 0 0.00 0 718 18 0 0
t$perf-norm:sp_cancel_supplier_order 436 436 0 0.00 0 27677 1780 0 0
t$perf-norm:sp_cancel_write_off 1002 1002 0 0.00 0 2398 9 0 0
t$perf-norm:sp_client_order 20451 20451 0 0.00 0 10453 18 0 0
t$perf-norm:sp_customer_reserve 1029 1029 0 0.00 0 2788 14 0 0
t$perf-norm:sp_pay_from_customer 6988 6988 0 0.00 0 9797 13 0 0
t$perf-norm:sp_pay_to_supplier 5830 5830 0 0.00 0 7764 13 0 0
t$perf-norm:sp_reserve_write_off 9993 9993 0 0.00 0 10426 15 0 0
t$perf-norm:sp_supplier_invoice 5550 5550 0 0.00 0 9830 18 0 0
t$perf-norm:sp_supplier_order 5349 5349 0 0.00 0 9358 17 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 2166 28 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 14388 103 0 0
t$perf-norm:srv_make_invnt_saldo 568 568 0 0.00 0 776 17 0 0
t$perf-norm:srv_make_money_saldo 802 802 0 0.00 0 1520 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 7 4 0 0
v_add_invoice_to_stock 10072 9936 136 1.35 0 12303 22 0 136
v_all_customers 37448 37448 0 0.00 0 111 1 0 0
v_all_suppliers 30574 30574 0 0.00 0 18 1 0 0
v_all_wares 40902 40902 0 0.00 0 117 1 0 0
v_cancel_adding_invoice 818 818 0 0.00 0 2175 11 0 0
v_cancel_client_order 3494 3494 0 0.00 0 6551 7 0 0
v_cancel_customer_prepayment 1338 1338 0 0.00 0 2081 7 0 0
v_cancel_customer_reserve 1304 1304 0 0.00 0 1894 6 0 0
v_cancel_payment_to_supplier 850 850 0 0.00 0 1846 6 0 0
v_cancel_supplier_invoice 796 790 6 0.75 0 1417 19 0 6
v_cancel_supplier_order 872 872 0 0.00 0 10541 31 0 0
v_cancel_write_off 2004 2004 0 0.00 0 8761 19 0 0
v_max_id_clo_ord 5349 5349 0 0.00 0 1642 1 0 0
v_max_id_clo_res 1029 1029 0 0.00 0 2342 13 0 0
v_max_id_ord_sup 5516 5516 0 0.00 0 5096 4 0 0
v_max_non_paid_invoice 1408 1408 0 0.00 0 3912 5 0 0
v_max_non_paid_realizn 3568 3568 0 0.00 0 8016 6 0 0
v_min_id_clo_ord 5349 5349 0 0.00 0 2250 5 0 0
v_min_id_clo_res 1029 1029 0 0.00 0 4979 11 0 0
v_min_id_ord_sup 5516 5516 0 0.00 0 4846 3 0 0
v_min_non_paid_invoice 5830 5830 0 0.00 0 8921 31 0 0
v_min_non_paid_realizn 6988 6988 0 0.00 0 9368 24 0 0
v_our_firm 10294 10294 0 0.00 0 9 1 0 0
v_reserve_write_off 19986 19986 0 0.00 0 12796 11 0 0
x_lock_depdocs_on_canc_invoice 11616 11616 0 0.00 0 21343 141 0 0
x_lock_depdocs_on_canc_sup_ord 436 436 0 0.00 0 10667 344 0 0
x_make_qstorno_1000_1200 5349 5349 0 0.00 2 38066 1248 0 0
x_make_qstorno_1200_2000 5550 5550 0 0.00 3 81554 3246 0 0
x_make_qstorno_2100_3300 468749 468749 0 0.00 0 80158 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 23-03-2021 01:28:29 to 23-03-2021 01:28:33.

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:25 7 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:31 21870 8192000000 10265759632 10571235328 937025504 10.264 72 57 114 0 958323808 2595568 18702736
22:58:01 43118 8192000000 10356394448 10674569216 1391561728 14.520 100 82 163 1 1422986176 4902448 26522000
22:58:50 25466 8192000000 10392771920 10714976256 1444052048 14.985 100 90 180 0 1479805024 6691344 29061632
22:59:29 24241 8192000000 10427573056 10754404352 1471500704 15.227 100 88 176 0 1507801872 7687632 28613536
23:00:02 23435 8192000000 10443590608 10777182208 1496611792 15.447 100 90 180 0 1533912384 8560944 28739648
23:00:34 13493 8192000000 10449136336 10785439744 1511756448 15.579 100 90 180 1 1549900816 9086688 29057680
23:00:57 15662 8192000000 10473736752 10809282560 1528654176 15.725 100 90 180 0 1566596240 9703632 28238432
23:01:29 15155 8192000000 10489165520 10829717504 1541733904 15.839 100 87 174 0 1579588688 10423424 27431360
23:01:52 16989 8192000000 10527610048 10873081856 1566196512 16.050 100 83 166 2 1602495824 11036352 25262960
23:02:25 11767 8192000000 10545881024 10895761408 1604188128 16.375 100 88 176 1 1642740672 12074496 26478048
23:02:46 17254 8192000000 10567275360 10924056576 1626275952 16.563 100 87 174 1 1664880496 13030976 25573568
23:03:11 15854 8192000000 10592176016 10949525504 1644357808 16.717 100 87 174 1 1683473792 13450320 25665664
23:03:36 11726 8192000000 10614800992 10974838784 1656542848 16.820 100 83 165 1 1694247728 13612720 24092160
23:04:01 7320 8192000000 10617703024 10984226816 1677521552 16.996 100 73 146 1 1712025056 13372160 21131344
23:04:16 7978 8192000000 10627090352 10998976512 1692763008 17.124 100 76 152 0 1727620064 12776496 22080560
23:04:38 8668 8192000000 10660409840 11030429696 1718752144 17.342 100 89 178 0 1757057072 12908608 25396320
23:04:54 6860 8192000000 10665115680 11039162368 1723756320 17.384 100 81 162 3 1760706128 13313600 23636208
23:05:10 5110 8192000000 10680117648 11058221056 1744671072 17.557 100 78 156 2 1779826480 12746080 22409328
23:05:23 6469 8192000000 10694592848 11071942656 1752538864 17.623 100 73 145 1 1785314736 12496752 20279120
23:05:36 4657 8192000000 10706391024 11084775424 1767529552 17.747 100 78 156 2 1801898928 13019072 21350304
23:05:48 4403 8192000000 10714097328 11094241280 1776023904 17.817 100 88 177 2 1819297008 18497840 24775264
23:05:59 3950 8192000000 10727919072 11105554432 1785851552 17.898 100 86 172 0 1823948096 14068144 24028400
23:06:10 5213 8192000000 10741873280 11122368512 1793961968 17.964 100 87 170 1 1831525936 13173472 24390496
23:06:21 2940 8192000000 10745916144 11130998784 1804133936 18.048 100 81 162 1 1840696560 13490176 23072448
23:06:31 1952 8192000000 10753466352 11137609728 1818111296 18.162 100 85 168 2 1853825920 11680832 24033792
23:06:40 9185 8192000000 10755485088 11144138752 1823409696 18.206 100 86 167 2 1858944352 12344912 23189744
23:06:56 2081 8192000000 10765595216 11149905920 1823590000 18.207 100 85 165 0 1858871536 12945232 22336304
23:07:05 1648 8192000000 10783792112 11166359552 1835178336 18.302 100 91 180 1 1873698240 13981584 24538320
23:07:14 2747 8192000000 10783275728 11171143680 1840077088 18.341 100 87 171 1 1877710496 13778800 23854608
23:07:23 2203 8192000000 10782929552 11171536896 1843240032 18.367 100 90 181 0 1883056944 13547152 26269760
23:07:31 2311 8192000000 10784529888 11174682624 1849382656 18.417 100 92 184 2 1889104528 13010288 26711584
23:07:40 1571 8192000000 10800679760 11185483776 1855979008 18.471 100 92 184 0 1896607904 14336208 26292688
23:07:48 1917 8192000000 10805011648 11195863040 1862868208 18.527 100 94 188 0 1902683584 13062192 26753184
23:07:56 1645 8192000000 10811253440 11201019904 1867318416 18.563 100 85 170 0 1903726128 11624608 24783104
23:08:05 1546 8192000000 10809366352 11200110592 1866950016 18.560 100 82 161 2 1902982464 12700912 23331536
23:08:13 1424 8192000000 10818898336 11207589888 1874408688 18.620 100 83 164 3 1909737712 11545376 23783648
23:08:20 3796 8192000000 10815277760 11212763136 1878281408 18.651 100 88 174 0 1915584096 12738544 24564144
23:08:31 3820 8192000000 10821586464 11217563648 1875794464 18.631 100 70 138 2 1906792144 11238240 19759440
23:08:41 4865 8192000000 10808843760 11214397440 1878400976 18.652 100 81 158 2 1913407152 12627248 22378928
23:08:54 9534 8192000000 10823741616 11216007168 1884658640 18.703 100 88 175 2 1919962464 11486848 23816976
23:09:10 2449 8192000000 10819037712 11224748032 1886423872 18.717 100 75 150 0 1921201440 14144352 20633216
23:09:19 19331 8192000000 10813937328 11221151744 1886711344 18.719 100 59 114 0 1913545408 9579232 17254832
23:09:45 7099 8192000000 10791378240 11215560704 1883033680 18.690 100 38 76 0 1903164976 9305888 10825408
23:09:58 9271 8192000000 10804353888 11218804736 1882219568 18.683 100 34 68 2 1899084720 7593776 9271376
23:10:15 7718 8192000000 10806972512 11223588864 1886508288 18.718 100 46 92 1 1909511792 9378976 13624528
23:10:33 7071 8192000000 10786401456 11216580608 1883070320 18.690 100 21 42 0 1895278592 6732992 5475280
23:10:47 4048 8192000000 10792886400 11222298624 1887135456 18.723 100 41 82 1 1906697712 7518320 12043936
23:11:01 6227 8192000000 10812506688 11225268224 1887286000 18.724 100 39 76 1 1908650912 10679856 10685056
23:11:14 7009 8192000000 10795294752 11225620480 1884299776 18.700 100 16 32 1 1894116816 6030880 3786160
23:11:27 7481 8192000000 10792615552 11224788992 1887995648 18.730 100 21 42 1 1899404480 5551824 5857008
23:11:42 9804 8192000000 10806900688 11231522816 1889641792 18.743 100 20 40 0 1901572208 6404544 5525872
23:12:03 8892 8192000000 10796991648 11228176384 1889184720 18.739 100 11 22 2 1897929008 5656768 3087520
23:12:18 10674 8192000000 10802425152 11239505920 1894199488 18.780 100 22 44 1 1911714000 11170512 6344000
23:12:35 6754 8192000000 10809705632 11237683200 1895658880 18.791 100 15 30 1 1905613856 5618752 4336224
23:12:50 11483 8192000000 10828290176 11241299968 1901050272 18.835 100 19 38 1 1914936992 9277680 4609040
23:13:07 79968 8192000000 10825481280 11250958336 1906750608 18.881 100 39 78 1 1924234384 4994880 12488896
23:14:34 4189 8192000000 10827990784 11261239296 1912088512 18.923 100 62 124 2 1940143472 10438608 17616352
23:14:46 3098 8192000000 10836752000 11259981824 1908069776 18.891 100 43 87 2 1927309360 6781536 12458048
23:14:56 6686 8192000000 10826163376 11256655872 1907114208 18.883 100 37 74 1 1924895408 7451568 10329632
23:15:09 6718 8192000000 10827496752 11262771200 1911190656 18.916 100 39 77 1 1934140192 11527056 11422480
23:15:22 3951 8192000000 10828303328 11258929152 1910083744 18.907 100 31 62 3 1925458976 5434512 9940720
23:15:41 4479 8192000000 10822727584 11258261504 1913855504 18.938 100 43 85 2 1932787872 5513776 13418592
23:15:54 8660 8192000000 10827697936 11258929152 1912406608 18.926 100 37 75 1 1928189088 5628880 10153600
23:16:10 8615 8192000000 10828521008 11262988288 1912707472 18.928 100 26 52 3 1926297504 5889584 7700448
23:16:25 5845 8192000000 10823898656 11256315904 1901825504 18.841 100 15 30 2 1915907504 9883728 4198272
23:16:41 22828 8192000000 10790959472 11230138368 1855824464 18.469 97 28 57 1 1869785056 5441376 8519216
23:17:10 43413 8192000000 10802215008 11238129664 1848355312 18.409 97 27 52 2 1863777984 8956688 6465984
23:18:00 8276 8192000000 10803291136 11235266560 1871346112 18.595 99 23 44 1 1883495792 5893536 6256144
23:18:16 7760 8192000000 10795294608 11220480000 1837827232 18.323 97 18 36 2 1849347376 5861632 5658512
23:18:30 5208 8192000000 10804818656 11224215552 1864437920 18.539 99 32 64 0 1880507888 7321872 8748096
23:18:42 7857 8192000000 10755293376 11176927232 1831459248 18.271 98 35 70 1 1847896752 6339776 10097728
23:18:56 7350 8192000000 10731226240 11149688832 1769428688 17.762 96 26 52 2 1784282304 6973952 7879664
23:19:10 5465 8192000000 10750598688 11163639808 1811378448 18.107 99 40 79 0 1830207456 7520272 11308736
23:19:25 7857 8192000000 10714001584 11117473792 1746734736 17.575 97 17 34 1 1757005392 4858816 5411840
23:19:40 6461 8192000000 10666027504 11074342912 1654037008 16.799 92 27 53 2 1666881376 4353472 8490896
23:19:53 15651 8192000000 10685086912 11106242560 1699527856 17.181 95 14 28 3 1708499760 5024656 3947248
23:20:18 8697 8192000000 10723208448 11132547072 1770797712 17.774 98 27 54 3 1785317440 6558896 7960832
23:20:33 11208 8192000000 10667071232 11079655424 1640121840 16.681 91 24 48 0 1652934736 5259024 7553872
23:20:52 9026 8192000000 10702341312 11125714944 1777689072 17.830 99 19 38 0 1788847488 6070736 5087680
23:21:08 9496 8192000000 10714230096 11123896320 1767087904 17.743 98 30 61 1 1781179408 5192112 8899392
23:21:32 56443 8192000000 10713952848 11144552448 1791256624 17.942 99 18 34 0 1800978416 4490432 5231360
23:22:35 9645 8192000000 10750599104 11163213824 1807388448 18.074 99 32 64 3 1822736304 5997216 9350640
23:22:53 6955 8192000000 10734774672 11157774336 1822968848 18.202 100 28 55 2 1837482224 7177616 7335760
23:23:07 4149 8192000000 10728984656 11143589888 1781323936 17.860 98 27 56 2 1796128816 6233264 8571616
23:23:24 2913 8192000000 10746184768 11170189312 1830701840 18.265 100 35 70 0 1847703040 7286720 9714480
23:23:33 5896 8192000000 10756109296 11174445056 1835977504 18.308 100 29 58 0 1850165392 5345024 8842864
23:23:48 6977 8192000000 10762730336 11190382592 1850209504 18.424 100 22 44 0 1862101216 5427232 6464480
23:24:05 8868 8192000000 10772096416 11199172608 1837206448 18.318 99 32 63 1 1852323632 6309664 8807520
23:24:20 6181 8192000000 10766656400 11198095360 1854214048 18.456 100 22 44 2 1866032672 5124080 6694544
23:24:34 8566 8192000000 10773359600 11202285568 1859211632 18.497 100 25 50 0 1872609168 6675392 6722144
23:24:52 8303 8192000000 10787803024 11214245888 1865977392 18.552 100 28 56 3 1880130048 5907280 8245376
23:25:08 7955 8192000000 10783345920 11215183872 1867962304 18.568 100 17 34 0 1877801552 5513552 4325696
23:25:22 8593 8192000000 10791309248 11220099072 1872539232 18.605 100 26 51 0 1890546864 10728128 7279504
23:25:37 11293 8192000000 10778753312 11213844480 1872380224 18.604 100 18 36 2 1887209376 9805168 5023984
23:25:54 20584 8192000000 10797562096 11224915968 1876981872 18.641 100 18 36 0 1887374976 5472368 4920736
23:26:23 72630 8192000000 10826603424 11251122176 1895356992 18.789 100 37 72 1 1911327872 5451664 10519216
23:27:45 24319 8192000000 10844225504 11269582848 1916936048 18.962 100 37 73 1 1934322800 6402416 10984336
23:28:17 19880 8192000000 10854193376 11283456000 1932343104 19.086 100 51 101 1 1954440560 8051040 14046416
23:28:52 36087 8192000000 10865693616 11298525184 1931587504 19.080 100 31 62 1 1948471424 7461072 9422848
23:29:42 13327 8192000000 10883521440 11314307072 1955945056 19.274 100 39 78 3 1975313728 8042368 11326304
23:30:06 7368 8192000000 10899068768 11321896960 1963310032 19.332 100 65 130 2 1991145696 9075712 18759952
23:30:22 19050 8192000000 10904645872 11327987712 1964957648 19.345 100 48 94 1 1988530800 9810672 13762480
23:30:57 30216 8192000000 10905404256 11341082624 1975478368 19.429 100 47 94 1 2003317392 13787760 14051264
23:31:36 18410 8192000000 10906759312 11346771968 1975307632 19.428 100 32 64 1 2000281504 15939040 9034832
23:32:02 8459 8192000000 10928563552 11358134272 1982511888 19.485 100 51 102 0 2014505728 16626048 15367792
23:32:25 11607 8192000000 10927490832 11358400512 1982875616 19.487 100 50 99 0 2015347824 17668384 14803824
23:32:46 8536 8192000000 10929521856 11364360192 1984248496 19.498 100 44 88 1 2016860352 19188304 13423552
23:33:05 5788 8192000000 10933797616 11363713024 1991155312 19.553 100 56 110 1 2025188096 18072464 15960320
23:33:20 5017 8192000000 10935313888 11368329216 1988921952 19.535 100 52 104 0 2023273568 18960672 15390944
23:33:37 12060 8192000000 10933294384 11368124416 1990605936 19.549 100 51 102 1 2025160656 19478160 15076560
23:34:02 8849 8192000000 10927551184 11371339776 1990987632 19.552 100 42 84 1 2021662864 17861920 12813312
23:34:18 5186 8192000000 10933226544 11371286528 1994943152 19.583 100 54 107 4 2029845936 19368176 15534608
23:34:33 13588 8192000000 10950397904 11381542912 2003036608 19.647 100 67 134 2 2042209232 19391392 19781232
23:35:02 5865 8192000000 10950545184 11385974784 2003227488 19.648 100 56 112 1 2042924704 22326192 17371024
23:35:23 7070 8192000000 10962701232 11396292608 2006063328 19.671 100 60 118 0 2047019344 23610784 17345232
23:35:38 21717 8192000000 10960419648 11402133504 2006423264 19.673 100 48 96 3 2046761728 25685824 14652640
23:36:13 8754 8192000000 10964265968 11409285120 2013121472 19.726 100 43 86 0 2055076496 28821392 13133632
23:36:32 12474 8192000000 10973696736 11420389376 2018637856 19.769 100 47 94 0 2064005664 30538432 14829376
23:36:56 10196 8192000000 10990949408 11432927232 2029955600 19.858 100 59 117 0 2078413584 30396112 18061872
23:37:19 5525 8192000000 10999242320 11438444544 2036162464 19.907 100 61 121 3 2089072816 34398304 18512048
23:37:36 2312 8192000000 11005343056 11438899200 2038322256 19.924 100 67 134 1 2090461184 32367040 19771888
23:37:45 9941 8192000000 10995949568 11435003904 2031370112 19.869 100 54 108 0 2081189424 33321776 16497536
23:38:06 6783 8192000000 10996306640 11436478464 2034199616 19.892 100 61 122 2 2085555616 32990336 18365664
23:38:24 7353 8192000000 10998071168 11442581504 2036210592 19.907 100 60 120 0 2090932368 36207856 18513920
23:38:52 4770 8192000000 11013675712 11453943808 2043040592 19.961 100 65 128 2 2100139920 37666224 19433104
23:39:06 8915 8192000000 11018096784 11452829696 2027975440 19.843 99 66 132 1 2086687504 38751120 19960944
23:39:24 5873 8192000000 11020097584 11459551232 2045375072 19.979 100 63 126 2 2104813344 40260144 19178128
23:39:38 4099 8192000000 11010431984 11445010432 2033565760 19.887 100 59 118 0 2092259248 41018896 17674592
23:39:51 5330 8192000000 11025153792 11463622656 2048281616 20.002 100 70 136 2 2113236064 44171456 20782992
23:40:06 2985 8192000000 11024970544 11449950208 2037543344 19.918 100 72 142 2 2104549376 44751680 22254352
23:40:15 4650 8192000000 11015613152 11447492608 2018716800 19.770 99 74 148 0 2088727040 46320192 23690048
23:40:33 2225 8192000000 11026975648 11453489152 2043681728 19.966 100 83 162 2 2114539920 45603104 25255088
23:40:48 2924 8192000000 11011611904 11433295872 2020782112 19.786 100 77 154 0 2089452608 44627888 24042608
23:40:58 5233 8192000000 10995027920 11434049536 2022173328 19.797 100 69 137 1 2091662080 47493552 21995200
23:41:11 1463 8192000000 11021553856 11447492608 2036004688 19.906 100 89 180 1 2106845568 42910912 27929968
23:41:19 4151 8192000000 11012067440 11437469696 2018959152 19.772 99 84 165 2 2088947056 44494032 25493872
23:41:31 5883 8192000000 11008071504 11437404160 2021603328 19.793 100 72 144 1 2092461904 48144480 22714096
23:41:43 3281 8192000000 11003845184 11430371328 2018909248 19.772 100 79 154 2 2088765744 45338256 24518240
23:41:55 5079 8192000000 11015754672 11441385472 2024457424 19.815 100 74 148 2 2094132064 46140464 23534176
23:42:13 6196 8192000000 11005880016 11435106304 2018281920 19.767 100 75 144 3 2088732048 47427520 23022608
23:42:29 2701 8192000000 10994725792 11415887872 1994255200 19.577 99 80 159 2 2066990304 48148048 24587056
23:42:40 2672 8192000000 11003263344 11418632192 1991455120 19.555 99 88 176 2 2068875632 49903056 27517456
23:42:51 3872 8192000000 11015530944 11434725376 2019139680 19.773 100 89 178 3 2099304448 51915392 28249376
23:43:04 3866 8192000000 11017979280 11443314688 2021210240 19.790 100 81 162 0 2100848560 53746848 25891472
23:43:15 2677 8192000000 11020263744 11437547520 2015292768 19.743 100 84 168 1 2098295856 55666928 27336160
23:43:24 3867 8192000000 11012119472 11431899136 2009627072 19.699 100 87 172 2 2093878576 55626368 28625136
23:43:37 5822 8192000000 11004799568 11430121472 1993315952 19.570 99 72 144 1 2071728848 55071040 23341856
23:43:51 4764 8192000000 11009257648 11433193472 1994452240 19.579 99 78 157 5 2077604112 57322080 25829792
23:44:05 6527 8192000000 10990980560 11409956864 1980745056 19.471 99 66 131 3 2061879040 59316368 21817616
23:44:22 2560 8192000000 11007651984 11435368448 2007136400 19.679 100 74 148 4 2090535296 59356544 24042352
23:44:33 6669 8192000000 11015598672 11437748224 2008644544 19.691 100 78 156 2 2093998960 60269456 25084960
23:44:51 2505 8192000000 11008387024 11430182912 2001988976 19.638 100 74 147 0 2089321072 63511520 23820576
23:45:04 5323 8192000000 11013345216 11434262528 1988233584 19.530 99 74 148 0 2079770992 66957584 24579824
23:45:16 3584 8192000000 11003498912 11428032512 1999732304 19.621 100 68 136 3 2080596912 58329440 22535168
23:45:29 5557 8192000000 10985023920 11406524416 1981341104 19.475 99 72 141 1 2062662544 58367104 22954336
23:45:42 1877 8192000000 11008324752 11430682624 2002420496 19.642 100 87 174 0 2092857776 62435776 28001504
23:45:51 1928 8192000000 11008392688 11422269440 2001766464 19.637 100 84 167 0 2086339936 57427536 27145936
23:45:59 1914 8192000000 11014546112 11425832960 2005806576 19.669 100 82 164 0 2087863824 55440608 26616640
23:46:07 3363 8192000000 11022665600 11436503040 2013116032 19.726 100 90 180 2 2100271312 58168144 28987136
23:46:20 2567 8192000000 11010788112 11437514752 2010376496 19.704 100 69 138 3 2091465216 58887712 22201008
23:46:52 10713 8192000000 10996231824 11426365440 1997842432 19.606 100 59 118 2 2078716640 61359696 19514512
23:47:14 2112 8192000000 11012402736 11434553344 2001911264 19.638 100 66 131 0 2086247552 62018016 22318272
23:47:25 3458 8192000000 11005025440 11435122688 2006852912 19.677 100 69 138 1 2094324688 64017328 23454448
23:47:36 6150 8192000000 10999530496 11420536832 1976921360 19.440 99 63 120 0 2063687968 66275520 20491088
23:47:51 6733 8192000000 11001425152 11429376000 1995586480 19.588 100 62 125 2 2082263760 65179552 21497728
23:48:06 6600 8192000000 10998215152 11429384192 1988773968 19.534 100 56 110 1 2076412272 68072224 19566080
23:48:22 3243 8192000000 10997292288 11430993920 1996092320 19.592 100 61 121 2 2085617488 69403248 20121920
23:48:33 2971 8192000000 11002782176 11432984576 1995959824 19.591 100 51 102 0 2080889168 67302832 17626512
23:48:43 11065 8192000000 10995948672 11435945984 1995442128 19.587 100 54 108 5 2082584704 67980800 19161776
23:49:11 11735 8192000000 10985350864 11425447936 1972879424 19.408 99 44 88 1 2054684192 66647056 15157712
23:49:59 14191 8192000000 10959262048 11405488128 1957060928 19.283 99 40 80 0 2033976560 63059664 13855968
23:50:20 7506 8192000000 10966227248 11408326656 1972643120 19.406 100 39 78 0 2051070512 65137440 13289952
23:50:43 31983 8192000000 10951910912 11423236096 1956831536 19.281 99 31 62 1 2041045440 73068768 11145136
23:51:25 16622 8192000000 10930346768 11381256192 1941411152 19.158 99 26 52 2 2011625456 60671824 9542480
23:52:01 15861 8192000000 10936575472 11382411264 1937822064 19.129 100 27 54 1 2013674336 65442784 10409488
23:52:43 33859 8192000000 10924641856 11375800320 1906711968 18.880 99 27 54 1 1993864192 76509168 10643056
23:53:25 27320 8192000000 10917907568 11364429824 1860284800 18.506 97 25 50 2 1952638448 82471088 9882560
23:53:58 9832 8192000000 10887847120 11349819392 1880871232 18.672 99 20 40 2 1956465472 67663840 7930400
23:54:19 10126 8192000000 10920610784 11367886848 1917473136 18.967 100 38 76 1 1994077184 63009680 13594368
23:54:39 26906 8192000000 10890551808 11342168064 1891874928 18.761 98 23 44 2 1960139792 58591600 9673264
23:55:12 32766 8192000000 10871850192 11333042176 1914012192 18.939 99 26 52 1 1944241248 22572432 7656624
23:55:53 21074 8192000000 10865093216 11329495040 1931611296 19.080 100 30 62 3 1958285952 18039632 8635024
23:56:21 20693 8192000000 10901398832 11333939200 1943526992 19.175 100 33 66 1 1962044064 8821520 9695552
23:57:18 90165 8192000000 10863786336 11312746496 1821630112 18.191 93 21 42 1 1836639856 9551248 5458496
23:59:00 25939 8192000000 10856279520 11306536960 1920798176 18.993 100 33 66 2 1945716640 15874848 9043616
23:59:32 116496 8192000000 10835271856 11294732288 1846779872 18.396 96 17 34 1 1868819088 17008160 5031056
00:01:36 101609 8192000000 10860497264 11311603712 1818519184 18.166 94 13 26 0 1831759776 9629136 3611456
00:03:34 106336 8192000000 10882195392 11336671232 1907250320 18.885 98 17 34 0 1928660176 16401248 5008608
00:05:29 66059 8192000000 10841788128 11298328576 1863315728 18.530 96 18 36 2 1890511312 21247408 5948176
00:06:43 2261 8192000000 10864226336 11308498944 1924307184 19.021 100 37 74 1 1950869008 15127712 11434112
00:06:53 35792 8192000000 10867612448 11319300096 1905262928 18.869 98 40 80 0 1932826944 16272160 11291856
00:07:46 29224 8192000000 10900997808 11336912896 1947904000 19.210 100 49 96 2 1976962960 15433792 13625168
00:08:22 40996 8192000000 10898560080 11351683072 1959778432 19.304 100 50 101 3 1993416752 19061552 14576768
00:09:20 60646 8192000000 10887960720 11365068800 1946296560 19.197 100 16 32 2 1970254304 18855936 5101808
00:10:36 113740 8192000000 10864610320 11331121152 1907137744 18.884 98 10 20 0 1924619536 14340576 3141216
00:12:51 71406 8192000000 10875021792 11347898368 1952239376 19.244 100 18 34 0 1970202400 13135472 4827552
00:14:09 15028 8192000000 10886595456 11353985024 1957748624 19.288 100 20 40 1 1977873920 14218720 5906576
00:14:35 34988 8192000000 10883206256 11359604736 1956024816 19.274 100 7 13 1 1972292704 14504448 1763440
00:15:37 53826 8192000000 10878763296 11354763264 1935071600 19.107 99 10 20 0 1951635360 13848528 2715232
00:17:05 31383 8192000000 10903780144 11363201024 1960041680 19.306 100 23 45 0 1974206304 8069808 6094816
00:17:49 72711 8192000000 10915912720 11386425344 1977968704 19.449 100 21 42 0 1996914592 12833616 6112272
00:19:47 117652 8192000000 10930221760 11388153856 1965731680 19.352 99 15 30 2 1990020464 19950896 4337888
00:21:51 13696 8192000000 10929363040 11379761152 1976468112 19.437 99 43 87 2 2000730624 9918592 14343920
00:22:15 73617 8192000000 10918081488 11391127552 1944069264 19.179 98 19 38 2 1959027568 9184208 5774096
00:23:36 57925 8192000000 10910779312 11362467840 1893768272 18.776 95 23 45 1 1912395776 12435392 6192112
00:24:47 58638 8192000000 10904909120 11375837184 1964849616 19.345 100 14 28 0 1983984816 15207152 3928048
00:25:52 120082 8192000000 10941147376 11394064384 1899432864 18.822 96 13 26 0 1914496896 11700576 3363456
00:28:00 102604 8192000000 10923284480 11412807680 1988385008 19.531 100 16 32 0 2018642336 25332512 4924816
00:29:49 114532 8192000000 10906975728 11370110976 1954637856 19.263 98 31 62 1 1975899936 12151312 9110768
00:31:56 43665 8192000000 10910808560 11382484992 1985836144 19.511 100 29 55 2 2002538400 8954480 7747776
00:32:51 47994 8192000000 10875841792 11348860928 1922833408 19.010 97 43 86 2 1944618928 9698528 12086992
00:33:55 55335 8192000000 10871651872 11354566656 1958538992 19.294 100 6 12 0 1967553872 7637568 1377312
00:34:58 10156 8192000000 10881273312 11357523968 1962680416 19.327 100 7 14 0 1971631328 7137136 1813776
00:35:14 16514 8192000000 10880246912 11352551424 1949420560 19.222 99 13 26 0 1960103408 7051952 3630896
00:35:53 29663 8192000000 10894998432 11362983936 1946914944 19.202 99 8 16 1 1959995200 10802048 2278208
00:36:34 45804 8192000000 10899680992 11370475520 1933602352 19.096 98 18 36 1 1949571680 9869264 6100064
00:38:24 81158 8192000000 10913143680 11381661696 1974151616 19.418 100 23 46 3 2001373584 19780928 7441040
00:39:51 99853 8192000000 10903115760 11376566272 1954048672 19.259 99 22 45 1 1980275168 19431984 6794512
00:41:42 60951 8192000000 10891493184 11362869248 1934795872 19.105 98 22 43 0 1954895952 13700400 6399680
00:42:53 78137 8192000000 10886193968 11363282944 1894617808 18.783 96 14 28 0 1910794048 11870208 4306032
00:44:18 51520 8192000000 10870588800 11334197248 1887032976 18.722 96 30 60 1 1904357120 8852976 8471168
00:45:26 50840 8192000000 10851800272 11307163648 1823704288 18.208 94 26 52 1 1838291392 7903648 6683456
00:46:23 23633 8192000000 10844539968 11309793280 1891401904 18.757 98 34 68 3 1911972144 11021104 9549136
00:46:57 24082 8192000000 10855750896 11315916800 1904790112 18.865 99 25 50 0 1922901792 10829760 7281920
00:47:43 55238 8192000000 10834565248 11287756800 1815355264 18.140 95 30 60 0 1833602576 9992976 8254336
00:48:46 56526 8192000000 10818372464 11294367744 1866292320 18.554 98 27 54 0 1888985968 15257856 7435792
00:49:51 93020 8192000000 10863672464 11316715520 1845573856 18.386 96 33 66 0 1868793600 14107472 9112272
00:51:31 87783 8192000000 10824456864 11295145984 1801034528 18.022 94 9 18 0 1813088448 9635888 2418032
00:53:06 30016 8192000000 10850687120 11296010240 1869568896 18.581 98 34 68 1 1888266736 9318192 9379648
00:53:49 42823 8192000000 10826487136 11296923648 1876297904 18.635 98 24 48 0 1904254224 21278384 6677936
00:54:38 52790 8192000000 10829943184 11297447936 1868586048 18.573 98 20 40 0 1889691920 15425152 5680720
00:55:37 118841 8192000000 10842427552 11300503552 1873897888 18.616 98 19 38 1 1889830336 10805056 5127392
00:57:43 28293 8192000000 10836956880 11317587968 1925620192 19.032 100 13 26 3 1938719216 10059568 3039456
00:58:22 42691 8192000000 10837863216 11301957632 1835919728 18.308 95 26 52 1 1850022672 7359648 6743296
00:59:11 53302 8192000000 10837832976 11314462720 1923981232 19.019 100 7 14 0 1933170688 7341440 1848016
01:00:19 30280 8192000000 10866766880 11329593344 1938047808 19.131 100 8 16 0 1950141408 9753376 2340224
01:01:00 82660 8192000000 10878355408 11353497600 1947518064 19.207 100 15 30 2 1964660912 12654768 4488080
01:02:36 66056 8192000000 10892507520 11369631744 1954066144 19.259 100 15 30 0 1971575824 12618400 4891280
01:03:48 78477 8192000000 10878979024 11350974464 1923005008 19.011 98 20 40 1 1942283616 13073216 6205392
01:05:32 36786 8192000000 10881717920 11352793088 1952594400 19.247 100 12 23 3 1966987248 10688992 3703856
01:06:17 66255 8192000000 10883939424 11339358208 1886344944 18.716 96 17 34 0 1901501296 10627040 4529312
01:07:31 62279 8192000000 10869371968 11342315520 1917811408 18.969 98 21 42 0 1935028928 11145232 6072288
01:08:40 52735 8192000000 10883457968 11352428544 1958156960 19.291 100 11 22 0 1969568336 8512304 2899072
01:09:39 35841 8192000000 10888635520 11356557312 1931622624 19.080 98 29 58 0 1947985648 8070752 8292272
01:10:21 41096 8192000000 10900175152 11363241984 1950186640 19.228 99 34 68 2 1968897616 9543520 9167456
01:11:15 54758 8192000000 10917418672 11384193024 1971533376 19.398 100 26 52 3 1990306112 11198544 7574192
01:12:18 105489 8192000000 10904779728 11381547008 1959323120 19.301 99 16 32 2 1975049600 11378688 4347792
01:14:10 26796 8192000000 10916592800 11368464384 1940115008 19.148 98 32 64 2 1955931632 7109552 8707072
01:14:43 21593 8192000000 10899239392 11361390592 1931843984 19.082 98 31 62 0 1949522080 8977040 8701056
01:15:12 60891 8192000000 10882892224 11362041856 1925083936 19.028 98 23 46 0 1941399440 9757920 6557584
01:17:42 42148 8192000000 10894398688 11360399360 1950462960 19.230 99 27 50 2 1963283920 5746048 7074912
01:18:31 10927 8192000000 10903785456 11359412224 1951959984 19.242 99 43 87 1 1972247328 7514432 12772912
01:18:48 31472 8192000000 10902675744 11373584384 1974106592 19.418 100 29 58 0 1992574016 9889344 8578080
01:19:41 49025 8192000000 10874514288 11353583616 1957882848 19.289 99 13 26 0 1968604304 6852800 3868656
01:20:39 52085 8192000000 10889760192 11371356160 1974616208 19.422 100 5 10 0 1983293952 7348592 1329152
01:21:38 39706 8192000000 10906304640 11383697408 1976380080 19.436 100 7 14 1 1985933360 7581424 1971856
01:22:25 75974 8192000000 10898345840 11387064320 1946990848 19.203 98 15 31 0 1961673696 10789968 3892880
01:23:53 55273 8192000000 10885794352 11381612544 1940433152 19.150 98 8 16 0 1954431232 11924528 2073552
01:24:57 50146 8192000000 10889076640 11354226688 1897101072 18.803 96 23 47 2 1916320240 12269488 6949680
01:25:59 53099 8192000000 10884055280 11360940032 1932021536 19.083 98 24 48 3 1947790192 8661424 7107232
01:27:05 21179 8192000000 9296396208 9572855808 456007744 5.272 24 4 6 1 459181936 2149216 1024976

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 23-03-2021 01:28:35 to 23-03-2021 01:29:07.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 68 v_add_invoice_to_stock 335544517
except 3 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 23-03-2021 01:29:08 to 23-03-2021 01:29:10.

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          235374
MON$OLDEST_ACTIVE               235375
MON$OLDEST_SNAPSHOT             235375
MON$NEXT_TRANSACTION            235375
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                       2008128
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.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 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 ---
:149: 
:150: mscs-test-161.budzdorov.ru    Tue Mar 23 01:27:29 2021
:151:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:152: 
--- end of diff output ---

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

23.03.21 01:29:10. 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-03-23 01:29:13 No severe PSQL-related problems occured
23.03.21 01:29:14. End of report.