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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
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.26
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 17436636 kB
MemAvailable 31661144 kB
Buffers 0 kB
Cached 14279044 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-05 22:27:19
DTS_END                         2021-03-05 22:27:19.9650
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/50096
TRN_ID                          238680
ATT_ID                          633
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: 9170.38 20799 1100445
customer order: creation 172.23 370 20668
customer order: refuse 14.74 314 1769
order to supplier: creation 45.07 1298 5408
order to supplier: removal 3.57 91996 428
invoice (draft): creation 47.06 3620 5647
invoice (draft): removal 51.98 845 6237
invoice accept: apply 42.11 17302 5053
invoice accept: cancel 46.94 891 5633
customer reserve: creation 3798.78 173 455853
customer reserve: removal 4657.17 55 558860
realization accept: apply 84.30 186 10116
realization accept: cancel 77.37 104 9284
payment from customer: creation 60.87 111 7304
payment from customer: removal 5.71 115 685
payment to supplier: creation 47.64 138 5717
payment to supplier: removal 3.11 80 373
service: total inventory turnovers 4.50 1300 540
service: total monetary turnovers 6.41 43 769
service: aggregate perf. data 0.81 19728 97
service: refresh index statistics 0.03 277316 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-03-2021 22:29:17 to 05-03-2021 22:29:19.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3989
TEST_TIME 2 4191
TEST_TIME 3 5455
TEST_TIME 4 6004
TEST_TIME 5 5980
TEST_TIME 6 5816
TEST_TIME 7 5583
TEST_TIME 8 5491
TEST_TIME 9 5289
TEST_TIME 10 5547
TEST_TIME 11 5462
TEST_TIME 12 5451
TEST_TIME 13 5636
TEST_TIME 14 6030
TEST_TIME 15 6179
TEST_TIME 16 6147
TEST_TIME 17 6431
TEST_TIME 18 6937
TEST_TIME 19 6963
TEST_TIME 20 7472
TEST_TIME 21 7516
TEST_TIME 22 7604
TEST_TIME 23 8161
TEST_TIME 24 8360
TEST_TIME 25 8821
TEST_TIME 26 9773
TEST_TIME 27 9725
TEST_TIME 28 10163
TEST_TIME 29 10345
TEST_TIME 30 10313
TEST_TIME 31 10401
TEST_TIME 32 10275
TEST_TIME 33 10059
TEST_TIME 34 10090
TEST_TIME 35 10033
TEST_TIME 36 9957
TEST_TIME 37 9809
TEST_TIME 38 9810
TEST_TIME 39 9727
TEST_TIME 40 9851
TEST_TIME 41 9757
TEST_TIME 42 9753
TEST_TIME 43 9673
TEST_TIME 44 9714
TEST_TIME 45 9553
TEST_TIME 46 9428
TEST_TIME 47 9431
TEST_TIME 48 9325
TEST_TIME 49 9386
TEST_TIME 50 9432
TEST_TIME 51 9435
TEST_TIME 52 9418
TEST_TIME 53 9507
TEST_TIME 54 9454
TEST_TIME 55 9465
TEST_TIME 56 9515
TEST_TIME 57 9521
TEST_TIME 58 9639
TEST_TIME 59 9712
TEST_TIME 60 9720
TEST_TIME 61 9774
TEST_TIME 62 9669
TEST_TIME 63 9563
TEST_TIME 64 9560
TEST_TIME 65 9532
TEST_TIME 66 9504
TEST_TIME 67 9460
TEST_TIME 68 9371
TEST_TIME 69 9393
TEST_TIME 70 9299
TEST_TIME 71 9323
TEST_TIME 72 9294
TEST_TIME 73 9253
TEST_TIME 74 9244
TEST_TIME 75 9242
TEST_TIME 76 9259
TEST_TIME 77 9237
TEST_TIME 78 9304
TEST_TIME 79 9293
TEST_TIME 80 9355
TEST_TIME 81 9401
TEST_TIME 82 9457
TEST_TIME 83 9509
TEST_TIME 84 9485
TEST_TIME 85 9536
TEST_TIME 86 9460
TEST_TIME 87 9425
TEST_TIME 88 9416
TEST_TIME 89 9409
TEST_TIME 90 9363
TEST_TIME 91 9332
TEST_TIME 92 9300
TEST_TIME 93 9280
TEST_TIME 94 9313
TEST_TIME 95 9284
TEST_TIME 96 9305
TEST_TIME 97 9286
TEST_TIME 98 9322
TEST_TIME 99 9376
TEST_TIME 100 9383
TEST_TIME 101 9381
TEST_TIME 102 9401
TEST_TIME 103 9359
TEST_TIME 104 9425
TEST_TIME 105 9450
TEST_TIME 106 9475
TEST_TIME 107 9470
TEST_TIME 108 9488
TEST_TIME 109 9413
TEST_TIME 110 9353
TEST_TIME 111 9388
TEST_TIME 112 9373
TEST_TIME 113 9360
TEST_TIME 114 9358
TEST_TIME 115 9333
TEST_TIME 116 9311
TEST_TIME 117 9304
TEST_TIME 118 9275
TEST_TIME 119 9226
TEST_TIME 120 9174

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 05-03-2021 22:29:20 to 05-03-2021 22:29:24.

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 1522600 1522600 0 0.00 0 20700 6 0 0
doc_list_biud 1522598 1522598 0 0.00 0 34072 26 0 0
sp_add_invoice_to_stock 5204 5053 151 2.90 42 169156 17302 0 151
sp_cancel_adding_invoice 5633 5633 0 0.00 4 94026 891 0 0
sp_cancel_client_order 1769 1769 0 0.00 4 7244 314 0 0
sp_cancel_customer_reserve 558860 558860 0 0.00 1 29076 55 0 0
sp_cancel_pay_from_customer 685 685 0 0.00 2 11284 116 0 0
sp_cancel_pay_to_supplier 373 373 0 0.00 3 3510 81 0 0
sp_cancel_supplier_invoice 6242 6237 5 0.08 1 21117 846 0 5
sp_cancel_supplier_order 428 428 0 0.00 7 1219902 91996 0 0
sp_cancel_write_off 9284 9284 0 0.00 1 8398 105 0 0
sp_client_order 20668 20668 0 0.00 3 24763 370 0 0
sp_customer_reserve 455853 455853 0 0.00 0 55138 173 0 0
sp_fill_shopping_cart 31706 31706 0 0.00 1 13536 41 0 0
sp_fill_shopping_cart_clo_res 455844 455844 0 0.00 0 20488 15 0 0
sp_get_clo_for_invoice 5043 5043 0 0.00 0 13538 294 0 0
sp_kill_cost_storno 15975 15975 0 0.00 0 6915 58 0 0
sp_kill_qstorno_ret_qs2qd 1133669 1133669 0 0.00 0 28939 30 0 0
sp_kill_qty_storno 597369 597369 0 0.00 0 34069 66 0 0
sp_lock_selected_doc 20876 20876 0 0.00 0 10824 6 0 0
sp_make_cost_storno 28180 28180 0 0.00 0 20694 56 0 0
sp_multiply_rows_for_pdistr 28179 28179 0 0.00 0 10415 34 0 0
sp_multiply_rows_for_qdistr 20668 20668 0 0.00 0 20155 186 0 0
sp_pay_from_customer 7304 7304 0 0.00 4 23173 111 0 0
sp_pay_to_supplier 5717 5717 0 0.00 5 23193 139 0 0
sp_payment_common 13021 13021 0 0.00 1 9812 27 0 0
sp_qd_handle_on_cancel_clo 1769 1769 0 0.00 0 7239 292 0 0
sp_qd_handle_on_invoice_upd_sts 10676 10676 0 0.00 0 34061 356 0 0
sp_qd_handle_on_reserve_upd_sts 10115 10115 0 0.00 0 22259 62 0 0
sp_reserve_write_off 10116 10116 0 0.00 6 22482 187 0 0
sp_supplier_invoice 5647 5647 0 0.00 6 98383 3621 0 0
sp_supplier_order 5408 5408 0 0.00 6 30768 1298 0 0
srv_aggregate_perf_data 98 97 1 1.02 2656 156564 19728 0 1
srv_fill_mon_cache_memory 164 164 0 0.00 908 151184 32156 0 0
srv_find_qd_qs_mism 1052952 1052952 0 0.00 0 19196 5 0 0
srv_make_invnt_saldo 540 540 0 0.00 42 48571 1300 0 0
srv_make_money_saldo 769 769 0 0.00 1 11028 43 0 0
srv_recalc_idx_stat 4 4 0 0.00 187959 426862 277316 0 0
t$perf-abend:sp_add_invoice_to_stock 151 151 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 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 5053 5053 0 0.00 0 11677 175 0 0
t$perf-norm:sp_cancel_adding_invoice 395 395 0 0.00 1 1742 72 0 0
t$perf-norm:sp_cancel_client_order 1769 1769 0 0.00 0 7656 20 0 0
t$perf-norm:sp_cancel_customer_reserve 690 690 0 0.00 0 4185 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 685 685 0 0.00 0 1594 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 373 373 0 0.00 0 10646 49 0 0
t$perf-norm:sp_cancel_supplier_invoice 407 407 0 0.00 0 690 14 0 0
t$perf-norm:sp_cancel_supplier_order 428 428 0 0.00 0 34864 1549 0 0
t$perf-norm:sp_cancel_write_off 971 971 0 0.00 0 3325 13 0 0
t$perf-norm:sp_client_order 20668 20668 0 0.00 0 11850 21 0 0
t$perf-norm:sp_customer_reserve 962 962 0 0.00 0 7160 19 0 0
t$perf-norm:sp_pay_from_customer 7304 7304 0 0.00 0 10049 12 0 0
t$perf-norm:sp_pay_to_supplier 5717 5717 0 0.00 0 10101 15 0 0
t$perf-norm:sp_reserve_write_off 10116 10116 0 0.00 0 11825 14 0 0
t$perf-norm:sp_supplier_invoice 5647 5647 0 0.00 0 7691 20 0 0
t$perf-norm:sp_supplier_order 5408 5408 0 0.00 0 5420 18 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 332 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 2825 40 0 0
t$perf-norm:srv_make_invnt_saldo 540 540 0 0.00 0 7038 47 0 0
t$perf-norm:srv_make_money_saldo 769 769 0 0.00 0 544 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10388 10086 302 2.90 0 16227 23 0 302
v_all_customers 37414 37414 0 0.00 0 120 1 0 0
v_all_suppliers 30256 30256 0 0.00 0 120 1 0 0
v_all_wares 41336 41336 0 0.00 0 119 1 0 0
v_cancel_adding_invoice 790 790 0 0.00 0 1399 9 0 0
v_cancel_client_order 3538 3538 0 0.00 0 1806 3 0 0
v_cancel_customer_prepayment 1370 1370 0 0.00 0 11253 18 0 0
v_cancel_customer_reserve 1380 1380 0 0.00 0 20671 20 0 0
v_cancel_payment_to_supplier 746 746 0 0.00 0 1364 7 0 0
v_cancel_supplier_invoice 824 814 10 1.21 0 20661 53 0 10
v_cancel_supplier_order 856 856 0 0.00 0 1622 9 0 0
v_cancel_write_off 1942 1942 0 0.00 0 5915 19 0 0
v_max_id_clo_ord 5408 5408 0 0.00 0 1266 2 0 0
v_max_id_clo_res 962 962 0 0.00 0 3566 17 0 0
v_max_id_ord_sup 5630 5630 0 0.00 0 4291 6 0 0
v_max_non_paid_invoice 1627 1627 0 0.00 0 793 3 0 0
v_max_non_paid_realizn 3958 3958 0 0.00 0 6824 6 0 0
v_min_id_clo_ord 5408 5408 0 0.00 0 11271 12 0 0
v_min_id_clo_res 962 962 0 0.00 0 1028 3 0 0
v_min_id_ord_sup 5630 5630 0 0.00 0 8892 13 0 0
v_min_non_paid_invoice 5717 5717 0 0.00 0 5625 15 0 0
v_min_non_paid_realizn 7304 7304 0 0.00 0 9806 18 0 0
v_our_firm 10614 10614 0 0.00 0 33 1 0 0
v_reserve_write_off 20230 20230 0 0.00 0 6497 5 0 0
x_lock_depdocs_on_canc_invoice 11463 11463 0 0.00 0 19651 111 0 0
x_lock_depdocs_on_canc_sup_ord 428 428 0 0.00 0 7518 336 0 0
x_make_qstorno_1000_1200 5408 5408 0 0.00 1 30739 1210 0 0
x_make_qstorno_1200_2000 5647 5647 0 0.00 3 95773 3478 0 0
x_make_qstorno_2100_3300 455851 455851 0 0.00 0 43295 155 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-03-2021 22:29:25 to 05-03-2021 22:29:29.

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:23 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:30 24196 8192000000 10258354544 10567307264 960093216 10.490 74 53 106 0 980408992 2719488 17596288
19:58:03 26293 8192000000 10331333040 10649423872 1378771696 14.406 100 83 166 0 1410992432 4955856 27264880
19:58:39 25882 8192000000 10378804368 10700398592 1424235104 14.810 100 81 162 0 1457379264 6368768 26775392
19:59:19 32131 8192000000 10415108192 10743427072 1461948432 15.143 100 92 184 1 1500245376 7594896 30702048
20:00:05 18646 8192000000 10453323264 10783584256 1497541424 15.455 100 88 176 0 1534404016 8451408 28411184
20:00:41 19581 8192000000 10464829312 10801033216 1524122768 15.686 100 92 184 0 1562817680 9287408 29407504
20:01:25 24408 8192000000 10491814288 10832961536 1543874944 15.857 100 88 176 0 1581948256 9877328 28195984
20:01:56 15111 8192000000 10497812112 10848346112 1560423872 16.000 100 79 156 1 1594790704 10203376 24163456
20:02:20 18105 8192000000 10532313632 10884968448 1579230272 16.162 100 71 142 0 1611282016 9975616 22076128
20:02:48 13636 8192000000 10550015664 10912321536 1613621216 16.456 100 72 144 1 1645041008 10048208 21371584
20:03:09 10300 8192000000 10588674016 10947391488 1646676048 16.736 100 74 148 0 1678772832 10283248 21813536
20:03:30 13355 8192000000 10613682192 10974904320 1663594176 16.879 100 79 158 2 1698299328 11721376 22983776
20:03:51 13646 8192000000 10627499712 10996600832 1687654544 17.082 100 88 177 0 1726090432 12982256 25453632
20:04:12 10699 8192000000 10662989008 11030568960 1704022448 17.219 100 79 158 0 1740115968 12950864 23142656
20:04:31 8066 8192000000 10660519856 11034116096 1723625728 17.382 100 78 154 3 1758908480 13362688 21920064
20:04:47 7120 8192000000 10677040112 11049373696 1733042976 17.461 100 84 167 3 1771058064 14508016 23507072
20:05:02 8623 8192000000 10694302192 11064082432 1741640960 17.532 100 78 156 0 1778035840 13998560 22396320
20:05:17 5991 8192000000 10689250512 11066732544 1750660000 17.607 100 72 144 0 1783688384 12792096 20236288
20:05:32 8656 8192000000 10703993824 11083075584 1767014992 17.742 100 76 152 0 1800701232 12480656 21205584
20:05:48 4759 8192000000 10716146944 11096731648 1777569568 17.829 100 81 160 0 1813283712 13616992 22097152
20:06:00 5021 8192000000 10723997504 11104387072 1788031920 17.916 100 85 170 1 1826232944 14509936 23691088
20:06:12 4321 8192000000 10728745888 11112648704 1791740352 17.946 100 83 166 0 1829044144 13748736 23555056
20:06:23 3878 8192000000 10736022880 11118505984 1799646240 18.011 100 87 170 0 1835982720 12908224 23428256
20:06:33 3049 8192000000 10748192528 11128827904 1811291776 18.106 100 91 182 1 1850176272 13439232 25445264
20:06:42 2707 8192000000 10752792752 11133239296 1813671616 18.126 100 84 170 0 1851227536 13920016 23635904
20:06:53 10790 8192000000 10750358016 11147157504 1816943632 18.153 100 70 140 0 1850046656 14169296 18933728
20:07:12 3612 8192000000 10780231424 11164192768 1830953552 18.267 100 84 166 2 1867891968 13081488 23856928
20:07:22 1830 8192000000 10779675968 11165089792 1841235392 18.351 100 90 180 5 1879461024 13115984 25109648
20:07:30 1468 8192000000 10791047392 11177877504 1845862384 18.388 100 93 186 0 1885226816 13633488 25730944
20:07:38 2330 8192000000 10792413328 11179159552 1848203632 18.408 100 89 175 1 1886543024 12858944 25480448
20:07:47 2210 8192000000 10789384592 11183009792 1850914992 18.430 100 81 160 0 1885586304 11344192 23327120
20:07:56 1858 8192000000 10805330864 11189641216 1855109008 18.464 100 86 172 0 1891695328 11894544 24691776
20:08:04 2151 8192000000 10812224480 11196387328 1859614512 18.500 100 93 185 0 1899156512 13229136 26312864
20:08:12 1452 8192000000 10810374800 11198902272 1866137824 18.553 100 92 183 1 1905478336 14330176 25010336
20:08:20 1842 8192000000 10809443024 11201658880 1869038320 18.576 100 90 182 1 1907140224 12949200 25152704
20:08:28 1261 8192000000 10820754240 11209957376 1875727984 18.631 100 90 181 4 1914250672 13093968 25428720
20:08:35 10837 8192000000 10812861648 11208155136 1868916752 18.576 100 62 124 0 1897974976 10662656 18395568
20:08:53 17742 8192000000 10810745216 11212722176 1875099824 18.626 100 81 161 2 1909855184 11124320 23631040
20:09:17 20317 8192000000 10782382208 11207684096 1878696480 18.655 100 79 158 0 1913701424 12591328 22413616
20:09:44 5105 8192000000 10784258144 11201273856 1870102544 18.585 100 34 69 2 1886953008 7932272 8918192
20:09:55 3024 8192000000 10796112480 11210125312 1874735056 18.623 100 50 100 1 1898803168 10421328 13646784
20:10:05 2659 8192000000 10799630000 11213590528 1877932576 18.648 100 50 100 1 1903558944 11595488 14030880
20:10:14 7889 8192000000 10788428208 11210268672 1879110016 18.658 100 47 93 0 1901315904 9559088 12646800
20:10:29 5086 8192000000 10780458112 11211898880 1880530560 18.669 100 25 51 2 1894085712 6721152 6834000
20:10:41 8101 8192000000 10801100896 11224399872 1887214864 18.723 100 32 64 2 1903559824 7709376 8635584
20:11:01 7723 8192000000 10788124544 11223158784 1890382800 18.749 100 31 62 1 1907357376 8401008 8573568
20:11:17 8698 8192000000 10786498640 11221917696 1889970592 18.746 100 22 45 0 1903239056 6812672 6455792
20:11:35 8739 8192000000 10786795360 11225718784 1891970912 18.762 100 19 38 3 1904790464 7157632 5661920
20:11:52 9901 8192000000 10797584000 11231334400 1893329856 18.773 100 25 50 2 1906630288 6384784 6915648
20:12:09 16533 8192000000 10800907888 11236433920 1893540960 18.774 100 9 18 1 1901463664 5536064 2386640
20:12:34 5709 8192000000 10812690032 11244535808 1905315824 18.869 100 32 64 1 1922023360 8339408 8368128
20:12:47 7860 8192000000 10813360928 11244240896 1903793232 18.857 100 28 54 2 1919029696 7828816 7407648
20:13:01 20083 8192000000 10822314576 11246342144 1911755280 18.921 100 34 69 1 1928354576 6160176 10439120
20:13:28 71432 8192000000 10814330368 11255263232 1908111024 18.891 100 21 43 2 1918856496 5011744 5733728
20:14:51 7179 8192000000 10826076896 11263631360 1913149872 18.932 100 25 50 1 1926809536 7012528 6647136
20:15:07 8807 8192000000 10845561856 11269623808 1915335376 18.949 100 28 56 1 1931468016 7651344 8481296
20:15:24 2623 8192000000 10841038192 11270078464 1918976288 18.979 100 40 79 2 1937741936 8091808 10673840
20:15:32 5096 8192000000 10828761552 11266285568 1916756304 18.961 100 28 56 1 1932132640 7633696 7742640
20:15:44 5203 8192000000 10836632544 11270414336 1919987376 18.987 100 29 58 1 1934555920 6517024 8051520
20:15:58 7620 8192000000 10832454624 11267047424 1917862816 18.970 100 29 59 1 1931507184 5564368 8080000
20:16:17 8859 8192000000 10817949344 11256750080 1905364464 18.869 100 13 26 2 1914316848 4992592 3959792
20:16:34 3604 8192000000 10829860672 11261546496 1911564256 18.919 100 30 60 2 1927998704 8078880 8355568
20:16:47 5634 8192000000 10821884704 11254669312 1892564752 18.766 99 22 44 0 1904821648 6347168 5909728
20:16:59 9537 8192000000 10814456784 11246829568 1898563664 18.815 100 17 34 0 1913097424 10084384 4449376
20:17:16 4553 8192000000 10784764784 11208310784 1822413376 18.197 96 22 44 1 1834288544 5372304 6502864
20:17:28 8189 8192000000 10770414000 11203432448 1785303936 17.893 95 14 28 0 1794359008 5336368 3718704
20:17:45 12345 8192000000 10773555888 11203493888 1845646944 18.387 99 17 34 2 1856197456 5746832 4803680
20:18:07 78748 8192000000 10749870608 11177730048 1775520320 17.813 95 31 62 2 1790276912 5706224 9050368
20:19:32 10003 8192000000 10757540688 11181129728 1799654992 18.011 97 33 66 2 1815743200 6099088 9989120
20:19:50 4665 8192000000 10733543728 11144527872 1796839056 17.988 98 44 88 3 1815846240 7066064 11941120
20:20:04 6788 8192000000 10690896048 11113504768 1731084064 17.445 96 37 73 1 1749025440 7718224 10223152
20:20:17 9368 8192000000 10721599264 11141488640 1783303088 17.877 99 25 50 2 1795438080 5035360 7099632
20:20:37 5920 8192000000 10743258272 11159994368 1817044336 18.154 100 32 64 1 1832716352 5895744 9776272
20:20:52 5296 8192000000 10723155072 11142107136 1768656496 17.756 97 28 56 0 1782542032 5056480 8829056
20:21:04 10394 8192000000 10714550224 11128303616 1767069952 17.743 98 16 32 2 1776495968 4791072 4634944
20:21:22 7579 8192000000 10721527792 11140653056 1806887504 18.070 100 26 52 1 1820290320 6380976 7021840
20:21:36 5722 8192000000 10714972560 11131101184 1759106928 17.677 97 23 45 2 1771595136 6238144 6250064
20:21:49 7138 8192000000 10733307584 11151728640 1794890336 17.972 99 15 28 1 1803690624 5125296 3674992
20:22:02 17452 8192000000 10709897104 11124060160 1707528768 17.248 94 21 41 2 1718930752 4768624 6633360
20:22:26 11318 8192000000 10711802096 11134038016 1776109408 17.817 98 26 52 2 1789888064 6211936 7566720
20:22:44 14707 8192000000 10740334112 11148001280 1795138592 17.974 99 23 47 1 1807727200 5161120 7427488
20:23:11 59194 8192000000 10730190304 11148103680 1772215872 17.785 97 31 62 1 1786869248 5603408 9049968
20:24:18 7540 8192000000 10727290032 11149709312 1800346752 18.017 99 24 48 2 1813061216 6433616 6280848
20:24:34 8547 8192000000 10754681216 11167252480 1826127456 18.228 100 26 52 1 1838958624 5654080 7177088
20:24:50 6528 8192000000 10754860720 11178385408 1838797312 18.331 100 33 66 0 1855022112 6510224 9714576
20:25:05 5472 8192000000 10768849440 11191439360 1849743120 18.420 100 39 75 0 1868292400 7761968 10787312
20:25:17 4879 8192000000 10761007344 11190484992 1848360592 18.409 100 25 50 0 1862009552 5771056 7877904
20:25:29 7151 8192000000 10762118096 11191087104 1849962448 18.422 100 15 29 3 1860117344 4998192 5156704
20:25:44 4583 8192000000 10771832336 11198001152 1856818096 18.477 100 30 60 1 1871107872 5611312 8678464
20:25:55 8366 8192000000 10767418704 11201699840 1856921744 18.478 100 20 41 0 1868773488 5061824 6789920
20:26:09 14614 8192000000 10772485280 11203923968 1861306000 18.514 100 15 30 0 1871481600 5893488 4282112
20:26:34 9054 8192000000 10777473024 11206111232 1863952128 18.535 100 18 36 2 1874814480 5899232 4963120
20:26:51 15949 8192000000 10786027872 11214729216 1868122288 18.569 100 23 44 3 1879244400 5221104 5901008
20:27:14 9105 8192000000 10798541504 11233021952 1885862832 18.712 100 18 36 0 1895792192 4772656 5156704
20:27:30 19901 8192000000 10839091008 11253379072 1903396432 18.854 100 58 114 1 1924940800 4840672 16703696
20:27:59 9270 8192000000 10849840352 11259305984 1912952288 18.930 100 63 127 4 1937898048 6383408 18562352
20:28:15 84831 8192000000 10859239632 11272843264 1920970240 18.995 100 62 121 3 1947208448 8980432 17257776
20:30:02 22413 8192000000 10846776480 11287162880 1927400944 19.046 100 25 50 1 1943010688 8159984 7449760
20:30:33 7001 8192000000 10866958720 11300581376 1940574880 19.151 100 45 91 1 1964029792 10431440 13023472
20:30:52 22548 8192000000 10872609264 11302248448 1942510944 19.167 100 43 85 1 1967957920 13815984 11630992
20:31:23 21502 8192000000 10891038448 11316441088 1953121440 19.251 100 51 101 2 1979010256 11768832 14119984
20:31:57 27744 8192000000 10895661264 11324567552 1961050448 19.314 100 56 112 2 1988272048 11625808 15595792
20:32:34 2863 8192000000 10911446272 11333636096 1964775360 19.344 100 63 125 0 1996828752 14072624 17980768
20:32:44 7531 8192000000 10914941040 11336663040 1969419600 19.381 100 58 116 6 2000872384 14453088 16999696
20:32:59 8330 8192000000 10911697216 11342827520 1971092800 19.394 100 49 98 0 1999350304 14541792 13715712
20:33:20 24535 8192000000 10919679488 11355967488 1977909040 19.448 100 43 86 2 2006584736 15442640 13233056
20:34:05 10498 8192000000 10924546672 11353403392 1963652224 19.335 99 40 80 1 1990723296 15046784 12024288
20:34:50 19458 8192000000 10942900736 11372924928 1992677360 19.565 100 61 122 1 2032624944 20654416 19293168
20:35:18 23026 8192000000 10945776272 11385741312 1997092816 19.600 100 47 94 0 2038373296 27729920 13550560
20:35:51 11223 8192000000 10944789200 11387043840 1999158464 19.616 100 46 92 0 2037349232 24610144 13580624
20:36:09 40874 8192000000 10951742368 11397545984 2002901088 19.646 100 44 88 1 2041646144 25125584 13619472
20:37:18 22704 8192000000 10950529856 11402457088 2007551056 19.682 100 38 76 1 2045566464 26260624 11754784
20:38:00 20722 8192000000 10952735424 11404828672 2010912464 19.709 100 31 62 2 2048637168 27774736 9949968
20:38:28 7559 8192000000 10955925024 11410853888 2017880224 19.763 100 34 68 4 2056974672 28321328 10773120
20:38:43 4307 8192000000 10955661792 11411836928 2015277632 19.743 100 27 54 0 2052259600 27871776 9110192
20:38:59 6859 8192000000 10963093536 11415400448 2019580896 19.777 100 34 68 3 2060389472 30020784 10787792
20:39:12 2766 8192000000 10982157152 11420536832 2023899376 19.811 100 46 90 1 2066097280 28664384 13533520
20:39:24 4064 8192000000 10991166288 11423805440 2027662080 19.840 100 58 112 0 2074008640 29535104 16811456
20:39:36 5083 8192000000 10965523760 11399004160 2002712544 19.644 99 64 128 2 2052937568 30939920 19285104
20:39:48 2438 8192000000 10975709728 11405852672 2014413344 19.736 100 73 144 0 2066494864 31547728 20533792
20:39:58 5213 8192000000 10978310304 11408875520 2014251136 19.735 100 73 146 2 2068524336 32574432 21698768
20:40:11 2956 8192000000 10952808672 11378606080 1986742688 19.518 99 74 146 1 2042054208 33865248 21446272
20:40:22 2866 8192000000 10971313712 11398627328 2002505696 19.642 100 74 145 1 2058375648 34619808 21250144
20:40:32 3824 8192000000 10970117648 11396472832 2001494848 19.635 100 73 146 1 2057630400 34845376 21290176
20:40:43 4070 8192000000 10980611520 11403120640 1987639840 19.525 99 71 142 4 2046911392 37652320 21619232
20:40:56 2272 8192000000 10988696944 11406241792 2006873040 19.677 100 73 146 1 2066589520 37184640 22531840
20:41:05 3949 8192000000 10983476336 11400077312 1997903200 19.606 100 79 157 1 2059157760 38039488 23215072
20:41:16 7158 8192000000 10952415936 11383308288 1980121408 19.466 99 64 128 2 2038686208 38755184 19809616
20:41:31 2230 8192000000 10986017296 11405111296 1998514704 19.611 100 73 146 5 2062426816 41392672 22519440
20:41:40 7326 8192000000 10976992896 11410096128 2002363872 19.641 100 63 127 0 2064418432 42062224 19992336
20:41:55 2307 8192000000 10982635200 11399917568 2003740544 19.652 100 81 160 0 2068032064 40090192 24201328
20:42:04 5656 8192000000 10952144624 11383635968 1954323456 19.261 98 58 116 0 2012179408 39759936 18096016
20:42:18 4259 8192000000 10950524096 11383529472 1985511776 19.508 100 61 122 1 2045065312 39960624 19592912
20:42:34 4470 8192000000 10957412096 11386716160 1974437696 19.421 99 59 117 1 2031940464 38822928 18679840
20:42:52 2841 8192000000 10976633104 11402510336 2002403072 19.642 100 77 154 2 2065257216 39869136 22985008
20:43:02 6067 8192000000 10958389680 11382091776 1976973520 19.441 99 75 150 4 2041473360 41382560 23117280
20:43:16 3621 8192000000 10970433152 11395547136 1984474752 19.500 99 83 164 3 2051635776 42099888 25061136
20:43:27 9624 8192000000 10959120768 11380559872 1941669712 19.160 97 73 143 2 2006533744 43222912 21641120
20:43:47 7781 8192000000 10973344544 11394326528 1983693040 19.494 100 65 121 2 2048590576 46312160 18585376
20:44:01 5508 8192000000 10975526816 11400814592 1981424752 19.476 99 77 154 0 2054919728 49080656 24414320
20:44:14 3251 8192000000 10988615872 11402702848 1995535040 19.588 100 78 154 4 2068147152 47712720 24899392
20:44:24 1132 8192000000 10949127504 11355435008 1953558048 19.255 98 87 171 5 2027109200 47879328 25671824
20:44:35 2316 8192000000 10978281280 11387109376 1976773936 19.439 100 85 170 3 2050258944 46616176 26868832
20:44:44 4881 8192000000 10966547136 11385241600 1977234928 19.443 100 82 162 0 2051261552 48447392 25579232
20:44:59 2591 8192000000 10984784832 11393634304 1984863568 19.503 100 86 173 1 2060943312 49874432 26205312
20:45:08 2536 8192000000 10977708272 11386888192 1977271456 19.443 100 85 166 3 2052162656 50208848 24682352
20:45:19 4070 8192000000 10977946976 11390144512 1976731968 19.439 100 84 167 0 2053618256 51088432 25797856
20:45:34 2502 8192000000 10974946960 11383328768 1974486464 19.421 100 82 162 0 2051993680 52580112 24927104
20:45:44 2003 8192000000 10940933568 11358892032 1954572016 19.263 99 69 138 1 2020140272 44409696 21158560
20:45:54 6328 8192000000 10958839744 11374448640 1973211360 19.411 100 76 152 1 2041916416 44384672 24320384
20:46:11 1466 8192000000 10958193824 11366883328 1964412064 19.341 100 90 180 1 2037442432 45651696 27378672
20:46:20 2893 8192000000 10964006048 11378180096 1973149856 19.410 100 85 169 2 2045957376 47058656 25748864
20:46:30 2033 8192000000 10970736928 11381538816 1976190352 19.435 100 91 181 1 2051241120 47229360 27821408
20:46:38 3146 8192000000 10969769744 11385442304 1979155280 19.458 100 82 165 1 2052483360 48574368 24753712
20:46:48 1806 8192000000 10966310336 11373318144 1966197088 19.355 99 88 176 1 2043309440 49671648 27440704
20:46:57 1420 8192000000 10979417616 11392811008 1984895600 19.503 100 90 179 1 2063094080 50576224 27622256
20:47:05 2678 8192000000 10970794896 11388481536 1978576416 19.453 100 80 158 2 2053157344 50350480 24230448
20:47:16 2880 8192000000 10959268576 11374063616 1974361616 19.420 100 76 152 1 2041769904 44328688 23079600
20:47:26 3100 8192000000 10952183200 11372412928 1968330288 19.372 100 73 142 2 2034016064 43150528 22535248
20:47:38 9744 8192000000 10928952528 11366223872 1964608176 19.343 100 55 110 0 2024733888 42540320 17585392
20:48:04 15925 8192000000 10916318224 11354124288 1910989760 18.915 97 39 78 1 1965080464 41348096 12742608
20:48:27 906 8192000000 10925683536 11355664384 1939291616 19.141 99 70 141 2 2006877776 42924976 24661184
20:48:40 2629 8192000000 10933415488 11362553856 1956141600 19.275 100 52 103 1 2017051088 43552720 17356768
20:48:51 2933 8192000000 10946311040 11364376576 1958917472 19.297 100 82 165 1 2029929152 45037984 25973696
20:49:01 1842 8192000000 10935702832 11349024768 1930639808 19.072 99 89 178 0 2007922080 49551168 27731104
20:49:10 4792 8192000000 10933640544 11358769152 1947214368 19.204 100 72 141 0 2022366320 52460816 22691136
20:49:22 8594 8192000000 10927786400 11367370752 1948264528 19.213 100 50 100 0 2019488912 54084368 17140016
20:49:44 6300 8192000000 10946635024 11372724224 1955187344 19.268 100 54 106 1 2027453488 54163136 18103008
20:49:59 2752 8192000000 10966650288 11375915008 1960690128 19.312 100 77 154 1 2039493392 53343872 25459392
20:50:09 2183 8192000000 10960136800 11379056640 1953288880 19.253 100 86 171 2 2037328304 56182288 27857136
20:50:19 7755 8192000000 10941553136 11371446272 1949832656 19.225 100 54 107 2 2022237968 55052128 17353184
20:50:38 16630 8192000000 10913264992 11364073472 1931195264 19.076 99 34 68 1 1995352832 52822416 11335152
20:51:05 11589 8192000000 10910719312 11358584832 1935658672 19.112 100 28 56 1 2000204016 53874864 10670480
20:51:23 13101 8192000000 10918464240 11366522880 1944659952 19.184 100 31 62 0 2010281152 54184784 11436416
20:51:47 12945 8192000000 10931247120 11372290048 1951809728 19.241 100 28 56 0 2014042464 52033632 10199104
20:52:07 6021 8192000000 10944933808 11380334592 1956239664 19.276 100 51 103 0 2026281136 52970560 17070912
20:52:23 3173 8192000000 10959540848 11373297664 1947216752 19.204 100 85 165 3 2034249760 60478784 26554224
20:52:32 4482 8192000000 10971604832 11396841472 1971584112 19.398 100 75 150 0 2059802992 64422064 23796816
20:52:44 15110 8192000000 10941478880 11384262656 1961654752 19.319 100 36 73 0 2022994480 48931152 12408576
20:53:17 20156 8192000000 10935236288 11385487360 1962549280 19.326 100 31 62 0 2021618080 47862176 11206624
20:53:49 35365 8192000000 10913194944 11372331008 1943887584 19.178 99 12 24 0 1978673744 30852448 3933712
20:54:31 19244 8192000000 10895990464 11352444928 1913559328 18.935 98 16 33 2 1949732240 30518528 5654384
20:55:56 41033 8192000000 10886505008 11343556608 1908505456 18.895 98 14 27 3 1933373328 20140832 4727040
20:56:45 35414 8192000000 10888616544 11350142976 1956482592 19.278 100 30 60 0 1984956304 19044208 9429504
20:57:27 60096 8192000000 10905749712 11331235840 1930030128 19.067 98 28 52 0 1952094112 14557664 7506320
20:58:35 66644 8192000000 10877914080 11326918656 1894126032 18.779 97 15 30 3 1905552800 6806720 4620048
20:59:53 54140 8192000000 10889521616 11346391040 1961917696 19.321 100 25 50 2 1978123248 9009600 7195952
21:01:27 93051 8192000000 10886623200 11347091456 1935667744 19.112 98 29 58 1 1953974176 10855728 7450704
21:03:16 83118 8192000000 10911861360 11361787904 1971854688 19.400 100 28 56 1 1987170880 7360960 7955232
21:04:45 16566 8192000000 10916988592 11368955904 1982972352 19.488 100 30 60 1 2000201648 8728288 8501008
21:05:11 22986 8192000000 10890607200 11362242560 1978617712 19.454 100 40 79 0 1999679696 9935856 11126128
21:05:41 56003 8192000000 10888480512 11355090944 1957202704 19.284 99 19 38 3 1971303504 8280112 5820688
21:06:54 43198 8192000000 10927053392 11382456320 1988215008 19.530 100 45 89 2 2017470384 14934128 14321248
21:07:46 58254 8192000000 10893719664 11373178880 1962672976 19.327 99 12 24 1 1978748384 12507920 3567488
21:08:51 39725 8192000000 10886308288 11358171136 1935230416 19.109 98 12 24 0 1951782416 12411440 4140560
21:09:39 26858 8192000000 10890170976 11364728832 1965972160 19.353 100 8 17 0 1979690032 11389216 2328656
21:10:13 22199 8192000000 10872966544 11347320832 1931765120 19.081 98 8 14 0 1941347696 7687872 1894704
21:10:41 18378 8192000000 10890018720 11358294016 1964955776 19.345 100 8 16 0 1975254848 8339440 1959632
21:12:24 62283 8192000000 10900045792 11378065408 1967615168 19.367 100 10 20 0 1979803984 8913920 3274896
21:13:33 51255 8192000000 10882447296 11362254848 1952136768 19.243 99 8 15 1 1965912128 11361296 2414064
21:14:31 33590 8192000000 10893597632 11368124416 1950506304 19.231 99 10 20 0 1966323056 13027840 2788912
21:15:10 27704 8192000000 10892760304 11380408320 1972962912 19.409 100 4 8 1 1988830112 14607984 1259216
21:15:46 35250 8192000000 10901516496 11376963584 1963989616 19.338 99 17 34 1 1980868208 11561744 5316848
21:16:34 85619 8192000000 10883612704 11354243072 1919206944 18.980 97 16 32 0 1938520240 14740576 4572720
21:18:06 29487 8192000000 10876400400 11340566528 1951136464 19.236 99 17 34 1 1964163312 8558960 4467888
21:18:41 74740 8192000000 10882053392 11342884864 1889498192 18.742 96 24 48 0 1907396464 10607808 7290464
21:20:02 49692 8192000000 10880412976 11350073344 1948890736 19.218 100 14 28 1 1965101952 11524128 4687088
21:21:02 55234 8192000000 10872450480 11340095488 1910028992 18.907 97 25 50 4 1931935888 15143552 6763344
21:22:03 32147 8192000000 10878926160 11336630272 1913059248 18.931 98 26 52 2 1931450480 11046080 7345152
21:22:49 55986 8192000000 10845865824 11313524736 1861034864 18.512 96 23 46 1 1882579088 15289440 6254784
21:23:52 78136 8192000000 10855894496 11329507328 1859093536 18.496 96 19 38 0 1882010992 17515648 5401808
21:25:16 63439 8192000000 10857810976 11325796352 1876542832 18.637 97 16 32 0 1904044464 21890080 5611552
21:26:26 47759 8192000000 10860886752 11323904000 1878255872 18.651 97 17 34 2 1896177872 13192256 4729744
21:27:20 78185 8192000000 10866710304 11342606336 1928410192 19.054 100 11 22 1 1943258240 12033072 2814976
21:28:44 151184 8192000000 10827436160 11298009088 1815394640 18.140 93 30 60 3 1835244272 11807376 8042256
21:31:28 20111 8192000000 10852683520 11319386112 1922921520 19.010 100 20 38 1 1938813248 10282912 5608816
21:31:54 27032 8192000000 10869329504 11340435456 1937345024 19.126 100 17 34 2 1952631824 10547568 4739232
21:32:36 67399 8192000000 10861753200 11342774272 1910468000 18.910 98 14 28 2 1927310672 12874352 3968320
21:33:49 56571 8192000000 10856332640 11334946816 1885507952 18.710 97 9 18 0 1898060160 10001600 2550608
21:35:30 55332 8192000000 10859477616 11320193024 1913985696 18.939 99 34 67 0 1936122864 12421536 9715632
21:36:40 59825 8192000000 10853705712 11320918016 1914922784 18.946 99 18 37 2 1930445536 10013088 5509664
21:37:46 34720 8192000000 10870721632 11340181504 1949549296 19.223 100 34 67 2 1968759584 10192672 9017616
21:39:49 63893 8192000000 10844856176 11311493120 1847945424 18.405 95 19 38 0 1861743584 8548320 5249840
21:40:59 69300 8192000000 10865156688 11326943232 1905695616 18.872 98 27 54 2 1922841168 8592160 8553392
21:42:24 51498 8192000000 10862567200 11328274432 1884362544 18.700 97 20 39 1 1899299136 9673024 5263568
21:43:40 64538 8192000000 10879675616 11330748416 1885298304 18.708 97 21 42 0 1907869472 16410576 6160592
21:44:52 56942 8192000000 10861836080 11321573376 1892528848 18.766 98 13 26 0 1912902816 17079280 3294688
21:45:55 75828 8192000000 10873350192 11327086592 1847057504 18.398 95 27 54 0 1867076720 12621712 7397504
21:47:19 75963 8192000000 10870599904 11361628160 1917530992 18.967 99 11 22 0 1938193536 17478768 3183776
21:48:41 111332 8192000000 10897072784 11389382656 1953459280 19.254 100 18 36 0 1980509200 22268432 4781488
21:50:43 78007 8192000000 10899366368 11352690688 1905032464 18.867 97 19 38 0 1923613264 12978304 5602496
21:52:13 50325 8192000000 10904037808 11381248000 1963823216 19.336 100 38 76 2 1992572144 17577088 11171840
21:53:10 102089 8192000000 10899224176 11371053056 1965092944 19.347 100 22 44 1 1986426720 15226384 6107392
21:55:03 50083 8192000000 10894035936 11368275968 1963249696 19.332 100 29 59 0 1986039216 14424288 8365232
21:56:54 52300 8192000000 10879039264 11369586688 1955915104 19.274 99 11 20 2 1968480784 9365904 3199776
21:58:17 55371 8192000000 10880163328 11370827776 1950360176 19.229 99 5 10 0 1959356240 7950688 1045376
21:59:28 78709 8192000000 10903669648 11383140352 1960633328 19.311 99 10 19 1 1973027440 9588288 2805824
22:00:52 82756 8192000000 10893198400 11371077632 1959478048 19.302 99 13 25 2 1970284448 7501936 3304464
22:02:26 83588 8192000000 10895879952 11374866432 1921125024 18.996 97 17 34 0 1935768160 10010288 4632848
22:04:06 55415 8192000000 10916822656 11373678592 1919570464 18.983 97 23 46 1 1937257664 11550944 6136256
22:05:10 46042 8192000000 10921477744 11387203584 1962771696 19.328 99 40 80 1 1993442096 19246192 11424208
22:06:13 74324 8192000000 10903055904 11397410816 1947331840 19.205 99 5 10 0 1967090592 18578672 1180080
22:07:34 43904 8192000000 10929340864 11378245632 1958318464 19.293 99 33 66 1 1981707952 13037856 10351632
22:08:32 75198 8192000000 10907402944 11392413696 1962346784 19.325 99 43 86 1 1987947712 13497296 12103632
22:09:53 53847 8192000000 10919993056 11384246272 1925624768 19.032 97 17 34 0 1942938416 12622224 4691424
22:10:57 29778 8192000000 10937206704 11382493184 1936772096 19.121 98 38 76 1 1961129664 13336864 11020704
22:11:33 66763 8192000000 10891327296 11370770432 1908350400 18.893 97 20 40 0 1928417472 14630352 5436720
22:12:47 144256 8192000000 10889823744 11358359552 1873405104 18.612 95 4 7 1 1885454704 11131520 918080
22:15:23 72584 8192000000 10862755296 11345608704 1916093728 18.956 98 11 22 1 1929279056 10158880 3026448
22:16:55 105846 8192000000 10879827744 11365670912 1926125792 19.036 98 25 50 0 1948819440 15307280 7386368
22:18:47 93603 8192000000 10898046848 11384479744 1950020688 19.227 99 17 34 0 1974065840 19072480 4972672
22:20:30 44424 8192000000 10858648944 11349962752 1895405056 18.789 97 11 22 0 1910145280 11860256 2879968
22:21:32 62946 8192000000 10848259120 11321745408 1885010912 18.706 97 14 28 0 1898671856 9168832 4492112
22:22:41 57645 8192000000 10857760720 11329290240 1913840784 18.937 98 11 22 0 1926018272 9267504 2909984
22:23:50 52823 8192000000 10861510576 11344957440 1914941408 18.946 98 7 14 1 1923739952 6945616 1852928
22:25:29 67606 8192000000 10870129200 11338506240 1914236944 18.941 98 16 31 1 1928278544 8576016 5465584
22:26:54 33157 8192000000 9570137824 9896906752 712053104 7.996 37 10 20 1 718251920 3834432 2364384

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 05-03-2021 22:29:31 to 05-03-2021 22:30:02.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 151 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 05-03-2021 22:30:03 to 05-03-2021 22:30:05.

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          238514
MON$OLDEST_ACTIVE               239096
MON$OLDEST_SNAPSHOT             239096
MON$NEXT_TRANSACTION            239096
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                       2044256
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.33423 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33423 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33423 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33423 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 ---
:75: 
:76: mscs-test-161.budzdorov.ru    Fri Mar  5 22:27:49 2021
:77:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:78: 
--- end of diff output ---

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

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