Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 27.12.2020 01:27
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 17559064 kB
MemAvailable 31438440 kB
Buffers 0 kB
Cached 14117584 kB
SwapCached 4820 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 2020-12-27 01:27:11
DTS_END                         2020-12-27 01:27:11.1810
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/45956
TRN_ID                          234608
ATT_ID                          688
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: 9249.00 21103 1109880
customer order: creation 170.82 394 20498
customer order: refuse 14.43 371 1732
order to supplier: creation 44.79 1260 5375
order to supplier: removal 3.69 94544 443
invoice (draft): creation 44.91 3024 5389
invoice (draft): removal 53.88 813 6465
invoice accept: apply 40.47 18804 4856
invoice accept: cancel 48.57 762 5828
customer reserve: creation 3730.94 187 447713
customer reserve: removal 4803.84 56 576461
realization accept: apply 83.33 180 9999
realization accept: cancel 82.21 115 9865
payment from customer: creation 58.57 135 7028
payment from customer: removal 5.52 93 662
payment to supplier: creation 47.48 130 5697
payment to supplier: removal 3.54 78 425
service: total inventory turnovers 4.59 1207 551
service: total monetary turnovers 6.50 34 780
service: aggregate perf. data 0.91 16086 109
service: refresh index statistics 0.03 283788 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 27-12-2020 01:27:48 to 27-12-2020 01:27:51.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3828
TEST_TIME 2 3657
TEST_TIME 3 4440
TEST_TIME 4 4378
TEST_TIME 5 4646
TEST_TIME 6 4448
TEST_TIME 7 4330
TEST_TIME 8 5156
TEST_TIME 9 5622
TEST_TIME 10 6368
TEST_TIME 11 6870
TEST_TIME 12 7214
TEST_TIME 13 7514
TEST_TIME 14 7907
TEST_TIME 15 7883
TEST_TIME 16 8397
TEST_TIME 17 8876
TEST_TIME 18 8692
TEST_TIME 19 9234
TEST_TIME 20 9535
TEST_TIME 21 9701
TEST_TIME 22 9991
TEST_TIME 23 10599
TEST_TIME 24 11425
TEST_TIME 25 11386
TEST_TIME 26 11129
TEST_TIME 27 10826
TEST_TIME 28 10890
TEST_TIME 29 10708
TEST_TIME 30 10567
TEST_TIME 31 10385
TEST_TIME 32 10306
TEST_TIME 33 10133
TEST_TIME 34 9985
TEST_TIME 35 9853
TEST_TIME 36 9787
TEST_TIME 37 9738
TEST_TIME 38 9686
TEST_TIME 39 9667
TEST_TIME 40 9589
TEST_TIME 41 9551
TEST_TIME 42 9417
TEST_TIME 43 9508
TEST_TIME 44 9401
TEST_TIME 45 9460
TEST_TIME 46 9441
TEST_TIME 47 9414
TEST_TIME 48 9469
TEST_TIME 49 9546
TEST_TIME 50 9552
TEST_TIME 51 9549
TEST_TIME 52 9654
TEST_TIME 53 9603
TEST_TIME 54 9727
TEST_TIME 55 9700
TEST_TIME 56 9627
TEST_TIME 57 9491
TEST_TIME 58 9526
TEST_TIME 59 9456
TEST_TIME 60 9435
TEST_TIME 61 9417
TEST_TIME 62 9370
TEST_TIME 63 9402
TEST_TIME 64 9328
TEST_TIME 65 9326
TEST_TIME 66 9272
TEST_TIME 67 9350
TEST_TIME 68 9378
TEST_TIME 69 9520
TEST_TIME 70 9594
TEST_TIME 71 9566
TEST_TIME 72 9624
TEST_TIME 73 9655
TEST_TIME 74 9687
TEST_TIME 75 9666
TEST_TIME 76 9712
TEST_TIME 77 9661
TEST_TIME 78 9560
TEST_TIME 79 9491
TEST_TIME 80 9497
TEST_TIME 81 9477
TEST_TIME 82 9401
TEST_TIME 83 9362
TEST_TIME 84 9375
TEST_TIME 85 9305
TEST_TIME 86 9295
TEST_TIME 87 9266
TEST_TIME 88 9303
TEST_TIME 89 9325
TEST_TIME 90 9288
TEST_TIME 91 9319
TEST_TIME 92 9320
TEST_TIME 93 9394
TEST_TIME 94 9387
TEST_TIME 95 9478
TEST_TIME 96 9478
TEST_TIME 97 9472
TEST_TIME 98 9500
TEST_TIME 99 9475
TEST_TIME 100 9394
TEST_TIME 101 9360
TEST_TIME 102 9413
TEST_TIME 103 9355
TEST_TIME 104 9299
TEST_TIME 105 9273
TEST_TIME 106 9323
TEST_TIME 107 9271
TEST_TIME 108 9224
TEST_TIME 109 9179
TEST_TIME 110 9159
TEST_TIME 111 9241
TEST_TIME 112 9207
TEST_TIME 113 9220
TEST_TIME 114 9298
TEST_TIME 115 9276
TEST_TIME 116 9307
TEST_TIME 117 9319
TEST_TIME 118 9314
TEST_TIME 119 9318
TEST_TIME 120 9252

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 27-12-2020 01:27:52 to 27-12-2020 01:27: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 1524481 1524481 0 0.00 0 22490 6 0 0
doc_list_biud 1524479 1524479 0 0.00 0 26627 27 0 0
sp_add_invoice_to_stock 4997 4856 141 2.82 53 187046 18805 0 141
sp_cancel_adding_invoice 5828 5828 0 0.00 5 43689 762 0 0
sp_cancel_client_order 1732 1732 0 0.00 4 12952 372 0 0
sp_cancel_customer_reserve 576461 576461 0 0.00 1 26632 57 0 0
sp_cancel_pay_from_customer 662 662 0 0.00 3 5589 94 0 0
sp_cancel_pay_to_supplier 425 425 0 0.00 3 4344 79 0 0
sp_cancel_supplier_invoice 6471 6465 6 0.09 2 22901 813 0 6
sp_cancel_supplier_order 443 443 0 0.00 6 1008590 94544 0 0
sp_cancel_write_off 9865 9865 0 0.00 1 10216 116 0 0
sp_client_order 20498 20498 0 0.00 3 21962 395 0 0
sp_customer_reserve 447713 447713 0 0.00 0 45334 187 0 0
sp_fill_shopping_cart 31247 31247 0 0.00 1 21800 37 0 0
sp_fill_shopping_cart_clo_res 447710 447710 0 0.00 0 17561 16 0 0
sp_get_clo_for_invoice 4852 4852 0 0.00 0 31014 307 0 0
sp_kill_cost_storno 16780 16780 0 0.00 0 22477 59 0 0
sp_kill_qstorno_ret_qs2qd 1169695 1169695 0 0.00 0 26615 31 0 0
sp_kill_qty_storno 615644 615644 0 0.00 0 26627 67 0 0
sp_lock_selected_doc 20545 20545 0 0.00 0 6584 6 0 0
sp_make_cost_storno 27575 27575 0 0.00 0 22330 57 0 0
sp_multiply_rows_for_pdistr 27575 27575 0 0.00 0 12177 29 0 0
sp_multiply_rows_for_qdistr 20498 20498 0 0.00 0 21950 183 0 0
sp_pay_from_customer 7028 7028 0 0.00 4 20930 135 0 0
sp_pay_to_supplier 5697 5697 0 0.00 5 15262 131 0 0
sp_payment_common 12724 12724 0 0.00 1 15018 34 0 0
sp_qd_handle_on_cancel_clo 1732 1732 0 0.00 0 12946 336 0 0
sp_qd_handle_on_invoice_upd_sts 10679 10679 0 0.00 0 18900 329 0 0
sp_qd_handle_on_reserve_upd_sts 9999 9999 0 0.00 0 13675 57 0 0
sp_reserve_write_off 9999 9999 0 0.00 6 19585 181 0 0
sp_supplier_invoice 5389 5389 0 0.00 6 87686 3024 0 0
sp_supplier_order 5375 5375 0 0.00 5 30906 1260 0 0
srv_aggregate_perf_data 109 109 0 0.00 2830 162811 16086 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1155 114674 32767 0 0
srv_find_qd_qs_mism 1063161 1063161 0 0.00 0 11567 5 0 0
srv_make_invnt_saldo 551 551 0 0.00 32 130202 1208 0 0
srv_make_money_saldo 780 780 0 0.00 0 7529 35 0 0
srv_recalc_idx_stat 4 4 0 0.00 242632 328660 283788 0 0
t$perf-abend:sp_add_invoice_to_stock 141 141 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4856 4856 0 0.00 0 10922 173 0 0
t$perf-norm:sp_cancel_adding_invoice 418 418 0 0.00 0 8876 95 0 0
t$perf-norm:sp_cancel_client_order 1732 1732 0 0.00 0 2334 11 0 0
t$perf-norm:sp_cancel_customer_reserve 633 633 0 0.00 0 5082 23 0 0
t$perf-norm:sp_cancel_pay_from_customer 662 662 0 0.00 0 285 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 425 425 0 0.00 0 1702 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 390 390 0 0.00 0 603 15 0 0
t$perf-norm:sp_cancel_supplier_order 443 443 0 0.00 0 23508 1687 0 0
t$perf-norm:sp_cancel_write_off 993 993 0 0.00 0 5201 18 0 0
t$perf-norm:sp_client_order 20498 20498 0 0.00 0 12493 19 0 0
t$perf-norm:sp_customer_reserve 1020 1020 0 0.00 0 1623 6 0 0
t$perf-norm:sp_pay_from_customer 7029 7029 0 0.00 0 7181 13 0 0
t$perf-norm:sp_pay_to_supplier 5697 5697 0 0.00 0 5508 12 0 0
t$perf-norm:sp_reserve_write_off 9999 9999 0 0.00 0 8078 12 0 0
t$perf-norm:sp_supplier_invoice 5389 5389 0 0.00 0 5382 18 0 0
t$perf-norm:sp_supplier_order 5375 5375 0 0.00 0 10373 26 0 0
t$perf-norm:srv_aggregate_perf_data 109 109 0 0.00 0 4384 47 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 945 13 0 0
t$perf-norm:srv_make_invnt_saldo 551 551 0 0.00 0 1333 23 0 0
t$perf-norm:srv_make_money_saldo 780 780 0 0.00 0 2695 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 9984 9702 282 2.82 0 11782 20 0 282
v_all_customers 37480 37480 0 0.00 0 33 1 0 0
v_all_suppliers 29698 29698 0 0.00 0 21 1 0 0
v_all_wares 40996 40996 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 836 836 0 0.00 0 2366 10 0 0
v_cancel_client_order 3464 3464 0 0.00 0 11777 10 0 0
v_cancel_customer_prepayment 1324 1324 0 0.00 0 4399 10 0 0
v_cancel_customer_reserve 1266 1266 0 0.00 0 3801 8 0 0
v_cancel_payment_to_supplier 850 850 0 0.00 0 4313 13 0 0
v_cancel_supplier_invoice 792 780 12 1.51 0 7034 28 0 12
v_cancel_supplier_order 886 886 0 0.00 0 4417 9 0 0
v_cancel_write_off 1986 1986 0 0.00 0 3888 19 0 0
v_max_id_clo_ord 5367 5367 0 0.00 0 576 1 0 0
v_max_id_clo_res 1020 1020 0 0.00 0 2278 7 0 0
v_max_id_ord_sup 5382 5382 0 0.00 0 3464 4 0 0
v_max_non_paid_invoice 1596 1596 0 0.00 0 204 2 0 0
v_max_non_paid_realizn 3651 3651 0 0.00 0 4527 9 0 0
v_min_id_clo_ord 5367 5367 0 0.00 0 5364 11 0 0
v_min_id_clo_res 1020 1020 0 0.00 0 5861 18 0 0
v_min_id_ord_sup 5382 5382 0 0.00 0 3752 5 0 0
v_min_non_paid_invoice 5696 5696 0 0.00 0 15011 16 0 0
v_min_non_paid_realizn 7028 7028 0 0.00 0 9901 23 0 0
v_our_firm 10270 10270 0 0.00 0 24 1 0 0
v_reserve_write_off 19996 19996 0 0.00 0 19476 10 0 0
x_lock_depdocs_on_canc_invoice 11903 11903 0 0.00 0 17763 109 0 0
x_lock_depdocs_on_canc_sup_ord 443 443 0 0.00 0 4853 319 0 0
x_make_qstorno_1000_1200 5375 5375 0 0.00 1 28136 1173 0 0
x_make_qstorno_1200_2000 5389 5389 0 0.00 3 87652 2903 0 0
x_make_qstorno_2100_3300 447713 447713 0 0.00 0 42843 169 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 27-12-2020 01:27:56 to 27-12-2020 01:28:01.

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:14 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:21 9367 8192000000 10143504672 10440036352 796275568 8.859 63 55 112 0 818569104 2190128 20103408
22:57:39 15176 8192000000 10302019392 10615656448 1361607200 14.252 100 81 162 0 1391869632 4059568 26202864
22:58:06 32201 8192000000 10378386304 10702131200 1418215408 14.757 100 87 174 0 1452519200 6144464 28159328
22:58:50 33259 8192000000 10411888720 10736599040 1455095888 15.083 100 90 180 0 1491991648 7783088 29112672
22:59:38 27626 8192000000 10436278784 10766258176 1479299456 15.295 100 89 178 0 1516629184 8616352 28713376
23:00:21 10382 8192000000 10437552592 10774151168 1496938240 15.449 100 87 174 0 1534208224 9441584 27828400
23:00:49 15153 8192000000 10467235184 10807595008 1516188560 15.617 100 86 172 1 1553512768 9953776 27370432
23:01:22 18615 8192000000 10502487392 10847346688 1547040368 15.884 100 82 164 0 1583400960 10308768 26051824
23:01:50 16822 8192000000 10530258304 10880831488 1583905712 16.202 100 82 164 3 1620334320 11314864 25113744
23:02:18 12967 8192000000 10548773648 10904801280 1606379392 16.394 100 80 159 2 1642423456 11648800 24395264
23:02:40 10006 8192000000 10569407568 10928906240 1625854080 16.560 100 76 150 5 1659664048 11245584 22564384
23:02:59 8823 8192000000 10588430384 10945810432 1641495808 16.692 100 80 160 1 1677544768 11639520 24409440
23:03:15 9069 8192000000 10602356656 10966482944 1659508096 16.845 100 81 162 0 1696143152 12428656 24206400
23:03:34 12980 8192000000 10602141392 10975182848 1675974592 16.983 100 75 146 2 1709454784 12549536 20930656
23:03:55 7864 8192000000 10638532368 11009843200 1698570960 17.173 100 81 162 0 1734469312 12592912 23305440
23:04:10 8169 8192000000 10650245328 11022864384 1708154064 17.253 100 81 161 0 1744627024 13120544 23352416
23:04:27 7385 8192000000 10665694272 11040301056 1724094688 17.386 100 70 138 1 1755951792 12286032 19571072
23:04:43 6199 8192000000 10682669568 11062243328 1745777232 17.567 100 78 156 1 1781314128 13444336 22092560
23:04:56 9314 8192000000 10702161296 11080605696 1760814880 17.691 100 77 153 2 1795284912 13184992 21285040
23:05:13 4887 8192000000 10702508112 11087527936 1770228112 17.769 100 74 146 1 1803395328 12456496 20710720
23:05:26 5884 8192000000 10724186096 11110154240 1787533600 17.911 100 74 147 2 1818912592 10809888 20569104
23:05:39 4540 8192000000 10728811200 11110068224 1793510448 17.961 100 75 150 2 1826037952 12090880 20436624
23:05:50 6296 8192000000 10734072912 11125125120 1804543808 18.051 100 69 139 1 1835911664 11683776 19684080
23:06:07 6590 8192000000 10738284720 11127410688 1807416000 18.075 100 66 130 1 1836851408 11303040 18132368
23:06:21 3096 8192000000 10762616784 11149737984 1825942896 18.226 100 83 163 0 1860878016 11844496 23090624
23:06:31 4298 8192000000 10760807968 11152941056 1827021136 18.235 100 68 134 1 1857855808 11961456 18873216
23:06:42 3117 8192000000 10776601456 11163783168 1833884080 18.291 100 84 168 0 1870220576 13203584 23132912
23:06:52 2531 8192000000 10784466992 11167678464 1837827712 18.323 100 88 176 1 1877407168 14559248 25020208
23:07:01 2451 8192000000 10781274080 11166969856 1838488992 18.329 100 84 168 0 1877307792 14648928 24169872
23:07:11 3023 8192000000 10789479616 11176448000 1843882608 18.372 100 90 180 2 1884565088 15063056 25619424
23:07:21 2106 8192000000 10793104112 11175772160 1847156256 18.399 100 90 179 2 1885814992 14175728 24483008
23:07:29 1990 8192000000 10798229312 11182919680 1852595536 18.443 100 92 184 0 1892427936 14013328 25819072
23:07:38 2435 8192000000 10785837568 11176615936 1851408048 18.434 100 86 171 0 1888373984 13034048 23931888
23:07:47 2456 8192000000 10796884032 11182874624 1855248928 18.465 100 90 180 3 1892289376 11860256 25180192
23:07:56 2295 8192000000 10791334784 11183607808 1853698784 18.452 100 76 152 0 1887716624 12132352 21885488
23:08:05 2664 8192000000 10806503920 11192750080 1861312320 18.514 100 89 179 0 1898738960 11658304 25768336
23:08:14 1641 8192000000 10814393664 11200020480 1862930512 18.527 100 88 178 0 1900404368 13031344 24442512
23:08:23 2255 8192000000 10810376992 11199078400 1866393664 18.555 100 93 186 2 1908030416 14522704 27114048
23:08:31 1420 8192000000 10810984432 11198259200 1867119344 18.561 100 86 174 1 1905156240 13756528 24280368
23:08:39 23695 8192000000 10794779840 11204415488 1869438384 18.580 100 64 128 2 1898176192 11101776 17636032
23:09:09 2371 8192000000 10828174912 11221381120 1881311536 18.676 100 89 179 2 1918170192 11435584 25423072
23:09:18 2792 8192000000 10807993520 11218874368 1876381120 18.636 100 50 100 1 1901462928 11594912 13486896
23:09:28 3226 8192000000 10815020384 11220672512 1884123232 18.698 100 64 128 2 1914175296 12189792 17862272
23:09:38 2785 8192000000 10807304000 11221671936 1882816560 18.688 100 58 114 3 1909684896 10931568 15936768
23:09:47 4290 8192000000 10809991696 11216764928 1882548992 18.686 100 50 98 0 1905425936 8869120 14007824
23:10:00 3336 8192000000 10804870208 11216719872 1880420816 18.669 100 41 82 1 1901005520 9373536 11211168
23:10:10 10350 8192000000 10804059296 11217596416 1879795184 18.663 100 29 58 1 1896376992 8422320 8159488
23:10:27 17526 8192000000 10791103248 11222274048 1882414656 18.685 100 33 66 1 1899236800 7130464 9691680
23:11:14 15766 8192000000 10793248112 11222933504 1883910496 18.697 100 30 60 1 1899504784 7165472 8428816
23:11:38 4374 8192000000 10802173328 11229757440 1887841776 18.728 100 37 74 1 1904914016 5432944 11639296
23:11:50 8737 8192000000 10793821984 11229773824 1886924208 18.721 100 28 55 3 1901916192 7695152 7296832
23:12:05 4787 8192000000 10813773344 11238428672 1889995504 18.746 100 34 68 0 1907759744 7902800 9861440
23:12:16 8391 8192000000 10798540304 11236081664 1894627168 18.783 100 26 52 1 1908699776 6777248 7295360
23:12:30 4559 8192000000 10816875008 11241811968 1899687440 18.824 100 48 93 1 1920117072 5818816 14610816
23:12:41 5340 8192000000 10808495728 11240845312 1895440800 18.790 100 21 42 1 1907565040 6034992 6089248
23:12:54 7656 8192000000 10819058976 11246010368 1899109328 18.819 100 27 54 2 1912970304 6268560 7592416
23:13:08 10454 8192000000 10813495184 11247804416 1901992784 18.842 100 26 52 2 1914995440 6095648 6907008
23:13:29 4802 8192000000 10820609424 11249430528 1904288736 18.861 100 29 58 2 1919530736 7631232 7610768
23:13:41 7242 8192000000 10808257424 11249254400 1904679200 18.864 100 20 40 1 1916230240 6069856 5481184
23:14:00 11992 8192000000 10819777360 11258462208 1905988624 18.874 100 17 35 0 1916254992 5862784 4403584
23:14:19 7871 8192000000 10820572384 11255652352 1908302160 18.893 100 22 44 1 1920488976 5879856 6306960
23:14:36 8087 8192000000 10825562096 11262844928 1908366016 18.894 100 14 27 1 1921934784 9801600 3767168
23:14:50 69224 8192000000 10847593504 11266674688 1913830112 18.937 100 34 68 1 1929171488 5150704 10190672
23:16:06 17683 8192000000 10812708432 11249582080 1889129552 18.739 99 26 52 1 1903087936 6982672 6975712
23:16:30 10840 8192000000 10824567664 11258093568 1905455136 18.870 100 15 28 1 1915367312 5849488 4062688
23:16:53 5048 8192000000 10802397504 11230171136 1876569200 18.637 99 30 61 4 1890604016 5598928 8435888
23:17:05 6815 8192000000 10814058000 11245834240 1896890768 18.801 100 25 48 3 1909562896 5918016 6754112
23:17:18 5908 8192000000 10793059712 11212333056 1824649904 18.216 96 38 76 2 1841124432 4629872 11844656
23:17:35 5768 8192000000 10748919200 11173462016 1814632576 18.134 97 12 24 2 1823251808 4948016 3671216
23:17:47 3774 8192000000 10781980560 11205165056 1849433536 18.418 99 37 77 0 1866064192 5372000 11258656
23:17:57 6304 8192000000 10755108288 11187703808 1832404768 18.279 99 16 32 1 1843376304 6384272 4587264
23:18:09 14167 8192000000 10733147424 11161481216 1779288352 17.844 96 21 42 3 1791679216 6142368 6248496
23:18:30 11374 8192000000 10759557872 11184988160 1810882400 18.103 98 20 40 1 1821892832 5367760 5642672
23:18:50 7856 8192000000 10756080336 11175813120 1821747392 18.192 99 14 28 0 1831221568 5708528 3765648
23:19:06 7981 8192000000 10750689440 11171737600 1792418576 17.952 97 38 76 3 1809501376 5752560 11330240
23:19:22 9035 8192000000 10705566960 11122434048 1747357936 17.580 96 28 57 2 1765355040 9912064 8085040
23:19:38 61354 8192000000 10718867632 11123810304 1649573552 16.761 91 32 64 2 1663982016 4788992 9619472
23:20:49 22650 8192000000 10575436432 10980540416 1611720720 16.439 91 17 34 1 1621341776 5139232 4481824
23:21:18 6479 8192000000 10711376608 11119140864 1773197168 17.793 99 34 66 3 1788797744 6042144 9558432
23:21:31 5357 8192000000 10662708304 11072659456 1717050480 17.328 97 27 53 1 1731092160 6141664 7900016
23:21:45 5599 8192000000 10701453728 11118022656 1785862048 17.898 100 28 56 0 1800404544 6864400 7678096
23:21:59 5983 8192000000 10716915392 11132755968 1786829584 17.906 99 38 76 2 1805037632 7137856 11070192
23:22:12 13173 8192000000 10703330432 11118129152 1772038576 17.784 98 29 56 0 1785254192 5385696 7829920
23:22:34 8540 8192000000 10713232672 11130769408 1782944192 17.874 99 23 45 1 1795646880 6054912 6647776
23:22:50 5777 8192000000 10721569040 11137818624 1801868320 18.029 100 22 44 2 1814317120 6132672 6316128
23:23:06 13445 8192000000 10745355280 11153100800 1782548272 17.870 98 21 42 0 1794145888 4974960 6622656
23:23:25 11141 8192000000 10729957008 11151732736 1803255584 18.041 99 22 44 0 1815523984 6295120 5973280
23:23:43 7764 8192000000 10754888416 11167453184 1829489200 18.255 100 33 66 0 1845100736 6081088 9530448
23:24:01 10546 8192000000 10748411968 11171692544 1836201008 18.310 100 15 30 0 1847050496 5669680 5179808
23:24:22 18626 8192000000 10749617728 11176296448 1838005440 18.325 100 15 30 0 1848286576 5985920 4295216
23:24:47 60686 8192000000 10802960368 11193806848 1854333760 18.457 100 67 136 0 1879857264 5585184 19938320
23:25:53 14670 8192000000 10758733344 11188613120 1849178832 18.415 100 20 40 2 1861455728 6566096 5710800
23:26:18 12098 8192000000 10766402736 11197214720 1855563504 18.467 100 30 57 2 1871475152 6681312 9230336
23:26:36 6297 8192000000 10775895312 11196653568 1855972688 18.471 100 22 43 2 1867483648 5679456 5831504
23:26:51 6697 8192000000 10778951344 11204763648 1866134416 18.553 100 28 56 2 1881796112 6721296 8940400
23:27:05 25356 8192000000 10811881632 11228721152 1877429088 18.644 100 25 49 1 1893412320 8918240 7064992
23:27:43 47363 8192000000 10834637968 11255320576 1905366176 18.869 100 42 84 2 1925036112 8158480 11511456
23:28:42 13657 8192000000 10852475520 11266736128 1919079232 18.979 100 45 90 0 1941167536 9531088 12557216
23:29:16 19057 8192000000 10856555456 11275374592 1924830096 19.026 100 50 100 1 1951577296 12822128 13925072
23:29:45 20801 8192000000 10864410496 11290382336 1928943104 19.058 100 52 102 1 1957351376 13978912 14429360
23:30:15 11016 8192000000 10868535696 11292028928 1935495680 19.111 100 42 84 0 1961126160 13208192 12422288
23:30:34 30233 8192000000 10880675856 11305885696 1941231968 19.157 100 38 77 2 1964816896 12624320 10960608
23:31:13 19717 8192000000 10888985568 11313807360 1949427520 19.222 100 49 98 2 1980916672 17208736 14280416
23:31:43 17372 8192000000 10896070352 11323002880 1954044288 19.259 100 42 86 2 1984881696 18462976 12374432
23:32:10 50805 8192000000 10898430576 11331813376 1961007392 19.314 100 31 62 4 1988714592 18296096 9411104
23:33:16 22351 8192000000 10901912128 11336654848 1966470208 19.357 100 33 66 0 1993858848 17296400 10092240
23:33:48 49298 8192000000 10914721760 11355869184 1980194864 19.466 100 34 68 1 2014072416 23296832 10580720
23:34:47 5466 8192000000 10921749584 11353313280 1981335440 19.475 100 41 83 0 2016493344 22333568 12824336
23:35:22 7968 8192000000 10935159968 11374399488 1986884848 19.519 100 40 79 4 2025017104 25383056 12749200
23:35:38 2360 8192000000 10943368400 11372904448 1989727488 19.542 100 57 114 2 2033865904 25863568 18274848
23:35:49 9740 8192000000 10932685920 11372871680 1990832560 19.550 100 55 109 1 2032316128 24839440 16644128
23:36:07 3495 8192000000 10945842832 11374964736 1991404064 19.555 100 65 130 1 2038144992 26628624 20112304
23:36:18 4786 8192000000 10952947952 11377233920 1991825696 19.558 100 60 120 1 2038739424 28451056 18462672
23:36:33 7037 8192000000 10956565680 11382923264 1994012832 19.575 100 58 116 3 2039511856 28019504 17479520
23:36:48 4326 8192000000 10951060256 11385069568 1998802112 19.613 100 52 104 0 2041102256 26434016 15866128
23:37:02 5935 8192000000 10964371440 11391430656 2001470944 19.634 100 60 118 4 2045893824 26470640 17952240
23:37:18 2034 8192000000 10983039696 11398770688 2010721728 19.707 100 77 155 0 2063504016 29204304 23577984
23:37:26 2030 8192000000 10985680384 11404894208 2014785360 19.739 100 89 177 3 2071162496 29991456 26385680
23:37:36 2940 8192000000 10975535648 11398619136 2009252256 19.696 100 82 164 0 2064682384 30307280 25122848
23:37:46 5352 8192000000 10974649136 11404992512 2011975904 19.717 100 73 145 0 2064741952 31202224 21563824
23:37:59 1506 8192000000 10983422272 11401637888 2015178816 19.742 100 81 163 0 2067796912 28392448 24225648
23:38:07 2407 8192000000 10986409744 11405537280 2018991664 19.772 100 89 177 2 2074503744 29813488 25698592
23:38:17 1154 8192000000 10983315504 11395018752 2006706560 19.676 100 91 181 0 2064943392 31256736 26980096
23:38:25 2576 8192000000 10974609808 11393159168 2005203120 19.664 100 83 164 1 2061285952 31726352 24356480
23:38:34 1778 8192000000 10986127568 11402125312 2009548160 19.698 100 87 174 0 2068503456 32465168 26490128
23:38:43 4113 8192000000 10976142816 11396501504 2006945488 19.677 100 83 167 0 2064307792 32778480 24583824
23:38:53 3593 8192000000 10979053728 11402264576 2009186688 19.695 100 82 164 2 2066548320 32908272 24453360
23:39:04 5240 8192000000 10976600352 11402682368 2007921696 19.685 100 67 132 0 2060710240 32841248 19947296
23:39:19 5584 8192000000 10990131152 11409604608 2015902096 19.748 100 73 146 1 2068902528 30829024 22171408
23:39:32 5397 8192000000 10989907984 11410972672 2017019728 19.757 100 82 164 0 2074506448 32278784 25207936
23:39:46 1492 8192000000 10993487040 11412635648 2018799296 19.771 100 96 192 2 2080137760 32958992 28379472
23:39:55 1370 8192000000 10999631136 11417849856 2021042992 19.788 100 86 170 2 2081471856 33555792 26873072
23:40:03 3087 8192000000 10974626816 11395690496 2004811856 19.661 100 75 149 1 2061849120 34019344 23017920
23:40:15 4870 8192000000 10980039008 11404427264 2008659616 19.691 100 77 147 2 2067023552 34570192 23793744
23:40:31 4040 8192000000 10976196912 11404759040 2003232304 19.648 100 63 124 1 2057862080 35576336 19053440
23:40:48 3665 8192000000 10998326192 11412992000 2012752912 19.723 100 76 151 3 2071184352 36784960 21646480
23:41:02 3213 8192000000 11009201248 11423739904 2018882976 19.771 100 74 142 0 2077075648 36308560 21884112
23:41:14 12060 8192000000 10995353504 11431821312 2028810016 19.849 100 68 136 1 2089163808 38964272 21389520
23:41:36 6341 8192000000 11005039904 11439927296 2028177840 19.844 100 61 118 2 2086448048 39499328 18770880
23:41:53 8285 8192000000 10993628288 11435921408 2033674880 19.887 100 56 112 0 2083927232 32718752 17533600
23:42:11 2464 8192000000 11010415664 11436765184 2036526240 19.910 100 80 158 2 2093465616 33169600 23769776
23:42:21 3207 8192000000 11016119872 11443847168 2041136384 19.946 100 86 169 1 2102988048 35920640 25931024
23:42:31 3739 8192000000 11017571408 11447746560 2046197488 19.985 100 79 157 0 2106396800 36094384 24104928
23:42:44 4623 8192000000 11020872992 11441094656 2035769232 19.904 100 69 138 3 2095846800 38128368 21949200
23:42:57 2833 8192000000 10994973408 11417030656 2014579792 19.738 100 83 163 0 2079104512 39258176 25266544
23:43:06 3999 8192000000 10983272096 11407417344 1990810000 19.550 99 69 136 1 2052374464 40138512 21425952
23:43:17 3718 8192000000 10994887904 11407540224 2001283232 19.633 100 81 162 1 2069057632 42779424 24994976
23:43:28 1596 8192000000 10980603136 11394985984 1984715440 19.502 99 86 172 2 2055520512 43785152 27019920
23:43:37 2193 8192000000 10984409152 11396956160 1989848784 19.543 100 91 179 4 2062679792 44815440 28015568
23:43:46 2847 8192000000 10966029440 11392970752 1984341728 19.499 100 69 137 0 2052105824 45892416 21871680
23:43:55 16117 8192000000 10930596880 11380973568 1965359184 19.349 99 43 86 0 2018280800 38246304 14675312
23:44:18 18696 8192000000 10924315024 11364605952 1935652768 19.112 98 38 76 2 1983978816 36509792 11816256
23:44:43 3409 8192000000 10934364784 11370258432 1963659728 19.335 100 49 95 1 2017990480 38832368 15498384
23:45:04 8093 8192000000 10945706064 11379843072 1960832880 19.313 99 57 113 0 2014914992 36317312 17764800
23:45:19 2874 8192000000 10973118352 11386679296 1985847904 19.511 100 86 171 2 2050762320 38257728 26656688
23:45:29 3976 8192000000 10969628256 11384180736 1977512192 19.445 100 73 145 1 2039544832 38838496 23194144
23:45:40 3672 8192000000 10957308736 11382329344 1978199088 19.450 100 64 128 2 2039059120 40310480 20549552
23:45:51 1521 8192000000 10963132336 11378421760 1962811472 19.328 99 87 175 1 2033331456 42942944 27577040
23:46:03 3956 8192000000 10971875840 11395989504 1984478736 19.500 100 74 148 2 2055734144 47013264 24242144
23:46:25 1855 8192000000 10981503328 11400138752 1975601872 19.430 99 80 159 2 2045873776 44411744 25860160
23:46:34 2822 8192000000 10975333472 11393052672 1984948816 19.504 100 78 153 0 2052964720 43057968 24957936
23:46:46 4158 8192000000 10955942176 11386593280 1984566912 19.501 100 61 122 0 2043788976 39114128 20107936
23:46:59 10000 8192000000 10929407888 11373256704 1939990720 19.147 98 44 88 1 1994770672 40282016 14497936
23:47:27 9831 8192000000 10950172976 11387285504 1976992880 19.441 100 52 104 5 2034985504 40505744 17486880
23:47:45 1987 8192000000 10964858144 11377917952 1968248400 19.372 100 86 172 2 2039088400 43224976 27615024
23:47:54 6959 8192000000 10942389104 11370967040 1967611760 19.366 100 65 131 1 2028438960 38988832 21838368
23:48:07 4672 8192000000 10938586944 11375190016 1967364816 19.365 100 55 110 0 2022184224 37622336 17197072
23:48:28 13462 8192000000 10926722864 11367432192 1948061792 19.211 99 48 96 0 2004919440 40883904 15973744
23:48:53 11359 8192000000 10919028000 11366846464 1957661760 19.287 100 37 74 0 2013611984 43405936 12544288
23:49:35 32017 8192000000 10899018624 11355291648 1908201536 18.892 98 30 60 1 1958280480 39187920 10891024
23:50:18 13355 8192000000 10894959824 11348983808 1917381424 18.966 99 20 40 0 1968483536 43180352 7921760
23:50:59 24128 8192000000 10865547472 11324170240 1880240624 18.667 98 16 32 1 1917543856 31396976 5906256
23:51:30 44879 8192000000 10853432960 11312226304 1865835648 18.551 97 11 22 0 1891508944 21631744 4041552
23:52:24 19462 8192000000 10867114160 11300458496 1913483024 18.935 99 48 94 3 1935381504 6538704 15359776
23:53:03 69180 8192000000 10890143568 11324014592 1937879664 19.130 100 33 67 4 1956685552 9290128 9515760
23:54:26 37926 8192000000 10842831344 11301138432 1892219264 18.764 98 20 40 1 1910682016 12160672 6302080
23:55:11 35177 8192000000 10851798288 11317374976 1910704144 18.912 99 16 32 2 1924019264 8793280 4521840
23:55:55 76230 8192000000 10862647024 11327401984 1916858032 18.962 99 20 41 1 1930061648 8267920 4935696
23:57:31 68531 8192000000 10877163504 11339272192 1920026704 18.987 98 15 30 1 1933314816 9704752 3583360
23:58:49 72754 8192000000 10846286704 11306627072 1881011088 18.673 96 20 40 2 1894769328 9014352 4743888
00:00:08 85188 8192000000 10883598048 11340517376 1912283312 18.925 98 13 26 0 1921771568 6214528 3273728
00:01:40 33167 8192000000 10875258400 11335458816 1923934272 19.018 98 15 32 0 1940043568 11493680 4615616
00:02:38 62534 8192000000 10883890672 11347337216 1958995360 19.298 100 24 48 1 1976322832 9958352 7369120
00:03:47 62917 8192000000 10903043264 11368165376 1969156592 19.379 100 22 44 1 1989646160 13410880 7078688
00:05:11 57910 8192000000 10899148080 11374751744 1966164720 19.355 100 8 15 0 1990804496 22055040 2584736
00:06:16 52716 8192000000 10890306992 11372781568 1945514064 19.191 99 5 10 0 1964029280 17474880 1040336
00:07:16 25581 8192000000 10897128048 11353165824 1954615520 19.263 99 24 48 3 1975685776 13821664 7248592
00:07:52 66872 8192000000 10883496944 11350577152 1919185760 18.980 97 18 36 2 1939381296 14799216 5396320
00:09:57 65036 8192000000 10886724944 11365253120 1965923840 19.353 100 16 31 0 1981654640 10881504 4849296
00:11:09 30417 8192000000 10907183456 11359506432 1939054128 19.139 98 24 48 5 1952486608 6288864 7143616
00:11:49 53490 8192000000 10888739312 11348463616 1935898096 19.114 98 29 58 0 1954900192 10682768 8319328
00:12:50 40267 8192000000 10893419120 11349893120 1909598576 18.903 97 24 48 2 1924601664 8298768 6704320
00:14:16 51819 8192000000 10905331648 11365318656 1931738720 19.081 98 20 40 0 1949113216 12046368 5328128
00:15:15 92408 8192000000 10905540496 11381821440 1975428016 19.428 100 14 28 0 1995847824 16275440 4144368
00:16:54 114673 8192000000 10914680496 11382394880 1951931344 19.242 98 11 22 0 1965789120 10786880 3070896
00:18:57 85896 8192000000 10915391696 11394072576 1970654752 19.391 99 7 14 0 1987400976 14762992 1983232
00:20:30 38581 8192000000 10934820720 11375771648 1933530064 19.095 97 33 66 2 1953673328 10749088 9394176
00:21:18 19335 8192000000 10927370496 11378413568 1989037248 19.536 100 35 70 0 2010025072 11126304 9861520
00:22:30 71517 8192000000 10927514448 11376959488 1912082096 18.923 96 18 36 0 1925794256 9066912 4645248
00:23:59 85171 8192000000 10888735600 11358035968 1958770512 19.296 99 24 48 2 1976702016 11143968 6787536
00:25:32 37678 8192000000 10886776704 11349385216 1935084416 19.108 98 33 60 4 1957409600 12800064 9525120
00:26:19 18903 8192000000 10881261296 11343073280 1932803984 19.089 98 26 52 2 1953590160 13581072 7205104
00:26:44 23333 8192000000 10891854560 11334582272 1940877072 19.154 99 21 42 0 1960765936 14000448 5888416
00:27:22 46037 8192000000 10857385776 11323211776 1923928560 19.018 98 25 50 0 1943379520 12595312 6855648
00:28:21 45379 8192000000 10865701760 11345096704 1944251600 19.181 99 15 30 0 1963950512 15655536 4043376
00:29:14 23115 8192000000 10868951488 11345649664 1946626064 19.200 99 8 16 0 1955271728 6675312 1970352
00:29:50 37799 8192000000 10886690976 11361136640 1961778432 19.320 100 7 14 1 1969650688 6497488 1374768
00:30:39 28756 8192000000 10869009488 11353026560 1931208448 19.077 98 9 18 0 1942769248 9152064 2408736
00:31:15 43002 8192000000 10885128704 11352563712 1881115024 18.674 95 22 43 1 1899967616 12348896 6503696
00:32:18 43739 8192000000 10892644672 11360301056 1916528976 18.959 97 28 55 1 1939353840 15367440 7457424
00:33:09 39079 8192000000 10885363024 11342667776 1920938192 18.994 98 31 62 2 1945890160 15862624 9089344
00:33:55 78859 8192000000 10911586064 11398193152 1941193984 19.156 99 17 34 2 1967038752 20801680 5043088
00:35:40 51138 8192000000 10905778864 11369992192 1935856912 19.114 98 27 53 3 1967609648 23767648 7985088
00:37:06 66115 8192000000 10856499680 11308695552 1828756400 18.249 94 21 42 0 1851812560 17231600 5824560
00:38:18 35617 8192000000 10881044656 11324383232 1918204400 18.972 99 20 40 0 1936097104 12280448 5612256
00:39:03 32845 8192000000 10884561312 11334737920 1911229680 18.917 98 36 71 2 1936918944 15556400 10132864
00:39:47 38713 8192000000 10877909072 11357609984 1933257616 19.093 100 13 26 1 1956031072 18954320 3819136
00:40:36 80127 8192000000 10886037936 11347415040 1910199104 18.908 98 14 28 0 1932310304 17967904 4143296
00:42:07 55091 8192000000 10889365488 11358793728 1940683232 19.152 99 24 48 1 1964939216 17524992 6730992
00:44:02 16324 8192000000 10878628864 11317874688 1905340592 18.869 98 37 73 2 1927891120 11868160 10682368
00:44:28 96401 8192000000 10880032528 11323551744 1868858640 18.575 96 41 82 0 1890888416 10548912 11480864
00:46:19 66754 8192000000 10856594512 11314479104 1901896752 18.842 98 26 50 2 1919195360 10593440 6705168
00:47:32 20743 8192000000 10830980912 11295334400 1891969856 18.762 98 20 40 0 1905746976 7938000 5839120
00:47:59 8774 8192000000 10844529280 11312877568 1910624432 18.912 99 17 34 1 1923097392 8105888 4367072
00:48:21 70546 8192000000 10844904240 11318403072 1880769168 18.671 97 15 30 1 1892613312 7395808 4448336
00:49:38 42360 8192000000 10864730304 11333881856 1916179856 18.956 99 13 26 0 1929578208 9353120 4045232
00:50:28 70433 8192000000 10862025504 11334520832 1928079568 19.052 99 22 44 2 1942960160 8655952 6224640
00:51:47 49541 8192000000 10860928912 11342696448 1947945024 19.210 100 11 22 0 1959224096 8231056 3048016
00:53:04 72884 8192000000 10864668752 11337596928 1899075456 18.819 97 5 10 1 1911882128 10949248 1857424
00:54:28 99438 8192000000 10885313424 11350417408 1920460288 18.991 98 13 26 0 1943732496 19507376 3764832
00:56:17 62668 8192000000 10886923776 11347464192 1934273568 19.101 99 15 30 0 1949308160 11591456 3443136
00:57:26 36133 8192000000 10867147136 11318816768 1851317616 18.433 94 45 90 0 1872794496 8252528 13224352
00:58:43 80128 8192000000 10878283472 11352100864 1928854144 19.058 99 11 22 0 1942676000 10945472 2876384
01:00:16 69367 8192000000 10917832448 11375173632 1974564672 19.422 100 17 34 1 1991333216 12349104 4419440
01:01:34 64529 8192000000 10928289440 11389476864 1967631408 19.367 99 25 48 1 1988889904 15199344 6059152
01:02:44 82320 8192000000 10914362480 11382157312 1943153920 19.172 98 16 32 1 1960740432 12762288 4824224
01:04:18 57680 8192000000 10928051984 11391393792 1979305472 19.459 100 30 60 0 2000986896 13471920 8209504
01:05:24 65099 8192000000 10931152336 11382530048 1984830496 19.503 100 20 40 1 2006313104 16494272 4988336
01:06:35 21784 8192000000 10933653680 11382849536 1954905008 19.266 98 42 85 1 1983080080 16167152 12007920
01:07:05 97079 8192000000 10928932976 11393097728 1994213872 19.577 100 52 104 2 2026010672 16983504 14813296
01:08:52 64455 8192000000 10912463264 11399270400 1980924400 19.472 100 11 22 0 2004761760 20195888 3641472
01:10:03 21403 8192000000 10914337328 11402891264 1987756624 19.526 100 8 16 0 2007721104 17504432 2460048
01:11:50 77925 8192000000 10919723952 11396169728 1979527632 19.461 99 15 30 0 2001000912 17367184 4106096
01:13:18 62919 8192000000 10881178336 11368226816 1909352128 18.901 96 12 24 0 1924996416 11378880 4265408
01:14:27 43125 8192000000 10906957696 11383541760 1977534432 19.445 100 25 48 0 1991938512 7454848 6949232
01:15:51 55993 8192000000 10910902704 11385135104 1950294160 19.229 98 10 20 0 1966729616 13495920 2939536
01:16:59 64734 8192000000 10902610336 11379228672 1955763456 19.272 99 12 24 0 1976674464 17233376 3677632
01:18:18 45158 8192000000 10912105488 11370332160 1922137680 19.004 97 26 52 0 1935777376 6195632 7444064
01:19:15 57496 8192000000 10875592800 11334946816 1895852304 18.793 96 20 40 0 1912264352 10606928 5805120
01:20:24 49933 8192000000 10855398000 11328225280 1848407120 18.409 94 18 36 0 1867329088 13556192 5365776
01:21:27 93363 8192000000 10890512640 11343417344 1879633856 18.662 96 15 30 1 1896698096 12988704 4075536
01:23:06 85244 8192000000 10902842416 11372478464 1932968112 19.091 99 26 52 0 1955225824 15238400 7019312
01:25:41 66487 8192000000 10865403280 11335180288 1846749872 18.396 94 19 38 0 1862273360 10182880 5340608
01:26:53 23074 8192000000 9176712288 9411674112 335259536 3.931 18 7 12 0 339015776 1941280 1814960

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 27-12-2020 01:28:02 to 27-12-2020 01:28:33.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 141 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 27-12-2020 01:28:34 to 27-12-2020 01:28:36.

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          234895
MON$OLDEST_ACTIVE               234896
MON$OLDEST_SNAPSHOT             234896
MON$NEXT_TRANSACTION            234896
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                       2004672
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
:425: 
:426: mscs-test-161.budzdorov.ru    Sun Dec 27 01:27:19 2020
:427:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:428: 
:429: 
:430: mscs-test-161.budzdorov.ru    Sun Dec 27 01:27:19 2020
:431:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:432: 
:433: 
:434: mscs-test-161.budzdorov.ru    Sun Dec 27 01:27:20 2020
:435:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:436: 
--- end of diff output ---

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

27.12.20 01:28:37. 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
2020-12-27 01:28:40 No severe PSQL-related problems occured
27.12.20 01:28:41. End of report.