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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17203480 kB
MemAvailable 31387460 kB
Buffers 0 kB
Cached 14465704 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-04 01:27:10
DTS_END                         2021-01-04 01:27:10.1830
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/58254
TRN_ID                          244176
ATT_ID                          686
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: 9238.25 23796 1108590
customer order: creation 173.83 347 20859
customer order: refuse 14.98 341 1798
order to supplier: creation 46.02 1232 5522
order to supplier: removal 3.51 89543 421
invoice (draft): creation 46.41 3300 5569
invoice (draft): removal 52.73 774 6328
invoice accept: apply 42.40 17330 5088
invoice accept: cancel 47.33 784 5680
customer reserve: creation 3861.33 175 463360
customer reserve: removal 4657.17 52 558860
realization accept: apply 84.26 183 10111
realization accept: cancel 76.50 117 9180
payment from customer: creation 60.11 111 7213
payment from customer: removal 5.87 67 704
payment to supplier: creation 49.96 124 5995
payment to supplier: removal 3.52 84 422
service: total inventory turnovers 4.88 1101 585
service: total monetary turnovers 6.50 28 780
service: aggregate perf. data 0.93 17316 111
service: refresh index statistics 0.03 342917 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 04-01-2021 01:28:32 to 04-01-2021 01:28:34.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4143
TEST_TIME 2 5838
TEST_TIME 3 5557
TEST_TIME 4 5589
TEST_TIME 5 5867
TEST_TIME 6 5909
TEST_TIME 7 5665
TEST_TIME 8 5883
TEST_TIME 9 6077
TEST_TIME 10 6134
TEST_TIME 11 6137
TEST_TIME 12 6404
TEST_TIME 13 6322
TEST_TIME 14 6493
TEST_TIME 15 6727
TEST_TIME 16 6749
TEST_TIME 17 7112
TEST_TIME 18 7388
TEST_TIME 19 7644
TEST_TIME 20 8543
TEST_TIME 21 8601
TEST_TIME 22 8685
TEST_TIME 23 8927
TEST_TIME 24 8990
TEST_TIME 25 9243
TEST_TIME 26 10016
TEST_TIME 27 9982
TEST_TIME 28 9783
TEST_TIME 29 9727
TEST_TIME 30 10048
TEST_TIME 31 10031
TEST_TIME 32 9860
TEST_TIME 33 9675
TEST_TIME 34 9667
TEST_TIME 35 9526
TEST_TIME 36 9652
TEST_TIME 37 9741
TEST_TIME 38 9712
TEST_TIME 39 9597
TEST_TIME 40 9533
TEST_TIME 41 9460
TEST_TIME 42 9544
TEST_TIME 43 9582
TEST_TIME 44 9739
TEST_TIME 45 9660
TEST_TIME 46 9598
TEST_TIME 47 9650
TEST_TIME 48 9614
TEST_TIME 49 9793
TEST_TIME 50 9632
TEST_TIME 51 9483
TEST_TIME 52 9453
TEST_TIME 53 9394
TEST_TIME 54 9385
TEST_TIME 55 9320
TEST_TIME 56 9252
TEST_TIME 57 9265
TEST_TIME 58 9243
TEST_TIME 59 9439
TEST_TIME 60 9416
TEST_TIME 61 9326
TEST_TIME 62 9315
TEST_TIME 63 9255
TEST_TIME 64 9240
TEST_TIME 65 9348
TEST_TIME 66 9329
TEST_TIME 67 9343
TEST_TIME 68 9299
TEST_TIME 69 9368
TEST_TIME 70 9406
TEST_TIME 71 9389
TEST_TIME 72 9409
TEST_TIME 73 9441
TEST_TIME 74 9437
TEST_TIME 75 9390
TEST_TIME 76 9529
TEST_TIME 77 9547
TEST_TIME 78 9511
TEST_TIME 79 9454
TEST_TIME 80 9375
TEST_TIME 81 9424
TEST_TIME 82 9363
TEST_TIME 83 9333
TEST_TIME 84 9365
TEST_TIME 85 9294
TEST_TIME 86 9244
TEST_TIME 87 9176
TEST_TIME 88 9142
TEST_TIME 89 9254
TEST_TIME 90 9280
TEST_TIME 91 9250
TEST_TIME 92 9267
TEST_TIME 93 9317
TEST_TIME 94 9304
TEST_TIME 95 9393
TEST_TIME 96 9383
TEST_TIME 97 9370
TEST_TIME 98 9434
TEST_TIME 99 9435
TEST_TIME 100 9478
TEST_TIME 101 9482
TEST_TIME 102 9515
TEST_TIME 103 9506
TEST_TIME 104 9503
TEST_TIME 105 9419
TEST_TIME 106 9372
TEST_TIME 107 9422
TEST_TIME 108 9400
TEST_TIME 109 9425
TEST_TIME 110 9368
TEST_TIME 111 9340
TEST_TIME 112 9319
TEST_TIME 113 9304
TEST_TIME 114 9287
TEST_TIME 115 9324
TEST_TIME 116 9290
TEST_TIME 117 9307
TEST_TIME 118 9312
TEST_TIME 119 9306
TEST_TIME 120 9239

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 04-01-2021 01:28:35 to 04-01-2021 01:28:39.

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 1537620 1537620 0 0.00 0 18769 6 0 0
doc_list_biud 1537619 1537619 0 0.00 0 30278 25 0 0
sp_add_invoice_to_stock 5201 5088 113 2.17 41 197079 17331 0 113
sp_cancel_adding_invoice 5680 5680 0 0.00 5 64833 785 0 0
sp_cancel_client_order 1798 1798 0 0.00 4 15443 342 0 0
sp_cancel_customer_reserve 558860 558860 0 0.00 1 30280 52 0 0
sp_cancel_pay_from_customer 704 704 0 0.00 3 3861 68 0 0
sp_cancel_pay_to_supplier 422 422 0 0.00 3 8537 84 0 0
sp_cancel_supplier_invoice 6337 6328 9 0.14 1 15329 774 0 9
sp_cancel_supplier_order 421 421 0 0.00 7 859109 89543 0 0
sp_cancel_write_off 9180 9180 0 0.00 1 13508 118 0 0
sp_client_order 20859 20859 0 0.00 4 17062 347 0 0
sp_customer_reserve 463360 463360 0 0.00 0 102505 175 0 0
sp_fill_shopping_cart 31938 31938 0 0.00 1 10636 35 0 0
sp_fill_shopping_cart_clo_res 463354 463354 0 0.00 0 24033 13 0 0
sp_get_clo_for_invoice 5082 5082 0 0.00 0 24364 288 0 0
sp_kill_cost_storno 15986 15986 0 0.00 0 8385 55 0 0
sp_kill_qstorno_ret_qs2qd 1133649 1133649 0 0.00 0 30272 29 0 0
sp_kill_qty_storno 597459 597459 0 0.00 0 30278 63 0 0
sp_lock_selected_doc 21049 21049 0 0.00 0 6525 5 0 0
sp_make_cost_storno 28401 28401 0 0.00 0 18763 55 0 0
sp_multiply_rows_for_pdistr 28401 28401 0 0.00 0 8356 30 0 0
sp_multiply_rows_for_qdistr 20859 20859 0 0.00 0 16887 155 0 0
sp_pay_from_customer 7213 7213 0 0.00 4 29955 111 0 0
sp_pay_to_supplier 5995 5995 0 0.00 5 18885 124 0 0
sp_payment_common 13208 13208 0 0.00 1 29945 32 0 0
sp_qd_handle_on_cancel_clo 1798 1798 0 0.00 0 15435 319 0 0
sp_qd_handle_on_invoice_upd_sts 10761 10761 0 0.00 0 24263 332 0 0
sp_qd_handle_on_reserve_upd_sts 10111 10111 0 0.00 0 20348 59 0 0
sp_reserve_write_off 10111 10111 0 0.00 6 20373 184 0 0
sp_supplier_invoice 5569 5569 0 0.00 6 86193 3301 0 0
sp_supplier_order 5522 5522 0 0.00 4 40577 1232 0 0
srv_aggregate_perf_data 111 111 0 0.00 3037 135111 17317 0 0
srv_fill_mon_cache_memory 156 156 0 0.00 1274 137275 32415 0 0
srv_find_qd_qs_mism 1060379 1060379 0 0.00 0 8437 5 0 0
srv_make_invnt_saldo 585 585 0 0.00 32 82778 1102 0 0
srv_make_money_saldo 780 780 0 0.00 1 2013 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 234146 451249 342918 0 0
t$perf-abend:sp_add_invoice_to_stock 113 113 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5089 5089 0 0.00 0 10571 165 0 0
t$perf-norm:sp_cancel_adding_invoice 410 410 0 0.00 0 2720 94 0 0
t$perf-norm:sp_cancel_client_order 1798 1798 0 0.00 0 13837 19 0 0
t$perf-norm:sp_cancel_customer_reserve 701 701 0 0.00 0 519 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 704 704 0 0.00 0 2947 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 422 422 0 0.00 0 2113 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 420 420 0 0.00 0 8178 36 0 0
t$perf-norm:sp_cancel_supplier_order 421 421 0 0.00 0 25615 1724 0 0
t$perf-norm:sp_cancel_write_off 981 981 0 0.00 0 6889 31 0 0
t$perf-norm:sp_client_order 20859 20859 0 0.00 0 12929 21 0 0
t$perf-norm:sp_customer_reserve 1039 1039 0 0.00 0 8972 18 0 0
t$perf-norm:sp_pay_from_customer 7213 7213 0 0.00 0 20749 14 0 0
t$perf-norm:sp_pay_to_supplier 5995 5995 0 0.00 0 4789 12 0 0
t$perf-norm:sp_reserve_write_off 10111 10111 0 0.00 0 7321 15 0 0
t$perf-norm:sp_supplier_invoice 5569 5569 0 0.00 0 7984 25 0 0
t$perf-norm:sp_supplier_order 5522 5522 0 0.00 0 3970 17 0 0
t$perf-norm:srv_aggregate_perf_data 111 111 0 0.00 0 524 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 156 156 0 0.00 0 397 14 0 0
t$perf-norm:srv_make_invnt_saldo 585 585 0 0.00 0 1254 25 0 0
t$perf-norm:srv_make_money_saldo 780 780 0 0.00 0 4547 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10387 10162 225 2.16 0 13198 19 0 225
v_all_customers 38182 38182 0 0.00 0 29 1 0 0
v_all_suppliers 30570 30570 0 0.00 0 18 1 0 0
v_all_wares 41718 41718 0 0.00 0 90 1 0 0
v_cancel_adding_invoice 820 820 0 0.00 0 649 7 0 0
v_cancel_client_order 3596 3596 0 0.00 0 2240 4 0 0
v_cancel_customer_prepayment 1408 1408 0 0.00 0 3819 8 0 0
v_cancel_customer_reserve 1402 1402 0 0.00 0 1272 5 0 0
v_cancel_payment_to_supplier 844 844 0 0.00 0 1893 5 0 0
v_cancel_supplier_invoice 858 840 18 2.09 0 5397 27 0 18
v_cancel_supplier_order 842 842 0 0.00 0 177 3 0 0
v_cancel_write_off 1962 1962 0 0.00 0 4539 20 0 0
v_max_id_clo_ord 5521 5521 0 0.00 0 2249 1 0 0
v_max_id_clo_res 1039 1039 0 0.00 0 2993 11 0 0
v_max_id_ord_sup 5558 5558 0 0.00 0 2447 4 0 0
v_max_non_paid_invoice 1789 1789 0 0.00 0 441 3 0 0
v_max_non_paid_realizn 3849 3849 0 0.00 0 2067 5 0 0
v_min_id_clo_ord 5521 5521 0 0.00 0 1787 5 0 0
v_min_id_clo_res 1039 1039 0 0.00 0 5271 26 0 0
v_min_id_ord_sup 5558 5558 0 0.00 0 6047 8 0 0
v_min_non_paid_invoice 5995 5995 0 0.00 0 9428 19 0 0
v_min_non_paid_realizn 7213 7213 0 0.00 0 29939 22 0 0
v_our_firm 10264 10264 0 0.00 0 20 1 0 0
v_reserve_write_off 20222 20222 0 0.00 0 5156 6 0 0
x_lock_depdocs_on_canc_invoice 11588 11588 0 0.00 0 25513 106 0 0
x_lock_depdocs_on_canc_sup_ord 421 421 0 0.00 0 2766 259 0 0
x_make_qstorno_1000_1200 5522 5522 0 0.00 1 40544 1153 0 0
x_make_qstorno_1200_2000 5569 5569 0 0.00 3 86180 3185 0 0
x_make_qstorno_2100_3300 463360 463360 0 0.00 0 102504 160 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-01-2021 01:28:40 to 04-01-2021 01:28:44.

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:13 3 8192000000 8803234320 8815087616 8599360 0.104 2 2 2 0 8721024 59104 62560
22:57:20 16517 8192000000 10227013904 10535272448 908548304 9.983 71 58 117 0 929712208 2554272 18609632
22:57:44 24328 8192000000 10329248672 10647764992 1375387792 14.375 100 82 164 1 1406280816 4646528 26246496
22:58:16 15926 8192000000 10358849152 10682085376 1419497344 14.768 100 83 166 0 1452704704 6079536 27127824
22:58:46 24279 8192000000 10390962176 10719072256 1447593632 15.017 100 88 174 1 1483081424 7124480 28363312
22:59:18 31848 8192000000 10434355616 10762559488 1480305216 15.304 100 92 184 0 1518057264 8307728 29444320
22:59:59 22855 8192000000 10446195712 10776596480 1491194624 15.399 100 92 184 1 1530283808 9290288 29798896
23:00:29 25106 8192000000 10453699840 10787758080 1506500080 15.533 100 90 180 0 1545328992 9885856 28943056
23:01:08 11019 8192000000 10464422768 10801176576 1518823456 15.640 100 90 180 0 1557631488 10440496 28367536
23:01:27 17905 8192000000 10471704784 10819948544 1531652544 15.751 100 75 150 1 1565550256 10214976 23682736
23:01:53 9407 8192000000 10483742432 10834497536 1548828304 15.900 100 74 149 0 1582290096 10329136 23132656
23:02:09 14516 8192000000 10508495760 10862825472 1569269472 16.076 100 68 136 0 1600609856 10466448 20873936
23:02:34 11813 8192000000 10551339360 10906050560 1601316240 16.351 100 74 148 1 1634541792 10920208 22305344
23:02:54 12362 8192000000 10583584976 10944303104 1640225296 16.682 100 80 160 1 1676532384 12506592 23800496
23:03:20 7924 8192000000 10611209328 10975940608 1661116160 16.858 100 77 154 2 1696887040 13369248 22401632
23:03:43 12798 8192000000 10630896496 10997317632 1682502784 17.038 100 82 164 1 1719501296 13053520 23944992
23:04:04 8010 8192000000 10650186656 11020136448 1705561824 17.232 100 81 162 1 1743058272 14092672 23403776
23:04:21 5623 8192000000 10657001328 11031613440 1719748928 17.350 100 77 155 0 1753964064 12666592 21548544
23:04:35 5547 8192000000 10664547456 11041325056 1728866112 17.426 100 73 146 1 1761747728 12257984 20623632
23:04:49 4609 8192000000 10674560080 11054301184 1740482512 17.523 100 76 150 1 1774273504 12217264 21573728
23:05:02 4632 8192000000 10684293808 11068035072 1750709536 17.607 100 66 132 0 1782113392 12312688 19091168
23:05:14 4403 8192000000 10696028288 11077468160 1761566032 17.697 100 76 151 1 1795602512 12745456 21291024
23:05:25 5039 8192000000 10704940640 11090305024 1768600800 17.755 100 82 163 3 1804286800 12808624 22877376
23:05:38 5808 8192000000 10714108256 11100336128 1779683248 17.847 100 78 156 1 1814220048 12713104 21823696
23:05:51 3866 8192000000 10725093552 11108904960 1785027600 17.891 100 85 170 1 1822002832 12871968 24103264
23:06:02 3793 8192000000 10733799568 11114590208 1789367856 17.927 100 80 156 3 1823979600 11808864 22802880
23:06:12 8443 8192000000 10725525408 11118026752 1800724080 18.020 100 80 160 0 1835994320 12563616 22706624
23:06:28 4096 8192000000 10747235152 11131052032 1805292144 18.057 100 77 154 0 1839472784 13352880 20827760
23:06:39 2382 8192000000 10768640992 11150372864 1824119584 18.211 100 91 182 0 1864394288 14669888 25604816
23:06:48 3722 8192000000 10762156464 11152871424 1826876800 18.234 100 79 159 0 1862781568 14098800 21805968
23:06:59 2333 8192000000 10770996880 11158650880 1829250432 18.253 100 83 166 2 1867736640 14370768 24115440
23:07:07 3080 8192000000 10780503952 11163643904 1834065712 18.292 100 90 180 0 1872903152 13313632 25523808
23:07:17 2133 8192000000 10776184608 11165077504 1836890576 18.315 100 90 180 0 1875371392 12988752 25492064
23:07:27 1235 8192000000 10787196944 11170877440 1844956832 18.381 100 96 192 0 1885284896 12786176 27541888
23:07:35 1770 8192000000 10789236000 11176972288 1850337952 18.425 100 88 176 2 1887385216 12386528 24660736
23:07:43 2124 8192000000 10798645344 11186192384 1851308688 18.433 100 89 179 1 1888979168 12751472 24919008
23:07:51 2493 8192000000 10809438032 11194277888 1856994384 18.479 100 96 189 0 1897503200 14824096 25684720
23:08:00 1637 8192000000 10798829072 11189284864 1861112096 18.512 100 95 190 2 1902531168 14446080 26972992
23:08:08 1579 8192000000 10805797968 11192483840 1861976064 18.519 100 91 183 1 1902072528 13943424 26153040
23:08:17 2134 8192000000 10816662960 11204435968 1867757888 18.566 100 90 179 0 1906426144 13175200 25493056
23:08:26 41705 8192000000 10810134288 11204280320 1865666016 18.549 100 67 135 0 1895987536 11472208 18849312
23:09:14 2044 8192000000 10822902320 11212795904 1876887568 18.640 100 89 177 2 1912185248 10281984 25015696
23:09:23 3611 8192000000 10824735312 11219365888 1886033216 18.714 100 89 176 2 1922815072 11045936 25735920
23:09:33 2806 8192000000 10814410496 11219656704 1879983776 18.665 100 57 114 0 1907723536 11137632 16602128
23:09:42 5192 8192000000 10797292704 11216277504 1878355024 18.652 100 42 83 3 1899071184 9323024 11393136
23:09:53 5228 8192000000 10796166336 11218653184 1880826832 18.672 100 44 90 1 1901915536 8952464 12136240
23:10:05 3828 8192000000 10791301632 11214901248 1883568544 18.694 100 43 86 0 1904195056 8171264 12455248
23:10:16 9601 8192000000 10805634560 11223310336 1881233744 18.675 100 28 56 1 1896469200 7256128 7979328
23:10:34 5035 8192000000 10808653376 11225038848 1886105680 18.714 100 39 78 1 1903971632 7061696 10804256
23:10:48 4085 8192000000 10797658160 11223777280 1889123392 18.739 100 30 60 0 1905259696 6847568 9288736
23:10:59 6531 8192000000 10789049648 11222454272 1886593840 18.718 100 19 38 2 1898607760 6959184 5054736
23:11:11 11240 8192000000 10787374688 11223494656 1888759888 18.736 100 23 46 2 1901022544 5565888 6696768
23:11:29 8562 8192000000 10799723456 11228958720 1891270352 18.756 100 19 38 1 1902647888 5805440 5572096
23:11:48 6940 8192000000 10806563152 11234697216 1894617200 18.783 100 28 56 1 1909803184 7560656 7625328
23:12:10 4478 8192000000 10798850352 11233611776 1895421264 18.789 100 25 50 0 1909217472 6863216 6932992
23:12:21 10579 8192000000 10809588640 11246264320 1898822752 18.817 100 17 32 3 1913576160 10073808 4679600
23:12:45 9941 8192000000 10822478208 11243970560 1903968928 18.858 100 43 87 2 1921699856 4646672 13084256
23:13:03 66714 8192000000 10811430048 11251068928 1902237408 18.844 100 18 36 0 1913648880 6248032 5163440
23:14:16 11923 8192000000 10831080640 11262763008 1904012864 18.859 100 20 39 3 1915420848 5929024 5478960
23:14:36 4292 8192000000 10825975552 11258232832 1907538064 18.887 100 30 61 1 1922618752 6916400 8164288
23:14:46 4511 8192000000 10835096608 11259326464 1907741328 18.889 100 31 62 1 1923352144 7218752 8392064
23:14:58 4880 8192000000 10828144176 11259822080 1907148320 18.884 100 28 54 1 1920079760 5444112 7487328
23:15:10 3098 8192000000 10833491920 11262930944 1911944560 18.922 100 35 69 3 1927343536 5874704 9524272
23:15:25 6788 8192000000 10824253824 11252768768 1890177040 18.747 99 27 54 2 1904762192 6248480 8336672
23:15:38 7968 8192000000 10834671136 11256360960 1889323456 18.740 99 28 57 0 1903608368 5523296 8761616
23:15:52 6425 8192000000 10820577648 11256459264 1905221632 18.868 100 21 42 1 1916904768 5968880 5714256
23:16:09 8389 8192000000 10800746144 11238526976 1875907408 18.632 99 24 48 4 1888824416 5616048 7300960
23:16:30 9522 8192000000 10814204624 11246608384 1881764304 18.679 99 20 40 3 1893225024 5700880 5759840
23:16:46 14336 8192000000 10778377024 11211411456 1815158544 18.138 96 13 26 2 1824645008 6020240 3466224
23:17:08 6725 8192000000 10798932544 11234459648 1889043264 18.738 100 24 48 4 1901769872 5493936 7232672
23:17:24 13831 8192000000 10798244304 11234193408 1873457904 18.612 99 24 48 0 1886303664 5781648 7064112
23:17:45 46154 8192000000 10785652320 11189772288 1783174704 17.876 94 37 72 0 1797934896 4894112 9866080
23:19:00 13434 8192000000 10716036144 11141271552 1697068960 17.161 92 23 46 1 1709795248 6455968 6270320
23:19:19 8697 8192000000 10717193968 11142795264 1761242224 17.695 97 31 63 1 1775784320 6319360 8222736
23:19:35 7746 8192000000 10696664832 11106344960 1667618768 16.913 92 26 52 0 1684605248 9550032 7436448
23:19:48 5250 8192000000 10712825168 11130769408 1778043200 17.833 99 32 63 1 1793116688 5248528 9824960
23:20:00 5750 8192000000 10722522800 11125321728 1767918464 17.750 97 42 83 2 1785906176 6142368 11845344
23:20:13 4946 8192000000 10733091664 11143598080 1778509584 17.837 98 35 69 3 1793345712 5805040 9031088
23:20:27 8273 8192000000 10696384624 11107471360 1693668160 17.132 94 25 50 3 1706712960 5528736 7516064
23:20:42 11097 8192000000 10703010512 11112054784 1722881808 17.376 97 15 30 0 1732887440 5664688 4340944
23:21:06 5477 8192000000 10692539920 11109359616 1734158192 17.470 97 34 68 2 1749573216 5809232 9605792
23:21:19 6464 8192000000 10665197376 11078930432 1733998928 17.469 98 11 22 0 1742503008 5469472 3034608
23:21:32 6249 8192000000 10703455952 11110264832 1774774816 17.806 100 23 46 1 1787208080 5834400 6598864
23:21:47 8852 8192000000 10714165344 11138965504 1811701856 18.110 100 36 72 3 1828956784 6677712 10577216
23:22:05 13173 8192000000 10719368416 11139477504 1778361632 17.836 98 26 50 4 1791620128 6117824 7140672
23:22:26 63583 8192000000 10751810720 11165491200 1807828992 18.078 99 23 47 1 1821021440 5110560 8081888
23:23:40 21493 8192000000 10753790368 11182235648 1823775264 18.209 99 19 37 3 1839095328 9445728 5874336
23:24:08 6021 8192000000 10778102400 11192836096 1850578816 18.427 100 33 64 0 1866359296 5622352 10158128
23:24:22 5660 8192000000 10769359152 11198345216 1853753680 18.453 100 25 50 1 1867177200 6600224 6823296
23:24:34 9916 8192000000 10772838320 11200159744 1859348224 18.498 100 23 47 2 1871601760 5395552 6857984
23:24:51 7329 8192000000 10791686048 11216986112 1867954624 18.568 100 37 74 1 1886907552 8060000 10892928
23:25:06 4298 8192000000 10787295120 11206946816 1863174448 18.529 100 33 67 2 1878357328 5067360 10115520
23:25:16 8181 8192000000 10796442080 11217674240 1866173280 18.553 100 18 36 0 1876290160 4914624 5202256
23:25:33 8065 8192000000 10794056272 11216171008 1868149072 18.569 100 26 51 1 1880802304 5132832 7520400
23:25:52 6054 8192000000 10783732752 11218632704 1870756768 18.590 100 18 36 2 1881323840 5140624 5426448
23:26:07 6219 8192000000 10792698160 11221950464 1873641552 18.614 100 22 44 1 1885734672 5931232 6161888
23:26:20 12073 8192000000 10792845776 11224977408 1876690016 18.638 100 22 42 6 1888612352 4722624 7199712
23:26:39 10797 8192000000 10799435648 11226853376 1877609760 18.646 100 19 38 2 1889012032 5892640 5509632
23:26:58 11942 8192000000 10813875104 11240517632 1885390288 18.709 100 20 40 1 1895801424 4976816 5434320
23:27:44 21463 8192000000 10841858272 11264643072 1913022048 18.931 100 43 84 2 1931211248 6063184 12126016
23:28:46 72373 8192000000 10856754832 11285438464 1922842192 19.010 100 33 68 1 1944096800 11932896 9321712
23:30:08 8421 8192000000 10862893136 11293614080 1940723296 19.153 100 58 116 1 1966672432 9848848 16100288
23:30:24 32655 8192000000 10875783392 11305361408 1944272528 19.181 100 44 88 2 1965171088 8741744 12156816
23:31:02 18943 8192000000 10884105904 11316396032 1950109888 19.227 100 41 82 1 1972939344 10682384 12147072
23:31:28 3274 8192000000 10899443088 11323158528 1960979600 19.314 100 54 106 1 1987395536 11306320 15109616
23:31:40 14737 8192000000 10896721536 11328864256 1962399344 19.325 100 55 106 1 1988892816 11846480 14646992
23:32:12 20593 8192000000 10894730528 11329372160 1948117392 19.211 99 54 107 1 1977233552 13712896 15403264
23:32:40 6968 8192000000 10904376640 11329093632 1961927024 19.321 100 53 106 0 1991267952 13762704 15578224
23:32:57 3630 8192000000 10910563520 11337330688 1966103744 19.355 100 58 116 0 1995569328 12672016 16793568
23:33:09 18439 8192000000 10923411488 11348328448 1970024896 19.386 100 53 106 0 2000143872 14858880 15260096
23:33:45 5216 8192000000 10922803280 11354447872 1985093824 19.505 100 60 120 3 2017069776 13960800 18015152
23:33:56 4858 8192000000 10916491040 11342249984 1965446352 19.349 99 61 119 2 1996515824 13636720 17432752
23:34:09 6256 8192000000 10916391760 11342962688 1974146640 19.418 100 59 118 0 2005849392 14895840 16806912
23:34:22 5167 8192000000 10926286912 11349725184 1979860384 19.464 100 64 128 0 2014120208 15744736 18515088
23:34:43 15258 8192000000 10925908992 11355631616 1982110928 19.481 100 58 115 0 2015498256 16155024 17232304
23:35:07 3113 8192000000 10935862400 11362566144 1989141424 19.537 100 62 124 1 2025537232 16743888 19651920
23:35:20 8296 8192000000 10937251600 11369254912 1993151840 19.569 100 56 110 1 2026897040 16813808 16931392
23:35:37 3901 8192000000 10948242928 11368812544 1993208368 19.569 100 68 136 2 2031585616 18611616 19765632
23:35:50 8738 8192000000 10941664800 11369336832 1994001472 19.575 100 66 132 1 2033768624 20188192 19578960
23:36:09 1273 8192000000 10945275760 11364495360 1985887248 19.511 100 76 151 2 2027767328 20242912 21637168
23:36:18 4893 8192000000 10945208256 11364077568 1971544608 19.398 99 78 156 1 2013597072 19256000 22796464
23:36:34 9342 8192000000 10941743344 11361517568 1988110816 19.529 100 72 144 1 2028707360 20590240 20006304
23:36:50 8945 8192000000 10944082528 11370491904 1992657568 19.565 100 68 136 3 2033648768 19857248 21133952
23:37:06 6759 8192000000 10917121296 11341381632 1957139296 19.283 98 57 114 1 1992377088 18387088 16850704
23:37:21 9918 8192000000 10936433344 11370647552 1995013072 19.583 100 62 122 5 2031786288 18939136 17834080
23:37:39 2262 8192000000 10958738704 11372335104 1997891968 19.606 100 79 159 1 2040885712 19648496 23345248
23:37:47 13172 8192000000 10947650848 11372670976 1991446240 19.555 100 74 143 3 2033363776 20796032 21121504
23:38:10 6976 8192000000 10947587472 11370496000 1978594240 19.454 99 72 146 1 2022322992 22233760 21494992
23:38:25 4677 8192000000 10941905680 11372576768 1991663344 19.557 100 66 132 0 2034520192 23068816 19788032
23:38:38 2087 8192000000 10959780208 11378171904 1993994928 19.575 100 73 147 1 2039836032 24059264 21781840
23:38:49 2253 8192000000 10954719216 11378405376 1989452560 19.539 99 77 154 0 2035695040 24040128 22202352
23:38:58 7078 8192000000 10957372720 11374952448 1989496144 19.540 99 77 152 2 2036021600 24508624 22016832
23:39:12 2944 8192000000 10962090240 11391156224 1995123040 19.584 99 71 141 1 2044293776 28451296 20719440
23:39:22 3626 8192000000 10959285952 11380285440 1982331856 19.483 99 76 152 1 2035112128 29097664 23682608
23:39:33 3089 8192000000 10922073776 11336839168 1946060320 19.195 98 73 143 2 1998416352 30032480 22323552
23:39:43 7283 8192000000 10931958368 11359158272 1972813920 19.408 100 53 106 1 2018813072 28980144 17019008
23:40:02 9231 8192000000 10930163344 11364986880 1975782544 19.431 100 56 110 1 2023029376 29186080 18060752
23:40:27 2847 8192000000 10913098624 11326472192 1944757568 19.185 99 76 151 0 1998610320 29654496 24198256
23:40:36 10159 8192000000 10924038368 11341357056 1956676336 19.280 100 59 114 1 2005369696 31066768 17626592
23:40:54 7517 8192000000 10929292496 11347828736 1941406800 19.158 99 62 124 2 1996498240 35226096 19865344
23:41:13 7417 8192000000 10939161488 11358113792 1966544544 19.358 100 66 130 3 2021034160 34213488 20276128
23:41:30 12476 8192000000 10925610848 11347279872 1933232976 19.093 98 52 104 0 1986698752 37360832 16104944
23:41:53 7085 8192000000 10939899888 11363360768 1967067472 19.362 100 53 104 4 2021921664 39159744 15694448
23:42:11 4330 8192000000 10917554576 11342270464 1932556176 19.087 98 59 118 0 1989698992 37754688 19388128
23:42:26 15503 8192000000 10931486048 11347087360 1942359936 19.166 99 54 108 1 1995676480 36599872 16716672
23:42:49 4421 8192000000 10917688624 11337342976 1948987024 19.218 100 63 125 4 2008455584 39349600 20118960
23:43:00 13970 8192000000 10926963648 11348070400 1931801456 19.081 99 53 105 2 1988955088 40537136 16616496
23:43:23 9680 8192000000 10901304784 11327004672 1928113808 19.052 99 52 104 0 1987061408 42228256 16719344
23:43:41 13667 8192000000 10918693856 11353178112 1932277792 19.085 99 46 91 1 1988965424 41688544 14999088
23:44:09 3027 8192000000 10928622400 11353948160 1954939888 19.266 100 59 116 0 2014725712 40456448 19329376
23:44:20 4030 8192000000 10933706352 11356790784 1957604864 19.287 100 59 115 1 2017040688 41108928 18326896
23:44:38 3575 8192000000 10937100672 11361931264 1962572560 19.326 100 60 117 0 2017748240 35876464 19299216
23:44:50 10081 8192000000 10930675472 11353563136 1940660544 19.152 99 65 129 1 1998695264 37921296 20113424
23:45:08 5320 8192000000 10929269776 11353911296 1956921360 19.282 100 58 117 3 2015303552 39985344 18396848
23:45:21 2423 8192000000 10947064368 11359670272 1959750000 19.304 100 77 153 0 2026281744 41215552 25316192
23:45:32 4743 8192000000 10924298288 11346366464 1945983936 19.194 100 73 144 1 2009073824 39923776 23166112
23:45:50 4430 8192000000 10924637024 11343605760 1947739984 19.208 100 74 147 0 2011906688 40579056 23587648
23:46:01 2831 8192000000 10920869056 11324772352 1927769632 19.049 99 84 167 3 1995271808 41546672 25955504
23:46:13 5165 8192000000 10938776192 11351539712 1950713664 19.232 100 80 159 1 2018771392 42868736 25188992
23:46:25 2061 8192000000 10911707536 11324809216 1922468080 19.007 99 78 156 2 1990988608 43570352 24950176
23:46:44 2325 8192000000 10902285264 11317878784 1920467392 18.991 100 65 125 0 1983489328 42959200 20062736
23:46:56 7639 8192000000 10884747136 11309498368 1914225088 18.941 100 69 136 0 1978389456 41735408 22428960
23:47:15 5453 8192000000 10912188832 11332751360 1936509440 19.119 100 67 133 1 1999651952 42633056 20509456
23:47:29 2471 8192000000 10933839360 11349266432 1952451200 19.246 100 94 187 1 2018519648 39000928 27067520
23:47:38 3896 8192000000 10918337488 11340890112 1944341056 19.181 100 65 130 0 2002205424 38325792 19538576
23:48:00 5900 8192000000 10879438176 11322019840 1927704704 19.049 100 30 60 1 1966569376 28634224 10230448
23:48:40 12671 8192000000 10887541376 11333746688 1918154928 18.972 99 23 46 0 1955475648 29434672 7886048
23:49:11 20517 8192000000 10888420368 11331133440 1923149072 19.012 99 27 54 1 1961468608 29328528 8991008
23:49:47 20251 8192000000 10875626736 11326558208 1901053584 18.835 98 27 54 2 1941494256 31649264 8791408
23:50:13 10260 8192000000 10889901856 11325550592 1925879936 19.034 100 53 106 1 1975728576 33786880 16061760
23:50:31 25428 8192000000 10849626432 11299209216 1869596560 18.581 98 26 52 2 1916622496 37738192 9287744
23:51:03 15662 8192000000 10861060112 11298209792 1883192416 18.691 99 25 50 2 1927694160 35599584 8902160
23:51:31 11006 8192000000 10879724272 11320385536 1910346624 18.909 100 37 73 1 1959042496 35904400 12791472
23:51:54 8727 8192000000 10887939328 11328802816 1926331024 19.038 100 41 82 0 1974793440 34286928 14175488
23:52:12 23515 8192000000 10889975248 11338883072 1930630512 19.072 100 24 48 0 1973000736 33808736 8561488
23:52:42 16091 8192000000 10894353824 11343699968 1935884208 19.114 100 23 46 1 1981262304 36783520 8594576
23:53:05 19064 8192000000 10884015040 11338661888 1921609968 19.000 99 24 47 0 1965892704 36542160 7740576
23:53:30 30710 8192000000 10875058464 11335053312 1937368416 19.126 100 23 46 0 1966380880 21591952 7420512
23:54:24 101458 8192000000 10889043248 11345424384 1952729856 19.248 100 31 62 1 1980800768 17684048 10386864
23:56:13 44226 8192000000 10912754784 11351703552 1932907936 19.090 99 36 68 2 1963675584 20608976 10158672
23:57:07 33559 8192000000 10864596048 11324485632 1917385632 18.966 98 10 20 0 1933925440 14210880 2328928
23:58:00 60443 8192000000 10876339536 11351396352 1945765040 19.193 100 12 22 2 1963245856 14874544 2606272
23:59:16 19567 8192000000 10878544144 11334696960 1935294640 19.109 99 10 20 0 1950801232 12514144 2992448
23:59:42 37828 8192000000 10907367472 11349741568 1969664240 19.383 100 40 78 1 1988089216 7183616 11241360
00:00:47 76525 8192000000 10893776336 11354570752 1950076016 19.227 99 17 34 0 1966718528 11785696 4856816
00:02:19 24761 8192000000 10908702704 11369283584 1981682544 19.478 100 17 34 1 1996080160 9789136 4608480
00:02:51 54100 8192000000 10913330368 11380621312 1964900480 19.345 99 13 26 0 1984044048 15451072 3692496
00:03:54 84432 8192000000 10917457824 11374346240 1982675568 19.486 100 14 28 1 1997643888 11342096 3626224
00:05:25 84153 8192000000 10923908928 11379122176 1974910064 19.424 99 23 46 2 1989358448 7444784 7003600
00:07:28 28359 8192000000 10925135648 11387813888 1991087920 19.552 100 12 24 1 2007691200 12934256 3669024
00:08:15 49775 8192000000 10931077088 11395112960 1970421424 19.389 99 21 37 1 1990960544 15501152 5037968
00:09:17 72231 8192000000 10915628192 11388989440 1970616592 19.390 99 12 24 1 1993737120 19372704 3747824
00:10:36 137275 8192000000 10935803392 11409080320 1992623392 19.565 100 10 20 0 2017560912 22380896 2556624
00:12:59 40809 8192000000 10907980528 11374358528 1942006704 19.163 97 14 28 0 1957650272 11944480 3699088
00:14:28 94429 8192000000 10925346736 11390763008 1907581008 18.887 96 10 20 0 1927181824 16278240 3322576
00:16:28 128118 8192000000 10906621408 11367292928 1923447712 19.014 97 10 20 1 1945048912 18905712 2695488
00:18:51 38916 8192000000 10897108224 11356524544 1940886912 19.154 98 32 63 0 1956132960 5948224 9297824
00:19:38 40602 8192000000 10885651952 11341398016 1898323440 18.813 96 46 90 1 1923906944 12248256 13335248
00:20:35 76104 8192000000 10914812576 11379298304 1967381808 19.365 100 38 76 1 1995878048 17993968 10502272
00:21:59 57582 8192000000 10905190368 11368759296 1951692752 19.240 98 16 32 1 1967140096 10728576 4718768
00:23:02 41986 8192000000 10920313744 11378122752 1964890768 19.345 99 31 61 1 1986285744 12804560 8590416
00:23:51 29744 8192000000 10885393056 11341905920 1914153648 18.940 97 29 58 1 1938989120 16270688 8564784
00:24:53 25327 8192000000 10885777216 11342016512 1940394960 19.150 99 36 71 3 1967065584 15941216 10729408
00:25:27 13113 8192000000 10929017760 11371036672 1965851056 19.353 100 61 119 2 2000830080 17774480 17204544
00:25:47 41969 8192000000 10864949312 11345793024 1884387344 18.701 96 21 42 1 1910040768 19257568 6395856
00:26:42 65615 8192000000 10868649264 11334541312 1899839344 18.825 97 21 42 0 1913100288 7589696 5671248
00:27:55 20792 8192000000 10872648704 11343921152 1949991440 19.226 100 6 12 0 1958958592 7564608 1402544
00:28:34 19646 8192000000 10881624560 11353120768 1961545328 19.318 100 8 16 0 1972121280 8212032 2363920
00:30:34 49235 8192000000 10887772784 11364458496 1949530688 19.223 99 23 46 0 1967179392 11177472 6471232
00:31:40 67161 8192000000 10869456736 11358801920 1884494656 18.701 96 9 18 0 1902994624 15937616 2562352
00:32:56 48351 8192000000 10881838288 11337908224 1879389792 18.660 96 14 27 0 1894494240 11926240 3178208
00:33:52 30483 8192000000 10869290112 11341041664 1911993712 18.923 98 18 34 0 1929546208 13008528 4543968
00:34:43 54553 8192000000 10892761680 11348344832 1922943680 19.010 98 28 54 2 1940964560 9814224 8206656
00:35:48 39148 8192000000 10892279664 11362664448 1960585408 19.311 100 39 78 0 1988061424 15313008 12163008
00:36:42 50913 8192000000 10867872528 11341299712 1877019600 18.641 96 16 32 1 1892306608 10665744 4621264
00:37:42 44259 8192000000 10868534192 11326296064 1889310896 18.740 97 37 69 3 1909616496 10591264 9714336
00:38:39 18098 8192000000 10872693472 11321532416 1904663440 18.864 98 35 70 0 1925177264 10437664 10076160
00:39:07 45250 8192000000 10870351360 11336429568 1917951920 18.970 99 21 42 1 1935240016 11323088 5965008
00:40:11 51170 8192000000 10850715856 11307294720 1870229440 18.586 97 16 32 2 1883380224 8411376 4739408
00:41:12 49710 8192000000 10855816720 11317297152 1853493568 18.450 96 25 50 1 1871635952 11003584 7138800
00:42:13 23320 8192000000 10873087792 11322757120 1910909568 18.914 99 38 75 1 1933438976 11051152 11478256
00:42:53 77326 8192000000 10878181824 11342716928 1935732576 19.113 100 12 24 0 1951126752 12077072 3317104
00:44:17 49428 8192000000 10849471264 11312582656 1898094592 18.811 98 12 24 2 1910420912 8732144 3594176
00:45:16 20595 8192000000 10879102672 11329114112 1917926336 18.970 99 24 48 0 1932758272 8784960 6046976
00:46:09 87158 8192000000 10890615776 11334238208 1939636096 19.144 100 44 88 1 1969277312 16652624 12988592
00:48:38 38463 8192000000 10888276928 11338989568 1924384640 19.022 99 21 43 0 1937119424 6508288 6226496
00:49:27 51017 8192000000 10888044720 11335475200 1945523232 19.191 100 57 114 0 1972023952 10125584 16375136
00:50:25 8945 8192000000 10886826960 11343421440 1951363120 19.237 100 44 87 1 1974028848 10902624 11763104
00:50:49 61116 8192000000 10877285392 11360370688 1955406032 19.270 100 27 53 2 1979362640 15828736 8127872
00:52:31 67970 8192000000 10892878640 11362840576 1945606144 19.191 99 21 43 2 1966697568 14724544 6366880
00:54:38 71868 8192000000 10887707680 11365863424 1944235312 19.181 99 15 30 1 1964777216 15634752 4907152
00:56:02 41134 8192000000 10882770592 11361017856 1958408080 19.293 100 9 18 1 1968313072 7687936 2217056
00:56:54 39991 8192000000 10918862912 11387162624 1981395200 19.476 100 18 36 0 1993484224 7654352 4434672
00:57:40 78658 8192000000 10938191728 11394904064 1988243552 19.530 100 20 38 0 2008940592 15668144 5028896
00:59:05 74173 8192000000 10919083120 11403067392 1997044064 19.599 100 14 28 0 2016230480 14909696 4276720
01:00:27 47207 8192000000 10909413152 11377844224 1900876224 18.833 95 19 38 0 1916867728 10675760 5315744
01:01:27 41679 8192000000 10928806672 11399061504 1984711616 19.502 100 8 16 0 1996361408 9321824 2327968
01:02:20 111268 8192000000 10934106512 11400888320 1974726640 19.423 99 12 24 1 1989318016 10800288 3791088
01:04:25 45071 8192000000 10915311712 11376201728 1928673424 19.056 97 17 34 2 1944426064 11069456 4683184
01:05:25 69495 8192000000 10918370224 11379339264 1919937376 18.986 97 22 44 1 1942798880 16323024 6538480
01:06:43 88801 8192000000 10900014960 11356090368 1857433440 18.482 94 7 14 0 1877158784 17701904 2023440
01:08:20 26363 8192000000 10908894528 11352555520 1939213536 19.140 99 31 62 1 1959780768 11744576 8822656
01:08:58 71952 8192000000 10865368544 11341172736 1835961840 18.308 94 16 32 1 1853378560 13429568 3987152
01:10:16 133670 8192000000 10878454912 11354357760 1903634032 18.856 97 14 28 0 1920936512 13479904 3822576
01:13:00 100698 8192000000 10859329808 11343441920 1861698624 18.517 95 27 52 1 1883922320 14560576 7663120
01:15:10 39155 8192000000 10850705888 11314167808 1870637552 18.589 97 16 32 0 1890717920 15514624 4565744
01:16:01 70983 8192000000 10853363648 11335725056 1919912768 18.986 99 14 28 2 1942974224 18613776 4447680
01:17:49 98144 8192000000 10870437968 11340263424 1919744640 18.985 99 14 28 1 1936586896 13051504 3790752
01:20:52 67189 8192000000 10880870960 11359928320 1957043696 19.283 100 15 31 1 1975882144 14384640 4453808
01:22:08 61346 8192000000 10849660544 11334791168 1874995584 18.625 96 9 18 0 1887366352 9526832 2843936
01:23:16 65299 8192000000 10875879840 11346075648 1913172000 18.932 98 16 32 0 1926584720 9136400 4276320
01:24:33 80996 8192000000 10872562864 11357917184 1928412816 19.054 99 9 17 1 1942123264 11122048 2588400
01:26:05 41783 8192000000 10873025376 11340947456 1899004288 18.818 97 29 53 4 1913707520 6944416 7758816
01:27:06 14055 8192000000 9212383360 9460043776 369971136 4.321 20 2 3 0 372892224 2502496 418592

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 113 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

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

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          244475
MON$OLDEST_ACTIVE               244476
MON$OLDEST_SNAPSHOT             244476
MON$NEXT_TRANSACTION            244476
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                       2040928
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 ---
:325: 
:326: mscs-test-161.budzdorov.ru    Mon Jan  4 01:27:27 2021
:327:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:328: 
--- end of diff output ---

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

04.01.21 01:29:20. 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-04 01:29:23 No severe PSQL-related problems occured
04.01.21 01:29:24. End of report.