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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-25 22:27:04
DTS_END                         2020-11-25 22:27:04.8840
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/54432
TRN_ID                          233948
ATT_ID                          648
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: 9145.80 25164 1097496
customer order: creation 159.26 362 19111
customer order: refuse 13.94 329 1673
order to supplier: creation 42.78 1289 5133
order to supplier: removal 3.48 97289 418
invoice (draft): creation 43.27 3517 5192
invoice (draft): removal 53.89 723 6467
invoice accept: apply 39.72 17688 4766
invoice accept: cancel 48.72 733 5846
customer reserve: creation 3670.91 174 440509
customer reserve: removal 4790.33 56 574839
realization accept: apply 78.62 184 9434
realization accept: cancel 81.59 111 9791
payment from customer: creation 54.20 113 6504
payment from customer: removal 5.18 80 622
payment to supplier: creation 45.42 131 5450
payment to supplier: removal 3.23 78 387
service: total inventory turnovers 4.37 1121 524
service: total monetary turnovers 6.08 22 730
service: aggregate perf. data 0.80 20663 96
service: refresh index statistics 0.03 358620 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 25-11-2020 22:28:33 to 25-11-2020 22:28:35.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 10244
TEST_TIME 2 8469
TEST_TIME 3 7145
TEST_TIME 4 6330
TEST_TIME 5 6361
TEST_TIME 6 6290
TEST_TIME 7 6616
TEST_TIME 8 6516
TEST_TIME 9 6234
TEST_TIME 10 6760
TEST_TIME 11 6639
TEST_TIME 12 6634
TEST_TIME 13 6581
TEST_TIME 14 6947
TEST_TIME 15 7082
TEST_TIME 16 7361
TEST_TIME 17 7798
TEST_TIME 18 8080
TEST_TIME 19 8384
TEST_TIME 20 8565
TEST_TIME 21 8578
TEST_TIME 22 8612
TEST_TIME 23 8897
TEST_TIME 24 9227
TEST_TIME 25 9470
TEST_TIME 26 10338
TEST_TIME 27 11119
TEST_TIME 28 11046
TEST_TIME 29 11102
TEST_TIME 30 11140
TEST_TIME 31 10924
TEST_TIME 32 10732
TEST_TIME 33 10503
TEST_TIME 34 10375
TEST_TIME 35 10427
TEST_TIME 36 10241
TEST_TIME 37 10216
TEST_TIME 38 10176
TEST_TIME 39 10097
TEST_TIME 40 9989
TEST_TIME 41 9868
TEST_TIME 42 9696
TEST_TIME 43 9721
TEST_TIME 44 9616
TEST_TIME 45 9509
TEST_TIME 46 9437
TEST_TIME 47 9413
TEST_TIME 48 9293
TEST_TIME 49 9348
TEST_TIME 50 9309
TEST_TIME 51 9249
TEST_TIME 52 9207
TEST_TIME 53 9341
TEST_TIME 54 9293
TEST_TIME 55 9308
TEST_TIME 56 9403
TEST_TIME 57 9414
TEST_TIME 58 9450
TEST_TIME 59 9478
TEST_TIME 60 9602
TEST_TIME 61 9656
TEST_TIME 62 9702
TEST_TIME 63 9667
TEST_TIME 64 9712
TEST_TIME 65 9658
TEST_TIME 66 9599
TEST_TIME 67 9547
TEST_TIME 68 9510
TEST_TIME 69 9423
TEST_TIME 70 9463
TEST_TIME 71 9443
TEST_TIME 72 9374
TEST_TIME 73 9391
TEST_TIME 74 9381
TEST_TIME 75 9323
TEST_TIME 76 9287
TEST_TIME 77 9283
TEST_TIME 78 9305
TEST_TIME 79 9393
TEST_TIME 80 9424
TEST_TIME 81 9437
TEST_TIME 82 9441
TEST_TIME 83 9446
TEST_TIME 84 9514
TEST_TIME 85 9511
TEST_TIME 86 9507
TEST_TIME 87 9475
TEST_TIME 88 9383
TEST_TIME 89 9362
TEST_TIME 90 9347
TEST_TIME 91 9314
TEST_TIME 92 9249
TEST_TIME 93 9239
TEST_TIME 94 9271
TEST_TIME 95 9270
TEST_TIME 96 9293
TEST_TIME 97 9275
TEST_TIME 98 9318
TEST_TIME 99 9331
TEST_TIME 100 9336
TEST_TIME 101 9398
TEST_TIME 102 9424
TEST_TIME 103 9410
TEST_TIME 104 9484
TEST_TIME 105 9449
TEST_TIME 106 9464
TEST_TIME 107 9504
TEST_TIME 108 9495
TEST_TIME 109 9421
TEST_TIME 110 9399
TEST_TIME 111 9425
TEST_TIME 112 9382
TEST_TIME 113 9378
TEST_TIME 114 9350
TEST_TIME 115 9325
TEST_TIME 116 9288
TEST_TIME 117 9225
TEST_TIME 118 9244
TEST_TIME 119 9221
TEST_TIME 120 9152

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 25-11-2020 22:28:37 to 25-11-2020 22:28:40.

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 1506669 1506669 0 0.00 0 16324 6 0 0
doc_list_biud 1506667 1506667 0 0.00 0 23888 27 0 0
sp_add_invoice_to_stock 4871 4766 105 2.15 30 198961 17689 0 105
sp_cancel_adding_invoice 5846 5846 0 0.00 4 62808 734 0 0
sp_cancel_client_order 1673 1673 0 0.00 4 10456 330 0 0
sp_cancel_customer_reserve 574839 574839 0 0.00 1 23829 56 0 0
sp_cancel_pay_from_customer 622 622 0 0.00 3 4329 81 0 0
sp_cancel_pay_to_supplier 387 387 0 0.00 3 5600 79 0 0
sp_cancel_supplier_invoice 6478 6467 11 0.16 1 21840 724 0 11
sp_cancel_supplier_order 418 418 0 0.00 9 1021653 97289 0 0
sp_cancel_write_off 9791 9791 0 0.00 1 10413 111 0 0
sp_client_order 19111 19111 0 0.00 4 21708 362 0 0
sp_customer_reserve 440509 440509 0 0.00 0 43051 174 0 0
sp_fill_shopping_cart 29420 29420 0 0.00 1 15518 41 0 0
sp_fill_shopping_cart_clo_res 440497 440497 0 0.00 0 25875 14 0 0
sp_get_clo_for_invoice 4754 4754 0 0.00 0 27875 338 0 0
sp_kill_cost_storno 16646 16646 0 0.00 0 15545 57 0 0
sp_kill_qstorno_ret_qs2qd 1166354 1166354 0 0.00 0 23886 30 0 0
sp_kill_qty_storno 613222 613222 0 0.00 0 23887 65 0 0
sp_lock_selected_doc 19607 19607 0 0.00 0 10377 6 0 0
sp_make_cost_storno 26142 26142 0 0.00 0 16321 57 0 0
sp_multiply_rows_for_pdistr 26142 26142 0 0.00 0 8435 26 0 0
sp_multiply_rows_for_qdistr 19111 19111 0 0.00 0 20932 161 0 0
sp_pay_from_customer 6504 6504 0 0.00 4 17191 113 0 0
sp_pay_to_supplier 5450 5450 0 0.00 4 14273 131 0 0
sp_payment_common 11954 11954 0 0.00 1 17171 32 0 0
sp_qd_handle_on_cancel_clo 1673 1673 0 0.00 0 10450 307 0 0
sp_qd_handle_on_invoice_upd_sts 10600 10600 0 0.00 0 14069 294 0 0
sp_qd_handle_on_reserve_upd_sts 9434 9434 0 0.00 0 17628 66 0 0
sp_reserve_write_off 9434 9434 0 0.00 6 17639 184 0 0
sp_supplier_invoice 5192 5192 0 0.00 6 89126 3518 0 0
sp_supplier_order 5133 5133 0 0.00 4 41255 1289 0 0
srv_aggregate_perf_data 97 96 1 1.03 2552 163539 20663 0 1
srv_fill_mon_cache_memory 154 154 0 0.00 1434 124807 35404 0 0
srv_find_qd_qs_mism 1053476 1053476 0 0.00 0 13160 5 0 0
srv_make_invnt_saldo 524 524 0 0.00 47 64756 1121 0 0
srv_make_money_saldo 730 730 0 0.00 0 1270 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 69936 625024 358620 0 0
t$perf-abend:sp_add_invoice_to_stock 105 105 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 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 4766 4766 0 0.00 0 14343 154 0 0
t$perf-norm:sp_cancel_adding_invoice 401 401 0 0.00 1 6485 106 0 0
t$perf-norm:sp_cancel_client_order 1673 1673 0 0.00 0 4015 15 0 0
t$perf-norm:sp_cancel_customer_reserve 604 604 0 0.00 0 676 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 622 622 0 0.00 0 1478 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 387 387 0 0.00 0 271 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 387 387 0 0.00 0 1827 19 0 0
t$perf-norm:sp_cancel_supplier_order 418 418 0 0.00 0 22817 1488 0 0
t$perf-norm:sp_cancel_write_off 928 928 0 0.00 0 9201 20 0 0
t$perf-norm:sp_client_order 19111 19111 0 0.00 0 7913 18 0 0
t$perf-norm:sp_customer_reserve 920 920 0 0.00 0 3585 7 0 0
t$perf-norm:sp_pay_from_customer 6504 6504 0 0.00 0 5475 10 0 0
t$perf-norm:sp_pay_to_supplier 5450 5450 0 0.00 0 4193 10 0 0
t$perf-norm:sp_reserve_write_off 9434 9434 0 0.00 0 9585 16 0 0
t$perf-norm:sp_supplier_invoice 5192 5192 0 0.00 0 7046 22 0 0
t$perf-norm:sp_supplier_order 5133 5133 0 0.00 0 8225 19 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 168 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 154 154 0 0.00 0 368 7 0 0
t$perf-norm:srv_make_invnt_saldo 524 524 0 0.00 0 6479 31 0 0
t$perf-norm:srv_make_money_saldo 730 730 0 0.00 0 4266 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 9716 9506 210 2.16 0 8023 20 0 210
v_all_customers 35020 35020 0 0.00 0 17 1 0 0
v_all_suppliers 28690 28690 0 0.00 0 14 1 0 0
v_all_wares 38220 38220 0 0.00 0 74 1 0 0
v_cancel_adding_invoice 802 802 0 0.00 0 5103 13 0 0
v_cancel_client_order 3346 3346 0 0.00 0 804 3 0 0
v_cancel_customer_prepayment 1244 1244 0 0.00 0 4278 7 0 0
v_cancel_customer_reserve 1208 1208 0 0.00 0 3071 10 0 0
v_cancel_payment_to_supplier 774 774 0 0.00 0 2252 7 0 0
v_cancel_supplier_invoice 796 774 22 2.76 0 3896 20 0 22
v_cancel_supplier_order 836 836 0 0.00 0 2239 6 0 0
v_cancel_write_off 1856 1856 0 0.00 0 4921 13 0 0
v_max_id_clo_ord 5133 5133 0 0.00 0 604 1 0 0
v_max_id_clo_res 920 920 0 0.00 0 1331 9 0 0
v_max_id_ord_sup 5176 5176 0 0.00 0 5488 6 0 0
v_max_non_paid_invoice 1414 1414 0 0.00 0 691 3 0 0
v_max_non_paid_realizn 3333 3333 0 0.00 0 2524 4 0 0
v_min_id_clo_ord 5133 5133 0 0.00 0 10007 15 0 0
v_min_id_clo_res 920 920 0 0.00 0 1498 4 0 0
v_min_id_ord_sup 5176 5176 0 0.00 0 7226 10 0 0
v_min_non_paid_invoice 5450 5450 0 0.00 0 4372 19 0 0
v_min_non_paid_realizn 6504 6504 0 0.00 0 6884 21 0 0
v_our_firm 9542 9542 0 0.00 0 17 1 0 0
v_reserve_write_off 18868 18868 0 0.00 0 4549 6 0 0
x_lock_depdocs_on_canc_invoice 11926 11926 0 0.00 0 23735 119 0 0
x_lock_depdocs_on_canc_sup_ord 418 418 0 0.00 0 19840 427 0 0
x_make_qstorno_1000_1200 5133 5133 0 0.00 1 41247 1204 0 0
x_make_qstorno_1200_2000 5192 5192 0 0.00 3 80565 3374 0 0
x_make_qstorno_2100_3300 440509 440509 0 0.00 0 43050 158 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 25-11-2020 22:28:41 to 25-11-2020 22:28:45.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:08 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:14 16586 8192000000 10230073568 10535976960 793870336 8.834 63 49 99 0 812742128 2231936 16639856
19:57:42 27025 8192000000 10327542864 10643230720 1371211056 14.338 100 80 160 0 1401651568 4423776 26016736
19:58:21 15698 8192000000 10358804160 10681548800 1413095552 14.711 100 86 172 0 1451741024 10596160 28049312
19:58:51 18894 8192000000 10395132464 10722197504 1444086208 14.986 100 81 163 1 1477673552 7185424 26401920
19:59:24 21646 8192000000 10412846880 10742476800 1468449024 15.200 100 84 166 1 1503299696 8187776 26662896
19:59:58 22885 8192000000 10456229600 10791407616 1500658336 15.482 100 84 169 0 1536483696 9028720 26796640
20:00:34 28291 8192000000 10482448592 10825674752 1534553648 15.776 100 89 178 0 1572760528 10336144 27870736
20:01:21 20993 8192000000 10513621104 10861862912 1562617344 16.019 100 84 168 1 1599228688 11162368 25448976
20:01:50 18663 8192000000 10538611664 10890665984 1588604496 16.242 100 83 166 3 1624983152 11433568 24945088
20:02:20 11733 8192000000 10553605216 10911916032 1616774192 16.482 100 83 165 1 1653128320 11594608 24759520
20:02:41 10644 8192000000 10577438032 10937479168 1633524240 16.625 100 83 166 2 1670488768 11427024 25537504
20:03:00 14514 8192000000 10599296576 10963226624 1651354944 16.776 100 82 164 0 1687955952 12408064 24192944
20:03:23 9900 8192000000 10620835088 10988650496 1678922880 17.008 100 83 165 0 1715585200 12388192 24274128
20:03:40 10166 8192000000 10632640976 11003068416 1693747120 17.133 100 82 164 1 1730778464 12448576 24582768
20:03:57 9180 8192000000 10639798512 11012001792 1704033488 17.219 100 75 150 0 1737829056 12236064 21559504
20:04:16 5765 8192000000 10655512912 11026579456 1719538976 17.348 100 79 159 1 1755116784 13042576 22535232
20:04:29 5736 8192000000 10671978880 11046817792 1730278960 17.438 100 81 162 0 1767330784 13134160 23917664
20:04:43 5280 8192000000 10676438832 11053932544 1744482256 17.556 100 83 165 0 1781259536 13994496 22782784
20:05:00 5183 8192000000 10698450688 11077984256 1759394592 17.679 100 85 170 1 1796526480 13081200 24050688
20:05:13 4070 8192000000 10706977792 11085697024 1771605728 17.780 100 79 158 0 1806270832 12493616 22171488
20:05:24 4001 8192000000 10716372688 11098308608 1777548432 17.829 100 80 160 1 1813910096 13005424 23356240
20:05:35 2984 8192000000 10721507520 11103195136 1788041136 17.916 100 83 166 1 1823504080 12602384 22860560
20:05:45 2922 8192000000 10738787600 11116707840 1794889744 17.972 100 89 176 2 1832940864 13207280 24843840
20:05:55 1948 8192000000 10741965296 11122155520 1801487920 18.026 100 88 172 3 1838832720 13053552 24291248
20:06:03 2011 8192000000 10749396928 11129864192 1813863936 18.128 100 91 178 1 1852081696 13266256 24951504
20:06:12 7805 8192000000 10755505424 11138093056 1812716656 18.118 100 81 160 1 1849228960 13880304 22632000
20:06:26 4191 8192000000 10759513520 11149492224 1820389136 18.181 100 75 150 1 1853641408 12786080 20466192
20:06:37 1508 8192000000 10781351280 11166531584 1838272816 18.327 100 92 185 1 1877302848 13190768 25839264
20:06:45 1865 8192000000 10789130080 11173732352 1846611712 18.395 100 90 180 2 1885458528 13302176 25544640
20:06:53 1609 8192000000 10793077904 11176267776 1849314256 18.417 100 96 191 2 1889943072 14398976 26229840
20:07:02 2278 8192000000 10796147104 11182796800 1853418960 18.450 100 93 186 2 1893415072 13572288 26423824
20:07:10 1275 8192000000 10800512192 11186868224 1860318832 18.506 100 96 192 1 1900487136 12476096 27692208
20:07:18 1666 8192000000 10808047552 11194114048 1860975360 18.511 100 95 190 0 1901785808 12833312 27977136
20:07:26 1725 8192000000 10806503632 11197865984 1863093600 18.528 100 89 176 1 1902389792 13060128 26236064
20:07:33 2035 8192000000 10802861088 11194183680 1864056320 18.536 100 94 189 0 1903364624 12627216 26681088
20:07:42 2158 8192000000 10816657136 11202396160 1868383696 18.571 100 93 186 4 1907170048 12750128 26036224
20:07:50 1857 8192000000 10814589504 11202658304 1867167616 18.561 100 94 188 2 1908335424 13790400 27377408
20:07:58 1227 8192000000 10815857536 11205713920 1870675488 18.590 100 96 196 2 1911333152 13269008 27388656
20:08:05 1593 8192000000 10809242560 11203444736 1868295520 18.570 100 74 148 2 1901971232 12662976 21012736
20:08:13 4580 8192000000 10802315472 11211132928 1871143440 18.594 100 58 116 1 1898776656 11649840 15983376
20:08:31 38450 8192000000 10812447968 11215372288 1874710272 18.622 100 55 111 0 1899166224 6555472 17900480
20:09:15 26718 8192000000 10794752704 11214086144 1876988032 18.641 100 57 112 3 1902883008 9600400 16294576
20:09:52 12371 8192000000 10780775632 11211628544 1874318288 18.619 100 30 60 0 1889153824 5926528 8909008
20:10:15 4701 8192000000 10784266752 11212935168 1875077728 18.625 100 29 56 0 1890442784 7787296 7577760
20:10:26 5719 8192000000 10782138816 11216322560 1875923312 18.632 100 25 50 1 1889594688 6731664 6939712
20:10:38 3824 8192000000 10801579696 11225812992 1884672848 18.703 100 48 96 1 1905608064 7356880 13578336
20:10:52 6501 8192000000 10804244784 11229880320 1887311296 18.724 100 31 62 1 1902925232 6435456 9178480
20:11:08 4332 8192000000 10797980576 11230224384 1887421504 18.725 100 25 50 1 1901755136 7469168 6864464
20:11:19 4165 8192000000 10818481728 11235262464 1890356928 18.749 100 41 83 1 1908915728 6972624 11586176
20:11:30 7419 8192000000 10796067136 11226959872 1888284064 18.732 100 22 44 2 1900208688 5752096 6172528
20:11:45 8664 8192000000 10807975536 11237883904 1893538128 18.774 100 25 50 1 1911275200 10266576 7470496
20:12:01 11620 8192000000 10812184080 11240493056 1894294480 18.780 100 15 30 1 1904221632 5622960 4304192
20:12:20 15577 8192000000 10806263360 11240005632 1896494832 18.798 100 14 28 1 1905464336 5167664 3801840
20:12:43 6328 8192000000 10805312160 11242295296 1899254160 18.820 100 27 54 3 1913711376 7002720 7454496
20:13:02 8049 8192000000 10809934832 11242975232 1902881936 18.849 100 28 55 2 1917732352 7211312 7639104
20:13:17 7909 8192000000 10809307168 11244531712 1903413856 18.854 100 21 42 1 1915498400 6481936 5602608
20:13:32 10478 8192000000 10814110272 11246092288 1903960400 18.858 100 18 34 2 1914489168 5960144 4568624
20:13:49 16293 8192000000 10819733984 11250122752 1903355952 18.853 100 21 42 0 1915862736 6322608 6184176
20:14:11 60789 8192000000 10813619264 11252490240 1905867616 18.873 100 28 54 0 1918995232 5500704 7626912
20:15:18 7944 8192000000 10829281776 11258171392 1909616032 18.904 100 33 66 0 1924971392 5600224 9755136
20:15:34 7602 8192000000 10822404320 11251421184 1872476496 18.604 98 30 60 0 1887352464 7039232 7836736
20:15:49 3513 8192000000 10815853760 11250376704 1904884912 18.866 100 34 68 1 1921300320 6197584 10217824
20:16:00 3941 8192000000 10810081040 11228262400 1880868880 18.672 99 38 76 2 1898759056 6636352 11253824
20:16:11 4975 8192000000 10818201200 11239694336 1879338992 18.660 99 31 62 1 1898489920 9864368 9286560
20:16:23 5339 8192000000 10787741792 11216539648 1862895360 18.527 99 26 52 1 1876363904 5698992 7769552
20:16:35 3763 8192000000 10783609056 11212640256 1864256368 18.538 99 31 62 0 1879613360 6629184 8727808
20:16:45 4111 8192000000 10782955504 11209445376 1850072704 18.423 98 28 54 5 1867917408 10475184 7369520
20:16:55 5502 8192000000 10771472144 11199463424 1819821280 18.176 97 24 48 0 1832447984 5632992 6993712
20:17:08 5977 8192000000 10777790896 11206639616 1837949008 18.324 98 21 42 0 1850238544 5670288 6619248
20:17:20 5449 8192000000 10791730608 11219832832 1874091040 18.617 100 19 38 1 1885522352 6365872 5065440
20:17:32 8170 8192000000 10747644000 11166912512 1751137840 17.611 94 22 44 0 1763043040 5769312 6135888
20:17:47 5822 8192000000 10749742240 11180236800 1805731936 18.061 98 25 48 2 1818470224 5537712 7200576
20:18:02 8954 8192000000 10721193136 11139923968 1766161440 17.735 97 21 42 4 1781927296 9968560 5797296
20:18:17 10932 8192000000 10684255984 11094458368 1663780832 16.881 93 19 38 0 1674791616 4999888 6010896
20:18:37 66205 8192000000 10704018096 11132882944 1788306608 17.918 99 42 82 0 1806582176 5381040 12894528
20:19:56 10737 8192000000 10710945024 11120836608 1704689360 17.224 94 33 65 3 1719831216 6233248 8908608
20:20:14 3383 8192000000 10728214688 11144847360 1801776960 18.028 100 32 65 0 1818555808 7136608 9642240
20:20:26 5325 8192000000 10718211872 11132981248 1779502752 17.845 98 31 62 1 1794723264 5858528 9361984
20:20:39 5273 8192000000 10718731648 11136618496 1790307744 17.934 98 37 74 0 1806979648 5930368 10741536
20:20:51 7354 8192000000 10701441232 11121082368 1750362112 17.605 97 35 70 2 1771656720 11787584 9507024
20:21:07 5241 8192000000 10720844976 11139301376 1800263360 18.016 100 33 66 3 1816957360 6915040 9778960
20:21:18 8070 8192000000 10734710720 11155812352 1821575840 18.191 100 26 52 3 1834268992 5305200 7387952
20:21:36 4495 8192000000 10744057776 11158319104 1779055904 17.842 97 29 57 2 1797854672 10272928 8525840
20:21:51 4563 8192000000 10737992992 11164569600 1826387648 18.230 100 26 52 0 1844547104 11104608 7054848
20:22:02 10472 8192000000 10751363152 11175124992 1822200144 18.196 99 25 46 2 1834353888 5310496 6843248
20:22:19 17183 8192000000 10771887104 11184836608 1845388912 18.385 100 27 54 0 1859555824 5534784 8632128
20:22:42 9937 8192000000 10761954368 11182211072 1832162400 18.277 99 31 62 0 1846972736 5205552 9604784
20:23:01 13089 8192000000 10766283968 11182977024 1826250128 18.229 99 23 44 3 1837415536 4912272 6253136
20:23:30 63991 8192000000 10764884384 11191324672 1851554288 18.435 100 23 46 1 1864171008 5810944 6805776
20:24:40 7688 8192000000 10765793968 11196698624 1860744352 18.509 100 22 44 0 1872357568 5421648 6191568
20:24:57 6721 8192000000 10781076336 11202351104 1862892080 18.527 100 27 54 3 1884734912 14095920 7746912
20:25:11 5583 8192000000 10790840016 11209207808 1867034192 18.560 100 40 80 0 1885428720 6747728 11646800
20:25:23 5776 8192000000 10777425936 11209662464 1867639440 18.565 100 27 54 1 1881924272 5927296 8357536
20:25:37 3981 8192000000 10794852896 11213230080 1870454448 18.588 100 40 79 0 1889189920 7105376 11630096
20:25:50 5743 8192000000 10782119104 11214028800 1871269904 18.595 100 24 47 1 1883350432 5961600 6118928
20:26:04 6172 8192000000 10781786800 11217874944 1877059680 18.641 100 26 52 2 1890422768 5725168 7637920
20:26:16 9582 8192000000 10792538528 11221356544 1877920752 18.648 100 32 64 0 1894120736 6703616 9496368
20:26:33 6737 8192000000 10794591136 11223699456 1882356560 18.684 100 31 63 1 1897059424 5407248 9295616
20:26:47 9525 8192000000 10797353440 11230285824 1881157984 18.674 100 24 48 0 1894205408 5775616 7271808
20:27:04 14141 8192000000 10821265376 11247779840 1898738336 18.816 100 26 52 2 1911507920 4467600 8301984
20:27:25 16165 8192000000 10849835744 11269103616 1918424448 18.974 100 50 98 2 1940587200 7752288 14410464
20:27:48 2782 8192000000 10869187040 11283517440 1928143568 19.052 100 62 126 0 1954349248 8471776 17733904
20:27:59 5995 8192000000 10874706096 11288965120 1934832512 19.105 100 67 133 0 1964085440 9681200 19571728
20:28:14 80398 8192000000 10873113936 11293212672 1934123648 19.100 100 41 82 1 1953650960 7056160 12471152
20:30:05 8145 8192000000 10882828096 11315699712 1949096704 19.219 100 55 107 3 1978475792 13641920 15737168
20:30:27 11387 8192000000 10893477088 11317612544 1954883024 19.265 100 63 124 0 1983694768 10566832 18244912
20:30:46 7602 8192000000 10901555840 11328933888 1959887088 19.305 100 61 120 5 1991801136 13967072 17946976
20:31:00 4753 8192000000 10899986432 11331436544 1964650368 19.343 100 60 119 1 1996680288 14972544 17057376
20:31:14 8456 8192000000 10905872896 11337191424 1970671360 19.391 100 61 121 1 2002055584 14702560 16681664
20:31:39 23979 8192000000 10912070000 11340185600 1972328816 19.404 100 57 114 2 2005995008 16990272 16675920
20:32:10 13576 8192000000 10913496832 11343732736 1973019568 19.409 100 51 102 0 2004256784 16359744 14877472
20:32:33 5030 8192000000 10903314544 11328000000 1950249840 19.228 99 58 114 3 1984167232 16637296 17280096
20:32:44 6150 8192000000 10916694512 11341217792 1970239952 19.387 100 67 132 0 2008992256 19439744 19312560
20:32:59 11790 8192000000 10898108416 11335700480 1963941552 19.337 100 47 94 1 1998649360 20268576 14439232
20:33:18 14558 8192000000 10909753856 11339235328 1966568448 19.358 100 46 92 0 1996412976 16419200 13425328
20:33:44 4811 8192000000 10896282592 11321200640 1950688832 19.232 99 55 110 0 1986156752 17769344 17698576
20:34:00 5225 8192000000 10911180656 11333091328 1952292768 19.245 99 63 126 1 1989103664 18044784 18766112
20:34:15 21685 8192000000 10897176928 11333677056 1946366528 19.198 99 44 87 1 1976317296 16974480 12976288
20:34:47 11539 8192000000 10887300864 11321237504 1949215856 19.220 100 51 102 2 1982387120 18222944 14948320
20:35:19 15286 8192000000 10892574688 11330719744 1957088912 19.283 100 40 78 3 1985872464 17044448 11739104
20:35:51 11878 8192000000 10910978304 11353440256 1965355792 19.349 100 35 70 2 1998792336 22987872 10448672
20:36:10 26281 8192000000 10917327856 11355271168 1970741568 19.391 100 43 86 0 2008159056 24495696 12921792
20:36:44 20984 8192000000 10916900288 11349368832 1953779792 19.257 99 49 97 1 1994753536 26408752 14564992
20:37:16 14327 8192000000 10911709344 11348860928 1963389760 19.333 100 37 74 0 1998051440 22452368 12209312
20:37:48 4507 8192000000 10925092288 11360124928 1977118256 19.442 100 42 83 2 2017450224 26636880 13695088
20:38:00 5593 8192000000 10918857808 11349323776 1957836256 19.289 99 49 96 0 1993835952 21550880 14448816
20:38:15 10173 8192000000 10929593248 11359997952 1980515936 19.469 100 42 84 2 2014968160 22118160 12334064
20:38:33 6450 8192000000 10900882704 11323961344 1946481568 19.198 99 56 112 0 1986811824 23009536 17320720
20:38:48 3255 8192000000 10922420880 11344621568 1952715520 19.248 99 69 133 2 1996395056 23903376 19776160
20:38:59 4695 8192000000 10924902448 11334242304 1948679376 19.216 99 78 151 0 1997473168 24477664 24316128
20:39:12 14578 8192000000 10925163984 11345952768 1953486544 19.254 99 74 148 2 2001804000 26709344 21608112
20:39:36 3178 8192000000 10954846160 11365957632 1975134016 19.426 100 85 171 0 2030914352 30106576 25673760
20:39:46 3657 8192000000 10929325088 11341283328 1959838336 19.305 99 71 142 3 2013139072 31325552 21975184
20:39:57 2079 8192000000 10946212432 11361742848 1980832768 19.471 100 73 147 1 2031027248 29113472 21081008
20:40:07 1711 8192000000 10950428320 11372257280 1989442064 19.539 100 78 153 0 2042787888 30047664 23298160
20:40:16 5581 8192000000 10947218768 11372257280 1984841392 19.503 100 70 140 0 2037691856 31813312 21037152
20:40:41 4564 8192000000 10938662832 11362291712 1976118096 19.434 100 67 135 1 2031210752 34541248 20551408
20:40:53 3549 8192000000 10964177616 11389075456 1993769984 19.574 100 74 148 0 2056896880 40865408 22261488
20:41:08 5551 8192000000 10959116224 11386425344 1991455840 19.555 100 65 131 0 2049787504 37393920 20937744
20:41:22 6004 8192000000 10950497856 11375104000 1974939616 19.425 99 72 142 0 2030438960 32937360 22561984
20:41:39 4272 8192000000 10972283488 11392487424 1991968640 19.559 100 65 129 0 2053220784 40901712 20350432
20:41:51 1864 8192000000 10970525792 11389870080 1978422544 19.452 99 79 156 0 2044932352 42229488 24280320
20:42:01 2338 8192000000 10970613680 11385614336 1989278880 19.538 100 88 177 2 2054418016 37599664 27539472
20:42:10 2315 8192000000 10977016672 11394646016 1996771584 19.597 100 85 169 0 2064031712 40078960 27181168
20:42:21 4117 8192000000 10987029504 11399225344 1997256960 19.601 100 86 169 1 2064627344 40737424 26632960
20:42:34 6927 8192000000 10975549248 11396329472 1981015024 19.473 99 69 136 1 2042952304 40968368 20968912
20:42:47 5139 8192000000 10938684544 11371061248 1964216288 19.340 99 74 148 1 2028577264 41384416 22976560
20:43:01 3866 8192000000 10957187872 11375542272 1965203168 19.347 99 75 150 0 2030500352 41832832 23464352
20:43:12 2227 8192000000 10950572384 11365838848 1960314896 19.309 99 76 150 2 2027157376 43363424 23479056
20:43:26 2204 8192000000 10942111552 11353931776 1945914096 19.194 99 90 181 1 2018939344 44835856 28189392
20:43:37 3069 8192000000 10936664512 11346051072 1945141600 19.188 99 79 156 0 2011406896 41808096 24457200
20:43:51 3359 8192000000 10947406208 11364380672 1963607200 19.335 100 78 154 1 2031995584 44447344 23941040
20:44:04 2868 8192000000 10962617728 11378069504 1973185808 19.411 100 73 146 0 2043075152 47172304 22717040
20:44:16 2108 8192000000 10967318576 11386376192 1981673248 19.478 100 73 144 0 2050389168 45628160 23087760
20:44:27 1431 8192000000 10967344544 11371532288 1970059008 19.386 100 87 174 0 2044846384 46237232 28550144
20:44:36 2403 8192000000 10958691456 11370418176 1975355488 19.428 100 85 167 2 2045248512 44188592 25704432
20:44:48 1791 8192000000 10951301952 11365986304 1969528480 19.382 100 87 173 2 2038667216 41628144 27510592
20:44:58 2051 8192000000 10970241584 11380867072 1979050224 19.457 100 86 170 2 2048583536 43874272 25659040
20:45:07 2919 8192000000 10964895360 11382366208 1959587376 19.303 99 76 153 0 2028727200 44967552 24172272
20:45:22 6889 8192000000 10950122912 11384016896 1969413648 19.381 100 49 97 1 2033787520 48283216 16090656
20:45:44 6306 8192000000 10956008304 11388424192 1977804016 19.447 100 47 92 1 2039969488 46863088 15302384
20:45:59 3958 8192000000 10964812720 11392729088 1980724896 19.470 100 67 133 1 2050336720 47959808 21652016
20:46:11 6124 8192000000 10962441920 11396788224 1984375728 19.499 100 62 121 1 2053144160 49080176 19688256
20:46:26 4900 8192000000 10960888208 11393458176 1961933552 19.321 99 52 104 3 2023154048 44749824 16470672
20:46:37 4915 8192000000 10967183280 11396902912 1983386992 19.492 100 59 118 1 2049292448 47318112 18587344
20:46:53 1634 8192000000 10966591488 11394215936 1982165520 19.482 100 61 123 0 2047641680 46131120 19345040
20:47:01 7203 8192000000 10962878928 11399192576 1981415104 19.476 100 50 99 0 2046306512 49294544 15596864
20:47:25 17508 8192000000 10933070928 11374247936 1906127216 18.876 96 31 62 0 1963850240 47472944 10250080
20:47:53 7691 8192000000 10961394640 11397152768 1962415488 19.325 99 44 89 1 2029888192 52475008 14997696
20:48:11 14347 8192000000 10952064336 11398176768 1977549296 19.445 100 34 69 1 2040392192 51889232 10953664
20:48:36 18932 8192000000 10950041488 11391680512 1954580016 19.263 99 35 71 1 2018576368 51954064 12042288
20:49:10 21035 8192000000 10948252256 11392778240 1968640496 19.375 100 38 76 2 2039457568 57882896 12934176
20:49:43 17400 8192000000 10948861776 11396255744 1946961856 19.202 99 31 62 2 2014635024 56914640 10758528
20:50:11 10917 8192000000 10937805808 11390889984 1941820784 19.161 99 31 62 1 2015409680 62744304 10844592
20:50:30 13006 8192000000 10948145328 11392565248 1964552528 19.342 100 34 68 1 2036291552 60506624 11232400
20:50:53 12771 8192000000 10934429408 11382890496 1923920224 19.018 98 34 68 8 1993622992 58884416 10818352
20:51:18 8896 8192000000 10936408976 11382554624 1934334112 19.102 99 30 60 0 2008907440 64116560 10456768
20:51:58 9300 8192000000 10934916928 11391483904 1952301280 19.245 100 33 66 0 2021286736 57669856 11315600
20:52:31 27620 8192000000 10929780464 11383816192 1946657344 19.200 100 23 46 0 2010833696 55677664 8498688
20:53:05 25736 8192000000 10910296848 11376836608 1906243136 18.876 98 20 40 1 1976153616 63125792 6784688
20:53:37 22522 8192000000 10900999936 11356614656 1910804336 18.913 99 17 34 1 1967267376 50544592 5918448
20:54:29 29879 8192000000 10887018384 11356524544 1915538992 18.951 99 12 24 1 1968551120 48341456 4670672
20:55:13 42616 8192000000 10890180624 11333705728 1929701008 19.064 100 17 34 0 1957687360 22323504 5662848
20:56:06 48785 8192000000 10876762224 11334393856 1915034560 18.947 99 29 58 2 1942025808 18108224 8883024
20:57:04 61484 8192000000 10860604496 11328942080 1909124448 18.900 99 18 37 0 1926259600 12308096 4827056
20:58:24 34188 8192000000 10859236816 11327180800 1940243776 19.149 100 14 26 2 1951403120 7076240 4083104
20:59:07 46096 8192000000 10872584944 11334086656 1935221488 19.109 99 8 16 0 1945082416 7837712 2023216
21:00:00 56358 8192000000 10900017376 11362570240 1968799616 19.376 100 16 32 1 1985991392 12968576 4223200
21:01:03 86965 8192000000 10903403488 11371868160 1952668368 19.248 99 16 32 2 1969402880 12366272 4368240
21:02:41 95821 8192000000 10886353344 11358474240 1930798016 19.073 98 12 25 0 1948120560 13781728 3540816
21:04:24 86169 8192000000 10881434160 11353280512 1937355088 19.126 98 14 30 0 1951107776 9386960 4365728
21:05:58 58898 8192000000 10897933008 11360051200 1953279792 19.253 99 26 52 3 1967746224 7503184 6963248
21:07:10 46888 8192000000 10916690528 11371937792 1957183824 19.284 99 20 41 0 1972166400 7766304 7216272
21:08:04 46488 8192000000 10920206624 11379761152 1968870736 19.376 99 39 78 1 1990957056 10657760 11428560
21:09:18 124807 8192000000 10904171696 11382173696 1992850688 19.566 100 32 64 0 2014141296 11881600 9409008
21:11:35 38044 8192000000 10926524224 11387813888 1995114928 19.584 100 23 46 1 2008140800 6546320 6479552
21:12:20 26165 8192000000 10917760800 11390005248 2000924960 19.630 100 23 46 0 2015144704 7697920 6521824
21:12:52 22273 8192000000 10903894000 11381309440 1980636544 19.470 99 18 36 1 1993259728 7577120 5046064
21:13:37 40467 8192000000 10910548256 11377500160 1959396128 19.301 98 28 56 0 1979787216 12832336 7558752
21:14:34 100369 8192000000 10928158928 11409670144 2000269104 19.625 100 14 28 0 2022178400 17397248 4512048
21:16:21 71302 8192000000 10939525008 11412295680 2006651760 19.675 100 8 16 1 2025851264 16875872 2323632
21:17:44 79287 8192000000 10936143248 11417047040 2012316672 19.720 100 14 28 0 2028408768 12130544 3961552
21:19:11 53117 8192000000 10932674496 11409629184 1970497904 19.389 98 10 20 0 1986281040 13044896 2738240
21:20:11 64993 8192000000 10916440224 11405152256 1981675040 19.478 99 9 18 0 2001581664 17062480 2844144
21:21:41 97065 8192000000 10909294176 11398098944 1943333904 19.173 97 13 26 0 1960910368 13805440 3771024
21:23:31 49340 8192000000 10919077280 11389636608 1975451344 19.429 99 17 34 2 1990313728 10545504 4316880
21:24:28 43189 8192000000 10943471504 11400097792 1979326288 19.459 99 23 46 1 1997018160 10758592 6933280
21:25:23 109590 8192000000 10907746992 11390132224 1905367008 18.869 96 11 22 1 1926679328 18245120 3067200
21:27:29 86602 8192000000 10897827840 11376861184 1907367712 18.886 96 10 20 1 1921057440 10578912 3110816
21:29:03 106141 8192000000 10906540032 11376734208 1920703104 18.992 97 15 29 0 1935919536 11961312 3255120
21:30:56 55626 8192000000 10892794464 11355037696 1877573024 18.646 95 19 38 2 1892096672 9350544 5173104
21:32:04 40349 8192000000 10913429344 11362496512 1951854992 19.241 99 37 73 0 1971327232 9442688 10029552
21:33:16 78094 8192000000 10913895504 11361947648 1961908672 19.321 100 52 104 0 1990127600 13754768 14464160
21:35:00 49728 8192000000 10875889888 11339780096 1929385760 19.062 98 39 78 4 1950990896 9508144 12096992
21:35:59 92527 8192000000 10873613120 11351281664 1888677360 18.735 96 24 48 1 1910666912 15166576 6822976
21:38:17 37478 8192000000 10845075376 11323875328 1924162848 19.020 100 6 12 0 1941709872 15711760 1835264
21:39:00 34331 8192000000 10797738720 11264122880 1827482432 18.239 95 10 20 1 1843462880 13312768 2667680
21:39:41 57850 8192000000 10786929072 11252793344 1820103952 18.179 96 15 30 1 1838193136 13705424 4383760
21:40:58 70513 8192000000 10783611376 11252293632 1781746832 17.864 94 20 40 1 1797217920 9443600 6027488
21:42:59 47787 8192000000 10845317888 11304988672 1903181648 18.852 100 21 42 2 1923719344 14640864 5896832
21:43:57 90783 8192000000 10800933712 11265949696 1787711104 17.913 93 18 36 0 1807586048 14365888 5509056
21:45:43 84007 8192000000 10835133376 11304910848 1852304912 18.441 97 23 46 2 1884574096 24879904 7389280
21:47:13 123726 8192000000 10842812736 11303632896 1858891744 18.494 97 13 27 0 1873657648 11196096 3569808
21:49:29 66869 8192000000 10852174656 11315589120 1883701088 18.695 98 17 34 0 1905234224 16947248 4585888
21:50:45 81265 8192000000 10872062176 11320758272 1895666608 18.791 98 15 30 1 1915636496 15745424 4224464
21:52:13 71536 8192000000 10876257280 11345215488 1897977120 18.810 98 38 77 1 1921678496 12356816 11344560
21:53:33 39029 8192000000 10883126096 11342139392 1926542992 19.039 99 22 44 1 1942999808 10303440 6153376
21:54:19 27006 8192000000 10912864896 11354542080 1956930400 19.282 100 40 80 0 1977253584 9453376 10869808
21:54:56 106406 8192000000 10891364608 11357118464 1964729088 19.344 100 37 74 1 1988841472 12711376 11401008
21:57:05 77428 8192000000 10874836192 11357302784 1934087696 19.100 98 12 24 2 1954118480 16670496 3360288
21:58:29 50875 8192000000 10891618672 11370504192 1974110112 19.418 100 10 20 0 1992796224 15875136 2810976
21:59:30 27393 8192000000 10893301104 11370905600 1975669872 19.430 100 8 16 1 1988639776 10779344 2190560
22:00:04 23661 8192000000 10901170208 11376619520 1979248880 19.459 100 11 22 1 1993659552 11255280 3155392
22:00:34 29403 8192000000 10891547600 11375599616 1959262816 19.300 99 13 26 2 1976492000 13776880 3452304
22:01:16 78781 8192000000 10898617664 11376189440 1958951728 19.298 99 11 22 0 1970588256 8743424 2893104
22:03:01 59779 8192000000 10883154736 11358101504 1924309984 19.021 97 14 28 1 1935938640 8199824 3428832
22:04:13 68524 8192000000 10914359712 11383136256 1924849760 19.026 97 25 49 0 1945860800 13995200 7015840
22:05:28 113372 8192000000 10905099136 11376844800 1956304240 19.277 99 11 22 0 1977553872 18147840 3101792
22:07:27 86648 8192000000 10929263024 11407933440 1977841504 19.448 99 11 22 0 1994726528 13278240 3606784
22:09:00 80218 8192000000 10929601856 11393118208 1956197248 19.276 98 19 38 3 1975497616 14163568 5136800
22:10:30 50372 8192000000 10938909936 11413540864 1997579936 19.604 100 32 64 1 2024761840 18406416 8775488
22:11:28 98052 8192000000 10920488912 11382530048 1913770432 18.937 96 31 59 2 1935278960 13462160 8046368
22:13:17 65366 8192000000 10926380192 11380826112 1927756304 19.049 97 28 56 1 1946653408 11108448 7788656
22:14:29 37823 8192000000 10910460416 11383914496 1965321184 19.348 99 28 56 0 1984778288 11969680 7487424
22:15:19 111949 8192000000 10914837120 11394744320 1968385568 19.373 99 16 32 0 1992431856 19795616 4250672
22:17:46 84632 8192000000 10894957760 11383988224 1929191024 19.060 97 10 20 0 1944516368 12631376 2693968
22:19:17 48246 8192000000 10906155952 11387932672 1982150160 19.482 100 18 36 1 1995828608 8161312 5517136
22:20:11 72270 8192000000 10896926672 11384385536 1947360832 19.205 98 9 18 0 1959359408 9494976 2503600
22:21:30 51959 8192000000 10897564864 11386814464 1962814992 19.328 99 9 18 0 1974144848 8792416 2537440
22:22:29 87347 8192000000 10908310320 11393339392 1991455520 19.555 100 12 24 0 2001139312 6241920 3441872
22:24:15 63698 8192000000 10920725568 11399245824 2002351376 19.641 100 13 26 0 2014300912 8371024 3578512
22:25:27 68831 8192000000 10910627344 11406360576 1980123616 19.466 99 13 26 1 1993338912 9732848 3482448
22:26:42 28039 8192000000 9301740352 9586106368 450550432 5.213 23 2 4 0 452222816 1547760 124624

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 25-11-2020 22:28:47 to 25-11-2020 22:29:18.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 105 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

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

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          234309
MON$OLDEST_ACTIVE               234310
MON$OLDEST_SNAPSHOT             234310
MON$NEXT_TRANSACTION            234310
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                       2037536
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.33393 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33393 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33393 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33393 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 ---
--- end of diff output ---

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

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