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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 58e1ddde69c44dad93d327777e5becec
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-05-09 08:45
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 4793.92
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 17372260 kB
MemAvailable 31412120 kB
Buffers 0 kB
Cached 14301884 kB
SwapCached 32 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-06-14 01:27:39
DTS_END                         2021-06-14 01:27:39.3330
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/34358
TRN_ID                          235377
ATT_ID                          636
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: 9044.23 28253 1085307
customer order: creation 162.48 387 19498
customer order: refuse 14.69 367 1763
order to supplier: creation 43.82 1301 5258
order to supplier: removal 3.31 97810 397
invoice (draft): creation 44.32 3301 5318
invoice (draft): removal 53.31 698 6397
invoice accept: apply 39.73 17885 4767
invoice accept: cancel 47.60 792 5712
customer reserve: creation 3682.57 176 441908
customer reserve: removal 4659.83 56 559180
realization accept: apply 78.79 206 9455
realization accept: cancel 86.63 109 10396
payment from customer: creation 58.84 130 7061
payment from customer: removal 5.43 86 651
payment to supplier: creation 48.38 130 5806
payment to supplier: removal 3.28 107 394
service: total inventory turnovers 4.20 1314 504
service: total monetary turnovers 6.16 26 739
service: aggregate perf. data 0.83 16944 99
service: refresh index statistics 0.03 423228 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-06-2021 01:29:02 to 14-06-2021 01:29:04.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2224
TEST_TIME 2 2553
TEST_TIME 3 2321
TEST_TIME 4 3452
TEST_TIME 5 3382
TEST_TIME 6 3876
TEST_TIME 7 4109
TEST_TIME 8 4117
TEST_TIME 9 4676
TEST_TIME 10 5159
TEST_TIME 11 5311
TEST_TIME 12 5456
TEST_TIME 13 5667
TEST_TIME 14 6073
TEST_TIME 15 6464
TEST_TIME 16 6810
TEST_TIME 17 7077
TEST_TIME 18 7546
TEST_TIME 19 8129
TEST_TIME 20 8063
TEST_TIME 21 8027
TEST_TIME 22 8184
TEST_TIME 23 8637
TEST_TIME 24 8855
TEST_TIME 25 9073
TEST_TIME 26 9253
TEST_TIME 27 9643
TEST_TIME 28 9812
TEST_TIME 29 10666
TEST_TIME 30 10566
TEST_TIME 31 10245
TEST_TIME 32 10362
TEST_TIME 33 10167
TEST_TIME 34 10136
TEST_TIME 35 9931
TEST_TIME 36 9965
TEST_TIME 37 9981
TEST_TIME 38 9808
TEST_TIME 39 9815
TEST_TIME 40 9754
TEST_TIME 41 9714
TEST_TIME 42 9537
TEST_TIME 43 9635
TEST_TIME 44 9518
TEST_TIME 45 9419
TEST_TIME 46 9430
TEST_TIME 47 9404
TEST_TIME 48 9313
TEST_TIME 49 9262
TEST_TIME 50 9226
TEST_TIME 51 9081
TEST_TIME 52 9099
TEST_TIME 53 9027
TEST_TIME 54 9036
TEST_TIME 55 8996
TEST_TIME 56 9052
TEST_TIME 57 9156
TEST_TIME 58 9092
TEST_TIME 59 9121
TEST_TIME 60 9037
TEST_TIME 61 9222
TEST_TIME 62 9322
TEST_TIME 63 9347
TEST_TIME 64 9460
TEST_TIME 65 9524
TEST_TIME 66 9535
TEST_TIME 67 9538
TEST_TIME 68 9492
TEST_TIME 69 9395
TEST_TIME 70 9387
TEST_TIME 71 9346
TEST_TIME 72 9309
TEST_TIME 73 9311
TEST_TIME 74 9260
TEST_TIME 75 9212
TEST_TIME 76 9181
TEST_TIME 77 9108
TEST_TIME 78 9147
TEST_TIME 79 9166
TEST_TIME 80 9198
TEST_TIME 81 9241
TEST_TIME 82 9263
TEST_TIME 83 9270
TEST_TIME 84 9335
TEST_TIME 85 9351
TEST_TIME 86 9420
TEST_TIME 87 9410
TEST_TIME 88 9454
TEST_TIME 89 9508
TEST_TIME 90 9411
TEST_TIME 91 9362
TEST_TIME 92 9313
TEST_TIME 93 9310
TEST_TIME 94 9270
TEST_TIME 95 9227
TEST_TIME 96 9257
TEST_TIME 97 9240
TEST_TIME 98 9248
TEST_TIME 99 9236
TEST_TIME 100 9231
TEST_TIME 101 9256
TEST_TIME 102 9302
TEST_TIME 103 9282
TEST_TIME 104 9291
TEST_TIME 105 9300
TEST_TIME 106 9283
TEST_TIME 107 9300
TEST_TIME 108 9316
TEST_TIME 109 9342
TEST_TIME 110 9322
TEST_TIME 111 9239
TEST_TIME 112 9240
TEST_TIME 113 9215
TEST_TIME 114 9225
TEST_TIME 115 9180
TEST_TIME 116 9152
TEST_TIME 117 9094
TEST_TIME 118 9080
TEST_TIME 119 9077
TEST_TIME 120 9046

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 14-06-2021 01:29:05 to 14-06-2021 01:29:09.

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 1496215 1496215 0 0.00 0 16174 6 0 0
doc_list_biud 1496214 1496214 0 0.00 0 33059 26 0 0
sp_add_invoice_to_stock 4882 4767 115 2.35 34 316091 17885 0 115
sp_cancel_adding_invoice 5712 5712 0 0.00 4 57557 792 0 0
sp_cancel_client_order 1763 1763 0 0.00 4 11672 368 0 0
sp_cancel_customer_reserve 559180 559180 0 0.00 1 33060 56 0 0
sp_cancel_pay_from_customer 651 651 0 0.00 3 5313 86 0 0
sp_cancel_pay_to_supplier 394 394 0 0.00 2 11441 108 0 0
sp_cancel_supplier_invoice 6401 6397 4 0.06 1 23799 698 0 4
sp_cancel_supplier_order 397 397 0 0.00 7 974329 97810 0 0
sp_cancel_write_off 10396 10396 0 0.00 1 10848 109 0 0
sp_client_order 19498 19498 0 0.00 3 23629 387 0 0
sp_customer_reserve 441908 441908 0 0.00 0 188684 177 0 0
sp_fill_shopping_cart 30070 30070 0 0.00 1 15211 38 0 0
sp_fill_shopping_cart_clo_res 441901 441901 0 0.00 0 25942 16 0 0
sp_get_clo_for_invoice 4760 4760 0 0.00 0 34850 332 0 0
sp_kill_cost_storno 17153 17153 0 0.00 0 12088 52 0 0
sp_kill_qstorno_ret_qs2qd 1135550 1135550 0 0.00 0 33057 30 0 0
sp_kill_qty_storno 598059 598059 0 0.00 0 33059 65 0 0
sp_lock_selected_doc 19847 19847 0 0.00 0 8154 6 0 0
sp_make_cost_storno 27082 27082 0 0.00 0 16017 61 0 0
sp_multiply_rows_for_pdistr 27081 27081 0 0.00 0 7671 28 0 0
sp_multiply_rows_for_qdistr 19498 19498 0 0.00 0 23621 176 0 0
sp_pay_from_customer 7061 7061 0 0.00 4 12156 130 0 0
sp_pay_to_supplier 5806 5806 0 0.00 5 15908 130 0 0
sp_payment_common 12867 12867 0 0.00 1 7664 25 0 0
sp_qd_handle_on_cancel_clo 1763 1763 0 0.00 0 11662 333 0 0
sp_qd_handle_on_invoice_upd_sts 10472 10472 0 0.00 0 19600 308 0 0
sp_qd_handle_on_reserve_upd_sts 9454 9454 0 0.00 0 27819 81 0 0
sp_reserve_write_off 9455 9455 0 0.00 6 27986 207 0 0
sp_supplier_invoice 5318 5318 0 0.00 6 57502 3302 0 0
sp_supplier_order 5258 5258 0 0.00 6 30248 1302 0 0
srv_aggregate_perf_data 100 99 1 1.00 2622 128036 16944 0 1
srv_fill_mon_cache_memory 148 148 0 0.00 1402 220712 37348 0 0
srv_find_qd_qs_mism 1040184 1040184 0 0.00 0 15441 5 0 0
srv_make_invnt_saldo 504 504 0 0.00 29 86117 1314 0 0
srv_make_money_saldo 739 739 0 0.00 1 3305 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 173045 727052 423229 0 0
t$perf-abend:sp_add_invoice_to_stock 115 115 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4767 4767 0 0.00 0 17404 195 0 0
t$perf-norm:sp_cancel_adding_invoice 417 417 0 0.00 0 4853 108 0 0
t$perf-norm:sp_cancel_client_order 1763 1763 0 0.00 0 9186 23 0 0
t$perf-norm:sp_cancel_customer_reserve 641 641 0 0.00 0 2880 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 651 651 0 0.00 0 1899 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 394 394 0 0.00 0 2843 13 0 0
t$perf-norm:sp_cancel_supplier_invoice 445 445 0 0.00 0 9041 34 0 0
t$perf-norm:sp_cancel_supplier_order 397 397 0 0.00 0 27710 1456 0 0
t$perf-norm:sp_cancel_write_off 925 925 0 0.00 0 4118 14 0 0
t$perf-norm:sp_client_order 19498 19498 0 0.00 0 8369 19 0 0
t$perf-norm:sp_customer_reserve 986 986 0 0.00 0 2977 14 0 0
t$perf-norm:sp_pay_from_customer 7061 7061 0 0.00 0 7841 14 0 0
t$perf-norm:sp_pay_to_supplier 5806 5806 0 0.00 0 5469 10 0 0
t$perf-norm:sp_reserve_write_off 9455 9455 0 0.00 0 8393 16 0 0
t$perf-norm:sp_supplier_invoice 5318 5318 0 0.00 0 5534 20 0 0
t$perf-norm:sp_supplier_order 5258 5258 0 0.00 0 5171 19 0 0
t$perf-norm:srv_aggregate_perf_data 99 99 0 0.00 0 13 0 0 0
t$perf-norm:srv_fill_mon_cache_memory 148 148 0 0.00 0 138 3 0 0
t$perf-norm:srv_make_invnt_saldo 504 504 0 0.00 0 1722 26 0 0
t$perf-norm:srv_make_money_saldo 739 739 0 0.00 0 3600 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 7 4 0 0
v_add_invoice_to_stock 9750 9520 230 2.35 0 8351 19 0 230
v_all_customers 36300 36300 0 0.00 0 80 1 0 0
v_all_suppliers 29614 29614 0 0.00 0 17 1 0 0
v_all_wares 38996 38996 0 0.00 0 81 1 0 0
v_cancel_adding_invoice 834 834 0 0.00 0 3362 15 0 0
v_cancel_client_order 3526 3526 0 0.00 0 8368 10 0 0
v_cancel_customer_prepayment 1302 1302 0 0.00 0 2462 8 0 0
v_cancel_customer_reserve 1282 1282 0 0.00 0 3417 6 0 0
v_cancel_payment_to_supplier 788 788 0 0.00 0 11378 28 0 0
v_cancel_supplier_invoice 898 890 8 0.89 0 1557 16 0 8
v_cancel_supplier_order 794 794 0 0.00 0 3714 12 0 0
v_cancel_write_off 1850 1850 0 0.00 0 5401 17 0 0
v_max_id_clo_ord 5256 5256 0 0.00 0 684 1 0 0
v_max_id_clo_res 986 986 0 0.00 0 3380 19 0 0
v_max_id_ord_sup 5314 5314 0 0.00 0 3974 7 0 0
v_max_non_paid_invoice 1569 1569 0 0.00 0 4811 8 0 0
v_max_non_paid_realizn 3510 3510 0 0.00 0 2071 3 0 0
v_min_id_clo_ord 5256 5256 0 0.00 0 3106 6 0 0
v_min_id_clo_res 986 986 0 0.00 0 2009 8 0 0
v_min_id_ord_sup 5314 5314 0 0.00 0 5239 5 0 0
v_min_non_paid_invoice 5806 5806 0 0.00 0 5387 13 0 0
v_min_non_paid_realizn 7061 7061 0 0.00 0 6711 18 0 0
v_our_firm 9798 9798 0 0.00 0 97 1 0 0
v_reserve_write_off 18908 18908 0 0.00 0 8369 8 0 0
x_lock_depdocs_on_canc_invoice 11664 11664 0 0.00 0 20949 118 0 0
x_lock_depdocs_on_canc_sup_ord 397 397 0 0.00 0 12171 296 0 0
x_make_qstorno_1000_1200 5258 5258 0 0.00 2 30218 1222 0 0
x_make_qstorno_1200_2000 5318 5318 0 0.00 2 57494 3164 0 0
x_make_qstorno_2100_3300 441907 441907 0 0.00 0 188678 158 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-06-2021 01:29:10 to 14-06-2021 01:29:14.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:43 2 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
22:57:49 15684 8192000000 10233264608 10542391296 938673824 10.280 72 56 112 0 960121216 2748720 18698672
22:58:14 36406 8192000000 10343546208 10659348480 1386643888 14.476 100 85 170 0 1419304240 4862336 27798016
22:59:01 18678 8192000000 10380180112 10703261696 1433065808 14.888 100 88 175 0 1468001248 6257040 28678400
22:59:28 25560 8192000000 10415894016 10741780480 1469160272 15.206 100 92 184 1 1506099616 7244432 29694912
23:00:01 33285 8192000000 10438788048 10766073856 1486953920 15.362 100 92 184 2 1524155552 8041344 29160288
23:00:45 25447 8192000000 10446321824 10779901952 1498768992 15.465 100 87 174 0 1535414944 8781744 27864208
23:01:20 25090 8192000000 10476865168 10811662336 1525526128 15.698 100 88 176 0 1561951264 9068512 27356624
23:01:57 19339 8192000000 10489081680 10830954496 1547036912 15.884 100 88 176 1 1584465392 9819184 27609296
23:02:32 13529 8192000000 10512689392 10864238592 1578496384 16.155 100 74 149 0 1610211600 9281744 22433472
23:02:54 19106 8192000000 10559563232 10915229696 1612201856 16.443 100 84 168 1 1646983792 9934480 24847456
23:03:30 16204 8192000000 10590894112 10957377536 1643815376 16.712 100 65 130 0 1673022496 10443136 18763984
23:03:55 3956 8192000000 10611671344 10974195712 1674602016 16.972 100 84 168 0 1710521472 11627248 24292208
23:04:10 11717 8192000000 10621398384 10990649344 1684802800 17.058 100 83 166 1 1721258224 12572640 23882784
23:04:29 16693 8192000000 10654279856 11020128256 1708244192 17.254 100 81 163 0 1744165136 12445168 23475776
23:04:53 11264 8192000000 10670690096 11042779136 1725023104 17.394 100 85 170 0 1763328128 13986640 24318384
23:05:11 8416 8192000000 10675318880 11051413504 1736512880 17.490 100 78 157 1 1772635664 13757184 22365600
23:05:32 8293 8192000000 10680050976 11057152000 1748215008 17.587 100 78 153 1 1782456128 12720480 21520640
23:05:47 7842 8192000000 10690736992 11070533632 1762685248 17.707 100 84 168 1 1799078368 12473152 23919968
23:06:02 5596 8192000000 10704990048 11083862016 1762624992 17.706 100 75 146 4 1795519584 11957200 20937392
23:06:18 4710 8192000000 10709498656 11089985536 1773350256 17.795 100 82 164 1 1808396256 12403584 22642416
23:06:30 6490 8192000000 10719170096 11104227328 1783203936 17.876 100 72 144 0 1815681952 12013680 20464336
23:06:46 7666 8192000000 10727082960 11113525248 1792766784 17.955 100 76 150 2 1827217792 13056848 21394160
23:07:02 4551 8192000000 10758580576 11136524288 1809740064 18.094 100 92 183 1 1850662864 14649184 26273616
23:07:13 3845 8192000000 10760154480 11144273920 1817474128 18.157 100 84 168 0 1855833232 14641600 23717504
23:07:23 4301 8192000000 10752788896 11139928064 1823289536 18.205 100 88 176 1 1862982144 15063344 24629264
23:07:34 2466 8192000000 10769941360 11155210240 1827376512 18.238 100 83 165 1 1864634336 13762464 23495360
23:07:44 2523 8192000000 10776082320 11160043520 1829190560 18.253 100 90 178 2 1868341136 13857824 25292752
23:07:53 2411 8192000000 10773046912 11159552000 1833891296 18.291 100 88 176 1 1872496400 14109136 24495968
23:08:02 2818 8192000000 10777596624 11162746880 1838528160 18.329 100 91 179 2 1878432096 13763408 26140528
23:08:11 1412 8192000000 10785556768 11169980416 1845839456 18.388 100 88 178 2 1884577760 13047952 25690352
23:08:19 3248 8192000000 10790970992 11177725952 1851254976 18.432 100 94 188 2 1890274112 12960672 26058464
23:08:28 2702 8192000000 10796588368 11184459776 1855877168 18.470 100 93 184 0 1896130944 13814064 26439712
23:08:38 1900 8192000000 10804858800 11191599104 1859672448 18.501 100 94 188 0 1899673040 12836800 27163792
23:08:47 1773 8192000000 10812698192 11196194816 1860386944 18.506 100 95 188 0 1902025472 14437744 27200784
23:08:55 2249 8192000000 10808388656 11194892288 1863781056 18.534 100 92 186 2 1903124368 13232528 26110784
23:09:04 2548 8192000000 10810404208 11196887040 1863384672 18.531 100 94 188 2 1904272752 13504096 27383984
23:09:12 2575 8192000000 10815311728 11201253376 1866828992 18.559 100 95 191 0 1908019552 13752208 27438352
23:09:21 3733 8192000000 10798748112 11199467520 1867281232 18.562 100 87 174 2 1905639104 13457872 24900000
23:09:37 31647 8192000000 10795153760 11195404288 1863161168 18.529 100 63 126 3 1891930112 9982128 18786816
23:10:15 1398 8192000000 10811183456 11202473984 1870472416 18.588 100 94 187 2 1908878944 10905808 27500720
23:10:23 2414 8192000000 10802236544 11201564672 1864400736 18.539 100 57 112 1 1891684208 11779056 15504416
23:10:32 6044 8192000000 10782169552 11195527168 1861796144 18.518 100 41 83 3 1882102816 8402768 11903904
23:10:45 4159 8192000000 10780177392 11200557056 1863823696 18.534 100 37 74 1 1882743520 8541440 10378384
23:11:01 5220 8192000000 10777915968 11200237568 1865603072 18.549 100 38 76 0 1884810976 7692544 11515360
23:11:14 9116 8192000000 10785427088 11201740800 1868506288 18.572 100 25 50 0 1881450144 5780560 7163296
23:11:32 7751 8192000000 10781463184 11205124096 1871642880 18.598 100 15 30 2 1880942224 5580704 3718640
23:11:46 5351 8192000000 10777865712 11208089600 1874002704 18.617 100 21 42 3 1886337152 6502064 5832384
23:11:58 13075 8192000000 10779092000 11210891264 1874312784 18.619 100 15 30 3 1884412592 5890464 4209344
23:12:19 10193 8192000000 10778786512 11213680640 1877133952 18.642 100 20 40 0 1889165008 6200048 5831008
23:12:39 5155 8192000000 10789077536 11218874368 1880471088 18.669 100 16 30 2 1890570864 5829120 4270656
23:12:51 13148 8192000000 10785982432 11224031232 1881648992 18.678 100 14 28 0 1891327616 5560976 4117648
23:13:12 72881 8192000000 10822741568 11239956480 1889549984 18.742 100 28 56 0 1903823984 5642096 8631904
23:14:32 18383 8192000000 10807864192 11238150144 1891469584 18.758 100 23 47 0 1904322928 6395776 6457568
23:14:58 5428 8192000000 10811978816 11242135552 1897574064 18.807 100 35 68 2 1914134048 6306496 10253488
23:15:10 7986 8192000000 10821271792 11247210496 1902387728 18.845 100 41 83 0 1920913968 5740448 12785792
23:15:25 5737 8192000000 10820356400 11250135040 1901015328 18.834 100 26 52 3 1914320832 6053312 7252192
23:15:39 7307 8192000000 10818526496 11248250880 1899360160 18.821 100 21 42 0 1915656192 10658992 5637040
23:15:55 6494 8192000000 10792910688 11225927680 1883045120 18.690 99 20 40 2 1894274944 5294080 5935744
23:16:08 9319 8192000000 10819946608 11250409472 1899777712 18.825 100 29 57 1 1913295536 5317216 8200608
23:16:26 10306 8192000000 10812780768 11246039040 1899305024 18.821 100 33 66 0 1915722480 5580480 10836976
23:16:44 7472 8192000000 10815956208 11246301184 1882237856 18.683 99 17 34 0 1892728656 5802560 4688240
23:17:04 16586 8192000000 10799557344 11239985152 1876681424 18.638 99 19 38 0 1888804272 6589136 5533712
23:17:32 8926 8192000000 10815175312 11242680320 1891283920 18.756 100 18 36 2 1902182032 6049744 4848368
23:17:51 67305 8192000000 10812695248 11243114496 1844543648 18.378 97 28 56 1 1862503264 9379248 8580368
23:19:06 4768 8192000000 10784019808 11216580608 1860227712 18.505 99 20 40 0 1871651776 5647504 5776560
23:19:17 12386 8192000000 10779726416 11204636672 1841493040 18.353 99 15 29 3 1851025984 5106976 4425968
23:19:36 5493 8192000000 10769246480 11194605568 1825337024 18.221 98 30 60 2 1840742288 6965296 8439968
23:19:48 7000 8192000000 10743428448 11168403456 1776917568 17.824 96 24 48 2 1789894192 5414256 7562368
23:20:01 6414 8192000000 10754766416 11174412288 1795566832 17.978 97 34 68 0 1811739856 6394064 9778960
23:20:15 5008 8192000000 10721652832 11144130560 1774598576 17.805 98 24 47 1 1787420304 5920384 6901344
23:20:27 6584 8192000000 10723722480 11133169664 1753855584 17.634 97 27 54 0 1767760496 5459584 8445328
23:20:42 4987 8192000000 10742053152 11160920064 1816905888 18.152 100 20 40 4 1828493728 6064224 5523616
23:20:56 9674 8192000000 10697567120 11115778048 1756033152 17.652 97 26 53 1 1770259824 5463136 8763536
23:21:12 7935 8192000000 10681559696 11094953984 1698611600 17.173 95 25 50 0 1711668240 5331296 7725344
23:21:27 10779 8192000000 10680654976 11096530944 1691759984 17.116 95 23 46 2 1704301472 5816000 6725488
23:21:44 5496 8192000000 10687880480 11100745728 1754108208 17.636 99 30 60 2 1768809904 5704240 8997456
23:21:57 8939 8192000000 10694035616 11110801408 1734197024 17.470 97 25 50 2 1746400144 4816016 7387104
23:22:12 10508 8192000000 10697326704 11105546240 1754989696 17.643 98 22 43 2 1767275808 5561824 6724288
23:22:30 21712 8192000000 10713529664 11135229952 1770389520 17.770 98 21 40 2 1783332304 5127552 7815232
23:22:58 79892 8192000000 10732816560 11155927040 1799007344 18.006 99 33 64 0 1813530224 4854608 9668272
23:24:24 8326 8192000000 10752078912 11172147200 1834281664 18.294 100 28 56 1 1848551216 6287728 7981824
23:24:38 7978 8192000000 10766665904 11180847104 1838745200 18.331 100 27 54 2 1853330256 7207984 7377072
23:24:54 6115 8192000000 10760994512 11183669248 1845672896 18.387 100 40 79 3 1865925392 8296000 11956496
23:25:09 5670 8192000000 10772509184 11194449920 1848600576 18.411 100 30 60 1 1868227248 11229072 8397600
23:25:20 5711 8192000000 10776751824 11190267904 1835652752 18.305 99 37 74 1 1852175968 6322336 10200880
23:25:34 7880 8192000000 10757437008 11182669824 1830930272 18.267 99 24 47 0 1843440272 6102048 6407952
23:25:50 9183 8192000000 10770813424 11196284928 1855718416 18.469 100 35 70 1 1871270704 4691488 10860800
23:26:06 5974 8192000000 10777125696 11203297280 1860635568 18.508 100 29 58 1 1874717664 5130944 8951152
23:26:18 10656 8192000000 10771308368 11202764800 1862773408 18.526 100 27 54 0 1876398304 5705392 7919504
23:26:37 14159 8192000000 10773013360 11203076096 1859931344 18.503 100 14 28 1 1869253952 5548208 3774400
23:26:58 7614 8192000000 10787206160 11206909952 1863633472 18.533 100 24 48 2 1876019568 5701696 6684400
23:27:13 9434 8192000000 10794963152 11224891392 1878159280 18.650 100 14 28 1 1891056720 9627712 3269728
23:27:29 14814 8192000000 10801513216 11231793152 1887854688 18.728 100 16 32 0 1897410880 5358464 4197728
23:28:27 34902 8192000000 10848290752 11262676992 1915610080 18.952 100 49 98 1 1936973504 6542656 14820768
23:29:44 94815 8192000000 10863175568 11289407488 1929211824 19.061 100 45 90 2 1956824624 14718624 12894176
23:31:26 24108 8192000000 10853462992 11291017216 1929324784 19.061 100 30 60 1 1953045408 14794768 8925856
23:31:58 11995 8192000000 10859115856 11294998528 1931637504 19.080 100 37 73 3 1957757008 14826400 11293104
23:32:32 14932 8192000000 10885544816 11307753472 1946310352 19.197 100 52 104 3 1976195856 15044224 14841280
23:32:54 18073 8192000000 10882836192 11315662848 1950579632 19.231 100 52 102 1 1982035664 16790720 14665312
23:33:24 28555 8192000000 10887547184 11322355712 1953567504 19.255 100 39 78 0 1981424528 16868640 10988384
23:34:05 5036 8192000000 10898476048 11326943232 1957496208 19.286 100 54 108 2 1993317120 19276208 16544704
23:34:29 9400 8192000000 10905437408 11333394432 1962874992 19.329 100 41 81 2 1991830240 15977632 12977616
23:34:50 12271 8192000000 10903631552 11337732096 1967581824 19.366 100 51 100 2 1999167712 16732336 14853552
23:35:09 7349 8192000000 10912910320 11341127680 1970372976 19.388 100 58 114 1 2005839360 17932688 17533696
23:35:25 10642 8192000000 10917558112 11348107264 1972390144 19.404 100 57 112 1 2008127648 19262944 16474560
23:35:43 12237 8192000000 10915201264 11347181568 1972592416 19.406 100 51 101 2 2007737584 20411920 14733248
23:36:05 9950 8192000000 10923464480 11351908352 1974791248 19.423 100 54 108 1 2012431568 20912976 16727344
23:36:22 5669 8192000000 10923095952 11355127808 1976065136 19.434 100 52 102 2 2012916896 21552656 15299104
23:36:37 2765 8192000000 10924109488 11349757952 1974870400 19.424 100 56 109 1 2009242064 17708400 16663264
23:36:49 3064 8192000000 10943044768 11361333248 1981559168 19.477 100 74 148 1 2022334384 19267184 21508032
23:37:02 14170 8192000000 10941651200 11369005056 1983083456 19.489 100 63 127 1 2023707856 21636960 18987440
23:37:22 2800 8192000000 10962136448 11375263744 1990959104 19.551 100 82 162 0 2041398976 25100816 25339056
23:37:32 5306 8192000000 10941298272 11370094592 1989307280 19.538 100 67 132 3 2033382608 23592048 20483280
23:37:46 9588 8192000000 10921615360 11357728768 1967060272 19.362 99 48 96 0 2003542640 22365024 14117344
23:38:03 2323 8192000000 10919487376 11342823424 1947824416 19.209 98 61 122 1 1988490016 22138992 18526608
23:38:12 6033 8192000000 10927861472 11354402816 1974686704 19.423 100 63 126 0 2014589648 21754192 18148752
23:38:26 2438 8192000000 10956735712 11372040192 1992493072 19.563 100 79 158 0 2040210032 24653136 23063824
23:38:39 4687 8192000000 10950397968 11371728896 1988255456 19.530 100 80 157 0 2037207568 25764224 23187888
23:38:59 4312 8192000000 10951040144 11381813248 1993194464 19.569 100 61 122 0 2038817104 27322896 18299744
23:39:18 6945 8192000000 10959108176 11391197184 1999282736 19.617 100 56 110 0 2046733168 30577952 16872480
23:39:32 2498 8192000000 10963340368 11390459904 2002240048 19.640 100 68 134 2 2054752960 31142240 21370672
23:39:41 5727 8192000000 10970343888 11394662400 2000886320 19.630 100 63 125 2 2050607264 30783232 18937712
23:39:56 4426 8192000000 10962898368 11396411392 2000689184 19.628 100 61 122 2 2052288656 33286928 18312544
23:40:09 3289 8192000000 10961143328 11387183104 1993912032 19.575 100 62 122 0 2046622128 33813808 18896288
23:40:19 5679 8192000000 10951271104 11377074176 1959366384 19.301 98 66 132 3 2014199520 34184960 20648176
23:40:32 3626 8192000000 10978895872 11399864320 2000595152 19.627 100 72 144 0 2059930064 37067712 22267200
23:40:46 7226 8192000000 10972200640 11400241152 2001086496 19.631 100 65 130 0 2058473424 37499744 19887184
23:41:04 2480 8192000000 10969542192 11392086016 1983468960 19.492 99 84 169 2 2046981840 38051920 25460960
23:41:15 14751 8192000000 10968679168 11391266816 1958789600 19.296 98 74 147 0 2020325248 40056016 21479632
23:41:44 4576 8192000000 10981837792 11399786496 1998413888 19.610 100 77 151 1 2061917360 40043504 23459968
23:41:56 3030 8192000000 10958851088 11383975936 1972783216 19.408 99 84 168 1 2038550352 40793552 24973584
23:42:07 8707 8192000000 10967752352 11393687552 1992884560 19.567 100 72 144 0 2054583664 39551440 22147664
23:42:26 3975 8192000000 10985814608 11410620416 2000801648 19.629 100 66 131 1 2064603136 43126800 20674688
23:42:37 4889 8192000000 10977814592 11402153984 1969389152 19.381 98 76 152 2 2040522816 47965760 23167904
23:42:52 4271 8192000000 10978440048 11406262272 1996590112 19.596 100 73 144 4 2064020336 44028592 23401632
23:43:06 3103 8192000000 10975572112 11396116480 1968256256 19.372 98 81 161 1 2032775424 39033264 25485904
23:43:18 4616 8192000000 10950579600 11373068288 1971224000 19.395 100 70 140 1 2034501904 40890208 22387696
23:43:30 4153 8192000000 10951958048 11374612480 1958568032 19.295 99 61 119 4 2018943472 41364192 19011248
23:43:42 3601 8192000000 10974477360 11388321792 1985111824 19.505 100 86 172 0 2051680544 39924240 26644480
23:43:55 4940 8192000000 10951565360 11381538816 1966066896 19.354 99 71 143 1 2029004192 40867456 22069840
23:44:10 1401 8192000000 10976636240 11387244544 1981657120 19.478 100 86 174 0 2050118816 41773296 26688400
23:44:19 3394 8192000000 10976200384 11398422528 1991460448 19.555 100 82 159 2 2058930544 42643904 24826192
23:44:31 2034 8192000000 10989028544 11402346496 1998076192 19.608 100 93 186 1 2068669824 42652576 27941056
23:44:40 2109 8192000000 10993178880 11406336000 1999570496 19.619 100 89 180 1 2072417888 45947504 26899888
23:44:48 3607 8192000000 10980760464 11406385152 1997434544 19.602 100 76 152 1 2066700928 46158176 23108208
23:45:07 3214 8192000000 10966946576 11401408512 1978763664 19.455 99 60 118 0 2043341360 45450688 19127008
23:45:23 3968 8192000000 10949173264 11372642304 1945423136 19.190 98 61 123 0 2009360640 44628064 19309440
23:45:36 3032 8192000000 10976664528 11395067904 1984566416 19.501 100 88 175 0 2059009120 46847296 27595408
23:45:46 10421 8192000000 10971190272 11393175552 1986803824 19.519 100 64 128 0 2045732544 39639776 19288944
23:46:03 11069 8192000000 10938203920 11381088256 1957615888 19.287 99 43 84 1 2014259264 42766240 13877136
23:46:39 15624 8192000000 10910342032 11369123840 1949623568 19.223 99 37 74 1 2003384000 42001760 11758672
23:47:01 11626 8192000000 10924805184 11367325696 1944451312 19.182 99 33 66 0 1990532896 35459568 10622016
23:47:23 10986 8192000000 10944503664 11380101120 1975775344 19.431 100 50 99 0 2029495760 38574320 15146096
23:47:46 10306 8192000000 10909744816 11349516288 1908228304 18.892 97 45 91 0 1964220832 41619584 14372944
23:48:12 14215 8192000000 10913229200 11341324288 1907262384 18.885 98 41 81 0 1963890944 42964592 13663968
23:48:42 26693 8192000000 10932742208 11371716608 1946985088 19.202 100 40 80 0 2010738176 50410992 13342096
23:49:28 3324 8192000000 10888689840 11318231040 1911865584 18.922 100 47 96 0 1977770960 50505200 15400176
23:49:40 21677 8192000000 10902908240 11333091328 1877110368 18.642 97 35 70 1 1942532144 53492688 11929088
23:50:08 13270 8192000000 10892947392 11330150400 1888619520 18.735 98 40 80 3 1955469856 53908624 12941712
23:50:32 14769 8192000000 10904908256 11341778944 1925855824 19.034 100 30 59 1 1984714016 48580240 10277952
23:50:53 29651 8192000000 10918827440 11355054080 1942073312 19.163 100 34 68 2 2006377104 52284032 12019760
23:51:30 22307 8192000000 10914966864 11357552640 1922938000 19.010 99 27 53 2 1976280736 44301520 9041216
23:52:10 35108 8192000000 10900266848 11340046336 1912242112 18.925 99 23 47 0 1962757984 42536368 7979504
23:52:58 23229 8192000000 10891980032 11342393344 1898925392 18.818 98 23 46 0 1950871312 43884048 8061872
23:53:50 20609 8192000000 10910968000 11361034240 1932550832 19.087 100 20 40 1 1986643712 46609808 7483072
23:54:17 34080 8192000000 10888841840 11350564864 1931268032 19.077 100 19 38 1 1979247040 41236368 6742640
23:55:25 14982 8192000000 10889546784 11336413184 1926048544 19.035 100 26 52 0 1971962032 36645504 9267984
23:55:46 41639 8192000000 10876496480 11348545536 1936306448 19.117 100 11 22 1 1967127072 26659728 4160896
23:56:34 145835 8192000000 10881025344 11310456832 1868936496 18.576 96 26 53 1 1886351856 9850640 7564720
23:59:11 47170 8192000000 10877921744 11336155136 1913569344 18.935 98 30 59 1 1933027008 10694720 8762944
00:00:17 51560 8192000000 10884930864 11341484032 1952125200 19.243 100 33 66 0 1970302224 8840544 9336480
00:01:18 76275 8192000000 10901309600 11348885504 1943735072 19.177 99 22 44 0 1961249312 11722624 5791616
00:02:51 37802 8192000000 10894501472 11350630400 1944871392 19.186 99 29 59 1 1964765904 11814016 8080496
00:03:40 31454 8192000000 10877515456 11358715904 1941212128 19.156 99 15 30 2 1961239728 15903408 4124192
00:04:17 15842 8192000000 10886567424 11362021376 1961527904 19.318 100 16 30 2 1980698912 14334304 4836704
00:04:41 220711 8192000000 10877277248 11349590016 1871350608 18.595 95 11 20 3 1887454480 13269296 2834576
00:08:27 143210 8192000000 10888105056 11366965248 1953184112 19.252 100 21 43 0 1970734016 11899200 5650704
00:10:59 10050 8192000000 10903965728 11347927040 1948277120 19.213 99 39 80 3 1966678992 7192112 11209760
00:11:16 23790 8192000000 10898044464 11364950016 1976948736 19.441 100 35 71 1 2000935936 13563664 10423536
00:11:59 63216 8192000000 10922757776 11378810880 1974638848 19.422 100 20 40 0 1991018896 10126480 6253568
00:13:08 69700 8192000000 10902059440 11382517760 1979173056 19.458 100 17 33 1 1996902528 12230096 5499376
00:14:49 79745 8192000000 10893070400 11366363136 1960383312 19.309 99 21 42 3 1974819600 8851136 5585152
00:16:24 32848 8192000000 10895626512 11374505984 1963005152 19.330 99 23 46 3 1986185936 16539200 6641584
00:17:04 73929 8192000000 10894894768 11376422912 1981542288 19.477 100 16 32 0 1994852032 8808304 4501440
00:18:53 54828 8192000000 10883599152 11373010944 1979403840 19.460 100 17 34 0 1995962560 11754528 4804192
00:20:00 47517 8192000000 10899785888 11380379648 1983774608 19.495 100 10 20 0 1994802576 8050544 2977424
00:20:54 60898 8192000000 10895380608 11384655872 1964496336 19.342 99 9 18 0 1977184976 10019216 2669424
00:22:17 36679 8192000000 10916020720 11387826176 1972352208 19.404 99 18 36 0 1993227520 14855680 6019632
00:23:10 48063 8192000000 10891654448 11366518784 1927575872 19.047 97 21 41 1 1950874048 17386720 5911456
00:24:05 39285 8192000000 10886199408 11372847104 1935902400 19.114 98 12 24 0 1956440480 17167360 3370720
00:24:51 42282 8192000000 10890738672 11358687232 1909985024 18.907 97 11 22 1 1925031168 11958640 3087504
00:25:44 30579 8192000000 10899088224 11365675008 1967792624 19.368 100 28 56 3 1989563024 14053568 7716832
00:26:31 82885 8192000000 10910019248 11382968320 1940346752 19.150 98 18 36 0 1969572592 23553088 5672752
00:28:02 80471 8192000000 10897526752 11377262592 1940784464 19.153 98 15 30 0 1970954320 26236016 3933840
00:29:29 68124 8192000000 10891837024 11361808384 1911834848 18.921 97 15 30 0 1928733264 12903936 3994480
00:30:44 68818 8192000000 10887384480 11359285248 1916211632 18.956 98 12 23 0 1935690544 16612800 2866112
00:31:59 48573 8192000000 10887434592 11361406976 1925757216 19.033 98 15 30 0 1946790704 16866240 4167248
00:32:55 69963 8192000000 10895898928 11362635776 1909201888 18.900 97 34 67 2 1929991824 11058352 9731584
00:34:13 54155 8192000000 10903397968 11366166528 1935005696 19.107 98 29 58 0 1953857232 10825488 8026048
00:35:18 11002 8192000000 10921195664 11364880384 1970920784 19.393 100 57 115 3 1996888384 9645584 16322016
00:35:44 100081 8192000000 10888140528 11368824832 1954594624 19.263 99 37 73 2 1977181440 11292768 11294048
00:37:37 47634 8192000000 10868715424 11334344704 1906338080 18.877 97 25 51 2 1920511680 6835920 7337680
00:38:36 50329 8192000000 10872483088 11334803456 1911895920 18.922 98 19 38 1 1924833680 7735520 5202240
00:39:34 40959 8192000000 10876403376 11356999680 1957220384 19.284 100 16 32 0 1971155680 9615344 4319952
00:40:24 48630 8192000000 10875423792 11351158784 1950619184 19.231 99 14 28 0 1962616720 7978304 4019232
00:41:47 81774 8192000000 10841612528 11312357376 1857059360 18.479 95 26 53 2 1873644928 8630032 7955536
00:43:15 101118 8192000000 10853530784 11321757696 1861256272 18.513 96 8 16 0 1877839728 14310608 2272848
00:45:13 69060 8192000000 10841740848 11308535808 1841775616 18.355 95 14 26 1 1862518528 16767712 3975200
00:46:53 90205 8192000000 10851262928 11297718272 1833989424 18.292 95 24 48 0 1851807632 10883072 6935136
00:48:31 107488 8192000000 10869999936 11332235264 1865667008 18.549 96 14 28 0 1885879664 16344816 3867840
00:50:25 46764 8192000000 10871355760 11330199552 1922604672 19.008 99 32 64 3 1944202672 12456720 9141280
00:51:20 45404 8192000000 10876073392 11335090176 1925229568 19.029 99 24 47 1 1946942496 14749872 6963056
00:52:15 107706 8192000000 10895560864 11354378240 1940478512 19.151 99 21 44 0 1965645856 19306976 5860368
00:54:14 67229 8192000000 10903805248 11372089344 1948229056 19.212 99 32 64 2 1970765616 13432960 9103600
00:55:32 47626 8192000000 10886162224 11349450752 1913115248 18.932 97 39 76 0 1934749504 10563008 11071248
00:56:27 110324 8192000000 10894803840 11359145984 1945422064 19.190 99 22 44 0 1961420352 9722464 6275824
00:58:23 88252 8192000000 10897367872 11356221440 1933874176 19.098 98 39 74 3 1952001344 7013520 11113648
00:59:58 46477 8192000000 10868565824 11349323776 1931656448 19.080 98 26 52 2 1947697136 8701600 7339088
01:00:53 51117 8192000000 10892418096 11365257216 1949432672 19.222 99 12 24 0 1962045232 9517600 3094960
01:02:07 68736 8192000000 10892582064 11367137280 1955461504 19.270 99 16 32 1 1970500128 10956096 4082528
01:03:22 57839 8192000000 10885240656 11374723072 1950816064 19.233 99 6 12 0 1963230368 11193072 1221232
01:04:26 38332 8192000000 10899103600 11377037312 1977841152 19.448 100 15 30 0 1989758928 7766144 4151632
01:05:18 54437 8192000000 10913060512 11381678080 1980756128 19.471 100 16 30 2 1995414048 10532880 4125040
01:06:20 41715 8192000000 10911374176 11385466880 1978944784 19.456 99 50 99 2 2006387440 13337920 14104736
01:07:08 52848 8192000000 10917722176 11386380288 1968881584 19.377 99 13 26 1 1981644464 9388912 3373968
01:08:12 47623 8192000000 10894880320 11368935424 1908082656 18.891 96 16 32 1 1924305648 11192256 5030736
01:09:16 121694 8192000000 10903171456 11387609088 1913969760 18.939 97 11 22 0 1931773424 15169600 2634064
01:11:26 34511 8192000000 10914297184 11371753472 1960755808 19.312 99 25 50 0 1975015728 7759824 6500096
01:12:08 65877 8192000000 10866740752 11340439552 1884340000 18.700 96 23 46 1 1900242016 9331168 6570848
01:13:21 46130 8192000000 10896799392 11351523328 1927910864 19.050 98 33 66 2 1948044208 10209008 9924336
01:14:16 50284 8192000000 10921608528 11373092864 1948719056 19.216 99 31 62 0 1967093600 9949824 8424720
01:15:13 54180 8192000000 10901151968 11370024960 1948446704 19.214 99 34 68 1 1969922736 11921936 9554096
01:16:19 160128 8192000000 10911791424 11370831872 1896229648 18.796 96 8 16 0 1911435072 13269008 1936416
01:19:13 93040 8192000000 10879843744 11346939904 1888183248 18.731 96 30 60 1 1911964160 14756864 9024048
01:20:53 34781 8192000000 10857831296 11347529728 1927856864 19.050 99 27 53 1 1948901856 13783088 7261904
01:21:35 37006 8192000000 10848169168 11328688128 1905444816 18.870 98 10 20 0 1917259872 8814272 3000784
01:22:24 71663 8192000000 10874356864 11354685440 1948204480 19.212 100 9 18 1 1959813344 9385424 2223440
01:23:43 60002 8192000000 10849256768 11326767104 1878719312 18.655 96 5 10 0 1889813472 9818336 1275824
01:24:51 72722 8192000000 10860295952 11342839808 1944668096 19.184 100 20 40 0 1957385008 7102128 5614784
01:26:32 60937 8192000000 10863683456 11338031104 1863939104 18.535 95 19 38 0 1879990304 11218032 4833168

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:29, from 14-06-2021 01:29:16 to 14-06-2021 01:29:45.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 115 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 14-06-2021 01:29:46 to 14-06-2021 01:29:48.

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          235328
MON$OLDEST_ACTIVE               235706
MON$OLDEST_SNAPSHOT             235706
MON$NEXT_TRANSACTION            235706
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                       2015936
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.33473 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33473 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33473 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33473 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 ---
:121: 
:122: mscs-test-161.budzdorov.ru    Mon Jun 14 01:27:47 2021
:123:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:124: 
:125: 
:126: mscs-test-161.budzdorov.ru    Mon Jun 14 01:27:51 2021
:127:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:128: 
--- end of diff output ---

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

14.06.21 01:29:49. 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-06-14 01:29:51 No severe PSQL-related problems occured
14.06.21 01:29:53. End of report.