Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 17.12.2020 16:32
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 17510720 kB
MemAvailable 31496060 kB
Buffers 0 kB
Cached 14162164 kB
SwapCached 3712 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-17 16:32:07
DTS_END                         2020-12-17 16:32:07.0530
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/36872
TRN_ID                          227094
ATT_ID                          613
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: 9225.53 25280 1107064
customer order: creation 155.04 354 18605
customer order: refuse 13.38 323 1605
order to supplier: creation 42.38 1212 5086
order to supplier: removal 3.36 113155 403
invoice (draft): creation 41.57 3456 4988
invoice (draft): removal 54.06 754 6487
invoice accept: apply 39.33 18114 4720
invoice accept: cancel 49.46 751 5935
customer reserve: creation 3670.00 178 440400
customer reserve: removal 4879.74 62 585569
realization accept: apply 74.76 162 8971
realization accept: cancel 83.71 109 10045
payment from customer: creation 55.18 115 6621
payment from customer: removal 5.09 73 611
payment to supplier: creation 44.57 115 5348
payment to supplier: removal 2.78 68 333
service: total inventory turnovers 4.44 1061 533
service: total monetary turnovers 5.80 19 696
service: aggregate perf. data 0.87 18250 104
service: refresh index statistics 0.03 347266 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-12-2020 16:32:58 to 17-12-2020 16:33:00.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4916
TEST_TIME 2 5453
TEST_TIME 3 5301
TEST_TIME 4 5505
TEST_TIME 5 5406
TEST_TIME 6 5597
TEST_TIME 7 5647
TEST_TIME 8 5641
TEST_TIME 9 6025
TEST_TIME 10 5847
TEST_TIME 11 5960
TEST_TIME 12 5860
TEST_TIME 13 6096
TEST_TIME 14 6565
TEST_TIME 15 6713
TEST_TIME 16 7130
TEST_TIME 17 7507
TEST_TIME 18 7648
TEST_TIME 19 8212
TEST_TIME 20 8130
TEST_TIME 21 8464
TEST_TIME 22 8467
TEST_TIME 23 8530
TEST_TIME 24 8679
TEST_TIME 25 9005
TEST_TIME 26 9828
TEST_TIME 27 11497
TEST_TIME 28 11189
TEST_TIME 29 10892
TEST_TIME 30 11029
TEST_TIME 31 10824
TEST_TIME 32 10604
TEST_TIME 33 10434
TEST_TIME 34 10250
TEST_TIME 35 10059
TEST_TIME 36 10000
TEST_TIME 37 10077
TEST_TIME 38 10029
TEST_TIME 39 9877
TEST_TIME 40 9925
TEST_TIME 41 9809
TEST_TIME 42 9639
TEST_TIME 43 9512
TEST_TIME 44 9461
TEST_TIME 45 9363
TEST_TIME 46 9240
TEST_TIME 47 9546
TEST_TIME 48 9461
TEST_TIME 49 9385
TEST_TIME 50 9517
TEST_TIME 51 9550
TEST_TIME 52 9507
TEST_TIME 53 9506
TEST_TIME 54 9527
TEST_TIME 55 9549
TEST_TIME 56 9533
TEST_TIME 57 9546
TEST_TIME 58 9516
TEST_TIME 59 9649
TEST_TIME 60 9570
TEST_TIME 61 9418
TEST_TIME 62 9413
TEST_TIME 63 9328
TEST_TIME 64 9306
TEST_TIME 65 9239
TEST_TIME 66 9280
TEST_TIME 67 9230
TEST_TIME 68 9303
TEST_TIME 69 9326
TEST_TIME 70 9290
TEST_TIME 71 9368
TEST_TIME 72 9354
TEST_TIME 73 9372
TEST_TIME 74 9371
TEST_TIME 75 9336
TEST_TIME 76 9390
TEST_TIME 77 9489
TEST_TIME 78 9448
TEST_TIME 79 9499
TEST_TIME 80 9524
TEST_TIME 81 9471
TEST_TIME 82 9421
TEST_TIME 83 9472
TEST_TIME 84 9420
TEST_TIME 85 9339
TEST_TIME 86 9286
TEST_TIME 87 9272
TEST_TIME 88 9318
TEST_TIME 89 9335
TEST_TIME 90 9291
TEST_TIME 91 9319
TEST_TIME 92 9354
TEST_TIME 93 9348
TEST_TIME 94 9389
TEST_TIME 95 9453
TEST_TIME 96 9466
TEST_TIME 97 9468
TEST_TIME 98 9453
TEST_TIME 99 9503
TEST_TIME 100 9495
TEST_TIME 101 9465
TEST_TIME 102 9458
TEST_TIME 103 9423
TEST_TIME 104 9448
TEST_TIME 105 9422
TEST_TIME 106 9379
TEST_TIME 107 9339
TEST_TIME 108 9388
TEST_TIME 109 9365
TEST_TIME 110 9349
TEST_TIME 111 9302
TEST_TIME 112 9275
TEST_TIME 113 9241
TEST_TIME 114 9239
TEST_TIME 115 9259
TEST_TIME 116 9256
TEST_TIME 117 9243
TEST_TIME 118 9251
TEST_TIME 119 9297
TEST_TIME 120 9231

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 17-12-2020 16:33:01 to 17-12-2020 16:33:05.

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 1515453 1515453 0 0.00 0 13846 6 0 0
doc_list_biud 1515453 1515453 0 0.00 0 24852 29 0 0
sp_add_invoice_to_stock 4842 4720 122 2.51 38 189746 18114 0 122
sp_cancel_adding_invoice 5935 5935 0 0.00 5 66498 751 0 0
sp_cancel_client_order 1605 1605 0 0.00 4 9961 324 0 0
sp_cancel_customer_reserve 585569 585569 0 0.00 1 24857 62 0 0
sp_cancel_pay_from_customer 611 611 0 0.00 3 2960 74 0 0
sp_cancel_pay_to_supplier 333 333 0 0.00 3 2685 69 0 0
sp_cancel_supplier_invoice 6498 6487 11 0.16 1 20834 755 0 11
sp_cancel_supplier_order 403 403 0 0.00 8 941425 113155 0 0
sp_cancel_write_off 10045 10045 0 0.00 1 12052 110 0 0
sp_client_order 18605 18605 0 0.00 3 23601 355 0 0
sp_customer_reserve 440400 440400 0 0.00 0 125606 178 0 0
sp_fill_shopping_cart 28670 28670 0 0.00 1 34674 37 0 0
sp_fill_shopping_cart_clo_res 440386 440386 0 0.00 0 24887 14 0 0
sp_get_clo_for_invoice 4706 4706 0 0.00 0 27217 355 0 0
sp_kill_cost_storno 16924 16924 0 0.00 0 9323 55 0 0
sp_kill_qstorno_ret_qs2qd 1188073 1188073 0 0.00 0 24843 33 0 0
sp_kill_qty_storno 623721 623721 0 0.00 0 24851 71 0 0
sp_lock_selected_doc 18941 18941 0 0.00 0 11042 5 0 0
sp_make_cost_storno 25646 25646 0 0.00 0 13596 53 0 0
sp_multiply_rows_for_pdistr 25646 25646 0 0.00 0 9539 27 0 0
sp_multiply_rows_for_qdistr 18605 18605 0 0.00 0 14733 170 0 0
sp_pay_from_customer 6621 6621 0 0.00 4 13657 115 0 0
sp_pay_to_supplier 5348 5348 0 0.00 4 9126 116 0 0
sp_payment_common 11969 11969 0 0.00 1 9438 25 0 0
sp_qd_handle_on_cancel_clo 1605 1605 0 0.00 0 9956 300 0 0
sp_qd_handle_on_invoice_upd_sts 10641 10641 0 0.00 0 23414 308 0 0
sp_qd_handle_on_reserve_upd_sts 8971 8971 0 0.00 0 8898 50 0 0
sp_reserve_write_off 8971 8971 0 0.00 6 11059 163 0 0
sp_supplier_invoice 4988 4988 0 0.00 6 101538 3456 0 0
sp_supplier_order 5086 5086 0 0.00 5 36239 1213 0 0
srv_aggregate_perf_data 105 104 1 0.95 2918 164850 18251 0 1
srv_fill_mon_cache_memory 149 149 0 0.00 1249 200065 36015 0 0
srv_find_qd_qs_mism 1063141 1063141 0 0.00 0 13845 5 0 0
srv_make_invnt_saldo 533 533 0 0.00 37 41983 1061 0 0
srv_make_money_saldo 696 696 0 0.00 1 417 20 0 0
srv_recalc_idx_stat 4 4 0 0.00 184055 628151 347267 0 0
t$perf-abend:sp_add_invoice_to_stock 122 122 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 4720 4720 0 0.00 0 26182 176 0 0
t$perf-norm:sp_cancel_adding_invoice 381 381 0 0.00 0 4162 105 0 0
t$perf-norm:sp_cancel_client_order 1605 1605 0 0.00 0 4397 17 0 0
t$perf-norm:sp_cancel_customer_reserve 652 652 0 0.00 0 1006 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 611 611 0 0.00 0 1117 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 333 333 0 0.00 0 2939 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 358 358 0 0.00 0 360 9 0 0
t$perf-norm:sp_cancel_supplier_order 403 403 0 0.00 0 57267 1722 0 0
t$perf-norm:sp_cancel_write_off 921 921 0 0.00 0 6265 18 0 0
t$perf-norm:sp_client_order 18605 18605 0 0.00 0 15303 21 0 0
t$perf-norm:sp_customer_reserve 911 911 0 0.00 0 2530 12 0 0
t$perf-norm:sp_pay_from_customer 6622 6622 0 0.00 0 16147 16 0 0
t$perf-norm:sp_pay_to_supplier 5348 5348 0 0.00 0 7015 11 0 0
t$perf-norm:sp_reserve_write_off 8972 8972 0 0.00 0 13630 13 0 0
t$perf-norm:sp_supplier_invoice 4988 4988 0 0.00 0 15275 29 0 0
t$perf-norm:sp_supplier_order 5086 5086 0 0.00 0 4740 14 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 260 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 149 149 0 0.00 0 5313 46 0 0
t$perf-norm:srv_make_invnt_saldo 533 533 0 0.00 0 681 20 0 0
t$perf-norm:srv_make_money_saldo 696 696 0 0.00 0 1314 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 4 0 0
v_add_invoice_to_stock 9656 9412 244 2.52 0 4125 18 0 244
v_all_customers 34576 34576 0 0.00 0 82 1 0 0
v_all_suppliers 28274 28274 0 0.00 0 18 1 0 0
v_all_wares 37210 37210 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 762 762 0 0.00 0 5173 14 0 0
v_cancel_client_order 3210 3210 0 0.00 0 2727 4 0 0
v_cancel_customer_prepayment 1222 1222 0 0.00 0 2923 10 0 0
v_cancel_customer_reserve 1304 1304 0 0.00 0 1610 4 0 0
v_cancel_payment_to_supplier 666 666 0 0.00 0 2668 9 0 0
v_cancel_supplier_invoice 738 716 22 2.98 0 2473 17 0 22
v_cancel_supplier_order 806 806 0 0.00 0 1321 6 0 0
v_cancel_write_off 1842 1842 0 0.00 0 5651 19 0 0
v_max_id_clo_ord 5086 5086 0 0.00 0 235 1 0 0
v_max_id_clo_res 911 911 0 0.00 0 4930 28 0 0
v_max_id_ord_sup 4979 4979 0 0.00 0 3509 6 0 0
v_max_non_paid_invoice 1276 1276 0 0.00 0 1540 4 0 0
v_max_non_paid_realizn 3351 3351 0 0.00 0 1369 3 0 0
v_min_id_clo_ord 5086 5086 0 0.00 0 2051 5 0 0
v_min_id_clo_res 911 911 0 0.00 0 5367 22 0 0
v_min_id_ord_sup 4979 4979 0 0.00 0 4129 4 0 0
v_min_non_paid_invoice 5348 5348 0 0.00 0 2990 10 0 0
v_min_non_paid_realizn 6621 6621 0 0.00 0 9435 22 0 0
v_our_firm 9174 9174 0 0.00 0 16 1 0 0
v_reserve_write_off 17942 17942 0 0.00 0 4182 6 0 0
x_lock_depdocs_on_canc_invoice 12064 12064 0 0.00 0 19615 125 0 0
x_lock_depdocs_on_canc_sup_ord 403 403 0 0.00 0 7771 395 0 0
x_make_qstorno_1000_1200 5086 5086 0 0.00 2 36168 1146 0 0
x_make_qstorno_1200_2000 4988 4988 0 0.00 3 101518 3314 0 0
x_make_qstorno_2100_3300 440400 440400 0 0.00 0 125603 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-12-2020 16:33:06 to 17-12-2020 16:33:10.

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
14:02:10 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:02:16 8832 8192000000 10211975152 10519109632 884838528 9.748 69 54 109 0 904902704 2438944 17625232
14:02:35 33970 8192000000 10340701280 10659241984 1381556272 14.430 100 81 162 1 1412628640 4625936 26446432
14:03:21 21670 8192000000 10374500800 10697969664 1421527968 14.786 100 79 158 0 1453228784 6455152 25245664
14:03:51 21047 8192000000 10401134624 10726879232 1448127376 15.021 100 92 184 0 1485286432 7409776 29749280
14:04:24 18808 8192000000 10426998704 10755944448 1478022928 15.284 100 94 188 0 1516209296 8357408 29828960
14:04:57 22312 8192000000 10439357216 10774265856 1496150896 15.443 100 91 182 0 1534862560 9516304 29195360
14:05:37 17278 8192000000 10457319200 10796556288 1511150528 15.573 100 90 180 0 1549741920 10242320 28349072
14:06:10 19104 8192000000 10488381808 10831986688 1525660752 15.699 100 81 160 1 1560932848 10090544 25181552
14:06:39 19218 8192000000 10517081872 10867781632 1568099472 16.066 100 85 170 2 1605303008 10636096 26567440
14:07:14 17152 8192000000 10550998352 10910875648 1604853104 16.381 100 81 162 2 1640381872 10833184 24695584
14:07:39 9966 8192000000 10565673504 10924785664 1625324144 16.555 100 77 154 2 1659340704 11026992 22989568
14:08:02 9733 8192000000 10597638816 10959065088 1652003504 16.781 100 84 168 1 1689405104 12246032 25155568
14:08:19 8251 8192000000 10615209616 10976870400 1667267328 16.910 100 84 168 2 1706080752 13640288 25173136
14:08:34 10547 8192000000 10626990944 10993270784 1681469424 17.030 100 82 162 0 1718499840 13223056 23807360
14:08:52 10406 8192000000 10651101632 11020898304 1703666224 17.216 100 85 170 1 1742084816 13996496 24422096
14:09:10 8234 8192000000 10653623696 11028713472 1717356496 17.330 100 81 161 2 1753876608 13104000 23416112
14:09:27 7325 8192000000 10668253632 11041792000 1730886336 17.443 100 81 160 2 1766497168 12696800 22914032
14:09:42 7030 8192000000 10686476240 11065155584 1745293280 17.563 100 78 153 1 1779473632 12235536 21944816
14:09:57 4390 8192000000 10704605360 11079135232 1759181344 17.678 100 80 160 1 1794855440 12447056 23227040
14:10:09 4311 8192000000 10709629088 11092611072 1771042544 17.776 100 79 157 3 1806195968 13306608 21846816
14:10:22 4437 8192000000 10716002976 11096326144 1778967424 17.841 100 85 167 1 1815101808 13141520 22992864
14:10:33 4495 8192000000 10730069024 11110436864 1785904624 17.898 100 92 182 1 1824918288 13975104 25038560
14:10:44 3922 8192000000 10737384400 11117518848 1797026048 17.990 100 87 173 1 1834885904 14366848 23493008
14:10:55 2949 8192000000 10742202160 11121037312 1799609776 18.011 100 77 154 0 1835023248 13827856 21585616
14:11:04 2992 8192000000 10755861696 11139502080 1815317008 18.139 100 88 178 1 1852504928 13133808 24054112
14:11:13 10742 8192000000 10752495376 11138359296 1817095360 18.154 100 79 158 1 1852615552 13563392 21956800
14:11:32 5431 8192000000 10763707584 11150823424 1822866160 18.201 100 78 156 2 1857443680 13490912 21086608
14:11:44 3397 8192000000 10770763056 11161657344 1832556864 18.280 100 81 161 1 1867901360 12759312 22585184
14:11:54 1638 8192000000 10774537088 11164672000 1840505856 18.345 100 83 164 1 1876380784 12644800 23230128
14:12:02 3349 8192000000 10789314000 11177119744 1844466320 18.377 100 89 179 0 1881924640 12776800 24681520
14:12:12 2082 8192000000 10795231680 11180331008 1850366544 18.425 100 89 179 0 1887837856 13015024 24456288
14:12:20 1976 8192000000 10801562256 11188985856 1853322272 18.449 100 89 177 3 1890413392 13115888 23975232
14:12:29 1906 8192000000 10804643024 11193360384 1860666432 18.509 100 92 184 1 1900129984 13730128 25733424
14:12:37 1863 8192000000 10803344080 11198017536 1869055936 18.577 100 92 184 1 1908499312 13595488 25847888
14:12:46 1504 8192000000 10807133680 11196465152 1871658784 18.598 100 87 173 0 1908878000 13584080 23635136
14:12:55 1708 8192000000 10812921840 11200962560 1868407680 18.571 100 97 191 1 1909587408 14395072 26784656
14:13:03 2902 8192000000 10820892080 11207798784 1872793648 18.607 100 90 179 2 1913154928 14968560 25392720
14:13:13 2594 8192000000 10816436704 11208269824 1873953200 18.616 100 87 174 1 1912255392 14404512 23897680
14:13:22 2406 8192000000 10821916448 11211579392 1872933264 18.608 100 92 183 1 1912373344 14024272 25415808
14:13:30 2854 8192000000 10825015760 11217899520 1881355392 18.676 100 91 185 5 1919834640 13311200 25168048
14:13:42 6877 8192000000 10816874896 11212947456 1879609104 18.662 100 81 164 3 1915487232 13673088 22205040
14:13:55 1335 8192000000 10830041808 11225055232 1886913648 18.721 100 91 183 3 1925411104 12956080 25541376
14:14:03 20597 8192000000 10791708000 11213156352 1880257552 18.667 100 60 120 1 1909491760 12421840 16812368
14:14:30 3962 8192000000 10816802464 11224616960 1882097952 18.682 100 57 114 1 1907939504 8861200 16980352
14:14:42 4726 8192000000 10810044448 11224051712 1886691744 18.719 100 54 107 1 1912312304 9463600 16156960
14:14:53 4029 8192000000 10805501648 11223465984 1885206464 18.707 100 42 84 1 1905188992 8381184 11601344
14:15:04 2633 8192000000 10812660192 11227844608 1889470928 18.742 100 52 104 0 1914692160 10779840 14441392
14:15:15 4062 8192000000 10816597408 11231051776 1888437424 18.733 100 46 92 1 1911549056 10660032 12451600
14:15:26 3109 8192000000 10819041120 11229786112 1893952032 18.778 100 54 106 4 1917577648 8533200 15092416
14:15:38 7422 8192000000 10804815760 11230117888 1890984448 18.754 100 34 69 1 1911961152 11864976 9111728
14:15:53 4772 8192000000 10815287152 11241410560 1895846560 18.793 100 32 64 1 1921103120 15962304 9294256
14:16:09 11047 8192000000 10812482976 11233689600 1894223904 18.780 100 17 34 2 1904782400 5729184 4829312
14:16:26 5002 8192000000 10821524128 11241758720 1899983632 18.826 100 38 76 0 1919025072 8449136 10592304
14:16:40 6290 8192000000 10802592624 11236306944 1898696208 18.816 100 24 48 3 1911833984 6327472 6810304
14:16:56 9128 8192000000 10815580544 11243675648 1903992752 18.858 100 32 64 1 1918774448 5718896 9062800
14:17:11 9960 8192000000 10804015440 11241451520 1901175616 18.836 100 18 36 0 1910801792 5025840 4600336
14:17:30 62304 8192000000 10823312976 11257274368 1909259904 18.901 100 34 67 1 1925016240 5308256 10448080
14:18:40 6448 8192000000 10824142544 11258769408 1905975328 18.874 100 20 40 0 1918404448 6459344 5969776
14:18:58 6240 8192000000 10836831280 11264307200 1911397344 18.918 100 29 58 1 1925449296 5911568 8140384
14:19:10 5881 8192000000 10832910992 11266183168 1913530016 18.935 100 23 46 1 1926071776 6196256 6345504
14:19:24 3511 8192000000 10846398384 11273125888 1919892032 18.986 100 43 86 0 1940033616 8368032 11773552
14:19:34 6114 8192000000 10831241424 11267588096 1917601264 18.968 100 28 56 1 1932548880 6971376 7976240
14:19:48 8696 8192000000 10823863984 11263029248 1914729376 18.945 100 13 26 0 1923751552 4949248 4072928
14:20:05 10139 8192000000 10839310736 11270959104 1915739328 18.953 100 17 34 2 1926205136 5592256 4873552
14:20:23 9468 8192000000 10824636688 11267452928 1918934128 18.978 100 25 50 0 1932527328 5811200 7782000
14:20:38 6294 8192000000 10835476448 11266531328 1897434496 18.806 99 27 54 0 1916349200 10309296 8605408
14:20:53 6137 8192000000 10831142272 11263664128 1893515040 18.774 99 25 49 2 1906154800 6482880 6156880
14:21:07 10044 8192000000 10835187264 11262304256 1908152528 18.892 100 25 50 1 1921611136 5905264 7553344
14:21:23 10173 8192000000 10809497360 11246477312 1867044688 18.560 98 18 33 2 1877256496 5325552 4886256
14:21:41 12965 8192000000 10817769632 11256111104 1902737008 18.848 100 12 24 0 1911761184 5420512 3603664
14:22:01 48317 8192000000 10791910128 11221118976 1830256416 18.261 96 26 52 2 1842448720 4980544 7211760
14:23:21 1656 8192000000 10816855008 11218907136 1860363968 18.506 99 83 167 2 1892944336 8295232 24285136
14:23:30 7814 8192000000 10763579056 11189714944 1805028176 18.055 96 25 52 0 1818435952 6075296 7332480
14:23:46 8275 8192000000 10736388672 11156180992 1805101488 18.056 97 34 68 2 1820753712 5383472 10268752
14:24:00 6755 8192000000 10794012768 11213729792 1863055600 18.528 100 40 80 2 1886244384 11778336 11410448
14:24:16 4178 8192000000 10774207760 11193266176 1825461920 18.222 98 45 89 2 1845630464 7423744 12744800
14:24:28 9314 8192000000 10751672352 11176947712 1794267696 17.967 97 16 32 2 1808430448 9822528 4340224
14:24:44 7343 8192000000 10716615120 11129831424 1716485488 17.323 94 29 58 1 1731151456 6794816 7871152
14:25:00 10125 8192000000 10726772112 11143409664 1770463360 17.771 97 30 60 1 1788700208 9762432 8474416
14:25:17 10651 8192000000 10679079216 11092627456 1666718400 16.906 93 21 42 0 1678163568 4982816 6462352
14:25:36 10717 8192000000 10710278064 11122900992 1744522064 17.556 97 17 32 1 1754360320 5394640 4443616
14:25:52 9011 8192000000 10712305200 11129729024 1791086112 17.941 100 23 44 2 1802584064 5363008 6134944
14:26:08 8861 8192000000 10690146128 11103358976 1736255040 17.488 96 19 38 0 1747311040 5435952 5620048
14:26:26 50432 8192000000 10665992272 11076710400 1693498048 17.131 94 31 62 3 1707920528 5779552 8642928
14:27:30 17465 8192000000 10693932320 11118645248 1785656000 17.896 100 23 46 2 1798324112 6249872 6418240
14:27:56 9270 8192000000 10720917984 11138940928 1805000656 18.055 100 22 44 1 1816376832 5209696 6166480
14:28:14 6905 8192000000 10723027792 11144048640 1780743840 17.856 98 33 66 3 1797668304 6099904 10824560
14:28:29 6675 8192000000 10718667456 11140636672 1775774848 17.815 98 23 47 2 1788884784 5850784 7259152
14:28:45 6195 8192000000 10734109696 11152531456 1819994128 18.178 100 42 83 1 1838334576 6224032 12116416
14:28:57 11794 8192000000 10738855008 11164975104 1826377776 18.230 100 17 34 1 1837659664 5842288 5439600
14:29:19 8475 8192000000 10739838192 11169943552 1837843408 18.323 100 26 52 2 1851335712 5593392 7898912
14:29:38 5023 8192000000 10757176528 11183255552 1844219840 18.375 100 24 48 1 1856967024 5811632 6935552
14:29:53 13105 8192000000 10774282304 11194339328 1848349008 18.409 100 14 29 0 1856876688 4696192 3831488
14:30:16 6604 8192000000 10779817488 11199877120 1858071696 18.488 100 23 45 1 1870636016 6530144 6034176
14:30:31 11994 8192000000 10767724128 11199352832 1857970128 18.487 100 23 46 1 1871003056 5903248 7129680
14:30:55 10831 8192000000 10771551504 11203616768 1861154864 18.513 100 13 26 1 1870364752 5755200 3454688
14:31:15 10842 8192000000 10769438368 11207606272 1864258336 18.538 100 11 22 3 1872767616 5200832 3308448
14:31:32 16914 8192000000 10796186224 11213209600 1879324928 18.660 100 35 70 3 1897190496 5771056 12094512
14:32:19 69394 8192000000 10817468112 11238748160 1888298880 18.732 100 39 76 4 1906055344 6088640 11667824
14:33:38 24447 8192000000 10839387680 11261980672 1907495808 18.887 100 35 70 1 1924416432 7101520 9819104
14:34:11 20997 8192000000 10853501744 11275927552 1923442416 19.014 100 43 84 0 1944879840 9011216 12426208
14:34:40 8551 8192000000 10864294736 11283542016 1930232208 19.069 100 51 98 3 1952851520 8344320 14274992
14:35:01 26718 8192000000 10870082800 11295944704 1935037824 19.107 100 42 84 0 1956178448 9270752 11869872
14:35:40 39688 8192000000 10875194000 11311808512 1945021200 19.187 100 43 86 1 1972826752 15162432 12643120
14:36:28 25353 8192000000 10875994416 11311415296 1944711584 19.184 100 33 66 2 1964072768 9531760 9829424
14:37:04 5058 8192000000 10891544000 11320381440 1957234592 19.284 100 48 96 0 1982108080 11017360 13856128
14:37:21 11013 8192000000 10897141152 11324542976 1958517424 19.294 100 49 98 1 1984838256 12047264 14273568
14:37:43 24218 8192000000 10893572128 11331203072 1961643776 19.319 100 43 86 1 1985261232 11358080 12259376
14:38:22 13576 8192000000 10884200896 11325161472 1952577104 19.247 99 34 68 2 1977501168 13982240 10941824
14:38:47 4462 8192000000 10916582368 11340185600 1971110288 19.394 100 54 105 0 2003324640 17049648 15164704
14:39:00 9650 8192000000 10916216960 11345735680 1973722096 19.415 100 48 96 2 2003707552 15342208 14643248
14:39:17 3828 8192000000 10930084496 11355779072 1980681616 19.470 100 66 128 2 2017282608 17159472 19441520
14:39:28 3972 8192000000 10934521888 11362824192 1982433552 19.484 100 66 127 1 2023007712 21813808 18760352
14:39:40 8774 8192000000 10924867056 11354025984 1981624128 19.478 100 57 114 2 2015246112 16749584 16872400
14:40:18 20678 8192000000 10932815968 11374120960 1989588576 19.541 100 53 105 3 2026031312 20121664 16321072
14:40:47 16501 8192000000 10924257312 11361255424 1952599984 19.247 98 38 75 1 1985088432 20495760 11992688
14:41:10 9773 8192000000 10920989600 11359711232 1982618240 19.485 100 39 78 1 2012743472 18229344 11895888
14:41:28 12817 8192000000 10925897600 11365748736 1988933152 19.535 100 48 95 1 2022624304 19014608 14676544
14:41:49 5598 8192000000 10947725760 11380105216 1999698720 19.620 100 55 110 2 2033881952 17664432 16518800
14:42:05 10933 8192000000 10957573616 11389542400 2005936912 19.670 100 55 110 1 2041815824 19522352 16356560
14:42:29 15020 8192000000 10955520800 11395268608 2009719392 19.699 100 46 89 0 2044957968 21713888 13524688
14:42:55 6488 8192000000 10964361632 11397824512 2010856032 19.708 100 59 117 5 2052999200 24382992 17760176
14:43:12 3406 8192000000 10963332896 11392241664 1992971408 19.567 99 62 122 1 2037028016 25638016 18418592
14:43:27 8538 8192000000 10960980160 11393097728 2006661712 19.675 100 59 118 0 2049388240 24926496 17800032
14:43:44 5019 8192000000 10975659856 11400183808 2016368368 19.752 100 77 154 1 2065944864 25938240 23638256
14:43:56 2126 8192000000 10968391648 11395547136 2010489168 19.705 100 69 136 0 2058443296 27007504 20946624
14:44:05 4126 8192000000 10971737440 11400560640 2015904096 19.748 100 77 155 1 2066916352 27553920 23458336
14:44:23 8714 8192000000 10960385744 11385434112 1999521072 19.619 99 62 124 2 2047789520 29702688 18565760
14:44:47 4096 8192000000 10985239040 11404169216 2009366240 19.697 100 78 154 1 2067188528 33964560 23857728
14:44:59 5905 8192000000 10988225920 11405946880 2010418464 19.705 100 67 132 1 2067348576 36630464 20299648
14:45:12 7018 8192000000 10991432512 11418484736 2017183408 19.758 100 71 142 1 2076668944 37579232 21906304
14:45:30 5281 8192000000 10994937584 11418587136 2023813152 19.810 100 79 158 1 2082480352 35016048 23651152
14:45:43 8456 8192000000 10999244256 11423023104 2022942848 19.803 100 71 142 4 2082465792 38151120 21371824
14:46:02 2346 8192000000 11013912800 11432763392 2023209968 19.805 100 76 149 1 2085628304 39258416 23159920
14:46:11 4384 8192000000 11007935712 11431481344 2025247424 19.821 100 72 144 0 2089757152 42161104 22348624
14:46:22 1969 8192000000 10997595760 11414822912 2004628448 19.659 99 84 168 0 2073877952 42536928 26712576
14:46:32 4238 8192000000 11004715904 11428225024 2020280816 19.782 100 73 144 3 2084872448 42022768 22568864
14:46:48 1499 8192000000 11006616416 11425239040 2010563824 19.706 99 78 157 0 2075536112 40240976 24731312
14:46:56 2384 8192000000 11024723680 11438653440 2031830000 19.873 100 84 169 1 2098983120 41524528 25628592
14:47:05 7116 8192000000 11009634848 11433398272 2025782192 19.826 100 72 142 1 2090894976 43103184 22009600
14:47:20 3367 8192000000 11009791808 11434233856 2012255088 19.719 99 79 158 0 2082446784 44799808 25391888
14:47:32 2626 8192000000 10997711520 11424772096 2015378704 19.744 100 77 153 0 2088161344 48537856 24244784
14:47:42 2279 8192000000 10991387312 11408351232 2006058720 19.670 100 75 149 0 2073949248 45384416 22506112
14:47:56 2359 8192000000 10971209056 11399983104 1987095008 19.521 99 67 130 2 2053086496 45260688 20730800
14:48:08 2859 8192000000 10992268800 11423776768 2012169872 19.719 100 66 132 1 2081534688 48150704 21214112
14:48:20 2616 8192000000 11008507376 11432288256 2016936128 19.756 100 77 152 1 2088266192 47374336 23955728
14:48:31 4929 8192000000 11014673968 11438469120 2022748912 19.802 100 81 157 2 2095678816 48170976 24758928
14:48:43 3935 8192000000 11008321248 11434668032 2018907088 19.772 100 80 159 2 2094005552 49807712 25290752
14:48:53 1282 8192000000 11007486768 11425660928 2002181728 19.640 99 86 173 1 2078211280 50173808 25855744
14:49:03 3234 8192000000 11012776656 11431895040 2016514688 19.753 100 87 174 1 2094898304 51925808 26457808
14:49:14 5207 8192000000 10999805504 11433107456 2015343504 19.744 100 67 134 0 2090181184 53126512 21711168
14:49:26 11688 8192000000 10989782160 11435294720 2011388048 19.712 100 44 88 0 2074966304 48799872 14778384
14:49:52 2757 8192000000 10981028944 11410862080 1981137712 19.474 98 66 132 2 2053073792 50479488 21456592
14:50:03 6761 8192000000 10999296096 11438325760 2011760352 19.715 100 53 105 1 2084378224 55309440 17308432
14:50:21 5414 8192000000 10988758336 11412852736 1988669280 19.533 99 65 131 3 2063291360 53660368 20961712
14:50:34 3692 8192000000 10991833520 11411382272 1993362560 19.570 99 77 150 2 2072993968 55946400 23685008
14:50:45 1247 8192000000 11016127664 11431788544 2008709376 19.691 100 87 173 0 2093911344 58261648 26940320
14:50:54 2938 8192000000 11021829376 11434528768 2010869216 19.708 100 88 174 1 2101606144 63073328 27663600
14:51:05 2258 8192000000 11012846656 11425046528 1997455360 19.603 100 88 176 0 2089290960 64080464 27755136
14:51:16 3108 8192000000 11011201920 11434487808 2006408240 19.673 100 72 144 1 2092215824 62980656 22826928
14:51:26 6004 8192000000 11002770032 11433455616 2009469808 19.697 100 59 118 0 2086571744 58017296 19084640
14:51:44 9626 8192000000 10968652112 11413471232 1978283744 19.451 99 33 66 1 2042876864 53226272 11366848
14:52:06 8085 8192000000 10986860704 11417739264 1983200368 19.490 99 51 102 1 2054007184 54615088 16191728
14:52:25 5770 8192000000 10985003184 11408515072 1949773984 19.225 97 65 127 3 2025905360 56267392 19863984
14:52:41 7771 8192000000 10979494992 11414134784 1986580352 19.517 100 55 109 0 2065954992 61280416 18094224
14:52:59 15643 8192000000 10949649856 11391447040 1923435296 19.014 97 41 82 2 1996497088 59014848 14046944
14:53:26 13150 8192000000 10953369488 11397173248 1955301024 19.269 99 42 84 0 2030981808 61709856 13970928
14:53:53 25276 8192000000 10956977152 11395944448 1968756320 19.376 100 30 60 2 2037402080 58251808 10393952
14:54:29 11242 8192000000 10977730240 11419148288 1985249088 19.506 100 43 86 1 2061877312 62602128 14026096
14:54:53 22755 8192000000 10971942016 11419586560 1981706320 19.478 100 33 66 0 2060401376 67097584 11597472
14:55:35 21034 8192000000 10957152816 11403558912 1968511008 19.374 100 35 70 0 2041167408 60497744 12158656
14:56:12 21522 8192000000 10969166112 11419545600 1954925120 19.266 99 27 54 1 2037552176 73433584 9193472
14:56:47 12801 8192000000 10961204256 11408498688 1964705472 19.343 100 25 50 0 2043617552 69898448 9013632
14:57:51 16157 8192000000 10942635120 11401216000 1922924960 19.010 99 23 46 3 2014114720 82022000 9167760
14:58:13 5760 8192000000 10943983936 11409059840 1933850704 19.098 100 25 50 1 2029361488 85916752 9594032
14:58:44 12953 8192000000 10928543920 11400278016 1929336208 19.062 100 21 42 0 2017385712 79484816 8564688
14:59:07 13384 8192000000 10905387904 11373727744 1910719792 18.912 99 18 36 0 1970965744 53897008 6348944
14:59:31 52671 8192000000 10885559712 11334803456 1894576256 18.783 98 16 32 1 1923700784 24201728 4922800
15:00:41 90912 8192000000 10847701088 11302948864 1875789408 18.631 96 35 70 0 1896663472 10453776 10420288
15:02:19 80291 8192000000 10806291984 11268796416 1770539248 17.771 92 20 40 0 1784032096 8356128 5136720
15:04:07 48827 8192000000 10833348800 11292131328 1891611232 18.759 99 19 38 0 1905107088 8698080 4797776
15:05:11 200063 8192000000 10860026224 11334004736 1853893152 18.454 96 13 24 1 1878489472 21305648 3290672
15:09:09 62827 8192000000 10873752000 11322404864 1919889184 18.986 99 27 48 0 1941797520 14715680 7192656
15:10:19 31274 8192000000 10844302160 11311722496 1897730928 18.808 98 33 67 0 1925351344 18397664 9222752
15:10:59 74915 8192000000 10856987168 11318312960 1896592560 18.799 98 16 32 1 1915737536 14205088 4939888
15:12:35 67436 8192000000 10868552928 11323871232 1924949728 19.026 99 21 40 3 1939933808 9624736 5359344
15:13:54 53650 8192000000 10859333600 11324657664 1925500816 19.031 99 12 24 0 1936303664 7530288 3272560
15:15:11 48498 8192000000 10849278416 11304316928 1909243840 18.901 98 25 48 2 1927241504 11204208 6793456
15:16:07 92864 8192000000 10870437136 11343253504 1944144160 19.180 100 32 64 3 1974127856 20496224 9487472
15:17:55 40919 8192000000 10877206432 11359006720 1948137392 19.212 100 6 12 1 1972804624 22845424 1821808
15:18:42 29078 8192000000 10885991632 11365027840 1957701984 19.288 100 12 24 1 1985546384 24172736 3671664
15:19:18 111592 8192000000 10873980416 11346149376 1893480352 18.774 97 9 18 0 1914774480 19125472 2168656
15:21:17 65543 8192000000 10893568416 11354169344 1954142720 19.259 100 20 40 0 1975381104 15184288 6054096
15:22:36 48978 8192000000 10868646800 11341750272 1937395104 19.126 99 16 32 0 1951049392 9279376 4374912
15:23:38 62190 8192000000 10893798416 11356708864 1958363040 19.293 100 21 42 1 1972341856 7945664 6033152
15:24:46 42953 8192000000 10926925584 11365646336 1972470192 19.405 100 44 88 0 1996427056 11952912 12003952
15:25:39 23165 8192000000 10917438624 11377053696 1976140320 19.434 100 36 71 1 1996386208 10844352 9401536
15:26:08 25459 8192000000 10908813872 11373428736 1956538880 19.279 99 41 81 1 1980931984 13197520 11195584
15:26:41 64508 8192000000 10909950912 11386273792 1973350816 19.412 100 15 30 0 1990035072 12726704 3957552
15:28:10 54825 8192000000 10929691840 11379445760 1966254608 19.356 99 32 64 2 1987058304 11760176 9043520
15:29:11 38044 8192000000 10900994720 11380011008 1968688048 19.375 99 34 68 0 1989012752 10804944 9519760
15:29:56 42310 8192000000 10948551984 11399696384 1990834800 19.550 100 30 60 0 2009162656 9651840 8676016
15:30:59 51901 8192000000 10932193184 11407798272 1977400048 19.444 99 33 66 0 2003083104 16591696 9091360
15:32:51 110900 8192000000 10926349088 11400003584 1991554672 19.556 99 41 82 2 2011355984 9012768 10788544
15:34:49 72098 8192000000 10920510816 11388903424 1957435744 19.286 97 33 66 0 1979748608 12463744 9849120
15:36:21 75111 8192000000 10913751120 11399127040 1982930080 19.488 99 11 21 0 2000940000 14949152 3060768
15:37:45 113579 8192000000 10907588144 11394256896 1959715520 19.304 98 17 34 2 1979883408 14766544 5401344
15:39:55 80388 8192000000 10907050400 11401687040 1965374016 19.349 98 13 26 0 1988520960 19483040 3663904
15:41:22 70291 8192000000 10936232944 11400163328 1965292896 19.348 98 19 38 0 1982910464 11880112 5737456
15:42:49 86697 8192000000 10896167520 11375939584 1889922128 18.745 95 14 28 0 1904883760 10951728 4009904
15:44:24 65178 8192000000 10890626672 11349061632 1897827968 18.809 96 30 60 0 1918144208 11907040 8409200
15:45:59 49001 8192000000 10865830784 11327225856 1872542320 18.605 96 19 38 1 1888318096 10632480 5143296
15:46:55 68155 8192000000 10873635952 11338031104 1866196704 18.553 96 16 32 1 1884473984 14203840 4073440
15:48:09 88267 8192000000 10857833104 11343253504 1862131376 18.521 96 13 26 0 1890060432 24378976 3550080
15:49:44 59489 8192000000 10873418528 11310284800 1863134864 18.529 96 31 62 1 1879785712 8497040 8153808
15:51:02 54722 8192000000 10850371008 11309686784 1843161056 18.367 95 33 66 2 1869582960 17094304 9327600
15:52:06 74681 8192000000 10846324640 11322490880 1883350880 18.692 98 13 25 2 1898514816 11890864 3273072
15:53:28 94405 8192000000 10856541984 11325698048 1902135792 18.843 99 15 30 0 1930857920 24096960 4625168
15:56:16 121497 8192000000 10882537936 11364118528 1910141488 18.908 98 11 22 0 1935594496 22261488 3191520
15:58:24 60120 8192000000 10867592368 11336151040 1909689904 18.904 98 12 23 1 1930259888 17036464 3533520
15:59:35 20942 8192000000 10869609216 11346333696 1938202128 19.132 100 7 14 3 1961247856 20674352 2371376
16:00:02 47831 8192000000 10871625312 11355635712 1941352512 19.158 100 7 14 0 1962205504 18743360 2109632
16:01:04 102678 8192000000 10881021152 11345567744 1886994352 18.722 96 13 26 0 1902457136 11957168 3505616
16:02:54 22600 8192000000 10915286592 11364057088 1966498208 19.358 100 42 80 3 1990701888 12716128 11487552
16:03:31 106495 8192000000 10886052592 11355574272 1883001616 18.689 96 9 18 0 1896147296 10984176 2161504
16:05:27 85392 8192000000 10902010192 11376730112 1929530592 19.063 98 18 36 1 1945954384 11560912 4862880
16:07:15 132238 8192000000 10887169056 11345219584 1788461456 17.919 91 9 18 0 1810893168 19902832 2528880
16:10:00 31816 8192000000 10902025712 11342413824 1922318368 19.005 98 41 83 2 1947645664 13944352 11382944
16:10:40 96194 8192000000 10874843200 11345629184 1892822976 18.769 97 36 72 0 1914828720 11953392 10052352
16:12:26 53829 8192000000 10903980112 11362467840 1941194752 19.156 99 19 39 2 1959558640 13347760 5016128
16:13:25 24215 8192000000 10923075184 11368116224 1971729344 19.399 100 43 86 3 1991723584 8115824 11878416
16:14:04 22002 8192000000 10919611008 11373522944 1945573536 19.191 98 50 98 1 1968587504 9242512 13771456
16:14:33 118667 8192000000 10877132624 11339366400 1911443904 18.918 97 22 44 0 1932725552 15554528 5727120
16:16:48 78006 8192000000 10896456368 11366760448 1937210176 19.124 98 26 52 1 1957450896 12853744 7386976
16:18:23 87413 8192000000 10889825376 11372900352 1957498864 19.286 100 19 38 1 1980716448 17255184 5962400
16:20:01 25358 8192000000 10884262512 11380097024 1959125968 19.299 100 3 6 1 1982739248 22602096 1011184
16:20:47 24966 8192000000 10888144064 11365658624 1972642144 19.406 100 12 24 0 1984361264 8962848 2756272
16:21:18 65930 8192000000 10897519792 11374542848 1977827472 19.447 100 7 14 0 1986336320 6882560 1626288
16:22:32 69786 8192000000 10903726416 11372556288 1966358160 19.357 99 13 26 1 1976912256 6794608 3759488
16:23:51 54963 8192000000 10890339792 11368005632 1963989728 19.338 99 15 30 1 1975152592 6970464 4192400
16:25:04 66193 8192000000 10908939168 11387166720 1965947008 19.353 99 12 24 0 1976285184 7295456 3042720
16:26:27 70852 8192000000 10917172768 11398373376 1978892160 19.456 99 12 24 0 1995508240 13205488 3410592
16:27:49 53869 8192000000 10907787760 11384074240 1977267072 19.443 99 13 24 0 1989611344 8531936 3812336
16:28:52 49535 8192000000 10928696400 11401273344 1985664576 19.510 99 27 54 1 2004035984 11103168 7268240
16:30:00 62873 8192000000 10904970448 11380580352 1922087952 19.004 96 17 34 1 1939704448 12778688 4837808
16:31:10 41279 8192000000 10911179712 11374903296 1957436528 19.286 99 12 24 1 1969880624 9193952 3250144
16:31:58 12198 8192000000 9052663600 9258106880 220303824 2.618 12 4 6 1 224257840 3067296 886720

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 17-12-2020 16:33:12 to 17-12-2020 16:33:42.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 122 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 17-12-2020 16:33:43 to 17-12-2020 16:33:45.

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          227436
MON$OLDEST_ACTIVE               227437
MON$OLDEST_SNAPSHOT             227437
MON$NEXT_TRANSACTION            227437
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                       2017088
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

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

17.12.20 16:33:46. 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-17 16:33:48 No severe PSQL-related problems occured
17.12.20 16:33:50. End of report.