Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 11.12.2020 19: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 17632200 kB
MemAvailable 31588308 kB
Buffers 0 kB
Cached 14094884 kB
SwapCached 3708 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-12-11 19:27:05
DTS_END                         2020-12-11 19:27:05.9200
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/59270
TRN_ID                          242662
ATT_ID                          647
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: 9522.64 20175 1142717
customer order: creation 170.50 358 20460
customer order: refuse 14.66 244 1759
order to supplier: creation 45.41 1122 5449
order to supplier: removal 3.53 86984 423
invoice (draft): creation 46.59 2708 5591
invoice (draft): removal 54.76 604 6571
invoice accept: apply 42.51 16830 5101
invoice accept: cancel 49.98 632 5998
customer reserve: creation 3920.07 169 470408
customer reserve: removal 4876.73 50 585207
realization accept: apply 83.62 144 10034
realization accept: cancel 84.08 95 10089
payment from customer: creation 59.76 93 7171
payment from customer: removal 5.80 46 696
payment to supplier: creation 48.61 106 5833
payment to supplier: removal 3.77 78 452
service: total inventory turnovers 4.89 1040 587
service: total monetary turnovers 6.43 53 772
service: aggregate perf. data 0.93 15159 112
service: refresh index statistics 0.03 276980 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 11-12-2020 19:28:40 to 11-12-2020 19:28:43.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7013
TEST_TIME 2 6220
TEST_TIME 3 6159
TEST_TIME 4 6296
TEST_TIME 5 6518
TEST_TIME 6 6778
TEST_TIME 7 6596
TEST_TIME 8 6572
TEST_TIME 9 6601
TEST_TIME 10 6904
TEST_TIME 11 7366
TEST_TIME 12 7487
TEST_TIME 13 8419
TEST_TIME 14 8311
TEST_TIME 15 8850
TEST_TIME 16 9797
TEST_TIME 17 9866
TEST_TIME 18 10058
TEST_TIME 19 10662
TEST_TIME 20 11249
TEST_TIME 21 12332
TEST_TIME 22 12342
TEST_TIME 23 12456
TEST_TIME 24 12267
TEST_TIME 25 11834
TEST_TIME 26 11860
TEST_TIME 27 11672
TEST_TIME 28 11621
TEST_TIME 29 11513
TEST_TIME 30 11448
TEST_TIME 31 11247
TEST_TIME 32 11082
TEST_TIME 33 11088
TEST_TIME 34 10989
TEST_TIME 35 10733
TEST_TIME 36 10763
TEST_TIME 37 10659
TEST_TIME 38 10650
TEST_TIME 39 10499
TEST_TIME 40 10442
TEST_TIME 41 10409
TEST_TIME 42 10408
TEST_TIME 43 10320
TEST_TIME 44 10374
TEST_TIME 45 10482
TEST_TIME 46 10454
TEST_TIME 47 10488
TEST_TIME 48 10431
TEST_TIME 49 10377
TEST_TIME 50 10497
TEST_TIME 51 10380
TEST_TIME 52 10206
TEST_TIME 53 10213
TEST_TIME 54 10112
TEST_TIME 55 10074
TEST_TIME 56 9972
TEST_TIME 57 9956
TEST_TIME 58 9864
TEST_TIME 59 9809
TEST_TIME 60 9815
TEST_TIME 61 9764
TEST_TIME 62 9892
TEST_TIME 63 9963
TEST_TIME 64 9938
TEST_TIME 65 9922
TEST_TIME 66 10045
TEST_TIME 67 10030
TEST_TIME 68 10032
TEST_TIME 69 9985
TEST_TIME 70 10030
TEST_TIME 71 10062
TEST_TIME 72 10076
TEST_TIME 73 10031
TEST_TIME 74 9987
TEST_TIME 75 9941
TEST_TIME 76 9928
TEST_TIME 77 9868
TEST_TIME 78 9840
TEST_TIME 79 9786
TEST_TIME 80 9766
TEST_TIME 81 9712
TEST_TIME 82 9757
TEST_TIME 83 9690
TEST_TIME 84 9698
TEST_TIME 85 9669
TEST_TIME 86 9692
TEST_TIME 87 9736
TEST_TIME 88 9800
TEST_TIME 89 9790
TEST_TIME 90 9816
TEST_TIME 91 9876
TEST_TIME 92 9867
TEST_TIME 93 9904
TEST_TIME 94 9890
TEST_TIME 95 9917
TEST_TIME 96 9903
TEST_TIME 97 9891
TEST_TIME 98 9820
TEST_TIME 99 9756
TEST_TIME 100 9735
TEST_TIME 101 9682
TEST_TIME 102 9632
TEST_TIME 103 9608
TEST_TIME 104 9597
TEST_TIME 105 9639
TEST_TIME 106 9620
TEST_TIME 107 9580
TEST_TIME 108 9636
TEST_TIME 109 9618
TEST_TIME 110 9648
TEST_TIME 111 9673
TEST_TIME 112 9689
TEST_TIME 113 9729
TEST_TIME 114 9697
TEST_TIME 115 9696
TEST_TIME 116 9715
TEST_TIME 117 9724
TEST_TIME 118 9661
TEST_TIME 119 9604
TEST_TIME 120 9528

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 11-12-2020 19:28:44 to 11-12-2020 19:28:47.

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 1578139 1578139 0 0.00 0 12466 6 0 0
doc_list_biud 1578137 1578137 0 0.00 0 19757 23 0 0
sp_add_invoice_to_stock 5207 5101 106 2.03 38 216365 16831 0 106
sp_cancel_adding_invoice 5998 5998 0 0.00 4 53962 632 0 0
sp_cancel_client_order 1759 1759 0 0.00 4 16178 245 0 0
sp_cancel_customer_reserve 585207 585207 0 0.00 1 19765 51 0 0
sp_cancel_pay_from_customer 696 696 0 0.00 2 2501 46 0 0
sp_cancel_pay_to_supplier 452 452 0 0.00 3 6351 78 0 0
sp_cancel_supplier_invoice 6582 6571 11 0.16 2 12765 604 0 11
sp_cancel_supplier_order 423 423 0 0.00 8 804891 86984 0 0
sp_cancel_write_off 10089 10089 0 0.00 1 10410 96 0 0
sp_client_order 20460 20460 0 0.00 4 13804 358 0 0
sp_customer_reserve 470408 470408 0 0.00 0 189178 170 0 0
sp_fill_shopping_cart 31497 31497 0 0.00 1 15990 32 0 0
sp_fill_shopping_cart_clo_res 470398 470398 0 0.00 0 16160 13 0 0
sp_get_clo_for_invoice 5091 5091 0 0.00 0 26990 312 0 0
sp_kill_cost_storno 17235 17235 0 0.00 0 4905 40 0 0
sp_kill_qstorno_ret_qs2qd 1187497 1187497 0 0.00 0 19240 27 0 0
sp_kill_qty_storno 625171 625171 0 0.00 0 19756 58 0 0
sp_lock_selected_doc 20970 20970 0 0.00 0 6019 4 0 0
sp_make_cost_storno 28128 28128 0 0.00 0 12442 42 0 0
sp_multiply_rows_for_pdistr 28128 28128 0 0.00 0 6593 24 0 0
sp_multiply_rows_for_qdistr 20460 20460 0 0.00 0 13014 182 0 0
sp_pay_from_customer 7171 7171 0 0.00 4 9278 94 0 0
sp_pay_to_supplier 5833 5833 0 0.00 4 10871 106 0 0
sp_payment_common 13004 13004 0 0.00 1 9271 22 0 0
sp_qd_handle_on_cancel_clo 1759 1759 0 0.00 0 16171 214 0 0
sp_qd_handle_on_invoice_upd_sts 11088 11088 0 0.00 0 16501 240 0 0
sp_qd_handle_on_reserve_upd_sts 10034 10034 0 0.00 0 11610 42 0 0
sp_reserve_write_off 10034 10034 0 0.00 6 11679 145 0 0
sp_supplier_invoice 5591 5591 0 0.00 6 91032 2709 0 0
sp_supplier_order 5449 5449 0 0.00 5 30569 1123 0 0
srv_aggregate_perf_data 113 112 1 0.88 2643 99721 15160 0 1
srv_fill_mon_cache_memory 141 141 0 0.00 1796 161593 39752 0 0
srv_find_qd_qs_mism 1094581 1094581 0 0.00 0 11540 5 0 0
srv_make_invnt_saldo 587 587 0 0.00 30 75645 1040 0 0
srv_make_money_saldo 772 772 0 0.00 1 24239 53 0 0
srv_recalc_idx_stat 4 4 0 0.00 144383 505600 276981 0 0
t$perf-abend:sp_add_invoice_to_stock 106 106 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 5101 5101 0 0.00 0 9561 118 0 0
t$perf-norm:sp_cancel_adding_invoice 443 443 0 0.00 0 3482 63 0 0
t$perf-norm:sp_cancel_client_order 1759 1759 0 0.00 0 6410 17 0 0
t$perf-norm:sp_cancel_customer_reserve 678 678 0 0.00 0 2599 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 696 696 0 0.00 0 2286 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 452 452 0 0.00 0 2040 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 386 386 0 0.00 0 298 8 0 0
t$perf-norm:sp_cancel_supplier_order 423 423 0 0.00 0 12662 1277 0 0
t$perf-norm:sp_cancel_write_off 1009 1009 0 0.00 0 9591 18 0 0
t$perf-norm:sp_client_order 20460 20460 0 0.00 0 6969 16 0 0
t$perf-norm:sp_customer_reserve 995 995 0 0.00 0 2795 6 0 0
t$perf-norm:sp_pay_from_customer 7171 7171 0 0.00 0 6634 10 0 0
t$perf-norm:sp_pay_to_supplier 5833 5833 0 0.00 0 5079 6 0 0
t$perf-norm:sp_reserve_write_off 10034 10034 0 0.00 0 6643 10 0 0
t$perf-norm:sp_supplier_invoice 5591 5591 0 0.00 0 7595 12 0 0
t$perf-norm:sp_supplier_order 5449 5449 0 0.00 0 8336 14 0 0
t$perf-norm:srv_aggregate_perf_data 112 112 0 0.00 0 384 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 141 141 0 0.00 0 254 3 0 0
t$perf-norm:srv_make_invnt_saldo 587 587 0 0.00 0 4218 18 0 0
t$perf-norm:srv_make_money_saldo 772 772 0 0.00 0 1798 7 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10390 10178 212 2.04 0 3852 15 0 212
v_all_customers 37326 37326 0 0.00 0 21 0 0 0
v_all_suppliers 30472 30472 0 0.00 0 22 1 0 0
v_all_wares 40920 40920 0 0.00 0 25 1 0 0
v_cancel_adding_invoice 886 886 0 0.00 0 4383 13 0 0
v_cancel_client_order 3518 3518 0 0.00 0 4265 8 0 0
v_cancel_customer_prepayment 1392 1392 0 0.00 0 1898 5 0 0
v_cancel_customer_reserve 1356 1356 0 0.00 0 5016 9 0 0
v_cancel_payment_to_supplier 904 904 0 0.00 0 6341 22 0 0
v_cancel_supplier_invoice 794 772 22 2.77 0 4940 19 0 22
v_cancel_supplier_order 846 846 0 0.00 0 4268 13 0 0
v_cancel_write_off 2018 2018 0 0.00 0 1124 13 0 0
v_max_id_clo_ord 5447 5447 0 0.00 0 942 1 0 0
v_max_id_clo_res 995 995 0 0.00 0 1447 11 0 0
v_max_id_ord_sup 5589 5589 0 0.00 0 5115 5 0 0
v_max_non_paid_invoice 1633 1633 0 0.00 0 4740 5 0 0
v_max_non_paid_realizn 3809 3809 0 0.00 0 1641 4 0 0
v_min_id_clo_ord 5447 5447 0 0.00 0 3047 7 0 0
v_min_id_clo_res 995 995 0 0.00 0 5127 12 0 0
v_min_id_ord_sup 5589 5589 0 0.00 0 4521 6 0 0
v_min_non_paid_invoice 5833 5833 0 0.00 0 3090 10 0 0
v_min_non_paid_realizn 7171 7171 0 0.00 0 9266 15 0 0
v_our_firm 10318 10318 0 0.00 0 12 1 0 0
v_reserve_write_off 20068 20068 0 0.00 0 4546 8 0 0
x_lock_depdocs_on_canc_invoice 12183 12183 0 0.00 0 17139 106 0 0
x_lock_depdocs_on_canc_sup_ord 423 423 0 0.00 0 7239 270 0 0
x_make_qstorno_1000_1200 5449 5449 0 0.00 1 30565 1061 0 0
x_make_qstorno_1200_2000 5591 5591 0 0.00 3 91024 2596 0 0
x_make_qstorno_2100_3300 470408 470408 0 0.00 0 182643 155 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-12-2020 19:28:48 to 11-12-2020 19:28:52.

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
16:57:09 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:15 15993 8192000000 10261454688 10570850304 838287632 9.283 64 49 96 0 855630416 2175968 15166816
16:57:40 34354 8192000000 10358342000 10674778112 1395789344 14.557 100 87 174 0 1432997536 9372688 27835504
16:58:26 32784 8192000000 10389887536 10715406336 1436351792 14.917 100 89 178 0 1472349920 7027136 28970992
16:59:12 21891 8192000000 10416706352 10742808576 1469782624 15.212 100 92 184 1 1508115776 8361040 29972112
16:59:45 9066 8192000000 10426203968 10757992448 1479621952 15.298 100 88 176 0 1517604032 8781680 29200400
17:00:03 27092 8192000000 10443115184 10777882624 1494143632 15.425 100 90 180 0 1532431456 9232032 29055792
17:00:42 17048 8192000000 10471494720 10805989376 1515039968 15.607 100 89 178 1 1554029616 10344816 28644832
17:01:15 13477 8192000000 10488829456 10831634432 1537618384 15.803 100 76 152 0 1571926576 10427744 23880448
17:01:42 15687 8192000000 10520063712 10872655872 1572757264 16.106 100 82 164 1 1608674720 10327712 25589744
17:02:04 10889 8192000000 10543310128 10899169280 1600608176 16.345 100 76 152 0 1634017344 10026160 23383008
17:02:23 10739 8192000000 10578122448 10936369152 1626081728 16.562 100 73 146 1 1659479344 10536048 22861568
17:02:42 10979 8192000000 10594510400 10957479936 1648847152 16.755 100 80 160 1 1685238736 11923296 24468288
17:03:02 12007 8192000000 10609783680 10980220928 1667680576 16.914 100 66 132 0 1698908768 11322272 19905920
17:03:26 7331 8192000000 10627887296 11001757696 1692743856 17.124 100 73 146 0 1726474432 12613808 21116768
17:03:41 6841 8192000000 10661684928 11032743936 1721340208 17.363 100 84 168 1 1758348144 13334704 23673232
17:03:56 6270 8192000000 10671822256 11047854080 1732919056 17.460 100 72 144 1 1766064928 12710656 20435216
17:04:10 7349 8192000000 10685855424 11063214080 1750677440 17.607 100 71 142 2 1783135760 12781760 19676560
17:04:29 5910 8192000000 10703839616 11082711040 1765283360 17.728 100 73 146 0 1798117952 12662480 20172112
17:04:43 4039 8192000000 10713472560 11096727552 1777558224 17.829 100 78 155 1 1812135232 12851056 21725952
17:04:54 3114 8192000000 10731541840 11107000320 1787280576 17.909 100 83 163 2 1822538000 12624240 22633184
17:05:04 3765 8192000000 10737694912 11117834240 1796041312 17.981 100 83 166 1 1833319216 13715760 23562144
17:05:14 4396 8192000000 10718947024 11114414080 1793505984 17.961 100 68 134 2 1825585280 13617680 18461616
17:05:26 2302 8192000000 10744644688 11134140416 1803475392 18.042 100 77 154 0 1837839712 12778960 21585360
17:05:36 2851 8192000000 10767833104 11150757888 1823043680 18.203 100 91 182 0 1862156832 13182880 25930272
17:05:45 2623 8192000000 10774241392 11159408640 1834465808 18.296 100 88 176 1 1872181456 13325488 24390160
17:05:54 3029 8192000000 10777454992 11165839360 1837851952 18.323 100 83 163 1 1872952576 12168736 22931888
17:06:05 2585 8192000000 10782561008 11172806656 1841065584 18.349 100 80 157 1 1875236976 12339216 21832176
17:06:14 1382 8192000000 10786471376 11171475456 1843619888 18.370 100 81 159 1 1879076432 13050720 22405824
17:06:22 2123 8192000000 10798912368 11185274880 1848213472 18.408 100 86 171 2 1885733952 13857584 23662896
17:06:31 1906 8192000000 10798237760 11184697344 1856141840 18.472 100 92 184 2 1896780176 15324320 25314016
17:06:39 1912 8192000000 10797313648 11185954816 1856669856 18.476 100 89 179 1 1895568576 14710768 24187952
17:06:47 1649 8192000000 10805060304 11192668160 1857565056 18.484 100 92 185 2 1897402176 14059648 25777472
17:06:55 1661 8192000000 10803859264 11192537088 1861933632 18.519 100 94 188 1 1901706400 13261024 26511744
17:07:03 1439 8192000000 10801961616 11194621952 1866218304 18.554 100 87 171 1 1902524272 11834032 24471936
17:07:11 1435 8192000000 10804880064 11196989440 1867320864 18.563 100 92 185 1 1905191984 11926176 25944944
17:07:19 39063 8192000000 10783717152 11194847232 1859793456 18.502 100 48 94 2 1882353856 8600656 13959744
17:08:05 4251 8192000000 10787214816 11201343488 1866809552 18.558 100 34 68 0 1884820160 8198736 9811872
17:08:17 3978 8192000000 10780214944 11204603904 1867434544 18.564 100 33 66 3 1885016480 7664400 9917536
17:08:28 6475 8192000000 10794606928 11209375744 1870027984 18.585 100 29 58 0 1884652624 7004240 7620400
17:08:41 5673 8192000000 10787591552 11209830400 1874369296 18.620 100 41 83 0 1894931664 8521280 12041088
17:08:53 9856 8192000000 10785035600 11208888320 1872689728 18.606 100 31 63 2 1888763488 7876336 8197424
17:09:09 7947 8192000000 10787012928 11212595200 1879088032 18.658 100 27 54 0 1893640208 6804784 7747392
17:09:26 8591 8192000000 10785202528 11215491072 1878896272 18.656 100 31 62 2 1893701360 6272144 8532944
17:09:41 8890 8192000000 10781332912 11218444288 1880919440 18.673 100 18 36 0 1892428192 6387376 5121376
17:09:57 5254 8192000000 10792752224 11222298624 1883720080 18.695 100 27 54 2 1897802704 5928816 8153808
17:10:08 7312 8192000000 10789584896 11223490560 1882458624 18.685 100 19 38 1 1894823408 6310896 6053888
17:10:25 10410 8192000000 10788833888 11223691264 1886263008 18.716 100 13 26 1 1896157264 5816096 4078160
17:10:41 12241 8192000000 10792952128 11229683712 1889267584 18.740 100 20 38 2 1900957264 6595792 5093888
17:11:00 11892 8192000000 10811049472 11234701312 1893338608 18.773 100 35 69 3 1909911536 5707760 10865168
17:11:21 64029 8192000000 10806154784 11239653376 1890904832 18.753 100 17 34 0 1900895648 4745472 5245344
17:12:31 6813 8192000000 10801018048 11241136128 1893717584 18.776 100 26 51 2 1906714656 5978000 7019072
17:12:47 5824 8192000000 10814182288 11248570368 1898811600 18.817 100 37 73 0 1916195520 7145744 10238176
17:13:03 4284 8192000000 10816232048 11250110464 1897818272 18.809 100 25 49 0 1910466832 5973440 6675120
17:13:13 8226 8192000000 10819757008 11254013952 1898761040 18.816 100 23 46 0 1915199088 10410752 6027296
17:13:29 6055 8192000000 10821758336 11256299520 1902634032 18.847 100 27 54 2 1916579344 6188832 7756480
17:13:42 4863 8192000000 10821042720 11257032704 1907183200 18.884 100 30 58 0 1922088928 6477824 8427904
17:13:56 9049 8192000000 10820516016 11258621952 1905996400 18.874 100 17 34 0 1917040016 6027664 5015952
17:14:12 12862 8192000000 10825016400 11259039744 1909907232 18.906 100 17 34 0 1919975760 5077760 4990768
17:14:35 10580 8192000000 10828021360 11259408384 1890220176 18.748 99 21 42 1 1902157888 5356960 6580752
17:14:54 6278 8192000000 10818657744 11253133312 1889098688 18.739 99 25 50 1 1902796784 7030496 6667600
17:15:07 9302 8192000000 10796867776 11232825344 1846562896 18.394 97 21 42 1 1857381008 4967088 5851024
17:15:23 11610 8192000000 10803571648 11230265344 1864568832 18.540 99 16 32 1 1878705120 9279920 4856368
17:15:42 11844 8192000000 10824920848 11249090560 1891517952 18.758 100 20 40 1 1903227776 6077808 5632016
17:16:02 61948 8192000000 10801351280 11233173504 1870369792 18.587 99 35 71 0 1886819680 6414096 10035792
17:17:11 16723 8192000000 10792258944 11210539008 1815110016 18.138 96 22 43 2 1827913696 6183200 6620480
17:17:37 10048 8192000000 10769301136 11188629504 1760106528 17.685 94 29 57 1 1778505136 10093168 8305440
17:17:55 7575 8192000000 10746702368 11173376000 1806261664 18.065 98 23 46 1 1818562912 5662032 6639216
17:18:12 6948 8192000000 10708400112 11124260864 1719325104 17.347 94 31 62 1 1734656944 6625312 8706528
17:18:29 4457 8192000000 10707116000 11126226944 1753005808 17.626 97 24 48 0 1765098528 5093328 6999392
17:18:39 13407 8192000000 10701060400 11108974592 1668709488 16.922 92 29 55 2 1682108384 4930896 8468000
17:18:59 11439 8192000000 10692572048 11100778496 1725523744 17.398 97 26 50 1 1738684016 5583376 7576896
17:19:17 8612 8192000000 10690991888 11097313280 1697870560 17.167 95 20 41 0 1709484288 5747664 5866064
17:19:33 9795 8192000000 10686834016 11106316288 1745922336 17.568 98 20 40 0 1758396544 5917296 6556912
17:19:54 12411 8192000000 10691199008 11104092160 1674501136 16.971 93 19 38 0 1685465664 4946384 6018144
17:20:15 9446 8192000000 10705354256 11108171776 1730783808 17.442 97 22 43 1 1746607904 9494096 6330000
17:20:31 11646 8192000000 10699989280 11118247936 1755930256 17.651 98 15 30 0 1765954368 5145792 4878320
17:20:50 50171 8192000000 10740907456 11158810624 1809940416 18.095 100 28 56 0 1823528704 5408096 8180192
17:21:49 24012 8192000000 10741865024 11164504064 1809613264 18.093 99 18 36 0 1820181312 5457056 5110992
17:22:20 15683 8192000000 10751971376 11173826560 1833677552 18.289 100 18 36 0 1843525792 4994272 4853968
17:22:47 5500 8192000000 10764111136 11191435264 1848989168 18.414 100 32 64 1 1864094912 5676000 9429744
17:22:59 5167 8192000000 10759761408 11191087104 1853292000 18.449 100 29 59 0 1868336896 6855280 8189616
17:23:12 8282 8192000000 10773478480 11200937984 1856386736 18.474 100 24 48 2 1869289920 6746432 6156752
17:23:27 9910 8192000000 10782103200 11206955008 1862684256 18.525 100 24 48 2 1876258816 5237424 8337136
17:23:45 10027 8192000000 10784662272 11208900608 1862692048 18.525 100 19 36 0 1873364640 4987744 5684848
17:24:02 8587 8192000000 10780060352 11207901184 1864328320 18.538 100 17 34 1 1874382384 5600752 4453312
17:24:16 13002 8192000000 10788227248 11213582336 1868995840 18.576 100 19 38 1 1879894784 5253040 5645904
17:24:36 6946 8192000000 10799732336 11221901312 1872998304 18.609 100 16 32 0 1883623488 5341296 5283888
17:24:54 17875 8192000000 10794072432 11226066944 1877547280 18.645 100 11 22 1 1886254736 5284656 3422800
17:25:24 6419 8192000000 10796767920 11227791360 1879189312 18.659 100 11 22 0 1887731280 5436864 3105104
17:25:37 25725 8192000000 10804769888 11231694848 1884036080 18.698 100 22 45 2 1896569136 5523088 7009968
17:26:11 47759 8192000000 10785028736 11227246592 1884384080 18.700 100 25 50 0 1897307664 5216144 7707440
17:27:09 16456 8192000000 10829360128 11252101120 1903649952 18.856 100 34 69 2 1917391120 4411904 9329264
17:27:37 20539 8192000000 10853579856 11272105984 1919391904 18.982 100 45 87 2 1939298848 8078608 11828336
17:28:05 9071 8192000000 10861628672 11281686528 1924720864 19.025 100 49 98 0 1947197744 9193696 13283184
17:28:29 19604 8192000000 10864908544 11287617536 1930256624 19.069 100 48 93 1 1954198496 11325088 12616784
17:29:01 12532 8192000000 10880740576 11302023168 1941680848 19.160 100 54 106 1 1969975520 13585200 14709472
17:29:20 4407 8192000000 10888845728 11308183552 1944840496 19.185 100 55 108 1 1973738128 14162400 14735232
17:29:37 37960 8192000000 10872295904 11310759936 1948152160 19.212 100 48 92 1 1977083552 15610768 13320624
17:30:28 24535 8192000000 10893056800 11325124608 1956969296 19.282 100 38 76 0 1984880144 16684624 11226224
17:31:31 18315 8192000000 10906460800 11341393920 1966120528 19.355 100 40 78 0 1996104240 18613248 11370464
17:32:05 5179 8192000000 10907758816 11338547200 1962111712 19.323 100 54 106 1 2002944480 25656080 15176688
17:32:18 7391 8192000000 10916638912 11338887168 1963925296 19.337 100 50 100 1 2000260672 20837616 15497760
17:32:33 15979 8192000000 10920501968 11349237760 1973973712 19.417 100 61 122 1 2015946960 23399888 18573360
17:33:00 12391 8192000000 10913295104 11351506944 1975216160 19.427 100 43 85 0 2010098288 21317280 13564848
17:33:20 24396 8192000000 10932685232 11360518144 1983368432 19.491 100 46 93 0 2020374592 22500752 14505408
17:33:56 17129 8192000000 10923312112 11359551488 1967804960 19.368 99 33 66 1 1998708448 20690160 10213328
17:34:29 10804 8192000000 10916649088 11350847488 1968637792 19.375 99 43 84 2 2003986208 22440432 12907984
17:34:46 4623 8192000000 10939734704 11373588480 1989950544 19.543 100 57 112 0 2030621600 24641936 16029120
17:34:59 3819 8192000000 10962998016 11386380288 1997631696 19.604 100 60 117 1 2043927200 29009600 17285904
17:35:09 9926 8192000000 10949789472 11381661696 1998524976 19.611 100 62 123 0 2043917328 27080784 18311568
17:35:26 5150 8192000000 10930633872 11360817152 1977588912 19.446 99 56 112 1 2021658880 27400112 16669856
17:35:40 5237 8192000000 10950970400 11380576256 1992701664 19.565 100 56 112 2 2036464928 27072688 16690576
17:35:57 7817 8192000000 10964348384 11385675776 1997049760 19.599 100 60 118 1 2043510304 29802384 16658160
17:36:15 4878 8192000000 10976436304 11405225984 2010365008 19.704 100 69 137 1 2063889792 32469632 21055152
17:36:27 7364 8192000000 10970472576 11401818112 2008711344 19.691 100 64 127 2 2060856448 32925216 19219888
17:36:41 2964 8192000000 10965531136 11382992896 1979951648 19.464 99 72 138 0 2033733136 33182256 20599232
17:36:52 1795 8192000000 10981629280 11400359936 2005533344 19.666 100 80 156 2 2064397168 35309232 23554592
17:37:04 4251 8192000000 10983062704 11399356416 2005605856 19.667 100 80 158 1 2066031168 36534032 23891280
17:37:17 7330 8192000000 10979625040 11403624448 2006584480 19.675 100 68 136 0 2062991376 36130944 20275952
17:37:42 5177 8192000000 10971984608 11396947968 1982945728 19.488 99 65 130 0 2041152624 37938800 20268096
17:37:55 2627 8192000000 10975549392 11389874176 1991503568 19.556 100 72 142 3 2052424848 38664448 22256832
17:38:04 2451 8192000000 10965026320 11380940800 1970301776 19.388 98 79 155 4 2032519296 39162528 23054992
17:38:14 6955 8192000000 10975017008 11396034560 1997504512 19.603 100 80 161 1 2065047296 42631632 24911152
17:38:30 3164 8192000000 10973220496 11382161408 1988567232 19.532 100 89 178 1 2060610160 44243936 27798992
17:38:39 3336 8192000000 10977238544 11395850240 1995980496 19.591 100 81 161 0 2066829904 45694416 25154992
17:38:50 2433 8192000000 10988741216 11407822848 1999819648 19.621 100 72 146 0 2071724768 47386880 24518240
17:39:00 4365 8192000000 10976188032 11404296192 1996585888 19.596 100 73 147 0 2065438176 45808512 23043776
17:39:12 2377 8192000000 10983970992 11404808192 1990357648 19.547 100 75 149 2 2063094192 49313024 23423520
17:39:21 10746 8192000000 10991073840 11413798912 1998301760 19.609 100 67 134 1 2070531776 51184032 21045984
17:39:41 5114 8192000000 10991676992 11403440128 1985768096 19.510 99 76 150 3 2064074768 54228992 24077680
17:39:54 2637 8192000000 11001784224 11422982144 2002447024 19.642 100 75 150 0 2084438800 58127936 23863840
17:40:06 5418 8192000000 11009700768 11434258432 2012524752 19.721 100 79 155 1 2092788560 55315808 24948000
17:40:21 3008 8192000000 10988463952 11408297984 1976618992 19.438 99 76 152 1 2054759712 54336528 23804192
17:40:30 2506 8192000000 10968225376 11387510784 1972004592 19.401 99 80 161 0 2046148992 49014944 25129456
17:40:40 10412 8192000000 10956849056 11394269184 1972448352 19.405 100 46 92 0 2036802896 49114368 15240176
17:41:01 5213 8192000000 10975334096 11405611008 1994488432 19.579 100 61 122 0 2064664336 50248656 19927248
17:41:14 3296 8192000000 10986861808 11410579456 1992296832 19.562 100 65 130 1 2067927216 54313760 21316624
17:41:26 2895 8192000000 10982918464 11406352384 1990857984 19.551 100 67 133 3 2069335024 56480576 21996464
17:41:35 3696 8192000000 10979058928 11406508032 1985506432 19.508 100 60 119 2 2063770656 58550016 19714208
17:41:49 4871 8192000000 10985295808 11407310848 1985165664 19.506 100 70 140 1 2068552272 60321216 23065392
17:42:02 6785 8192000000 10984258544 11414298624 1985399872 19.507 100 51 101 1 2063349120 60645792 17303456
17:42:16 10025 8192000000 10954152512 11390730240 1971455648 19.397 99 44 88 2 2042081328 55630912 14994768
17:42:34 9217 8192000000 10969413584 11408445440 1980473520 19.468 100 45 90 2 2052896208 57077392 15345296
17:42:50 11111 8192000000 10959196880 11390914560 1937937072 19.130 98 52 104 0 2015663040 60005488 17720480
17:43:07 10540 8192000000 10939518640 11371655168 1950449664 19.230 100 41 82 0 2026278736 61378704 14450368
17:43:33 19161 8192000000 10927530592 11372662784 1937877424 19.130 99 32 64 2 1997584816 48574016 11133376
17:43:59 14834 8192000000 10926739568 11362975744 1937261408 19.125 99 38 76 1 1998608784 48923872 12423504
17:44:25 18645 8192000000 10917755648 11362926592 1930520704 19.071 99 31 61 1 1994054832 52591584 10942544
17:44:59 16561 8192000000 10908892768 11354664960 1906768256 18.881 98 31 60 1 1967680272 50574016 10338000
17:45:28 43842 8192000000 10879181616 11348500480 1918050496 18.971 99 28 56 1 1976546048 48896688 9598864
17:46:26 23416 8192000000 10896673984 11347304448 1925644512 19.032 100 19 38 1 1976378672 44304544 6429616
17:46:56 25161 8192000000 10881774400 11340091392 1902501408 18.846 99 18 36 1 1963692272 54486704 6704160
17:47:28 30492 8192000000 10873148480 11331010560 1896166096 18.795 99 15 30 1 1945575904 43582864 5826944
17:48:08 40678 8192000000 10846518912 11310596096 1860843744 18.510 97 15 31 0 1904103088 37866992 5392352
17:48:55 25799 8192000000 10837057776 11284111360 1860655840 18.509 97 23 46 1 1879701856 11954368 7091648
17:49:27 58467 8192000000 10860430096 11320029184 1913056320 18.931 100 13 26 1 1933964832 16935984 3972528
17:50:33 81690 8192000000 10853216880 11299905536 1842869328 18.364 96 18 36 0 1871395328 23582592 4943408
17:52:04 78874 8192000000 10857642912 11302293504 1877287616 18.643 98 34 68 0 1906480384 18115360 11077408
17:53:30 50764 8192000000 10841754288 11298181120 1871331200 18.595 98 19 37 0 1892890624 16123968 5435456
17:54:45 131657 8192000000 10804481152 11269115904 1815633008 18.142 95 8 16 1 1832823936 14972192 2218736
17:57:03 148735 8192000000 10842787472 11302940672 1888046176 18.730 98 20 40 0 1908194256 14972672 5175408
17:59:38 157817 8192000000 10844751088 11290677248 1819031552 18.170 94 12 24 0 1832451888 10424752 2995584
18:02:38 37286 8192000000 10845072320 11302825984 1920496208 18.991 100 22 44 0 1939326656 12625072 6205376
18:03:22 23860 8192000000 10847139968 11314774016 1924598512 19.024 100 7 14 0 1940068400 13618976 1850912
18:03:56 53795 8192000000 10826657664 11295797248 1870263520 18.586 97 4 8 1 1882950464 12095136 591808
18:05:33 71404 8192000000 10899008608 11340410880 1950778336 19.233 100 31 60 2 1969891728 9829056 9284336
18:06:52 25615 8192000000 10860142832 11317583872 1907189568 18.884 98 26 53 4 1921952720 7803856 6959296
18:07:25 34294 8192000000 10884188704 11333541888 1947736320 19.208 100 39 75 2 1966487760 7209840 11541600
18:08:06 23815 8192000000 10891122768 11344752640 1961069216 19.315 100 44 88 0 1983548016 10554784 11924016
18:08:43 76722 8192000000 10909812704 11359473664 1961137280 19.315 100 26 51 2 1983377088 14583168 7656640
18:10:10 27536 8192000000 10904004912 11358613504 1970342448 19.388 100 21 42 0 1984898400 8515696 6040256
18:10:51 24759 8192000000 10902729680 11357835264 1938145232 19.132 98 41 79 1 1961720928 12299040 11276656
18:11:27 51674 8192000000 10899180896 11359268864 1947341248 19.205 99 30 59 4 1970484720 14486688 8656784
18:13:27 74059 8192000000 10896374496 11367485440 1950987248 19.234 99 12 24 1 1963107456 8887216 3232992
18:14:47 55945 8192000000 10920222560 11367456768 1941551344 19.159 98 26 52 0 1957843840 8361072 7931424
18:15:53 59850 8192000000 10928836480 11383689216 1982442032 19.484 100 27 54 1 2001314096 11475552 7396512
18:17:01 161593 8192000000 10932830864 11375423488 1968521296 19.374 99 27 54 1 1990967728 14007792 8438640
18:19:56 71636 8192000000 10896526640 11366555648 1928378384 19.054 97 24 48 0 1948550304 13728592 6443328
18:21:20 24940 8192000000 10888663120 11362709504 1966981664 19.361 100 15 30 0 1984340272 13444592 3914016
18:21:52 34540 8192000000 10899324608 11362451456 1940360896 19.150 98 33 66 0 1959117424 8417520 10339008
18:22:39 62069 8192000000 10884171376 11358244864 1932791312 19.089 98 13 26 1 1944292128 8101584 3399232
18:23:50 66642 8192000000 10857161424 11338698752 1886480064 18.717 96 6 12 0 1895509392 7657792 1371536
18:25:04 76604 8192000000 10862746144 11333738496 1936278400 19.117 99 17 34 2 1947591856 6629040 4684416
18:26:28 70968 8192000000 10870735776 11351732224 1901754944 18.840 97 6 12 0 1915397488 11789472 1853072
18:27:49 21886 8192000000 10891195584 11353030656 1915529360 18.951 97 39 79 2 1939922096 13600368 10792368
18:28:29 62112 8192000000 10896985568 11363155968 1950438928 19.230 99 24 48 1 1969283664 12106096 6738640
18:29:37 68763 8192000000 10859299376 11333562368 1860216928 18.505 95 10 20 1 1879059072 16261696 2580448
18:30:52 55407 8192000000 10880481216 11355381760 1896022576 18.794 97 11 22 2 1909497280 10623952 2850752
18:31:54 32130 8192000000 10896631104 11348967424 1949910128 19.226 100 18 36 1 1966816080 11584208 5321744
18:32:34 51720 8192000000 10841307440 11307540480 1814360944 18.132 93 25 50 0 1843919456 22502240 7056272
18:33:33 57731 8192000000 10842419600 11313291264 1884446064 18.701 98 15 29 0 1897491840 9381328 3664448
18:34:38 37227 8192000000 10881147408 11312558080 1887166864 18.723 97 42 84 0 1907360880 7801280 12392736
18:35:24 20345 8192000000 10861887456 11308158976 1866564016 18.556 96 49 98 0 1891294320 11428208 13302096
18:35:52 20971 8192000000 10856765920 11309252608 1908477504 18.894 99 30 60 2 1927366080 10777632 8110944
18:36:22 24936 8192000000 10890466960 11328274432 1920653360 18.992 99 58 116 0 1948703216 11385200 16664656
18:36:59 16322 8192000000 10857092848 11293671424 1893387872 18.773 98 53 106 2 1921328112 13237264 14702976
18:37:28 40475 8192000000 10880089488 11323899904 1897337712 18.805 98 39 78 0 1924336864 16314928 10684224
18:38:14 134040 8192000000 10851987280 11309473792 1796039008 17.981 93 26 52 1 1818827840 16112752 6676080
18:40:39 81274 8192000000 10857309648 11312607232 1908049696 18.891 99 29 58 2 1925578224 9693360 7835168
18:42:18 97870 8192000000 10845926000 11308265472 1861677728 18.517 96 30 60 1 1879046368 8534592 8834048
18:45:08 63317 8192000000 10832052192 11298668544 1883260336 18.691 97 13 26 0 1893028192 6268032 3499824
18:46:18 57623 8192000000 10843618928 11321815040 1933896624 19.098 100 10 20 0 1944517968 7890864 2730480
18:47:22 69826 8192000000 10861737680 11332182016 1902183248 18.844 98 13 26 1 1913889936 7921968 3784720
18:49:19 79475 8192000000 10856657472 11342761984 1905680784 18.872 98 4 8 0 1916503616 9562368 1260464
18:50:44 69337 8192000000 10872278976 11338960896 1905974256 18.874 98 20 39 1 1921129872 9256528 5899088
18:52:18 65938 8192000000 10888866720 11367882752 1955614864 19.271 100 24 48 1 1978755136 16247792 6892480
18:53:32 92891 8192000000 10899164480 11379687424 1945712416 19.192 99 17 34 0 1968196912 17626976 4857520
18:55:11 84593 8192000000 10891045088 11375865856 1940049520 19.147 99 13 26 0 1961391680 17415440 3926720
18:56:56 49270 8192000000 10891908032 11365814272 1948692896 19.216 99 21 42 1 1966294960 11711760 5890304
18:57:56 82002 8192000000 10915333712 11372634112 1900882816 18.833 96 12 24 2 1917959056 13668736 3407504
18:59:24 87730 8192000000 10908960464 11369656320 1914738272 18.945 97 13 24 2 1931128544 13664880 2725392
19:00:58 43525 8192000000 10927800816 11380805632 1980904256 19.472 100 22 44 0 1995930128 8886480 6139392
19:01:48 34814 8192000000 10934319856 11394854912 1995732912 19.589 100 44 88 1 2018883904 10654816 12496176
19:02:36 91177 8192000000 10927675152 11402067968 1975154848 19.426 99 23 46 1 1993076192 11920672 6000672
19:04:39 119806 8192000000 10907003504 11381919744 1969205280 19.379 99 24 48 1 1987727296 9994784 8527232
19:06:54 38603 8192000000 10894316272 11374858240 1962550896 19.326 99 8 16 0 1975926096 11406928 1968272
19:07:45 22096 8192000000 10920323744 11393159168 1991352304 19.554 100 22 45 0 2005562256 7609712 6600240
19:08:20 82568 8192000000 10914123824 11393372160 1978210560 19.451 99 10 20 0 1992877872 11566480 3100832
19:09:57 60356 8192000000 10914505216 11398811648 1979310064 19.459 99 11 22 1 1997204480 14364272 3530144
19:11:16 72394 8192000000 10876945040 11366096896 1913397200 18.934 96 15 30 1 1931288448 13403280 4487968
19:12:36 58861 8192000000 10896889328 11366707200 1904778032 18.865 96 21 41 0 1922939760 11740448 6421280
19:13:42 55155 8192000000 10902564656 11376734208 1971233440 19.395 100 21 42 1 1988704336 11236304 6234592
19:14:44 77628 8192000000 10875212160 11350609920 1865378224 18.547 94 21 42 0 1886407136 14970448 6058464
19:16:08 79592 8192000000 10856078016 11336986624 1853825968 18.453 95 10 20 0 1875134720 18535200 2773552
19:17:34 48915 8192000000 10864978576 11308056576 1832944400 18.283 94 32 64 0 1852257776 10239216 9074160
19:18:30 59980 8192000000 10857053792 11331018752 1847179168 18.399 95 32 64 2 1874228016 18091456 8957392
19:19:36 97700 8192000000 10841750400 11312517120 1849970192 18.422 96 9 18 1 1863780032 11576096 2233744
19:21:28 36077 8192000000 10880220000 11317866496 1886154176 18.715 97 60 115 4 1911400016 8688864 16556976
19:22:13 39647 8192000000 10877657456 11326013440 1908845520 18.897 99 57 114 1 1936893648 11757776 16290352
19:23:05 75826 8192000000 10855285472 11322630144 1867530816 18.564 97 22 44 2 1887709024 14423408 5754800
19:24:30 95284 8192000000 10816109472 11291344896 1819672624 18.175 95 10 20 0 1834261712 12014896 2574192
19:26:20 51163 8192000000 10026897072 10404024320 1146767136 12.279 60 13 24 1 1164846656 15215520 2864000

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:29, from 11-12-2020 19:28:54 to 11-12-2020 19:29:23.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 106 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 11-12-2020 19:29:24 to 11-12-2020 19:29:26.

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          241932
MON$OLDEST_ACTIVE               243093
MON$OLDEST_SNAPSHOT             243093
MON$NEXT_TRANSACTION            243093
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                       2013824
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.33400 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33400 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33400 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33400 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 ---
:15: 
:16: mscs-test-161.budzdorov.ru    Fri Dec 11 19:27:14 2020
:17:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:18: 
:19: 
:20: mscs-test-161.budzdorov.ru    Fri Dec 11 19:27:15 2020
:21:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:22: 
--- end of diff output ---

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

11.12.20 19:29:27. 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-12-11 19:29:29 No severe PSQL-related problems occured
11.12.20 19:29:31. End of report.