Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 20.02.2021 22:29
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 17032608 kB
MemAvailable 31163264 kB
Buffers 0 kB
Cached 14692308 kB
SwapCached 3892 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-20 22:27:19
DTS_END                         2021-02-20 22:27:19.5650
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_INVOICE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/60312
TRN_ID                          246696
ATT_ID                          689
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: 9295.86 23491 1115503
customer order: creation 180.09 330 21611
customer order: refuse 15.98 334 1917
order to supplier: creation 48.56 1264 5827
order to supplier: removal 3.13 115843 375
invoice (draft): creation 48.64 3303 5837
invoice (draft): removal 50.53 912 6064
invoice accept: apply 44.11 17407 5293
invoice accept: cancel 45.48 811 5458
customer reserve: creation 4085.83 172 490299
customer reserve: removal 4466.22 63 535946
realization accept: apply 86.71 166 10405
realization accept: cancel 85.45 106 10254
payment from customer: creation 61.84 116 7421
payment from customer: removal 5.82 72 698
payment to supplier: creation 51.41 131 6169
payment to supplier: removal 3.79 60 455
service: total inventory turnovers 4.92 943 590
service: total monetary turnovers 6.49 27 779
service: aggregate perf. data 0.84 15078 101
service: refresh index statistics 0.03 312685 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-02-2021 22:29:28 to 20-02-2021 22:29:30.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 318
TEST_TIME 2 1527
TEST_TIME 3 2562
TEST_TIME 4 3581
TEST_TIME 5 3628
TEST_TIME 6 4008
TEST_TIME 7 4374
TEST_TIME 8 4773
TEST_TIME 9 5229
TEST_TIME 10 5625
TEST_TIME 11 5568
TEST_TIME 12 5684
TEST_TIME 13 5662
TEST_TIME 14 5907
TEST_TIME 15 6389
TEST_TIME 16 6759
TEST_TIME 17 7394
TEST_TIME 18 7657
TEST_TIME 19 8764
TEST_TIME 20 8802
TEST_TIME 21 9000
TEST_TIME 22 8899
TEST_TIME 23 8793
TEST_TIME 24 8918
TEST_TIME 25 9262
TEST_TIME 26 9551
TEST_TIME 27 10223
TEST_TIME 28 10909
TEST_TIME 29 10828
TEST_TIME 30 10579
TEST_TIME 31 10748
TEST_TIME 32 10548
TEST_TIME 33 10480
TEST_TIME 34 10536
TEST_TIME 35 10650
TEST_TIME 36 10512
TEST_TIME 37 10311
TEST_TIME 38 10156
TEST_TIME 39 9968
TEST_TIME 40 9947
TEST_TIME 41 9898
TEST_TIME 42 9865
TEST_TIME 43 9853
TEST_TIME 44 9866
TEST_TIME 45 9824
TEST_TIME 46 9716
TEST_TIME 47 9594
TEST_TIME 48 9580
TEST_TIME 49 9477
TEST_TIME 50 9578
TEST_TIME 51 9532
TEST_TIME 52 9515
TEST_TIME 53 9559
TEST_TIME 54 9626
TEST_TIME 55 9586
TEST_TIME 56 9609
TEST_TIME 57 9702
TEST_TIME 58 9656
TEST_TIME 59 9745
TEST_TIME 60 9698
TEST_TIME 61 9698
TEST_TIME 62 9748
TEST_TIME 63 9779
TEST_TIME 64 9809
TEST_TIME 65 9866
TEST_TIME 66 9886
TEST_TIME 67 9880
TEST_TIME 68 9781
TEST_TIME 69 9732
TEST_TIME 70 9651
TEST_TIME 71 9656
TEST_TIME 72 9625
TEST_TIME 73 9539
TEST_TIME 74 9554
TEST_TIME 75 9529
TEST_TIME 76 9461
TEST_TIME 77 9443
TEST_TIME 78 9527
TEST_TIME 79 9561
TEST_TIME 80 9540
TEST_TIME 81 9491
TEST_TIME 82 9590
TEST_TIME 83 9579
TEST_TIME 84 9587
TEST_TIME 85 9560
TEST_TIME 86 9596
TEST_TIME 87 9555
TEST_TIME 88 9614
TEST_TIME 89 9739
TEST_TIME 90 9715
TEST_TIME 91 9633
TEST_TIME 92 9599
TEST_TIME 93 9535
TEST_TIME 94 9542
TEST_TIME 95 9500
TEST_TIME 96 9482
TEST_TIME 97 9427
TEST_TIME 98 9409
TEST_TIME 99 9422
TEST_TIME 100 9387
TEST_TIME 101 9376
TEST_TIME 102 9383
TEST_TIME 103 9352
TEST_TIME 104 9445
TEST_TIME 105 9462
TEST_TIME 106 9491
TEST_TIME 107 9461
TEST_TIME 108 9459
TEST_TIME 109 9515
TEST_TIME 110 9509
TEST_TIME 111 9526
TEST_TIME 112 9501
TEST_TIME 113 9462
TEST_TIME 114 9434
TEST_TIME 115 9384
TEST_TIME 116 9421
TEST_TIME 117 9388
TEST_TIME 118 9324
TEST_TIME 119 9285
TEST_TIME 120 9296

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 20-02-2021 22:29:32 to 20-02-2021 22:29:35.

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 1569544 1569544 0 0.00 0 14456 6 0 0
doc_list_biud 1569544 1569544 0 0.00 0 30176 28 0 0
sp_add_invoice_to_stock 5468 5293 175 3.20 43 164420 17407 0 175
sp_cancel_adding_invoice 5458 5458 0 0.00 4 62034 811 0 0
sp_cancel_client_order 1917 1917 0 0.00 5 11531 335 0 0
sp_cancel_customer_reserve 535946 535946 0 0.00 1 28948 63 0 0
sp_cancel_pay_from_customer 698 698 0 0.00 3 4443 72 0 0
sp_cancel_pay_to_supplier 455 455 0 0.00 2 1064 61 0 0
sp_cancel_supplier_invoice 6072 6064 8 0.13 2 25865 913 0 8
sp_cancel_supplier_order 375 375 0 0.00 6 1024883 115844 0 0
sp_cancel_write_off 10254 10254 0 0.00 1 7787 106 0 0
sp_client_order 21611 21611 0 0.00 3 35608 330 0 0
sp_customer_reserve 490299 490299 0 0.00 0 59483 172 0 0
sp_fill_shopping_cart 33258 33258 0 0.00 1 13691 41 0 0
sp_fill_shopping_cart_clo_res 490297 490297 0 0.00 0 24557 13 0 0
sp_get_clo_for_invoice 5291 5291 0 0.00 0 29973 312 0 0
sp_kill_cost_storno 16865 16865 0 0.00 0 12882 59 0 0
sp_kill_qstorno_ret_qs2qd 1088585 1088585 0 0.00 0 28944 35 0 0
sp_kill_qty_storno 575710 575710 0 0.00 0 30174 74 0 0
sp_lock_selected_doc 21792 21792 0 0.00 0 8025 6 0 0
sp_make_cost_storno 29286 29286 0 0.00 0 14453 51 0 0
sp_multiply_rows_for_pdistr 29286 29286 0 0.00 0 7885 26 0 0
sp_multiply_rows_for_qdistr 21611 21611 0 0.00 0 18720 145 0 0
sp_pay_from_customer 7421 7421 0 0.00 4 19299 116 0 0
sp_pay_to_supplier 6169 6169 0 0.00 4 19524 131 0 0
sp_payment_common 13590 13590 0 0.00 1 5857 23 0 0
sp_qd_handle_on_cancel_clo 1917 1917 0 0.00 0 11524 306 0 0
sp_qd_handle_on_invoice_upd_sts 10749 10749 0 0.00 0 30174 323 0 0
sp_qd_handle_on_reserve_upd_sts 10405 10405 0 0.00 0 27890 57 0 0
sp_reserve_write_off 10405 10405 0 0.00 6 27920 166 0 0
sp_supplier_invoice 5837 5837 0 0.00 8 106914 3303 0 0
sp_supplier_order 5827 5827 0 0.00 5 33599 1264 0 0
srv_aggregate_perf_data 101 101 0 0.00 2464 92927 15078 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 1180 152656 33262 0 0
srv_find_qd_qs_mism 1065264 1065264 0 0.00 0 12396 6 0 0
srv_make_invnt_saldo 590 590 0 0.00 26 34707 944 0 0
srv_make_money_saldo 779 779 0 0.00 1 4360 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 87422 412550 312686 0 0
t$perf-abend:sp_add_invoice_to_stock 175 175 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5293 5293 0 0.00 0 14396 175 0 0
t$perf-norm:sp_cancel_adding_invoice 421 421 0 0.00 0 3511 105 0 0
t$perf-norm:sp_cancel_client_order 1917 1917 0 0.00 0 6171 14 0 0
t$perf-norm:sp_cancel_customer_reserve 741 741 0 0.00 0 1176 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 698 698 0 0.00 0 7594 18 0 0
t$perf-norm:sp_cancel_pay_to_supplier 455 455 0 0.00 0 711 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 403 403 0 0.00 0 2933 18 0 0
t$perf-norm:sp_cancel_supplier_order 375 375 0 0.00 0 46508 2098 0 0
t$perf-norm:sp_cancel_write_off 1086 1086 0 0.00 0 4953 17 0 0
t$perf-norm:sp_client_order 21611 21611 0 0.00 0 9611 19 0 0
t$perf-norm:sp_customer_reserve 1011 1011 0 0.00 0 3091 6 0 0
t$perf-norm:sp_pay_from_customer 7421 7421 0 0.00 0 11275 11 0 0
t$perf-norm:sp_pay_to_supplier 6169 6169 0 0.00 0 9898 17 0 0
t$perf-norm:sp_reserve_write_off 10405 10405 0 0.00 0 8330 16 0 0
t$perf-norm:sp_supplier_invoice 5837 5837 0 0.00 0 10846 17 0 0
t$perf-norm:sp_supplier_order 5827 5827 0 0.00 0 8621 19 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 552 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 876 11 0 0
t$perf-norm:srv_make_invnt_saldo 590 590 0 0.00 0 6013 39 0 0
t$perf-norm:srv_make_money_saldo 779 779 0 0.00 0 7295 26 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 15 6 0 0
v_add_invoice_to_stock 10932 10582 350 3.20 0 5622 18 0 350
v_all_customers 39322 39322 0 0.00 0 17 1 0 0
v_all_suppliers 32362 32362 0 0.00 0 16 1 0 0
v_all_wares 43222 43222 0 0.00 0 109 1 0 0
v_cancel_adding_invoice 842 842 0 0.00 0 2663 10 0 0
v_cancel_client_order 3834 3834 0 0.00 0 1923 4 0 0
v_cancel_customer_prepayment 1396 1396 0 0.00 0 994 3 0 0
v_cancel_customer_reserve 1482 1482 0 0.00 0 3334 7 0 0
v_cancel_payment_to_supplier 910 910 0 0.00 0 920 6 0 0
v_cancel_supplier_invoice 822 806 16 1.94 0 2131 18 0 16
v_cancel_supplier_order 750 750 0 0.00 0 953 8 0 0
v_cancel_write_off 2172 2172 0 0.00 0 1852 13 0 0
v_max_id_clo_ord 5827 5827 0 0.00 0 1976 2 0 0
v_max_id_clo_res 1011 1011 0 0.00 0 5400 18 0 0
v_max_id_ord_sup 5820 5820 0 0.00 0 2748 3 0 0
v_max_non_paid_invoice 1635 1635 0 0.00 0 4461 7 0 0
v_max_non_paid_realizn 3984 3984 0 0.00 0 4800 4 0 0
v_min_id_clo_ord 5827 5827 0 0.00 0 2473 5 0 0
v_min_id_clo_res 1011 1011 0 0.00 0 7015 20 0 0
v_min_id_ord_sup 5820 5820 0 0.00 0 5655 10 0 0
v_min_non_paid_invoice 6169 6169 0 0.00 0 5853 15 0 0
v_min_non_paid_realizn 7421 7421 0 0.00 0 5498 15 0 0
v_our_firm 10774 10774 0 0.00 0 14 1 0 0
v_reserve_write_off 20810 20810 0 0.00 0 3339 6 0 0
x_lock_depdocs_on_canc_invoice 11119 11119 0 0.00 0 14142 129 0 0
x_lock_depdocs_on_canc_sup_ord 375 375 0 0.00 0 3300 328 0 0
x_make_qstorno_1000_1200 5827 5827 0 0.00 1 33584 1184 0 0
x_make_qstorno_1200_2000 5837 5837 0 0.00 4 106878 3149 0 0
x_make_qstorno_2100_3300 490299 490299 0 0.00 0 59481 157 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 20-02-2021 22:29:36 to 20-02-2021 22:29:40.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:23 6 8192000000 8804761792 8816918528 10492496 0.127 2 2 3 0 10682080 66144 123440
19:57:29 20914 8192000000 10264276144 10575568896 898799632 9.886 72 51 104 0 918694880 2482480 17412768
19:57:58 34315 8192000000 10371487600 10687361024 1399090032 14.587 100 79 158 0 1429077200 5283040 24704128
19:58:43 17263 8192000000 10392558816 10715324416 1449001808 15.029 100 89 179 1 1484448960 7086400 28360752
19:59:12 19816 8192000000 10422817440 10750255104 1469087808 15.206 100 91 182 0 1506187392 8051664 29047920
19:59:45 21926 8192000000 10439980208 10772705280 1489234576 15.382 100 88 176 1 1526267376 8868656 28164144
20:00:19 24094 8192000000 10460699536 10796380160 1513476416 15.594 100 91 182 0 1551800960 9767440 28557104
20:00:50 24495 8192000000 10488703024 10826752000 1531984704 15.754 100 88 176 0 1569196032 9978016 27233312
20:01:25 20544 8192000000 10501028848 10844737536 1555076592 15.954 100 85 170 0 1592179216 10732368 26370256
20:01:53 15581 8192000000 10528715968 10875133952 1573833152 16.115 100 87 173 2 1611515536 11174240 26508144
20:02:18 17062 8192000000 10539070032 10892488704 1591571584 16.267 100 76 152 1 1625128832 10837296 22719952
20:02:46 11440 8192000000 10565853200 10918236160 1617635136 16.490 100 87 174 1 1655083600 11187456 26261008
20:03:10 11578 8192000000 10586568816 10943516672 1633714528 16.626 100 89 176 1 1671486960 11652048 26120384
20:03:31 9269 8192000000 10596675712 10955374592 1652055952 16.782 100 83 166 0 1688714576 12404304 24254320
20:03:47 7286 8192000000 10596588480 10964480000 1666609648 16.905 100 77 153 3 1700793872 11980848 22203376
20:04:01 9343 8192000000 10615249376 10981900288 1673878304 16.966 100 80 160 0 1709598048 12621744 23098000
20:04:19 7385 8192000000 10620418128 10989506560 1687721360 17.082 100 85 170 0 1725462352 13370624 24370368
20:04:33 7232 8192000000 10636381264 11009286144 1698534816 17.173 100 76 152 0 1732541504 12205520 21801168
20:04:48 5231 8192000000 10644392304 11017154560 1708739744 17.258 100 76 152 0 1742601424 11360448 22501232
20:05:01 9937 8192000000 10670511728 11043016704 1730361888 17.439 100 84 168 0 1766616864 12222800 24032176
20:05:20 5001 8192000000 10691854944 11065606144 1744456240 17.556 100 81 159 0 1778577664 11788688 22332736
20:05:32 4189 8192000000 10690739536 11066724352 1756703488 17.657 100 85 167 2 1793077136 13150192 23223456
20:05:44 4800 8192000000 10704113664 11081121792 1763292560 17.712 100 89 178 1 1801479168 13095792 25090816
20:05:56 4991 8192000000 10716187888 11095506944 1771443584 17.779 100 80 158 3 1804967424 12178208 21345632
20:06:10 4464 8192000000 10724482800 11103002624 1784085504 17.883 100 83 166 1 1820365792 12794896 23485392
20:06:21 2930 8192000000 10738462128 11116068864 1800251824 18.016 100 85 170 2 1836620464 12532128 23836512
20:06:31 10320 8192000000 10727593600 11114930176 1795493264 17.977 100 63 122 2 1823841088 11450992 16896832
20:06:50 3321 8192000000 10756676912 11140820992 1808194608 18.081 100 90 180 1 1845670160 11969120 25506432
20:07:00 2335 8192000000 10769042560 11150032896 1829347456 18.254 100 93 186 0 1868340976 12782960 26210560
20:07:09 2864 8192000000 10766759360 11150258176 1830057392 18.260 100 88 178 0 1868786944 13589536 25140016
20:07:20 1952 8192000000 10778978816 11163480064 1834081936 18.293 100 85 170 2 1870919008 13115632 23721440
20:07:28 2028 8192000000 10777947024 11164528640 1838373584 18.328 100 87 172 0 1876731536 14308464 24049488
20:07:37 2656 8192000000 10783667456 11170185216 1843039760 18.366 100 89 177 0 1881606272 13334240 25232272
20:07:46 2362 8192000000 10795132304 11179016192 1849456720 18.418 100 91 183 0 1889854832 14796208 25601904
20:07:54 1846 8192000000 10800525920 11187105792 1857006672 18.479 100 90 174 2 1895604496 14099488 24498336
20:08:03 2094 8192000000 10806862432 11193360384 1863996672 18.536 100 91 180 1 1903055184 13934992 25123520
20:08:11 1810 8192000000 10806811216 11197730816 1866193744 18.553 100 93 185 3 1905697776 13142928 26361104
20:08:21 1952 8192000000 10812197872 11204100096 1867194272 18.562 100 88 176 1 1906595328 14430064 24970992
20:08:29 2317 8192000000 10804108512 11199553536 1870406896 18.588 100 84 168 1 1906877792 12747312 23723584
20:08:38 1366 8192000000 10815246240 11207454720 1874084624 18.617 100 89 179 0 1912696528 12210848 26401056
20:08:45 36506 8192000000 10801824608 11204579328 1866820448 18.559 100 50 101 2 1890716576 9578208 14317920
20:09:28 7285 8192000000 10789953392 11203276800 1869113648 18.577 100 35 70 0 1886576080 7660544 9801888
20:09:44 5836 8192000000 10784266032 11206565888 1870405984 18.588 100 30 58 3 1886037616 7689408 7942224
20:09:58 6933 8192000000 10777967856 11210280960 1875221040 18.626 100 30 60 1 1891312736 7501824 8589872
20:10:13 9944 8192000000 10787882048 11215740928 1877284000 18.643 100 30 60 2 1892163136 6240384 8638752
20:10:30 6260 8192000000 10787390416 11215798272 1877413248 18.644 100 17 32 1 1887970672 6144432 4412992
20:10:43 8129 8192000000 10791570512 11218214912 1877365680 18.644 100 14 28 0 1887307280 5837344 4104256
20:11:00 8054 8192000000 10796524144 11220979712 1884341152 18.700 100 23 46 1 1896701120 5893552 6466416
20:11:15 3749 8192000000 10804498048 11226468352 1886526752 18.718 100 31 60 3 1901292512 6309232 8456528
20:11:25 5611 8192000000 10796546400 11227668480 1887995392 18.730 100 22 44 0 1901658624 6457328 7205904
20:11:38 7464 8192000000 10798974832 11231117312 1890866576 18.753 100 24 48 0 1903859200 6487424 6505200
20:11:56 7159 8192000000 10803403968 11233292288 1895173376 18.787 100 21 43 2 1907394656 6511376 5709904
20:12:10 31098 8192000000 10808004144 11242123264 1892630672 18.767 100 20 40 1 1903504272 5718560 5155040
20:13:16 31048 8192000000 10813868592 11247337472 1899894064 18.825 100 28 56 1 1914248720 6457440 7897216
20:13:55 4389 8192000000 10825881360 11253870592 1903414736 18.854 100 31 63 3 1919290496 6805136 9070624
20:14:07 1797 8192000000 10843005344 11260694528 1913261360 18.933 100 58 116 4 1936791664 6290800 17239504
20:14:15 5821 8192000000 10818066816 11251167232 1903553104 18.855 100 18 36 0 1914496736 6089728 4853904
20:14:29 5818 8192000000 10837120512 11258613760 1911020720 18.915 100 32 64 3 1925307520 5534832 8751968
20:14:43 5534 8192000000 10841540608 11260715008 1907343376 18.885 100 22 44 0 1920156512 6746496 6066640
20:14:55 9008 8192000000 10820617056 11258466304 1911211104 18.916 100 35 69 4 1928551728 7704608 9636016
20:15:11 5770 8192000000 10822879840 11259150336 1910427744 18.910 100 20 39 1 1921536560 5927472 5181344
20:15:23 6442 8192000000 10829884256 11263303680 1912586016 18.927 100 25 48 1 1924664064 5629648 6448400
20:15:37 11787 8192000000 10834009968 11265232896 1911420720 18.918 100 21 42 0 1927651968 9842352 6388896
20:15:56 7049 8192000000 10827142336 11263840256 1912118272 18.924 100 25 49 2 1925076736 6035472 6922992
20:16:13 13042 8192000000 10823585824 11268952064 1913808816 18.937 100 19 37 3 1924810880 5693152 5308912
20:16:32 11645 8192000000 10807998080 11244892160 1894478688 18.782 99 15 28 3 1903817296 5432624 3905984
20:16:50 21116 8192000000 10804885376 11235098624 1829262512 18.253 96 13 26 0 1838078032 5149232 3666288
20:17:17 60572 8192000000 10738323296 11174223872 1730750432 17.442 91 24 47 3 1743692240 4738016 8203792
20:18:24 8480 8192000000 10735674464 11156946944 1773571456 17.796 95 24 48 1 1786182896 5916496 6694944
20:18:39 7097 8192000000 10759255360 11185876992 1817400880 18.156 98 26 52 0 1831386752 6724288 7261584
20:18:55 6039 8192000000 10775376608 11188961280 1817755680 18.159 98 43 86 0 1841908432 12480384 11672368
20:19:08 5998 8192000000 10755913888 11179372544 1813295728 18.123 98 23 44 2 1826139936 5987504 6856704
20:19:20 6456 8192000000 10764897808 11182112768 1798343856 18.000 97 24 49 5 1810855952 5400368 7111728
20:19:33 7345 8192000000 10737397104 11160596480 1751316272 17.612 95 33 64 2 1765995024 6186208 8492544
20:19:49 4532 8192000000 10733518048 11149434880 1810333648 18.099 99 40 79 2 1827302784 5505632 11463504
20:20:02 5801 8192000000 10666081632 11073970176 1656434656 16.819 91 27 55 1 1669887056 5236880 8215520
20:20:16 7917 8192000000 10676612016 11090075648 1665971600 16.899 93 27 54 0 1679275072 5092336 8211136
20:20:30 4611 8192000000 10701767392 11111866368 1748751280 17.591 98 33 64 0 1765601984 7182128 9668576
20:20:44 4577 8192000000 10729181920 11139657728 1804881424 18.054 100 43 87 0 1823881632 5682448 13317760
20:20:55 7782 8192000000 10715028240 11138854912 1803120368 18.040 100 20 40 1 1815570272 6665712 5784192
20:21:10 13677 8192000000 10713950240 11129704448 1731931792 17.452 95 33 64 0 1747306992 5847808 9527392
20:21:30 9686 8192000000 10693411968 11106926592 1719156640 17.345 96 19 38 1 1730774224 5885088 5732496
20:21:46 11579 8192000000 10732743984 11145109504 1809022528 18.088 100 40 81 2 1826262032 5047472 12192032
20:22:07 60796 8192000000 10726152000 11145547776 1805498976 18.059 99 22 44 2 1817828720 5464400 6865344
20:23:15 14259 8192000000 10735017728 11152711680 1798812880 18.004 99 19 38 4 1808790736 4965568 5012288
20:23:38 4504 8192000000 10756076432 11172433920 1832796672 18.282 100 41 82 1 1852552432 8573264 11182496
20:23:49 2176 8192000000 10767036720 11181428736 1835339536 18.303 100 58 116 1 1865259936 13143200 16777200
20:24:00 10028 8192000000 10759109824 11185307648 1843157984 18.367 100 30 60 2 1858892944 5992704 9742256
20:24:17 4862 8192000000 10773475712 11191906304 1850052080 18.423 100 39 76 3 1868858240 7272400 11533760
20:24:28 9226 8192000000 10769789824 11195822080 1850692592 18.428 100 21 39 1 1861532736 5288256 5551888
20:24:46 7929 8192000000 10774374032 11205054464 1865170208 18.545 100 28 56 0 1878248416 4851280 8226928
20:25:01 9586 8192000000 10786729376 11207622656 1845958560 18.389 99 28 56 0 1859736016 5100432 8677024
20:25:23 11362 8192000000 10791384464 11213922304 1867145728 18.561 100 25 51 3 1880674464 5708992 7819744
20:25:42 10417 8192000000 10788966240 11218747392 1867677968 18.565 100 23 42 2 1880158720 5589440 6891312
20:26:03 13489 8192000000 10792975712 11220377600 1874744592 18.623 100 22 44 1 1887255696 5940784 6570320
20:26:23 8101 8192000000 10788151632 11224924160 1876147120 18.634 100 17 34 0 1887225856 5902992 5175744
20:26:37 18292 8192000000 10791812608 11224915968 1876512864 18.637 100 19 38 0 1887407920 5519600 5375456
20:27:04 152654 8192000000 10847615536 11271393280 1893865216 18.777 100 30 57 1 1907483728 5282080 8336432
20:29:44 36843 8192000000 10864103920 11290554368 1928596592 19.056 100 44 88 0 1950270288 9295744 12377952
20:30:38 38747 8192000000 10877486768 11310751744 1943290832 19.173 100 40 78 0 1966772208 11831984 11649392
20:31:24 30057 8192000000 10880241600 11315945472 1951289968 19.237 100 35 70 0 1974995072 13853008 9852096
20:32:03 12202 8192000000 10913058032 11334565888 1967904048 19.369 100 69 137 0 2006406208 18487920 20014240
20:32:28 13776 8192000000 10922535680 11345936384 1971518624 19.397 100 56 109 3 2007162416 19644128 15999664
20:32:50 8273 8192000000 10915597392 11345846272 1974140896 19.418 100 54 108 1 2010823792 20891136 15791760
20:33:12 15099 8192000000 10924001776 11354615808 1979917584 19.464 100 51 102 0 2016508672 21298496 15292592
20:33:34 6289 8192000000 10932491056 11360690176 1986140992 19.513 100 57 114 1 2023766272 20722016 16903264
20:33:47 9665 8192000000 10946295344 11373436928 1990933856 19.551 100 58 116 0 2028875056 21068272 16872928
20:34:05 3848 8192000000 10954097584 11373748224 2001203840 19.632 100 63 123 2 2040868912 21598944 18066128
20:34:17 18390 8192000000 10960994608 11385937920 2001290816 19.633 100 62 123 1 2042753344 23263952 18198576
20:34:45 6469 8192000000 10962100624 11387166720 2007365696 19.681 100 60 120 2 2049565824 24187920 18012208
20:35:07 14466 8192000000 10962302960 11393687552 2009525088 19.698 100 64 128 1 2053747152 25243520 18978544
20:35:39 27453 8192000000 10964565296 11400511488 2006910032 19.677 100 55 110 1 2057133200 33072176 17150992
20:36:19 12069 8192000000 10956556432 11399704576 2007330000 19.680 100 47 94 1 2049737248 28067376 14339872
20:36:41 7961 8192000000 10965265488 11405524992 2015324080 19.743 100 51 100 3 2062785952 31636784 15825088
20:37:06 7913 8192000000 10977012192 11416657920 2022194416 19.797 100 48 96 0 2064760368 27463120 15102832
20:37:23 10581 8192000000 10976078816 11415076864 2023413648 19.807 100 47 94 1 2064714288 26755408 14545232
20:37:49 6426 8192000000 10988033296 11422478336 2029392240 19.854 100 62 122 3 2075551856 26924880 19234736
20:38:04 2798 8192000000 10990114464 11406950400 2012208352 19.719 99 84 167 1 2063702000 26994336 24499312
20:38:14 8145 8192000000 10989186240 11415068672 2029098704 19.852 100 76 153 0 2081081824 28696224 23286896
20:38:29 5845 8192000000 10999758384 11425468416 2032480816 19.878 100 73 146 2 2083226496 29081776 21663904
20:38:43 8761 8192000000 10995101856 11426549760 2031426880 19.870 100 65 128 0 2080754416 29652640 19674896
20:39:04 13088 8192000000 11001376016 11432644608 2034989872 19.898 100 68 134 3 2086866064 31223456 20652736
20:39:33 7533 8192000000 10990030992 11424870400 2018754320 19.770 99 60 115 0 2067738224 30929552 18054352
20:39:47 6735 8192000000 10999569552 11432263680 2034292528 19.892 100 65 127 0 2083965920 29700496 19972896
20:40:05 11873 8192000000 10999904144 11438534656 2023820288 19.810 99 64 128 1 2077544048 33744896 19978864
20:40:27 6737 8192000000 10983150320 11423031296 2017572544 19.761 99 55 110 1 2070337072 34137776 18626752
20:40:42 2895 8192000000 10995883760 11428196352 2028825152 19.849 100 71 138 0 2086584320 34818288 22940880
20:40:54 3217 8192000000 11006364336 11434684416 2018167696 19.766 99 77 149 1 2077963104 36413936 23381472
20:41:06 5689 8192000000 11009680720 11442429952 2033508592 19.886 100 73 145 1 2094342224 38216640 22616992
20:41:22 3770 8192000000 11005461712 11434586112 2031842928 19.873 100 68 135 2 2090369280 37683904 20842448
20:41:36 3844 8192000000 10992963200 11424571392 2014571968 19.737 99 73 144 1 2078277136 39951424 23753744
20:41:51 2368 8192000000 11015605792 11434721280 2018432672 19.768 99 82 162 1 2089561200 45571024 25557504
20:42:01 3746 8192000000 11020663952 11449556992 2034283536 19.892 100 80 160 0 2106209760 46232688 25693536
20:42:12 3452 8192000000 11025752768 11452399616 2038273184 19.923 100 79 157 2 2107297136 44512912 24511040
20:42:24 2257 8192000000 11032657152 11459837952 2044019136 19.968 100 83 166 0 2115050336 45034416 25996784
20:42:33 4522 8192000000 11036933216 11463979008 2046273392 19.986 100 86 173 1 2120192208 47377040 26541776
20:42:44 3552 8192000000 11042845856 11467014144 2049113104 20.008 100 82 164 0 2121213392 46785136 25315152
20:42:55 1954 8192000000 11033396864 11453353984 2028458368 19.847 99 90 181 2 2106575712 50061952 28055392
20:43:06 3104 8192000000 11031015968 11458433024 2036978464 19.913 100 76 150 2 2110789952 49708064 24103424
20:43:16 1178 8192000000 11009809648 11429711872 2014876032 19.740 99 85 170 2 2092874160 50802976 27195152
20:43:24 4602 8192000000 11023140528 11446403072 2008563216 19.690 99 75 151 2 2086330400 53830272 23936912
20:43:37 2628 8192000000 11010460576 11429367808 2008304656 19.688 100 80 157 2 2088686304 55308176 25073472
20:43:49 1679 8192000000 10992723584 11418095616 1998765904 19.613 100 79 156 0 2077039456 53279968 24993584
20:43:57 3797 8192000000 10995007184 11422867456 1996943648 19.599 100 70 140 0 2075380752 56083424 22353680
20:44:10 9279 8192000000 10967698096 11415748608 1994554192 19.580 100 53 106 1 2066420816 54364496 17502128
20:44:32 11055 8192000000 10961078304 11407233024 1986612288 19.517 100 48 94 2 2052265616 49733008 15920320
20:44:56 9400 8192000000 10992886208 11428638720 2003283328 19.649 100 62 123 3 2075034640 52168176 19583136
20:45:17 4782 8192000000 11004298608 11431911424 2004913760 19.661 100 71 141 0 2085154528 57726704 22514064
20:45:30 2022 8192000000 11009459104 11437932544 2008232416 19.688 100 86 170 3 2094203712 57845312 28125984
20:45:39 1683 8192000000 11024976144 11444252672 2013323552 19.728 100 92 184 1 2100170560 57749808 29097200
20:45:47 1413 8192000000 11025192112 11447066624 2017287424 19.759 100 85 171 1 2105646464 60679456 27679584
20:45:57 3577 8192000000 11004413168 11446476800 2009904416 19.701 100 63 126 1 2092341168 61915152 20521600
20:46:09 17560 8192000000 10963634048 11424784384 1970052336 19.386 98 42 84 1 2043436912 59288320 14096256
20:46:46 9929 8192000000 10962456368 11421818880 2000480192 19.627 100 31 62 3 2055673792 44830992 10362608
20:47:03 18831 8192000000 10944820672 11383865344 1944516496 19.183 97 34 66 1 1996789760 41165552 11107712
20:47:30 8760 8192000000 10943937456 11381284864 1941482832 19.159 98 55 109 0 2001206400 42730752 16992816
20:47:45 5100 8192000000 10959214048 11397246976 1976139952 19.434 100 49 99 1 2037017248 45343280 15534016
20:48:08 12558 8192000000 10948016256 11396067328 1971642096 19.398 100 33 66 0 2028432352 45709712 11080544
20:48:32 18157 8192000000 10924238368 11378610176 1933576800 19.095 98 26 52 1 1982994752 40629424 8788528
20:49:03 17816 8192000000 10929922304 11378749440 1964159568 19.339 100 26 52 2 2015632432 42931824 8541040
20:49:34 21691 8192000000 10938462720 11386626048 1951268432 19.237 99 22 44 1 2003580768 44946832 7365504
20:50:27 16423 8192000000 10914035600 11359432704 1914956576 18.946 98 32 64 0 1979407632 53115296 11335760
20:50:51 3512 8192000000 10934750832 11369152512 1952768608 19.249 100 49 95 3 2018722576 50788272 15165696
20:51:01 6628 8192000000 10920798608 11360317440 1938915536 19.138 100 44 87 4 2005781552 52189456 14676560
20:51:20 11021 8192000000 10913329840 11354054656 1930675712 19.072 100 37 74 0 1999157488 55278288 13203488
20:51:38 9234 8192000000 10906373360 11349110784 1915824576 18.953 99 34 68 0 1986008912 57940368 12243968
20:51:59 19056 8192000000 10912702592 11365314560 1931699488 19.080 100 27 54 1 1999760256 58166784 9893984
20:52:28 37097 8192000000 10923245408 11367469056 1936679984 19.120 100 26 52 1 2000175632 53950816 9544832
20:53:22 22743 8192000000 10908154576 11362029568 1899859712 18.825 98 26 52 2 1965438208 56371040 9207456
20:53:55 22023 8192000000 10899503184 11356860416 1920237632 18.989 100 19 37 0 1979133232 51591920 7303680
20:54:24 13234 8192000000 10891002672 11344052224 1890488176 18.750 98 24 48 1 1948823376 50407856 7927344
20:54:44 19117 8192000000 10882497600 11355787264 1918445712 18.974 100 14 28 0 1964103648 41038240 4619696
20:55:15 59384 8192000000 10847596640 11309150208 1849222896 18.416 96 18 36 3 1864356672 10020624 5113152
20:57:20 35011 8192000000 10860129328 11279159296 1849886144 18.421 95 48 91 2 1872534720 9782640 12865936
20:58:24 46286 8192000000 10841801264 11298734080 1875954576 18.632 98 7 14 0 1891072736 13336016 1782144
20:59:16 69471 8192000000 10859314432 11309494272 1868284464 18.570 97 26 49 6 1884186176 9865328 6036384
21:00:34 34702 8192000000 10879957344 11335417856 1941405072 19.158 100 14 28 1 1953441152 8569264 3466816
21:01:28 135970 8192000000 10870883888 11314208768 1845071168 18.382 95 7 14 0 1859866992 13417664 1378160
21:03:51 114250 8192000000 10881171760 11325366272 1905644944 18.872 98 33 66 0 1924308112 9490416 9172752
21:05:52 72995 8192000000 10893308864 11330367488 1925699504 19.032 99 40 78 1 1944517808 8020496 10797808
21:07:13 7203 8192000000 10910749840 11342135296 1958288048 19.292 100 74 147 4 1989053920 10921344 19844528
21:07:41 17160 8192000000 10891945280 11348643840 1959713152 19.304 100 40 80 0 1983859152 13049136 11096864
21:08:09 22819 8192000000 10884627888 11345080320 1939033680 19.139 99 26 52 2 1954453008 8214512 7204816
21:08:39 9074 8192000000 10918833456 11355320320 1963616768 19.335 100 57 112 1 1988539472 8163024 16759680
21:08:58 7898 8192000000 10918273600 11356139520 1967965600 19.369 100 50 97 2 1992211936 9310128 14936208
21:09:18 18988 8192000000 10910153648 11355041792 1966755984 19.360 100 52 104 0 1990856320 8598672 15501664
21:09:43 82384 8192000000 10890807568 11356143616 1924152896 19.020 98 18 36 2 1939614560 10287152 5174512
21:11:24 29758 8192000000 10871895232 11336118272 1932232432 19.085 99 10 19 1 1944292528 9330128 2729968
21:12:50 22500 8192000000 10897081776 11356164096 1946463792 19.198 99 25 51 0 1970930080 17476800 6989488
21:13:25 36983 8192000000 10899841440 11371900928 1968936720 19.377 100 10 20 1 1985454560 14128016 2389824
21:14:08 12971 8192000000 10902439504 11371552768 1974848064 19.424 100 12 24 0 1995271040 17193808 3229168
21:14:28 27169 8192000000 10913761392 11378921472 1979904576 19.464 100 24 49 1 2000588864 13743888 6940400
21:15:02 49757 8192000000 10914421360 11387322368 1980874864 19.472 100 13 26 1 2000035104 15192928 3967312
21:16:00 51771 8192000000 10907072688 11384537088 1978010272 19.449 100 16 32 1 2002325296 18621904 5693120
21:17:38 76019 8192000000 10906328256 11365281792 1956817488 19.281 99 22 46 0 1973181808 10440144 5924176
21:19:01 52492 8192000000 10897320816 11365433344 1966029888 19.354 100 19 38 1 1984258432 12896384 5332160
21:20:03 104572 8192000000 10864719248 11336867840 1852133040 18.439 94 6 12 1 1865606384 11434144 2039200
21:21:54 48585 8192000000 10917365568 11366363136 1950794544 19.233 99 37 73 2 1969779568 8167488 10817536
21:22:49 24643 8192000000 10916818496 11357839360 1938239984 19.133 98 33 66 2 1957643888 10928736 8475168
21:23:31 27811 8192000000 10907997296 11380572160 1978116704 19.450 100 41 81 2 2005347360 15015552 12215104
21:24:22 66490 8192000000 10896846608 11359408128 1918605824 18.976 97 26 51 3 1933943392 8591472 6746096
21:25:35 21797 8192000000 10909640576 11362643968 1932567456 19.087 98 35 70 0 1952791216 10345520 9878240
21:26:10 69210 8192000000 10903979264 11367182336 1933199200 19.092 98 25 50 1 1950856912 10710464 6947248
21:27:38 45460 8192000000 10918253888 11384279040 1963702704 19.335 99 25 50 0 1980103632 9806096 6594832
21:28:32 77775 8192000000 10897158192 11359461376 1826858784 18.234 92 23 46 1 1857381680 24281024 6241872
21:30:00 77907 8192000000 10868159536 11338719232 1771488688 17.779 91 14 28 1 1790173424 15110608 3574128
21:31:31 45901 8192000000 10893591168 11350761472 1912866224 18.930 98 30 59 0 1935086672 12940544 9279904
21:32:24 39121 8192000000 10891000528 11364392960 1930315088 19.069 99 15 30 1 1950064976 15350256 4399632
21:33:19 53892 8192000000 10891685984 11331162112 1879216816 18.659 96 26 53 0 1900149872 13508736 7424320
21:34:20 102881 8192000000 10865158080 11332841472 1925803040 19.033 99 36 71 3 1950665248 14467344 10394864
21:36:18 76811 8192000000 10840691552 11289382912 1875571776 18.629 96 33 65 0 1892914688 8029408 9313504
21:37:42 14118 8192000000 10875820960 11321495552 1915197904 18.948 99 43 86 0 1935751648 8486080 12067664
21:38:24 16275 8192000000 10851918592 11313283072 1897074544 18.803 98 40 79 0 1920073584 11670224 11328816
21:38:47 58099 8192000000 10835792784 11314741248 1831162896 18.269 95 11 23 0 1844006768 10196976 2646896
21:39:51 48150 8192000000 10859980560 11336491008 1921933680 19.002 100 7 14 0 1945046672 21419728 1693264
21:40:53 73941 8192000000 10838367328 11320688640 1867725904 18.566 97 6 12 0 1884507216 14889216 1892096
21:42:25 38883 8192000000 10805753040 11267084288 1858320800 18.490 97 18 35 1 1875127952 11827920 4979232
21:43:14 66000 8192000000 10839577584 11312173056 1904218336 18.860 100 16 32 0 1923599888 14845408 4536144
21:44:26 68823 8192000000 10846394816 11320823808 1906163888 18.876 99 12 24 0 1925817216 15852688 3800640
21:45:43 59547 8192000000 10857661504 11327717376 1894337376 18.781 98 18 36 1 1915948128 15933936 5676816
21:47:00 52152 8192000000 10877610224 11345223680 1932551216 19.087 99 24 48 1 1950396480 10960176 6885088
21:47:58 41672 8192000000 10907846192 11360256000 1956232256 19.276 100 35 68 2 1980638800 13690112 10716432
21:48:57 29717 8192000000 10894571424 11364126720 1960691088 19.312 100 46 91 0 1988009728 14374400 12944240
21:49:38 75444 8192000000 10857376832 11327217664 1898892672 18.817 97 17 34 2 1916430288 13095520 4442096
21:51:00 47180 8192000000 10885935376 11351945216 1953882416 19.257 100 18 36 3 1966025456 7534064 4608976
21:51:55 24373 8192000000 10894489968 11356606464 1957660080 19.287 100 38 76 0 1976524448 8556992 10307376
21:52:26 15607 8192000000 10923779888 11360088064 1944570048 19.183 99 53 105 1 1968702576 8780848 15351680
21:52:49 10063 8192000000 10909212832 11356692480 1947041984 19.203 99 51 102 1 1972026320 10719088 14265248
21:53:05 25365 8192000000 10908652336 11366309888 1961514656 19.318 100 49 98 0 1987846096 12744912 13586528
21:53:40 52626 8192000000 10908292768 11374772224 1969222096 19.379 100 28 56 0 1990807856 14067632 7518128
21:54:41 50798 8192000000 10912471392 11388211200 1955646288 19.271 99 24 48 2 1983131952 20351568 7134096
21:56:13 128930 8192000000 10847589120 11318132736 1861742848 18.517 95 7 14 0 1873279040 10079296 1456896
21:58:47 76892 8192000000 10866673232 11336802304 1875827904 18.631 96 26 52 0 1891425216 8242016 7355296
22:00:13 51030 8192000000 10873720208 11328532480 1920310272 18.989 98 28 56 2 1937750032 10036864 7402896
22:01:10 51048 8192000000 10878083456 11354800128 1955817760 19.273 100 8 16 2 1966687840 8713776 2156304
22:02:15 67898 8192000000 10872833584 11352604672 1920691632 18.992 98 9 18 1 1932667248 9178112 2797504
22:03:30 71812 8192000000 10882471280 11354234880 1927660144 19.048 98 17 34 1 1940419216 7857152 4901920
22:04:49 66268 8192000000 10882369680 11362185216 1960038080 19.306 100 18 36 0 1974177040 8991120 5147840
22:06:03 31921 8192000000 10873550080 11354566656 1944121488 19.180 99 11 22 0 1954154016 7218512 2814016
22:06:50 33669 8192000000 10894916624 11361189888 1948821312 19.217 99 20 39 3 1960134320 5935056 5377952
22:07:36 59879 8192000000 10907811376 11387219968 1970143232 19.387 100 22 43 1 1993440240 17476480 5820528
22:08:42 68212 8192000000 10892883840 11369668608 1916862096 18.962 97 17 33 2 1935282992 13457792 4963104
22:10:18 63790 8192000000 10867170800 11357020160 1885303120 18.708 96 13 26 1 1904959728 15759200 3897408
22:11:29 18799 8192000000 10872721360 11332759552 1912249104 18.925 98 25 49 0 1926019728 7152992 6617632
22:12:08 26847 8192000000 10859386128 11319910400 1902548496 18.847 98 37 74 2 1923323296 10419392 10355408
22:12:50 72463 8192000000 10841862528 11319185408 1892907456 18.769 98 18 36 1 1914865344 17095968 4861920
22:14:11 43908 8192000000 10850047792 11314642944 1880013760 18.665 97 19 38 0 1893394336 8241200 5139376
22:15:09 45066 8192000000 10897977648 11348463616 1939197152 19.140 100 24 46 1 1955824816 9655200 6972464
22:16:04 37476 8192000000 10897105184 11360505856 1953340224 19.253 100 37 74 2 1981664576 17341376 10982976
22:16:48 140611 8192000000 10860888608 11322023936 1815716080 18.143 93 19 38 2 1837842192 17192448 4933664
22:19:15 25468 8192000000 10864731152 11328053248 1901245632 18.836 98 26 49 4 1917321504 8601600 7474272
22:19:47 86945 8192000000 10848886768 11318853632 1905783280 18.873 99 22 44 0 1922864480 10202336 6878864
22:21:27 61553 8192000000 10854114672 11308568576 1824099184 18.211 94 24 46 2 1840127792 9835776 6192832
22:22:35 34044 8192000000 10848534384 11315347456 1920356864 18.990 100 35 70 0 1941712208 11904592 9450752
22:23:18 28482 8192000000 10836858960 11312648192 1911388208 18.918 100 10 20 1 1924964432 10726368 2849856
22:23:59 85951 8192000000 10838203024 11324272640 1865141648 18.545 97 16 32 1 1880743488 11415440 4186400
22:25:31 41430 8192000000 10852551344 11326685184 1910144432 18.908 99 12 24 3 1930247328 16859248 3243648
22:26:19 67169 8192000000 9448870400 9792471040 563843920 6.439 30 8 16 0 573551472 7263088 2444464

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 20-02-2021 22:29:42 to 20-02-2021 22:30:13.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 175 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 20-02-2021 22:30:14 to 20-02-2021 22:30:16.

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          246422
MON$OLDEST_ACTIVE               246962
MON$OLDEST_SNAPSHOT             246962
MON$NEXT_TRANSACTION            246962
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                       2030368
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
:72: 
:73: mscs-test-161.budzdorov.ru    Sat Feb 20 22:27:42 2021
:74:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:75: 
--- end of diff output ---

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

20.02.21 22:30:17. 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-20 22:30:19 No severe PSQL-related problems occured
20.02.21 22:30:21. End of report.