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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17160148 kB
MemAvailable 31186832 kB
Buffers 0 kB
Cached 14565556 kB
SwapCached 4088 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-02-17 01:27:15
DTS_END                         2021-02-17 01:27:15.6720
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_PAY_TO_SUPPLIER(18:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/56514
TRN_ID                          230682
ATT_ID                          662
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: 9192.11 26043 1103053
customer order: creation 161.98 380 19438
customer order: refuse 13.44 315 1613
order to supplier: creation 43.98 1339 5278
order to supplier: removal 3.51 100621 421
invoice (draft): creation 43.21 3560 5185
invoice (draft): removal 54.65 814 6558
invoice accept: apply 39.47 19455 4736
invoice accept: cancel 49.60 798 5952
customer reserve: creation 3681.95 191 441834
customer reserve: removal 4816.23 57 577948
realization accept: apply 79.54 215 9545
realization accept: cancel 80.37 112 9644
payment from customer: creation 56.51 121 6781
payment from customer: removal 5.25 80 630
payment to supplier: creation 47.40 125 5688
payment to supplier: removal 3.48 90 418
service: total inventory turnovers 4.38 1225 525
service: total monetary turnovers 6.32 44 758
service: aggregate perf. data 0.81 20353 97
service: refresh index statistics 0.03 370974 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-02-2021 01:28:47 to 17-02-2021 01:28:49.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4567
TEST_TIME 2 3558
TEST_TIME 3 4796
TEST_TIME 4 5081
TEST_TIME 5 5615
TEST_TIME 6 5215
TEST_TIME 7 5320
TEST_TIME 8 5639
TEST_TIME 9 6297
TEST_TIME 10 6257
TEST_TIME 11 6438
TEST_TIME 12 6767
TEST_TIME 13 6833
TEST_TIME 14 6970
TEST_TIME 15 7233
TEST_TIME 16 7410
TEST_TIME 17 7639
TEST_TIME 18 8015
TEST_TIME 19 8740
TEST_TIME 20 9015
TEST_TIME 21 9183
TEST_TIME 22 8913
TEST_TIME 23 8774
TEST_TIME 24 8825
TEST_TIME 25 8875
TEST_TIME 26 9188
TEST_TIME 27 9837
TEST_TIME 28 10893
TEST_TIME 29 10940
TEST_TIME 30 10755
TEST_TIME 31 10785
TEST_TIME 32 10593
TEST_TIME 33 10550
TEST_TIME 34 10608
TEST_TIME 35 10462
TEST_TIME 36 10285
TEST_TIME 37 10111
TEST_TIME 38 10151
TEST_TIME 39 10120
TEST_TIME 40 10027
TEST_TIME 41 9981
TEST_TIME 42 10024
TEST_TIME 43 10013
TEST_TIME 44 9902
TEST_TIME 45 9859
TEST_TIME 46 9696
TEST_TIME 47 9597
TEST_TIME 48 9582
TEST_TIME 49 9574
TEST_TIME 50 9841
TEST_TIME 51 9929
TEST_TIME 52 9909
TEST_TIME 53 9945
TEST_TIME 54 9872
TEST_TIME 55 9860
TEST_TIME 56 9924
TEST_TIME 57 9881
TEST_TIME 58 9873
TEST_TIME 59 9873
TEST_TIME 60 9865
TEST_TIME 61 9897
TEST_TIME 62 9891
TEST_TIME 63 9864
TEST_TIME 64 9722
TEST_TIME 65 9628
TEST_TIME 66 9678
TEST_TIME 67 9606
TEST_TIME 68 9508
TEST_TIME 69 9493
TEST_TIME 70 9520
TEST_TIME 71 9464
TEST_TIME 72 9450
TEST_TIME 73 9419
TEST_TIME 74 9467
TEST_TIME 75 9481
TEST_TIME 76 9426
TEST_TIME 77 9465
TEST_TIME 78 9493
TEST_TIME 79 9551
TEST_TIME 80 9530
TEST_TIME 81 9502
TEST_TIME 82 9546
TEST_TIME 83 9573
TEST_TIME 84 9643
TEST_TIME 85 9612
TEST_TIME 86 9515
TEST_TIME 87 9535
TEST_TIME 88 9497
TEST_TIME 89 9470
TEST_TIME 90 9481
TEST_TIME 91 9501
TEST_TIME 92 9452
TEST_TIME 93 9409
TEST_TIME 94 9393
TEST_TIME 95 9375
TEST_TIME 96 9438
TEST_TIME 97 9434
TEST_TIME 98 9391
TEST_TIME 99 9400
TEST_TIME 100 9420
TEST_TIME 101 9438
TEST_TIME 102 9482
TEST_TIME 103 9454
TEST_TIME 104 9411
TEST_TIME 105 9514
TEST_TIME 106 9504
TEST_TIME 107 9486
TEST_TIME 108 9459
TEST_TIME 109 9486
TEST_TIME 110 9414
TEST_TIME 111 9407
TEST_TIME 112 9368
TEST_TIME 113 9328
TEST_TIME 114 9313
TEST_TIME 115 9288
TEST_TIME 116 9239
TEST_TIME 117 9222
TEST_TIME 118 9226
TEST_TIME 119 9267
TEST_TIME 120 9197

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 17-02-2021 01:28:50 to 17-02-2021 01:28:54.

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 1510855 1510855 0 0.00 0 21266 6 0 0
doc_list_biud 1510855 1510855 0 0.00 0 38997 28 0 0
sp_add_invoice_to_stock 4851 4736 115 2.37 40 189543 19455 0 115
sp_cancel_adding_invoice 5952 5952 0 0.00 4 61909 799 0 0
sp_cancel_client_order 1613 1613 0 0.00 4 8773 315 0 0
sp_cancel_customer_reserve 577948 577948 0 0.00 1 39000 57 0 0
sp_cancel_pay_from_customer 630 630 0 0.00 3 6434 80 0 0
sp_cancel_pay_to_supplier 418 418 0 0.00 3 7062 90 0 0
sp_cancel_supplier_invoice 6563 6558 5 0.07 1 16851 814 0 5
sp_cancel_supplier_order 421 421 0 0.00 6 886702 100621 0 0
sp_cancel_write_off 9644 9644 0 0.00 1 21268 112 0 0
sp_client_order 19438 19438 0 0.00 4 69771 381 0 0
sp_customer_reserve 441834 441834 0 0.00 0 69771 191 0 0
sp_fill_shopping_cart 29894 29894 0 0.00 1 22687 39 0 0
sp_fill_shopping_cart_clo_res 441823 441823 0 0.00 0 32254 13 0 0
sp_get_clo_for_invoice 4725 4725 0 0.00 0 36620 316 0 0
sp_kill_cost_storno 16644 16644 0 0.00 0 16931 56 0 0
sp_kill_qstorno_ret_qs2qd 1172519 1172519 0 0.00 0 38993 31 0 0
sp_kill_qty_storno 616404 616404 0 0.00 0 38997 68 0 0
sp_lock_selected_doc 19818 19818 0 0.00 0 7549 7 0 0
sp_make_cost_storno 26737 26737 0 0.00 0 16487 52 0 0
sp_multiply_rows_for_pdistr 26737 26737 0 0.00 0 7941 30 0 0
sp_multiply_rows_for_qdistr 19438 19438 0 0.00 0 24370 158 0 0
sp_pay_from_customer 6781 6781 0 0.00 4 14933 122 0 0
sp_pay_to_supplier 5688 5688 0 0.00 5 14963 126 0 0
sp_payment_common 12469 12469 0 0.00 1 11056 27 0 0
sp_qd_handle_on_cancel_clo 1613 1613 0 0.00 0 8765 283 0 0
sp_qd_handle_on_invoice_upd_sts 10675 10675 0 0.00 0 15302 330 0 0
sp_qd_handle_on_reserve_upd_sts 9545 9545 0 0.00 0 26366 82 0 0
sp_reserve_write_off 9545 9545 0 0.00 6 26385 215 0 0
sp_supplier_invoice 5185 5185 0 0.00 6 86152 3560 0 0
sp_supplier_order 5278 5278 0 0.00 5 58934 1339 0 0
srv_aggregate_perf_data 97 97 0 0.00 2670 321877 20354 0 0
srv_fill_mon_cache_memory 157 157 0 0.00 1215 157194 33988 0 0
srv_find_qd_qs_mism 1056877 1056877 0 0.00 0 21145 5 0 0
srv_make_invnt_saldo 525 525 0 0.00 20 49579 1225 0 0
srv_make_money_saldo 758 758 0 0.00 1 14281 45 0 0
srv_recalc_idx_stat 4 4 0 0.00 219021 522136 370974 0 0
t$perf-abend:sp_add_invoice_to_stock 115 115 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4736 4736 0 0.00 0 16371 183 0 0
t$perf-norm:sp_cancel_adding_invoice 399 399 0 0.00 0 5987 96 0 0
t$perf-norm:sp_cancel_client_order 1613 1613 0 0.00 0 4121 15 0 0
t$perf-norm:sp_cancel_customer_reserve 700 700 0 0.00 0 3047 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 630 630 0 0.00 0 3824 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 418 418 0 0.00 0 2341 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 402 402 0 0.00 0 10787 42 0 0
t$perf-norm:sp_cancel_supplier_order 421 421 0 0.00 0 20992 1876 0 0
t$perf-norm:sp_cancel_write_off 967 967 0 0.00 0 1406 8 0 0
t$perf-norm:sp_client_order 19438 19438 0 0.00 0 10574 19 0 0
t$perf-norm:sp_customer_reserve 1017 1017 0 0.00 0 8360 31 0 0
t$perf-norm:sp_pay_from_customer 6781 6781 0 0.00 0 10955 13 0 0
t$perf-norm:sp_pay_to_supplier 5688 5688 0 0.00 0 10803 16 0 0
t$perf-norm:sp_reserve_write_off 9545 9545 0 0.00 0 10861 18 0 0
t$perf-norm:sp_supplier_invoice 5185 5185 0 0.00 0 8299 22 0 0
t$perf-norm:sp_supplier_order 5278 5278 0 0.00 0 5716 16 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 441 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 5879 46 0 0
t$perf-norm:srv_make_invnt_saldo 525 525 0 0.00 0 1464 26 0 0
t$perf-norm:srv_make_money_saldo 758 758 0 0.00 0 1070 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 9 4 0 0
v_add_invoice_to_stock 9676 9446 230 2.37 0 6617 23 0 230
v_all_customers 35368 35368 0 0.00 0 15 1 0 0
v_all_suppliers 29408 29408 0 0.00 0 27 1 0 0
v_all_wares 38876 38876 0 0.00 0 24 1 0 0
v_cancel_adding_invoice 798 798 0 0.00 0 2004 8 0 0
v_cancel_client_order 3226 3226 0 0.00 0 2435 7 0 0
v_cancel_customer_prepayment 1260 1260 0 0.00 0 1062 5 0 0
v_cancel_customer_reserve 1400 1400 0 0.00 0 6773 16 0 0
v_cancel_payment_to_supplier 836 836 0 0.00 0 1796 11 0 0
v_cancel_supplier_invoice 814 804 10 1.22 0 4430 18 0 10
v_cancel_supplier_order 842 842 0 0.00 0 3601 12 0 0
v_cancel_write_off 1934 1934 0 0.00 0 3006 21 0 0
v_max_id_clo_ord 5278 5278 0 0.00 0 4539 3 0 0
v_max_id_clo_res 1017 1017 0 0.00 0 2670 15 0 0
v_max_id_ord_sup 5178 5178 0 0.00 0 6943 5 0 0
v_max_non_paid_invoice 1440 1440 0 0.00 0 5613 8 0 0
v_max_non_paid_realizn 3640 3640 0 0.00 0 2845 5 0 0
v_min_id_clo_ord 5278 5278 0 0.00 0 2385 5 0 0
v_min_id_clo_res 1017 1017 0 0.00 0 7297 13 0 0
v_min_id_ord_sup 5178 5178 0 0.00 0 4090 4 0 0
v_min_non_paid_invoice 5688 5688 0 0.00 0 11019 18 0 0
v_min_non_paid_realizn 6781 6781 0 0.00 0 6866 15 0 0
v_our_firm 9790 9790 0 0.00 0 16 1 0 0
v_reserve_write_off 19090 19090 0 0.00 0 6911 8 0 0
x_lock_depdocs_on_canc_invoice 12108 12108 0 0.00 0 20371 121 0 0
x_lock_depdocs_on_canc_sup_ord 421 421 0 0.00 0 9189 328 0 0
x_make_qstorno_1000_1200 5278 5278 0 0.00 2 58927 1251 0 0
x_make_qstorno_1200_2000 5185 5185 0 0.00 3 86114 3423 0 0
x_make_qstorno_2100_3300 441834 441834 0 0.00 0 69770 176 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-02-2021 01:28:55 to 17-02-2021 01:28:59.

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:19 12 8192000000 8804547376 8816721920 8751472 0.106 3 1 2 0 8872176 58144 62560
22:57:25 13382 8192000000 10174856432 10470318080 749092720 8.378 61 45 92 0 766869232 2149264 15627248
22:57:46 16414 8192000000 10286548624 10594684928 1332930800 13.994 100 83 167 0 1365280176 4088208 28261168
22:58:15 29903 8192000000 10342670496 10659581952 1397957536 14.577 100 88 176 0 1432725600 5875456 28892608
22:58:53 10522 8192000000 10367993664 10687262720 1420302896 14.775 100 89 178 1 1456030608 6580624 29147088
22:59:24 17946 8192000000 10389474976 10715283456 1445687936 15.000 100 86 172 0 1481960560 7924080 28348544
22:59:52 8178 8192000000 10404850208 10733240320 1458082608 15.109 100 84 168 0 1493195440 7905664 27207168
23:00:08 26189 8192000000 10420632080 10751221760 1475896432 15.265 100 87 174 0 1513349760 8747536 28705792
23:00:44 21088 8192000000 10446051088 10779217920 1488858624 15.379 100 86 172 0 1526026208 8985904 28181680
23:01:15 18654 8192000000 10459148880 10799521792 1519100016 15.642 100 81 163 0 1554190064 9639664 25450384
23:01:57 13588 8192000000 10503540848 10848575488 1551744880 15.925 100 78 156 0 1586328032 10445040 24138112
23:02:22 16148 8192000000 10541243200 10894532608 1590990192 16.262 100 74 148 0 1624278768 10721744 22566832
23:02:46 10306 8192000000 10558878912 10919030784 1623079776 16.536 100 77 154 1 1656776624 11244784 22452064
23:03:05 7774 8192000000 10577310448 10936987648 1636340080 16.649 100 72 144 1 1669200176 11430816 21429280
23:03:22 8061 8192000000 10597880400 10958807040 1652929696 16.789 100 75 151 0 1687513520 11919312 22664512
23:03:43 9599 8192000000 10614636720 10978410496 1675438288 16.979 100 79 159 1 1710789216 12255184 23095744
23:04:00 9952 8192000000 10624983616 10994147328 1684730720 17.057 100 80 158 0 1720590960 12887072 22973168
23:04:21 7407 8192000000 10645610224 11016216576 1703371008 17.213 100 84 166 1 1741497328 14271296 23855024
23:04:35 6249 8192000000 10638849248 11016798208 1709666736 17.266 100 74 148 2 1743362896 12718960 20977200
23:04:50 6463 8192000000 10667328560 11042496512 1731854016 17.451 100 83 166 1 1768539712 13221728 23463968
23:05:05 4868 8192000000 10677361488 11050651648 1735198976 17.479 100 81 162 1 1771756800 13537168 23020656
23:05:19 4568 8192000000 10684675536 11059933184 1745699632 17.566 100 85 165 2 1782892800 14362880 22830288
23:05:31 4898 8192000000 10703537952 11079258112 1759674880 17.682 100 86 172 0 1798427280 14413776 24338624
23:05:43 5782 8192000000 10696951952 11084472320 1767958368 17.750 100 73 145 3 1801383168 13070352 20354448
23:05:56 5316 8192000000 10718972816 11101294592 1781542768 17.862 100 77 153 2 1815237488 12388592 21306128
23:06:08 3809 8192000000 10726580192 11108974592 1792482864 17.952 100 83 165 4 1827468032 12385696 22599472
23:06:25 3212 8192000000 10723392304 11109490688 1790410064 17.935 100 75 148 1 1823647472 12950432 20286976
23:06:35 2673 8192000000 10753673616 11131457536 1803331312 18.041 100 85 167 1 1840963360 14375936 23256112
23:06:45 2431 8192000000 10753657184 11136790528 1816720240 18.151 100 90 180 0 1856288368 13852480 25715648
23:06:54 4403 8192000000 10751434832 11141636096 1819505600 18.174 100 75 151 0 1852062000 11993120 20563280
23:07:05 4417 8192000000 10772136528 11159117824 1828389552 18.246 100 89 178 0 1866867424 13205280 25272592
23:07:16 3439 8192000000 10780580544 11166420992 1833603280 18.289 100 86 173 1 1871618576 13768688 24246608
23:07:27 2574 8192000000 10784288112 11172380672 1840295680 18.343 100 89 176 0 1877090368 11764176 25030512
23:07:36 1748 8192000000 10786060368 11173924864 1843727280 18.371 100 86 173 2 1879755040 12679824 23347936
23:07:44 2309 8192000000 10798762864 11181842432 1847861920 18.405 100 90 180 2 1886439632 13190032 25387680
23:07:53 2559 8192000000 10795221520 11182661632 1847873872 18.405 100 87 174 0 1886662496 14642800 24145824
23:08:02 3877 8192000000 10789061360 11176579072 1848834512 18.413 100 85 169 0 1885577072 13565168 23177392
23:08:13 1641 8192000000 10789929248 11184488448 1853466720 18.450 100 78 157 0 1887861040 12702192 21692128
23:08:21 1578 8192000000 10803577296 11191967744 1861179248 18.513 100 90 184 0 1900709328 12998800 26531280
23:08:29 1907 8192000000 10808643216 11197382656 1861326736 18.514 100 91 181 0 1901057296 13773856 25956704
23:08:37 1908 8192000000 10812405520 11196977152 1865273632 18.546 100 91 182 0 1904553248 14044944 25234672
23:08:46 1709 8192000000 10816553888 11202281472 1866624448 18.557 100 96 193 2 1908046944 14941600 26480896
23:08:54 1961 8192000000 10814849152 11205046272 1872460016 18.604 100 92 184 1 1913017088 14167280 26389792
23:09:02 2091 8192000000 10818320624 11205238784 1872777712 18.607 100 91 183 0 1912413648 14240240 25395696
23:09:10 1176 8192000000 10815553200 11207749632 1875226000 18.627 100 91 180 0 1915281824 14020064 26035760
23:09:18 40409 8192000000 10790688128 11200577536 1865217184 18.546 100 42 84 0 1885422672 7099776 13105712
23:10:05 10093 8192000000 10800485152 11211583488 1874857680 18.624 100 59 118 4 1902433712 11030544 16545488
23:10:23 5155 8192000000 10804572432 11214532608 1879584384 18.662 100 59 117 2 1905149152 8660496 16904272
23:10:35 4530 8192000000 10790898480 11211800576 1873820944 18.615 100 33 67 1 1890475872 8062736 8592192
23:10:46 6210 8192000000 10793830208 11211821056 1874013344 18.617 100 33 65 2 1890340432 7089456 9237632
23:11:02 5933 8192000000 10788030544 11219353600 1885742208 18.711 100 41 79 2 1904506304 7532784 11231312
23:11:16 10473 8192000000 10800337248 11221807104 1879705760 18.663 100 19 38 0 1890705168 6114480 4884928
23:11:33 3728 8192000000 10790050096 11222155264 1884151888 18.699 100 32 64 3 1901031056 7647088 9232080
23:11:44 11966 8192000000 10791213936 11224436736 1889605136 18.743 100 28 55 1 1903212608 5933072 7674400
23:12:04 10692 8192000000 10790265424 11224707072 1888627360 18.735 100 8 16 3 1895730528 5147888 1955280
23:12:21 9282 8192000000 10801265904 11232718848 1893085248 18.771 100 17 34 1 1903505760 5576464 4844048
23:12:38 7843 8192000000 10803254848 11237167104 1896053792 18.795 100 21 42 1 1908267520 6438064 5775664
23:12:59 21814 8192000000 10807313328 11250245632 1902715184 18.848 100 14 28 1 1916939968 10715456 3509328
23:13:26 13493 8192000000 10819050448 11248123904 1908659888 18.896 100 23 45 1 1921258128 5048304 7549936
23:13:46 65972 8192000000 10818713536 11259011072 1911021088 18.915 100 30 58 4 1925089648 5339440 8729120
23:14:59 9245 8192000000 10826539920 11262160896 1913501808 18.935 100 16 32 0 1923372096 5698928 4171360
23:15:16 8948 8192000000 10823172304 11263254528 1914410848 18.942 100 22 44 2 1926699968 6088864 6200256
23:15:31 3564 8192000000 10835194464 11268255744 1918115216 18.972 100 40 80 1 1936681680 7474912 11091552
23:15:42 8320 8192000000 10829021536 11270651904 1918333040 18.973 100 35 70 0 1935197232 6898000 9966192
23:15:56 6886 8192000000 10837326864 11268636672 1918793072 18.977 100 27 54 1 1936500944 10077280 7630592
23:16:10 8364 8192000000 10829055952 11266998272 1918419632 18.974 100 27 55 1 1932513184 5726976 8366576
23:16:27 8828 8192000000 10812496944 11250917376 1876370448 18.636 98 13 26 0 1885449600 5442096 3637056
23:16:42 11587 8192000000 10813572912 11251167232 1890078336 18.746 99 21 42 0 1902066224 6358000 5629888
23:16:59 12787 8192000000 10817568800 11257507840 1892153312 18.763 99 13 26 1 1901192368 4994960 4044096
23:17:21 12006 8192000000 10790647712 11225800704 1827506384 18.239 96 15 30 0 1837009008 5241488 4261136
23:17:40 16706 8192000000 10785983424 11226677248 1854505840 18.459 98 16 32 1 1864879136 5412448 4960848
23:18:03 11006 8192000000 10776459776 11204104192 1818638464 18.167 97 16 32 0 1828966784 5738016 4590304
23:18:23 70092 8192000000 10793950624 11206795264 1825010304 18.219 97 31 62 1 1840224704 6365328 8849072
23:19:40 4070 8192000000 10775377136 11196350464 1841571984 18.354 99 40 80 0 1861434944 8940352 10922608
23:19:51 6551 8192000000 10749186864 11169988608 1784554272 17.887 96 39 76 1 1801915856 6571920 10789664
23:20:05 5919 8192000000 10746655056 11176992768 1816568624 18.150 98 21 41 0 1828362864 5998320 5795920
23:20:17 7658 8192000000 10765731872 11187535872 1845624416 18.387 100 34 68 0 1861423056 6528848 9269792
23:20:32 5210 8192000000 10756944848 11168653312 1830218608 18.261 99 34 64 2 1845977520 6670464 9088448
23:20:43 6702 8192000000 10746574704 11168055296 1790547952 17.936 97 25 48 1 1803647120 5857344 7241824
23:20:59 5767 8192000000 10704488128 11118948352 1733799152 17.467 96 37 74 0 1750772576 5522816 11450608
23:21:12 6541 8192000000 10673987216 11083927552 1717083328 17.328 96 27 54 0 1734245744 9140896 8021520
23:21:27 8544 8192000000 10679430192 11097772032 1699193664 17.178 95 28 56 2 1712885520 4730752 8961104
23:21:43 9727 8192000000 10695287760 11114569728 1765709632 17.732 99 16 32 0 1776022144 5551408 4761104
23:22:01 9394 8192000000 10689322720 11105718272 1725094192 17.395 96 32 64 3 1740625936 5819840 9711904
23:22:18 51545 8192000000 10682304704 11099463680 1734116096 17.470 97 21 42 1 1745263024 4663552 6483376
23:23:22 19547 8192000000 10723882384 11142590464 1793960848 17.964 99 21 40 2 1804713120 5599856 5152416
23:23:49 10236 8192000000 10739947584 11154141184 1819894160 18.177 100 27 55 1 1833286592 5630256 7762176
23:24:06 6064 8192000000 10727166080 11153629184 1818963104 18.169 100 40 81 2 1838311824 7894224 11454496
23:24:20 5035 8192000000 10747232656 11165507584 1815216368 18.139 99 27 54 2 1828939296 6186992 7535936
23:24:35 7377 8192000000 10764088496 11175075840 1835342208 18.303 100 43 86 1 1853956560 6271296 12343056
23:24:53 5181 8192000000 10748143088 11176587264 1840276240 18.343 100 23 46 0 1853086656 6065808 6744608
23:25:09 5734 8192000000 10782786272 11196493824 1853926848 18.454 100 39 78 3 1872617008 6122592 12567568
23:25:22 6971 8192000000 10763619312 11190661120 1851998896 18.438 100 18 36 0 1864029296 5652624 6377776
23:25:35 8202 8192000000 10773707200 11198894080 1856051072 18.471 100 24 46 1 1868280032 5387424 6841536
23:25:49 12470 8192000000 10765980496 11192635392 1857402272 18.482 100 20 40 2 1868432592 5070992 5959328
23:26:11 7853 8192000000 10772761616 11201589248 1859714224 18.501 100 30 60 0 1874444448 6091664 8638560
23:26:29 9670 8192000000 10771416208 11202809856 1862104208 18.520 100 15 30 2 1872262784 5753936 4404640
23:26:50 55287 8192000000 10790656512 11212533760 1867081904 18.561 100 25 47 0 1879310112 5483232 6744976
23:27:51 36674 8192000000 10823632864 11237453824 1888148128 18.731 100 46 90 4 1905944816 5601680 12195008
23:28:40 16763 8192000000 10845650144 11259006976 1903732096 18.856 100 54 107 0 1927192144 8344320 15115728
23:29:03 25872 8192000000 10842466304 11264778240 1913064096 18.931 100 60 118 1 1940315568 10379488 16871984
23:29:42 12701 8192000000 10858427744 11277959168 1922144432 19.004 100 63 126 0 1952493760 12237856 18111472
23:30:05 28370 8192000000 10857244928 11283505152 1924483968 19.023 100 45 90 2 1948590832 11350016 12756848
23:30:41 14126 8192000000 10867155312 11294437376 1936949344 19.122 100 62 124 2 1966347328 11021056 18376928
23:31:03 4561 8192000000 10877632416 11296243712 1938196000 19.132 100 49 97 0 1962254848 9889456 14169392
23:31:16 7434 8192000000 10875056896 11299512320 1941940256 19.162 100 55 110 1 1968936192 11884880 15111056
23:31:37 13395 8192000000 10881416544 11303219200 1946923824 19.202 100 57 114 1 1975603648 11938352 16741472
23:32:00 10997 8192000000 10885487984 11314319360 1949060320 19.219 100 51 101 1 1977283648 13517488 14705840
23:32:20 35114 8192000000 10879819120 11314278400 1951774848 19.241 100 40 78 2 1976106624 12620928 11710848
23:33:03 35567 8192000000 10895768064 11329187840 1961329520 19.317 100 37 74 3 1985344192 13335776 10678896
23:33:46 12994 8192000000 10902701120 11337097216 1966962400 19.361 100 53 106 2 1999485200 16265008 16257792
23:34:12 11922 8192000000 10904761648 11341053952 1969028496 19.378 100 48 96 2 2000571792 17409680 14133616
23:34:32 5478 8192000000 10907755120 11334799360 1965944400 19.353 100 47 90 1 1997272064 17187696 14139968
23:34:45 4345 8192000000 10915937392 11344379904 1968489456 19.373 100 48 96 0 2001928112 18678272 14760384
23:34:56 17945 8192000000 10922290240 11354574848 1974711344 19.423 100 53 106 2 2010896304 20420928 15764032
23:35:23 17206 8192000000 10916161312 11355193344 1976038704 19.433 100 58 116 1 2014183360 20624928 17519728
23:35:48 11110 8192000000 10921852272 11357081600 1977490960 19.445 100 51 103 0 2013014736 19579632 15944144
23:36:11 5717 8192000000 10939708624 11368976384 1992123088 19.561 100 60 120 3 2032521968 22328656 18070224
23:36:25 17901 8192000000 10934640160 11373260800 1972637232 19.406 99 54 108 1 2012365888 23348288 16380368
23:36:52 4894 8192000000 10935556128 11372371968 1990353232 19.547 100 51 101 0 2025907872 20442432 15112208
23:37:07 22366 8192000000 10936052000 11378401280 1992780512 19.566 100 49 98 0 2028892368 21196288 14915568
23:37:37 4869 8192000000 10960804928 11389952000 2002310480 19.641 100 63 126 1 2044384960 23021664 19052816
23:37:49 6928 8192000000 10956128112 11392724992 2008267216 19.688 100 75 149 1 2054041184 24125856 21648112
23:38:04 6271 8192000000 10963313648 11398811648 2012013824 19.717 100 66 130 3 2057187216 25766176 19407216
23:38:19 10355 8192000000 10972404544 11401723904 2006900992 19.677 100 62 125 0 2053127760 27396336 18830432
23:38:38 8905 8192000000 10965905824 11400990720 2016329120 19.751 100 68 135 3 2065915808 29338848 20247840
23:38:56 4087 8192000000 10967952928 11400728576 2014100768 19.734 100 62 124 0 2058963760 24995216 19867776
23:39:08 5615 8192000000 10981509568 11408052224 2019455408 19.776 100 74 146 0 2066679184 25689264 21534512
23:39:22 4580 8192000000 10985213680 11412848640 2024801664 19.818 100 84 164 3 2074867440 25623840 24441936
23:39:35 6517 8192000000 10977681664 11408932864 2018595216 19.769 100 75 148 0 2066912688 26347264 21970208
23:39:49 5367 8192000000 10977974384 11409031168 2017573920 19.761 100 63 124 0 2060247296 23775520 18897856
23:40:13 5710 8192000000 10978736704 11412172800 2018934288 19.772 100 62 123 1 2062685488 25099760 18651440
23:40:28 7239 8192000000 10969816960 11413991424 2019178176 19.774 100 51 102 2 2060564560 25723504 15662880
23:40:42 4329 8192000000 10984371024 11417116672 2025447424 19.823 100 70 139 1 2072903552 25445760 22010368
23:40:54 3844 8192000000 10975243296 11397144576 1968122752 19.371 98 81 158 0 2018290416 26934704 23232960
23:41:05 2156 8192000000 10985043232 11401895936 2007510928 19.682 100 87 172 2 2063510256 29490096 26509232
23:41:14 3134 8192000000 10974809440 11392598016 1998906768 19.614 100 85 168 2 2053992320 29533184 25552368
23:41:27 5876 8192000000 10973533584 11397873664 2004909008 19.661 100 71 143 1 2055325568 28882256 21534304
23:41:41 5128 8192000000 10974435360 11398955008 2001720128 19.636 100 78 156 0 2053709456 28686624 23302704
23:41:56 2952 8192000000 10953648928 11383328768 1991796720 19.558 100 74 148 2 2045714320 30891040 23026560
23:42:10 3462 8192000000 10948741328 11367272448 1979474048 19.461 99 81 160 0 2031790464 29052800 23263616
23:42:21 4079 8192000000 10954593328 11374465024 1984483744 19.500 100 80 160 3 2039354800 29443536 25427520
23:42:34 2681 8192000000 10970098192 11393036288 1995590240 19.588 100 80 161 1 2052384928 32759856 24034832
23:42:43 2393 8192000000 10976763840 11398668288 2001912064 19.638 100 87 174 0 2062213120 33179152 27121904
23:42:53 2025 8192000000 10987900768 11403739136 2005487408 19.666 100 76 151 1 2060664336 32199840 22977088
23:43:01 5342 8192000000 10986152896 11404812288 2009233040 19.695 100 84 166 2 2068506544 33219408 26054096
23:43:14 5712 8192000000 10983709440 11409440768 2009092128 19.694 100 82 164 1 2069482064 34921088 25468848
23:43:31 8395 8192000000 10971548896 11405750272 2001383056 19.634 100 58 115 1 2056198960 36618864 18197040
23:43:46 3207 8192000000 10957410288 11381559296 1982160400 19.482 99 74 148 0 2042827376 36668336 23998640
23:43:58 4644 8192000000 10977660352 11405930496 2009461728 19.697 100 80 157 0 2071827776 38119408 24246640
23:44:09 4950 8192000000 10960453488 11387977728 1969110064 19.378 99 74 146 3 2031068112 38832096 23125952
23:44:24 4211 8192000000 10961435824 11384008704 1979988352 19.465 100 75 147 1 2041079072 38618176 22472544
23:44:36 1743 8192000000 10934173376 11353673728 1948882064 19.218 98 69 135 1 2010895600 40976560 21036976
23:44:45 2415 8192000000 10973033088 11393318912 1985140352 19.505 100 84 164 0 2056506688 45223168 26143168
23:44:54 1245 8192000000 10965346416 11377197056 1967028656 19.362 100 90 179 1 2042821024 47666896 28125472
23:45:02 4582 8192000000 10967313296 11394535424 1980241040 19.467 100 73 146 1 2050410912 47294928 22874944
23:45:13 7800 8192000000 10931543056 11366576128 1931820096 19.081 98 52 102 0 1996160960 47414320 16926544
23:45:32 12943 8192000000 10952502944 11388272640 1972435728 19.405 100 53 106 1 2038650240 49232544 16981968
23:45:53 2556 8192000000 10958014512 11374718976 1938924256 19.138 98 81 162 1 2016433456 51411024 26098176
23:46:03 5267 8192000000 10969897280 11391328256 1958036848 19.290 99 73 146 3 2034815760 53601424 23177488
23:46:15 1232 8192000000 10966425216 11385438208 1957895136 19.289 99 83 165 0 2036925248 53834016 25196096
23:46:31 8392 8192000000 10912338896 11356037120 1886409920 18.717 96 48 96 2 1953885904 51379632 16096352
23:46:48 4358 8192000000 10966614064 11380633600 1966908480 19.361 100 79 155 0 2040501744 49342480 24250784
23:46:59 4966 8192000000 10937990592 11372666880 1946903168 19.202 99 49 97 1 2011962784 48812592 16247024
23:47:14 6955 8192000000 10939899792 11382931456 1960535232 19.310 100 42 84 2 2025627312 51341280 13750800
23:47:34 2821 8192000000 10939105424 11375194112 1960933152 19.313 100 40 81 2 2019444752 45752624 12758976
23:47:45 1214 8192000000 10966546288 11384037376 1967927840 19.369 100 74 146 3 2037187984 46647056 22613088
23:47:54 9886 8192000000 10930836832 11378266112 1947338256 19.205 99 44 88 1 2006487248 44987200 14161792
23:48:12 12323 8192000000 10936522816 11372400640 1930161168 19.068 98 39 78 2 1982036672 40035488 11840016
23:48:33 14706 8192000000 10926502624 11363102720 1955126208 19.267 100 35 70 1 2004706080 38026560 11553312
23:48:57 29702 8192000000 10924852128 11356639232 1937848288 19.130 99 42 84 2 1990625344 39451824 13325232
23:50:08 3621 8192000000 10937091520 11373056000 1962077136 19.323 100 47 94 0 2021338432 43902304 15358992
23:50:37 13239 8192000000 10915918016 11360624640 1924668752 19.024 98 32 64 1 1979723568 43772752 11282064
23:51:08 13711 8192000000 10928083168 11377954816 1958517792 19.294 100 32 63 1 2013287008 44538000 10231216
23:51:35 21804 8192000000 10933662096 11379208192 1964537824 19.342 100 30 60 0 2020469760 46015488 9916448
23:52:13 23237 8192000000 10928472304 11382525952 1950676336 19.232 99 24 48 1 2006228000 47418880 8132784
23:52:43 19386 8192000000 10931041632 11386347520 1954858368 19.265 100 23 46 1 2018641856 55118512 8664976
23:53:10 10017 8192000000 10923457440 11372990464 1925860448 19.034 99 25 50 3 1997531104 61317168 10353488
23:53:35 16382 8192000000 10911846064 11375849472 1915997200 18.955 99 23 46 2 1990077728 64175568 9904960
23:54:05 7212 8192000000 10921864848 11357265920 1920902272 18.994 100 46 90 1 1995887328 59433648 15551408
23:54:20 12209 8192000000 10912983216 11369304064 1926920608 19.042 100 28 56 0 1996884128 59752480 10211040
23:54:52 16819 8192000000 10908494304 11358953472 1933257328 19.093 100 31 62 2 1996301120 52449408 10594384
23:55:24 24084 8192000000 10877362736 11339661312 1916518272 18.959 99 24 47 2 1964111664 39436272 8157120
23:55:57 69669 8192000000 10864175344 11295965184 1854037664 18.455 96 18 36 1 1876243872 16923264 5282944
23:57:17 5634 8192000000 10874079504 11306905600 1933204960 19.092 100 56 111 1 1956090432 6452944 16432528
23:57:29 101160 8192000000 10851779600 11301007360 1839548960 18.337 95 12 24 0 1851531296 9043584 2938752
23:59:18 21220 8192000000 10869426080 11312685056 1925029120 19.027 99 37 73 1 1941217056 6999856 9188080
23:59:52 45577 8192000000 10861939632 11315576832 1893786928 18.776 98 15 30 0 1904943152 7559360 3596864
00:00:46 99925 8192000000 10883247808 11335946240 1903572464 18.855 98 11 23 1 1921839120 15618544 2648112
00:02:32 140143 8192000000 10884032576 11335479296 1884019584 18.698 96 34 67 1 1906749872 13347376 9382912
00:05:03 43412 8192000000 10883761632 11336658944 1909742976 18.905 98 41 83 1 1943805696 21030208 13032512
00:06:14 89995 8192000000 10881401248 11347161088 1952299792 19.245 100 32 65 0 1971835552 10321248 9214512
00:07:50 21344 8192000000 10879406784 11336695808 1938754176 19.137 99 38 76 0 1960879632 10963488 11161968
00:08:21 41356 8192000000 10882799008 11342258176 1952515936 19.247 100 27 54 0 1971887664 11785664 7586064
00:09:11 28986 8192000000 10891482448 11354337280 1956745248 19.280 100 29 58 3 1975590352 10366016 8479088
00:10:00 31689 8192000000 10899641904 11356610560 1961331056 19.317 100 45 92 4 1989125648 14918528 12876064
00:10:42 89016 8192000000 10887199312 11364343808 1948609760 19.215 99 8 16 0 1965587088 14773568 2203760
00:12:21 86328 8192000000 10884528448 11348443136 1939861280 19.146 99 11 22 0 1960576800 17462640 3252880
00:14:13 81484 8192000000 10920349808 11392270336 1979216272 19.458 100 27 54 2 2004917904 17254608 8447024
00:16:00 101487 8192000000 10915399952 11398111232 1977485552 19.445 100 22 44 0 2004834176 20871328 6477296
00:18:31 120565 8192000000 10891864128 11375276032 1930339440 19.070 98 5 10 0 1949656400 18024656 1292304
00:20:45 43975 8192000000 10892067552 11355185152 1927244752 19.045 98 29 59 1 1945051664 9181376 8625536
00:21:45 36527 8192000000 10889342272 11344035840 1889737552 18.744 96 28 56 1 1907517680 9828704 7951424
00:22:28 44279 8192000000 10877279568 11348492288 1933988256 19.099 99 16 32 1 1954129120 15604112 4536752
00:23:31 84071 8192000000 10889758848 11362074624 1920807488 18.993 98 21 43 1 1937502224 10543264 6151472
00:25:01 15761 8192000000 10925424272 11371642880 1980275696 19.467 100 50 99 0 2001543472 7326224 13941552
00:25:23 14568 8192000000 10916976944 11366326272 1970657824 19.391 100 32 64 0 1989583904 10072880 8853200
00:26:09 65713 8192000000 10892395808 11368357888 1947727184 19.208 99 32 64 0 1969831632 13872304 8232144
00:27:27 86259 8192000000 10891866528 11363905536 1914726688 18.945 97 14 28 0 1928732768 10524384 3481696
00:28:59 52902 8192000000 10925122304 11378450432 1956478640 19.278 99 11 22 0 1967659504 8666448 2514416
00:30:02 157194 8192000000 10892644896 11359084544 1920635136 18.992 97 22 44 1 1946990080 19873952 6480992
00:32:46 26204 8192000000 10890527072 11358126080 1948238048 19.212 99 24 46 1 1964564096 9554464 6771584
00:33:19 19043 8192000000 10905020880 11373834240 1968678000 19.375 100 24 48 2 1985652384 10514256 6460128
00:33:48 50630 8192000000 10859748256 11340337152 1871971328 18.600 95 14 27 2 1884960304 8532176 4456800
00:34:45 37801 8192000000 10859121728 11338895360 1924093376 19.020 99 9 18 1 1937506656 10749696 2663584
00:35:28 43454 8192000000 10865186704 11329986560 1933257536 19.093 99 16 32 1 1949316368 11947472 4111360
00:36:34 49755 8192000000 10868594528 11350593536 1935759808 19.113 99 15 30 0 1952880640 12505024 4615808
00:37:36 47644 8192000000 10864109904 11342594048 1917415520 18.966 98 17 34 0 1931295520 9124992 4755008
00:38:33 82221 8192000000 10874076192 11336855552 1827749024 18.241 93 30 60 2 1848994288 13014912 8230352
00:40:05 33682 8192000000 10868640480 11319668736 1892338128 18.765 98 50 100 0 1922544384 16061808 14144448
00:41:18 138863 8192000000 10840846048 11306708992 1804991856 18.055 93 18 36 1 1819465184 9483568 4989760
00:44:10 55314 8192000000 10861128304 11320270848 1916015152 18.955 99 26 52 0 1938049328 14307216 7726960
00:45:17 83672 8192000000 10870631856 11353075712 1887012720 18.722 97 12 24 0 1903520672 13259952 3248000
00:47:51 39868 8192000000 10872476032 11330293760 1906224912 18.876 98 32 64 3 1924450336 9021808 9203616
00:48:40 44283 8192000000 10879792560 11338891264 1912374128 18.926 98 44 88 2 1939519168 15212560 11932480
00:49:38 61860 8192000000 10868538944 11341815808 1881589792 18.678 97 16 32 1 1914036288 27895936 4550560
00:50:50 55341 8192000000 10858572864 11315421184 1870931472 18.592 97 12 24 1 1896438032 21816000 3690560
00:51:59 114932 8192000000 10871692208 11343921152 1931988800 19.083 100 16 31 3 1952399728 15463536 4947392
00:54:02 52347 8192000000 10862884400 11344314368 1912484112 18.927 99 12 24 0 1929758576 13716752 3557712
00:55:04 55999 8192000000 10875914352 11341893632 1927263776 19.045 99 28 56 4 1948857904 13135488 8458640
00:56:07 37875 8192000000 10849710896 11316396032 1898005856 18.810 98 26 52 0 1917468560 12073824 7388880
00:56:56 50809 8192000000 10869369344 11343126528 1935373648 19.110 100 23 46 3 1955546240 12888624 7283968
00:57:53 60648 8192000000 10854517904 11331289088 1905041968 18.867 98 8 16 0 1921631248 14220736 2368544
00:59:31 56142 8192000000 10875999680 11343634432 1933866640 19.098 99 18 35 1 1948633088 10033808 4732640
01:00:39 83691 8192000000 10879621600 11355836416 1961750496 19.320 100 16 32 0 1977746192 11535488 4460208
01:02:48 63615 8192000000 10878546112 11365462016 1945070608 19.187 99 10 19 1 1960185088 12436944 2677536
01:04:13 96324 8192000000 10869349696 11318853632 1853280768 18.449 95 14 28 1 1868297824 11193008 3824048
01:06:11 70683 8192000000 10880937872 11349700608 1898069728 18.811 98 28 56 0 1928789568 22872736 7847104
01:07:27 69758 8192000000 10888715904 11360829440 1957319040 19.285 100 24 48 0 1977612080 13832064 6460976
01:08:44 66117 8192000000 10873845744 11355168768 1933398176 19.094 99 11 22 0 1949423152 13333328 2691648
01:10:04 74187 8192000000 10901223552 11386986496 1963529616 19.334 100 24 48 4 1984483888 14043152 6911120
01:11:24 58104 8192000000 10887838480 11371954176 1916866448 18.962 97 16 31 2 1943433488 21656544 4910496
01:12:30 141748 8192000000 10869383168 11342905344 1809668224 18.093 92 6 12 0 1822206320 11228128 1309968
01:14:57 21828 8192000000 10910068240 11358605312 1953172560 19.252 100 43 86 2 1973385024 8006320 12206144
01:15:35 43431 8192000000 10906369824 11369472000 1959066560 19.299 100 24 48 1 1978098976 12528352 6504064
01:16:29 107100 8192000000 10893279056 11361763328 1948539952 19.215 99 26 52 1 1969131648 12812976 7778720
01:18:35 76510 8192000000 10882112416 11347501056 1919550912 18.983 98 18 36 0 1933611136 9192224 4868000
01:20:01 12873 8192000000 10896919568 11358384128 1960916688 19.313 100 34 65 1 1978486720 8346832 9223200
01:20:20 20790 8192000000 10912058528 11370500096 1972875568 19.408 100 44 88 1 1995371104 9691104 12804432
01:20:49 31674 8192000000 10905032704 11380240384 1978856048 19.456 100 33 66 1 1999998864 11790912 9351904
01:21:31 68053 8192000000 10895512368 11387981824 1975454320 19.429 100 9 15 2 1990314608 12597360 2262928
01:23:33 74581 8192000000 10910572320 11389886464 1982480144 19.484 100 13 26 0 1999261472 12937824 3843504
01:24:57 76633 8192000000 10883108736 11377995776 1942422512 19.166 98 15 31 1 1955854896 9316960 4115424
01:26:23 58990 8192000000 9445295920 9749561344 556315280 6.359 29 7 14 0 565824512 8039744 1469488

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 17-02-2021 01:29:01 to 17-02-2021 01:29:31.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 115 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 17-02-2021 01:29:32 to 17-02-2021 01:29:34.

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          230239
MON$OLDEST_ACTIVE               230926
MON$OLDEST_SNAPSHOT             230926
MON$NEXT_TRANSACTION            230926
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                       2020416
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.33416 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33416 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33416 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33416 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 ---
:41: 
:42: mscs-test-161.budzdorov.ru    Wed Feb 17 01:27:24 2021
:43:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:44: 
:45: 
:46: mscs-test-161.budzdorov.ru    Wed Feb 17 01:27:27 2021
:47:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:48: 
:49: 
:50: mscs-test-161.budzdorov.ru    Wed Feb 17 01:27:31 2021
:51:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:52: 
--- end of diff output ---

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

17.02.21 01:29:35. 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-02-17 01:29:38 No severe PSQL-related problems occured
17.02.21 01:29:39. End of report.