Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 14.03.2021 19: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 df9f488d08424df294c459d6c283e9c3
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 2021-03-04 16:07
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.26
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 17717504 kB
MemAvailable 31543480 kB
Buffers 0 kB
Cached 13937072 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-14 19:27:26
DTS_END                         2021-03-14 19:27:26.5290
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(131:22) ==> SP_CANCEL_ADDING_INVOICE(33:5) ==> SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/47652
TRN_ID                          241369
ATT_ID                          675
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: 9179.08 22138 1101489
customer order: creation 173.99 344 20879
customer order: refuse 14.35 312 1722
order to supplier: creation 44.45 1176 5334
order to supplier: removal 3.45 98878 414
invoice (draft): creation 47.13 3083 5656
invoice (draft): removal 52.49 761 6299
invoice accept: apply 41.58 18105 4989
invoice accept: cancel 47.13 735 5656
customer reserve: creation 3858.84 179 463061
customer reserve: removal 4597.36 59 551683
realization accept: apply 85.05 157 10206
realization accept: cancel 81.03 114 9723
payment from customer: creation 60.81 112 7297
payment from customer: removal 5.99 66 719
payment to supplier: creation 49.83 121 5980
payment to supplier: removal 3.55 54 426
service: total inventory turnovers 5.18 964 622
service: total monetary turnovers 6.13 40 735
service: aggregate perf. data 0.70 28534 84
service: refresh index statistics 0.03 288967 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-03-2021 19:28:20 to 14-03-2021 19:28:22.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2133
TEST_TIME 2 3107
TEST_TIME 3 3898
TEST_TIME 4 4119
TEST_TIME 5 4682
TEST_TIME 6 4383
TEST_TIME 7 4432
TEST_TIME 8 4748
TEST_TIME 9 4850
TEST_TIME 10 4814
TEST_TIME 11 5150
TEST_TIME 12 5247
TEST_TIME 13 5539
TEST_TIME 14 5859
TEST_TIME 15 6366
TEST_TIME 16 6480
TEST_TIME 17 6918
TEST_TIME 18 6953
TEST_TIME 19 7124
TEST_TIME 20 8351
TEST_TIME 21 8726
TEST_TIME 22 8579
TEST_TIME 23 8771
TEST_TIME 24 9320
TEST_TIME 25 10942
TEST_TIME 26 11095
TEST_TIME 27 10755
TEST_TIME 28 10561
TEST_TIME 29 10456
TEST_TIME 30 10298
TEST_TIME 31 10098
TEST_TIME 32 10025
TEST_TIME 33 10147
TEST_TIME 34 10106
TEST_TIME 35 9994
TEST_TIME 36 9736
TEST_TIME 37 9589
TEST_TIME 38 9569
TEST_TIME 39 9705
TEST_TIME 40 9653
TEST_TIME 41 9628
TEST_TIME 42 9710
TEST_TIME 43 9693
TEST_TIME 44 9618
TEST_TIME 45 9573
TEST_TIME 46 9600
TEST_TIME 47 9638
TEST_TIME 48 9706
TEST_TIME 49 9714
TEST_TIME 50 9806
TEST_TIME 51 9803
TEST_TIME 52 9741
TEST_TIME 53 9620
TEST_TIME 54 9555
TEST_TIME 55 9507
TEST_TIME 56 9401
TEST_TIME 57 9429
TEST_TIME 58 9420
TEST_TIME 59 9370
TEST_TIME 60 9331
TEST_TIME 61 9247
TEST_TIME 62 9194
TEST_TIME 63 9170
TEST_TIME 64 9113
TEST_TIME 65 9204
TEST_TIME 66 9290
TEST_TIME 67 9254
TEST_TIME 68 9372
TEST_TIME 69 9357
TEST_TIME 70 9363
TEST_TIME 71 9392
TEST_TIME 72 9381
TEST_TIME 73 9401
TEST_TIME 74 9447
TEST_TIME 75 9444
TEST_TIME 76 9566
TEST_TIME 77 9597
TEST_TIME 78 9487
TEST_TIME 79 9446
TEST_TIME 80 9422
TEST_TIME 81 9445
TEST_TIME 82 9390
TEST_TIME 83 9329
TEST_TIME 84 9265
TEST_TIME 85 9287
TEST_TIME 86 9246
TEST_TIME 87 9176
TEST_TIME 88 9275
TEST_TIME 89 9247
TEST_TIME 90 9248
TEST_TIME 91 9249
TEST_TIME 92 9228
TEST_TIME 93 9288
TEST_TIME 94 9309
TEST_TIME 95 9274
TEST_TIME 96 9343
TEST_TIME 97 9344
TEST_TIME 98 9305
TEST_TIME 99 9322
TEST_TIME 100 9337
TEST_TIME 101 9350
TEST_TIME 102 9422
TEST_TIME 103 9348
TEST_TIME 104 9269
TEST_TIME 105 9252
TEST_TIME 106 9250
TEST_TIME 107 9187
TEST_TIME 108 9139
TEST_TIME 109 9109
TEST_TIME 110 9176
TEST_TIME 111 9205
TEST_TIME 112 9198
TEST_TIME 113 9194
TEST_TIME 114 9198
TEST_TIME 115 9195
TEST_TIME 116 9197
TEST_TIME 117 9211
TEST_TIME 118 9248
TEST_TIME 119 9200
TEST_TIME 120 9184

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-03-2021 19:28:24 to 14-03-2021 19:28:27.

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 1529448 1529448 0 0.00 0 27919 7 0 0
doc_list_biud 1529447 1529447 0 0.00 0 80604 27 0 0
sp_add_invoice_to_stock 5141 4989 152 2.95 23 187536 18105 0 152
sp_cancel_adding_invoice 5656 5656 0 0.00 5 87477 736 0 0
sp_cancel_client_order 1722 1722 0 0.00 4 11994 313 0 0
sp_cancel_customer_reserve 551683 551683 0 0.00 1 80606 59 0 0
sp_cancel_pay_from_customer 719 719 0 0.00 2 8464 66 0 0
sp_cancel_pay_to_supplier 426 426 0 0.00 3 3141 55 0 0
sp_cancel_supplier_invoice 6310 6299 11 0.17 2 25323 761 0 11
sp_cancel_supplier_order 414 414 0 0.00 6 1139789 98879 0 0
sp_cancel_write_off 9723 9723 0 0.00 1 8488 114 0 0
sp_client_order 20879 20879 0 0.00 3 29959 345 0 0
sp_customer_reserve 463061 463061 0 0.00 0 60242 180 0 0
sp_fill_shopping_cart 31865 31865 0 0.00 1 25025 36 0 0
sp_fill_shopping_cart_clo_res 463053 463053 0 0.00 0 33304 14 0 0
sp_get_clo_for_invoice 4979 4979 0 0.00 0 35900 308 0 0
sp_kill_cost_storno 16524 16524 0 0.00 0 4700 55 0 0
sp_kill_qstorno_ret_qs2qd 1119802 1119802 0 0.00 0 80590 32 0 0
sp_kill_qty_storno 590681 590681 0 0.00 0 80604 69 0 0
sp_lock_selected_doc 20979 20979 0 0.00 0 7846 5 0 0
sp_make_cost_storno 28461 28461 0 0.00 0 27905 58 0 0
sp_multiply_rows_for_pdistr 28461 28461 0 0.00 0 6469 24 0 0
sp_multiply_rows_for_qdistr 20879 20879 0 0.00 0 11924 150 0 0
sp_pay_from_customer 7297 7297 0 0.00 4 13287 113 0 0
sp_pay_to_supplier 5980 5980 0 0.00 4 11429 122 0 0
sp_payment_common 13277 13277 0 0.00 2 12171 33 0 0
sp_qd_handle_on_cancel_clo 1722 1722 0 0.00 0 11988 293 0 0
sp_qd_handle_on_invoice_upd_sts 10634 10634 0 0.00 0 58315 306 0 0
sp_qd_handle_on_reserve_upd_sts 10206 10206 0 0.00 0 18927 53 0 0
sp_reserve_write_off 10206 10206 0 0.00 6 18945 158 0 0
sp_supplier_invoice 5656 5656 0 0.00 6 104225 3084 0 0
sp_supplier_order 5334 5334 0 0.00 5 30742 1176 0 0
srv_aggregate_perf_data 84 84 0 0.00 2698 621019 28534 0 0
srv_fill_mon_cache_memory 144 144 0 0.00 1877 164288 36108 0 0
srv_find_qd_qs_mism 1052859 1052859 0 0.00 0 8662 6 0 0
srv_make_invnt_saldo 622 622 0 0.00 21 48269 964 0 0
srv_make_money_saldo 735 735 0 0.00 1 8035 41 0 0
srv_recalc_idx_stat 4 4 0 0.00 170828 522338 288967 0 0
t$perf-abend:sp_add_invoice_to_stock 152 152 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4989 4989 0 0.00 0 32618 158 0 0
t$perf-norm:sp_cancel_adding_invoice 410 410 0 0.00 0 23286 215 0 0
t$perf-norm:sp_cancel_client_order 1722 1722 0 0.00 0 4138 14 0 0
t$perf-norm:sp_cancel_customer_reserve 703 703 0 0.00 0 3963 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 719 719 0 0.00 0 4558 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 426 426 0 0.00 0 192 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 407 407 0 0.00 0 414 9 0 0
t$perf-norm:sp_cancel_supplier_order 414 414 0 0.00 0 34747 1497 0 0
t$perf-norm:sp_cancel_write_off 994 994 0 0.00 0 12640 19 0 0
t$perf-norm:sp_client_order 20879 20879 0 0.00 0 30998 20 0 0
t$perf-norm:sp_customer_reserve 1002 1002 0 0.00 0 3857 6 0 0
t$perf-norm:sp_pay_from_customer 7297 7297 0 0.00 0 30997 20 0 0
t$perf-norm:sp_pay_to_supplier 5980 5980 0 0.00 0 4211 8 0 0
t$perf-norm:sp_reserve_write_off 10206 10206 0 0.00 0 7956 11 0 0
t$perf-norm:sp_supplier_invoice 5656 5656 0 0.00 0 4813 14 0 0
t$perf-norm:sp_supplier_order 5334 5334 0 0.00 0 2051 11 0 0
t$perf-norm:srv_aggregate_perf_data 84 84 0 0.00 0 5 0 0 0
t$perf-norm:srv_fill_mon_cache_memory 144 144 0 0.00 0 6408 65 0 0
t$perf-norm:srv_make_invnt_saldo 622 622 0 0.00 0 2598 16 0 0
t$perf-norm:srv_make_money_saldo 735 735 0 0.00 0 2915 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 7 4 0 0
v_add_invoice_to_stock 10260 9956 304 2.96 0 3959 17 0 304
v_all_customers 38300 38300 0 0.00 0 15 0 0 0
v_all_suppliers 30738 30738 0 0.00 0 12 1 0 0
v_all_wares 41758 41758 0 0.00 0 15 1 0 0
v_cancel_adding_invoice 820 820 0 0.00 0 2184 10 0 0
v_cancel_client_order 3444 3444 0 0.00 0 1385 4 0 0
v_cancel_customer_prepayment 1438 1438 0 0.00 0 3485 8 0 0
v_cancel_customer_reserve 1406 1406 0 0.00 0 874 4 0 0
v_cancel_payment_to_supplier 852 852 0 0.00 0 256 3 0 0
v_cancel_supplier_invoice 836 814 22 2.63 0 2112 16 0 22
v_cancel_supplier_order 828 828 0 0.00 0 391 3 0 0
v_cancel_write_off 1988 1988 0 0.00 0 4644 15 0 0
v_max_id_clo_ord 5334 5334 0 0.00 0 9385 3 0 0
v_max_id_clo_res 1002 1002 0 0.00 0 1212 14 0 0
v_max_id_ord_sup 5652 5652 0 0.00 0 2930 2 0 0
v_max_non_paid_invoice 1597 1597 0 0.00 0 5361 5 0 0
v_max_non_paid_realizn 3842 3842 0 0.00 0 4513 6 0 0
v_min_id_clo_ord 5334 5334 0 0.00 0 4176 7 0 0
v_min_id_clo_res 1002 1002 0 0.00 0 7625 14 0 0
v_min_id_ord_sup 5652 5652 0 0.00 0 3478 4 0 0
v_min_non_paid_invoice 5980 5980 0 0.00 0 9022 21 0 0
v_min_non_paid_realizn 7297 7297 0 0.00 0 8561 18 0 0
v_our_firm 10368 10368 0 0.00 0 15 1 0 0
v_reserve_write_off 20412 20412 0 0.00 0 3464 5 0 0
x_lock_depdocs_on_canc_invoice 11548 11548 0 0.00 0 18439 111 0 0
x_lock_depdocs_on_canc_sup_ord 414 414 0 0.00 0 3409 300 0 0
x_make_qstorno_1000_1200 5334 5334 0 0.00 2 30736 1108 0 0
x_make_qstorno_1200_2000 5656 5656 0 0.00 3 104203 2946 0 0
x_make_qstorno_2100_3300 463061 463061 0 0.00 0 60216 164 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-03-2021 19:28:28 to 14-03-2021 19:28:32.

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:30 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:36 14022 8192000000 10207666112 10514477056 914888144 10.046 73 57 116 0 936432160 2466736 19077280
16:57:58 29431 8192000000 10327264240 10641666048 1372781424 14.352 100 77 154 0 1401676784 4204096 24691264
16:58:38 17629 8192000000 10369045456 10689146880 1423252192 14.802 100 84 167 0 1455963440 5845328 26865920
16:59:15 30408 8192000000 10400385232 10726387712 1453651856 15.070 100 90 180 0 1490549728 7453952 29443920
16:59:54 22685 8192000000 10414307008 10744119296 1473202960 15.242 100 90 180 1 1510549456 8282560 29063936
17:00:27 15081 8192000000 10447874080 10779766784 1497428768 15.454 100 86 172 0 1533308176 8679792 27199616
17:00:55 18172 8192000000 10463251728 10797215744 1519075088 15.642 100 94 188 1 1558704448 10125584 29503776
17:01:23 19436 8192000000 10480894544 10820907008 1535757392 15.787 100 91 181 0 1574580368 10407808 28415168
17:01:49 16064 8192000000 10488881632 10835193856 1548469344 15.897 100 86 173 1 1585381152 11085024 25826784
17:02:15 11910 8192000000 10519373920 10867245056 1570284640 16.085 100 79 158 1 1604963712 11565408 23113664
17:02:37 9988 8192000000 10536665312 10889990144 1592879616 16.278 100 85 170 3 1630657584 12350192 25427776
17:02:56 11529 8192000000 10556811568 10911522816 1607177280 16.401 100 78 156 1 1642677248 12097072 23402896
17:03:15 10112 8192000000 10580043872 10936156160 1635832640 16.644 100 89 178 3 1676150336 13312800 27004896
17:03:35 14677 8192000000 10607004064 10969169920 1656243584 16.817 100 84 168 2 1694841312 13178816 25418912
17:03:57 5428 8192000000 10620549984 10983686144 1675483296 16.979 100 82 161 2 1711962848 12494384 23985168
17:04:09 9719 8192000000 10636418048 11001970688 1694687840 17.141 100 77 154 1 1729450288 12529664 22232784
17:04:26 5391 8192000000 10643089392 11012767744 1704441776 17.222 100 83 165 1 1742179760 13220672 24517312
17:04:39 4974 8192000000 10656422464 11027402752 1719448720 17.348 100 87 170 0 1756596208 13057760 24089728
17:04:51 5800 8192000000 10670701456 11042447360 1730627088 17.441 100 79 158 1 1765688688 12272496 22789104
17:05:04 3846 8192000000 10684183280 11056590848 1744678640 17.557 100 82 159 2 1779651424 11865712 23107072
17:05:15 4691 8192000000 10692318064 11066601472 1753384000 17.630 100 82 162 1 1790818480 13156432 24278048
17:05:26 4236 8192000000 10703857888 11077455872 1762611328 17.706 100 84 164 2 1798498896 12920288 22967280
17:05:38 3229 8192000000 10708504768 11088261120 1773672464 17.797 100 78 156 1 1808735776 12497840 22565472
17:05:48 5254 8192000000 10713216608 11095199744 1781515760 17.862 100 85 167 1 1818379072 13202400 23660912
17:06:00 2780 8192000000 10731767520 11107196928 1793614624 17.961 100 82 164 1 1828986544 12651168 22720752
17:06:10 3726 8192000000 10734270192 11114209280 1797799536 17.996 100 88 175 0 1836514656 14073616 24641504
17:06:21 2974 8192000000 10744378160 11123806208 1805904080 18.062 100 88 173 3 1842576048 13402352 23269616
17:06:30 8878 8192000000 10746471840 11132219392 1806263744 18.065 100 84 168 0 1844302000 14360944 23677312
17:06:45 4678 8192000000 10754395696 11135438848 1815306656 18.139 100 87 175 1 1854409808 15082544 24020608
17:06:58 2421 8192000000 10780354848 11163176960 1826716144 18.233 100 90 179 2 1866874608 15564640 24593824
17:07:07 2250 8192000000 10776175712 11163267072 1834873664 18.299 100 89 177 2 1873494304 13298816 25321824
17:07:16 1446 8192000000 10781967472 11166294016 1842003968 18.357 100 89 178 1 1879545488 12595504 24946016
17:07:24 2262 8192000000 10783625440 11169890304 1842912864 18.365 100 91 180 2 1881170688 11387184 26870640
17:07:33 1687 8192000000 10796166064 11181346816 1848864624 18.413 100 94 188 1 1886096640 11663520 25568496
17:07:41 2058 8192000000 10805615168 11190554624 1857283008 18.481 100 94 188 0 1896655776 12906528 26466240
17:07:49 1674 8192000000 10805103776 11190329344 1857823424 18.486 100 90 181 0 1898085920 14077280 26185216
17:07:58 3789 8192000000 10815603808 11199356928 1863197040 18.529 100 93 185 2 1903043696 13471072 26375584
17:08:08 1768 8192000000 10811440032 11198844928 1863602128 18.532 100 94 189 1 1904303968 14076960 26624880
17:08:16 33619 8192000000 10766145536 11192098816 1860882544 18.510 100 51 102 0 1886483680 10954416 14646720
17:08:58 9923 8192000000 10777799536 11189645312 1859334592 18.498 100 31 61 1 1874786064 6008688 9442784
17:09:14 2949 8192000000 10788517168 11201081344 1865797488 18.550 100 50 99 0 1887424112 7349648 14276976
17:09:25 9594 8192000000 10760925680 11192594432 1861632800 18.517 100 24 46 2 1874924288 6725536 6565952
17:09:45 4316 8192000000 10779602592 11199131648 1867563424 18.565 100 36 71 1 1884061872 5964656 10533792
17:09:55 7123 8192000000 10776648560 11203280896 1870278480 18.587 100 25 50 4 1883755184 6482032 6994672
17:10:11 7796 8192000000 10782860912 11206860800 1871163776 18.594 100 20 40 1 1882663568 6072976 5426816
17:10:28 6537 8192000000 10779649936 11208699904 1873996656 18.617 100 23 46 1 1887263120 6644368 6622096
17:10:42 12062 8192000000 10782161904 11210342400 1879623520 18.662 100 22 44 1 1892513888 6968160 5922208
17:11:02 12497 8192000000 10790636160 11219283968 1885155200 18.707 100 24 49 0 1901976224 10140352 6680672
17:11:23 11717 8192000000 10790972896 11220631552 1886677648 18.719 100 32 64 0 1902510480 6829040 9003792
17:11:42 13573 8192000000 10792248304 11222700032 1885908336 18.713 100 20 40 0 1897563024 5823808 5830880
17:12:02 18439 8192000000 10792837008 11229253632 1890233648 18.748 100 12 22 0 1899030960 5562880 3234432
17:12:26 76137 8192000000 10809272896 11242778624 1898918656 18.818 100 25 49 2 1911063296 5037296 7107344
17:13:50 6562 8192000000 10823340624 11254210560 1900996784 18.834 100 38 76 1 1922946512 11382752 10566976
17:14:05 9615 8192000000 10823945280 11255558144 1907338608 18.885 100 35 71 4 1924524816 6777504 10408704
17:14:21 6027 8192000000 10818663920 11253522432 1904559680 18.863 100 23 44 2 1916830752 6282576 5988496
17:14:33 6725 8192000000 10814183632 11247460352 1887453376 18.725 99 29 58 1 1902291184 6755920 8081888
17:14:48 7194 8192000000 10822012112 11252244480 1901964144 18.842 100 28 57 2 1915539216 5998976 7576096
17:15:03 10270 8192000000 10824946224 11249328128 1885963824 18.713 99 19 39 1 1896698656 5454544 5280288
17:15:22 7573 8192000000 10823734768 11259109376 1904288896 18.861 100 21 40 2 1920176512 10134192 5753424
17:15:40 9557 8192000000 10809215072 11244904448 1884503776 18.701 99 20 41 2 1895507008 5349296 5653936
17:15:59 12143 8192000000 10811583680 11244130304 1863676640 18.533 98 17 31 2 1873438640 5212880 4549120
17:16:17 9648 8192000000 10810755824 11245264896 1895893760 18.793 100 26 50 1 1909400512 5784608 7722144
17:16:33 6599 8192000000 10801780160 11234406400 1874166144 18.618 99 22 44 3 1886812656 6036784 6609728
17:16:47 11246 8192000000 10785493984 11214651392 1857369200 18.482 99 16 32 1 1866949968 5237088 4343680
17:17:07 12438 8192000000 10785841280 11209310208 1862060944 18.520 100 20 39 1 1877999232 10382384 5555904
17:17:30 47411 8192000000 10781429184 11208019968 1846061200 18.390 99 37 74 0 1867787584 11061328 10665056
17:18:29 8058 8192000000 10768646896 11193311232 1824166448 18.212 98 27 54 2 1838221120 6872336 7182336
17:18:43 9701 8192000000 10740752416 11163185152 1756019600 17.651 95 18 36 0 1770794160 9976000 4798560
17:18:59 5116 8192000000 10712681680 11123613696 1738849728 17.509 95 31 62 1 1757471216 10289376 8332112
17:19:11 6199 8192000000 10718171264 11137085440 1774723216 17.806 98 35 70 0 1792437024 8021504 9692304
17:19:24 7385 8192000000 10724517872 11145060352 1785137952 17.892 98 28 56 1 1799859472 6477088 8244432
17:19:37 9290 8192000000 10679333232 11091324928 1640312656 16.682 90 25 48 2 1653279232 5589648 7376928
17:19:53 7994 8192000000 10676789888 11093770240 1735875104 17.484 97 17 34 0 1745780976 5168208 4737664
17:20:07 6023 8192000000 10708148320 11128643584 1783447648 17.878 99 31 62 2 1799182064 5017760 10716656
17:20:21 8569 8192000000 10695923120 11109941248 1730409504 17.439 96 27 54 0 1744721648 6612560 7699584
17:20:36 9125 8192000000 10715643488 11128913920 1777615056 17.830 99 21 42 0 1788723152 5383600 5724496
17:20:52 8486 8192000000 10704078880 11120242688 1732028336 17.452 96 28 56 0 1745951456 5202496 8720624
17:21:09 16752 8192000000 10723668832 11146985472 1809086544 18.088 100 28 56 0 1823610016 5951904 8571568
17:21:34 9904 8192000000 10729354384 11156246528 1800216896 18.016 99 24 48 1 1816850016 9751952 6881168
17:21:51 65736 8192000000 10725459632 11148238848 1785238512 17.893 98 31 62 1 1799995776 5706800 9050464
17:23:05 7947 8192000000 10727826560 11155320832 1794603360 17.970 98 15 30 0 1804160032 5442112 4114560
17:23:19 9200 8192000000 10753214816 11174412288 1832082208 18.276 100 31 62 2 1848511488 7708256 8721024
17:23:36 10420 8192000000 10742427968 11174375424 1837448544 18.320 100 20 40 1 1849376128 6507024 5420560
17:23:53 8252 8192000000 10758120816 11186561024 1843189536 18.367 100 21 41 1 1854235440 5229152 5816752
17:24:07 8897 8192000000 10765213264 11191173120 1845836128 18.388 100 18 36 0 1860253648 9311232 5106288
17:24:22 8315 8192000000 10761930672 11191783424 1850362704 18.425 100 32 63 1 1869858176 10192704 9302768
17:24:39 12568 8192000000 10771462816 11195154432 1854729904 18.461 100 24 48 1 1866633424 5515856 6387664
17:25:01 7981 8192000000 10771521616 11202912256 1863993248 18.536 100 20 40 2 1875694112 5665024 6035840
17:25:15 14121 8192000000 10796386016 11212595200 1866617968 18.557 100 29 58 0 1880758752 5010016 9130768
17:25:35 11374 8192000000 10781573152 11214512128 1869667520 18.582 100 23 46 1 1881872464 5588320 6616624
17:25:52 13441 8192000000 10780125312 11218882560 1874490768 18.621 100 26 52 3 1887894816 6028608 7375440
17:26:13 10218 8192000000 10786810704 11220217856 1875334912 18.627 100 20 40 2 1886834016 5828816 5670288
17:26:29 21689 8192000000 10824624592 11236917248 1875352688 18.628 100 16 32 0 1885283760 5660176 4270896
17:26:58 133499 8192000000 10851986560 11276541952 1892967872 18.770 100 30 60 0 1910990192 9885072 8137248
17:29:31 7691 8192000000 10865640704 11289325568 1930792576 19.073 100 41 82 0 1954877008 12597856 11486576
17:29:48 5488 8192000000 10880027280 11303448576 1942147920 19.164 100 58 114 3 1972449568 13972432 16329216
17:30:08 13402 8192000000 10886040256 11312132096 1945709264 19.192 100 43 86 0 1972182576 14736720 11736592
17:30:31 8834 8192000000 10900634912 11325288448 1957581600 19.287 100 58 112 0 1987824400 14413200 15829600
17:30:47 24763 8192000000 10906575408 11332194304 1960524144 19.310 100 56 112 1 1993625824 16935040 16166640
17:31:18 35286 8192000000 10902986048 11334844416 1960912224 19.313 100 47 94 1 1993713296 19225856 13575216
17:32:10 26866 8192000000 10900792128 11343060992 1966714416 19.359 100 40 80 1 1995664656 16852320 12097920
17:32:44 32947 8192000000 10914230592 11353821184 1974353712 19.420 100 39 76 0 2005677568 19751744 11572112
17:33:29 11785 8192000000 10928554624 11363463168 1988584432 19.533 100 44 88 0 2018665120 17502896 12577792
17:33:58 9605 8192000000 10936279616 11372498944 1995899776 19.590 100 55 108 1 2030625568 18321696 16404096
17:34:18 19847 8192000000 10947751120 11387342848 1999030016 19.615 100 40 80 3 2031841712 20352320 12459376
17:34:51 9608 8192000000 10964102144 11396038656 2008309408 19.688 100 54 106 1 2048245904 23242128 16694368
17:35:08 5651 8192000000 10958715568 11395592192 2011992384 19.717 100 49 98 0 2049899024 23251312 14655328
17:35:23 8387 8192000000 10961417424 11397279744 2015117552 19.742 100 48 95 0 2051357968 21902736 14337680
17:35:40 29678 8192000000 10946873088 11386773504 1987428656 19.523 99 50 98 3 2026224144 23594800 15200688
17:36:24 10628 8192000000 10950162960 11391639552 2005315280 19.665 100 48 96 0 2046459056 25856016 15287760
17:36:45 13273 8192000000 10968382784 11407302656 2010092560 19.702 100 47 94 2 2053450416 28182160 15175696
17:37:16 7460 8192000000 10967337536 11406696448 2016908704 19.756 100 48 96 3 2060781440 29179664 14693072
17:37:48 5121 8192000000 10987154928 11421007872 2026272848 19.829 100 61 120 3 2077722832 32980368 18469616
17:38:00 6971 8192000000 10984331600 11421257728 2012858368 19.724 99 61 119 0 2066423120 34241216 19323536
17:38:23 10698 8192000000 11010205776 11444760576 2033092544 19.883 100 49 98 0 2093039984 44068384 15879056
17:38:41 6300 8192000000 10997712256 11424374784 2012278304 19.719 99 76 152 1 2074843136 38370864 24193968
17:38:58 16981 8192000000 10992057104 11428917248 2007896896 19.685 99 56 112 2 2068843200 43057072 17889232
17:39:23 4945 8192000000 10992322112 11430268928 2022920080 19.803 100 60 117 2 2083542432 41855104 18767248
17:39:34 7864 8192000000 10992123104 11422863360 2014456352 19.737 100 56 112 1 2078757792 46691184 17610256
17:39:51 4361 8192000000 11004089904 11435667456 2024628080 19.816 100 67 133 3 2088421168 43853648 19939440
17:40:05 3967 8192000000 11014338320 11443871744 2032035056 19.875 100 69 138 0 2099929040 45491744 22402240
17:40:17 4117 8192000000 10982586352 11398418432 1992663664 19.565 99 78 154 2 2063833600 47426192 23743744
17:40:29 2805 8192000000 10993317344 11408969728 2000202048 19.624 99 86 171 2 2072086256 46444080 25440128
17:40:39 1876 8192000000 11005615744 11425484800 2000796176 19.629 99 86 172 3 2076322256 48382128 27143952
17:40:48 6978 8192000000 11008942352 11432243200 2014740512 19.739 100 76 149 1 2090657824 52652960 23264352
17:41:04 7052 8192000000 10988616160 11417378816 2001019056 19.631 100 70 139 0 2071966912 48721888 22225968
17:41:19 5985 8192000000 10973088896 11401306112 1982618464 19.485 99 64 129 1 2056205424 52495328 21091632
17:41:33 5958 8192000000 11001548560 11425898496 2008792352 19.692 100 78 154 2 2083392960 50193744 24406864
17:41:48 5535 8192000000 11007330016 11431772160 2009844752 19.700 100 71 141 1 2084399072 52470624 22083696
17:42:01 6875 8192000000 11015359824 11438075904 2016209520 19.750 100 74 148 3 2093558800 54611504 22737776
17:42:18 2668 8192000000 11023870384 11443331072 2022258256 19.798 100 86 170 2 2103206496 54825632 26122608
17:42:30 1989 8192000000 11023377664 11448897536 2027973296 19.843 100 82 165 1 2105978816 53273744 24731776
17:42:40 11458 8192000000 11017816992 11446652928 2025882416 19.826 100 72 144 1 2099536704 50916240 22738048
17:43:02 4798 8192000000 11005257904 11433418752 1997547456 19.603 99 66 129 4 2072193840 54200048 20446336
17:43:15 3412 8192000000 11009435392 11440111616 2013438544 19.729 100 67 134 1 2091594144 56912384 21243216
17:43:28 7026 8192000000 10983058704 11407671296 1975757728 19.431 99 80 160 3 2059485024 57801152 25926144
17:43:44 2522 8192000000 10992836976 11405991936 1970437824 19.389 99 81 160 1 2055093664 58298000 26357840
17:43:56 2655 8192000000 11009964352 11427385344 2000363520 19.626 100 84 169 1 2086533552 60512064 25657968
17:44:12 2832 8192000000 11020930784 11433373696 2006792208 19.676 100 88 172 2 2093852752 61162496 25898048
17:44:21 2247 8192000000 11012085040 11436507136 2008452672 19.689 100 76 151 1 2094142304 61712992 23976640
17:44:32 2959 8192000000 11013487040 11434754048 1993197552 19.569 99 85 170 0 2082847008 62206160 27443296
17:44:41 3257 8192000000 11005198704 11425042432 1991588288 19.556 99 82 164 0 2080164256 62830704 25745264
17:44:53 3803 8192000000 11001187296 11427647488 1997998592 19.607 100 69 138 0 2081479104 61891488 21589024
17:45:10 15094 8192000000 10956432864 11398549504 1951812544 19.241 98 37 74 2 2024931536 60698688 12420304
17:45:32 4325 8192000000 10973880896 11399974912 1972628384 19.406 100 63 125 3 2056893408 62965296 21299728
17:45:44 3275 8192000000 10989382000 11415027712 1981632752 19.478 100 67 134 3 2067077712 63349040 22095920
17:45:53 5136 8192000000 10989847568 11409178624 1976781776 19.439 100 84 164 3 2069843008 65767008 27294224
17:46:06 8262 8192000000 10963676992 11398766592 1942221776 19.164 98 58 115 0 2029367984 68650752 18495456
17:46:23 7319 8192000000 10989064832 11415384064 1978710688 19.454 100 70 138 0 2071688656 71234208 21743760
17:46:38 2349 8192000000 10980893136 11393871872 1947619344 19.208 98 82 164 2 2046747632 73497440 25630848
17:46:46 3349 8192000000 11002715952 11420708864 1979676080 19.462 100 84 167 0 2083645200 77223328 26745792
17:46:59 8111 8192000000 10988304864 11432513536 1981249248 19.475 100 54 108 0 2076787184 78004176 17533760
17:47:16 19048 8192000000 10940607392 11394822144 1936855072 19.122 98 42 83 1 2017923680 66098064 14970544
17:47:41 35813 8192000000 10926582864 11381297152 1923744528 19.017 98 32 64 1 1990322208 55653664 10924016
17:48:23 16521 8192000000 10924513680 11384274944 1947982304 19.210 100 20 40 0 2006605872 51803376 6820192
17:48:50 28000 8192000000 10926002224 11379494912 1949409120 19.222 100 21 42 0 2011909856 54957216 7543520
17:49:32 30929 8192000000 10933689808 11393454080 1955359776 19.269 100 25 50 3 2020722832 56846608 8516448
17:50:10 19096 8192000000 10926547808 11374567424 1925765936 19.033 99 32 64 0 2002211216 64588624 11856656
17:50:36 31785 8192000000 10907909040 11362635776 1906827936 18.881 98 26 52 0 1980682112 62803488 11050688
17:51:15 30102 8192000000 10923687344 11386540032 1932399472 19.086 100 30 60 0 2003813120 60405504 11008144
17:51:53 33652 8192000000 10904050848 11371372544 1912344272 18.925 99 15 30 0 1973839344 56061888 5433184
17:53:22 52816 8192000000 10858817088 11315175424 1897884272 18.809 98 11 22 0 1910684368 9712720 3087376
17:54:36 7189 8192000000 10828992848 11276869632 1877497200 18.645 98 26 53 0 1893065072 7909984 7657888
17:54:56 28789 8192000000 10859739312 11287732224 1863907520 18.535 97 59 121 2 1887987776 7557344 16522912
17:55:32 19003 8192000000 10869870416 11310604288 1923611696 19.016 100 47 94 2 1949513328 13065680 12835952
17:56:04 26317 8192000000 10844462560 11306262528 1902243344 18.844 99 18 36 1 1918334912 11133120 4958448
17:57:51 162945 8192000000 10884961488 11360755712 1930045552 19.067 98 19 38 0 1951941840 16122080 5774208
18:00:48 44071 8192000000 10883046688 11352727552 1936005984 19.115 99 15 31 0 1952596000 12708608 3881408
18:01:44 164269 8192000000 10873110368 11333898240 1925830416 19.034 98 15 30 0 1936659472 6870752 3958304
18:04:39 45341 8192000000 10886501984 11350773760 1931124896 19.076 98 19 37 1 1947649856 11008816 5516144
18:05:31 69197 8192000000 10887679280 11368726528 1947816784 19.209 99 10 20 0 1964113456 12761872 3534800
18:06:47 57950 8192000000 10926989952 11373895680 1973273904 19.411 100 18 36 1 1990880608 12092848 5513856
18:07:54 58494 8192000000 10902897264 11377401856 1943535536 19.175 98 22 44 1 1961039024 10282544 7220944
18:08:58 101989 8192000000 10885120976 11355070464 1910840784 18.913 97 7 14 0 1922722224 10249040 1632400
18:10:48 33267 8192000000 10885815520 11342479360 1921561984 18.999 98 18 36 0 1934312928 7490000 5260944
18:11:29 4892 8192000000 10884716464 11330420736 1938637136 19.136 99 58 114 2 1963558064 7279728 17641200
18:11:40 18779 8192000000 10883294400 11326111744 1917384720 18.966 98 35 70 1 1935707952 8854592 9468640
18:12:07 25170 8192000000 10908812080 11356151808 1959522256 19.302 100 48 96 2 1984016304 11509040 12985008
18:12:45 56696 8192000000 10913084960 11371368448 1975398928 19.428 100 33 64 0 1997029760 12909904 8720928
18:14:44 85885 8192000000 10902576752 11374632960 1953631344 19.255 99 5 10 0 1972388320 17298128 1458848
18:16:22 135270 8192000000 10901896320 11383468032 1937417536 19.126 98 19 37 1 1963386224 20668288 5300400
18:19:13 57555 8192000000 10911555504 11362914304 1955894352 19.273 99 25 49 1 1973043376 9648432 7500592
18:20:24 82337 8192000000 10928642000 11377369088 1978545472 19.453 100 39 78 0 1997450944 7852128 11053344
18:22:32 33515 8192000000 10904860192 11342688256 1901119808 18.835 96 54 107 1 1925027168 8915856 14991504
18:23:14 44692 8192000000 10903656640 11359985664 1963031312 19.330 100 44 86 2 1988566000 13602944 11931744
18:24:08 39493 8192000000 10896074800 11358478336 1953285872 19.253 99 43 85 1 1979532240 14052352 12194016
18:25:03 51211 8192000000 10873168144 11343822848 1943604752 19.176 99 17 34 1 1959882016 11565456 4711808
18:26:00 51329 8192000000 10877875104 11352350720 1943380320 19.174 99 14 28 1 1954449728 6892944 4176464
18:27:06 44500 8192000000 10872872336 11337203712 1904876896 18.866 97 15 28 1 1915327648 7141728 3309024
18:28:13 51474 8192000000 10882996848 11361767424 1969248880 19.379 100 9 18 1 1978587968 6804560 2534528
18:29:35 60737 8192000000 10890360192 11373101056 1967852256 19.368 100 10 20 1 1978637056 8111296 2673504
18:30:45 29286 8192000000 10896641216 11366637568 1941764432 19.161 98 14 28 3 1962396512 16096688 4535392
18:31:20 43506 8192000000 10922390592 11383369728 1942741520 19.169 98 23 46 2 1963794752 14410176 6643056
18:33:19 55951 8192000000 10906621344 11358167040 1909444000 18.902 97 14 28 0 1927963792 14686208 3833584
18:34:21 40257 8192000000 10881908912 11345555456 1924330080 19.022 98 27 54 0 1947133808 15219424 7584304
18:35:07 53646 8192000000 10907911600 11351019520 1875092576 18.625 96 18 36 0 1890842496 10484736 5265184
18:36:07 41755 8192000000 10869955456 11330269184 1867882192 18.567 96 19 38 0 1886383104 13142336 5358576
18:37:01 92746 8192000000 10891173296 11339075584 1905185936 18.868 98 22 44 1 1927997856 16598128 6213792
18:38:41 70882 8192000000 10854772416 11311648768 1823372160 18.205 94 4 8 0 1831978672 7620160 986352
18:39:58 82530 8192000000 10842208944 11319771136 1862338144 18.522 97 10 20 0 1879529152 14125968 3065040
18:42:28 56153 8192000000 10855365248 11311689728 1861466496 18.515 97 25 50 0 1888259696 20065328 6727872
18:43:37 121950 8192000000 10825985024 11299614720 1794035440 17.965 94 11 23 0 1816567456 19464304 3067712
18:47:08 62896 8192000000 10806309936 11276951552 1840905504 18.348 97 16 32 0 1858724464 12995344 4823616
18:48:25 21042 8192000000 10813487296 11289976832 1895432160 18.790 100 13 26 1 1911636512 12317072 3887280
18:49:01 67337 8192000000 10825890496 11299688448 1907722112 18.888 100 10 20 1 1919102704 8682544 2698048
18:50:16 80007 8192000000 10846134720 11313627136 1883224608 18.691 98 9 18 2 1894386704 8746528 2415568
18:52:03 66319 8192000000 10845313024 11319685120 1913820752 18.937 99 12 24 1 1932122736 14359472 3942512
18:53:15 47326 8192000000 10847427024 11322511360 1912126864 18.924 99 21 43 1 1928982672 10412544 6443264
18:54:55 82356 8192000000 10860041088 11351224320 1915440768 18.950 99 14 28 0 1935564560 16137040 3986752
18:56:24 43492 8192000000 10876814592 11344613376 1942694816 19.168 100 22 44 1 1956422352 6730096 6997440
18:57:17 44323 8192000000 10891964704 11344760832 1905958848 18.874 97 26 52 0 1920721328 7053376 7709104
18:58:11 39053 8192000000 10888700512 11360792576 1939602816 19.144 99 28 56 2 1954928576 7677376 7648384
18:59:01 32089 8192000000 10897708192 11359023104 1948465760 19.214 99 31 62 0 1968504656 11532528 8506368
18:59:39 64175 8192000000 10869231280 11334287360 1846526480 18.394 94 23 44 1 1864811264 11321824 6962960
19:00:52 79556 8192000000 10874168960 11339280384 1922407136 19.006 99 14 28 2 1937791152 11581696 3802320
19:02:27 23352 8192000000 10900012416 11352907776 1941322576 19.157 99 43 86 2 1963166336 9568416 12275344
19:03:03 70142 8192000000 10868246240 11340312576 1860352912 18.506 95 25 49 1 1878399120 10921696 7124512
19:04:45 56434 8192000000 10899735840 11352272896 1935462224 19.111 99 41 80 0 1959183376 11998016 11723136
19:05:50 18565 8192000000 10918875568 11363426304 1944490224 19.183 99 51 102 2 1970397824 11711632 14195968
19:06:21 54776 8192000000 10916764592 11373731840 1964562976 19.342 100 54 108 0 1997004224 17453472 14987776
19:07:25 19745 8192000000 10910291680 11367215104 1967728864 19.367 100 32 64 2 1986936048 10540400 8666784
19:07:51 31571 8192000000 10912376144 11373006848 1953777312 19.257 99 40 80 2 1977985872 13182432 11026128
19:08:31 17327 8192000000 10924259632 11372040192 1970944000 19.393 100 43 86 2 1992148576 9714352 11490224
19:08:57 27739 8192000000 10912443264 11377393664 1958701584 19.296 99 46 92 1 1984571344 13370112 12499648
19:09:32 81103 8192000000 10887847456 11369594880 1946803792 19.201 99 16 33 1 1969487376 17462432 5221152
19:11:13 40709 8192000000 10907933792 11372081152 1971700624 19.399 100 41 82 2 1994188304 10572000 11915680
19:12:00 82485 8192000000 10898963200 11383103488 1959759472 19.304 99 22 44 2 1981802960 15954208 6089280
19:13:39 67706 8192000000 10888508368 11378102272 1954957040 19.266 99 10 18 3 1970649088 12324832 3367216
19:14:53 61400 8192000000 10889827216 11365277696 1913270144 18.933 97 12 21 2 1931335312 14495408 3569760
19:16:30 74195 8192000000 10893990624 11365294080 1924458528 19.023 98 17 34 0 1949493888 19290752 5744608
19:17:55 95844 8192000000 10875166928 11364380672 1853620416 18.452 95 8 16 0 1867805888 11911472 2274000
19:19:43 73824 8192000000 10846876704 11316699136 1803459856 18.042 92 24 48 0 1817486560 7157072 6869632
19:21:58 32252 8192000000 10882442576 11325681664 1915005504 18.947 99 41 82 1 1937273200 10395680 11872016
19:22:40 44741 8192000000 10854414688 11318558720 1881847376 18.680 97 32 65 0 1899707760 8686592 9173792
19:23:33 92260 8192000000 10873884224 11343585280 1900240480 18.828 98 26 52 1 1924046592 16817008 6989104
19:25:12 72803 8192000000 10838580208 11314774016 1830735760 18.265 95 7 14 0 1845929776 13378480 1815536
19:26:35 43592 8192000000 10851498320 11315773440 1864630544 18.541 97 36 70 2 1886637008 12849808 9156656

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 14-03-2021 19:28:34 to 14-03-2021 19:29:04.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 152 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 14-03-2021 19:29:05 to 14-03-2021 19:29:06.

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          241241
MON$OLDEST_ACTIVE               242860
MON$OLDEST_SNAPSHOT             242860
MON$NEXT_TRANSACTION            242860
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                       1999232
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.33426 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33426 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33426 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33426 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 ---
:75: 
:76: mscs-test-161.budzdorov.ru    Sun Mar 14 19:27:34 2021
:77:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:78: 
--- end of diff output ---

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

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