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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-16 22:27:17
DTS_END                         2021-02-16 22:27:17.2860
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_ADDING_INVOICE(33:5) ==> SP_ADD_INVOICE_TO_STOCK(141:26) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/54648
TRN_ID                          233785
ATT_ID                          673
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: 9175.22 23633 1101026
customer order: creation 167.17 395 20060
customer order: refuse 14.15 354 1698
order to supplier: creation 44.63 1331 5356
order to supplier: removal 3.55 99270 426
invoice (draft): creation 44.76 3550 5371
invoice (draft): removal 53.10 805 6372
invoice accept: apply 40.24 19373 4829
invoice accept: cancel 47.60 815 5712
customer reserve: creation 3795.38 187 455446
customer reserve: removal 4678.88 57 561465
realization accept: apply 80.24 190 9629
realization accept: cancel 80.44 116 9653
payment from customer: creation 57.16 133 6859
payment from customer: removal 5.23 99 627
payment to supplier: creation 47.32 160 5678
payment to supplier: removal 3.37 90 404
service: total inventory turnovers 4.77 1082 572
service: total monetary turnovers 6.47 26 776
service: aggregate perf. data 0.74 26911 89
service: refresh index statistics 0.03 317725 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 16-02-2021 22:28:26 to 16-02-2021 22:28:28.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3425
TEST_TIME 2 4403
TEST_TIME 3 3987
TEST_TIME 4 4709
TEST_TIME 5 5712
TEST_TIME 6 5731
TEST_TIME 7 6040
TEST_TIME 8 5831
TEST_TIME 9 6082
TEST_TIME 10 6009
TEST_TIME 11 6159
TEST_TIME 12 6152
TEST_TIME 13 6381
TEST_TIME 14 6698
TEST_TIME 15 6667
TEST_TIME 16 6917
TEST_TIME 17 7411
TEST_TIME 18 7673
TEST_TIME 19 7912
TEST_TIME 20 7908
TEST_TIME 21 7909
TEST_TIME 22 8266
TEST_TIME 23 8253
TEST_TIME 24 8416
TEST_TIME 25 8744
TEST_TIME 26 9043
TEST_TIME 27 9155
TEST_TIME 28 9373
TEST_TIME 29 9755
TEST_TIME 30 10339
TEST_TIME 31 10342
TEST_TIME 32 10271
TEST_TIME 33 10292
TEST_TIME 34 10293
TEST_TIME 35 10279
TEST_TIME 36 10068
TEST_TIME 37 9921
TEST_TIME 38 9843
TEST_TIME 39 10046
TEST_TIME 40 9926
TEST_TIME 41 9876
TEST_TIME 42 9817
TEST_TIME 43 9806
TEST_TIME 44 9825
TEST_TIME 45 9761
TEST_TIME 46 9782
TEST_TIME 47 9797
TEST_TIME 48 9904
TEST_TIME 49 9852
TEST_TIME 50 9734
TEST_TIME 51 9579
TEST_TIME 52 9575
TEST_TIME 53 9622
TEST_TIME 54 9503
TEST_TIME 55 9448
TEST_TIME 56 9441
TEST_TIME 57 9393
TEST_TIME 58 9430
TEST_TIME 59 9505
TEST_TIME 60 9419
TEST_TIME 61 9328
TEST_TIME 62 9235
TEST_TIME 63 9277
TEST_TIME 64 9362
TEST_TIME 65 9303
TEST_TIME 66 9444
TEST_TIME 67 9389
TEST_TIME 68 9362
TEST_TIME 69 9374
TEST_TIME 70 9413
TEST_TIME 71 9368
TEST_TIME 72 9432
TEST_TIME 73 9476
TEST_TIME 74 9483
TEST_TIME 75 9509
TEST_TIME 76 9520
TEST_TIME 77 9515
TEST_TIME 78 9459
TEST_TIME 79 9381
TEST_TIME 80 9379
TEST_TIME 81 9362
TEST_TIME 82 9355
TEST_TIME 83 9302
TEST_TIME 84 9287
TEST_TIME 85 9239
TEST_TIME 86 9178
TEST_TIME 87 9102
TEST_TIME 88 9231
TEST_TIME 89 9195
TEST_TIME 90 9171
TEST_TIME 91 9234
TEST_TIME 92 9213
TEST_TIME 93 9251
TEST_TIME 94 9260
TEST_TIME 95 9367
TEST_TIME 96 9400
TEST_TIME 97 9380
TEST_TIME 98 9426
TEST_TIME 99 9450
TEST_TIME 100 9412
TEST_TIME 101 9426
TEST_TIME 102 9484
TEST_TIME 103 9398
TEST_TIME 104 9341
TEST_TIME 105 9336
TEST_TIME 106 9290
TEST_TIME 107 9345
TEST_TIME 108 9299
TEST_TIME 109 9287
TEST_TIME 110 9227
TEST_TIME 111 9211
TEST_TIME 112 9181
TEST_TIME 113 9163
TEST_TIME 114 9201
TEST_TIME 115 9186
TEST_TIME 116 9168
TEST_TIME 117 9168
TEST_TIME 118 9241
TEST_TIME 119 9249
TEST_TIME 120 9180

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 16-02-2021 22:28:29 to 16-02-2021 22:28:33.

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 1521758 1521758 0 0.00 0 19877 7 0 0
doc_list_biud 1521758 1521758 0 0.00 0 77890 27 0 0
sp_add_invoice_to_stock 4977 4829 148 2.97 32 196596 19374 0 148
sp_cancel_adding_invoice 5712 5712 0 0.00 4 80116 816 0 0
sp_cancel_client_order 1698 1698 0 0.00 5 12258 355 0 0
sp_cancel_customer_reserve 561465 561465 0 0.00 1 77893 58 0 0
sp_cancel_pay_from_customer 627 627 0 0.00 2 5647 99 0 0
sp_cancel_pay_to_supplier 404 404 0 0.00 3 3109 90 0 0
sp_cancel_supplier_invoice 6378 6372 6 0.09 1 34626 805 0 6
sp_cancel_supplier_order 426 426 0 0.00 5 1091370 99270 0 0
sp_cancel_write_off 9653 9653 0 0.00 1 9247 116 0 0
sp_client_order 20060 20060 0 0.00 4 12914 396 0 0
sp_customer_reserve 455446 455446 0 0.00 0 117828 188 0 0
sp_fill_shopping_cart 30783 30783 0 0.00 1 14018 41 0 0
sp_fill_shopping_cart_clo_res 455436 455436 0 0.00 0 14693 13 0 0
sp_get_clo_for_invoice 4819 4819 0 0.00 0 36316 299 0 0
sp_kill_cost_storno 16396 16396 0 0.00 0 15374 60 0 0
sp_kill_qstorno_ret_qs2qd 1139381 1139381 0 0.00 0 77884 31 0 0
sp_kill_qty_storno 599774 599774 0 0.00 0 77890 69 0 0
sp_lock_selected_doc 20006 20006 0 0.00 0 8321 5 0 0
sp_make_cost_storno 26985 26985 0 0.00 0 19874 62 0 0
sp_multiply_rows_for_pdistr 26985 26985 0 0.00 0 6271 30 0 0
sp_multiply_rows_for_qdistr 20060 20060 0 0.00 0 11827 159 0 0
sp_pay_from_customer 6859 6859 0 0.00 4 20996 134 0 0
sp_pay_to_supplier 5678 5678 0 0.00 5 14455 160 0 0
sp_payment_common 12537 12537 0 0.00 1 20525 35 0 0
sp_qd_handle_on_cancel_clo 1698 1698 0 0.00 0 12246 321 0 0
sp_qd_handle_on_invoice_upd_sts 10531 10531 0 0.00 0 30751 368 0 0
sp_qd_handle_on_reserve_upd_sts 9629 9629 0 0.00 0 22359 59 0 0
sp_reserve_write_off 9629 9629 0 0.00 6 22374 191 0 0
sp_supplier_invoice 5371 5371 0 0.00 6 92961 3550 0 0
sp_supplier_order 5356 5356 0 0.00 5 23294 1331 0 0
srv_aggregate_perf_data 89 89 0 0.00 2899 308187 26911 0 0
srv_fill_mon_cache_memory 166 166 0 0.00 1497 170824 32214 0 0
srv_find_qd_qs_mism 1053986 1053986 0 0.00 0 14515 6 0 0
srv_make_invnt_saldo 572 572 0 0.00 31 109093 1083 0 0
srv_make_money_saldo 776 776 0 0.00 1 891 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 182535 466174 317726 0 0
t$perf-abend:sp_add_invoice_to_stock 148 148 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4829 4829 0 0.00 0 19895 195 0 0
t$perf-norm:sp_cancel_adding_invoice 381 381 0 0.00 0 1963 81 0 0
t$perf-norm:sp_cancel_client_order 1698 1698 0 0.00 0 2648 13 0 0
t$perf-norm:sp_cancel_customer_reserve 649 649 0 0.00 0 505 6 0 0
t$perf-norm:sp_cancel_pay_from_customer 627 627 0 0.00 0 450 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 404 404 0 0.00 0 501 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 405 405 0 0.00 0 4307 36 0 0
t$perf-norm:sp_cancel_supplier_order 426 426 0 0.00 0 40254 1927 0 0
t$perf-norm:sp_cancel_write_off 968 968 0 0.00 0 4964 11 0 0
t$perf-norm:sp_client_order 20060 20060 0 0.00 0 14461 23 0 0
t$perf-norm:sp_customer_reserve 970 970 0 0.00 0 5197 13 0 0
t$perf-norm:sp_pay_from_customer 6859 6859 0 0.00 0 6594 11 0 0
t$perf-norm:sp_pay_to_supplier 5678 5678 0 0.00 0 8875 14 0 0
t$perf-norm:sp_reserve_write_off 9629 9629 0 0.00 0 13050 14 0 0
t$perf-norm:sp_supplier_invoice 5371 5371 0 0.00 0 7781 22 0 0
t$perf-norm:sp_supplier_order 5356 5356 0 0.00 0 5114 18 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 264 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 3102 32 0 0
t$perf-norm:srv_make_invnt_saldo 572 572 0 0.00 0 1638 20 0 0
t$perf-norm:srv_make_money_saldo 776 776 0 0.00 0 5080 27 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 2 0 0
v_add_invoice_to_stock 9934 9638 296 2.97 0 4762 22 0 296
v_all_customers 36638 36638 0 0.00 0 19 1 0 0
v_all_suppliers 29516 29516 0 0.00 0 85 1 0 0
v_all_wares 40120 40120 0 0.00 0 27 1 0 0
v_cancel_adding_invoice 762 762 0 0.00 0 2162 10 0 0
v_cancel_client_order 3396 3396 0 0.00 0 4362 5 0 0
v_cancel_customer_prepayment 1254 1254 0 0.00 0 3923 10 0 0
v_cancel_customer_reserve 1298 1298 0 0.00 0 3750 12 0 0
v_cancel_payment_to_supplier 808 808 0 0.00 0 3094 18 0 0
v_cancel_supplier_invoice 822 810 12 1.45 0 1631 21 0 12
v_cancel_supplier_order 852 852 0 0.00 0 3010 6 0 0
v_cancel_write_off 1936 1936 0 0.00 0 5273 22 0 0
v_max_id_clo_ord 5356 5356 0 0.00 0 1094 2 0 0
v_max_id_clo_res 970 970 0 0.00 0 1760 12 0 0
v_max_id_ord_sup 5365 5365 0 0.00 0 4781 4 0 0
v_max_non_paid_invoice 1641 1641 0 0.00 0 260 2 0 0
v_max_non_paid_realizn 3549 3549 0 0.00 0 4788 5 0 0
v_min_id_clo_ord 5356 5356 0 0.00 0 4589 7 0 0
v_min_id_clo_res 970 970 0 0.00 0 4537 11 0 0
v_min_id_ord_sup 5365 5365 0 0.00 0 5789 6 0 0
v_min_non_paid_invoice 5678 5678 0 0.00 0 6210 20 0 0
v_min_non_paid_realizn 6859 6859 0 0.00 0 10188 19 0 0
v_our_firm 10102 10102 0 0.00 0 292 1 0 0
v_reserve_write_off 19258 19258 0 0.00 0 8749 10 0 0
x_lock_depdocs_on_canc_invoice 11679 11679 0 0.00 0 21701 121 0 0
x_lock_depdocs_on_canc_sup_ord 426 426 0 0.00 0 10936 404 0 0
x_make_qstorno_1000_1200 5356 5356 0 0.00 1 23265 1242 0 0
x_make_qstorno_1200_2000 5371 5371 0 0.00 3 84773 3407 0 0
x_make_qstorno_2100_3300 455446 455446 0 0.00 0 117826 172 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 16-02-2021 22:28:34 to 16-02-2021 22:28:38.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:21 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:27 15859 8192000000 10218750160 10525679616 1027961744 11.149 80 58 113 1 1049627040 2806736 18858560
19:57:52 32740 8192000000 10360254384 10675159040 1385469312 14.465 100 85 171 0 1417901888 4367536 28065040
19:58:37 34078 8192000000 10396551152 10718408704 1439329232 14.944 100 89 177 1 1474489088 6467088 28692768
19:59:23 10412 8192000000 10406612480 10730602496 1464430576 15.165 100 90 180 0 1500696800 7335760 28930464
19:59:44 38472 8192000000 10456330336 10784661504 1490726112 15.395 100 90 180 0 1527180224 7780640 28673472
20:00:38 19672 8192000000 10474172880 10810830848 1524161728 15.686 100 85 170 1 1559722752 8901776 26659248
20:01:10 16836 8192000000 10484096880 10824388608 1542326400 15.844 100 82 164 0 1577187392 9498032 25362960
20:01:40 11453 8192000000 10506500704 10853138432 1560522624 16.001 100 79 159 0 1594738800 9854448 24361728
20:02:03 16143 8192000000 10534817600 10887409664 1589482448 16.249 100 74 148 1 1622126128 9728992 22914688
20:02:28 17106 8192000000 10560918736 10916278272 1614284592 16.461 100 77 154 1 1647968480 10526080 23157808
20:02:55 13643 8192000000 10562810560 10924449792 1626937280 16.569 100 75 149 0 1660201152 10747728 22516144
20:03:19 12246 8192000000 10593880976 10955382784 1645829200 16.729 100 76 152 0 1679094144 10590976 22673968
20:03:44 9398 8192000000 10619668544 10983374848 1677443008 16.996 100 77 154 0 1710989584 11264560 22282016
20:04:03 7672 8192000000 10628900624 10999029760 1693641488 17.132 100 81 161 3 1728983952 12345984 22996480
20:04:18 10286 8192000000 10654499984 11025956864 1713517344 17.298 100 81 161 1 1749745776 12811200 23417232
20:04:35 6230 8192000000 10654356784 11028480000 1718084576 17.336 100 79 156 0 1752272256 11628336 22559344
20:04:50 3194 8192000000 10663292912 11038916608 1725501088 17.398 100 75 150 2 1758401840 11178336 21722416
20:05:01 6153 8192000000 10681358736 11058601984 1743461312 17.547 100 79 159 0 1777843744 12224096 22158336
20:05:15 4843 8192000000 10687442992 11064885248 1755052528 17.643 100 81 161 0 1790708960 11932880 23723552
20:05:27 5447 8192000000 10711098768 11086704640 1764589488 17.722 100 78 156 0 1799745136 12521504 22634144
20:05:39 3995 8192000000 10725493248 11105742848 1781276768 17.860 100 82 165 0 1820962064 16839952 22845344
20:05:50 3917 8192000000 10738704864 11118219264 1796621984 17.986 100 88 176 0 1834928240 13383008 24923248
20:06:01 4026 8192000000 10729719072 11111002112 1798723488 18.003 100 84 168 1 1835693952 13726384 23244080
20:06:12 2843 8192000000 10743680800 11121917952 1800991712 18.022 100 82 162 1 1837878832 14027792 22859328
20:06:21 3263 8192000000 10754227920 11134087168 1811874448 18.111 100 90 178 3 1850356752 13953648 24528656
20:06:31 2525 8192000000 10752681760 11133546496 1813603680 18.125 100 86 173 1 1852259408 14093664 24562064
20:06:39 3412 8192000000 10756743200 11141701632 1817217120 18.155 100 84 168 1 1855162032 14493264 23451648
20:06:51 3024 8192000000 10770469968 11154112512 1818360928 18.164 100 86 168 2 1857111488 15334416 23416144
20:07:01 2369 8192000000 10778414480 11161698304 1837210592 18.318 100 93 186 1 1878483536 14796176 26476768
20:07:10 2064 8192000000 10780722400 11167035392 1836904240 18.316 100 82 164 2 1873694032 13820992 22968800
20:07:19 1354 8192000000 10789809776 11176165376 1845684048 18.387 100 91 183 1 1884759600 13330560 25744992
20:07:26 2490 8192000000 10791164816 11176468480 1849010128 18.414 100 90 182 2 1887042624 12905728 25126768
20:07:35 1946 8192000000 10796773696 11185102848 1853812160 18.453 100 90 178 2 1891944544 13055680 25076704
20:07:43 1706 8192000000 10801604864 11191115776 1858617776 18.492 100 91 185 1 1897733664 12943280 26172608
20:07:51 1934 8192000000 10808194480 11196870656 1863646192 18.533 100 91 183 0 1903059456 13792112 25621152
20:07:59 1817 8192000000 10808135088 11196575744 1868640576 18.573 100 94 188 0 1908233056 13498464 26094016
20:08:07 2295 8192000000 10811189088 11199856640 1866399600 18.555 100 92 184 0 1906808464 13443392 26965472
20:08:16 1596 8192000000 10817116336 11204509696 1867521840 18.564 100 97 192 0 1908331888 13401968 27408080
20:08:24 1933 8192000000 10818683680 11204923392 1869871680 18.583 100 96 194 0 1911836176 13830224 28134272
20:08:32 1270 8192000000 10812918880 11202056192 1873471936 18.612 100 82 162 1 1909920384 13244096 23204352
20:08:39 2018 8192000000 10820003296 11208957952 1876511920 18.637 100 94 190 2 1915731920 11719872 27500128
20:08:48 40474 8192000000 10807488016 11212861440 1866299744 18.554 100 42 84 1 1889440816 10095152 13045920
20:09:35 21866 8192000000 10804274160 11206529024 1872362896 18.603 100 58 113 2 1896254928 7241632 16650400
20:10:03 20424 8192000000 10780754384 11210846208 1875058960 18.625 100 48 96 1 1897162448 8664304 13439184
20:10:30 5380 8192000000 10790011376 11209756672 1874709744 18.622 100 38 76 1 1892942032 8199040 10033248
20:10:42 4547 8192000000 10801446320 11221467136 1878127936 18.650 100 48 94 2 1899422528 8369360 12925232
20:10:54 4511 8192000000 10787866448 11218567168 1879241440 18.659 100 26 52 1 1897694608 11605680 6847488
20:11:06 3901 8192000000 10793140256 11218595840 1881530016 18.677 100 40 79 2 1899896048 6885488 11480544
20:11:17 8305 8192000000 10794755024 11218034688 1877661504 18.646 100 18 36 2 1889419872 6593056 5165312
20:11:32 4053 8192000000 10791840576 11220705280 1878212144 18.651 100 21 40 2 1890505904 6341184 5952576
20:11:45 10264 8192000000 10795885072 11218149376 1877843088 18.648 100 18 36 0 1888725312 5863392 5018832
20:12:02 8523 8192000000 10784312864 11217784832 1880443488 18.669 100 28 55 1 1895988832 6987968 8557376
20:12:19 9978 8192000000 10784240768 11220004864 1880377456 18.668 100 21 42 1 1893376688 6699152 6300080
20:12:40 10725 8192000000 10795896720 11224023040 1881666192 18.679 100 22 45 4 1893798544 5917616 6214736
20:12:58 16087 8192000000 10788465920 11224281088 1880916640 18.673 100 16 30 1 1895802528 9865872 5020016
20:13:23 4888 8192000000 10796858608 11224715264 1884605120 18.702 100 29 57 3 1898642656 6205600 7831936
20:13:34 7944 8192000000 10798286992 11228561408 1888873392 18.737 100 22 43 3 1900920272 5270928 6775952
20:13:52 22485 8192000000 10791956688 11234394112 1890408368 18.749 100 29 58 0 1904064640 5125056 8531216
20:14:48 28113 8192000000 10793639264 11234762752 1890334304 18.748 100 22 45 0 1902224640 5165088 6725248
20:15:22 10373 8192000000 10814704464 11243143168 1896211472 18.796 100 23 46 1 1908785120 5913264 6660384
20:15:46 8037 8192000000 10809209200 11241734144 1894857664 18.785 100 30 60 0 1910295088 7206576 8230848
20:16:00 7420 8192000000 10795289008 11233210368 1888354592 18.733 100 34 68 0 1905341024 7129664 9856768
20:16:16 4839 8192000000 10809987184 11237093376 1886624752 18.719 100 29 59 2 1904689008 9782736 8281520
20:16:28 7538 8192000000 10798155344 11230941184 1872270304 18.603 99 17 34 0 1882541488 5697360 4573824
20:16:44 7831 8192000000 10787397520 11220275200 1855951424 18.470 98 20 40 4 1868233696 6678912 5603360
20:16:59 11490 8192000000 10795515456 11232235520 1884509584 18.702 100 18 36 0 1895402000 5272896 5619520
20:17:17 8223 8192000000 10810086016 11239211008 1887027648 18.722 100 22 44 4 1904301056 10609488 6663920
20:17:34 5826 8192000000 10784642272 11218808832 1861840640 18.518 99 13 26 0 1871514512 5268624 4405248
20:17:49 10873 8192000000 10775323456 11200950272 1834047808 18.292 98 22 44 3 1845902832 5834768 6020256
20:18:07 13443 8192000000 10745881168 11172732928 1794041744 17.965 97 14 28 1 1803190176 5259744 3888688
20:18:36 10795 8192000000 10737428928 11156029440 1791108928 17.941 98 33 66 0 1806247728 5700208 9438592
20:18:57 64433 8192000000 10720939920 11133894656 1743605168 17.549 96 31 62 1 1761747968 9470496 8672304
20:20:15 15156 8192000000 10711562512 11126251520 1696177120 17.153 93 19 38 0 1706333584 5358560 4797904
20:20:36 9228 8192000000 10717685104 11127230464 1751801632 17.617 97 42 83 3 1770555360 7556912 11196816
20:20:52 9054 8192000000 10697103664 11105447936 1727026800 17.411 97 31 63 0 1742029760 6352336 8650624
20:21:07 8469 8192000000 10682152272 11104854016 1730237328 17.437 97 28 56 3 1744188032 6613744 7336960
20:21:22 9091 8192000000 10687247792 11099389952 1692700976 17.124 95 17 33 2 1703107056 5229584 5176496
20:21:37 7491 8192000000 10680183488 11090747392 1712584448 17.290 96 14 28 1 1726498752 9193184 4721120
20:21:53 9102 8192000000 10705507792 11127181312 1792911344 17.956 100 16 32 0 1802925440 5581104 4432992
20:22:09 9171 8192000000 10725241632 11143593984 1802869824 18.037 100 20 40 1 1813995264 5614128 5511312
20:22:24 9776 8192000000 10732701504 11140075520 1764283200 17.720 97 34 69 0 1779813376 5043520 10486656
20:22:43 7440 8192000000 10727953664 11146334208 1796027216 17.981 99 31 60 0 1810592960 5374320 9191424
20:22:58 8662 8192000000 10734217056 11154100224 1815048256 18.137 100 29 58 1 1833215888 9625248 8542384
20:23:13 10283 8192000000 10737896992 11158552576 1821572240 18.191 100 38 76 1 1839773296 6886192 11314864
20:23:30 8785 8192000000 10728316448 11153072128 1803328096 18.041 99 15 29 0 1813299360 5703744 4267520
20:23:45 64954 8192000000 10752078560 11166871552 1831639056 18.273 100 28 51 2 1844348880 5125504 7584320
20:24:59 21080 8192000000 10750060992 11178438656 1834120848 18.293 100 19 38 1 1845767472 5547088 6099536
20:25:28 11015 8192000000 10766668496 11188408320 1843957968 18.373 100 27 53 2 1857346976 5978928 7410080
20:25:45 9110 8192000000 10760307280 11187900416 1848092848 18.407 100 27 54 0 1861745824 5836752 7816224
20:26:03 4719 8192000000 10770553792 11194535936 1851386032 18.433 100 31 62 0 1867246000 7517616 8342352
20:26:15 7302 8192000000 10769837792 11195047936 1852988544 18.446 100 23 46 0 1865833648 5879344 6965760
20:26:30 6674 8192000000 10769050960 11194679296 1853716576 18.452 100 23 44 1 1865840672 4978208 7145888
20:26:44 6409 8192000000 10777655184 11202232320 1857941456 18.487 100 30 59 1 1873161328 5896096 9323776
20:26:58 9513 8192000000 10789420352 11211255808 1865949984 18.551 100 26 50 2 1878684208 5462752 7271472
20:27:13 26153 8192000000 10813560656 11232120832 1882582736 18.686 100 34 67 2 1900701616 8827792 9291088
20:27:55 31199 8192000000 10830561632 11249922048 1898054240 18.811 100 40 77 4 1916542272 7479104 11008928
20:28:38 24219 8192000000 10848868320 11263524864 1909041056 18.899 100 51 102 2 1932810864 9152752 14617056
20:29:14 15015 8192000000 10846693760 11268915200 1916854896 18.962 100 46 92 2 1939074912 9273104 12946912
20:29:42 13832 8192000000 10857754336 11274637312 1922264880 19.005 100 46 90 0 1943565936 8954304 12346752
20:30:07 64020 8192000000 10858554416 11289513984 1929008768 19.059 100 47 94 2 1953101920 9536768 14556384
20:31:21 49094 8192000000 10870460320 11309285376 1930115536 19.068 100 28 56 1 1952596240 13082256 9398448
20:32:17 23280 8192000000 10863214768 11305271296 1932750128 19.089 100 25 49 1 1960839792 20885808 7203856
20:32:53 12958 8192000000 10876266928 11306168320 1946431072 19.198 100 48 96 1 1968686160 8499552 13755536
20:33:12 8753 8192000000 10879079760 11306835968 1944469952 19.182 100 53 106 1 1970771904 11186064 15115888
20:33:28 9066 8192000000 10887925264 11313811456 1948752096 19.217 100 56 107 1 1976224592 11751648 15720848
20:33:46 7095 8192000000 10894386736 11322335232 1953481200 19.254 100 74 146 0 1992050240 17088544 21480496
20:34:01 3398 8192000000 10896205616 11322130432 1954857632 19.265 100 63 123 0 1985473472 12700560 17915280
20:34:12 12995 8192000000 10910894896 11331031040 1959864224 19.305 100 63 126 1 1990554256 11775440 18914592
20:34:35 23466 8192000000 10902756128 11335385088 1963210208 19.332 100 56 112 1 1992178256 12287696 16680352
20:35:11 15695 8192000000 10903337680 11335901184 1966143136 19.355 100 52 104 0 1995077632 14234800 14699696
20:35:39 6919 8192000000 10909553232 11342192640 1970586256 19.390 100 48 94 1 1999081728 15188224 13307248
20:35:59 3410 8192000000 10926403536 11348611072 1977472368 19.445 100 64 128 2 2013041616 16383184 19186064
20:36:11 8278 8192000000 10907098656 11342458880 1960002944 19.306 99 64 124 4 1994703056 16329216 18370896
20:36:32 8690 8192000000 10917220080 11349327872 1979236624 19.459 100 59 118 0 2011817568 15019648 17561296
20:36:59 3098 8192000000 10931148096 11364610048 1985349488 19.507 100 60 120 0 2023945680 21272784 17323408
20:37:19 9262 8192000000 10932529664 11364634624 1990026192 19.544 100 62 123 0 2026664368 18615456 18022720
20:37:46 4021 8192000000 10940803808 11365629952 1991256224 19.554 100 58 116 0 2027034832 18193632 17584976
20:37:57 8964 8192000000 10943961728 11376697344 1998392160 19.610 100 63 124 1 2034687728 18655792 17639776
20:38:14 3992 8192000000 10945990528 11380269056 1997971920 19.607 100 52 103 1 2033630800 20736608 14922272
20:38:28 10174 8192000000 10937271392 11374514176 1979729008 19.463 99 51 102 2 2015927808 20897600 15301200
20:38:45 14779 8192000000 10947027504 11376570368 1992842256 19.566 100 55 110 1 2029633104 20740432 16050416
20:39:10 12893 8192000000 10954113184 11392106496 1998516064 19.611 100 45 90 1 2039271968 27298832 13457072
20:39:33 6660 8192000000 10963795440 11392421888 2009822960 19.700 100 75 150 1 2055940912 23365936 22752016
20:39:53 2200 8192000000 10957585184 11382820864 1995489760 19.587 100 77 150 1 2042209248 25064544 21654944
20:40:03 5977 8192000000 10974674736 11387580416 2002510048 19.643 100 84 164 1 2052584720 26023552 24051120
20:40:16 1668 8192000000 10977984496 11392794624 2006371648 19.673 100 92 181 2 2061045104 27881680 26791776
20:40:25 3012 8192000000 10974588032 11397791744 2011068480 19.710 100 78 154 1 2061960560 27763648 23128432
20:40:36 2908 8192000000 10976617984 11400032256 2012187184 19.719 100 80 157 2 2063689040 28605872 22895984
20:40:45 3445 8192000000 10982317008 11401863168 1999411792 19.618 99 86 170 1 2054937680 30248592 25277296
20:40:56 3209 8192000000 10982587648 11403964416 2013510912 19.729 100 81 162 4 2070745728 33421184 23813632
20:41:07 4017 8192000000 10992051872 11407917056 2019651712 19.777 100 86 171 0 2077817648 32955040 25210896
20:41:18 2649 8192000000 10992779728 11412590592 2026020160 19.827 100 87 174 1 2079382480 27736192 25626128
20:41:28 4812 8192000000 10966995904 11395080192 2006213968 19.672 100 68 136 0 2058799568 31838752 20746848
20:41:39 3238 8192000000 10966327424 11390881792 2000298640 19.625 100 81 162 1 2053078160 27865152 24914368
20:41:50 3308 8192000000 10966955056 11388850176 1997258048 19.601 100 66 132 1 2047222640 28854864 21109728
20:42:01 5094 8192000000 10941138096 11364528128 1961595952 19.319 99 80 160 0 2017498816 30272656 25630208
20:42:13 2400 8192000000 10947357120 11366141952 1976175856 19.434 100 75 150 1 2030859968 31055824 23628288
20:42:23 3885 8192000000 10953384752 11372814336 1983585984 19.493 100 83 165 1 2041843472 32067632 26189856
20:42:35 3633 8192000000 10960978656 11383533568 1978686144 19.454 99 79 158 1 2036545584 33352416 24507024
20:42:46 2437 8192000000 10966293664 11383029760 1990804992 19.550 100 85 170 2 2053540352 36341328 26394032
20:42:56 5783 8192000000 10972855232 11389112320 1989295248 19.538 100 89 177 1 2055234496 38362016 27577232
20:43:11 6305 8192000000 10955153312 11384651776 1986532656 19.516 100 69 138 0 2045260480 37141936 21585888
20:43:26 4003 8192000000 10964592256 11387146240 1989220960 19.538 100 66 132 0 2046345552 36805792 20318800
20:43:39 7321 8192000000 10977694944 11405225984 1999346768 19.618 100 71 142 1 2060243040 38596656 22299616
20:43:53 1636 8192000000 10987116960 11405791232 2008518448 19.690 100 86 172 0 2074861904 39326880 27016576
20:44:02 1699 8192000000 10987071040 11413573632 2009737696 19.699 100 85 170 2 2075396048 39394704 26263648
20:44:11 1761 8192000000 10982447184 11395125248 1987190016 19.522 99 91 181 1 2050707696 36827600 26690080
20:44:20 3563 8192000000 10975826608 11392860160 1997017296 19.599 100 78 157 2 2059144416 37561056 24566064
20:44:31 3883 8192000000 10989141104 11406090240 2001702608 19.636 100 89 178 0 2069188432 39965312 27520512
20:44:47 1525 8192000000 10979321040 11397296128 1999974688 19.623 100 80 159 0 2061791920 37894592 23922640
20:44:56 2928 8192000000 10957971856 11373629440 1964212880 19.340 99 78 155 0 2030732624 42829568 23690176
20:45:06 3359 8192000000 10966017024 11378413568 1981386464 19.476 100 86 170 0 2046235264 38210448 26638352
20:45:17 4171 8192000000 10960100560 11376529408 1979298128 19.459 100 82 163 1 2042012352 37726096 24988128
20:45:29 1518 8192000000 10955970608 11366588416 1971737120 19.399 100 85 167 1 2033736032 36067888 25931024
20:45:37 2161 8192000000 10948661136 11365773312 1970156640 19.387 100 80 160 1 2034490416 39268480 25065296
20:45:46 4295 8192000000 10944118912 11365273600 1965624160 19.351 100 80 159 2 2029591488 39190704 24776624
20:46:03 7651 8192000000 10940946288 11368288256 1965176608 19.347 100 54 108 2 2021926080 39343664 17405808
20:46:28 6637 8192000000 10937941904 11369484288 1952810848 19.249 99 47 94 2 2005947856 37760304 15376704
20:46:43 3840 8192000000 10943339440 11376033792 1974374304 19.420 100 50 99 1 2028182096 38437856 15369936
20:46:54 13850 8192000000 10938536144 11372421120 1957526256 19.286 99 48 96 1 2011340672 39275920 14538496
20:47:33 3235 8192000000 10945908000 11371728896 1930499008 19.071 98 52 102 1 1992609648 46688752 15421888
20:47:45 8732 8192000000 10942632816 11371548672 1965450624 19.349 100 47 92 1 2022404960 42294272 14660064
20:48:01 11193 8192000000 10943792368 11377991680 1966800560 19.360 100 64 128 6 2030964464 44401952 19761952
20:48:28 7825 8192000000 10950990400 11380035584 1968432544 19.373 100 53 105 1 2030649072 46053200 16163328
20:48:44 4914 8192000000 10964432784 11395813376 1980830528 19.471 100 65 130 0 2050065392 48654976 20579888
20:49:04 9140 8192000000 10967812688 11401433088 1983935360 19.496 100 50 100 0 2047595872 47843488 15817024
20:49:21 15862 8192000000 10948031968 11392516096 1956459360 19.278 99 35 70 1 2018681808 50285568 11936880
20:49:44 9396 8192000000 10932543184 11375910912 1917677744 18.968 97 41 81 0 1981775040 50900592 13196704
20:50:15 5280 8192000000 10933838784 11362287616 1948440912 19.214 99 59 116 3 2013848864 47725152 17682800
20:50:28 1494 8192000000 10944753984 11369938944 1954482560 19.262 100 64 128 2 2024935904 50132224 20321120
20:50:42 11562 8192000000 10925514832 11368034304 1949444736 19.222 100 38 76 0 2014523216 52324736 12753744
20:51:02 9876 8192000000 10928363056 11367821312 1933536240 19.095 99 39 78 0 2002528608 55981776 13010592
20:51:18 16584 8192000000 10930502576 11375362048 1945226928 19.188 100 36 72 0 2012587472 54973888 12386656
20:51:51 8992 8192000000 10950019584 11389165568 1966406352 19.357 100 37 74 0 2031810288 52391168 13012768
20:52:07 14249 8192000000 10921531216 11372220416 1941515072 19.159 99 30 61 1 2002137200 50194752 10427376
20:52:29 9958 8192000000 10935211376 11378483200 1940614688 19.152 99 29 58 1 1999529040 48777168 10137184
20:52:50 27552 8192000000 10927255216 11372482560 1954027216 19.259 100 28 56 1 2010962976 47482304 9453456
20:53:28 19131 8192000000 10922249456 11365068800 1930143760 19.068 99 28 55 0 1986810512 46736528 9930224
20:53:58 18283 8192000000 10911808608 11357831168 1948300624 19.213 100 28 56 0 1997801584 40390128 9110832
20:54:22 23814 8192000000 10905527392 11360235520 1920852704 18.994 99 25 50 1 1975612176 45345904 9413568
20:54:55 15708 8192000000 10919244736 11366952960 1942052704 19.163 100 25 50 1 1992622864 42008192 8561968
20:55:20 28315 8192000000 10919982912 11379585024 1953387536 19.253 100 20 40 0 2004208464 43596128 7224800
20:56:05 28816 8192000000 10892582352 11352727552 1885664656 18.711 97 14 28 1 1928922272 38152224 5105392
20:57:01 23838 8192000000 10907296128 11343134720 1898391088 18.813 98 20 40 2 1945840944 40046160 7403696
20:57:32 47703 8192000000 10868666544 11322822656 1899335792 18.821 98 14 27 0 1924957616 21751952 3869872
20:58:27 21328 8192000000 10883454272 11318784000 1937932672 19.130 100 38 76 0 1962488688 13282864 11273152
20:58:56 45988 8192000000 10881797712 11337211904 1948359216 19.213 100 37 74 1 1973834592 14217120 11258256
20:59:52 61233 8192000000 10876727488 11346837504 1932655792 19.088 99 19 38 0 1960145824 21938752 5551280
21:01:00 41928 8192000000 10863818016 11339931648 1900173328 18.828 98 2 4 0 1918298928 18000976 124624
21:01:48 23161 8192000000 10869118528 11342753792 1938906176 19.138 100 4 8 1 1954343184 14609472 827536
21:02:18 92272 8192000000 10907611920 11342630912 1900190640 18.828 97 27 54 0 1922664096 14640496 7832960
21:04:01 53414 8192000000 10922425936 11357310976 1960573552 19.311 100 37 72 2 1982694864 12214896 9906416
21:05:08 68195 8192000000 10888364928 11355639808 1945031808 19.187 99 28 57 0 1966397984 14264896 7101280
21:06:24 89958 8192000000 10889480656 11347345408 1917072816 18.963 98 11 22 0 1928703760 8870496 2760448
21:08:15 83569 8192000000 10897584352 11351134208 1945794000 19.193 99 30 59 0 1968208544 14125936 8288608
21:09:48 30889 8192000000 10898987520 11355668480 1947518128 19.207 99 20 40 1 1962143696 8933136 5692432
21:10:25 79633 8192000000 10895906160 11366162432 1974021264 19.417 100 15 30 0 1990921648 13380208 3520176
21:11:51 97049 8192000000 10908444096 11376238592 1955779360 19.272 99 12 23 1 1970953168 11490304 3683504
21:13:35 139725 8192000000 10905934544 11381956608 1947055040 19.203 98 10 20 1 1969905216 19768720 3081456
21:16:02 170824 8192000000 10904071376 11365056512 1923603888 19.016 97 13 26 1 1936844848 9748208 3492752
21:19:05 55292 8192000000 10913480672 11366952960 1938786992 19.137 98 29 58 0 1957303264 9827968 8688304
21:20:07 140501 8192000000 10915899616 11371245568 1908731120 18.896 97 28 54 0 1927410976 10803072 7876784
21:22:34 30687 8192000000 10935578944 11384303616 1973004688 19.409 99 42 85 1 1995840336 10153824 12681824
21:23:16 79435 8192000000 10904590592 11364892672 1934672848 19.104 97 28 56 2 1956573344 13533456 8367040
21:24:46 32975 8192000000 10918970976 11368460288 1944211424 19.180 98 35 69 1 1968410672 14142288 10056960
21:25:26 55016 8192000000 10876395648 11357573120 1899118656 18.819 97 15 30 0 1917669840 14258736 4292448
21:26:51 28499 8192000000 10880242624 11361038336 1952565552 19.247 100 10 20 0 1967635248 12470448 2599248
21:27:33 36145 8192000000 10871045024 11344936960 1925512800 19.031 98 11 22 0 1942983216 14654848 2815568
21:28:17 9130 8192000000 10872220192 11347492864 1949442256 19.222 100 7 14 0 1961305520 10108576 1754688
21:28:33 63737 8192000000 10875862864 11344777216 1927269984 19.045 98 14 28 0 1941850304 10728752 3851568
21:29:43 46502 8192000000 10894362176 11363618816 1959829888 19.305 100 14 25 0 1975137904 11766992 3541024
21:30:36 43394 8192000000 10878476560 11358437376 1942766544 19.169 99 11 22 2 1955931904 10623104 2542256
21:31:25 34936 8192000000 10887653344 11364327424 1947223440 19.204 99 20 40 1 1966001680 13573248 5204992
21:32:21 35878 8192000000 10867845680 11331026944 1880928048 18.673 95 32 64 0 1903460528 13643248 8889232
21:33:03 85191 8192000000 10882344624 11367297024 1918319632 18.973 98 21 42 0 1938074624 13200800 6554192
21:34:34 24844 8192000000 10891727856 11355332608 1946151328 19.196 99 27 51 1 1960893280 7334656 7407296
21:35:06 10052 8192000000 10878649104 11330580480 1929761520 19.065 98 46 92 2 1950530080 8000784 12767776
21:35:26 44365 8192000000 10871149776 11326590976 1879676912 18.662 96 42 85 3 1905562944 14316928 11569104
21:36:33 61569 8192000000 10886261184 11350839296 1890483504 18.750 97 27 54 3 1908717312 10917456 7316352
21:37:44 98219 8192000000 10888070832 11345473536 1887522960 18.726 97 22 44 0 1908401552 14523760 6354832
21:39:29 62567 8192000000 10869947456 11331166208 1883820592 18.696 97 13 26 0 1918359552 30354416 4184544
21:40:37 29936 8192000000 10861829168 11323723776 1897274112 18.804 98 16 32 0 1917321488 15519584 4527792
21:41:13 42127 8192000000 10874932784 11332464640 1914553328 18.943 99 31 63 1 1939467056 16554672 8359056
21:42:03 66658 8192000000 10866278928 11301588992 1869201616 18.578 96 26 52 0 1886533040 10445296 6886128
21:43:32 33779 8192000000 10885703936 11340111872 1906574640 18.879 98 42 84 0 1933379984 15316608 11488736
21:44:26 46223 8192000000 10858140608 11319304192 1907614576 18.887 98 35 70 2 1930632320 13114912 9902832
21:45:18 116397 8192000000 10821957888 11288195072 1826297072 18.229 94 30 60 1 1842810464 7590480 8922912
21:47:21 26601 8192000000 10875933408 11318771712 1913060560 18.931 99 47 93 2 1931643200 5446592 13136048
21:47:53 32733 8192000000 10884430448 11341295616 1944543232 19.183 100 51 102 0 1970861744 12157968 14160544
21:48:35 54109 8192000000 10879902784 11332071424 1910200368 18.908 98 30 60 1 1931186112 12677568 8308176
21:49:35 35988 8192000000 10835589744 11303936000 1887312544 18.724 98 25 50 2 1908803696 13855392 7635760
21:50:21 1873 8192000000 10875117232 11311947776 1919079808 18.979 100 67 129 7 1947131104 9022672 19028624
21:50:29 41677 8192000000 10839317744 11304083456 1886255840 18.716 98 28 56 2 1905711072 11574512 7880720
21:51:17 49417 8192000000 10838970832 11311005696 1875356912 18.628 98 16 31 1 1891054608 11230208 4467488
21:52:13 53190 8192000000 10845474928 11311292416 1900429056 18.830 99 11 22 1 1915953264 12521120 3003088
21:53:12 76933 8192000000 10824944400 11289001984 1860733776 18.509 97 22 43 2 1882343152 14981008 6628368
21:55:23 98581 8192000000 10856392176 11336056832 1897892176 18.809 99 8 16 0 1913115920 12922160 2301584
21:57:08 44920 8192000000 10872252912 11335462912 1928420368 19.054 99 27 54 2 1946173696 9492160 8261168
21:58:00 63451 8192000000 10883057168 11369967616 1950882544 19.234 100 16 32 2 1969617568 14223056 4511968
21:59:31 57880 8192000000 10911712080 11368779776 1956459280 19.278 100 21 42 0 1978822240 16414496 5948464
22:00:42 49031 8192000000 10902091872 11371761664 1968839840 19.376 100 20 40 2 1995248560 20521296 5887424
22:01:46 41129 8192000000 10900935344 11372138496 1949513232 19.223 99 14 28 0 1964100704 10735424 3852048
22:02:35 108429 8192000000 10897790224 11370229760 1925292000 19.029 98 6 12 0 1937932784 11049184 1591600
22:04:29 57711 8192000000 10941437328 11391324160 1971538080 19.398 99 37 72 3 1997653952 15761008 10354864
22:05:33 53283 8192000000 10915337712 11409494016 1986208160 19.514 100 24 48 0 2011093472 18169456 6715856
22:06:43 71046 8192000000 10920673776 11385004032 1950720640 19.232 98 28 56 3 1968683728 10421120 7541968
22:08:05 19332 8192000000 10927307456 11378741248 1968142256 19.371 99 46 92 2 1991362208 10496496 12723456
22:08:34 91719 8192000000 10898123168 11393507328 1957239408 19.284 99 28 56 1 1982391504 17185216 7966880
22:12:13 55933 8192000000 10895732080 11380699136 1973584704 19.414 100 21 42 0 1997208352 17437744 6185904
22:13:15 39304 8192000000 10913378624 11385032704 1972800048 19.408 100 13 26 1 1995094928 18400528 3894352
22:14:06 70602 8192000000 10884544816 11370045440 1937179568 19.124 98 11 22 0 1948602608 8531376 2891664
22:15:44 81768 8192000000 10895749760 11382124544 1958037088 19.290 99 21 42 1 1975645296 11732224 5875984
22:17:12 83775 8192000000 10897932176 11379552256 1956876768 19.281 99 10 20 2 1973976256 13570304 3529184
22:18:47 50213 8192000000 10882373472 11358244864 1921071472 18.995 97 18 34 1 1937611120 11067248 5472400
22:20:08 54903 8192000000 10885606912 11369041920 1939164768 19.140 98 18 36 2 1956506656 11478080 5863808
22:21:09 40115 8192000000 10892873824 11382874112 1953538176 19.255 99 9 18 1 1972493792 16501968 2453648
22:22:07 58693 8192000000 10888176896 11345321984 1816832400 18.152 92 23 43 1 1831413600 8515648 6065552
22:23:17 55858 8192000000 10880816736 11350704128 1933403328 19.094 99 28 56 1 1952559296 11459440 7696528
22:24:21 81549 8192000000 10872767904 11356758016 1901504800 18.838 97 18 36 0 1919503168 12617776 5380592
22:26:10 63632 8192000000 10900401488 11363459072 1946882304 19.202 99 12 24 0 1962433952 12408320 3143328

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 16-02-2021 22:28:40 to 16-02-2021 22:29:11.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 148 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

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

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          232979
MON$OLDEST_ACTIVE               233953
MON$OLDEST_SNAPSHOT             233953
MON$NEXT_TRANSACTION            233953
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                       2049312
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.33416 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33416 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33416 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33416 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 ---
:32: 
:33: mscs-test-161.budzdorov.ru    Tue Feb 16 22:27:25 2021
:34:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:35: 
--- end of diff output ---

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

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