Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 10.02.2021 16: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 17298068 kB
MemAvailable 31180196 kB
Buffers 0 kB
Cached 14391624 kB
SwapCached 4772 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-10 16:27:19
DTS_END                         2021-02-10 16:27:19.6110
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/42046
TRN_ID                          233843
ATT_ID                          606
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: 9213.42 25002 1105610
customer order: creation 162.65 362 19518
customer order: refuse 14.12 344 1694
order to supplier: creation 44.01 1298 5281
order to supplier: removal 3.65 96519 438
invoice (draft): creation 43.94 3382 5273
invoice (draft): removal 53.01 801 6361
invoice accept: apply 39.78 16103 4774
invoice accept: cancel 48.35 794 5802
customer reserve: creation 3790.79 154 454895
customer reserve: removal 4727.08 58 567250
realization accept: apply 78.18 192 9382
realization accept: cancel 84.89 117 10187
payment from customer: creation 56.02 128 6722
payment from customer: removal 5.38 88 645
payment to supplier: creation 47.08 143 5650
payment to supplier: removal 3.32 82 398
service: total inventory turnovers 4.68 1062 561
service: total monetary turnovers 5.69 21 683
service: aggregate perf. data 0.77 17287 92
service: refresh index statistics 0.03 361102 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-02-2021 16:28:13 to 10-02-2021 16:28:15.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3256
TEST_TIME 2 4264
TEST_TIME 3 4273
TEST_TIME 4 4138
TEST_TIME 5 4251
TEST_TIME 6 4306
TEST_TIME 7 4577
TEST_TIME 8 5100
TEST_TIME 9 5173
TEST_TIME 10 5569
TEST_TIME 11 5741
TEST_TIME 12 6304
TEST_TIME 13 6058
TEST_TIME 14 6317
TEST_TIME 15 6603
TEST_TIME 16 6871
TEST_TIME 17 7236
TEST_TIME 18 7787
TEST_TIME 19 8018
TEST_TIME 20 8873
TEST_TIME 21 9111
TEST_TIME 22 8965
TEST_TIME 23 9349
TEST_TIME 24 9885
TEST_TIME 25 9801
TEST_TIME 26 10385
TEST_TIME 27 10890
TEST_TIME 28 10927
TEST_TIME 29 10659
TEST_TIME 30 10461
TEST_TIME 31 10364
TEST_TIME 32 10256
TEST_TIME 33 10359
TEST_TIME 34 10165
TEST_TIME 35 10007
TEST_TIME 36 10096
TEST_TIME 37 9955
TEST_TIME 38 9850
TEST_TIME 39 9695
TEST_TIME 40 9481
TEST_TIME 41 9424
TEST_TIME 42 9482
TEST_TIME 43 9334
TEST_TIME 44 9570
TEST_TIME 45 9524
TEST_TIME 46 9480
TEST_TIME 47 9514
TEST_TIME 48 9513
TEST_TIME 49 9463
TEST_TIME 50 9432
TEST_TIME 51 9439
TEST_TIME 52 9385
TEST_TIME 53 9432
TEST_TIME 54 9317
TEST_TIME 55 9535
TEST_TIME 56 9575
TEST_TIME 57 9590
TEST_TIME 58 9587
TEST_TIME 59 9436
TEST_TIME 60 9430
TEST_TIME 61 9393
TEST_TIME 62 9344
TEST_TIME 63 9302
TEST_TIME 64 9291
TEST_TIME 65 9202
TEST_TIME 66 9221
TEST_TIME 67 9210
TEST_TIME 68 9252
TEST_TIME 69 9199
TEST_TIME 70 9282
TEST_TIME 71 9276
TEST_TIME 72 9243
TEST_TIME 73 9207
TEST_TIME 74 9291
TEST_TIME 75 9401
TEST_TIME 76 9380
TEST_TIME 77 9402
TEST_TIME 78 9414
TEST_TIME 79 9500
TEST_TIME 80 9456
TEST_TIME 81 9364
TEST_TIME 82 9323
TEST_TIME 83 9285
TEST_TIME 84 9294
TEST_TIME 85 9234
TEST_TIME 86 9216
TEST_TIME 87 9210
TEST_TIME 88 9206
TEST_TIME 89 9203
TEST_TIME 90 9169
TEST_TIME 91 9189
TEST_TIME 92 9156
TEST_TIME 93 9185
TEST_TIME 94 9197
TEST_TIME 95 9287
TEST_TIME 96 9333
TEST_TIME 97 9383
TEST_TIME 98 9378
TEST_TIME 99 9398
TEST_TIME 100 9399
TEST_TIME 101 9419
TEST_TIME 102 9423
TEST_TIME 103 9442
TEST_TIME 104 9379
TEST_TIME 105 9337
TEST_TIME 106 9308
TEST_TIME 107 9287
TEST_TIME 108 9274
TEST_TIME 109 9229
TEST_TIME 110 9191
TEST_TIME 111 9178
TEST_TIME 112 9175
TEST_TIME 113 9212
TEST_TIME 114 9229
TEST_TIME 115 9221
TEST_TIME 116 9222
TEST_TIME 117 9231
TEST_TIME 118 9242
TEST_TIME 119 9279
TEST_TIME 120 9214

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 10-02-2021 16:28:17 to 10-02-2021 16:28:20.

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 1525574 1525574 0 0.00 0 23383 6 0 0
doc_list_biud 1525572 1525572 0 0.00 0 27832 27 0 0
sp_add_invoice_to_stock 4873 4774 99 2.03 32 138780 16103 0 99
sp_cancel_adding_invoice 5802 5802 0 0.00 6 85050 795 0 0
sp_cancel_client_order 1694 1694 0 0.00 4 10917 344 0 0
sp_cancel_customer_reserve 567250 567250 0 0.00 1 27836 59 0 0
sp_cancel_pay_from_customer 645 645 0 0.00 2 4967 89 0 0
sp_cancel_pay_to_supplier 398 398 0 0.00 3 5276 82 0 0
sp_cancel_supplier_invoice 6372 6361 11 0.17 2 24684 801 0 11
sp_cancel_supplier_order 438 438 0 0.00 6 909114 96519 0 0
sp_cancel_write_off 10187 10187 0 0.00 1 9898 117 0 0
sp_client_order 19518 19518 0 0.00 4 26174 363 0 0
sp_customer_reserve 454895 454895 0 0.00 0 48383 154 0 0
sp_fill_shopping_cart 30059 30059 0 0.00 1 13028 37 0 0
sp_fill_shopping_cart_clo_res 454894 454894 0 0.00 0 15060 13 0 0
sp_get_clo_for_invoice 4769 4769 0 0.00 0 20843 319 0 0
sp_kill_cost_storno 17032 17032 0 0.00 0 23125 61 0 0
sp_kill_qstorno_ret_qs2qd 1151486 1151486 0 0.00 0 27807 32 0 0
sp_kill_qty_storno 605881 605881 0 0.00 0 27831 68 0 0
sp_lock_selected_doc 19792 19792 0 0.00 0 8716 6 0 0
sp_make_cost_storno 26523 26523 0 0.00 0 16910 57 0 0
sp_multiply_rows_for_pdistr 26521 26521 0 0.00 0 10867 36 0 0
sp_multiply_rows_for_qdistr 19518 19518 0 0.00 0 16384 161 0 0
sp_pay_from_customer 6722 6722 0 0.00 4 13190 129 0 0
sp_pay_to_supplier 5650 5650 0 0.00 5 16133 144 0 0
sp_payment_common 12372 12372 0 0.00 1 15745 38 0 0
sp_qd_handle_on_cancel_clo 1694 1694 0 0.00 0 10858 311 0 0
sp_qd_handle_on_invoice_upd_sts 10571 10571 0 0.00 0 20046 315 0 0
sp_qd_handle_on_reserve_upd_sts 9380 9380 0 0.00 0 17506 57 0 0
sp_reserve_write_off 9382 9382 0 0.00 6 17518 193 0 0
sp_supplier_invoice 5273 5273 0 0.00 6 93483 3383 0 0
sp_supplier_order 5281 5281 0 0.00 6 37299 1299 0 0
srv_aggregate_perf_data 92 92 0 0.00 2910 134651 17287 0 0
srv_fill_mon_cache_memory 147 147 0 0.00 1070 207267 36365 0 0
srv_find_qd_qs_mism 1059025 1059025 0 0.00 0 11208 4 0 0
srv_make_invnt_saldo 561 561 0 0.00 28 84205 1063 0 0
srv_make_money_saldo 683 683 0 0.00 0 1440 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 161696 643860 361102 0 0
t$perf-abend:sp_add_invoice_to_stock 99 99 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 4774 4774 0 0.00 0 15822 140 0 0
t$perf-norm:sp_cancel_adding_invoice 401 401 0 0.00 0 2847 88 0 0
t$perf-norm:sp_cancel_client_order 1694 1694 0 0.00 0 1277 11 0 0
t$perf-norm:sp_cancel_customer_reserve 697 697 0 0.00 0 7238 23 0 0
t$perf-norm:sp_cancel_pay_from_customer 645 645 0 0.00 0 5440 26 0 0
t$perf-norm:sp_cancel_pay_to_supplier 398 398 0 0.00 0 3978 13 0 0
t$perf-norm:sp_cancel_supplier_invoice 391 391 0 0.00 0 1564 13 0 0
t$perf-norm:sp_cancel_supplier_order 438 438 0 0.00 0 23303 1544 0 0
t$perf-norm:sp_cancel_write_off 979 979 0 0.00 0 3707 7 0 0
t$perf-norm:sp_client_order 19518 19518 0 0.00 0 7474 18 0 0
t$perf-norm:sp_customer_reserve 976 976 0 0.00 0 3908 8 0 0
t$perf-norm:sp_pay_from_customer 6722 6722 0 0.00 0 13858 10 0 0
t$perf-norm:sp_pay_to_supplier 5650 5650 0 0.00 0 8880 12 0 0
t$perf-norm:sp_reserve_write_off 9382 9382 0 0.00 0 9026 14 0 0
t$perf-norm:sp_supplier_invoice 5273 5273 0 0.00 0 9010 19 0 0
t$perf-norm:sp_supplier_order 5281 5281 0 0.00 0 7118 21 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 3389 42 0 0
t$perf-norm:srv_fill_mon_cache_memory 147 147 0 0.00 0 99 2 0 0
t$perf-norm:srv_make_invnt_saldo 561 561 0 0.00 0 5979 31 0 0
t$perf-norm:srv_make_money_saldo 683 683 0 0.00 0 3442 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 51 14 0 0
v_add_invoice_to_stock 9736 9538 198 2.03 0 5363 20 0 198
v_all_customers 35794 35794 0 0.00 0 18 0 0 0
v_all_suppliers 29630 29630 0 0.00 0 22 1 0 0
v_all_wares 39036 39036 0 0.00 0 181 1 0 0
v_cancel_adding_invoice 802 802 0 0.00 0 2954 12 0 0
v_cancel_client_order 3388 3388 0 0.00 0 8299 8 0 0
v_cancel_customer_prepayment 1290 1290 0 0.00 0 4109 8 0 0
v_cancel_customer_reserve 1394 1394 0 0.00 0 512 3 0 0
v_cancel_payment_to_supplier 796 796 0 0.00 0 2480 6 0 0
v_cancel_supplier_invoice 804 782 22 2.73 0 2297 17 0 22
v_cancel_supplier_order 876 876 0 0.00 0 739 5 0 0
v_cancel_write_off 1958 1958 0 0.00 0 7176 18 0 0
v_max_id_clo_ord 5277 5277 0 0.00 0 572 1 0 0
v_max_id_clo_res 976 976 0 0.00 0 2259 16 0 0
v_max_id_ord_sup 5264 5264 0 0.00 0 5244 6 0 0
v_max_non_paid_invoice 1376 1376 0 0.00 0 703 3 0 0
v_max_non_paid_realizn 3409 3409 0 0.00 0 4987 7 0 0
v_min_id_clo_ord 5277 5277 0 0.00 0 1488 5 0 0
v_min_id_clo_res 976 976 0 0.00 0 1395 5 0 0
v_min_id_ord_sup 5264 5264 0 0.00 0 5463 8 0 0
v_min_non_paid_invoice 5650 5650 0 0.00 0 10406 30 0 0
v_min_non_paid_realizn 6722 6722 0 0.00 0 10839 24 0 0
v_our_firm 9868 9868 0 0.00 0 13 1 0 0
v_reserve_write_off 18760 18760 0 0.00 0 8629 7 0 0
x_lock_depdocs_on_canc_invoice 11772 11772 0 0.00 0 22764 112 0 0
x_lock_depdocs_on_canc_sup_ord 438 438 0 0.00 0 19923 332 0 0
x_make_qstorno_1000_1200 5281 5281 0 0.00 2 37289 1222 0 0
x_make_qstorno_1200_2000 5273 5273 0 0.00 3 92530 3249 0 0
x_make_qstorno_2100_3300 454894 454894 0 0.00 0 48382 139 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-02-2021 16:28:21 to 10-02-2021 16:28:25.

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
13:57:22 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:29 20636 8192000000 10224052032 10530361344 840552000 9.305 67 51 105 0 860462368 2547504 17362864
13:57:59 35812 8192000000 10351799808 10665197568 1374957888 14.371 100 89 178 0 1409976112 4775120 30243104
13:58:44 38280 8192000000 10387790720 10709590016 1430845360 14.869 100 92 184 0 1467677856 6574304 30258192
13:59:34 21583 8192000000 10404048000 10729578496 1454091472 15.074 100 86 172 0 1490025440 7634800 28299168
14:00:09 23939 8192000000 10420949552 10749566976 1469999280 15.214 100 89 178 1 1507171104 8264544 28907280
14:00:45 10722 8192000000 10434151648 10766409728 1487261200 15.365 100 90 180 0 1525504064 8952560 29290304
14:01:04 25250 8192000000 10469304496 10805547008 1520940448 15.658 100 83 166 1 1556586896 9397792 26248656
14:01:40 18916 8192000000 10498026064 10843238400 1550193056 15.912 100 80 159 0 1584252432 9299264 24760112
14:02:09 12946 8192000000 10512542608 10868604928 1576973040 16.142 100 77 153 2 1610595408 10229040 23393328
14:02:37 13776 8192000000 10555541248 10909691904 1607292832 16.402 100 73 146 3 1639609792 10039504 22277456
14:02:58 11376 8192000000 10559646080 10921025536 1621804912 16.525 100 76 152 0 1655272656 10748560 22719184
14:03:16 13758 8192000000 10581215120 10942443520 1642489456 16.701 100 78 156 2 1676596544 11055248 23051840
14:03:38 9187 8192000000 10583048368 10951471104 1652456656 16.785 100 76 152 0 1687074832 11902576 22715600
14:03:59 8805 8192000000 10615744224 10981314560 1673274576 16.961 100 74 148 0 1706399888 11968176 21157136
14:04:15 8392 8192000000 10631686784 11001446400 1682825952 17.041 100 76 151 4 1717786224 12796576 22163696
14:04:31 7803 8192000000 10645404112 11016208384 1704483856 17.223 100 78 156 0 1739626016 12562752 22579408
14:04:45 8219 8192000000 10664974032 11040878592 1721095984 17.361 100 72 144 2 1757986560 16916304 19974272
14:05:00 7665 8192000000 10673263424 11052216320 1741854480 17.534 100 73 142 1 1774195824 12630768 19710576
14:05:15 5144 8192000000 10685854208 11064840192 1752132336 17.619 100 76 151 0 1785737616 12036688 21568592
14:05:28 4996 8192000000 10709982560 11084988416 1762337504 17.704 100 78 156 1 1797117536 12932432 21847600
14:05:39 4740 8192000000 10714282848 11092926464 1776428496 17.820 100 82 163 5 1812213712 13575376 22209840
14:05:52 10312 8192000000 10722927136 11106942976 1783764480 17.880 100 82 162 1 1818900240 12749808 22385952
14:06:10 5973 8192000000 10724984608 11108831232 1793575072 17.961 100 84 168 0 1830969152 14095632 23298448
14:06:23 3015 8192000000 10751827744 11134631936 1806725792 18.069 100 75 148 0 1841174224 12924032 21524400
14:06:33 2119 8192000000 10760241872 11142918144 1822162928 18.195 100 85 168 2 1859029344 12567648 24298768
14:06:42 2238 8192000000 10758682544 11143217152 1825757184 18.225 100 93 183 2 1864238160 12786976 25694000
14:06:51 1625 8192000000 10773255472 11157868544 1829990304 18.259 100 89 176 2 1868016864 12281568 25744992
14:07:00 1952 8192000000 10775819440 11159183360 1834603360 18.297 100 82 161 0 1871406016 13468736 23333920
14:07:09 2702 8192000000 10784646848 11170074624 1841075888 18.350 100 93 186 2 1880663184 13300096 26287200
14:07:18 1386 8192000000 10788356656 11172249600 1845610240 18.386 100 90 180 1 1884994096 14301696 25082160
14:07:26 3093 8192000000 10789573440 11177926656 1849696448 18.420 100 94 188 2 1891722640 14322496 27703696
14:07:35 2853 8192000000 10797115056 11181662208 1851960288 18.438 100 89 178 2 1891397872 13887808 25549776
14:07:45 1860 8192000000 10800889632 11186540544 1854805552 18.461 100 84 163 3 1891330304 14350768 22173984
14:07:54 1735 8192000000 10804119968 11189260288 1856268912 18.473 100 92 184 1 1896681056 14979408 25432736
14:08:02 2487 8192000000 10812477824 11194482688 1860397440 18.507 100 95 188 0 1901154112 14383584 26373088
14:08:11 1946 8192000000 10809357424 11193769984 1862905952 18.527 100 93 186 3 1903016944 13830752 26280240
14:08:19 1592 8192000000 10806140512 11192307712 1864199712 18.537 100 90 180 1 1903263520 13330608 25733200
14:08:27 1745 8192000000 10810158736 11196022784 1865051920 18.544 100 90 179 0 1903757552 13072144 25633488
14:08:36 5573 8192000000 10796815904 11197505536 1866983392 18.560 100 83 168 0 1903932560 13036848 23912320
14:08:50 30400 8192000000 10806172912 11200618496 1865486992 18.548 100 66 133 0 1894475616 9788928 19199696
14:09:26 2141 8192000000 10825725712 11215220736 1878232080 18.651 100 88 177 2 1914534752 11472128 24830544
14:09:35 2376 8192000000 10814428368 11214782464 1875239024 18.627 100 66 133 1 1907481952 13959776 18283152
14:09:45 2727 8192000000 10825002704 11218186240 1881198656 18.675 100 81 162 0 1915751648 11371136 23181856
14:09:55 4568 8192000000 10786260400 11206078464 1871817840 18.599 100 34 68 0 1890382592 8771440 9793312
14:10:08 5469 8192000000 10796300064 11204980736 1875104656 18.626 100 38 75 2 1892235824 6208816 10922352
14:10:20 6133 8192000000 10793337264 11211329536 1878310544 18.651 100 29 58 3 1893469536 7413536 7745456
14:10:33 4597 8192000000 10799331840 11216072704 1878470896 18.653 100 25 50 3 1892227696 6393312 7363488
14:10:48 10537 8192000000 10803380752 11225309184 1885742432 18.711 100 32 64 1 1901710128 6023376 9944320
14:11:07 67167 8192000000 10793413792 11225141248 1888533888 18.734 100 25 50 2 1901054176 5305152 7215136
14:12:23 7306 8192000000 10807434480 11238363136 1898678208 18.816 100 38 76 0 1917148736 7339968 11130560
14:12:40 6302 8192000000 10809782672 11239956480 1898502656 18.814 100 29 58 0 1913041824 6321552 8217616
14:12:52 4631 8192000000 10818224592 11246555136 1902050480 18.843 100 34 69 1 1922445104 10507680 9886944
14:13:05 4519 8192000000 10817347856 11245051904 1902935120 18.850 100 37 75 1 1921177440 7682352 10559968
14:13:16 5283 8192000000 10815386080 11241820160 1898772416 18.816 100 20 40 0 1910979024 5742128 6464480
14:13:29 7948 8192000000 10815463568 11240808448 1899755968 18.824 100 25 50 0 1913439440 6320016 7363456
14:13:47 9818 8192000000 10818503088 11247992832 1902274608 18.845 100 18 36 1 1913087456 5982448 4830400
14:14:05 8222 8192000000 10816858848 11250245632 1907278480 18.885 100 27 51 1 1920271840 6147632 6845728
14:14:19 6244 8192000000 10812200720 11248746496 1905868624 18.873 100 29 59 1 1920677360 7037808 7770928
14:14:36 12448 8192000000 10808016816 11247013888 1885526464 18.710 99 12 24 0 1894192368 5513968 3151936
14:14:55 11652 8192000000 10818304192 11247984640 1903227344 18.852 100 21 40 0 1915627568 6428688 5971536
14:15:13 14126 8192000000 10819257792 11249131520 1889669872 18.743 99 41 82 2 1907230080 5618928 11941280
14:15:59 32005 8192000000 10854921280 11257270272 1905964496 18.874 100 64 129 2 1929794944 5264224 18566224
14:16:38 6736 8192000000 10806903904 11248054272 1903643488 18.856 100 18 37 0 1915184848 6754448 4786912
14:16:50 4508 8192000000 10839212944 11255885824 1893408320 18.773 99 48 93 3 1912261632 5962160 12891152
14:17:03 4757 8192000000 10822045728 11252850688 1904568912 18.863 100 34 69 2 1922827072 8809040 9449120
14:17:14 8874 8192000000 10817757040 11248472064 1890397280 18.749 99 31 62 0 1905559936 6793296 8369360
14:17:31 8511 8192000000 10816444112 11246039040 1901721472 18.840 100 24 48 1 1914018960 5416320 6881168
14:17:47 9725 8192000000 10793962288 11217481728 1851441376 18.434 97 31 63 1 1867122928 7146816 8534736
14:18:04 9128 8192000000 10773307376 11196981248 1809897920 18.095 96 24 48 3 1822956192 6342720 6715552
14:18:22 7675 8192000000 10775112752 11202420736 1822582352 18.199 97 23 46 1 1834289872 5010000 6697520
14:18:36 7825 8192000000 10749513168 11175112704 1797399424 17.993 96 23 46 0 1813569408 9758512 6411472
14:18:52 9511 8192000000 10706758640 11130560512 1692552656 17.123 92 17 33 3 1701942512 4845232 4544624
14:19:09 7085 8192000000 10709254624 11119042560 1740833280 17.526 96 30 59 2 1754992928 4818384 9341264
14:19:25 72590 8192000000 10700191712 11104501760 1672645216 16.955 92 28 56 0 1686845792 6053888 8146688
14:20:49 8541 8192000000 10711481344 11127963648 1734576608 17.474 96 21 42 1 1746034640 6018864 5439168
14:21:04 3633 8192000000 10718548192 11134881792 1762029520 17.701 97 26 52 2 1775117056 5723872 7363664
14:21:19 4597 8192000000 10727461728 11144441856 1796398272 17.984 99 35 71 1 1813161984 6845648 9918064
14:21:29 7762 8192000000 10694790864 11108958208 1695906256 17.151 94 23 46 1 1711355824 9042240 6407328
14:21:44 5551 8192000000 10686637840 11100213248 1713712160 17.300 96 27 55 0 1726797968 4909104 8176704
14:21:55 7527 8192000000 10691286384 11102916608 1755048064 17.643 98 30 56 5 1769857616 5786464 9023088
14:22:09 16089 8192000000 10709890128 11112640512 1747021552 17.577 97 23 46 1 1759842624 5624464 7196608
14:22:34 5060 8192000000 10723908384 11139919872 1807716736 18.077 100 37 75 0 1824944736 5212960 12015040
14:22:46 9342 8192000000 10717893456 11146141696 1794699024 17.970 99 21 42 1 1810150528 10231136 5220368
14:23:03 7612 8192000000 10727486624 11152633856 1799670864 18.011 99 27 54 3 1812700224 5225520 7803840
14:23:17 6998 8192000000 10747988128 11167956992 1832042816 18.276 100 42 84 4 1849495040 5466176 11986048
14:23:33 11067 8192000000 10747947920 11173003264 1838495312 18.329 100 32 64 0 1854306352 5310960 10500080
14:23:52 8356 8192000000 10752647040 11173965824 1840115168 18.342 100 22 44 1 1851658704 5495792 6047744
14:24:07 69292 8192000000 10769173680 11187326976 1847398512 18.401 100 25 50 1 1859861568 4994336 7468720
14:25:22 7554 8192000000 10758168032 11195322368 1853707120 18.452 100 29 58 0 1869649712 8272592 7670000
14:25:37 5382 8192000000 10766384448 11192668160 1854799808 18.461 100 25 50 0 1867989824 5311408 7878608
14:25:50 8050 8192000000 10770478336 11198230528 1854116176 18.456 100 19 38 0 1865944256 6043760 5784320
14:26:06 10354 8192000000 10769955920 11200512000 1855966432 18.471 100 19 38 1 1867070112 5723056 5380624
14:26:23 10404 8192000000 10762991408 11199700992 1860744352 18.509 100 29 58 0 1875370384 5961152 8664880
14:26:42 7179 8192000000 10790709728 11208564736 1863945792 18.535 100 41 83 1 1881565808 5303696 12316320
14:26:57 8729 8192000000 10776585136 11209273344 1865755392 18.550 100 18 36 0 1876507328 5002048 5749888
14:27:12 11469 8192000000 10802040640 11227406336 1882392432 18.684 100 14 28 1 1890581568 4208048 3981088
14:27:31 25805 8192000000 10827905568 11247124480 1895419360 18.789 100 34 68 0 1910876576 6037120 9420096
14:28:13 26086 8192000000 10840143568 11265388544 1910466832 18.910 100 48 96 1 1934260160 10202656 13590672
14:28:52 14978 8192000000 10854489472 11278704640 1924659696 19.024 100 48 96 0 1953898320 15519424 13719200
14:29:14 26823 8192000000 10869328592 11296649216 1934004032 19.099 100 51 102 1 1964910432 16681152 14225248
14:29:50 60209 8192000000 10878735936 11312984064 1946737952 19.200 100 45 91 4 1975947360 15678528 13530880
14:31:00 33999 8192000000 10877451504 11319357440 1949242672 19.220 100 34 68 1 1977257248 17420000 10594576
14:31:43 28803 8192000000 10875959936 11316805632 1931240928 19.077 99 24 48 2 1956696288 17841728 7613632
14:32:23 7250 8192000000 10898002656 11326033920 1954883680 19.265 100 53 106 0 1990994832 19708432 16402720
14:32:39 14159 8192000000 10893685392 11326832640 1960427024 19.309 100 47 94 1 1993969408 20471360 13071024
14:33:06 18893 8192000000 10909332192 11343024128 1970447568 19.389 100 52 104 0 2007713088 22239152 15026368
14:33:31 6701 8192000000 10924828320 11351699456 1975586944 19.430 100 54 108 1 2016753696 25345408 15821344
14:33:44 5516 8192000000 10922207248 11345862656 1959572560 19.303 99 60 119 0 2001810800 25040320 17197920
14:34:01 8145 8192000000 10943902768 11360927744 1979566704 19.461 100 66 132 0 2025677200 26819392 19291104
14:34:17 11687 8192000000 10941683312 11367428096 1988523104 19.532 100 71 140 1 2037669280 28510400 20635776
14:34:37 7402 8192000000 10941914992 11369402368 1986961776 19.520 100 61 122 1 2033654880 28821760 17871344
14:34:52 5655 8192000000 10949409600 11374792704 1990503456 19.548 100 71 138 2 2040074288 29101376 20469456
14:35:06 5589 8192000000 10957527520 11376582656 1991125568 19.553 100 61 122 2 2039066736 29840480 18100688
14:35:21 8399 8192000000 10944731216 11380228096 1991102448 19.553 100 57 111 2 2041598928 32793840 17702640
14:35:38 9914 8192000000 10947170192 11377381376 1992607968 19.564 100 53 105 0 2035465360 26601104 16256288
14:36:01 5834 8192000000 10952526528 11387166720 1997383296 19.602 100 54 107 2 2042152256 27792224 16976736
14:36:13 4167 8192000000 10955000704 11387908096 1999850480 19.622 100 52 104 0 2043779456 27937728 15991248
14:36:27 10961 8192000000 10960869552 11392307200 2001668656 19.636 100 56 111 2 2048758768 30533120 16556992
14:36:46 6437 8192000000 10962177472 11389857792 1999380864 19.618 100 59 118 0 2050175728 33015296 17779568
14:37:01 15545 8192000000 10957235760 11382689792 1977253440 19.443 99 68 135 1 2033714016 35174192 21286384
14:37:33 16077 8192000000 10944066480 11368095744 1967356688 19.364 99 57 114 4 2020372656 34861488 18154480
14:37:58 7933 8192000000 10952376992 11391090688 1985221040 19.506 100 43 85 0 2037345376 38211472 13912864
14:38:19 6059 8192000000 10968414272 11399962624 2001470016 19.634 100 58 114 3 2056604784 37373664 17761104
14:38:35 12068 8192000000 10977950240 11409063936 2006529936 19.674 100 66 132 2 2066057792 38919408 20608448
14:38:55 13425 8192000000 10982612320 11413258240 1993508352 19.572 99 58 116 0 2054256640 42744480 18003808
14:39:19 15504 8192000000 10977394592 11417452544 1994869808 19.582 99 53 108 0 2058385440 46305584 17210048
14:39:47 14827 8192000000 10975468160 11411853312 1996631664 19.596 99 47 93 3 2056246352 44674608 14940080
14:40:09 6145 8192000000 10976585744 11411300352 2008345552 19.688 100 56 112 1 2065054032 38778704 17929776
14:40:24 5993 8192000000 10973212528 11409940480 1996543232 19.595 99 60 118 3 2054739648 39618592 18577824
14:40:37 21332 8192000000 10997404688 11425857536 2002163632 19.640 99 71 142 0 2068022560 43803728 22055200
14:41:15 7342 8192000000 11000362272 11435769856 2020875936 19.787 100 64 128 2 2085928336 44490160 20562240
14:41:36 6272 8192000000 10994256720 11431538688 2017278640 19.759 100 49 98 0 2077086944 43552928 16255376
14:41:53 7246 8192000000 10990591904 11423965184 2010877824 19.708 100 63 125 1 2078254128 46569872 20806432
14:42:15 16245 8192000000 10995110320 11435757568 2018057104 19.765 100 49 97 4 2082041136 47478064 16505968
14:42:43 4655 8192000000 10998822288 11431571456 2020921568 19.787 100 59 118 0 2083498320 43302656 19274096
14:42:57 3313 8192000000 11001063728 11436883968 2024882864 19.818 100 67 134 2 2091059520 44199984 21976672
14:43:09 3938 8192000000 10999408080 11434020864 2024420592 19.815 100 74 149 1 2092903184 44756032 23726560
14:43:21 6322 8192000000 10977791504 11415961600 1979007872 19.457 98 66 132 1 2044562480 43675440 21879168
14:43:39 3593 8192000000 11005715312 11424514048 2013874608 19.732 100 77 152 3 2083329920 44888000 24567312
14:43:51 2799 8192000000 10975508240 11393056768 1986049696 19.513 99 66 132 1 2053366176 45684096 21632384
14:44:00 1070 8192000000 10991179104 11411927040 1990536384 19.548 99 84 168 0 2062987712 45954992 26496336
14:44:08 2020 8192000000 10998518960 11415998464 2004476432 19.658 100 87 167 1 2077953488 45823616 27653440
14:44:17 3769 8192000000 11003782000 11422932992 2010344256 19.704 100 88 176 2 2085187728 47517888 27325584
14:44:28 4736 8192000000 10998732272 11419598848 2003385680 19.649 100 83 165 2 2078988720 49467408 26135632
14:44:44 3880 8192000000 10982537296 11405127680 1987048512 19.520 99 78 153 2 2061828608 50705472 24074624
14:44:55 2606 8192000000 10941130336 11357581312 1949739088 19.224 98 77 152 0 2024746416 50369200 24638128
14:45:05 1121 8192000000 10981949408 11401678848 1986058496 19.513 100 92 183 1 2065701024 50825200 28817328
14:45:17 2818 8192000000 10984132176 11410378752 1991490784 19.556 100 76 150 2 2066932192 51578176 23863232
14:45:28 8333 8192000000 10979587344 11412848640 1991911936 19.559 100 64 128 1 2060278992 47956960 20410096
14:45:43 18171 8192000000 10937825408 11387826176 1944515920 19.183 98 42 84 0 2007076976 47465456 15095600
14:46:19 6895 8192000000 10972491984 11391574016 1960122288 19.307 99 72 141 1 2035547600 52502544 22922768
14:46:33 5508 8192000000 10967886048 11402199040 1976895584 19.440 100 58 116 1 2046243856 50570288 18777984
14:46:46 7067 8192000000 10958274192 11399864320 1965900752 19.353 99 50 100 1 2036263072 53007072 17355248
14:47:00 10519 8192000000 10955075296 11404627968 1977134704 19.442 100 39 78 1 2042859376 52145920 13578752
14:47:19 18182 8192000000 10935650160 11394252800 1966571408 19.358 99 34 67 3 2018980336 41657504 10751424
14:47:46 24221 8192000000 10931978432 11392118784 1968433936 19.373 99 29 58 2 2018205440 39622400 10149104
14:48:18 12915 8192000000 10932514912 11390201856 1956541440 19.279 99 21 42 0 2007632192 43630352 7460400
14:48:42 16607 8192000000 10915337328 11378597888 1961107952 19.315 100 28 56 1 2015519632 44894336 9517344
14:49:20 11199 8192000000 10972884928 11417366528 1986762592 19.518 100 40 80 2 2045464848 45772384 12929872
14:49:40 2751 8192000000 10955364496 11386408960 1965058112 19.346 99 75 149 1 2034260160 46497248 22704800
14:49:50 3334 8192000000 10954521600 11385982976 1968388320 19.373 100 59 119 1 2035867392 48391744 19087328
14:50:02 9313 8192000000 10952233184 11405594624 1976297920 19.435 100 54 108 0 2046926416 53199552 17428944
14:50:28 10357 8192000000 10939965952 11391668224 1973712496 19.415 100 36 72 1 2029924240 43780432 12431312
14:50:45 12078 8192000000 10930049552 11384840192 1946160672 19.196 99 27 53 1 2000624896 45797280 8666944
14:51:03 23524 8192000000 10938954912 11406811136 1976142592 19.434 100 24 47 0 2034688288 49854464 8691232
14:51:44 27822 8192000000 10904040800 11364966400 1905260896 18.869 97 18 36 0 1951938832 40580304 6097632
14:52:19 26881 8192000000 10878047728 11333869568 1859906464 18.503 96 20 40 1 1913187008 46142432 7138112
14:53:09 32653 8192000000 10866292800 11327275008 1885659216 18.711 99 18 36 2 1937342848 45251568 6432064
14:53:51 33419 8192000000 10881409872 11336130560 1922929904 19.010 100 30 60 2 1965911136 33023072 9958160
14:54:34 17738 8192000000 10877760368 11346702336 1923497616 19.015 100 26 52 2 1966288080 34588688 8201776
14:54:59 10725 8192000000 10880260944 11347595264 1935976976 19.115 100 20 40 2 1964635440 22272800 6385664
14:55:42 77017 8192000000 10846299664 11300196352 1883956976 18.697 98 20 39 1 1902438880 12096560 6385344
14:57:38 57391 8192000000 10855188528 11293347840 1878616976 18.654 98 30 60 1 1902741440 14471824 9652640
14:58:42 38822 8192000000 10869485264 11321344000 1929658464 19.064 100 32 65 2 1955728464 16841040 9228960
15:00:10 92933 8192000000 10844582864 11296083968 1847709936 18.404 95 22 46 1 1869869584 15817136 6342512
15:02:36 92783 8192000000 10815710736 11287908352 1866541168 18.556 97 12 24 1 1880277072 10594560 3141344
15:04:15 52577 8192000000 10841822304 11300433920 1903149008 18.852 99 14 28 0 1915329744 8693216 3487520
15:05:15 44625 8192000000 10830890480 11289153536 1871711920 18.598 97 10 19 0 1882411616 8400912 2298784
15:06:06 81165 8192000000 10862273440 11319394304 1931151648 19.076 100 21 43 0 1947849840 10685520 6012672
15:07:50 14248 8192000000 10873044384 11330801664 1941079184 19.155 100 23 46 0 1965486688 17024864 7382640
15:08:55 34409 8192000000 10868138064 11345682432 1945636912 19.192 100 16 32 0 1967472272 17136256 4699104
15:10:01 59737 8192000000 10863592432 11330031616 1926690928 19.040 99 12 24 0 1945340992 15023248 3626816
15:11:10 53893 8192000000 10846653472 11329089536 1897671104 18.808 98 3 6 0 1914220480 15695008 854368
15:12:11 53571 8192000000 10873748224 11340582912 1935774672 19.113 100 12 25 0 1957072496 18179168 3118656
15:13:19 72711 8192000000 10879449040 11351474176 1961534304 19.318 100 31 63 1 1980899440 10662416 8702720
15:14:38 72576 8192000000 10887449200 11362463744 1960787136 19.312 100 9 18 0 1977194624 14030304 2377184
15:15:57 108254 8192000000 10892279936 11358785536 1933036784 19.091 98 11 22 0 1944738448 8877488 2824176
15:18:01 60222 8192000000 10899402400 11377016832 1961014928 19.314 99 28 56 0 1981673456 12745456 7913072
15:19:08 46108 8192000000 10927979312 11382145024 1964161392 19.339 99 26 51 1 1978739280 7743952 6833936
15:20:07 64228 8192000000 10915043792 11389415424 1976176400 19.434 100 11 22 0 1989859824 11080096 2603328
15:21:18 80999 8192000000 10920322224 11403763712 1984811264 19.503 100 10 20 1 2007838352 20336448 2690640
15:22:45 117167 8192000000 10922463664 11396259840 1975757264 19.431 99 11 22 1 1991147488 12905632 2484592
15:24:58 207267 8192000000 10930153968 11397783552 1923440912 19.014 96 24 49 0 1945518464 15712944 6364608
15:28:37 34439 8192000000 10929180736 11408420864 2000333328 19.625 100 9 18 1 2018449424 15816288 2299808
15:29:32 35313 8192000000 10913863792 11381534720 1973100560 19.410 99 22 44 1 1991144768 12333616 5710592
15:30:26 48883 8192000000 10885061296 11364024320 1906900224 18.882 96 15 30 3 1925127280 13887696 4339360
15:31:21 35584 8192000000 10881672480 11363110912 1945074752 19.187 99 11 21 1 1958816080 10879328 2862000
15:32:42 38421 8192000000 10878779136 11351048192 1944375488 19.182 99 14 28 0 1956005584 8154656 3475440
15:33:37 68677 8192000000 10895814112 11383341056 1957399760 19.285 99 9 18 0 1971504896 11636768 2468368
15:35:11 96392 8192000000 10929048256 11391934464 1944274464 19.181 98 20 40 1 1961076288 11026768 5775056
15:36:56 95333 8192000000 10890099504 11373473792 1929184368 19.060 97 29 54 1 1951575216 14857664 7533184
15:38:49 38686 8192000000 10885001808 11354226688 1923856176 19.018 98 17 34 1 1936340672 7917712 4566784
15:39:41 30032 8192000000 10877615024 11337064448 1863898496 18.535 95 26 52 1 1880277648 9376224 7002928
15:40:22 21384 8192000000 10899656416 11342163968 1909800048 18.905 98 51 100 2 1935726496 12029216 13897232
15:40:54 46286 8192000000 10870991152 11336785920 1888134032 18.731 97 35 70 0 1914680224 16606672 9939520
15:42:20 110619 8192000000 10876749008 11343118336 1845289040 18.384 95 11 22 0 1861401072 13251296 2860736
15:44:18 90137 8192000000 10869632944 11350056960 1869969712 18.584 96 9 18 1 1884295152 11859728 2465712
15:45:54 52465 8192000000 10880013664 11327008768 1912257264 18.925 98 24 48 1 1935061200 15950256 6853680
15:46:54 46255 8192000000 10842950208 11317612544 1880423568 18.669 97 24 47 2 1901792576 14479664 6889344
15:47:47 95981 8192000000 10833656992 11290689536 1830101104 18.260 95 31 60 3 1845900832 5937712 9862016
15:49:37 54704 8192000000 10828999808 11285897216 1853101680 18.447 97 21 42 0 1866778016 8209984 5466352
15:50:43 31563 8192000000 10854775984 11288543232 1847432976 18.401 97 49 98 1 1874123312 13115616 13574720
15:51:20 62741 8192000000 10826929248 11299274752 1894606656 18.783 99 43 85 1 1917833040 11357728 11868656
15:52:30 74879 8192000000 10829359744 11309518848 1896701248 18.800 99 9 18 0 1909518976 10188032 2629696
15:53:51 50316 8192000000 10833865776 11303415808 1882414304 18.685 98 14 29 0 1898665296 11892768 4358224
15:56:13 65043 8192000000 10831274528 11304734720 1863882480 18.535 97 14 28 0 1877125536 9874704 3368352
15:57:24 29022 8192000000 10842943984 11312119808 1909149440 18.900 99 16 32 0 1919997664 6561376 4286848
15:58:00 60397 8192000000 10867913744 11336298496 1927664064 19.048 99 25 50 2 1944799552 10401376 6734112
15:59:14 76025 8192000000 10876419616 11337633792 1866450624 18.556 95 15 30 2 1888818800 18352352 4015824
16:00:36 48610 8192000000 10885484896 11353481216 1946344144 19.197 100 22 44 1 1966718032 13967968 6405920
16:01:32 67968 8192000000 10880279904 11355258880 1916934928 18.962 98 19 38 1 1938553280 15942560 5675792
16:02:51 83424 8192000000 10911743808 11372683264 1938771360 19.137 99 18 37 0 1964343584 20467184 5105040
16:04:41 49904 8192000000 10893255920 11382722560 1945421088 19.190 99 13 26 0 1964550112 15282512 3846512
16:05:37 72575 8192000000 10908939008 11380224000 1954130544 19.259 99 19 38 1 1972027808 12309632 5587632
16:07:02 57989 8192000000 10899017424 11369713664 1938565680 19.135 98 24 48 0 1956773712 11958736 6249296
16:08:12 97131 8192000000 10906849216 11378720768 1946069936 19.195 99 12 24 0 1963789120 14468304 3250880
16:09:55 78177 8192000000 10905156832 11387797504 1964717152 19.344 99 26 52 1 1981715280 9975760 7022368
16:11:22 108444 8192000000 10895407744 11361787904 1903515728 18.855 96 21 42 1 1917103184 7876192 5711264
16:13:27 40739 8192000000 10903495312 11375263744 1975343936 19.428 100 29 57 2 1995018336 11709760 7964640
16:14:15 34138 8192000000 10866588400 11338280960 1923174736 19.012 97 25 50 2 1942412720 12404832 6833152
16:15:01 72227 8192000000 10900127680 11388489728 1979400256 19.460 100 9 18 0 1992169472 10080144 2689072
16:16:19 35948 8192000000 10896975104 11379810304 1965200544 19.347 99 9 18 0 1978477152 10639280 2637328
16:17:01 77973 8192000000 10903547664 11380563968 1927178656 19.044 97 21 42 1 1948618160 15154384 6285120
16:18:34 65298 8192000000 10907522864 11383881728 1965958768 19.353 100 20 40 1 1990950160 18821216 6170176
16:19:51 71375 8192000000 10892120480 11387883520 1953682928 19.256 99 11 22 1 1976450656 19266048 3501680
16:21:14 68898 8192000000 10900412528 11377164288 1945338976 19.189 98 19 38 2 1959415136 8718448 5357712
16:22:38 28060 8192000000 10903276976 11384176640 1964721696 19.344 99 28 55 4 1980571648 7667616 8182336
16:23:17 41078 8192000000 10888420576 11359125504 1904333408 18.861 96 26 52 1 1921571984 9223376 8015200
16:24:33 42958 8192000000 10900868768 11372580864 1940907456 19.154 98 30 59 1 1960230640 10561312 8761872
16:25:22 41377 8192000000 10868083040 11334856704 1866070720 18.552 95 23 46 0 1882161920 9245424 6845776
16:26:22 41014 8192000000 10876515536 11340800000 1914760384 18.945 98 28 56 0 1933626720 11024992 7841344
16:27:13 14154 8192000000 8944137424 9204854784 85652544 1.034 5 2 4 0 86760176 770720 336912

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 10-02-2021 16:28:27 to 10-02-2021 16:28:57.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 99 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:02, from 10-02-2021 16:28:58 to 10-02-2021 16:29:00.

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          234158
MON$OLDEST_ACTIVE               234159
MON$OLDEST_SNAPSHOT             234159
MON$NEXT_TRANSACTION            234159
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                       1999872
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
:170: 
:171: mscs-test-161.budzdorov.ru    Wed Feb 10 16:27:29 2021
:172:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:173: 
--- end of diff output ---

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

10.02.21 16:29:01. 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-10 16:29:03 No severe PSQL-related problems occured
10.02.21 16:29:04. End of report.