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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17495040 kB
MemAvailable 31626352 kB
Buffers 0 kB
Cached 14183064 kB
SwapCached 2112 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-26 22:27:03
DTS_END                         2020-11-26 22:27:03.8880
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/36086
TRN_ID                          246753
ATT_ID                          709
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: 9188.65 25791 1102638
customer order: creation 173.51 392 20821
customer order: refuse 14.85 339 1782
order to supplier: creation 47.16 1295 5659
order to supplier: removal 3.54 92352 425
invoice (draft): creation 48.03 3323 5764
invoice (draft): removal 51.98 781 6237
invoice accept: apply 42.60 18238 5112
invoice accept: cancel 46.68 871 5602
customer reserve: creation 3884.80 184 466176
customer reserve: removal 4571.34 56 548561
realization accept: apply 87.21 159 10465
realization accept: cancel 80.45 111 9654
payment from customer: creation 62.73 116 7528
payment from customer: removal 6.18 94 742
payment to supplier: creation 51.14 129 6137
payment to supplier: removal 3.58 96 429
service: total inventory turnovers 4.89 1046 587
service: total monetary turnovers 7.01 32 841
service: aggregate perf. data 0.93 14512 112
service: refresh index statistics 0.03 381699 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 26-11-2020 22:28:12 to 26-11-2020 22:28:14.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8033
TEST_TIME 2 4779
TEST_TIME 3 5507
TEST_TIME 4 5141
TEST_TIME 5 5257
TEST_TIME 6 5834
TEST_TIME 7 6412
TEST_TIME 8 6415
TEST_TIME 9 6438
TEST_TIME 10 6346
TEST_TIME 11 6302
TEST_TIME 12 6549
TEST_TIME 13 6723
TEST_TIME 14 6734
TEST_TIME 15 6649
TEST_TIME 16 7223
TEST_TIME 17 7657
TEST_TIME 18 8249
TEST_TIME 19 8300
TEST_TIME 20 8506
TEST_TIME 21 8827
TEST_TIME 22 9127
TEST_TIME 23 9418
TEST_TIME 24 9838
TEST_TIME 25 10121
TEST_TIME 26 10531
TEST_TIME 27 10597
TEST_TIME 28 10751
TEST_TIME 29 10481
TEST_TIME 30 10428
TEST_TIME 31 10530
TEST_TIME 32 10349
TEST_TIME 33 10231
TEST_TIME 34 10146
TEST_TIME 35 10184
TEST_TIME 36 10009
TEST_TIME 37 9945
TEST_TIME 38 9837
TEST_TIME 39 9743
TEST_TIME 40 9953
TEST_TIME 41 9935
TEST_TIME 42 9845
TEST_TIME 43 9739
TEST_TIME 44 9729
TEST_TIME 45 9664
TEST_TIME 46 9730
TEST_TIME 47 9794
TEST_TIME 48 9780
TEST_TIME 49 9810
TEST_TIME 50 9732
TEST_TIME 51 9881
TEST_TIME 52 9941
TEST_TIME 53 9882
TEST_TIME 54 9868
TEST_TIME 55 9807
TEST_TIME 56 9756
TEST_TIME 57 10105
TEST_TIME 58 10105
TEST_TIME 59 10048
TEST_TIME 60 9896
TEST_TIME 61 9830
TEST_TIME 62 9830
TEST_TIME 63 9825
TEST_TIME 64 9755
TEST_TIME 65 9653
TEST_TIME 66 9598
TEST_TIME 67 9645
TEST_TIME 68 9615
TEST_TIME 69 9651
TEST_TIME 70 9631
TEST_TIME 71 9615
TEST_TIME 72 9586
TEST_TIME 73 9622
TEST_TIME 74 9657
TEST_TIME 75 9671
TEST_TIME 76 9702
TEST_TIME 77 9725
TEST_TIME 78 9730
TEST_TIME 79 9677
TEST_TIME 80 9771
TEST_TIME 81 9721
TEST_TIME 82 9652
TEST_TIME 83 9609
TEST_TIME 84 9570
TEST_TIME 85 9600
TEST_TIME 86 9553
TEST_TIME 87 9543
TEST_TIME 88 9500
TEST_TIME 89 9481
TEST_TIME 90 9414
TEST_TIME 91 9368
TEST_TIME 92 9390
TEST_TIME 93 9353
TEST_TIME 94 9344
TEST_TIME 95 9344
TEST_TIME 96 9408
TEST_TIME 97 9409
TEST_TIME 98 9379
TEST_TIME 99 9404
TEST_TIME 100 9391
TEST_TIME 101 9394
TEST_TIME 102 9488
TEST_TIME 103 9488
TEST_TIME 104 9522
TEST_TIME 105 9518
TEST_TIME 106 9503
TEST_TIME 107 9478
TEST_TIME 108 9420
TEST_TIME 109 9372
TEST_TIME 110 9385
TEST_TIME 111 9350
TEST_TIME 112 9296
TEST_TIME 113 9292
TEST_TIME 114 9264
TEST_TIME 115 9300
TEST_TIME 116 9306
TEST_TIME 117 9312
TEST_TIME 118 9300
TEST_TIME 119 9266
TEST_TIME 120 9193

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 26-11-2020 22:28:16 to 26-11-2020 22:28:19.

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 1535953 1535953 0 0.00 0 30139 6 0 0
doc_list_biud 1535952 1535952 0 0.00 0 39883 26 0 0
sp_add_invoice_to_stock 5255 5112 143 2.72 42 192284 18239 0 143
sp_cancel_adding_invoice 5602 5602 0 0.00 5 71276 872 0 0
sp_cancel_client_order 1782 1782 0 0.00 4 19974 340 0 0
sp_cancel_customer_reserve 548561 548561 0 0.00 1 31644 57 0 0
sp_cancel_pay_from_customer 742 742 0 0.00 3 6775 94 0 0
sp_cancel_pay_to_supplier 429 429 0 0.00 2 3447 96 0 0
sp_cancel_supplier_invoice 6248 6237 11 0.17 2 39951 781 0 11
sp_cancel_supplier_order 425 425 0 0.00 7 1034017 92353 0 0
sp_cancel_write_off 9654 9654 0 0.00 1 22039 112 0 0
sp_client_order 20821 20821 0 0.00 3 29558 392 0 0
sp_customer_reserve 466176 466176 0 0.00 0 71599 184 0 0
sp_fill_shopping_cart 32227 32227 0 0.00 1 11171 38 0 0
sp_fill_shopping_cart_clo_res 466169 466169 0 0.00 0 16907 15 0 0
sp_get_clo_for_invoice 5103 5103 0 0.00 0 37667 267 0 0
sp_kill_cost_storno 16427 16427 0 0.00 0 7381 54 0 0
sp_kill_qstorno_ret_qs2qd 1113438 1113438 0 0.00 0 39881 31 0 0
sp_kill_qty_storno 587829 587829 0 0.00 0 39881 67 0 0
sp_lock_selected_doc 21566 21566 0 0.00 0 9123 4 0 0
sp_make_cost_storno 29233 29233 0 0.00 0 17158 51 0 0
sp_multiply_rows_for_pdistr 29233 29233 0 0.00 0 5454 24 0 0
sp_multiply_rows_for_qdistr 20821 20821 0 0.00 0 10602 172 0 0
sp_pay_from_customer 7528 7528 0 0.00 4 24223 117 0 0
sp_pay_to_supplier 6137 6137 0 0.00 5 20855 130 0 0
sp_payment_common 13665 13665 0 0.00 1 13247 23 0 0
sp_qd_handle_on_cancel_clo 1782 1782 0 0.00 0 19384 302 0 0
sp_qd_handle_on_invoice_upd_sts 10705 10705 0 0.00 0 31284 327 0 0
sp_qd_handle_on_reserve_upd_sts 10465 10465 0 0.00 0 20347 54 0 0
sp_reserve_write_off 10465 10465 0 0.00 6 20551 159 0 0
sp_supplier_invoice 5764 5764 0 0.00 7 106013 3324 0 0
sp_supplier_order 5659 5659 0 0.00 5 33827 1295 0 0
srv_aggregate_perf_data 113 112 1 0.88 2173 107342 14513 0 1
srv_fill_mon_cache_memory 162 162 0 0.00 1337 167904 32730 0 0
srv_find_qd_qs_mism 1054482 1054482 0 0.00 0 30138 5 0 0
srv_make_invnt_saldo 587 587 0 0.00 50 77151 1047 0 0
srv_make_money_saldo 841 841 0 0.00 1 3253 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 178461 522491 381699 0 0
t$perf-abend:sp_add_invoice_to_stock 143 143 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 5112 5112 0 0.00 0 13406 166 0 0
t$perf-norm:sp_cancel_adding_invoice 425 425 0 0.00 0 24983 155 0 0
t$perf-norm:sp_cancel_client_order 1782 1782 0 0.00 0 10510 18 0 0
t$perf-norm:sp_cancel_customer_reserve 721 721 0 0.00 0 3017 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 742 742 0 0.00 0 4713 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 429 429 0 0.00 0 2267 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 412 412 0 0.00 0 2907 22 0 0
t$perf-norm:sp_cancel_supplier_order 425 425 0 0.00 0 17960 1461 0 0
t$perf-norm:sp_cancel_write_off 1062 1062 0 0.00 0 3211 9 0 0
t$perf-norm:sp_client_order 20821 20821 0 0.00 0 14523 17 0 0
t$perf-norm:sp_customer_reserve 1070 1070 0 0.00 0 1380 5 0 0
t$perf-norm:sp_pay_from_customer 7528 7528 0 0.00 0 15783 14 0 0
t$perf-norm:sp_pay_to_supplier 6137 6137 0 0.00 0 9120 12 0 0
t$perf-norm:sp_reserve_write_off 10465 10465 0 0.00 0 13988 15 0 0
t$perf-norm:sp_supplier_invoice 5764 5764 0 0.00 0 8380 19 0 0
t$perf-norm:sp_supplier_order 5659 5659 0 0.00 0 5067 14 0 0
t$perf-norm:srv_aggregate_perf_data 112 112 0 0.00 0 874 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 274 4 0 0
t$perf-norm:srv_make_invnt_saldo 587 587 0 0.00 0 2807 27 0 0
t$perf-norm:srv_make_money_saldo 841 841 0 0.00 0 2294 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10492 10206 286 2.72 0 20765 26 0 286
v_all_customers 38378 38378 0 0.00 0 90 1 0 0
v_all_suppliers 31718 31718 0 0.00 0 32 1 0 0
v_all_wares 41642 41642 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 850 850 0 0.00 0 1968 9 0 0
v_cancel_client_order 3564 3564 0 0.00 0 19914 14 0 0
v_cancel_customer_prepayment 1484 1484 0 0.00 0 1690 5 0 0
v_cancel_customer_reserve 1442 1442 0 0.00 0 297 3 0 0
v_cancel_payment_to_supplier 858 858 0 0.00 0 2640 15 0 0
v_cancel_supplier_invoice 846 824 22 2.60 0 3337 20 0 22
v_cancel_supplier_order 850 850 0 0.00 0 1410 5 0 0
v_cancel_write_off 2124 2124 0 0.00 0 6588 17 0 0
v_max_id_clo_ord 5658 5658 0 0.00 0 2486 2 0 0
v_max_id_clo_res 1070 1070 0 0.00 0 7506 18 0 0
v_max_id_ord_sup 5748 5748 0 0.00 0 5201 4 0 0
v_max_non_paid_invoice 1684 1684 0 0.00 0 426 2 0 0
v_max_non_paid_realizn 3947 3947 0 0.00 0 1452 3 0 0
v_min_id_clo_ord 5658 5658 0 0.00 0 6429 12 0 0
v_min_id_clo_res 1070 1070 0 0.00 0 9937 18 0 0
v_min_id_ord_sup 5748 5748 0 0.00 0 8383 16 0 0
v_min_non_paid_invoice 6137 6137 0 0.00 0 2823 11 0 0
v_min_non_paid_realizn 7528 7528 0 0.00 0 6503 14 0 0
v_our_firm 10426 10426 0 0.00 0 18 1 0 0
v_reserve_write_off 20930 20930 0 0.00 0 14566 6 0 0
x_lock_depdocs_on_canc_invoice 11427 11427 0 0.00 0 23707 109 0 0
x_lock_depdocs_on_canc_sup_ord 425 425 0 0.00 0 12210 325 0 0
x_make_qstorno_1000_1200 5659 5659 0 0.00 1 33813 1207 0 0
x_make_qstorno_1200_2000 5764 5764 0 0.00 3 105980 3200 0 0
x_make_qstorno_2100_3300 466176 466176 0 0.00 0 71598 167 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 26-11-2020 22:28:20 to 26-11-2020 22:28:24.

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:07 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:13 19330 8192000000 10269333984 10578485248 943832256 10.331 75 60 121 0 967018848 2558752 20627840
19:57:42 41668 8192000000 10355465904 10675621888 1396632816 14.565 100 83 166 0 1428471776 4919440 26919520
19:58:35 27251 8192000000 10382593760 10707333120 1437713248 14.929 100 89 177 2 1473263328 6740064 28810016
19:59:10 13955 8192000000 10400476496 10727813120 1456470272 15.095 100 88 176 0 1492115136 7275168 28369696
19:59:39 24158 8192000000 10423536176 10754936832 1476631152 15.272 100 84 168 0 1511258048 7615376 27011520
20:00:10 22533 8192000000 10450572208 10783719424 1493409856 15.419 100 87 174 1 1529462960 8239392 27813712
20:00:44 10879 8192000000 10467985232 10804137984 1520538704 15.655 100 84 168 1 1555868160 8854848 26474608
20:01:05 23361 8192000000 10482030736 10822889472 1538403888 15.810 100 86 172 1 1575276912 9679424 27193600
20:01:38 20680 8192000000 10509891744 10855387136 1559920704 15.996 100 86 172 0 1596982864 10335200 26726960
20:02:06 24537 8192000000 10534803232 10891943936 1586782752 16.226 100 80 160 0 1621815936 10305568 24727616
20:02:40 8388 8192000000 10560867856 10917658624 1615322064 16.470 100 79 159 0 1650581968 10526688 24733216
20:02:56 12101 8192000000 10582468416 10943946752 1637093424 16.655 100 76 152 2 1671687104 11720224 22873456
20:03:19 8486 8192000000 10609285728 10977255424 1665613248 16.896 100 79 158 1 1700088960 11268736 23206976
20:03:35 7052 8192000000 10623506064 10992660480 1681144224 17.027 100 73 146 2 1714051168 11790976 21115968
20:03:49 9582 8192000000 10649488688 11020574720 1702425360 17.205 100 79 157 0 1737696416 12615232 22655824
20:04:08 9362 8192000000 10660283824 11032125440 1716744816 17.325 100 85 170 2 1754988864 14051744 24192304
20:04:25 6561 8192000000 10674500304 11044179968 1727625120 17.416 100 83 166 0 1766168816 14687904 23855792
20:04:39 7960 8192000000 10679819440 11056652288 1737971424 17.502 100 75 150 1 1773594464 13565200 22057840
20:04:55 6542 8192000000 10689348736 11070476288 1752461392 17.622 100 70 140 1 1783677344 11445344 19770608
20:05:08 6030 8192000000 10697599648 11081760768 1767769200 17.749 100 80 161 2 1801271888 10975248 22527440
20:05:22 4731 8192000000 10720309392 11101286400 1778343056 17.836 100 78 156 3 1811946432 11959200 21644176
20:05:34 3770 8192000000 10711047328 11099774976 1779651296 17.847 100 71 142 1 1811490464 11874336 19964832
20:05:45 7159 8192000000 10718852928 11104260096 1785626624 17.896 100 70 139 1 1817151744 12019168 19505952
20:05:59 3432 8192000000 10724222096 11117690880 1789207376 17.925 100 70 140 0 1820826656 11419200 20200080
20:06:10 4780 8192000000 10743673456 11130986496 1806431232 18.067 100 84 170 1 1843224592 12819408 23973952
20:06:21 3302 8192000000 10753523648 11141193728 1816535104 18.149 100 81 160 0 1851665776 12883728 22246944
20:06:31 2418 8192000000 10755315456 11140841472 1823310448 18.205 100 79 159 0 1858630064 13456880 21862736
20:06:40 2290 8192000000 10766377872 11153113088 1824796320 18.217 100 88 174 0 1863334992 13133776 25404896
20:06:49 2626 8192000000 10764087232 11158953984 1830907824 18.267 100 84 166 0 1866902096 12953856 23040416
20:06:58 2799 8192000000 10775791456 11161935872 1835905376 18.307 100 91 181 0 1875831952 14024064 25902512
20:07:08 1510 8192000000 10782386240 11169787904 1844066896 18.374 100 91 183 0 1883222576 13616464 25539216
20:07:16 2182 8192000000 10792812896 11177476096 1848736592 18.412 100 93 186 1 1887240880 12127344 26376944
20:07:25 2088 8192000000 10794737824 11183771648 1854648160 18.460 100 91 182 3 1892624160 13450608 24525392
20:07:33 2414 8192000000 10799339440 11187150848 1858472176 18.491 100 92 182 2 1897116272 13015888 25628208
20:07:42 1801 8192000000 10807943392 11191558144 1861035024 18.512 100 95 188 1 1901768960 13987936 26746000
20:07:50 1181 8192000000 10807699168 11192401920 1861429760 18.515 100 95 188 2 1901681344 13635536 26616048
20:07:58 1746 8192000000 10801942224 11187916800 1863252800 18.530 100 94 189 2 1902022128 12468288 26301040
20:08:06 1570 8192000000 10807929280 11200696320 1868782480 18.574 100 95 186 6 1908887536 13796064 26308992
20:08:13 1164 8192000000 10817956768 11206266880 1872657920 18.606 100 93 184 3 1913246000 14397184 26190896
20:08:21 7689 8192000000 10777334528 11197489152 1862654448 18.525 100 63 126 2 1894400656 13707984 18038224
20:08:35 44894 8192000000 10784301616 11192176640 1860223808 18.505 100 43 86 2 1880437632 7568528 12645296
20:09:28 1243 8192000000 10814523696 11206381568 1875539248 18.629 100 89 177 1 1910950176 10331296 25079632
20:09:35 9199 8192000000 10786521904 11203928064 1864742352 18.542 100 47 94 3 1888944528 11255120 12947056
20:09:54 8551 8192000000 10769409120 11196731392 1861567168 18.516 100 27 54 3 1876252448 5955936 8729344
20:10:09 4423 8192000000 10782131712 11201130496 1864781504 18.542 100 39 78 1 1883582208 7423968 11376736
20:10:21 6245 8192000000 10803407440 11205795840 1864069728 18.536 100 28 56 1 1884394144 12936448 7387968
20:10:33 6954 8192000000 10771469472 11205799936 1869581936 18.581 100 42 84 0 1889604944 8085840 11937168
20:10:51 3994 8192000000 10780565424 11205763072 1868396592 18.571 100 29 57 3 1883527248 7007808 8122848
20:11:01 6255 8192000000 10785802704 11205918720 1868985424 18.576 100 24 47 1 1881506912 5716240 6805248
20:11:14 7837 8192000000 10780429680 11210199040 1870223920 18.586 100 16 32 2 1880560416 5461872 4874624
20:11:29 10385 8192000000 10777144400 11217408000 1873396880 18.612 100 18 35 3 1888528752 10510112 4621760
20:11:46 9737 8192000000 10792157968 11224567808 1877178880 18.642 100 22 45 0 1888769616 6000752 5589984
20:12:04 11894 8192000000 10792617040 11218743296 1878209072 18.651 100 19 39 2 1888946544 5224816 5512656
20:12:23 8246 8192000000 10798623392 11224047616 1881565168 18.678 100 22 44 1 1893215488 5736976 5913344
20:12:45 11519 8192000000 10801059616 11229241344 1887439984 18.725 100 24 48 1 1899868832 5879408 6549440
20:13:06 10479 8192000000 10798983344 11231031296 1885178560 18.707 100 11 22 0 1893524272 5239008 3106704
20:13:24 12288 8192000000 10807339088 11235307520 1891535712 18.758 100 21 41 4 1905959456 9400640 5023104
20:13:45 76729 8192000000 10803505328 11242528768 1894521216 18.782 100 25 50 0 1906939488 5127888 7290384
20:15:09 6008 8192000000 10825521936 11248775168 1899352816 18.821 100 36 69 0 1915395600 5603280 10439504
20:15:22 6302 8192000000 10804928224 11239641088 1881031360 18.673 99 26 52 1 1895698960 7341872 7325728
20:15:35 4956 8192000000 10816256672 11243237376 1894009904 18.778 100 29 57 3 1909327680 7397760 7920016
20:15:46 12308 8192000000 10797602624 11239862272 1896548208 18.799 100 18 36 1 1907069776 5767712 4753856
20:16:05 6389 8192000000 10811973376 11240538112 1892569024 18.766 100 25 50 0 1906207120 6927568 6710528
20:16:19 7999 8192000000 10798756352 11232555008 1887300480 18.724 100 22 44 1 1899805536 6040560 6464496
20:16:35 9185 8192000000 10799665920 11235434496 1873580688 18.613 99 14 26 0 1882453104 5061040 3811376
20:16:51 6365 8192000000 10796935600 11230285824 1869157648 18.577 99 21 42 2 1881458880 6322816 5978416
20:17:04 8817 8192000000 10789214464 11222302720 1851152336 18.431 98 23 46 0 1864480592 6292496 7035760
20:17:21 10452 8192000000 10767572368 11195162624 1798395152 18.001 96 14 28 0 1808132528 5463072 4274304
20:17:38 7668 8192000000 10751648896 11174744064 1793349408 17.959 97 20 39 1 1805106448 6159888 5597152
20:17:54 8726 8192000000 10735277824 11161575424 1763793552 17.716 96 20 41 1 1774896400 5651104 5451744
20:18:09 7921 8192000000 10715857040 11138793472 1763959104 17.717 97 25 51 2 1776891056 5985648 6946304
20:18:24 21906 8192000000 10723437856 11136135168 1674623136 16.972 92 33 66 2 1689830624 5784032 9423456
20:18:52 68306 8192000000 10678414720 11094421504 1559921584 15.996 86 30 59 4 1573662608 5022208 8718816
20:20:07 8662 8192000000 10680554224 11091865600 1697551536 17.165 96 25 50 3 1710234080 5442272 7240272
20:20:22 7411 8192000000 10708997200 11120414720 1753937984 17.634 98 27 54 3 1772245264 10717520 7589760
20:20:37 4687 8192000000 10699105696 11108556800 1765978320 17.734 99 46 90 4 1787185312 8420368 12786624
20:20:52 6163 8192000000 10712722480 11124228096 1779307248 17.844 99 29 58 1 1793186176 5420000 8458928
20:21:06 7587 8192000000 10702685616 11125903360 1778508464 17.837 99 19 38 2 1789365680 5415840 5441376
20:21:19 5679 8192000000 10728703952 11147591680 1792139744 17.949 99 23 46 1 1809422240 11103200 6179296
20:21:31 7815 8192000000 10716400848 11141459968 1796092416 17.982 99 22 44 4 1808613776 6253888 6267472
20:21:50 4131 8192000000 10723460608 11147739136 1797801952 17.996 99 25 50 0 1810907024 6103456 7001616
20:22:00 8161 8192000000 10745528208 11160141824 1803210032 18.040 99 25 49 2 1819814560 9584304 7020224
20:22:15 5384 8192000000 10750313952 11164282880 1802060224 18.031 98 28 54 3 1815299232 5429232 7809776
20:22:27 11257 8192000000 10755467936 11172126720 1816806048 18.152 99 27 54 2 1829879136 4796832 8276256
20:22:46 6482 8192000000 10760366096 11179732992 1836994464 18.316 100 22 44 3 1849489072 5672192 6822416
20:23:03 13295 8192000000 10758021040 11179917312 1825669024 18.224 99 26 53 1 1838700064 5000592 8030448
20:23:24 22214 8192000000 10772569632 11191681024 1848868720 18.413 100 43 84 5 1866500016 5073920 12557376
20:23:53 57917 8192000000 10768881744 11196399616 1855640688 18.468 100 31 62 0 1870889600 6189712 9059200
20:24:57 11909 8192000000 10764123952 11200303104 1860711968 18.509 100 24 48 1 1873464832 5808112 6944752
20:25:15 7011 8192000000 10774876288 11203735552 1863111808 18.529 100 32 64 0 1878456688 6721936 8622944
20:25:28 7199 8192000000 10791409264 11212607488 1866336240 18.555 100 33 66 1 1882445312 6455792 9653280
20:25:43 8946 8192000000 10775048576 11213725696 1870806896 18.591 100 35 68 4 1886695600 5897520 9991184
20:26:00 4863 8192000000 10796105120 11219664896 1873938288 18.616 100 36 72 0 1891096080 6216976 10940816
20:26:12 8687 8192000000 10793219472 11222409216 1876945056 18.640 100 28 56 2 1890300368 5007136 8348176
20:26:29 7685 8192000000 10791435056 11224989696 1878066768 18.649 100 21 43 2 1889135328 5331232 5737328
20:26:43 10570 8192000000 10796210512 11225362432 1878897840 18.656 100 22 44 1 1891547824 5503552 7146432
20:27:00 7972 8192000000 10810179088 11232911360 1884416880 18.701 100 27 55 0 1897951360 4856608 8677872
20:27:18 4772 8192000000 10847828112 11259678720 1912412384 18.926 100 53 107 1 1933823120 5965280 15445456
20:27:32 22617 8192000000 10854160688 11270905856 1919018384 18.979 100 52 103 0 1941814304 8080816 14715104
20:28:12 5903 8192000000 10863893472 11281231872 1925021296 19.027 100 54 108 0 1949185904 8638880 15525728
20:28:25 13065 8192000000 10870902160 11290263552 1936691040 19.120 100 59 118 0 1963625952 9556944 17377968
20:28:47 87238 8192000000 10871696960 11306491904 1942332128 19.165 100 46 92 0 1965954832 10499888 13122816
20:30:22 14162 8192000000 10877473968 11310096384 1946886368 19.202 100 42 84 1 1969248592 10481024 11881200
20:30:45 6920 8192000000 10882765392 11314073600 1953115360 19.251 100 44 86 1 1977325040 11891936 12317744
20:30:59 14768 8192000000 10883303360 11318292480 1956990736 19.282 100 43 86 1 1981348640 12042864 12315040
20:31:22 23472 8192000000 10894878272 11324207104 1956567696 19.279 100 44 88 1 1982034560 12710256 12756608
20:31:58 40653 8192000000 10903798656 11341824000 1969111328 19.378 100 42 84 1 1998493856 17154608 12227920
20:32:58 7541 8192000000 10915077104 11346817024 1974226336 19.419 100 47 94 1 2005141776 16447232 14468208
20:33:13 3651 8192000000 10905984096 11343200256 1975038400 19.425 100 40 80 0 1999547840 12852336 11657104
20:33:26 12857 8192000000 10913706368 11351064576 1983606144 19.493 100 49 94 0 2012434624 14676528 14151952
20:33:47 10083 8192000000 10920944208 11358068736 1988345360 19.531 100 53 106 3 2020812592 16519840 15947392
20:34:07 11412 8192000000 10941772480 11371384832 1992574400 19.564 100 59 116 0 2029749248 20023648 17151200
20:34:27 4661 8192000000 10940756416 11363749888 1988419552 19.531 100 58 115 0 2026122704 20895760 16807392
20:34:40 7437 8192000000 10949594368 11379286016 1996486784 19.595 100 62 125 0 2041378592 26515216 18376592
20:34:57 4300 8192000000 10955771888 11374481408 1997572736 19.604 100 61 122 0 2034858480 19704896 17580848
20:35:10 8029 8192000000 10945177856 11376640000 1998476720 19.611 100 57 113 1 2033814624 19349392 15988512
20:35:24 12749 8192000000 10928754784 11359928320 1973433728 19.413 99 53 105 2 2006719776 18610496 14675552
20:35:47 6858 8192000000 10918099568 11343126528 1966810752 19.360 99 44 88 0 1998271472 18976688 12484032
20:36:01 2964 8192000000 10944843392 11369246720 1990059280 19.544 100 67 131 0 2029452864 20263488 19130096
20:36:11 5551 8192000000 10945166192 11376443392 1992874192 19.566 100 50 100 1 2027673040 20112128 14686720
20:36:24 12795 8192000000 10953092208 11377471488 1998281232 19.609 100 67 131 1 2038328384 21303216 18743936
20:36:44 5213 8192000000 10950037712 11374747648 1996805248 19.598 100 67 133 2 2038741712 22235840 19700624
20:36:58 5179 8192000000 10929392528 11367366656 1978587296 19.454 99 53 105 0 2015431616 21193792 15650528
20:37:16 17168 8192000000 10956739248 11387125760 2004250896 19.656 100 62 123 1 2045282704 21743968 19287840
20:37:41 8733 8192000000 10954968992 11382480896 1984632368 19.501 99 56 110 1 2023474928 21788272 17054288
20:37:58 6911 8192000000 10956787472 11392823296 2011427632 19.713 100 64 127 1 2054257488 23252304 19577552
20:38:16 4713 8192000000 10964833664 11396022272 1996615280 19.596 99 50 100 0 2036151888 23991760 15544848
20:38:29 8453 8192000000 10957041152 11387826176 1993054640 19.568 99 64 126 1 2037932992 24439776 20438576
20:38:45 10915 8192000000 10962835328 11397357568 2007022352 19.678 100 56 112 2 2053334544 29170880 17141312
20:39:03 5371 8192000000 10965518384 11398238208 2007710240 19.683 100 69 138 1 2056269072 27349344 21209488
20:39:20 3591 8192000000 10955612736 11377405952 1986040336 19.512 99 72 145 3 2041160768 32720992 22399440
20:39:30 7364 8192000000 10957202496 11389050880 1988364576 19.531 99 63 126 2 2036344640 28503376 19476688
20:39:46 4997 8192000000 10971245584 11391758336 1990383920 19.547 99 73 146 1 2041481664 27936144 23161600
20:40:00 4032 8192000000 10974607392 11398225920 2010532096 19.706 100 69 136 1 2060870000 29557680 20780224
20:40:10 4029 8192000000 10980419680 11403669504 1994121728 19.576 99 73 144 0 2050528288 34945904 21460656
20:40:26 5634 8192000000 10970406704 11398680576 2004067360 19.655 100 68 134 0 2056547136 30960176 21519600
20:40:39 4907 8192000000 10963670160 11394707456 2003278480 19.649 100 60 120 1 2050232656 28842288 18111888
20:40:55 3155 8192000000 10981328832 11405066240 2012365200 19.720 100 78 155 0 2065435184 29522208 23547776
20:41:04 5875 8192000000 10949404192 11372638208 1961799248 19.320 98 73 143 0 2013292944 29900448 21593248
20:41:35 9141 8192000000 10930510208 11361652736 1949388096 19.222 98 50 99 1 1998135152 32764448 15982608
20:41:58 7036 8192000000 10946474736 11377586176 1984645152 19.501 100 49 97 0 2034488080 33809200 16033728
20:42:17 4903 8192000000 10965536464 11392909312 1979058064 19.457 99 57 114 1 2031695232 34034320 18602848
20:42:32 3069 8192000000 10965170624 11382824960 1992462800 19.563 100 72 142 0 2049282624 34929376 21890448
20:42:45 5165 8192000000 10976707872 11399372800 1999365712 19.618 100 74 146 1 2058792848 37520064 21907072
20:43:11 3692 8192000000 10952998080 11380748288 1956941680 19.282 98 62 124 0 2018455392 41033216 20480496
20:43:21 2593 8192000000 10965311760 11381272576 1982921856 19.488 100 78 157 0 2047208928 39885520 24401552
20:43:31 2188 8192000000 10985849840 11394043904 1989776000 19.542 100 88 172 3 2057350928 41042720 26532208
20:43:43 1972 8192000000 10976303760 11387248640 1987183168 19.522 100 83 164 1 2054832656 41927984 25721504
20:43:54 7965 8192000000 10963396048 11382943744 1985707872 19.510 100 77 153 1 2045868864 36085760 24075232
20:44:09 6961 8192000000 10970120880 11390050304 1986179376 19.514 100 72 144 2 2047599280 37772528 23647376
20:44:23 2888 8192000000 10962654560 11384274944 1985524416 19.508 100 78 157 2 2052625408 41315856 25785136
20:44:33 1381 8192000000 10974034384 11390353408 1986614976 19.517 100 86 171 1 2062701040 47411728 28674336
20:44:41 3455 8192000000 10979988544 11395805184 1991665120 19.557 100 88 177 1 2064220736 44747632 27807984
20:44:51 4079 8192000000 10980156384 11409006592 1997342784 19.602 100 66 132 0 2062505312 43770272 21392256
20:45:03 4270 8192000000 10968793040 11407380480 1998534224 19.611 100 47 94 0 2054796560 40763184 15499152
20:45:16 4354 8192000000 10970344896 11401609216 1998441248 19.610 100 58 116 0 2055859936 38888720 18529968
20:45:30 1336 8192000000 11000627328 11414806528 2013061984 19.726 100 93 186 0 2079543696 37415360 29066352
20:45:38 4549 8192000000 10955090864 11390877696 1986684208 19.518 99 50 100 2 2040450912 38106192 15660512
20:45:58 4131 8192000000 10960279296 11403870208 1982181920 19.482 99 39 75 2 2028700496 34257984 12260592
20:46:09 4236 8192000000 10965382336 11399774208 1996509776 19.595 100 52 104 2 2049574576 36508032 16556768
20:46:21 8814 8192000000 10976615728 11409780736 2003427776 19.650 100 54 106 4 2057445360 37241760 16775824
20:46:38 2114 8192000000 10976328848 11402874880 1995714544 19.589 100 78 154 2 2061029600 40496832 24818224
20:46:48 3697 8192000000 10973171200 11397558272 1978278688 19.451 99 71 142 2 2042434560 41821744 22334128
20:46:59 8149 8192000000 10950239824 11387916288 1963835344 19.337 99 37 72 1 2017535120 41482176 12217600
20:47:15 9307 8192000000 10950030768 11379625984 1942353888 19.166 98 48 96 1 2003283856 44193696 16736272
20:47:31 4577 8192000000 10969315232 11390820352 1980163856 19.466 100 68 134 3 2044519584 43276208 21079520
20:47:43 3274 8192000000 10945360896 11372511232 1936944624 19.122 98 66 131 3 2000738896 42646368 21147904
20:47:54 7222 8192000000 10925170784 11361497088 1923923120 19.018 98 54 108 1 1987424992 45727824 17774048
20:48:08 14662 8192000000 10930593040 11379113984 1963554432 19.334 100 35 70 0 2018347136 42859648 11933056
20:48:30 20331 8192000000 10916673120 11363192832 1924104608 19.020 98 35 70 0 1977173040 41604112 11464320
20:48:56 19304 8192000000 10907753760 11357069312 1931519424 19.079 99 29 59 1 1981527376 39502768 10505184
20:49:31 18700 8192000000 10915965904 11360100352 1938656480 19.136 99 27 55 2 1983297872 35123536 9517856
20:49:59 27305 8192000000 10904902336 11354050560 1915351152 18.950 98 29 58 2 1964401248 39307888 9742208
20:50:33 16347 8192000000 10893690368 11347361792 1913625200 18.936 99 29 57 0 1965135232 42176256 9333776
20:51:00 13103 8192000000 10895765344 11332427776 1878544800 18.653 97 46 90 1 1927893856 35516032 13833024
20:51:23 38355 8192000000 10875730368 11324403712 1915269296 18.949 100 29 58 2 1965498976 40646176 9583504
20:52:08 49187 8192000000 10855375120 11311304704 1891842176 18.761 98 15 30 0 1929617376 32434912 5340288
20:53:11 37560 8192000000 10885609600 11327528960 1926240912 19.037 100 14 27 2 1954766176 23923264 4602000
20:53:55 36447 8192000000 10867151792 11318005760 1913505488 18.935 99 31 60 0 1936191200 13857744 8827968
20:54:52 43036 8192000000 10860979968 11329175552 1899241952 18.820 98 11 23 0 1917699920 15013008 3444960
20:55:41 57241 8192000000 10906091664 11341209600 1945021712 19.187 100 34 68 1 1967824288 13105056 9697520
20:56:45 43347 8192000000 10908562512 11348316160 1955410192 19.270 100 29 55 0 1974969504 12199168 7360144
20:57:39 33178 8192000000 10887143200 11344674816 1922872384 19.010 98 25 50 0 1944810896 15078112 6860400
20:58:22 93491 8192000000 10875070016 11323379712 1855607728 18.468 95 11 21 1 1867709424 9325824 2775872
21:00:06 133599 8192000000 10898462128 11339132928 1921761360 19.001 98 29 58 2 1937605312 7787072 8056880
21:02:28 12753 8192000000 10902013504 11346046976 1950103264 19.227 99 59 114 2 1978089824 12132640 15853920
21:02:48 67418 8192000000 10866355456 11327090688 1942351248 19.166 99 16 32 0 1955993040 8678080 4963712
21:04:02 16436 8192000000 10914302832 11352891392 1950541008 19.231 99 39 77 1 1969915728 8327824 11046896
21:04:25 28496 8192000000 10902469424 11363528704 1971217888 19.395 100 37 74 2 1997873360 16454816 10200656
21:05:03 26918 8192000000 10920603264 11371040768 1974859296 19.424 100 31 62 0 1998034576 14237616 8937664
21:05:41 57387 8192000000 10920564800 11366690816 1940741200 19.153 98 36 72 0 1966958640 15721520 10495920
21:07:23 45614 8192000000 10897717600 11375222784 1971501984 19.397 100 18 36 1 1992317632 15779072 5036576
21:08:18 49205 8192000000 10905080048 11365822464 1943148464 19.172 98 14 28 0 1957463504 10239088 4075952
21:09:14 56850 8192000000 10891251936 11355422720 1934582240 19.103 98 15 30 0 1949428464 10626400 4219824
21:10:29 29831 8192000000 10915528176 11378675712 1972713824 19.407 100 17 34 0 1996131184 18396784 5020576
21:11:05 75888 8192000000 10907819760 11374809088 1936249856 19.117 98 18 35 0 1956878512 15530064 5098592
21:12:41 15841 8192000000 10919781248 11387822080 1982247504 19.482 100 31 64 1 2008750384 17944016 8558864
21:13:07 67546 8192000000 10917518080 11390595072 1964688480 19.343 99 9 18 0 1984326640 17126784 2511376
21:14:29 116800 8192000000 10916741376 11398967296 1945736160 19.193 98 16 32 0 1966042896 15656736 4650000
21:16:34 40105 8192000000 10932088544 11380633600 1950659744 19.232 98 38 76 0 1972594672 11307312 10627616
21:17:21 62463 8192000000 10919019040 11387469824 1948068144 19.211 98 22 43 0 1969707744 15380320 6259280
21:19:17 68888 8192000000 10902922640 11367677952 1952281376 19.245 99 21 42 1 1967165264 9252928 5630960
21:20:35 48902 8192000000 10937739760 11380977664 1961972224 19.322 99 27 54 0 1983968976 13831920 8164832
21:21:41 53558 8192000000 10924943200 11390341120 1980935440 19.472 100 21 42 3 2005141824 17667904 6538480
21:23:32 61138 8192000000 10881537968 11372670976 1872242000 18.602 95 14 28 0 1906255248 29004016 5009232
21:24:40 136861 8192000000 10872359632 11342868480 1830534496 18.264 94 7 14 0 1850501424 18236624 1730304
21:27:41 74000 8192000000 10888477920 11353964544 1920863088 18.994 98 19 38 1 1939010064 12945920 5201056
21:29:02 56720 8192000000 10855408768 11334770688 1900084768 18.827 97 11 22 0 1917772592 14115520 3572304
21:30:05 1627 8192000000 10857110000 11335471104 1933678720 19.096 100 7 14 0 1950414304 14952592 1782992
21:30:13 5726 8192000000 10854812144 11335663616 1933644000 19.096 100 4 8 0 1947585792 13398320 543472
21:30:25 17309 8192000000 10859187632 11305025536 1887475312 18.725 98 21 40 2 1902897824 9923856 5498656
21:30:53 39774 8192000000 10818135520 11279515648 1886146272 18.715 98 18 36 0 1897939360 5826832 5966256
21:31:39 58352 8192000000 10839618512 11305484288 1892591328 18.767 98 7 14 0 1900401904 5996720 1813856
21:32:43 37258 8192000000 10857839168 11317526528 1917607888 18.968 99 15 30 1 1928679504 7228000 3843616
21:33:27 64983 8192000000 10842452480 11324481536 1880563440 18.670 97 9 18 1 1891651232 8556384 2531408
21:34:39 53148 8192000000 10868635936 11325751296 1865163504 18.545 96 17 34 0 1878173200 8323264 4686432
21:35:39 45094 8192000000 10853418272 11319263232 1900443440 18.830 98 21 41 1 1914693136 8250032 5999664
21:37:03 66255 8192000000 10893001840 11346759680 1942874288 19.170 100 23 46 2 1965240304 16047232 6318784
21:38:22 28272 8192000000 10909910704 11347918848 1954090624 19.259 100 36 72 0 1972331376 7723584 10517168
21:38:59 35459 8192000000 10901670128 11364319232 1965990272 19.354 100 36 72 1 1985887344 10069136 9827936
21:39:41 48299 8192000000 10887257328 11348951040 1897374016 18.805 96 26 52 0 1919866784 14947552 7545216
21:40:37 28792 8192000000 10880042048 11346968576 1936178208 19.116 99 20 40 0 1956524256 14500512 5845536
21:41:12 60237 8192000000 10889593024 11358273536 1933803776 19.097 99 13 25 1 1958906000 21233392 3868832
21:42:33 77371 8192000000 10883763152 11325337600 1842368224 18.360 94 24 48 0 1859012864 9189024 7455616
21:43:57 51363 8192000000 10863114992 11317891072 1845168320 18.383 95 22 44 0 1861104800 9929344 6007136
21:44:54 70391 8192000000 10877360768 11336388608 1902129072 18.843 98 32 64 1 1921709824 11254672 8326080
21:46:17 34868 8192000000 10899140272 11354988544 1959618032 19.303 100 39 74 0 1980105696 10747312 9740352
21:48:10 94869 8192000000 10902266576 11345207296 1939578704 19.143 100 23 46 0 1959672496 13046544 7047248
21:50:22 88297 8192000000 10875336960 11348865024 1952224848 19.244 100 16 32 0 1970556144 13680752 4650544
21:52:17 73549 8192000000 10895786688 11362672640 1969409920 19.381 100 21 42 1 1984417664 9410736 5597008
21:53:46 80309 8192000000 10899329440 11377049600 1977002128 19.441 100 13 26 0 1988405632 7679456 3724048
21:55:15 60925 8192000000 10883014864 11363692544 1942177840 19.164 98 13 27 0 1953670352 6995440 4497072
21:57:01 79927 8192000000 10907509232 11372630016 1973212272 19.411 100 12 23 1 1986778240 10295472 3270496
21:58:27 94803 8192000000 10891944048 11359821824 1923247952 19.013 97 17 32 2 1938270144 10589120 4433072
22:00:37 39391 8192000000 10879435776 11358593024 1933022848 19.091 98 21 42 2 1946052560 7088544 5941168
22:01:28 46891 8192000000 10912332736 11379109888 1960011936 19.306 99 10 20 1 1968098816 5748448 2338432
22:02:27 38604 8192000000 10911105232 11393429504 1974008272 19.417 99 16 32 0 1990046304 11564736 4473296
22:03:12 77486 8192000000 10922842608 11383910400 1926880768 19.042 97 20 40 0 1941984912 9535568 5568576
22:04:39 45009 8192000000 10914394448 11365433344 1934878176 19.106 97 26 52 2 1954682560 12031936 7772448
22:05:31 54612 8192000000 10871731504 11333640192 1872156672 18.602 94 42 84 2 1897327248 13015392 12155184
22:06:41 24449 8192000000 10898581328 11363336192 1963503344 19.334 100 21 42 0 1981267920 11318736 6445840
22:07:13 29830 8192000000 10897290512 11361538048 1932129264 19.084 98 26 52 6 1953509024 13974144 7405616
22:07:59 70520 8192000000 10911358256 11377209344 1955105056 19.267 99 21 42 1 1980750848 19439904 6205888
22:09:52 167904 8192000000 10885840928 11352563712 1860645088 18.509 94 7 14 0 1878997792 16656144 1696560
22:12:48 26995 8192000000 10884809376 11338469376 1897584752 18.807 97 29 58 1 1914943120 9466064 7892304
22:13:25 29244 8192000000 10898082768 11348828160 1931530544 19.079 99 44 88 2 1955315536 11841952 11943040
22:14:03 23164 8192000000 10882264176 11325415424 1876471904 18.637 96 64 129 0 1906993984 11972464 18549616
22:14:34 26585 8192000000 10878409136 11317407744 1901553952 18.839 98 52 105 0 1926514800 11000656 13960192
22:15:08 130707 8192000000 10873833248 11321892864 1899114288 18.819 98 45 90 1 1921701632 10083472 12503872
22:17:25 40427 8192000000 10847392320 11320803328 1906702336 18.880 98 20 36 2 1925439168 12994528 5742304
22:18:11 26825 8192000000 10836133552 11305533440 1879481344 18.661 97 14 28 0 1902664624 19647872 3535408
22:18:44 54421 8192000000 10844783760 11315826688 1925479408 19.031 100 11 22 0 1938672464 9920560 3272496
22:19:59 59433 8192000000 10836506736 11316457472 1892951072 18.770 98 9 18 0 1907243328 11517152 2775104
22:21:04 65060 8192000000 10852775536 11323604992 1909871024 18.906 99 18 33 0 1929078800 14712272 4495504
22:22:20 87035 8192000000 10868444304 11320623104 1872163936 18.602 97 15 30 1 1886020128 9668576 4187616
22:23:53 107864 8192000000 10845354528 11309723648 1805379712 18.058 93 17 34 0 1818305488 8237072 4688704
22:26:01 43502 8192000000 10868838608 11323375616 1900355232 18.829 98 24 48 0 1917441184 10175616 6910336
22:26:55 18887 8192000000 9202898464 9457188864 357407632 4.180 19 4 6 1 367534128 9011552 1114944

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 26-11-2020 22:28:26 to 26-11-2020 22:28:57.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 26-11-2020 22:28:58 to 26-11-2020 22:29:00.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          246752
MON$OLDEST_ACTIVE               247375
MON$OLDEST_SNAPSHOT             247375
MON$NEXT_TRANSACTION            247375
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 ---
:263: 
:264: mscs-test-161.budzdorov.ru    Thu Nov 26 22:27:23 2020
:265:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:266: 
--- end of diff output ---

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

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