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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-07 22:27:09
DTS_END                         2021-01-07 22:27:09.4970
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_FROM_CUSTOMER(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/33648
TRN_ID                          243345
ATT_ID                          637
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: 9273.66 19688 1112839
customer order: creation 175.82 370 21098
customer order: refuse 15.25 375 1830
order to supplier: creation 47.64 1290 5717
order to supplier: removal 3.52 92097 422
invoice (draft): creation 47.06 3466 5647
invoice (draft): removal 52.33 733 6279
invoice accept: apply 42.47 18984 5096
invoice accept: cancel 47.46 783 5695
customer reserve: creation 3886.79 190 466415
customer reserve: removal 4651.46 55 558175
realization accept: apply 86.31 195 10357
realization accept: cancel 83.85 117 10062
payment from customer: creation 60.55 131 7266
payment from customer: removal 6.02 71 722
payment to supplier: creation 50.73 143 6088
payment to supplier: removal 3.55 78 426
service: total inventory turnovers 5.17 1195 620
service: total monetary turnovers 6.87 36 824
service: aggregate perf. data 0.80 24073 96
service: refresh index statistics 0.03 249368 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6050
TEST_TIME 2 4584
TEST_TIME 3 3734
TEST_TIME 4 5010
TEST_TIME 5 5694
TEST_TIME 6 5676
TEST_TIME 7 5764
TEST_TIME 8 5707
TEST_TIME 9 5812
TEST_TIME 10 6346
TEST_TIME 11 6657
TEST_TIME 12 7073
TEST_TIME 13 7809
TEST_TIME 14 7734
TEST_TIME 15 7875
TEST_TIME 16 8305
TEST_TIME 17 8242
TEST_TIME 18 8252
TEST_TIME 19 8539
TEST_TIME 20 8644
TEST_TIME 21 8782
TEST_TIME 22 8811
TEST_TIME 23 8815
TEST_TIME 24 8975
TEST_TIME 25 9179
TEST_TIME 26 9239
TEST_TIME 27 9469
TEST_TIME 28 9432
TEST_TIME 29 9731
TEST_TIME 30 9746
TEST_TIME 31 10114
TEST_TIME 32 10173
TEST_TIME 33 10388
TEST_TIME 34 10244
TEST_TIME 35 10221
TEST_TIME 36 9999
TEST_TIME 37 9933
TEST_TIME 38 9869
TEST_TIME 39 9980
TEST_TIME 40 9801
TEST_TIME 41 9807
TEST_TIME 42 9714
TEST_TIME 43 9687
TEST_TIME 44 9826
TEST_TIME 45 9690
TEST_TIME 46 9685
TEST_TIME 47 9601
TEST_TIME 48 9417
TEST_TIME 49 9483
TEST_TIME 50 9487
TEST_TIME 51 9430
TEST_TIME 52 9388
TEST_TIME 53 9404
TEST_TIME 54 9389
TEST_TIME 55 9396
TEST_TIME 56 9345
TEST_TIME 57 9367
TEST_TIME 58 9482
TEST_TIME 59 9602
TEST_TIME 60 9561
TEST_TIME 61 9557
TEST_TIME 62 9631
TEST_TIME 63 9644
TEST_TIME 64 9712
TEST_TIME 65 9859
TEST_TIME 66 9864
TEST_TIME 67 9792
TEST_TIME 68 9718
TEST_TIME 69 9670
TEST_TIME 70 9633
TEST_TIME 71 9568
TEST_TIME 72 9555
TEST_TIME 73 9598
TEST_TIME 74 9532
TEST_TIME 75 9477
TEST_TIME 76 9480
TEST_TIME 77 9480
TEST_TIME 78 9407
TEST_TIME 79 9389
TEST_TIME 80 9369
TEST_TIME 81 9368
TEST_TIME 82 9310
TEST_TIME 83 9364
TEST_TIME 84 9323
TEST_TIME 85 9284
TEST_TIME 86 9423
TEST_TIME 87 9398
TEST_TIME 88 9406
TEST_TIME 89 9389
TEST_TIME 90 9459
TEST_TIME 91 9516
TEST_TIME 92 9502
TEST_TIME 93 9541
TEST_TIME 94 9530
TEST_TIME 95 9475
TEST_TIME 96 9384
TEST_TIME 97 9419
TEST_TIME 98 9352
TEST_TIME 99 9362
TEST_TIME 100 9335
TEST_TIME 101 9339
TEST_TIME 102 9313
TEST_TIME 103 9310
TEST_TIME 104 9325
TEST_TIME 105 9298
TEST_TIME 106 9352
TEST_TIME 107 9385
TEST_TIME 108 9362
TEST_TIME 109 9417
TEST_TIME 110 9414
TEST_TIME 111 9452
TEST_TIME 112 9487
TEST_TIME 113 9477
TEST_TIME 114 9451
TEST_TIME 115 9385
TEST_TIME 116 9410
TEST_TIME 117 9371
TEST_TIME 118 9339
TEST_TIME 119 9349
TEST_TIME 120 9275

Performance per minute, chart


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

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 1545634 1545634 0 0.00 0 32419 7 0 0
doc_list_biud 1545628 1545628 0 0.00 0 31035 25 0 0
sp_add_invoice_to_stock 5253 5096 157 2.98 63 177089 18984 0 157
sp_cancel_adding_invoice 5695 5695 0 0.00 5 66697 784 0 0
sp_cancel_client_order 1830 1830 0 0.00 5 26183 375 0 0
sp_cancel_customer_reserve 558175 558175 0 0.00 1 31041 55 0 0
sp_cancel_pay_from_customer 722 722 0 0.00 2 4690 71 0 0
sp_cancel_pay_to_supplier 426 426 0 0.00 3 1849 78 0 0
sp_cancel_supplier_invoice 6289 6279 10 0.15 2 28002 734 0 10
sp_cancel_supplier_order 422 422 0 0.00 11 858787 92098 0 0
sp_cancel_write_off 10062 10062 0 0.00 1 25478 118 0 0
sp_client_order 21098 21098 0 0.00 3 33162 371 0 0
sp_customer_reserve 466415 466415 0 0.00 0 126430 190 0 0
sp_fill_shopping_cart 32448 32448 0 0.00 1 10873 39 0 0
sp_fill_shopping_cart_clo_res 466410 466410 0 0.00 0 16286 15 0 0
sp_get_clo_for_invoice 5091 5091 0 0.00 0 28621 294 0 0
sp_kill_cost_storno 16905 16905 0 0.00 0 23992 55 0 0
sp_kill_qstorno_ret_qs2qd 1133113 1133113 0 0.00 0 29756 30 0 0
sp_kill_qty_storno 597909 597909 0 0.00 0 31035 65 0 0
sp_lock_selected_doc 21432 21432 0 0.00 0 8507 5 0 0
sp_make_cost_storno 28801 28801 0 0.00 0 31147 62 0 0
sp_multiply_rows_for_pdistr 28799 28799 0 0.00 0 29407 35 0 0
sp_multiply_rows_for_qdistr 21097 21097 0 0.00 0 17332 158 0 0
sp_pay_from_customer 7266 7266 0 0.00 4 29418 132 0 0
sp_pay_to_supplier 6088 6088 0 0.00 4 31157 144 0 0
sp_payment_common 13351 13351 0 0.00 1 18630 31 0 0
sp_qd_handle_on_cancel_clo 1830 1830 0 0.00 0 26175 349 0 0
sp_qd_handle_on_invoice_upd_sts 10785 10785 0 0.00 0 16841 308 0 0
sp_qd_handle_on_reserve_upd_sts 10356 10356 0 0.00 0 18825 62 0 0
sp_reserve_write_off 10357 10357 0 0.00 5 36416 195 0 0
sp_supplier_invoice 5647 5647 0 0.00 7 106600 3467 0 0
sp_supplier_order 5717 5717 0 0.00 5 28969 1290 0 0
srv_aggregate_perf_data 96 96 0 0.00 3198 268811 24073 0 0
srv_fill_mon_cache_memory 170 170 0 0.00 1234 150824 31463 0 0
srv_find_qd_qs_mism 1064529 1064529 0 0.00 0 9509 5 0 0
srv_make_invnt_saldo 620 620 0 0.00 42 67399 1195 0 0
srv_make_money_saldo 824 824 0 0.00 0 5816 36 0 0
srv_recalc_idx_stat 4 4 0 0.00 197593 287364 249369 0 0
t$perf-abend:sp_add_invoice_to_stock 157 157 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5096 5096 0 0.00 0 10046 204 0 0
t$perf-norm:sp_cancel_adding_invoice 428 428 0 0.00 1 9886 166 0 0
t$perf-norm:sp_cancel_client_order 1830 1830 0 0.00 0 5993 17 0 0
t$perf-norm:sp_cancel_customer_reserve 688 688 0 0.00 0 1492 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 722 722 0 0.00 0 5998 22 0 0
t$perf-norm:sp_cancel_pay_to_supplier 426 426 0 0.00 0 1165 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 453 453 0 0.00 0 681 15 0 0
t$perf-norm:sp_cancel_supplier_order 422 422 0 0.00 0 30614 1871 0 0
t$perf-norm:sp_cancel_write_off 1017 1017 0 0.00 0 5988 17 0 0
t$perf-norm:sp_client_order 21098 21098 0 0.00 0 6597 20 0 0
t$perf-norm:sp_customer_reserve 970 970 0 0.00 0 530 4 0 0
t$perf-norm:sp_pay_from_customer 7266 7266 0 0.00 0 8877 12 0 0
t$perf-norm:sp_pay_to_supplier 6088 6088 0 0.00 0 5389 10 0 0
t$perf-norm:sp_reserve_write_off 10357 10357 0 0.00 0 8363 13 0 0
t$perf-norm:sp_supplier_invoice 5647 5647 0 0.00 0 5832 22 0 0
t$perf-norm:sp_supplier_order 5717 5717 0 0.00 0 3508 15 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 388 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 170 170 0 0.00 0 1859 21 0 0
t$perf-norm:srv_make_invnt_saldo 620 620 0 0.00 0 2444 26 0 0
t$perf-norm:srv_make_money_saldo 824 824 0 0.00 0 2336 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10492 10178 314 2.99 0 7727 19 0 314
v_all_customers 37930 37930 0 0.00 0 37 1 0 0
v_all_suppliers 31310 31310 0 0.00 0 18 1 0 0
v_all_wares 42194 42194 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 856 856 0 0.00 0 1285 9 0 0
v_cancel_client_order 3660 3660 0 0.00 0 2239 5 0 0
v_cancel_customer_prepayment 1444 1444 0 0.00 0 1795 7 0 0
v_cancel_customer_reserve 1376 1376 0 0.00 0 3314 9 0 0
v_cancel_payment_to_supplier 852 852 0 0.00 0 1837 6 0 0
v_cancel_supplier_invoice 926 906 20 2.15 0 12987 30 0 20
v_cancel_supplier_order 844 844 0 0.00 0 318 3 0 0
v_cancel_write_off 2034 2034 0 0.00 0 5172 17 0 0
v_max_id_clo_ord 5710 5710 0 0.00 0 567 1 0 0
v_max_id_clo_res 970 970 0 0.00 0 6471 18 0 0
v_max_id_ord_sup 5641 5641 0 0.00 0 10652 6 0 0
v_max_non_paid_invoice 1783 1783 0 0.00 0 3684 5 0 0
v_max_non_paid_realizn 4027 4027 0 0.00 0 2439 4 0 0
v_min_id_clo_ord 5710 5710 0 0.00 0 10780 16 0 0
v_min_id_clo_res 970 970 0 0.00 0 2518 8 0 0
v_min_id_ord_sup 5641 5641 0 0.00 0 6386 10 0 0
v_min_non_paid_invoice 6087 6087 0 0.00 0 18615 23 0 0
v_min_non_paid_realizn 7264 7264 0 0.00 0 18626 21 0 0
v_our_firm 10738 10738 0 0.00 0 14 1 0 0
v_reserve_write_off 20712 20712 0 0.00 0 10573 7 0 0
x_lock_depdocs_on_canc_invoice 11521 11521 0 0.00 0 9146 109 0 0
x_lock_depdocs_on_canc_sup_ord 422 422 0 0.00 0 18629 431 0 0
x_make_qstorno_1000_1200 5717 5717 0 0.00 1 28888 1198 0 0
x_make_qstorno_1200_2000 5647 5647 0 0.00 4 106358 3339 0 0
x_make_qstorno_2100_3300 466415 466415 0 0.00 0 126429 173 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-01-2021 22:29:08 to 07-01-2021 22:29:12.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:13 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:19 17818 8192000000 10252350048 10561884160 861328400 9.513 69 49 98 0 881105696 2344688 17432608
19:57:45 30517 8192000000 10349038864 10669715456 1385873376 14.469 100 83 166 1 1417905952 4694864 27337712
19:58:24 16790 8192000000 10357574896 10683432960 1423780560 14.806 100 83 166 0 1457626528 6219504 27626464
19:58:52 29572 8192000000 10393782528 10720366592 1447678320 15.017 100 90 180 0 1484168496 6877664 29612512
19:59:32 25436 8192000000 10419094976 10748727296 1472806752 15.238 100 91 182 0 1509829344 7596224 29426368
20:00:06 26645 8192000000 10440680544 10770644992 1486706688 15.360 100 94 188 0 1525947136 8794592 30445856
20:00:51 15566 8192000000 10443911952 10785214464 1507265568 15.539 100 84 168 1 1542512432 8773952 26472912
20:01:17 18806 8192000000 10476668448 10820747264 1531679392 15.752 100 81 162 1 1566489312 9433504 25376416
20:01:46 9489 8192000000 10491265248 10842595328 1561653168 16.010 100 73 146 0 1592923104 9479136 21790800
20:02:07 6311 8192000000 10524970528 10879393792 1590447632 16.258 100 79 158 1 1623841024 9813504 23579888
20:02:24 16432 8192000000 10562416832 10919477248 1612588288 16.447 100 70 140 1 1643179184 9648208 20942688
20:02:47 14403 8192000000 10571974880 10929942528 1632690288 16.618 100 76 150 3 1665235984 10064576 22481120
20:03:13 15228 8192000000 10589751056 10954727424 1650447600 16.768 100 73 145 1 1682409504 11157248 20804656
20:03:37 12678 8192000000 10618771504 10979635200 1675995056 16.984 100 81 162 1 1710085296 11147328 22942912
20:03:58 7400 8192000000 10627622544 11000930304 1690068512 17.102 100 70 141 2 1721605760 12025488 19511760
20:04:14 7813 8192000000 10648879312 11019538432 1708079696 17.253 100 80 161 2 1743035968 12531824 22424448
20:04:29 7768 8192000000 10679531232 11052474368 1732512272 17.456 100 83 166 1 1769078272 13136736 23429264
20:04:45 6153 8192000000 10677679168 11057340416 1738547648 17.507 100 71 142 2 1771106880 12322816 20236416
20:04:59 4785 8192000000 10686152368 11066281984 1758426320 17.671 100 81 163 1 1794175648 12380320 23369008
20:05:11 7015 8192000000 10696801040 11079659520 1765844000 17.733 100 74 146 2 1798607472 12155232 20608240
20:05:27 3897 8192000000 10719522000 11099598848 1777209616 17.826 100 79 159 0 1811736208 12357216 22169376
20:05:39 12008 8192000000 10716303344 11102220288 1784874816 17.890 100 70 140 1 1817614080 13408800 19330464
20:05:59 4334 8192000000 10748269888 11131424768 1798913536 18.005 100 80 160 0 1834543120 13530528 22099056
20:06:10 3335 8192000000 10749713536 11140349952 1813347904 18.123 100 79 158 0 1849539680 13693280 22498496
20:06:20 3846 8192000000 10759808640 11143004160 1822952080 18.202 100 83 164 0 1859214400 13142608 23119712
20:06:30 1915 8192000000 10765864432 11155443712 1830560592 18.264 100 80 161 1 1866012128 13206480 22245056
20:06:39 2570 8192000000 10774914096 11158388736 1832058176 18.276 100 82 164 1 1868459744 13169904 23231664
20:06:47 3144 8192000000 10783588400 11168317440 1844693280 18.379 100 91 182 3 1882514544 13057056 24764208
20:06:57 2255 8192000000 10782321360 11168641024 1840601808 18.346 100 79 159 0 1876403232 13163872 22637552
20:07:07 3164 8192000000 10795513872 11183632384 1848850864 18.413 100 83 162 2 1889543728 16374112 24318752
20:07:17 2618 8192000000 10794548064 11180158976 1854323184 18.457 100 89 178 1 1891371456 12376672 24671600
20:07:26 2028 8192000000 10802933616 11193819136 1862300272 18.522 100 87 173 1 1900601568 12938864 25362432
20:07:35 2790 8192000000 10798068672 11189936128 1864782064 18.542 100 92 183 2 1904607664 14225760 25599840
20:07:44 2466 8192000000 10814940880 11202256896 1872515408 18.605 100 94 186 1 1913042864 14566192 25961264
20:07:53 1883 8192000000 10814760176 11203977216 1868918640 18.576 100 89 178 1 1908454960 14283168 25253152
20:08:01 1874 8192000000 10817495344 11208802304 1874669632 18.622 100 90 179 1 1912857392 12511344 25676416
20:08:10 2566 8192000000 10815073728 11208552448 1874596800 18.621 100 89 178 0 1912674672 12883984 25193888
20:08:19 1920 8192000000 10820230176 11208765440 1876712512 18.639 100 90 179 2 1913893520 12523152 24657856
20:08:27 1966 8192000000 10820550752 11210842112 1880691776 18.671 100 94 187 2 1920865712 13973888 26200048
20:08:35 3097 8192000000 10813824336 11215695872 1877645456 18.646 100 68 135 2 1909512736 13551488 18315792
20:08:45 1646 8192000000 10824685440 11219693568 1885778160 18.712 100 91 184 0 1925321024 13567568 25975296
20:08:52 4375 8192000000 10822934896 11222917120 1882722128 18.687 100 70 141 1 1914281504 11781152 19778224
20:09:19 1384 8192000000 10829115504 11223257088 1886352144 18.716 100 80 159 1 1921174704 12525984 22296576
20:09:27 14321 8192000000 10809108256 11222716416 1881287920 18.676 100 52 105 2 1906919904 11134192 14497792
20:09:51 4793 8192000000 10809667616 11219578880 1883481824 18.693 100 57 116 1 1909290080 8833552 16974704
20:10:02 6165 8192000000 10789099872 11214331904 1881170080 18.675 100 35 71 2 1899011296 7706448 10134768
20:10:18 6971 8192000000 10806012784 11223031808 1880576624 18.670 100 28 56 2 1895814256 7899200 7338432
20:10:33 2591 8192000000 10810734032 11227426816 1885165520 18.707 100 49 98 1 1909275888 10304576 13805792
20:10:41 2522 8192000000 10808659520 11222618112 1890852352 18.753 100 52 98 2 1912569216 8530240 13186624
20:10:51 6962 8192000000 10811590800 11229483008 1889044272 18.738 100 47 94 0 1910696752 8212672 13439808
20:11:06 5014 8192000000 10805480128 11231895552 1890922768 18.753 100 34 68 0 1908468992 7854080 9692144
20:11:21 6872 8192000000 10800773104 11228827648 1893021904 18.770 100 43 86 1 1913105600 6970112 13113584
20:11:34 4781 8192000000 10808848496 11232063488 1889634720 18.743 100 26 51 2 1907423040 11063952 6724368
20:11:48 4911 8192000000 10803798544 11228803072 1892170272 18.763 100 38 76 0 1910630080 8088448 10371360
20:11:59 6274 8192000000 10811774608 11235610624 1892572704 18.767 100 30 60 2 1907766320 7262592 7931024
20:12:14 8889 8192000000 10807685936 11232616448 1892208112 18.764 100 28 56 0 1907941024 7754624 7978288
20:12:31 14741 8192000000 10805932224 11233652736 1895226192 18.788 100 28 55 1 1911599680 5933280 10440208
20:12:53 67878 8192000000 10818796944 11247063040 1896834400 18.801 100 23 46 3 1909511536 5801264 6875872
20:14:18 3895 8192000000 10824738496 11255750656 1904647648 18.864 100 28 56 0 1919635536 7274192 7713696
20:14:28 6671 8192000000 10823321520 11254898688 1909049152 18.899 100 45 91 2 1929313808 7482480 12782176
20:14:44 6005 8192000000 10831677872 11258712064 1909223728 18.900 100 32 64 0 1926414848 7191920 9999200
20:14:58 8773 8192000000 10814182656 11253620736 1904133008 18.860 100 19 39 0 1915725376 5534192 6058176
20:15:13 6445 8192000000 10837154944 11261566976 1907131808 18.884 100 27 54 2 1920850224 5337952 8380464
20:15:28 9607 8192000000 10838860192 11267723264 1910013696 18.907 100 22 44 1 1921503424 5256512 6233216
20:15:44 6319 8192000000 10813596752 11251773440 1892900384 18.769 99 26 51 2 1906970528 6005488 8064656
20:15:56 8457 8192000000 10806334064 11245076480 1884813984 18.704 99 28 54 3 1898186352 4986032 8386336
20:16:11 10349 8192000000 10825176080 11257053184 1905734560 18.872 100 19 37 3 1917171040 5492352 5944128
20:16:28 6265 8192000000 10832986992 11268464640 1911193600 18.916 100 36 72 1 1928401824 6813168 10395056
20:16:41 11505 8192000000 10824129360 11261403136 1910846864 18.913 100 23 46 1 1924409232 7314624 6247744
20:17:01 3241 8192000000 10828064784 11252924416 1903799376 18.857 100 45 90 1 1923929600 5853936 14276288
20:17:14 14955 8192000000 10788004048 11218837504 1811064784 18.105 95 25 51 2 1822391600 4603952 6722864
20:17:43 64715 8192000000 10778153376 11185348608 1782112432 17.867 95 37 72 1 1797705488 5057920 10535136
20:18:54 12314 8192000000 10746732320 11169775616 1747539216 17.581 94 27 51 3 1761624224 6340352 7744656
20:19:14 5244 8192000000 10739866880 11155066880 1771354864 17.778 96 38 76 2 1793475104 12116272 10003968
20:19:26 3926 8192000000 10751985984 11169439744 1821847552 18.193 99 41 82 0 1840514192 7495696 11170944
20:19:36 4759 8192000000 10741224112 11147243520 1776045952 17.817 97 38 77 1 1803350192 15589168 11715072
20:19:47 7034 8192000000 10737824848 11166732288 1781901648 17.865 97 26 52 1 1801013872 10718896 8393328
20:20:03 7351 8192000000 10710298784 11110928384 1760839888 17.691 97 27 54 1 1774086576 5962864 7283824
20:20:18 5778 8192000000 10698112064 11119104000 1739733744 17.516 96 27 55 1 1753335904 5509584 8092576
20:20:32 7185 8192000000 10694198192 11101741056 1656009872 16.815 92 22 44 0 1667537792 4830400 6697520
20:20:47 8030 8192000000 10698579264 11109556224 1751411840 17.613 98 24 48 1 1764256624 6402704 6442080
20:21:02 7639 8192000000 10727043424 11135774720 1781519200 17.862 99 32 64 1 1800387072 9462992 9404880
20:21:15 7206 8192000000 10736299280 11154665472 1811812320 18.111 100 20 41 2 1823792144 5922352 6057472
20:21:32 10299 8192000000 10710180272 11132731392 1794447152 17.968 100 22 44 4 1806176448 5187424 6541872
20:21:50 12481 8192000000 10708407264 11128303616 1779218048 17.843 99 22 45 2 1791024928 5377296 6429584
20:22:09 10027 8192000000 10724443328 11142172672 1805285520 18.057 100 25 51 1 1818285056 5366496 7633040
20:22:25 8819 8192000000 10736495952 11153879040 1800624560 18.019 99 36 70 3 1816622576 5885776 10112240
20:22:43 9255 8192000000 10733902240 11155398656 1809060944 18.088 99 31 60 1 1823977056 5838128 9077984
20:23:01 63240 8192000000 10761890224 11169832960 1820978912 18.186 99 47 95 1 1841491920 5420864 15092144
20:24:11 5802 8192000000 10734098480 11164700672 1813912128 18.128 99 29 57 1 1829557296 7207088 8438080
20:24:26 7214 8192000000 10773253184 11179253760 1839430864 18.336 100 38 77 3 1855345632 6283200 9631568
20:24:40 5164 8192000000 10757793264 11183996928 1843436608 18.369 100 28 56 1 1858803760 7493552 7873600
20:24:53 9204 8192000000 10759758784 11189620736 1849557712 18.419 100 37 74 3 1866179376 6740016 9881648
20:25:09 5983 8192000000 10766000880 11193815040 1852608624 18.443 100 28 56 0 1866561040 5893056 8059360
20:25:21 6768 8192000000 10770309760 11190554624 1835554976 18.305 99 31 62 2 1849692848 5185600 8952272
20:25:39 8948 8192000000 10776966560 11200053248 1854112416 18.456 100 23 47 1 1867222112 6423104 6686592
20:25:54 9385 8192000000 10771539136 11201323008 1862496112 18.524 100 24 48 0 1875120112 5917424 6706576
20:26:13 11107 8192000000 10780249552 11211509760 1866345024 18.555 100 24 48 1 1878325616 5306672 6673920
20:26:37 7104 8192000000 10784788096 11213484032 1868144944 18.569 100 18 36 2 1878702992 5597392 4960656
20:26:52 13325 8192000000 10785035216 11217850368 1874438544 18.620 100 16 32 0 1883891024 5302720 4149760
20:27:14 18566 8192000000 10823569520 11243479040 1900051360 18.827 100 40 80 3 1918405456 6431808 11922288
20:27:53 3602 8192000000 10855969072 11266838528 1913229584 18.933 100 59 117 1 1941812064 12245408 16337072
20:28:04 74080 8192000000 10838315120 11271299072 1918167200 18.972 100 35 70 2 1935740496 7696896 9876400
20:29:32 88372 8192000000 10862533872 11293945856 1931837904 19.082 100 33 66 2 1950524400 9128016 9558480
20:31:09 32532 8192000000 10869459680 11305132032 1935706128 19.112 100 44 88 0 1966162864 17750608 12706128
20:31:54 52533 8192000000 10861696928 11315105792 1937990768 19.131 100 17 34 1 1958423168 15422640 5009760
20:32:53 13059 8192000000 10886504624 11318575104 1951163632 19.236 100 40 79 1 1972562624 9700000 11698992
20:33:16 9708 8192000000 10900914000 11326164992 1962581008 19.327 100 51 103 2 1988945872 11949264 14415600
20:33:45 19374 8192000000 10908306256 11336744960 1967421616 19.365 100 54 107 1 1993812560 11164496 15226448
20:34:15 16483 8192000000 10902140624 11331579904 1958881280 19.297 99 51 102 2 1990455664 17221040 14353344
20:34:41 9762 8192000000 10918538448 11347947520 1978050224 19.449 100 50 99 3 2006288240 13311232 14926784
20:35:00 14091 8192000000 10921867696 11354378240 1985015232 19.504 100 52 105 0 2014192288 14199536 14977520
20:35:25 10411 8192000000 10930510688 11359465472 1991247632 19.554 100 71 142 0 2028489440 16556144 20685664
20:35:42 8311 8192000000 10925657776 11362242560 1988588496 19.533 100 46 92 1 2017641520 15766208 13286816
20:36:05 8617 8192000000 10943073584 11372761088 1998887088 19.614 100 67 133 2 2035420912 17183728 19350096
20:36:27 6330 8192000000 10936966128 11364634624 1994555792 19.580 100 62 124 1 2031489344 17954608 18978944
20:36:46 5562 8192000000 10940554448 11370295296 1994926832 19.583 100 60 118 1 2031512576 19030032 17555712
20:36:58 4155 8192000000 10942164848 11371352064 1996602224 19.596 100 62 122 1 2033737408 18656176 18479008
20:37:09 1965 8192000000 10954442128 11375407104 2001950560 19.638 100 71 141 1 2039468240 17420832 20096848
20:37:20 2998 8192000000 10964327488 11379277824 2000296128 19.625 100 73 144 1 2041002304 19090160 21616016
20:37:30 3139 8192000000 10961004032 11380387840 2002528976 19.643 100 73 145 0 2044089312 20138368 21421968
20:37:39 1715 8192000000 10953782448 11366645760 1977725312 19.447 99 73 145 1 2019721184 20863728 21132144
20:37:49 2184 8192000000 10959251104 11378855936 1994514608 19.579 100 72 144 1 2043047680 27580784 20952288
20:37:58 5368 8192000000 10953145728 11377598464 1995907648 19.590 100 67 135 0 2039470144 23657712 19904784
20:38:18 8367 8192000000 10949143952 11372945408 1992045664 19.560 100 57 113 0 2032722192 23520960 17155568
20:38:34 4703 8192000000 10949852800 11378028544 1995679744 19.589 100 63 124 2 2039002528 25119536 18203248
20:38:45 7219 8192000000 10939116896 11357331456 1979282320 19.459 99 79 157 2 2030965520 26290240 25392960
20:39:02 10885 8192000000 10938144256 11376848896 1989620368 19.541 100 54 108 2 2030062816 23878672 16563776
20:39:37 9735 8192000000 10949920992 11383267328 2000587600 19.627 100 63 125 0 2039947760 20597504 18762656
20:40:00 6734 8192000000 10939548864 11377164288 1993485424 19.571 100 60 117 2 2033193456 22256048 17451984
20:40:16 4213 8192000000 10947332656 11358605312 1977665008 19.446 100 78 157 0 2022605280 20643424 24296848
20:40:28 3548 8192000000 10934784304 11358941184 1975426352 19.428 100 68 134 0 2018027616 22023888 20577376
20:40:40 2795 8192000000 10929668928 11350261760 1951767168 19.241 98 91 178 2 1996844048 17873408 27203472
20:40:49 2036 8192000000 10932413264 11347423232 1971302608 19.396 100 90 177 2 2016056272 19634224 25119440
20:40:58 4470 8192000000 10940149520 11365236736 1983485680 19.492 100 71 142 0 2023325680 18891680 20948320
20:41:16 2230 8192000000 10939334560 11359604736 1979948944 19.464 100 77 152 1 2020781360 18989056 21843360
20:41:25 1991 8192000000 10944648288 11356532736 1966700944 19.359 99 91 183 2 2016732768 23787040 26244784
20:41:36 10150 8192000000 10939926976 11360423936 1965782704 19.352 99 77 152 3 2012757904 24168000 22807200
20:41:52 14233 8192000000 10951747088 11378208768 1983470912 19.492 100 60 120 1 2028795120 27454544 17869664
20:42:14 8676 8192000000 10939547152 11370184704 1980885024 19.472 100 60 120 0 2027513184 28635728 17992432
20:42:31 8614 8192000000 10925853472 11359068160 1961574272 19.319 99 60 120 1 2008592080 28164784 18853024
20:42:46 1559 8192000000 10910231760 11331178496 1948132192 19.212 99 69 139 2 1995175792 27557232 19486368
20:42:55 7645 8192000000 10921149808 11356078080 1968171136 19.371 100 64 128 0 2016944560 29409152 19364272
20:43:10 9670 8192000000 10911987280 11348197376 1944937520 19.186 99 54 108 1 1990136880 28827120 16372240
20:43:27 6008 8192000000 10903013808 11332001792 1939778896 19.145 99 54 104 0 1983904144 28266976 15858272
20:43:52 7678 8192000000 10882382304 11313594368 1895228128 18.788 97 45 90 1 1933797456 25675712 12893616
20:44:08 2516 8192000000 10881580128 11304230912 1905819904 18.873 98 53 103 3 1942572400 21535200 15217296
20:44:23 1367 8192000000 10884117328 11298783232 1910317024 18.909 99 67 135 0 1952610288 22569232 19724032
20:44:33 2196 8192000000 10857814416 11275415552 1886623552 18.719 99 61 122 0 1928287168 23611584 18052032
20:44:44 1312 8192000000 10902319264 11306643456 1925271008 19.029 100 82 162 2 1974328768 25543440 23514320
20:44:52 1934 8192000000 10889182128 11290980352 1912057872 18.923 99 80 160 1 1962084992 27003840 23023280
20:45:02 4289 8192000000 10883471408 11298893824 1909279056 18.901 99 77 152 0 1958722448 27768656 21674736
20:45:19 4726 8192000000 10902825808 11310350336 1928708704 19.057 100 71 140 1 1976253712 27104288 20440720
20:45:32 7614 8192000000 10902305616 11319627776 1935996432 19.115 100 68 134 1 1986015280 30228272 19790576
20:45:46 4782 8192000000 10916437952 11332083712 1946849792 19.201 100 73 147 0 1999292240 30703216 21739232
20:46:02 3533 8192000000 10915021280 11323535360 1939464096 19.142 100 90 180 1 2000032656 32221872 28346688
20:46:12 4298 8192000000 10900128256 11310997504 1921351248 18.998 99 78 156 2 1982247424 37013808 23882368
20:46:24 4478 8192000000 10923284944 11329146880 1942086160 19.163 100 78 153 0 1999554800 34648544 22820096
20:46:34 7469 8192000000 10893888880 11317448704 1926644144 19.040 99 65 130 0 1981410464 34629808 20136512
20:46:49 4390 8192000000 10891429856 11313528832 1915668048 18.952 99 58 117 1 1965756256 32066816 18021392
20:47:04 2176 8192000000 10888354816 11305717760 1924811920 19.025 100 70 139 1 1977051952 31358080 20881952
20:47:16 4185 8192000000 10896125008 11304316928 1917057952 18.963 100 71 140 0 1971780768 33251920 21470896
20:47:31 7341 8192000000 10896843440 11318165504 1931519744 19.079 100 73 146 1 1986337520 33343584 21474192
20:47:51 3677 8192000000 10902924208 11319296000 1934664592 19.104 100 73 145 2 1984394544 27056752 22673200
20:48:03 2529 8192000000 10921045536 11325804544 1943804016 19.177 100 77 153 2 1995866560 28728048 23334496
20:48:12 2116 8192000000 10925542880 11332018176 1949086704 19.219 100 84 164 1 2004180480 29885376 25208400
20:48:22 3354 8192000000 10909721712 11319848960 1928601136 19.056 99 83 165 2 1985196800 30568064 26027600
20:48:34 2659 8192000000 10910536544 11329548288 1930960480 19.075 99 72 145 1 1982160624 29060688 22139456
20:48:45 6315 8192000000 10879838032 11312406528 1927150608 19.044 100 49 96 2 1969595872 27318304 15126960
20:48:57 9215 8192000000 10909345392 11333283840 1944282576 19.181 100 59 116 2 1992956048 30127088 18546384
20:49:16 1234 8192000000 10901211424 11320549376 1927049872 19.043 99 63 125 1 1980478192 33107472 20320848
20:49:23 1481 8192000000 10931553120 11338764288 1949663664 19.224 100 93 185 2 2011155296 32987520 28504112
20:49:32 1795 8192000000 10907240944 11321864192 1931598976 19.080 99 69 137 4 1988284096 35157792 21527328
20:49:44 3380 8192000000 10912235872 11340025856 1945233504 19.188 100 54 108 0 1996118704 34423760 16461440
20:50:11 21507 8192000000 10899093424 11343781888 1928306912 19.053 99 35 70 1 1975174624 35312560 11555152
20:50:59 7447 8192000000 10917637088 11351638016 1954656768 19.264 100 58 114 2 2005603920 32871888 18075264
20:51:13 3824 8192000000 10932904800 11344515072 1953116160 19.251 100 70 136 2 2007080912 33060112 20904640
20:51:24 2092 8192000000 10928794480 11347140608 1954510496 19.262 100 77 151 2 2009273072 31233376 23529200
20:51:33 9087 8192000000 10912784256 11353235456 1953051968 19.251 100 42 84 1 2002112816 35776896 13283952
20:51:53 6567 8192000000 10903993248 11338895360 1939658288 19.144 99 39 78 0 1988883664 36722640 12502736
20:52:08 6868 8192000000 10906003632 11343814656 1943530176 19.175 100 44 88 2 1991600352 33663856 14406320
20:52:32 7334 8192000000 10900447792 11339079680 1928551200 19.055 99 30 59 1 1973715488 35450928 9713360
20:52:52 16496 8192000000 10896205584 11335086080 1940634048 19.152 100 34 68 1 1989017184 37165840 11217296
20:53:15 11124 8192000000 10898519504 11342712832 1943428960 19.174 100 24 47 1 1984308688 33111232 7768496
20:53:46 19433 8192000000 10898050848 11348955136 1942137536 19.164 100 27 54 0 1984579120 33686592 8754992
20:54:23 11073 8192000000 10904477120 11345911808 1947299536 19.205 100 30 60 0 1989711984 32330528 10081920
20:54:41 20460 8192000000 10913180960 11362430976 1958079952 19.291 100 35 70 3 2003074144 33331408 11662784
20:55:12 26652 8192000000 10904774528 11353878528 1920518512 18.991 98 27 54 0 1964512176 35416032 8577632
20:55:56 29644 8192000000 10888066016 11348819968 1944646144 19.184 100 16 32 1 1985479488 35399552 5433792
20:56:50 38777 8192000000 10912283568 11363573760 1919648800 18.984 99 18 36 1 1964705616 38649664 6407152
20:57:53 26027 8192000000 10890812560 11349794816 1909849952 18.905 98 15 28 1 1961871936 46547200 5474784
20:58:26 52480 8192000000 10896892528 11342778368 1941371760 19.158 100 12 24 0 1968517616 23840320 3305536
20:59:28 31184 8192000000 10884169792 11333103616 1915760352 18.953 98 25 51 0 1943421088 20095712 7565024
21:00:13 12743 8192000000 10901150320 11321950208 1931865792 19.082 99 38 72 0 1951071616 8895600 10310224
21:00:33 38421 8192000000 10883943984 11335487488 1933214032 19.093 99 15 30 0 1946402096 9648432 3539632
21:01:19 66352 8192000000 10886640288 11342733312 1959413024 19.301 100 26 52 1 1979541072 12392752 7735296
21:02:32 116515 8192000000 10903753232 11359318016 1970949232 19.393 100 41 81 0 1993958128 11455520 11553376
21:04:43 69135 8192000000 10923111264 11384922112 1985515248 19.508 100 22 44 0 2003696640 11604160 6577232
21:06:03 66161 8192000000 10914570400 11391578112 1968268048 19.372 99 29 59 0 1991470336 15163472 8038816
21:07:22 31418 8192000000 10919051040 11390468096 1988139648 19.529 100 25 50 0 2010642480 15238880 7263952
21:08:00 23169 8192000000 10906752736 11384033280 1968608464 19.374 99 15 30 2 1989564320 16262592 4693264
21:08:30 7195 8192000000 10927216944 11382116352 1984339520 19.499 100 30 61 1 2009897200 17190064 8367616
21:08:43 5039 8192000000 10949030528 11397308416 1998357664 19.610 100 55 110 0 2030535616 16303440 15874512
21:08:56 66330 8192000000 10940421376 11395133440 1977322880 19.443 99 20 40 0 1990746736 7906000 5517856
21:10:09 52485 8192000000 10947548000 11404996608 2004987088 19.662 100 26 52 0 2026998896 13489536 8522272
21:11:16 33442 8192000000 10933142880 11413327872 2004091056 19.655 100 28 58 3 2023943232 11951456 7900720
21:12:15 39418 8192000000 10931353488 11400359936 1990340192 19.546 99 21 42 1 2006201504 10064624 5796688
21:13:05 150823 8192000000 10934655248 11413098496 1997958928 19.607 99 16 32 1 2012400800 9966048 4475824
21:15:55 81926 8192000000 10922706928 11415887872 1987704384 19.526 99 24 48 0 2011669616 16327872 7637360
21:17:32 9615 8192000000 10918662512 11415814144 1999595664 19.620 100 14 28 0 2015863136 12407216 3860256
21:17:48 27525 8192000000 10898552976 11372015616 1940061728 19.147 97 22 43 2 1953714256 7269216 6383312
21:18:22 52813 8192000000 10916535456 11390758912 1975113248 19.426 99 27 54 1 1991503888 9053120 7337520
21:19:41 72497 8192000000 10914529760 11411083264 1997171696 19.600 100 13 26 0 2013841648 13001296 3668656
21:21:00 55138 8192000000 10918510096 11401637888 1987187872 19.522 99 20 40 0 2006009344 13048352 5773120
21:22:06 35765 8192000000 10912240896 11385794560 1968501856 19.374 98 22 44 3 1990569856 15361968 6706032
21:22:49 64567 8192000000 10938422512 11409727488 1986079504 19.513 99 25 50 2 2010892752 17100096 7713152
21:24:13 47392 8192000000 10923349296 11402813440 1972205024 19.403 98 21 42 1 1994048144 15901312 5941808
21:25:08 61531 8192000000 10917346672 11382554624 1936852416 19.122 97 24 46 1 1964896608 20579584 7464608
21:26:16 87895 8192000000 10921102720 11381108736 1894812240 18.785 95 18 34 1 1909375056 10058096 4504720
21:27:57 72705 8192000000 10909003488 11385315328 1968557424 19.374 99 27 54 5 1990367632 13775808 8034400
21:29:16 46058 8192000000 10898432384 11373084672 1914964336 18.946 96 12 24 1 1931873712 14076896 2832480
21:30:23 45111 8192000000 10883924352 11360796672 1878086992 18.650 95 8 16 0 1895859920 15825008 1947920
21:31:14 51168 8192000000 10895033760 11359617024 1901648416 18.840 96 18 35 0 1918257120 11842448 4766256
21:32:11 56649 8192000000 10876320560 11362697216 1883436624 18.693 96 11 22 0 1902221888 15389664 3395600
21:33:14 73170 8192000000 10839416400 11299254272 1775922128 17.816 91 7 14 0 1786171216 8442432 1806656
21:34:34 13486 8192000000 10882784000 11315081216 1901244448 18.836 98 46 92 0 1921980032 7464560 13271024
21:34:54 7539 8192000000 10893144112 11321847808 1936946736 19.122 100 68 134 4 1965057360 8556624 19554000
21:35:10 19793 8192000000 10902119216 11334955008 1950447040 19.230 100 58 115 1 1978916448 12468832 16000576
21:35:39 75508 8192000000 10873280928 11322785792 1892877200 18.769 97 36 72 1 1913951664 10619008 10455456
21:37:12 79803 8192000000 10895401776 11343208448 1909894944 18.906 98 28 56 1 1928888000 11805024 7188032
21:38:38 49861 8192000000 10863470352 11332407296 1916731632 18.961 98 20 40 1 1938084576 16157136 5195808
21:39:42 59000 8192000000 10816274304 11294674944 1858097840 18.488 96 11 23 2 1876485200 15388128 2999232
21:40:55 47620 8192000000 10867526048 11321712640 1913847824 18.938 99 11 22 0 1927784352 10960176 2976352
21:41:54 53279 8192000000 10857410720 11316105216 1913406928 18.934 98 23 46 2 1928514784 8619280 6488576
21:42:56 84271 8192000000 10840129728 11313909760 1902703504 18.848 98 9 18 0 1916223776 10635472 2884800
21:44:28 100720 8192000000 10843007152 11311005696 1886394752 18.717 97 11 21 0 1899856960 10260896 3201312
21:46:36 61000 8192000000 10864389456 11327356928 1921680976 19.000 99 24 48 0 1938223504 9806544 6735984
21:47:44 59328 8192000000 10864915120 11345326080 1946379152 19.198 100 18 36 0 1962203728 10858208 4966368
21:48:54 51664 8192000000 10853597744 11320147968 1870830464 18.591 96 17 34 0 1883210560 8220320 4159776
21:49:54 32062 8192000000 10857477904 11317657600 1915422416 18.950 99 32 64 1 1934365040 10241168 8701456
21:50:33 85316 8192000000 10835609744 11289903104 1861872448 18.518 96 20 40 0 1879677360 12276800 5528112
21:52:04 51095 8192000000 10859277968 11330142208 1900195552 18.828 98 31 63 3 1923752304 14524336 9032416
21:53:01 65924 8192000000 10860715840 11332333568 1917426336 18.966 99 14 27 1 1931522960 10341856 3754768
21:54:59 31980 8192000000 10866191888 11331584000 1937514016 19.127 100 38 76 4 1957484352 9036480 10933856
21:55:52 17626 8192000000 10885249568 11337523200 1923007552 19.011 99 38 76 5 1948268144 15081584 10179008
21:56:21 33876 8192000000 10904991824 11352981504 1949559184 19.223 100 46 92 0 1974485968 12689168 12237616
21:57:01 27534 8192000000 10898426896 11361198080 1960192800 19.308 100 39 78 0 1985869744 14803888 10873056
21:57:44 81732 8192000000 10889604640 11369021440 1946748336 19.201 99 13 24 2 1961624000 12158928 2716736
21:59:12 64280 8192000000 10901237360 11365900288 1954102016 19.259 99 20 38 0 1968101472 9192832 4806624
22:00:23 121782 8192000000 10935395424 11385815040 1947283536 19.205 98 20 38 0 1963143136 10906352 4953248
22:02:42 124146 8192000000 10910834096 11389837312 1954535264 19.263 98 15 30 1 1981437392 22274544 4627584
22:04:52 56639 8192000000 10901130224 11387097088 1960897600 19.313 99 3 6 0 1975613280 13831632 884048
22:05:56 49500 8192000000 10884153056 11363766272 1922073088 19.003 97 12 24 0 1937065312 11279008 3713216
22:06:51 39489 8192000000 10887723840 11357024256 1939407216 19.142 98 19 37 1 1953812544 9181680 5223648
22:07:37 55545 8192000000 10916261488 11368124416 1944314464 19.181 98 19 38 1 1958754112 8229296 6210352
22:08:39 55819 8192000000 10907662224 11369361408 1940425808 19.150 98 25 50 2 1957015376 9467120 7122448
22:09:41 69498 8192000000 10905704480 11369185280 1955703968 19.272 99 16 33 1 1970608336 10191952 4712416
22:10:57 43951 8192000000 10896095840 11367260160 1939955088 19.146 98 21 42 0 1956348256 10191440 6201728
22:11:59 64121 8192000000 10925821248 11390201856 1952959584 19.250 98 26 52 0 1973413344 12787392 7666368
22:13:42 92535 8192000000 10905430768 11369398272 1883631264 18.694 95 14 28 0 1903308640 15543904 4133472
22:15:26 43435 8192000000 10910543280 11372630016 1937164240 19.124 98 34 70 0 1957504384 10657952 9682192
22:16:19 66099 8192000000 10894444528 11362430976 1921394064 18.998 98 17 34 0 1938923440 12990272 4539104
22:17:40 38894 8192000000 10889799200 11345240064 1897815728 18.809 97 22 43 3 1919378832 15239488 6323616
22:18:28 125596 8192000000 10900550912 11365601280 1860517680 18.507 95 13 26 0 1882818976 19358400 2942896
22:20:42 40394 8192000000 10903550832 11350880256 1885934384 18.713 96 17 34 0 1898171280 7621840 4615056
22:21:32 97491 8192000000 10880773296 11338096640 1897401520 18.805 97 29 58 0 1916929552 11540544 7987488
22:23:24 93577 8192000000 10876020896 11349196800 1926714352 19.041 99 20 40 1 1942909472 10383248 5811872
22:25:14 6864 8192000000 10879457632 11355418624 1951941744 19.242 100 13 26 0 1966895808 11700128 3253936
22:25:42 40598 8192000000 10871651968 11350175744 1933832768 19.098 99 21 41 0 1948933104 7655808 7444528
22:26:34 37542 8192000000 10706806256 11173634048 1768189504 17.752 91 5 10 0 1777175520 8058720 927296

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 07-01-2021 22:29:14 to 07-01-2021 22:29:46.

Exceptions occured during test was in run

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

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

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          243344
MON$OLDEST_ACTIVE               243509
MON$OLDEST_SNAPSHOT             243509
MON$NEXT_TRANSACTION            243509
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                       2050848
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:528: 
:529: mscs-test-161.budzdorov.ru    Thu Jan  7 22:27:16 2021
:530:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:531: 
:532: 
:533: mscs-test-161.budzdorov.ru    Thu Jan  7 22:27:17 2021
:534:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:535: 
--- end of diff output ---

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

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