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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-15 01:27:06
DTS_END                         2020-12-15 01:27:06.0400
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_FROM_CUSTOMER(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/51612
TRN_ID                          246808
ATT_ID                          671
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: 10051.92 22504 1206231
customer order: creation 174.30 342 20916
customer order: refuse 15.04 301 1805
order to supplier: creation 47.36 1171 5683
order to supplier: removal 3.67 78648 440
invoice (draft): creation 46.13 2674 5535
invoice (draft): removal 58.97 589 7076
invoice accept: apply 42.72 15610 5126
invoice accept: cancel 54.03 579 6484
customer reserve: creation 3999.43 154 479931
customer reserve: removal 5296.01 42 635521
realization accept: apply 85.42 165 10250
realization accept: cancel 95.70 107 11484
payment from customer: creation 60.48 117 7258
payment from customer: removal 6.14 56 737
payment to supplier: creation 50.20 127 6024
payment to supplier: removal 3.83 74 459
service: total inventory turnovers 4.82 1183 578
service: total monetary turnovers 6.92 40 830
service: aggregate perf. data 0.75 20815 90
service: refresh index statistics 0.03 327281 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 15-12-2020 01:27:53 to 15-12-2020 01:27:55.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4728
TEST_TIME 2 4548
TEST_TIME 3 4153
TEST_TIME 4 3516
TEST_TIME 5 3803
TEST_TIME 6 5471
TEST_TIME 7 6836
TEST_TIME 8 6992
TEST_TIME 9 7642
TEST_TIME 10 8450
TEST_TIME 11 8291
TEST_TIME 12 9205
TEST_TIME 13 9666
TEST_TIME 14 10150
TEST_TIME 15 10015
TEST_TIME 16 10538
TEST_TIME 17 11340
TEST_TIME 18 11655
TEST_TIME 19 12312
TEST_TIME 20 12749
TEST_TIME 21 12590
TEST_TIME 22 12267
TEST_TIME 23 11885
TEST_TIME 24 11729
TEST_TIME 25 11721
TEST_TIME 26 11516
TEST_TIME 27 11370
TEST_TIME 28 11261
TEST_TIME 29 11109
TEST_TIME 30 11069
TEST_TIME 31 11232
TEST_TIME 32 10958
TEST_TIME 33 10860
TEST_TIME 34 10608
TEST_TIME 35 10847
TEST_TIME 36 10743
TEST_TIME 37 10827
TEST_TIME 38 10912
TEST_TIME 39 10882
TEST_TIME 40 10741
TEST_TIME 41 10795
TEST_TIME 42 10787
TEST_TIME 43 10923
TEST_TIME 44 10916
TEST_TIME 45 10790
TEST_TIME 46 11021
TEST_TIME 47 11062
TEST_TIME 48 11052
TEST_TIME 49 10969
TEST_TIME 50 10778
TEST_TIME 51 10675
TEST_TIME 52 10623
TEST_TIME 53 10560
TEST_TIME 54 10559
TEST_TIME 55 10470
TEST_TIME 56 10364
TEST_TIME 57 10402
TEST_TIME 58 10395
TEST_TIME 59 10358
TEST_TIME 60 10469
TEST_TIME 61 10437
TEST_TIME 62 10375
TEST_TIME 63 10484
TEST_TIME 64 10411
TEST_TIME 65 10411
TEST_TIME 66 10489
TEST_TIME 67 10436
TEST_TIME 68 10527
TEST_TIME 69 10481
TEST_TIME 70 10549
TEST_TIME 71 10585
TEST_TIME 72 10526
TEST_TIME 73 10414
TEST_TIME 74 10438
TEST_TIME 75 10401
TEST_TIME 76 10344
TEST_TIME 77 10383
TEST_TIME 78 10344
TEST_TIME 79 10279
TEST_TIME 80 10285
TEST_TIME 81 10225
TEST_TIME 82 10159
TEST_TIME 83 10179
TEST_TIME 84 10097
TEST_TIME 85 10143
TEST_TIME 86 10271
TEST_TIME 87 10228
TEST_TIME 88 10222
TEST_TIME 89 10215
TEST_TIME 90 10224
TEST_TIME 91 10280
TEST_TIME 92 10349
TEST_TIME 93 10370
TEST_TIME 94 10375
TEST_TIME 95 10324
TEST_TIME 96 10336
TEST_TIME 97 10349
TEST_TIME 98 10292
TEST_TIME 99 10230
TEST_TIME 100 10178
TEST_TIME 101 10111
TEST_TIME 102 10053
TEST_TIME 103 10013
TEST_TIME 104 10025
TEST_TIME 105 10035
TEST_TIME 106 9972
TEST_TIME 107 9936
TEST_TIME 108 10003
TEST_TIME 109 9955
TEST_TIME 110 10019
TEST_TIME 111 10000
TEST_TIME 112 10015
TEST_TIME 113 9993
TEST_TIME 114 9966
TEST_TIME 115 9992
TEST_TIME 116 10081
TEST_TIME 117 10103
TEST_TIME 118 10097
TEST_TIME 119 10131
TEST_TIME 120 10052

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 15-12-2020 01:27:56 to 15-12-2020 01:28:00.

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 1650412 1650412 0 0.00 0 31472 6 0 0
doc_list_biud 1650412 1650412 0 0.00 0 61077 21 0 0
sp_add_invoice_to_stock 5226 5126 100 1.91 28 222718 15610 0 100
sp_cancel_adding_invoice 6484 6484 0 0.00 5 53620 580 0 0
sp_cancel_client_order 1805 1805 0 0.00 4 12684 302 0 0
sp_cancel_customer_reserve 635521 635521 0 0.00 1 61078 43 0 0
sp_cancel_pay_from_customer 737 737 0 0.00 3 2355 56 0 0
sp_cancel_pay_to_supplier 459 459 0 0.00 3 12055 74 0 0
sp_cancel_supplier_invoice 7086 7076 10 0.14 2 18076 590 0 10
sp_cancel_supplier_order 440 440 0 0.00 10 876343 78648 0 0
sp_cancel_write_off 11484 11484 0 0.00 1 28116 107 0 0
sp_client_order 20916 20916 0 0.00 4 46531 343 0 0
sp_customer_reserve 479931 479931 0 0.00 0 96808 154 0 0
sp_fill_shopping_cart 32134 32134 0 0.00 1 11745 34 0 0
sp_fill_shopping_cart_clo_res 479931 479931 0 0.00 0 18589 13 0 0
sp_get_clo_for_invoice 5126 5126 0 0.00 0 21103 271 0 0
sp_kill_cost_storno 19164 19164 0 0.00 0 12720 46 0 0
sp_kill_qstorno_ret_qs2qd 1290042 1290042 0 0.00 0 61074 23 0 0
sp_kill_qty_storno 678186 678186 0 0.00 0 61077 50 0 0
sp_lock_selected_doc 21422 21422 0 0.00 0 6429 4 0 0
sp_make_cost_storno 28658 28658 0 0.00 0 29636 58 0 0
sp_multiply_rows_for_pdistr 28658 28658 0 0.00 0 11004 31 0 0
sp_multiply_rows_for_qdistr 20916 20916 0 0.00 0 12323 152 0 0
sp_pay_from_customer 7258 7258 0 0.00 4 24156 118 0 0
sp_pay_to_supplier 6024 6024 0 0.00 5 23862 127 0 0
sp_payment_common 13282 13282 0 0.00 1 24131 34 0 0
sp_qd_handle_on_cancel_clo 1805 1805 0 0.00 0 12675 268 0 0
sp_qd_handle_on_invoice_upd_sts 11610 11610 0 0.00 0 23669 242 0 0
sp_qd_handle_on_reserve_upd_sts 10250 10250 0 0.00 0 14500 46 0 0
sp_reserve_write_off 10250 10250 0 0.00 6 19514 166 0 0
sp_supplier_invoice 5535 5535 0 0.00 6 79735 2675 0 0
sp_supplier_order 5683 5683 0 0.00 5 34170 1172 0 0
srv_aggregate_perf_data 90 90 0 0.00 2302 124851 20815 0 0
srv_fill_mon_cache_memory 136 136 0 0.00 1283 157056 40627 0 0
srv_find_qd_qs_mism 1157060 1157060 0 0.00 0 31471 5 0 0
srv_make_invnt_saldo 578 578 0 0.00 22 124886 1183 0 0
srv_make_money_saldo 830 830 0 0.00 0 8578 40 0 0
srv_recalc_idx_stat 4 4 0 0.00 125773 540222 327282 0 0
t$perf-abend:sp_add_invoice_to_stock 100 100 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5127 5127 0 0.00 0 17470 175 0 0
t$perf-norm:sp_cancel_adding_invoice 438 438 0 0.00 0 19394 124 0 0
t$perf-norm:sp_cancel_client_order 1805 1805 0 0.00 0 9771 27 0 0
t$perf-norm:sp_cancel_customer_reserve 726 726 0 0.00 0 4422 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 737 737 0 0.00 0 416 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 459 459 0 0.00 0 2216 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 394 394 0 0.00 0 2959 14 0 0
t$perf-norm:sp_cancel_supplier_order 440 440 0 0.00 0 22053 1451 0 0
t$perf-norm:sp_cancel_write_off 1047 1047 0 0.00 0 11092 20 0 0
t$perf-norm:sp_client_order 20916 20916 0 0.00 0 12517 18 0 0
t$perf-norm:sp_customer_reserve 1021 1021 0 0.00 0 7912 17 0 0
t$perf-norm:sp_pay_from_customer 7258 7258 0 0.00 0 9975 15 0 0
t$perf-norm:sp_pay_to_supplier 6024 6024 0 0.00 0 18671 13 0 0
t$perf-norm:sp_reserve_write_off 10250 10250 0 0.00 0 8931 12 0 0
t$perf-norm:sp_supplier_invoice 5535 5535 0 0.00 0 27746 26 0 0
t$perf-norm:sp_supplier_order 5683 5683 0 0.00 0 8205 15 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 161 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 136 136 0 0.00 0 6873 53 0 0
t$perf-norm:srv_make_invnt_saldo 578 578 0 0.00 0 4731 20 0 0
t$perf-norm:srv_make_money_saldo 830 830 0 0.00 0 2463 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 19 6 0 0
v_add_invoice_to_stock 10452 10252 200 1.91 0 7653 18 0 200
v_all_customers 38062 38062 0 0.00 0 67 0 0 0
v_all_suppliers 31330 31330 0 0.00 0 20 1 0 0
v_all_wares 41832 41832 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 876 876 0 0.00 0 1787 8 0 0
v_cancel_client_order 3610 3610 0 0.00 0 6961 11 0 0
v_cancel_customer_prepayment 1474 1474 0 0.00 0 873 3 0 0
v_cancel_customer_reserve 1452 1452 0 0.00 0 2604 6 0 0
v_cancel_payment_to_supplier 918 918 0 0.00 0 4114 7 0 0
v_cancel_supplier_invoice 808 788 20 2.47 0 1269 13 0 20
v_cancel_supplier_order 880 880 0 0.00 0 684 3 0 0
v_cancel_write_off 2094 2094 0 0.00 0 4037 16 0 0
v_max_id_clo_ord 5683 5683 0 0.00 0 599 1 0 0
v_max_id_clo_res 1021 1021 0 0.00 0 1899 12 0 0
v_max_id_ord_sup 5535 5535 0 0.00 0 5298 4 0 0
v_max_non_paid_invoice 1577 1577 0 0.00 0 383 2 0 0
v_max_non_paid_realizn 3970 3970 0 0.00 0 868 3 0 0
v_min_id_clo_ord 5683 5683 0 0.00 0 6167 14 0 0
v_min_id_clo_res 1021 1021 0 0.00 0 1115 4 0 0
v_min_id_ord_sup 5535 5535 0 0.00 0 6652 12 0 0
v_min_non_paid_invoice 6024 6024 0 0.00 0 6776 16 0 0
v_min_non_paid_realizn 7258 7258 0 0.00 0 7567 27 0 0
v_our_firm 10346 10346 0 0.00 0 12 1 0 0
v_reserve_write_off 20500 20500 0 0.00 0 4710 7 0 0
x_lock_depdocs_on_canc_invoice 13166 13166 0 0.00 0 12246 93 0 0
x_lock_depdocs_on_canc_sup_ord 440 440 0 0.00 0 10643 334 0 0
x_make_qstorno_1000_1200 5683 5683 0 0.00 2 34145 1094 0 0
x_make_qstorno_1200_2000 5535 5535 0 0.00 3 79579 2565 0 0
x_make_qstorno_2100_3300 479931 479931 0 0.00 0 96806 139 0 0

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

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:09 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:16 10433 8192000000 10215379584 10520346624 916427152 10.061 73 47 93 1 934260640 2358528 15474960
22:57:35 42163 8192000000 10345208832 10660511744 1381162304 14.427 100 87 173 1 1414199408 5049664 27987440
22:58:26 18711 8192000000 10373393360 10696429568 1428789712 14.851 100 88 176 1 1464813696 6858656 29165328
22:58:53 4763 8192000000 10393062416 10720206848 1455579056 15.087 100 86 172 0 1490691360 7196160 27916144
22:59:09 23087 8192000000 10427192416 10759254016 1480360096 15.305 100 90 180 1 1517217696 8173488 28684112
22:59:40 27382 8192000000 10457861648 10791325696 1507120704 15.538 100 90 180 1 1544424496 8987536 28316256
23:00:22 20921 8192000000 10475246432 10814283776 1524366480 15.688 100 90 180 0 1562833968 9990544 28476944
23:00:52 14350 8192000000 10484771136 10826141696 1539927104 15.823 100 88 176 1 1577366544 10103872 27335568
23:01:27 16664 8192000000 10530679008 10877636608 1584769472 16.209 100 85 171 1 1621390256 10943792 25676992
23:01:52 14950 8192000000 10545480672 10899304448 1602367456 16.360 100 92 184 1 1642983376 12582672 28033248
23:02:19 11485 8192000000 10564154208 10918412288 1618365216 16.496 100 80 160 0 1654230240 12013776 23851248
23:02:38 12264 8192000000 10574449600 10935001088 1629451072 16.590 100 76 152 0 1663853504 11889952 22512480
23:03:02 7199 8192000000 10596536944 10958979072 1652505808 16.786 100 76 152 1 1686764560 11925856 22332896
23:03:17 10617 8192000000 10610257504 10976264192 1668232688 16.918 100 80 160 1 1704594320 12314064 24047568
23:03:35 8566 8192000000 10629896544 10996105216 1688132848 17.086 100 87 171 3 1726234528 13421104 24680576
23:03:51 7553 8192000000 10642422032 11012243456 1698653296 17.174 100 79 158 1 1734443648 12772336 23018016
23:04:07 5855 8192000000 10661508240 11031248896 1717092304 17.328 100 83 164 2 1754525456 12986560 24446592
23:04:19 6959 8192000000 10662598608 11039784960 1728166832 17.420 100 76 151 0 1762985344 13163408 21655104
23:04:33 4719 8192000000 10674941616 11054006272 1740420592 17.522 100 74 148 0 1773355952 11916928 21018432
23:04:45 4910 8192000000 10693106352 11073773568 1757327136 17.662 100 76 149 1 1790832064 11836896 21668032
23:04:56 3811 8192000000 10704197456 11081764864 1764661616 17.723 100 80 158 0 1799674864 12858096 22155152
23:05:07 5004 8192000000 10708122560 11091283968 1773051072 17.792 100 77 154 0 1807671536 12551024 22069440
23:05:19 3239 8192000000 10725261136 11107803136 1788738144 17.921 100 86 170 2 1825324272 13308432 23277696
23:05:28 3172 8192000000 10732645072 11114852352 1791026928 17.940 100 90 176 5 1830250560 14148496 25075136
23:05:38 2972 8192000000 10734740384 11119067136 1798130352 17.999 100 76 152 0 1832576528 13285584 21160592
23:05:47 2228 8192000000 10744740912 11130597376 1806710336 18.069 100 76 151 1 1840455424 11742992 22002096
23:05:56 1659 8192000000 10755700544 11137183744 1815465808 18.141 100 86 171 1 1851326640 12303696 23557136
23:06:04 1964 8192000000 10761575280 11145273344 1823654944 18.208 100 91 178 3 1860289840 12289680 24345216
23:06:13 5118 8192000000 10756565040 11146403840 1821717040 18.192 100 76 147 0 1855338544 13263856 20357648
23:06:24 4174 8192000000 10771850176 11157950464 1833647968 18.289 100 89 178 0 1871490320 12522192 25320160
23:06:35 1305 8192000000 10784537360 11171643392 1842167936 18.358 100 92 182 0 1881716192 14007984 25540272
23:06:42 1189 8192000000 10789724832 11176251392 1849350208 18.417 100 94 189 2 1889465168 13809168 26305792
23:06:50 1780 8192000000 10798752368 11187494912 1851659472 18.436 100 92 180 0 1891541520 13954416 25927632
23:06:59 2056 8192000000 10807271392 11194839040 1857227360 18.481 100 94 189 0 1898052080 14072560 26752160
23:07:07 1340 8192000000 10808385696 11198357504 1865094016 18.545 100 92 183 0 1904114080 12887504 26132560
23:07:15 1689 8192000000 10809688400 11196801024 1870714288 18.590 100 94 186 2 1910546016 13854160 25977568
23:07:23 968 8192000000 10815580544 11205500928 1873764960 18.615 100 93 185 1 1913590096 13414032 26411104
23:07:30 1435 8192000000 10818403456 11206021120 1869632224 18.581 100 92 183 0 1909449968 13503376 26314368
23:07:38 1691 8192000000 10825210896 11213348864 1876425600 18.636 100 97 192 1 1917915328 14579904 26909824
23:07:46 1310 8192000000 10825724688 11214770176 1876089856 18.634 100 95 193 0 1915360240 12021664 27248720
23:07:53 2078 8192000000 10822768288 11212709888 1878125968 18.650 100 92 183 0 1917894576 14256496 25512112
23:08:01 1233 8192000000 10829865936 11222482944 1884037328 18.698 100 96 192 0 1925129440 14522256 26569856
23:08:09 2193 8192000000 10816896480 11223437312 1883458784 18.693 100 77 154 0 1917057408 12045184 21553440
23:08:18 38286 8192000000 10804111200 11219554304 1877753264 18.647 100 49 96 2 1899959840 8894672 13311904
23:09:03 5097 8192000000 10796876112 11221741568 1878852960 18.656 100 38 76 4 1897659200 8341824 10464416
23:09:18 7523 8192000000 10796028592 11223384064 1881188496 18.675 100 31 61 0 1897382624 7662576 8531552
23:09:33 10367 8192000000 10781996192 11220504576 1880524144 18.669 100 27 54 1 1895402976 7238288 7640544
23:09:49 9776 8192000000 10794772208 11225722880 1880525600 18.669 100 27 53 1 1893245280 5830432 6889248
23:10:05 9071 8192000000 10799026576 11230289920 1887346144 18.724 100 22 41 0 1899580272 6178080 6056048
23:10:21 9826 8192000000 10788823472 11228209152 1887371440 18.725 100 26 52 0 1901211344 6568720 7271184
23:10:41 15345 8192000000 10803548624 11239190528 1887964880 18.729 100 12 24 1 1897011472 5466208 3580384
23:11:04 10646 8192000000 10812431712 11244072960 1898250096 18.812 100 24 47 0 1911059504 5564688 7244720
23:11:21 16209 8192000000 10800158608 11242291200 1899946656 18.826 100 18 36 0 1911385040 5874368 5564016
23:11:43 15521 8192000000 10806043568 11248271360 1900881792 18.833 100 9 18 2 1909007760 5876400 2249568
23:12:10 11006 8192000000 10809318512 11244937216 1885022016 18.706 99 15 30 2 1894489472 5369504 4097952
23:12:29 14711 8192000000 10810985552 11247960064 1904464448 18.862 100 21 42 2 1917130880 5553088 7113344
23:12:51 23563 8192000000 10814469920 11252928512 1904814256 18.865 100 25 50 1 1918304688 5588624 7901808
23:13:25 77597 8192000000 10830969808 11270737920 1909845200 18.905 100 29 58 0 1928165792 10227168 8093424
23:14:49 6212 8192000000 10819399408 11263102976 1909525184 18.903 100 26 52 3 1923632656 6361024 7746448
23:15:07 10828 8192000000 10820459232 11251449856 1853951904 18.454 97 27 54 1 1868858752 7212368 7694480
23:15:25 8028 8192000000 10817373776 11256045568 1904414240 18.862 100 25 51 2 1917733840 5921984 7397616
23:15:41 8219 8192000000 10818283472 11253932032 1901019376 18.834 100 28 56 1 1915055072 5814944 8220752
23:15:56 5129 8192000000 10798562656 11232178176 1847155888 18.399 97 36 71 4 1862115808 4906768 10053152
23:16:09 7792 8192000000 10794335152 11227234304 1836009024 18.308 97 26 52 2 1849513712 5486624 8018064
23:16:24 9657 8192000000 10789447984 11218706432 1829551040 18.256 97 23 46 0 1841588256 5214896 6822320
23:16:43 7008 8192000000 10758874752 11190140928 1818248000 18.163 98 17 34 2 1828992240 5669248 5074992
23:16:57 13752 8192000000 10770204800 11202850816 1784502256 17.887 95 15 30 0 1794160272 5110960 4547056
23:17:19 6393 8192000000 10772615648 11203248128 1855602400 18.468 100 25 50 3 1868430112 6528848 6298864
23:17:32 11478 8192000000 10747497648 11178909696 1813929984 18.128 98 15 30 3 1822611792 5044528 3637280
23:17:50 10557 8192000000 10729985872 11158999040 1767141472 17.743 96 9 17 3 1774849728 5242912 2465344
23:18:07 17358 8192000000 10712717744 11135877120 1686431232 17.071 92 17 34 0 1700816480 9725440 4659808
23:18:33 14378 8192000000 10704224368 11121250304 1689687600 17.099 93 21 42 0 1701074992 4742336 6645056
23:19:00 60192 8192000000 10729565296 11126607872 1706007056 17.235 94 60 115 5 1729625024 4529856 19088112
23:20:06 8644 8192000000 10701946368 11122176000 1761924304 17.700 98 31 62 2 1778395472 7912560 8558608
23:20:22 7959 8192000000 10714589904 11132444672 1788284992 17.918 99 32 64 0 1804429136 7145664 8998480
23:20:36 5739 8192000000 10714912592 11132997632 1766789520 17.741 98 28 54 2 1780918224 6931376 7197328
23:20:51 6526 8192000000 10724779680 11130417152 1764293536 17.720 98 37 74 0 1781887648 7544880 10049232
23:21:06 8538 8192000000 10721555248 11144531968 1808111568 18.080 100 32 64 2 1822652944 5834256 8707120
23:21:21 9115 8192000000 10742628208 11159769088 1804706608 18.053 99 26 50 1 1817416400 5460032 7249760
23:21:39 8577 8192000000 10735060816 11154735104 1804187360 18.048 99 26 52 0 1817422832 5651616 7583856
23:21:55 6952 8192000000 10727258384 11144204288 1791435344 17.944 98 21 42 0 1803002016 5081728 6484944
23:22:08 7402 8192000000 10751038192 11168337920 1830397216 18.263 100 15 30 0 1840161040 5176816 4587008
23:22:21 8934 8192000000 10755300576 11170721792 1814467712 18.132 99 27 54 1 1828056688 5358224 8230752
23:22:36 8092 8192000000 10758546128 11184238592 1842060208 18.358 100 22 44 1 1853981536 6038256 5883072
23:22:51 14650 8192000000 10757682368 11186167808 1843187248 18.367 100 16 32 0 1852788720 4744800 4856672
23:23:11 63118 8192000000 10782296144 11197071360 1851658928 18.436 100 35 70 2 1868487376 6996608 9831840
23:24:22 5703 8192000000 10776026416 11202613248 1859168640 18.497 100 24 47 3 1873013504 6747264 7097600
23:24:34 11330 8192000000 10776820592 11203469312 1860000112 18.503 100 11 22 1 1868165952 5208192 2957648
23:24:53 6878 8192000000 10788288560 11211792384 1865207920 18.545 100 27 54 1 1880050672 7161232 7681520
23:25:07 9997 8192000000 10772106176 11209228288 1866103168 18.553 100 16 32 0 1876634304 5877968 4653168
23:25:23 9739 8192000000 10776857248 11215523840 1868183120 18.570 100 17 34 1 1879163184 5524272 5455792
23:25:39 4319 8192000000 10794604992 11221594112 1877189616 18.642 100 37 74 1 1894447264 7212992 10044656
23:25:50 16919 8192000000 10794894624 11223678976 1877989136 18.649 100 19 37 1 1888605744 5282288 5334320
23:26:15 7015 8192000000 10791630272 11222499328 1879064896 18.658 100 17 34 3 1889695008 5243264 5386848
23:26:28 14097 8192000000 10788426464 11221114880 1862394368 18.523 99 19 37 1 1872924400 5488864 5041168
23:26:49 8211 8192000000 10790050352 11229757440 1883802400 18.696 100 19 38 1 1894892544 5889088 5201056
23:27:03 37723 8192000000 10832904208 11253506048 1896942976 18.802 100 22 42 3 1906803008 4327152 5532880
23:27:50 33680 8192000000 10861582608 11285946368 1924484000 19.023 100 41 80 2 1944929264 9262608 11182656
23:28:32 11230 8192000000 10867172768 11294457856 1939007120 19.139 100 41 83 0 1961527456 10721952 11798384
23:28:51 41944 8192000000 10885865696 11317760000 1947703136 19.208 100 33 66 0 1974158304 16439664 10015504
23:29:43 19289 8192000000 10902032016 11334959104 1960003680 19.306 100 39 78 1 1987322064 15829520 11488864
23:30:11 88991 8192000000 10911667456 11348340736 1971281232 19.396 100 40 81 1 2000667776 17790672 11595872
23:31:47 25311 8192000000 10913518640 11353419776 1979430592 19.460 100 31 61 0 2008927728 20620432 8876704
23:32:30 3690 8192000000 10938637920 11360862208 1986739472 19.518 100 44 86 0 2019730496 20030304 12960720
23:32:40 3503 8192000000 10936878144 11369115648 1990882480 19.551 100 52 104 4 2030518032 24089920 15545632
23:32:51 3111 8192000000 10955969840 11377823744 1996978896 19.599 100 62 121 2 2040391696 25632560 17780240
23:33:05 4563 8192000000 10961270960 11385049088 1997437088 19.603 100 58 115 0 2046233744 32072208 16724448
23:33:17 13007 8192000000 10948628608 11375562752 1982232992 19.482 99 62 124 1 2030609808 29838336 18538480
23:33:37 7276 8192000000 10949337936 11377676288 1975208928 19.427 99 52 104 1 2022284208 30628736 16446544
23:33:57 3247 8192000000 10945313168 11380375552 1995024704 19.583 100 56 112 1 2039597376 27372704 17199968
23:34:07 17222 8192000000 10941139440 11380813824 1978959504 19.456 99 42 82 3 2019912160 27794464 13158192
23:34:31 7205 8192000000 10973497568 11393347584 1998215088 19.609 100 72 143 1 2051418992 31185952 22017952
23:34:46 3932 8192000000 10969304368 11389562880 2000385328 19.626 100 63 125 0 2044605712 25987312 18233072
23:34:57 7293 8192000000 10971543024 11398266880 2011896576 19.716 100 68 132 2 2057771824 26353856 19521392
23:35:11 4943 8192000000 10966089760 11391918080 2006297312 19.672 100 69 138 0 2054495888 27635200 20563376
23:35:24 15443 8192000000 10947868272 11379105792 1980455456 19.468 99 55 110 2 2024954832 28210448 16288928
23:35:47 6571 8192000000 10933206336 11362488320 1979372656 19.460 99 57 114 1 2024476032 28018400 17084976
23:36:01 4165 8192000000 10963052848 11392679936 2003374384 19.649 100 58 112 3 2050620528 29477520 17768624
23:36:13 15088 8192000000 10959841888 11389059072 1987172000 19.521 99 63 124 2 2034036752 27913552 18951200
23:36:38 6613 8192000000 10967453680 11394564096 1990934272 19.551 99 62 125 0 2040020464 30012224 19073968
23:36:52 1279 8192000000 10992773088 11407286272 2014870048 19.740 100 83 164 2 2070152656 30834320 24448288
23:36:59 4570 8192000000 10977532272 11406000128 2011935104 19.717 100 80 159 0 2073055936 36587264 24533568
23:37:12 1506 8192000000 10972529776 11387338752 1988169536 19.529 99 81 164 0 2045486000 32579616 24736848
23:37:21 2819 8192000000 10974401968 11397283840 2001968608 19.638 100 69 138 0 2057165232 34746080 20450544
23:37:31 2416 8192000000 10981587424 11402293248 2009205824 19.695 100 76 151 1 2067521264 34100480 24214960
23:37:41 4525 8192000000 10963424288 11394531328 1988512272 19.532 99 60 116 1 2039263824 32730272 18021280
23:37:55 1644 8192000000 10975884656 11393994752 2006312608 19.672 100 81 163 2 2058374656 28165312 23896736
23:38:03 5155 8192000000 10968593936 11398950912 2004635344 19.659 100 64 128 3 2054128976 30140736 19352896
23:38:16 12092 8192000000 10947915472 11382116352 1967721728 19.367 98 47 94 1 2011037904 28800928 14515248
23:38:37 2994 8192000000 10964308192 11385544704 1995209040 19.585 100 66 131 1 2046552704 30904768 20438896
23:38:52 4865 8192000000 10954737760 11372351488 1975792688 19.431 99 70 140 6 2030004752 33404080 20807984
23:39:07 3607 8192000000 10973092112 11401605120 2000585104 19.627 100 77 154 1 2062093344 37530512 23977728
23:39:18 1990 8192000000 10939409600 11360096256 1937124064 19.124 97 84 170 0 2002854928 39890944 25839920
23:39:26 6762 8192000000 10959169184 11381719040 1982820496 19.487 100 71 141 1 2042032048 37326400 21885152
23:39:41 3864 8192000000 10954484400 11378802688 1982423840 19.484 100 79 154 1 2039479920 33567760 23488320
23:39:51 3393 8192000000 10937140320 11368857600 1972216240 19.403 100 69 138 0 2028842304 35145984 21480080
23:40:05 7363 8192000000 10928610400 11366268928 1968565344 19.374 100 43 86 1 2013807376 31760448 13481584
23:40:20 13667 8192000000 10906707152 11343986688 1931566016 19.079 98 45 90 5 1972502208 27544640 13391552
23:40:41 6002 8192000000 10893546576 11330650112 1946421264 19.198 100 38 76 2 1985931312 27327744 12182304
23:40:54 2751 8192000000 10905225328 11327459328 1937480592 19.127 99 62 123 0 1985303296 28396784 19425920
23:41:03 1657 8192000000 10909257904 11322724352 1933658672 19.096 99 74 146 0 1988623056 32570432 22393952
23:41:12 6158 8192000000 10940033200 11351580672 1963825936 19.336 100 65 127 0 2017312656 34175488 19311232
23:41:54 16686 8192000000 10897568432 11335356416 1924513392 19.023 99 28 56 0 1968333408 34696480 9123536
23:42:20 8267 8192000000 10909728288 11339919360 1924247312 19.021 99 33 66 1 1972567872 37493216 10827344
23:42:35 4209 8192000000 10904963904 11336257536 1928119760 19.052 99 47 94 1 1978649808 36205168 14324880
23:42:50 10244 8192000000 10909624048 11350953984 1946293664 19.197 100 42 85 2 2000741392 40935584 13512144
23:43:15 4644 8192000000 10888186816 11318816768 1896026944 18.794 98 38 76 0 1953262688 43783696 13452048
23:43:28 10489 8192000000 10901325600 11337920512 1917209264 18.964 99 35 70 4 1976262064 46870272 12182528
23:43:49 19731 8192000000 10888807200 11334459392 1897907456 18.809 98 25 50 0 1944102320 37483088 8711776
23:44:20 21935 8192000000 10881245872 11319443456 1899068384 18.819 99 28 57 1 1947544448 38380144 10095920
23:44:50 24866 8192000000 10867612688 11314913280 1909709952 18.904 100 29 58 0 1958403408 38403456 10290000
23:45:24 20537 8192000000 10875168352 11332026368 1921090640 18.996 100 19 38 2 1964620320 36471968 7057712
23:45:58 20620 8192000000 10866311056 11332595712 1910316160 18.909 99 16 32 2 1951507936 35733632 5458144
23:46:30 23532 8192000000 10839532816 11296837632 1857738592 18.485 97 10 20 0 1888443392 27374400 3330400
23:46:59 35348 8192000000 10832026608 11289047040 1838875616 18.332 97 10 21 1 1860524256 18995376 2653264
23:47:44 82624 8192000000 10842747872 11309289472 1869135904 18.577 98 16 32 0 1892285232 18055376 5093952
23:49:12 100864 8192000000 10840585200 11283161088 1886128288 18.715 98 29 58 0 1904938032 10609984 8199760
23:51:28 83041 8192000000 10872046640 11339612160 1934891664 19.106 100 18 36 2 1950671520 10976848 4803008
23:53:13 132564 8192000000 10904395824 11345100800 1905278144 18.869 98 27 54 0 1928014640 14114608 8621888
23:55:34 85397 8192000000 10902408336 11352637440 1945492752 19.191 99 29 58 0 1969362224 15375744 8493728
23:57:13 38719 8192000000 10909524160 11367931904 1974872576 19.424 100 29 58 0 2003671472 20614096 8184800
23:58:06 157056 8192000000 10908777760 11379486720 1963015616 19.330 99 17 33 0 1981588752 13695776 4877360
00:00:49 48590 8192000000 10917005488 11377094656 1964118752 19.339 99 14 28 1 1984258048 16149264 3990032
00:02:14 70868 8192000000 10876747952 11337924608 1911777488 18.921 97 15 29 1 1928648832 13217424 3653920
00:03:35 92051 8192000000 10902926592 11378290688 1973038800 19.410 100 16 32 2 1996639584 19089632 4511152
00:05:13 92716 8192000000 10904833152 11378188288 1963462256 19.334 99 13 27 0 1977374064 10359104 3552704
00:07:01 12206 8192000000 10919777616 11369414656 1987852416 19.527 100 41 82 2 2006497408 7096368 11548624
00:07:26 38413 8192000000 10933500720 11382620160 1989439584 19.539 100 34 67 0 2010468896 11409760 9619552
00:08:10 11206 8192000000 10946619088 11390717952 1998764384 19.613 100 61 122 0 2028767296 11990112 18012800
00:08:29 39507 8192000000 10923225104 11383062528 1972810960 19.408 99 14 28 1 1990505504 13780032 3914512
00:09:18 104330 8192000000 10924501216 11413200896 1966900640 19.361 99 11 22 0 1990019968 20377952 2741376
00:11:31 49570 8192000000 10923045776 11376136192 1951958416 19.242 98 19 38 0 1968396240 11073456 5364368
00:12:27 40533 8192000000 10925840800 11372109824 1949506944 19.223 98 37 74 0 1972976304 12655760 10813600
00:13:31 75814 8192000000 10922806304 11391856640 1962526960 19.326 99 17 33 2 1988210720 20884480 4799280
00:14:55 106304 8192000000 10903432336 11361030144 1914837120 18.945 96 15 30 1 1939203472 20027600 4338752
00:16:53 68020 8192000000 10910218416 11360444416 1971897888 19.401 100 37 71 2 1989330144 6977040 10455216
00:18:09 81754 8192000000 10887275008 11361566720 1906299984 18.877 96 29 58 0 1923223760 9419824 7503952
00:20:10 30354 8192000000 10884509056 11356184576 1946548816 19.199 99 18 36 1 1962866576 11458160 4859600
00:20:54 40517 8192000000 10894316880 11367620608 1966964304 19.361 100 11 22 1 1980839824 11084320 2791200
00:22:41 50918 8192000000 10891285872 11359432704 1947082384 19.203 98 25 51 0 1966727920 12528272 7117264
00:23:38 57187 8192000000 10891306368 11369914368 1935949328 19.114 98 20 40 0 1956019072 13842064 6227680
00:24:42 31748 8192000000 10883110720 11358408704 1932411344 19.086 98 20 39 2 1955525456 16843216 6270896
00:25:31 56106 8192000000 10872793344 11355951104 1888017216 18.730 97 18 36 0 1914046816 20189296 5840304
00:26:40 67244 8192000000 10816112656 11284684800 1820721904 18.184 94 11 22 0 1840403744 16447920 3233920
00:27:56 43524 8192000000 10844448048 11297423360 1838573328 18.329 95 20 40 1 1851364736 8005120 4786288
00:28:51 36272 8192000000 10865458256 11313467392 1857440656 18.483 96 30 60 2 1877953184 11956864 8555664
00:29:36 73162 8192000000 10854483264 11327983616 1835020336 18.300 95 25 49 3 1854455520 12333040 7102144
00:31:03 43535 8192000000 10886980944 11308777472 1836316560 18.311 95 31 62 0 1852999632 7785728 8897344
00:31:56 30490 8192000000 10852237712 11304808448 1913472192 18.935 100 38 76 3 1940364448 16384032 10508224
00:32:44 60840 8192000000 10844122288 11306553344 1832824544 18.282 95 25 50 1 1850812928 11127200 6861184
00:33:51 59303 8192000000 10860865008 11311808512 1869817104 18.583 97 24 48 0 1887400864 10958400 6625360
00:34:57 75979 8192000000 10843872160 11288465408 1819841248 18.176 95 10 20 0 1834968496 11906720 3220528
00:36:20 26132 8192000000 10882186080 11320655872 1929399168 19.062 100 40 80 0 1950695856 10354896 10941792
00:36:54 42297 8192000000 10860226912 11332440064 1934619120 19.104 100 29 58 0 1957002736 14475280 7908336
00:37:52 123598 8192000000 10875131136 11330342912 1847514464 18.402 95 16 32 1 1868553952 16703552 4335936
00:40:01 131991 8192000000 10865439616 11337703424 1939104752 19.140 100 25 50 2 1960444368 13748976 7590640
00:42:20 62715 8192000000 10878592160 11346239488 1952785680 19.249 100 17 34 0 1972452048 15071600 4594768
00:43:29 40452 8192000000 10879409408 11347017728 1949148864 19.220 100 18 36 0 1968365232 13497824 5718544
00:45:12 45060 8192000000 10871294288 11345747968 1947345696 19.205 100 5 10 0 1959810576 11045824 1419056
00:46:03 65230 8192000000 10855444016 11324674048 1916830512 18.961 98 11 22 0 1931054480 11182320 3041648
00:47:28 57988 8192000000 10853600352 11323527168 1887456160 18.725 97 9 18 0 1904604000 14093712 3054128
00:48:39 55314 8192000000 10869591776 11335446528 1914283600 18.941 99 15 30 0 1933162560 14168096 4710864
00:49:47 53243 8192000000 10872988720 11339317248 1925707056 19.033 99 22 44 0 1949485920 17210256 6568608
00:51:49 92728 8192000000 10881978624 11369385984 1953562768 19.255 100 14 28 2 1982955536 24488704 4904064
00:53:33 44021 8192000000 10875065024 11328933888 1897978288 18.810 97 14 28 1 1911114832 9703888 3432656
00:54:24 38912 8192000000 10879253040 11340079104 1913842848 18.937 98 33 66 0 1935327760 11808096 9676816
00:55:10 36559 8192000000 10894488544 11352330240 1957773312 19.288 100 25 50 2 1977760784 12574512 7412960
00:56:09 55621 8192000000 10929011984 11381178368 1971210080 19.395 100 19 38 1 1990965216 14041392 5713744
00:57:11 48396 8192000000 10928890240 11395764224 1981599984 19.477 100 20 40 0 2007360048 20183152 5576912
00:58:25 72850 8192000000 10915772496 11384561664 1980820000 19.471 100 10 20 0 1997260832 13417136 3023696
00:59:44 70227 8192000000 10921592368 11397857280 1989384816 19.539 100 13 26 1 2003641024 10869360 3386848
01:01:02 101660 8192000000 10925508336 11361411072 1889414768 18.741 95 13 26 0 1905447360 12197680 3834912
01:02:50 22454 8192000000 10904558624 11357036544 1920110512 18.988 97 44 87 0 1941670016 9783584 11775920
01:03:18 16327 8192000000 10915761600 11368665088 1967873376 19.369 100 41 82 2 1992419968 13186784 11359808
01:03:44 27261 8192000000 10936016112 11377287168 1976734976 19.439 100 40 79 0 1999661248 11923600 11002672
01:04:18 29649 8192000000 10935980096 11375423488 1948870752 19.217 98 48 96 2 1976266096 14002576 13392768
01:04:54 70610 8192000000 10916431648 11386216448 1981436384 19.476 100 28 56 0 2005320672 16582192 7302096
01:06:33 76607 8192000000 10910992096 11376836608 1947576496 19.207 98 23 44 1 1964940816 11127008 6237312
01:07:55 67763 8192000000 10852529616 11310080000 1881686304 18.679 95 21 43 0 1901668688 13844640 6137744
01:09:18 76552 8192000000 10875857968 11350745088 1931878080 19.082 99 7 14 1 1948050112 13926768 2245264
01:11:34 56773 8192000000 10858431792 11344637952 1913215344 18.932 98 10 17 1 1927454832 10886624 3352864
01:12:39 81051 8192000000 10856211296 11326095360 1859038208 18.495 95 19 38 1 1878155168 13704544 5412416
01:14:27 93212 8192000000 10855093904 11344502784 1877444688 18.644 97 12 24 1 1899800800 18717408 3638704
01:16:06 39009 8192000000 10864231216 11322331136 1892514896 18.766 98 21 42 6 1910056640 11372992 6168752
01:16:55 41579 8192000000 10847580304 11315621888 1872642064 18.606 97 29 59 1 1892441200 11359088 8440048
01:17:43 67289 8192000000 10838511008 11315847168 1855082256 18.463 96 12 24 0 1870450656 12287312 3081088
01:19:07 47307 8192000000 10834361824 11299995648 1876362768 18.636 98 9 18 1 1886530608 7997888 2169952
01:20:04 45737 8192000000 10846154400 11303329792 1871621472 18.597 97 23 46 1 1891655072 13738288 6295312
01:20:56 71577 8192000000 10870010304 11330236416 1882686688 18.687 98 23 46 0 1907311872 17718992 6906192
01:22:14 91791 8192000000 10839974512 11318542336 1829131216 18.252 95 13 26 3 1852631248 19523024 3977008
01:24:25 101591 8192000000 10854654160 11314262016 1861430752 18.515 97 5 9 0 1874009248 11615456 963040
01:26:16 59429 8192000000 9656889296 10050682880 607346768 6.902 32 3 6 0 615302016 7269600 685648

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:29, from 15-12-2020 01:28:07 to 15-12-2020 01:28:36.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 15-12-2020 01:28:37 to 15-12-2020 01:28:38.

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          246737
MON$OLDEST_ACTIVE               247074
MON$OLDEST_SNAPSHOT             247074
MON$NEXT_TRANSACTION            247074
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                       2041632
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.33400 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33400 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33400 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33400 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 ---
:57: 
:58: mscs-test-161.budzdorov.ru    Tue Dec 15 01:27:17 2020
:59:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:60: 
:61: 
:62: mscs-test-161.budzdorov.ru    Tue Dec 15 01:27:17 2020
:63:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:64: 
--- end of diff output ---

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

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