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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17354420 kB
MemAvailable 31659992 kB
Buffers 0 kB
Cached 14365252 kB
SwapCached 2260 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-11-29 19:27:01
DTS_END                         2020-11-29 19:27:01.3200
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/40110
TRN_ID                          243753
ATT_ID                          721
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: 9130.47 25579 1095656
customer order: creation 175.23 332 21027
customer order: refuse 15.82 342 1898
order to supplier: creation 46.86 1212 5623
order to supplier: removal 3.42 101821 410
invoice (draft): creation 46.76 3326 5611
invoice (draft): removal 51.47 806 6176
invoice accept: apply 42.48 19320 5097
invoice accept: cancel 46.15 824 5538
customer reserve: creation 3927.09 191 471251
customer reserve: removal 4475.18 61 537021
realization accept: apply 83.97 170 10076
realization accept: cancel 85.54 111 10265
payment from customer: creation 60.62 120 7274
payment from customer: removal 5.77 56 692
payment to supplier: creation 48.83 128 5860
payment to supplier: removal 3.28 71 394
service: total inventory turnovers 4.72 1177 566
service: total monetary turnovers 6.53 27 783
service: aggregate perf. data 0.75 23999 90
service: refresh index statistics 0.03 357481 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 29-11-2020 19:28:35 to 29-11-2020 19:28:37.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6364
TEST_TIME 2 6507
TEST_TIME 3 5531
TEST_TIME 4 5423
TEST_TIME 5 5311
TEST_TIME 6 5557
TEST_TIME 7 5751
TEST_TIME 8 5825
TEST_TIME 9 6436
TEST_TIME 10 6463
TEST_TIME 11 6615
TEST_TIME 12 7408
TEST_TIME 13 7663
TEST_TIME 14 7650
TEST_TIME 15 7924
TEST_TIME 16 7857
TEST_TIME 17 8113
TEST_TIME 18 8699
TEST_TIME 19 9038
TEST_TIME 20 9273
TEST_TIME 21 9274
TEST_TIME 22 9376
TEST_TIME 23 9501
TEST_TIME 24 9499
TEST_TIME 25 9529
TEST_TIME 26 9998
TEST_TIME 27 10080
TEST_TIME 28 10139
TEST_TIME 29 10911
TEST_TIME 30 10894
TEST_TIME 31 10810
TEST_TIME 32 10553
TEST_TIME 33 10337
TEST_TIME 34 10135
TEST_TIME 35 10091
TEST_TIME 36 10607
TEST_TIME 37 10631
TEST_TIME 38 10472
TEST_TIME 39 10396
TEST_TIME 40 10268
TEST_TIME 41 10306
TEST_TIME 42 10115
TEST_TIME 43 10216
TEST_TIME 44 10170
TEST_TIME 45 10154
TEST_TIME 46 10059
TEST_TIME 47 10021
TEST_TIME 48 10165
TEST_TIME 49 10307
TEST_TIME 50 10308
TEST_TIME 51 10145
TEST_TIME 52 9984
TEST_TIME 53 9930
TEST_TIME 54 9915
TEST_TIME 55 9911
TEST_TIME 56 9799
TEST_TIME 57 9784
TEST_TIME 58 9747
TEST_TIME 59 9641
TEST_TIME 60 9742
TEST_TIME 61 9695
TEST_TIME 62 9655
TEST_TIME 63 9613
TEST_TIME 64 9500
TEST_TIME 65 9568
TEST_TIME 66 9577
TEST_TIME 67 9560
TEST_TIME 68 9617
TEST_TIME 69 9596
TEST_TIME 70 9593
TEST_TIME 71 9654
TEST_TIME 72 9627
TEST_TIME 73 9610
TEST_TIME 74 9611
TEST_TIME 75 9672
TEST_TIME 76 9621
TEST_TIME 77 9697
TEST_TIME 78 9692
TEST_TIME 79 9645
TEST_TIME 80 9583
TEST_TIME 81 9542
TEST_TIME 82 9526
TEST_TIME 83 9500
TEST_TIME 84 9460
TEST_TIME 85 9524
TEST_TIME 86 9478
TEST_TIME 87 9495
TEST_TIME 88 9447
TEST_TIME 89 9380
TEST_TIME 90 9349
TEST_TIME 91 9335
TEST_TIME 92 9317
TEST_TIME 93 9300
TEST_TIME 94 9285
TEST_TIME 95 9259
TEST_TIME 96 9325
TEST_TIME 97 9322
TEST_TIME 98 9359
TEST_TIME 99 9338
TEST_TIME 100 9371
TEST_TIME 101 9350
TEST_TIME 102 9367
TEST_TIME 103 9355
TEST_TIME 104 9387
TEST_TIME 105 9426
TEST_TIME 106 9430
TEST_TIME 107 9414
TEST_TIME 108 9496
TEST_TIME 109 9424
TEST_TIME 110 9368
TEST_TIME 111 9332
TEST_TIME 112 9322
TEST_TIME 113 9293
TEST_TIME 114 9255
TEST_TIME 115 9230
TEST_TIME 116 9237
TEST_TIME 117 9201
TEST_TIME 118 9232
TEST_TIME 119 9209
TEST_TIME 120 9134

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 29-11-2020 19:28:39 to 29-11-2020 19:28:42.

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 1531336 1531336 0 0.00 0 20843 7 0 0
doc_list_biud 1531336 1531336 0 0.00 0 45171 27 0 0
sp_add_invoice_to_stock 5202 5097 105 2.01 25 161516 19320 0 105
sp_cancel_adding_invoice 5538 5538 0 0.00 5 64587 824 0 0
sp_cancel_client_order 1898 1898 0 0.00 4 9452 343 0 0
sp_cancel_customer_reserve 537021 537021 0 0.00 1 45181 61 0 0
sp_cancel_pay_from_customer 692 692 0 0.00 3 2181 56 0 0
sp_cancel_pay_to_supplier 394 394 0 0.00 2 2341 71 0 0
sp_cancel_supplier_invoice 6185 6176 9 0.14 2 17583 806 0 9
sp_cancel_supplier_order 410 410 0 0.00 7 1086823 101821 0 0
sp_cancel_write_off 10265 10265 0 0.00 1 13509 112 0 0
sp_client_order 21027 21027 0 0.00 3 25201 332 0 0
sp_customer_reserve 471251 471251 0 0.00 0 79870 192 0 0
sp_fill_shopping_cart 32260 32260 0 0.00 1 19377 38 0 0
sp_fill_shopping_cart_clo_res 471244 471244 0 0.00 0 26102 14 0 0
sp_get_clo_for_invoice 5090 5090 0 0.00 0 23132 282 0 0
sp_kill_cost_storno 16889 16889 0 0.00 0 16571 60 0 0
sp_kill_qstorno_ret_qs2qd 1090893 1090893 0 0.00 0 45116 33 0 0
sp_kill_qty_storno 576474 576474 0 0.00 0 45171 71 0 0
sp_lock_selected_doc 21085 21085 0 0.00 0 8405 4 0 0
sp_make_cost_storno 28300 28300 0 0.00 0 20729 55 0 0
sp_multiply_rows_for_pdistr 28300 28300 0 0.00 0 19028 30 0 0
sp_multiply_rows_for_qdistr 21027 21027 0 0.00 0 16940 140 0 0
sp_pay_from_customer 7274 7274 0 0.00 4 20848 120 0 0
sp_pay_to_supplier 5860 5860 0 0.00 4 20847 128 0 0
sp_payment_common 13134 13134 0 0.00 1 19013 32 0 0
sp_qd_handle_on_cancel_clo 1898 1898 0 0.00 0 9446 315 0 0
sp_qd_handle_on_invoice_upd_sts 10628 10628 0 0.00 0 25148 335 0 0
sp_qd_handle_on_reserve_upd_sts 10076 10076 0 0.00 0 20675 52 0 0
sp_reserve_write_off 10076 10076 0 0.00 6 20861 170 0 0
sp_supplier_invoice 5611 5611 0 0.00 6 103297 3327 0 0
sp_supplier_order 5623 5623 0 0.00 5 24984 1212 0 0
srv_aggregate_perf_data 90 90 0 0.00 2848 367441 24000 0 0
srv_fill_mon_cache_memory 168 168 0 0.00 1249 136176 31239 0 0
srv_find_qd_qs_mism 1046799 1046799 0 0.00 0 13393 6 0 0
srv_make_invnt_saldo 566 566 0 0.00 43 39015 1178 0 0
srv_make_money_saldo 783 783 0 0.00 1 1196 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 195029 497235 357481 0 0
t$perf-abend:sp_add_invoice_to_stock 105 105 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5097 5097 0 0.00 0 15959 164 0 0
t$perf-norm:sp_cancel_adding_invoice 412 412 0 0.00 0 2744 82 0 0
t$perf-norm:sp_cancel_client_order 1898 1898 0 0.00 0 4155 14 0 0
t$perf-norm:sp_cancel_customer_reserve 649 649 0 0.00 0 1858 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 692 692 0 0.00 0 24790 38 0 0
t$perf-norm:sp_cancel_pay_to_supplier 394 394 0 0.00 0 1237 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 422 422 0 0.00 0 1561 19 0 0
t$perf-norm:sp_cancel_supplier_order 410 410 0 0.00 0 21308 1544 0 0
t$perf-norm:sp_cancel_write_off 1042 1042 0 0.00 0 5268 13 0 0
t$perf-norm:sp_client_order 21027 21027 0 0.00 0 16915 15 0 0
t$perf-norm:sp_customer_reserve 1086 1086 0 0.00 0 6475 9 0 0
t$perf-norm:sp_pay_from_customer 7274 7274 0 0.00 0 9580 11 0 0
t$perf-norm:sp_pay_to_supplier 5860 5860 0 0.00 0 12347 11 0 0
t$perf-norm:sp_reserve_write_off 10076 10076 0 0.00 0 6101 9 0 0
t$perf-norm:sp_supplier_invoice 5611 5611 0 0.00 0 17661 17 0 0
t$perf-norm:sp_supplier_order 5623 5623 0 0.00 0 12298 16 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 701 21 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 976 9 0 0
t$perf-norm:srv_make_invnt_saldo 566 566 0 0.00 0 1924 27 0 0
t$perf-norm:srv_make_money_saldo 783 783 0 0.00 0 695 10 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10390 10180 210 2.02 0 7015 19 0 210
v_all_customers 38432 38432 0 0.00 0 18 1 0 0
v_all_suppliers 30766 30766 0 0.00 0 48 1 0 0
v_all_wares 42054 42054 0 0.00 0 52 1 0 0
v_cancel_adding_invoice 824 824 0 0.00 0 2416 11 0 0
v_cancel_client_order 3796 3796 0 0.00 0 2648 6 0 0
v_cancel_customer_prepayment 1384 1384 0 0.00 0 2152 4 0 0
v_cancel_customer_reserve 1298 1298 0 0.00 0 3149 8 0 0
v_cancel_payment_to_supplier 788 788 0 0.00 0 1041 5 0 0
v_cancel_supplier_invoice 862 844 18 2.08 0 3604 24 0 18
v_cancel_supplier_order 820 820 0 0.00 0 2735 8 0 0
v_cancel_write_off 2084 2084 0 0.00 0 2436 15 0 0
v_max_id_clo_ord 5622 5622 0 0.00 0 3003 2 0 0
v_max_id_clo_res 1086 1086 0 0.00 0 1637 15 0 0
v_max_id_ord_sup 5611 5611 0 0.00 0 3551 4 0 0
v_max_non_paid_invoice 1710 1710 0 0.00 0 3113 5 0 0
v_max_non_paid_realizn 3895 3895 0 0.00 0 6161 6 0 0
v_min_id_clo_ord 5622 5622 0 0.00 0 6177 7 0 0
v_min_id_clo_res 1086 1086 0 0.00 0 4215 11 0 0
v_min_id_ord_sup 5611 5611 0 0.00 0 3246 4 0 0
v_min_non_paid_invoice 5860 5860 0 0.00 0 17722 18 0 0
v_min_non_paid_realizn 7274 7274 0 0.00 0 17724 21 0 0
v_our_firm 10380 10380 0 0.00 0 31 1 0 0
v_reserve_write_off 20152 20152 0 0.00 0 7041 7 0 0
x_lock_depdocs_on_canc_invoice 11292 11292 0 0.00 0 15900 133 0 0
x_lock_depdocs_on_canc_sup_ord 410 410 0 0.00 0 7686 426 0 0
x_make_qstorno_1000_1200 5623 5623 0 0.00 2 24070 1127 0 0
x_make_qstorno_1200_2000 5611 5611 0 0.00 3 103290 3202 0 0
x_make_qstorno_2100_3300 471251 471251 0 0.00 0 79857 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 29-11-2020 19:28:43 to 29-11-2020 19:28:47.

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
16:57:05 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:11 17112 8192000000 10255946736 10571206656 1177926208 12.571 91 66 131 0 1203436720 3314880 22195632
16:57:37 28532 8192000000 10348933392 10673053696 1405256960 14.642 100 84 168 0 1437313552 5087744 26968848
16:58:17 29502 8192000000 10414196128 10742931456 1448452560 15.024 100 85 170 1 1483606752 6454240 28699952
16:59:02 26907 8192000000 10441742576 10771873792 1488897088 15.379 100 92 183 1 1525693712 7754160 29042464
16:59:40 11786 8192000000 10446375568 10780823552 1502510384 15.498 100 88 176 0 1539142944 8587216 28045344
17:00:01 5563 8192000000 10449207200 10787729408 1509106160 15.556 100 85 170 0 1545221456 9095888 27019408
17:00:20 25322 8192000000 10479740192 10820280320 1520890048 15.658 100 88 176 1 1558042688 9380528 27772112
17:00:53 10777 8192000000 10484247424 10830237696 1539928688 15.823 100 80 160 0 1574963952 10086448 24948816
17:01:12 16567 8192000000 10506401264 10854510592 1557818528 15.977 100 81 162 1 1592364400 9924128 24621744
17:01:43 11249 8192000000 10515249280 10868273152 1576074320 16.134 100 75 149 2 1609396704 10462640 22859744
17:02:03 21809 8192000000 10548138224 10901794816 1595281920 16.299 100 81 161 0 1631155872 11068720 24805232
17:02:34 10256 8192000000 10554303792 10913050624 1615194496 16.469 100 83 166 0 1652041648 11534032 25313120
17:02:53 12788 8192000000 10584131200 10944729088 1634971520 16.637 100 84 167 0 1672548432 12341136 25235776
17:03:13 9462 8192000000 10603219760 10966011904 1656685744 16.821 100 78 156 1 1692819392 13085664 23047984
17:03:29 7413 8192000000 10610690512 10981888000 1676410544 16.987 100 78 156 1 1711555856 12764160 22381152
17:03:44 6691 8192000000 10628176528 10997346304 1687976576 17.084 100 75 150 0 1722014608 12135136 21902896
17:03:59 8006 8192000000 10645243168 11019399168 1706680192 17.241 100 78 156 1 1741373360 12427152 22266016
17:04:15 9285 8192000000 10653711072 11030380544 1717686944 17.333 100 73 144 1 1749941616 11932768 20321904
17:04:34 5492 8192000000 10677602736 11052683264 1736861424 17.493 100 78 154 4 1770738160 11837760 22038976
17:04:47 5503 8192000000 10683779872 11063500800 1752548480 17.623 100 86 172 2 1790583920 13251440 24784000
17:05:00 4845 8192000000 10711394416 11087101952 1770504704 17.771 100 86 172 0 1807922032 13321120 24096208
17:05:11 4222 8192000000 10718825552 11096870912 1775732192 17.814 100 86 171 0 1812893168 13761600 23399376
17:05:22 4875 8192000000 10717565344 11095900160 1779213520 17.843 100 81 162 1 1816760848 15068672 22478656
17:05:34 2737 8192000000 10733597440 11114192896 1792857872 17.955 100 90 180 0 1832602240 14868304 24876064
17:05:43 3650 8192000000 10734308496 11116752896 1791998512 17.948 100 86 173 1 1830249904 14168208 24083184
17:05:54 2549 8192000000 10737674064 11119521792 1800088976 18.015 100 90 180 0 1838938880 13714848 25135056
17:06:03 3871 8192000000 10736447856 11125501952 1807481152 18.075 100 86 170 2 1844527600 13088048 23958400
17:06:13 2310 8192000000 10750245040 11134795776 1815462752 18.141 100 85 170 0 1851850128 13217888 23169488
17:06:22 1839 8192000000 10759805600 11146661888 1823230992 18.204 100 88 177 0 1861914080 14091840 24591248
17:06:31 3229 8192000000 10754765632 11144953856 1823153424 18.203 100 84 167 2 1859242128 13318032 22770672
17:06:41 6674 8192000000 10786630752 11168907264 1826951632 18.234 100 80 159 2 1862424432 13767600 21705200
17:06:54 1822 8192000000 10788731248 11176005632 1841888144 18.356 100 84 169 1 1879342048 13686864 23767040
17:07:02 2347 8192000000 10784169008 11176673280 1845943808 18.389 100 92 186 3 1889579664 17143056 26492800
17:07:11 1680 8192000000 10797383968 11182010368 1849833056 18.421 100 91 181 1 1888310880 12178656 26299168
17:07:19 2039 8192000000 10798682256 11189854208 1854932240 18.462 100 87 174 3 1892327040 13100656 24294144
17:07:28 1889 8192000000 10806144368 11197059072 1861874192 18.518 100 91 183 2 1902093776 14016928 26202656
17:07:36 1839 8192000000 10811230416 11201531904 1868557536 18.573 100 90 181 1 1908635264 14770976 25306752
17:07:45 1251 8192000000 10821250032 11209035776 1873327136 18.611 100 91 182 2 1912581824 13477008 25777680
17:07:52 1663 8192000000 10814667328 11205533696 1875817136 18.631 100 97 192 1 1916098416 13143360 27137920
17:08:00 1491 8192000000 10818222352 11206815744 1874840592 18.623 100 90 183 0 1913520864 12963088 25717184
17:08:08 24576 8192000000 10771608384 11204251648 1871952896 18.600 100 62 125 0 1902433408 12606768 17873744
17:08:41 14641 8192000000 10811096992 11210149888 1876695616 18.638 100 77 153 4 1908093168 7454464 23943088
17:09:02 10679 8192000000 10807263392 11211399168 1877752416 18.647 100 67 136 1 1907048416 9792144 19503856
17:09:19 6500 8192000000 10784548640 11207389184 1871709952 18.598 100 45 90 0 1894005696 10025248 12270496
17:09:31 9774 8192000000 10781189952 11207585792 1874401136 18.620 100 27 54 1 1889287680 7471840 7414704
17:09:48 8832 8192000000 10788176960 11212759040 1878154080 18.650 100 36 73 0 1894855968 5517088 11184800
17:10:10 6597 8192000000 10786251216 11217485824 1877812320 18.647 100 31 62 1 1893610192 7005328 8792544
17:10:24 6309 8192000000 10779174528 11217584128 1875126640 18.626 100 15 31 1 1889047104 9947136 3973328
17:10:39 11928 8192000000 10788496128 11217645568 1877632128 18.646 100 21 42 2 1888865072 5402048 5830896
17:11:00 8094 8192000000 10801857120 11226267648 1883948032 18.697 100 28 55 0 1897481248 6341728 7191488
17:11:16 8344 8192000000 10793936128 11227381760 1891237808 18.756 100 29 58 0 1907547792 6825040 9484944
17:11:30 7631 8192000000 10795471600 11230597120 1886835232 18.720 100 12 24 2 1895785344 5650368 3299744
17:11:48 5932 8192000000 10800386528 11234099200 1892497216 18.766 100 20 40 0 1904198464 5907488 5793760
17:12:02 12240 8192000000 10795011344 11235586048 1894918496 18.785 100 11 22 1 1903679920 5846864 2914560
17:12:22 9698 8192000000 10811497616 11244703744 1900101824 18.827 100 24 47 2 1913201680 6584768 6515088
17:12:38 12137 8192000000 10805090432 11243642880 1900412624 18.830 100 17 34 1 1910790080 5392384 4985072
17:13:01 60688 8192000000 10847109360 11264208896 1907522336 18.887 100 27 53 3 1920723472 5210416 7990720
17:14:08 9930 8192000000 10821094352 11258306560 1910739600 18.913 100 35 70 1 1926631808 4956992 10935216
17:14:25 14987 8192000000 10829427440 11258916864 1892560464 18.766 99 35 70 4 1907954224 6319504 9074256
17:14:51 3812 8192000000 10828819936 11261583360 1910597168 18.911 100 42 86 0 1929951136 7113840 12240128
17:15:01 4181 8192000000 10832978624 11262582784 1909308576 18.901 100 30 60 3 1923406528 5880992 8216960
17:15:13 6393 8192000000 10831474720 11263488000 1891741536 18.760 99 27 54 0 1906356384 6925184 7689664
17:15:31 5669 8192000000 10826719632 11263307776 1910287568 18.909 100 32 62 2 1926232784 7464016 8481200
17:15:43 5276 8192000000 10820336848 11251859456 1889435664 18.741 99 31 64 0 1904629856 6350000 8844192
17:15:55 9697 8192000000 10808339504 11246407680 1895657728 18.791 100 19 38 3 1906641856 5341168 5642960
17:16:11 8118 8192000000 10800675008 11241017344 1877557520 18.645 99 20 40 0 1888301232 5247360 5496352
17:16:27 8945 8192000000 10832020640 11257323520 1880354672 18.668 99 13 27 1 1894114096 9944160 3815264
17:16:43 9182 8192000000 10779790784 11203182592 1830851072 18.266 97 9 18 1 1838400432 5152800 2396560
17:16:59 7896 8192000000 10777994384 11208802304 1844095280 18.374 99 22 44 0 1860930336 10887824 5947232
17:17:13 9736 8192000000 10745341984 11172196352 1767779840 17.749 95 17 34 1 1777805024 5296928 4728256
17:17:29 14840 8192000000 10743635632 11170807808 1760725472 17.690 95 15 30 2 1769722736 5245632 3751632
17:17:51 58649 8192000000 10781226160 11205214208 1852320240 18.441 100 21 42 1 1863875920 5060352 6495328
17:18:59 15179 8192000000 10745795792 11171356672 1758469440 17.672 95 24 48 1 1771360368 6164592 6726336
17:19:22 5529 8192000000 10758385296 11168305152 1809117840 18.089 98 45 90 1 1828145552 6356944 12670768
17:19:36 7886 8192000000 10740812112 11148140544 1765823888 17.733 96 30 60 1 1780733136 6519664 8389584
17:19:52 3486 8192000000 10732404672 11147976704 1791290512 17.942 98 40 82 2 1809602448 7064720 11247216
17:20:03 5094 8192000000 10713747616 11125186560 1747835440 17.584 97 30 56 4 1761391008 4952384 8603184
17:20:16 7700 8192000000 10702761984 11115921408 1747832752 17.584 97 22 43 0 1764113008 10549536 5730720
17:20:33 5429 8192000000 10707548416 11127500800 1791854368 17.947 100 24 48 0 1804366608 5825184 6687056
17:20:45 8247 8192000000 10724035936 11143163904 1805471344 18.059 100 28 56 2 1819866464 5844544 8550576
17:21:02 10121 8192000000 10716599840 11132084224 1744860608 17.559 96 27 53 1 1757391376 4214176 8316592
17:21:21 9688 8192000000 10722767856 11148902400 1809299600 18.090 100 18 36 0 1820210944 6237024 4674320
17:21:38 7178 8192000000 10710062928 11128684544 1754093376 17.636 97 26 50 1 1767326352 5011520 8221456
17:21:53 12146 8192000000 10702458560 11131412480 1791904944 17.947 99 23 46 1 1805270144 5726256 7638944
17:22:11 27612 8192000000 10734184464 11150819328 1783505952 17.878 98 23 46 4 1795651184 5284432 6860800
17:22:45 57796 8192000000 10748901424 11162263552 1810233120 18.098 99 33 66 1 1825928416 6355744 9339552
17:23:52 5913 8192000000 10749409984 11173400576 1837548032 18.321 100 31 62 5 1851863984 5923488 8392464
17:24:06 7095 8192000000 10755225072 11178913792 1839838688 18.339 100 26 53 0 1853933312 5762640 8331984
17:24:20 5839 8192000000 10767990608 11186122752 1841108848 18.350 100 32 62 3 1857110384 6109328 9892208
17:24:35 5532 8192000000 10755998112 11182575616 1841579504 18.354 100 24 48 1 1853982864 5362400 7040960
17:24:47 8447 8192000000 10762225280 11190755328 1845737248 18.387 100 25 50 1 1867555024 14437552 7380224
17:25:02 10557 8192000000 10771584288 11191422976 1848316528 18.408 100 22 45 2 1861503472 5551504 7635440
17:25:23 12964 8192000000 10759743600 11190915072 1846986752 18.398 100 16 32 1 1856826960 5420592 4419616
17:25:44 9450 8192000000 10766660448 11197927424 1853259088 18.449 100 10 20 0 1861249584 4908784 3081712
17:26:02 12179 8192000000 10775654736 11202199552 1857877344 18.486 100 19 38 1 1869084032 5281104 5925584
17:26:20 9378 8192000000 10774504384 11212742656 1866046560 18.552 100 14 28 2 1875550192 5434144 4069488
17:26:36 10161 8192000000 10779455968 11215179776 1868642448 18.573 100 17 34 0 1878928000 5363264 4922288
17:26:54 11075 8192000000 10805817472 11221495808 1875280720 18.627 100 19 37 1 1885638688 4968288 5389680
17:27:16 28131 8192000000 10832536880 11250647040 1904650496 18.864 100 53 105 1 1927125296 7517424 14957376
17:27:53 18784 8192000000 10850616928 11267923968 1919766560 18.985 100 54 108 3 1942681248 8118896 14795792
17:28:23 9687 8192000000 10868959968 11272482816 1922014912 19.003 100 56 111 1 1947039168 9075728 15948528
17:28:47 66504 8192000000 10859311168 11287719936 1926674944 19.040 100 54 108 0 1952484128 10766816 15042368
17:30:03 22209 8192000000 10856431248 11287638016 1933327504 19.093 100 40 80 0 1952733456 7493760 11912192
17:30:33 28721 8192000000 10876599216 11298459648 1939587744 19.143 100 40 76 1 1960342416 9799232 10955440
17:31:10 15651 8192000000 10889215312 11314630656 1951990112 19.242 100 56 112 1 1980378752 12320928 16067712
17:31:34 14916 8192000000 10885672240 11316994048 1954832016 19.265 100 49 98 0 1982065088 12944352 14288720
17:31:56 16166 8192000000 10885452576 11311890432 1933252944 19.093 99 51 103 2 1961597488 12948304 15396240
17:32:22 10969 8192000000 10892970368 11316027392 1953393328 19.253 100 47 93 0 1979456816 12624832 13438656
17:32:40 11470 8192000000 10906751520 11326341120 1959392864 19.301 100 57 114 0 1989621008 14267104 15961040
17:33:00 9559 8192000000 10912957248 11338956800 1966909264 19.361 100 61 122 2 2001934416 17261392 17763760
17:33:18 7106 8192000000 10912131616 11341570048 1973035616 19.410 100 63 124 1 2009073456 17659120 18378720
17:33:35 19361 8192000000 10919601152 11348541440 1973570816 19.414 100 52 104 1 2006143408 16959248 15613344
17:34:11 5523 8192000000 10928194352 11353190400 1979757312 19.463 100 62 122 3 2014980688 17553472 17669904
17:34:28 9380 8192000000 10925989232 11352518656 1988061360 19.528 100 55 110 2 2023512000 18098928 17351712
17:34:47 9520 8192000000 10920091712 11357790208 1984925408 19.504 100 42 84 1 2013782720 16848160 12009152
17:35:05 6684 8192000000 10919619424 11347664896 1975198752 19.427 100 61 121 0 2010406800 17436320 17771728
17:35:19 3867 8192000000 10942997664 11359113216 1983862464 19.495 100 71 140 1 2023158496 18587824 20708208
17:35:29 2228 8192000000 10949062864 11355873280 1982494416 19.484 100 81 159 2 2025668336 20865616 22308304
17:35:39 7142 8192000000 10940938256 11359621120 1983770304 19.495 100 72 143 0 2027744128 22755056 21218768
17:35:58 6643 8192000000 10928688208 11352461312 1963866048 19.337 99 63 125 1 2005064352 22632240 18566064
17:36:16 12291 8192000000 10913639888 11344224256 1970069520 19.386 100 65 130 1 2013715584 24111312 19534752
17:36:39 10525 8192000000 10935041136 11356327936 1978187168 19.450 100 67 134 1 2018065360 19323328 20554864
17:36:56 5146 8192000000 10932421984 11353944064 1978633840 19.454 100 64 126 0 2016859120 20189888 18035392
17:37:12 9524 8192000000 10938541008 11349594112 1959079312 19.299 99 71 141 1 2001478720 21824560 20574848
17:37:32 16150 8192000000 10929760160 11358990336 1972285168 19.404 100 58 116 0 2015907200 26235376 17386656
17:38:40 4704 8192000000 10909957088 11334250496 1954023664 19.259 99 52 104 2 1993361024 23512992 15824368
17:38:52 2232 8192000000 10943340944 11352752128 1972294384 19.404 100 83 165 4 2021740096 24358192 25087520
17:39:02 3015 8192000000 10941417136 11349979136 1956172896 19.276 99 92 184 1 2010355232 26617440 27564896
17:39:11 1904 8192000000 10932284464 11343319040 1962876688 19.329 100 94 185 2 2018525184 27686240 27962256
17:39:20 3738 8192000000 10935040544 11345682432 1968211424 19.371 100 85 171 1 2019222368 25608976 25401968
17:39:32 5076 8192000000 10941618928 11351670784 1973179648 19.411 100 77 154 0 2020313392 23307728 23826016
17:39:44 4361 8192000000 10918721216 11338833920 1954443984 19.262 99 68 130 2 1997103424 23483664 19175776
17:39:59 4867 8192000000 10921320400 11346255872 1964982256 19.346 100 72 144 1 2009163536 22985088 21196192
17:40:15 6274 8192000000 10928889904 11350642688 1964584656 19.342 100 58 117 0 2004731424 22185728 17961040
17:40:28 4993 8192000000 10906009328 11320307712 1934139008 19.100 99 70 140 2 1975170688 19841840 21189840
17:40:40 3246 8192000000 10910769824 11323305984 1950304080 19.229 100 73 145 2 1993670736 21970352 21396304
17:40:50 3852 8192000000 10905724688 11317366784 1932485520 19.087 99 79 156 1 1978944128 23071760 23386848
17:41:02 3757 8192000000 10912892272 11321688064 1944458848 19.182 100 81 162 1 1992263584 23456864 24347872
17:41:14 3304 8192000000 10917099840 11326930944 1951171712 19.236 100 81 160 1 1999486864 24094544 24220608
17:41:26 2974 8192000000 10907898688 11311656960 1926894864 19.042 99 85 168 0 1977785712 25257856 25632992
17:41:37 14081 8192000000 10900015728 11316961280 1935770992 19.113 100 78 156 1 1985837712 26927936 23138784
17:42:03 4365 8192000000 10908992240 11326193664 1941731776 19.161 100 65 130 0 1990980976 29588000 19661200
17:42:15 8290 8192000000 10899906944 11322232832 1932332656 19.086 99 67 133 1 1981280864 28628272 20319936
17:42:32 3521 8192000000 10933715888 11339726848 1955272848 19.268 100 77 154 2 2008242112 29034560 23934704
17:42:42 3204 8192000000 10911184288 11328069632 1921822640 19.001 98 74 149 0 1972913520 28172064 22918816
17:42:52 4511 8192000000 10924998480 11339304960 1958998960 19.298 100 81 160 0 2011575536 28765760 23810816
17:43:05 2900 8192000000 10917030192 11329740800 1947401216 19.206 100 80 160 1 1999707264 27267008 25039040
17:43:15 3540 8192000000 10925317728 11336278016 1952661584 19.248 100 82 162 1 2005674560 28236144 24776832
17:43:25 5151 8192000000 10917421808 11326713856 1918845216 18.978 98 83 167 2 1975268160 30493136 25929808
17:43:37 2773 8192000000 10911548192 11318636544 1930572416 19.071 100 85 168 1 1988206288 31494816 26139056
17:43:54 6067 8192000000 10910800640 11320573952 1919261072 18.981 99 68 135 0 1972125424 31932960 20931392
17:44:08 2794 8192000000 10910173600 11320393728 1921447408 18.998 99 81 161 1 1977803952 32111728 24244816
17:44:20 4461 8192000000 10917918576 11323011072 1923324464 19.013 99 78 154 2 1981190032 33842032 24023536
17:44:38 1249 8192000000 10925993328 11333955584 1939186064 19.140 100 95 189 4 2008105984 39482800 29437120
17:44:46 2074 8192000000 10939138592 11342106624 1948537536 19.215 100 86 169 2 2013605872 39358304 25710032
17:44:54 2085 8192000000 10938078656 11340496896 1943436592 19.174 100 84 168 1 2010471424 40672544 26362288
17:45:04 2302 8192000000 10916724880 11331268608 1938510016 19.135 100 78 157 1 2003054480 40136288 24408176
17:45:33 11877 8192000000 10884065920 11317923840 1896487712 18.798 98 42 84 0 1948697712 37878032 14331968
17:45:55 4692 8192000000 10909912336 11322626048 1911834528 18.921 99 77 151 1 1979887504 44519888 23533088
17:46:06 6668 8192000000 10878914528 11302174720 1914250912 18.941 100 45 88 1 1960410624 32020896 14138816
17:46:20 6791 8192000000 10894537424 11313741824 1927330624 19.046 100 56 108 5 1975115744 30361808 17423312
17:46:38 8183 8192000000 10905601968 11327041536 1938464928 19.135 100 67 133 1 1991349984 31593744 21291312
17:46:54 3772 8192000000 10895096192 11302359040 1895088128 18.787 98 81 160 1 1951518960 31022528 25408304
17:47:06 4444 8192000000 10914752256 11328102400 1936890448 19.122 100 82 162 1 1999266544 37397280 24978816
17:47:20 2101 8192000000 10932560720 11342557184 1946695280 19.200 100 85 170 0 2011670992 39027648 25948064
17:47:29 3131 8192000000 10921389616 11324547072 1918586272 18.976 99 88 175 0 1985835568 40619840 26629456
17:47:40 4212 8192000000 10910906800 11335356416 1937836320 19.129 100 80 160 0 2006915568 44613952 24465296
17:47:54 7550 8192000000 10902907248 11333906432 1932311472 19.085 100 60 117 1 1990633024 39299616 19021936
17:48:08 9596 8192000000 10896848960 11330359296 1935281888 19.109 100 30 60 1 1981416160 35987408 10146864
17:48:26 9335 8192000000 10916895280 11342925824 1947359632 19.205 100 65 129 0 2003190112 35073440 20757040
17:48:48 27007 8192000000 10909294416 11338813440 1924882784 19.026 99 45 90 1 1977635824 38157952 14595088
17:49:29 11581 8192000000 10918374768 11353194496 1947372176 19.206 100 44 88 2 2001714592 40019040 14323376
17:49:55 7195 8192000000 10912793456 11348086784 1948689104 19.216 100 41 81 2 2000602272 38846976 13066192
17:50:11 3529 8192000000 10922105744 11357167616 1952971248 19.250 100 38 76 0 2004286064 38291536 13023280
17:50:32 5312 8192000000 10934945584 11365556224 1960684768 19.311 100 55 110 0 2019577408 40900080 17992560
17:50:57 11478 8192000000 10914544752 11354640384 1942168576 19.164 99 35 70 0 1991019632 37520544 11330512
17:51:21 10414 8192000000 10932728784 11370377216 1957682480 19.288 100 35 70 1 2009554096 40431440 11440176
17:51:42 14071 8192000000 10927126224 11368390656 1961241872 19.316 100 32 64 4 2011523376 39772720 10508784
17:52:10 19794 8192000000 10911123392 11355312128 1928136336 19.052 99 30 60 1 1983023168 44433920 10452912
17:52:42 30047 8192000000 10915954032 11361296384 1937855776 19.130 100 32 64 0 1993780496 45133680 10791040
17:53:20 22902 8192000000 10899011760 11354152960 1937052384 19.123 100 20 40 2 1986330640 41972880 7305376
17:53:54 19248 8192000000 10906814832 11361935360 1945834032 19.193 100 20 40 2 1990142768 37360688 6948048
17:54:20 15486 8192000000 10902905840 11364253696 1944576272 19.183 100 17 34 1 1989089456 38634528 5878656
17:55:00 47136 8192000000 10903135344 11361779712 1937828144 19.129 100 13 26 0 1985231488 42436768 4966576
17:55:53 15000 8192000000 10902852240 11350368256 1920706112 18.992 99 26 52 0 1971137520 41370944 9060464
17:56:24 15505 8192000000 10895761904 11357564928 1946902096 19.202 100 25 50 2 1987942464 33272464 7767904
17:56:45 16015 8192000000 10863268368 11319791616 1913557760 18.935 99 26 52 2 1949858352 28170560 8130032
17:57:08 51800 8192000000 10891301200 11330666496 1913685104 18.936 98 26 53 1 1938928960 17736720 7507136
17:58:16 81848 8192000000 10885715984 11332702208 1899672736 18.824 97 31 60 1 1929247776 19699808 9875232
18:00:11 31045 8192000000 10908838048 11355353088 1957245856 19.284 100 42 85 1 1990967744 21022960 12698928
18:00:57 63368 8192000000 10927628416 11374272512 1961121280 19.315 100 24 48 1 1993478816 24822784 7534752
18:02:08 82699 8192000000 10900504576 11384811520 1949941568 19.226 99 17 34 0 1989338960 34079824 5317568
18:03:38 53681 8192000000 10894392912 11355602944 1957144048 19.283 100 14 29 0 1997109856 35748288 4217520
18:04:38 72179 8192000000 10904300864 11358523392 1969215424 19.379 100 16 34 0 1981385088 8066960 4102704
18:05:57 23152 8192000000 10906862320 11369824256 1974970224 19.425 100 14 28 2 1986548848 7515088 4063536
18:06:33 104745 8192000000 10911354480 11387260928 1976365136 19.436 100 16 32 1 1996677168 15857888 4454144
18:08:27 75166 8192000000 10931543584 11377823744 1981199888 19.474 100 17 28 2 2000577456 15486512 3891056
18:09:50 93847 8192000000 10942748880 11390820352 1990903376 19.551 100 35 69 1 2015669984 15275184 9491424
18:11:33 39695 8192000000 10911014336 11381563392 1970473040 19.389 99 12 24 2 1981972064 8181184 3317840
18:12:21 70854 8192000000 10914057440 11381075968 1982102272 19.481 100 5 10 0 1995044384 11645952 1296160
18:13:40 43848 8192000000 10941165504 11402526720 1983621264 19.493 99 38 76 2 2009834336 15082288 11130784
18:14:30 78384 8192000000 10924293984 11404300288 1972256144 19.403 99 8 16 0 1993254064 18772672 2225248
18:15:54 111666 8192000000 10934738640 11417395200 1970267168 19.388 99 7 14 0 1994551696 22316064 1968464
18:18:04 111267 8192000000 10913016384 11373166592 1954237680 19.260 98 8 14 0 1973173936 16689072 2247184
18:20:12 60974 8192000000 10920703952 11389149184 1977654976 19.446 99 22 44 1 1995440288 11539120 6246192
18:21:20 89588 8192000000 10896560960 11371675648 1903973552 18.858 95 19 38 1 1928475600 19653504 4848544
18:22:56 56795 8192000000 10898579872 11356090368 1906822704 18.881 96 21 42 1 1922390352 9541760 6025888
18:23:59 14144 8192000000 10898568608 11351130112 1961699824 19.320 99 44 88 1 1982964928 9297120 11967984
18:24:21 36341 8192000000 10891256768 11354210304 1940720464 19.153 98 21 42 1 1956010256 8967744 6322048
18:25:09 26478 8192000000 10887660080 11350810624 1932926192 19.090 98 24 48 1 1948418128 8019840 7472096
18:25:46 16390 8192000000 10899183536 11349983232 1962355856 19.325 100 40 80 3 1987225408 12553472 12316080
18:26:10 74837 8192000000 10888269632 11349311488 1935110448 19.108 98 41 82 2 1968108304 21004784 11993072
18:27:44 50406 8192000000 10892235904 11381407744 1956902976 19.281 100 8 16 0 1979419728 20323824 2192928
18:29:11 96018 8192000000 10879813824 11346657280 1908702192 18.896 97 13 26 0 1928189040 16277328 3209520
18:30:53 78135 8192000000 10870756272 11342872576 1937070992 19.123 99 8 16 0 1948793488 9421696 2300800
18:32:23 61431 8192000000 10884808000 11360833536 1936861536 19.122 99 11 22 1 1948609584 8746080 3001968
18:33:31 42897 8192000000 10867346608 11328901120 1855375664 18.466 95 13 26 0 1866155312 7419520 3360128
18:35:12 84778 8192000000 10880150064 11345293312 1906365952 18.877 98 18 36 0 1923171040 11048560 5756528
18:36:47 31429 8192000000 10889724848 11338215424 1933561280 19.095 99 38 76 1 1954285040 9856832 10866928
18:37:26 27235 8192000000 10876971744 11332292608 1908570432 18.895 98 46 92 1 1933758160 12185120 13002608
18:38:01 61304 8192000000 10853905632 11315728384 1859207680 18.497 96 19 38 1 1880540304 14925056 6407568
18:39:09 40257 8192000000 10862610544 11308507136 1870702816 18.590 97 31 62 0 1888074384 8614256 8757312
18:40:26 53745 8192000000 10856771776 11312988160 1873805616 18.615 97 28 56 2 1893337120 11189824 8341680
18:41:29 75743 8192000000 10858866592 11331158016 1896821632 18.801 98 10 20 1 1914209712 14940720 2447360
18:43:37 32745 8192000000 10894346912 11341512704 1950598160 19.231 100 41 82 0 1976734928 14630928 11505840
18:44:18 35444 8192000000 10873018608 11340578816 1928678192 19.056 99 25 50 1 1948557600 13193552 6685856
18:45:00 81454 8192000000 10870586208 11330854912 1853989824 18.455 95 8 16 0 1867648368 11627728 2030816
18:46:29 18962 8192000000 10893522848 11338481664 1922764192 19.009 98 51 102 3 1949545440 12053232 14728016
18:46:55 40024 8192000000 10900952032 11346251776 1954274336 19.261 100 43 86 2 1978000112 11350000 12375776
18:47:44 96662 8192000000 10874204480 11334410240 1915482640 18.951 98 25 49 1 1934218352 11477024 7258688
18:49:27 70728 8192000000 10888496496 11350487040 1926936832 19.042 99 21 42 1 1952099936 19077872 6085232
18:50:45 19761 8192000000 10882081680 11349590016 1930019376 19.067 99 17 32 1 1954609376 20109744 4480256
18:51:12 10177 8192000000 10885043280 11355340800 1949409952 19.222 100 22 44 2 1976717424 21045408 6262064
18:51:33 14988 8192000000 10865474448 11338809344 1930605008 19.072 100 18 36 1 1959624928 23524288 5495632
18:52:32 68882 8192000000 10853398944 11326898176 1880827952 18.672 97 14 28 0 1895377072 10535168 4013952
18:53:47 53153 8192000000 10859435376 11327668224 1919186640 18.980 99 13 26 1 1932097568 9311424 3599504
18:54:47 67733 8192000000 10859184064 11327041536 1907518784 18.887 98 12 24 0 1918034256 6906992 3608480
18:56:10 54721 8192000000 10868326848 11339816960 1945806880 19.193 100 16 32 0 1961123120 10630432 4685808
18:57:51 57712 8192000000 10883213232 11358437376 1957921216 19.290 100 17 34 1 1977307424 14803008 4583200
18:59:10 71524 8192000000 10886972384 11363188736 1971937744 19.401 100 15 30 0 1984683520 8225616 4520160
19:00:29 67160 8192000000 10877591616 11354968064 1934479968 19.103 98 5 10 0 1943610528 8159728 970832
19:01:53 30258 8192000000 10910497648 11378892800 1984453808 19.500 100 33 66 1 2003326448 9358976 9513664
19:02:30 50810 8192000000 10906951648 11384385536 1984108112 19.497 100 25 50 1 2002484928 10718368 7658448
19:03:35 63892 8192000000 10909390288 11383021568 1973105040 19.410 99 15 30 2 1987781136 10034816 4641280
19:04:54 55327 8192000000 10900091088 11368906752 1927920832 19.050 97 22 40 1 1945479088 11121488 6436768
19:06:02 47480 8192000000 10897461072 11354066944 1915243648 18.949 97 18 36 1 1928775216 8767872 4763696
19:07:21 48239 8192000000 10885481152 11346677760 1928038672 19.051 98 19 38 0 1942006400 9055008 4912720
19:08:16 22453 8192000000 10895159600 11351928832 1924553584 19.023 98 28 54 2 1940555520 8353456 7648480
19:08:47 28979 8192000000 10888749376 11349471232 1942488160 19.167 99 30 60 1 1960705776 10158560 8059056
19:09:33 22033 8192000000 10906135696 11352981504 1943090720 19.171 99 39 78 2 1964134880 10303072 10741088
19:10:03 27449 8192000000 10917556544 11361775616 1949240496 19.220 99 53 104 1 1978841648 15185808 14415344
19:10:37 19311 8192000000 10912953296 11366539264 1968917056 19.377 100 35 70 1 1989464288 11051840 9495392
19:11:03 76534 8192000000 10881185344 11359993856 1908987664 18.899 97 20 40 0 1924513088 10310208 5215216
19:12:27 70070 8192000000 10877207488 11348561920 1899070816 18.819 97 10 19 1 1912165232 10407200 2687216
19:13:43 27182 8192000000 10885745008 11345510400 1943644848 19.176 100 10 20 1 1957866752 11081216 3140688
19:14:18 40701 8192000000 10899850560 11365154816 1951728880 19.240 99 29 56 1 1972771904 13132640 7910384
19:15:05 136176 8192000000 10880267856 11354198016 1884337136 18.700 96 13 26 0 1906304960 18491888 3475936
19:17:51 36908 8192000000 10857484848 11310907392 1898309680 18.813 98 27 54 1 1914325568 8381504 7634384
19:18:42 83003 8192000000 10875897136 11353108480 1932691184 19.088 99 12 24 0 1948655600 12263408 3701008
19:21:07 87111 8192000000 10846485712 11313098752 1844891600 18.381 95 17 34 0 1864212624 14430672 4890352
19:22:43 59446 8192000000 10833766464 11300179968 1886901440 18.721 98 14 28 1 1906309072 15245328 4162304
19:23:49 46748 8192000000 10802064608 11277783040 1813854288 18.127 95 10 20 0 1831497728 14467824 3175616
19:24:42 54635 8192000000 10819981904 11285938176 1848358400 18.409 98 7 14 0 1859677712 9422032 1897280
19:25:43 64790 8192000000 10835973664 11299270656 1839004416 18.333 96 19 37 0 1856562496 11361296 6196784
19:26:55 17739 8192000000 9517961008 9835859968 662281584 7.479 35 3 5 0 671077680 8022432 773664

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 29-11-2020 19:28:49 to 29-11-2020 19:29:21.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 29-11-2020 19:29:22 to 29-11-2020 19:29:24.

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          244715
MON$OLDEST_ACTIVE               244716
MON$OLDEST_SNAPSHOT             244716
MON$NEXT_TRANSACTION            244716
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                       2052320
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.33394 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33394 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33394 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 ---
:101: 
:102: mscs-test-161.budzdorov.ru    Sun Nov 29 19:27:21 2020
:103:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:104: 
--- end of diff output ---

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

29.11.20 19:29:25. 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-11-29 19:29:27 No severe PSQL-related problems occured
29.11.20 19:29:28. End of report.