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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-21 19:27:02
DTS_END                         2020-11-21 19:27:01.9980
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/49526
TRN_ID                          232943
ATT_ID                          627
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: 9009.33 20774 1081120
customer order: creation 168.30 336 20196
customer order: refuse 14.10 372 1692
order to supplier: creation 44.48 1278 5338
order to supplier: removal 3.36 96062 403
invoice (draft): creation 44.89 3329 5387
invoice (draft): removal 51.74 759 6209
invoice accept: apply 40.60 17742 4872
invoice accept: cancel 46.88 746 5626
customer reserve: creation 3725.67 176 447080
customer reserve: removal 4567.08 55 548050
realization accept: apply 81.80 197 9816
realization accept: cancel 91.40 102 10968
payment from customer: creation 58.90 119 7068
payment from customer: removal 5.63 68 676
payment to supplier: creation 48.64 129 5837
payment to supplier: removal 3.28 100 393
service: total inventory turnovers 5.14 939 617
service: total monetary turnovers 6.56 51 787
service: aggregate perf. data 0.84 18372 101
service: refresh index statistics 0.03 274557 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 21-11-2020 19:28:35 to 21-11-2020 19:28:37.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4089
TEST_TIME 2 4663
TEST_TIME 3 5191
TEST_TIME 4 4939
TEST_TIME 5 4753
TEST_TIME 6 4721
TEST_TIME 7 4630
TEST_TIME 8 4769
TEST_TIME 9 5242
TEST_TIME 10 6039
TEST_TIME 11 6429
TEST_TIME 12 6725
TEST_TIME 13 6770
TEST_TIME 14 7018
TEST_TIME 15 7392
TEST_TIME 16 8202
TEST_TIME 17 8452
TEST_TIME 18 8492
TEST_TIME 19 8830
TEST_TIME 20 9082
TEST_TIME 21 9234
TEST_TIME 22 9444
TEST_TIME 23 9275
TEST_TIME 24 10632
TEST_TIME 25 11082
TEST_TIME 26 10898
TEST_TIME 27 10917
TEST_TIME 28 10755
TEST_TIME 29 10645
TEST_TIME 30 10543
TEST_TIME 31 10454
TEST_TIME 32 10323
TEST_TIME 33 10191
TEST_TIME 34 10271
TEST_TIME 35 10165
TEST_TIME 36 10140
TEST_TIME 37 9914
TEST_TIME 38 9819
TEST_TIME 39 9691
TEST_TIME 40 9705
TEST_TIME 41 9731
TEST_TIME 42 9678
TEST_TIME 43 9650
TEST_TIME 44 9491
TEST_TIME 45 9345
TEST_TIME 46 9597
TEST_TIME 47 9746
TEST_TIME 48 9762
TEST_TIME 49 9666
TEST_TIME 50 9654
TEST_TIME 51 9625
TEST_TIME 52 9835
TEST_TIME 53 9792
TEST_TIME 54 9746
TEST_TIME 55 9749
TEST_TIME 56 9660
TEST_TIME 57 9779
TEST_TIME 58 9847
TEST_TIME 59 9980
TEST_TIME 60 9826
TEST_TIME 61 9720
TEST_TIME 62 9736
TEST_TIME 63 9677
TEST_TIME 64 9634
TEST_TIME 65 9571
TEST_TIME 66 9522
TEST_TIME 67 9443
TEST_TIME 68 9388
TEST_TIME 69 9366
TEST_TIME 70 9374
TEST_TIME 71 9307
TEST_TIME 72 9340
TEST_TIME 73 9372
TEST_TIME 74 9339
TEST_TIME 75 9358
TEST_TIME 76 9308
TEST_TIME 77 9310
TEST_TIME 78 9417
TEST_TIME 79 9411
TEST_TIME 80 9445
TEST_TIME 81 9476
TEST_TIME 82 9448
TEST_TIME 83 9457
TEST_TIME 84 9451
TEST_TIME 85 9518
TEST_TIME 86 9448
TEST_TIME 87 9394
TEST_TIME 88 9358
TEST_TIME 89 9298
TEST_TIME 90 9298
TEST_TIME 91 9264
TEST_TIME 92 9194
TEST_TIME 93 9199
TEST_TIME 94 9214
TEST_TIME 95 9195
TEST_TIME 96 9193
TEST_TIME 97 9246
TEST_TIME 98 9228
TEST_TIME 99 9275
TEST_TIME 100 9297
TEST_TIME 101 9297
TEST_TIME 102 9343
TEST_TIME 103 9301
TEST_TIME 104 9301
TEST_TIME 105 9283
TEST_TIME 106 9352
TEST_TIME 107 9379
TEST_TIME 108 9353
TEST_TIME 109 9287
TEST_TIME 110 9258
TEST_TIME 111 9238
TEST_TIME 112 9208
TEST_TIME 113 9161
TEST_TIME 114 9171
TEST_TIME 115 9149
TEST_TIME 116 9108
TEST_TIME 117 9091
TEST_TIME 118 9075
TEST_TIME 119 9085
TEST_TIME 120 9011

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 21-11-2020 19:28:38 to 21-11-2020 19:28:42.

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 1496351 1496351 0 0.00 0 14353 6 0 0
doc_list_biud 1496351 1496351 0 0.00 0 39844 26 0 0
sp_add_invoice_to_stock 5021 4872 149 2.96 36 185496 17743 0 149
sp_cancel_adding_invoice 5626 5626 0 0.00 5 60638 746 0 0
sp_cancel_client_order 1692 1692 0 0.00 4 19242 372 0 0
sp_cancel_customer_reserve 548050 548050 0 0.00 1 20464 55 0 0
sp_cancel_pay_from_customer 676 676 0 0.00 3 2871 69 0 0
sp_cancel_pay_to_supplier 393 393 0 0.00 2 4508 101 0 0
sp_cancel_supplier_invoice 6218 6209 9 0.14 1 39854 760 0 9
sp_cancel_supplier_order 403 403 0 0.00 4 1073365 96062 0 0
sp_cancel_write_off 10968 10968 0 0.00 1 16188 102 0 0
sp_client_order 20196 20196 0 0.00 3 25254 337 0 0
sp_customer_reserve 447080 447080 0 0.00 0 47024 176 0 0
sp_fill_shopping_cart 30913 30913 0 0.00 1 12448 40 0 0
sp_fill_shopping_cart_clo_res 447077 447077 0 0.00 0 11823 14 0 0
sp_get_clo_for_invoice 4869 4869 0 0.00 0 20838 321 0 0
sp_kill_cost_storno 17663 17663 0 0.00 0 5632 53 0 0
sp_kill_qstorno_ret_qs2qd 1113680 1113680 0 0.00 0 39840 30 0 0
sp_kill_qty_storno 587633 587633 0 0.00 0 39842 65 0 0
sp_lock_selected_doc 20258 20258 0 0.00 0 7595 5 0 0
sp_make_cost_storno 27590 27590 0 0.00 0 14210 60 0 0
sp_multiply_rows_for_pdistr 27590 27590 0 0.00 0 9569 32 0 0
sp_multiply_rows_for_qdistr 20196 20196 0 0.00 0 23586 150 0 0
sp_pay_from_customer 7068 7068 0 0.00 4 21733 120 0 0
sp_pay_to_supplier 5837 5837 0 0.00 5 9218 130 0 0
sp_payment_common 12905 12905 0 0.00 1 21728 33 0 0
sp_qd_handle_on_cancel_clo 1692 1692 0 0.00 0 19209 334 0 0
sp_qd_handle_on_invoice_upd_sts 10495 10495 0 0.00 0 16983 325 0 0
sp_qd_handle_on_reserve_upd_sts 9816 9816 0 0.00 0 18491 67 0 0
sp_reserve_write_off 9816 9816 0 0.00 6 18502 197 0 0
sp_supplier_invoice 5387 5387 0 0.00 6 89449 3330 0 0
sp_supplier_order 5338 5338 0 0.00 5 38593 1278 0 0
srv_aggregate_perf_data 102 101 1 0.98 2670 144332 18373 0 1
srv_fill_mon_cache_memory 149 149 0 0.00 1055 146822 35273 0 0
srv_find_qd_qs_mism 1035010 1035010 0 0.00 0 14352 5 0 0
srv_make_invnt_saldo 617 617 0 0.00 35 49195 939 0 0
srv_make_money_saldo 787 787 0 0.00 1 10601 52 0 0
srv_recalc_idx_stat 4 4 0 0.00 233871 300353 274557 0 0
t$perf-abend:sp_add_invoice_to_stock 149 149 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 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 4872 4872 0 0.00 0 8604 167 0 0
t$perf-norm:sp_cancel_adding_invoice 393 393 0 0.00 0 6371 116 0 0
t$perf-norm:sp_cancel_client_order 1692 1692 0 0.00 0 3683 9 0 0
t$perf-norm:sp_cancel_customer_reserve 645 645 0 0.00 0 9901 32 0 0
t$perf-norm:sp_cancel_pay_from_customer 676 676 0 0.00 0 880 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 393 393 0 0.00 0 281 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 405 405 0 0.00 0 1207 18 0 0
t$perf-norm:sp_cancel_supplier_order 403 403 0 0.00 0 32257 1463 0 0
t$perf-norm:sp_cancel_write_off 966 966 0 0.00 0 4769 10 0 0
t$perf-norm:sp_client_order 20196 20196 0 0.00 0 11249 18 0 0
t$perf-norm:sp_customer_reserve 930 930 0 0.00 0 2424 9 0 0
t$perf-norm:sp_pay_from_customer 7068 7068 0 0.00 0 5907 10 0 0
t$perf-norm:sp_pay_to_supplier 5837 5837 0 0.00 0 3172 8 0 0
t$perf-norm:sp_reserve_write_off 9816 9816 0 0.00 0 5470 8 0 0
t$perf-norm:sp_supplier_invoice 5387 5387 0 0.00 0 11021 17 0 0
t$perf-norm:sp_supplier_order 5338 5338 0 0.00 0 4705 15 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 424 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 149 149 0 0.00 0 357 8 0 0
t$perf-norm:srv_make_invnt_saldo 617 617 0 0.00 0 5180 38 0 0
t$perf-norm:srv_make_money_saldo 787 787 0 0.00 0 4939 24 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 123 32 0 0
v_add_invoice_to_stock 10036 9738 298 2.96 0 5603 18 0 298
v_all_customers 36826 36826 0 0.00 0 30 1 0 0
v_all_suppliers 29754 29754 0 0.00 0 49 1 0 0
v_all_wares 40392 40392 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 786 786 0 0.00 0 1157 7 0 0
v_cancel_client_order 3384 3384 0 0.00 0 3966 9 0 0
v_cancel_customer_prepayment 1352 1352 0 0.00 0 2230 7 0 0
v_cancel_customer_reserve 1290 1290 0 0.00 0 637 4 0 0
v_cancel_payment_to_supplier 786 786 0 0.00 0 2314 7 0 0
v_cancel_supplier_invoice 828 810 18 2.17 0 1197 17 0 18
v_cancel_supplier_order 806 806 0 0.00 0 3570 11 0 0
v_cancel_write_off 1932 1932 0 0.00 0 3717 13 0 0
v_max_id_clo_ord 5338 5338 0 0.00 0 3828 2 0 0
v_max_id_clo_res 930 930 0 0.00 0 2913 19 0 0
v_max_id_ord_sup 5379 5379 0 0.00 0 4301 5 0 0
v_max_non_paid_invoice 1677 1677 0 0.00 0 1252 3 0 0
v_max_non_paid_realizn 3753 3753 0 0.00 0 2030 3 0 0
v_min_id_clo_ord 5338 5338 0 0.00 0 8898 12 0 0
v_min_id_clo_res 930 930 0 0.00 0 4283 9 0 0
v_min_id_ord_sup 5379 5379 0 0.00 0 5126 9 0 0
v_min_non_paid_invoice 5837 5837 0 0.00 0 6374 23 0 0
v_min_non_paid_realizn 7068 7068 0 0.00 0 8600 20 0 0
v_our_firm 10196 10196 0 0.00 0 22 1 0 0
v_reserve_write_off 19632 19632 0 0.00 0 3927 4 0 0
x_lock_depdocs_on_canc_invoice 11430 11430 0 0.00 0 14017 120 0 0
x_lock_depdocs_on_canc_sup_ord 403 403 0 0.00 0 7155 317 0 0
x_make_qstorno_1000_1200 5338 5338 0 0.00 2 38584 1185 0 0
x_make_qstorno_1200_2000 5387 5387 0 0.00 3 89417 3198 0 0
x_make_qstorno_2100_3300 447080 447080 0 0.00 0 47023 160 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-11-2020 19:28:43 to 21-11-2020 19:28:47.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:05 3 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:12 20067 8192000000 10252347984 10557251584 903851696 9.936 72 51 103 0 923986272 2668896 17465680
16:57:38 25247 8192000000 10345352832 10662457344 1382275216 14.437 100 83 166 0 1414627632 4675504 27676912
16:58:13 23034 8192000000 10381780896 10704379904 1435818160 14.913 100 87 173 1 1470718192 6064176 28835856
16:58:46 36060 8192000000 10415045712 10748264448 1462052368 15.144 100 84 168 1 1496662880 7161456 27449056
16:59:33 35684 8192000000 10461320608 10795274240 1508024688 15.546 100 88 176 0 1544254896 7914976 28315232
17:00:24 21852 8192000000 10476051280 10819891200 1538036576 15.807 100 88 176 0 1575083600 9338128 27708896
17:00:57 16866 8192000000 10505531072 10849742848 1561636416 16.010 100 81 162 0 1595679136 9270576 24772144
17:01:29 13119 8192000000 10531384640 10877952000 1584563872 16.207 100 85 170 1 1620941712 10077728 26300112
17:01:52 14894 8192000000 10551841936 10904158208 1601325424 16.351 100 78 157 2 1635613264 10410128 23877712
17:02:16 12642 8192000000 10583181440 10935291904 1633776896 16.627 100 84 168 0 1670322896 11621808 24924192
17:02:38 15948 8192000000 10589984832 10951991296 1648012544 16.748 100 85 170 0 1685457840 12231328 25213968
17:03:03 15068 8192000000 10609467184 10972151808 1665088096 16.892 100 76 152 1 1699471232 12071088 22312048
17:03:27 14688 8192000000 10635131200 11002159104 1682416016 17.038 100 76 152 1 1717657808 12565280 22676512
17:03:51 6913 8192000000 10640607968 11009236992 1705335088 17.230 100 86 173 1 1743462720 12932592 25195040
17:04:06 10943 8192000000 10650147328 11020935168 1710060800 17.269 100 87 172 1 1747806720 13007152 24738768
17:04:27 8228 8192000000 10661068560 11032776704 1721687808 17.366 100 73 147 0 1755772704 13274960 20809936
17:04:43 8387 8192000000 10675371136 11050926080 1735872320 17.484 100 88 176 4 1775412496 14007856 25532320
17:04:59 5021 8192000000 10685196352 11061936128 1747618160 17.582 100 77 153 2 1781407312 12767824 21021328
17:05:12 3684 8192000000 10702901824 11079819264 1765741296 17.732 100 87 171 1 1803145504 13231008 24173200
17:05:23 4948 8192000000 10711851968 11085066240 1772055712 17.784 100 86 172 1 1809880832 14176128 23648992
17:05:36 4022 8192000000 10729245936 11108179968 1780683136 17.855 100 83 163 5 1816685040 13297392 22704512
17:05:46 3637 8192000000 10728665616 11105927168 1790223392 17.934 100 87 174 0 1827743280 13223712 24296176
17:05:58 3449 8192000000 10739246816 11121102848 1799121088 18.007 100 88 174 1 1836947408 13796208 24030112
17:06:09 3701 8192000000 10736675088 11120316416 1799119840 18.007 100 78 156 1 1835154416 14404496 21630080
17:06:18 3008 8192000000 10739870608 11123658752 1808866000 18.087 100 91 180 0 1847921456 14430832 24624624
17:06:29 2084 8192000000 10758527440 11136794624 1812266240 18.114 100 92 182 0 1851499472 13987024 25246208
17:06:37 11295 8192000000 10751951008 11137044480 1816509600 18.149 100 80 160 0 1852069936 13999584 21560752
17:06:56 2857 8192000000 10756643424 11143962624 1817000912 18.153 100 83 166 0 1854470896 14661568 22808416
17:07:06 1945 8192000000 10768638768 11152474112 1829500704 18.255 100 86 172 3 1867378464 13413104 24464656
17:07:15 3675 8192000000 10783567824 11167404032 1839860832 18.340 100 89 178 0 1877832464 13012432 24959200
17:07:25 2236 8192000000 10787034416 11170996224 1843324624 18.368 100 87 176 2 1881194224 12955536 24914064
17:07:34 1893 8192000000 10784738992 11174240256 1846159072 18.391 100 93 184 1 1884893824 13082864 25651888
17:07:42 2059 8192000000 10800197104 11182329856 1847393600 18.401 100 96 191 1 1888565008 14359360 26812048
17:07:50 1819 8192000000 10800197040 11186323456 1849389184 18.417 100 92 182 2 1889207312 14340688 25477440
17:07:59 1669 8192000000 10796734944 11185274880 1857576720 18.484 100 94 188 1 1897894624 13608944 26708960
17:08:06 1640 8192000000 10800931568 11187245056 1855464256 18.466 100 83 164 1 1891653456 11749056 24440144
17:08:14 1882 8192000000 10800918416 11193683968 1862318336 18.522 100 92 181 0 1900607904 11813168 26476400
17:08:23 13204 8192000000 10801725584 11194507264 1861544176 18.516 100 72 144 2 1892706800 11047120 20115504
17:08:43 1483 8192000000 10804779088 11201159168 1865510992 18.548 100 73 146 0 1898214160 11988800 20714368
17:08:53 1951 8192000000 10803838688 11195891712 1868319824 18.571 100 81 161 3 1902706480 11799984 22586672
17:09:02 3648 8192000000 10789429920 11199049728 1863528992 18.532 100 51 103 0 1889136576 11433072 14174512
17:09:12 4695 8192000000 10790007184 11196366848 1863277376 18.530 100 45 90 1 1885103856 8973584 12852896
17:09:24 3268 8192000000 10805320160 11202891776 1870650944 18.590 100 73 147 1 1900874800 9482864 20740992
17:09:33 3937 8192000000 10794051312 11199569920 1867750624 18.566 100 57 112 1 1894110640 10967952 15392064
17:09:44 7524 8192000000 10779151648 11199483904 1868248208 18.570 100 29 58 1 1884353872 8007168 8098496
17:10:01 2600 8192000000 10785635920 11199832064 1873395344 18.612 100 46 92 0 1895830784 9219632 13215808
17:10:12 57352 8192000000 10822320016 11231084544 1877948320 18.649 100 41 84 0 1895813280 5339408 12525552
17:11:15 13557 8192000000 10798304528 11229585408 1876882800 18.640 100 32 63 3 1896811808 11499328 8429680
17:11:35 9710 8192000000 10797656576 11225534464 1878037552 18.649 100 24 48 1 1891805616 7056800 6711264
17:11:52 2660 8192000000 10796804832 11223457792 1882469760 18.685 100 40 80 0 1901579360 7764960 11344640
17:12:06 4474 8192000000 10809559200 11227607040 1881608240 18.678 100 35 70 4 1899508032 7413936 10485856
17:12:17 5451 8192000000 10803495264 11231809536 1882237296 18.683 100 32 62 1 1902632272 11760464 8634512
17:12:30 7436 8192000000 10801473584 11228340224 1880409152 18.668 100 20 39 2 1897043280 9772368 6861760
17:12:43 4969 8192000000 10793423696 11227414528 1881208688 18.675 100 26 52 1 1898653024 9839280 7605056
17:12:55 6231 8192000000 10809811712 11228942336 1880488384 18.669 100 20 41 1 1892374704 6050656 5835664
17:13:13 7287 8192000000 10793267504 11224014848 1880199552 18.667 100 18 36 0 1891674656 6297552 5177552
17:13:26 13793 8192000000 10810122240 11232210944 1883129936 18.690 100 26 52 0 1897031472 6430592 7470944
17:13:49 11604 8192000000 10795448320 11227922432 1882757056 18.687 100 24 48 2 1896240192 5968912 7514224
17:14:07 7330 8192000000 10804113520 11227250688 1882867632 18.688 100 17 34 2 1893360512 5940560 4552320
17:14:20 18544 8192000000 10791515392 11229147136 1891550080 18.758 100 20 39 2 1902935840 5230112 6155648
17:15:19 15598 8192000000 10807441232 11242229760 1892780720 18.768 100 35 69 2 1913787120 11048016 9958384
17:15:43 8313 8192000000 10801960384 11236663296 1892765312 18.768 100 25 50 0 1905268704 5980560 6522832
17:16:00 6269 8192000000 10793380640 11229458432 1886518480 18.718 100 27 54 2 1900960752 6493168 7949104
17:16:15 7097 8192000000 10827225952 11239845888 1893296464 18.772 100 48 97 3 1914338368 7075456 13966448
17:16:28 4183 8192000000 10806319328 11240886272 1891870368 18.761 100 29 58 1 1906993808 6688880 8434560
17:16:40 6283 8192000000 10801668320 11239493632 1891849344 18.761 100 28 56 0 1906538640 6837344 7851952
17:16:54 9813 8192000000 10794360496 11228848128 1871311888 18.595 99 27 52 2 1884369312 5572208 7485216
17:17:11 5907 8192000000 10798124480 11227824128 1871057136 18.593 99 36 72 2 1888117904 6059264 11001504
17:17:24 8272 8192000000 10794979136 11224367104 1859605136 18.500 99 18 36 1 1870554960 6236384 4713440
17:17:40 7198 8192000000 10791590624 11228524544 1882670656 18.687 100 17 33 2 1893118256 5484192 4963408
17:17:55 5995 8192000000 10795710368 11218419712 1862482208 18.523 99 32 63 2 1881516048 10126864 8906976
17:18:08 14242 8192000000 10718732912 11140149248 1698007952 17.168 91 15 30 3 1707313056 4767536 4537568
17:18:29 13529 8192000000 10695324880 11113885696 1728138240 17.420 95 15 30 0 1738136176 5439408 4558528
17:18:50 11009 8192000000 10729711104 11144736768 1743377248 17.547 95 23 40 3 1754090976 4282976 6430752
17:19:07 65938 8192000000 10703560416 11128107008 1688981312 17.093 92 32 64 0 1704299968 5373888 9944768
17:20:20 13404 8192000000 10741807328 11158118400 1733612272 17.466 95 24 48 0 1746972736 6450784 6909680
17:20:39 7493 8192000000 10724880928 11136921600 1741552528 17.532 96 37 73 1 1758313040 6430272 10330240
17:20:55 6394 8192000000 10718315584 11139633152 1802250752 18.032 100 28 56 4 1816643296 6579888 7812656
17:21:08 5371 8192000000 10717791024 11133132800 1776115584 17.817 98 36 72 0 1794377104 7986944 10274576
17:21:23 6216 8192000000 10714990544 11133902848 1785101456 17.891 99 28 56 3 1804232304 11099792 8031056
17:21:36 8597 8192000000 10717730960 11137863680 1805765072 18.061 99 27 54 2 1820332960 5809712 8758176
17:21:53 4461 8192000000 10729483776 11148345344 1806137712 18.064 99 29 58 4 1824118336 10019280 7961344
17:22:04 5982 8192000000 10715157792 11128934400 1788186816 17.917 98 32 64 1 1803340832 5521136 9632880
17:22:17 5280 8192000000 10717379200 11130220544 1780547248 17.854 98 31 63 1 1795954960 6598016 8809696
17:22:33 6029 8192000000 10736095392 11159494656 1801491440 18.026 99 24 49 2 1813875248 5346736 7037072
17:22:46 9655 8192000000 10744089200 11166486528 1815289392 18.139 99 24 48 2 1827969552 5677008 7003152
17:23:03 10276 8192000000 10730638480 11154821120 1779662960 17.847 97 23 44 0 1791539024 4897040 6979024
17:23:19 11544 8192000000 10741012448 11169361920 1833684784 18.289 100 28 56 3 1848080480 5773504 8622192
17:23:37 10936 8192000000 10748871776 11169685504 1833968448 18.292 100 22 44 0 1846865104 5461328 7435328
17:23:55 19248 8192000000 10752022784 11164467200 1800127184 18.015 98 25 50 3 1812518656 5297088 7094384
17:24:51 28963 8192000000 10745680112 11171483648 1835644880 18.305 100 29 59 0 1850076736 5933696 8498160
17:25:27 11367 8192000000 10760554016 11187568640 1848282208 18.408 100 24 48 2 1861538448 6398912 6857328
17:25:47 8872 8192000000 10770444864 11197861888 1855813088 18.469 100 23 46 2 1868520720 6394976 6312656
17:26:02 6159 8192000000 10770949248 11197095936 1858173632 18.488 100 26 52 1 1871848752 6462448 7212672
17:26:16 8838 8192000000 10768557792 11196739584 1856540960 18.475 100 15 30 0 1866279408 5739920 3998528
17:26:31 7624 8192000000 10766338992 11200815104 1860297120 18.506 100 25 50 1 1872954064 5412352 7244592
17:26:46 9778 8192000000 10783593360 11207208960 1865491728 18.548 100 27 54 2 1879211584 5510336 8209520
17:27:05 3596 8192000000 10802283088 11217657856 1880675632 18.671 100 37 72 1 1896378688 4528880 11174176
17:27:19 20682 8192000000 10818441232 11235753984 1890192944 18.747 100 41 82 1 1907823232 6268512 11361776
17:27:49 34795 8192000000 10831597920 11247648768 1902726880 18.848 100 51 102 1 1924970800 7777040 14466880
17:28:36 15822 8192000000 10850777840 11262656512 1915240768 18.949 100 51 102 0 1942900352 13252480 14407104
17:28:59 38197 8192000000 10866932208 11285540864 1926255280 19.037 100 46 92 2 1954850656 15522752 13072624
17:29:45 8791 8192000000 10867727088 11289231360 1932476304 19.087 100 46 92 2 1962828704 17602240 12750160
17:30:24 17555 8192000000 10883573664 11307724800 1941124368 19.156 100 45 90 0 1974879024 21606848 12147808
17:30:50 39646 8192000000 10880573008 11314081792 1950037424 19.227 100 59 118 2 1986223312 18627776 17558112
17:32:29 67004 8192000000 10882352768 11327713280 1947182240 19.204 100 26 52 0 1975967808 20725904 8059664
17:34:08 14321 8192000000 10905769280 11337633792 1965455440 19.349 100 47 93 2 1999332576 19659488 14217648
17:34:36 6566 8192000000 10920211920 11346354176 1970808992 19.392 100 54 107 1 2006462144 20250016 15403136
17:34:51 11678 8192000000 10918499328 11347996672 1971382528 19.396 100 57 114 0 2012068576 23617488 17068560
17:35:09 10549 8192000000 10926477104 11353989120 1975406192 19.428 100 49 97 1 2014645264 24531328 14707744
17:35:26 13581 8192000000 10930438208 11362971648 1980697504 19.470 100 51 102 2 2022390368 26060400 15632464
17:35:46 3439 8192000000 10945814096 11376136192 1987942432 19.528 100 61 122 0 2034268864 27932160 18394272
17:35:57 6126 8192000000 10948817216 11376160768 1992075776 19.560 100 62 124 0 2039989216 29353840 18559600
17:36:16 5154 8192000000 10940752512 11378462720 1990550720 19.548 100 53 106 0 2032616560 25830096 16235744
17:36:30 4516 8192000000 10949172400 11380047872 1992985376 19.567 100 54 108 4 2036436560 27209072 16242112
17:36:43 4153 8192000000 10958314672 11384221696 1996791536 19.597 100 57 114 1 2044501328 30319776 17390016
17:36:54 2354 8192000000 10976539456 11395850240 2001677360 19.636 100 73 145 2 2055893056 32064256 22151440
17:37:06 9370 8192000000 10966032192 11395260416 2005516544 19.666 100 73 145 0 2060904832 33450912 21937376
17:37:25 2212 8192000000 10988725712 11402031104 2012386032 19.720 100 95 188 4 2073486864 34043344 27057488
17:37:34 3470 8192000000 10959767008 11377098752 1991733152 19.557 99 82 163 0 2048368848 31846240 24789456
17:37:45 5732 8192000000 10977565152 11396919296 2004877664 19.661 100 70 140 2 2059029760 33798624 20353472
17:37:59 2733 8192000000 10987598480 11399782400 2011908672 19.717 100 83 166 1 2069879344 33365440 24605232
17:38:08 4686 8192000000 10989908000 11402567680 2008767408 19.692 100 81 162 3 2067253152 34728704 23757040
17:38:19 3960 8192000000 10986319280 11405737984 2012127456 19.718 100 79 157 0 2070416304 35326816 22962032
17:38:32 2881 8192000000 10966504256 11381977088 1994300048 19.578 99 82 159 0 2052978512 34200240 24478224
17:38:42 1167 8192000000 10976363968 11394191360 2002189248 19.640 100 86 168 0 2062181648 34655136 25337264
17:38:51 3968 8192000000 10976987040 11401994240 2006173552 19.671 100 74 148 1 2063670416 35304048 22192816
17:39:04 4382 8192000000 10985092096 11406114816 2006974976 19.678 100 84 168 1 2069301984 36385632 25941376
17:39:17 12859 8192000000 10961981664 11397054464 2000163728 19.624 100 57 114 2 2054335600 36167920 18003952
17:39:41 2355 8192000000 10975839312 11400871936 1989200624 19.537 99 62 125 0 2046567712 38419904 18947184
17:39:55 5019 8192000000 10977215472 11397586944 1985850704 19.511 99 69 135 0 2044412768 38628864 19933200
17:40:07 3730 8192000000 10964950304 11383631872 1979209840 19.458 99 73 146 2 2045666624 44368416 22088368
17:40:19 2062 8192000000 10974879952 11386474496 1986861808 19.519 100 86 169 0 2053885344 41676144 25347392
17:40:28 1952 8192000000 10978103968 11389976576 1991561248 19.556 100 91 178 2 2061015024 42858272 26595504
17:40:37 2965 8192000000 10977757248 11394170880 1993486208 19.571 100 87 174 1 2065062960 44762016 26814736
17:40:47 1052 8192000000 10986127232 11396165632 1983292448 19.491 99 92 184 2 2055899648 44362528 28244672
17:40:55 6121 8192000000 10980421600 11405672448 1998779024 19.613 100 75 150 1 2068446368 46218624 23448720
17:41:08 7870 8192000000 10980865296 11398422528 1989872272 19.543 100 67 132 1 2056468336 45999648 20596416
17:41:27 1967 8192000000 10999332896 11413176320 2007918688 19.685 100 94 186 3 2084332704 48010064 28403952
17:41:36 4103 8192000000 10993625792 11409588224 2002586400 19.643 100 89 178 1 2079235856 48758816 27890640
17:41:48 1516 8192000000 10978718592 11392860160 1987207488 19.522 100 82 164 1 2060847232 48525776 25113968
17:41:57 3990 8192000000 10967055344 11384905728 1968865072 19.376 99 71 142 1 2039665808 48409776 22390960
17:42:09 2679 8192000000 10976938704 11398885376 1989101600 19.537 100 73 146 1 2061865200 50103552 22660048
17:42:20 3426 8192000000 10961895568 11376750592 1948106560 19.211 98 81 162 0 2024193424 51079584 25007280
17:42:33 1620 8192000000 10966705360 11379843072 1973166000 19.411 100 92 183 4 2052751648 52085648 27500000
17:42:42 3956 8192000000 10947920288 11358285824 1956212384 19.276 99 81 161 0 2026643952 45814240 24617328
17:42:54 3770 8192000000 10965584656 11379261440 1963794304 19.336 99 87 174 2 2042777104 52199440 26783360
17:43:11 2399 8192000000 10975958512 11387449344 1962125744 19.323 99 83 164 2 2036829488 49633280 25070464
17:43:20 2904 8192000000 10967570128 11376160768 1977970144 19.449 100 82 161 0 2046327120 43028928 25328048
17:43:32 3027 8192000000 10978957904 11387498496 1985244016 19.506 100 90 181 2 2053122576 39400624 28477936
17:43:42 4661 8192000000 10932920832 11364925440 1939575136 19.143 98 54 106 0 1996191008 39663152 16952720
17:43:53 6784 8192000000 10915902336 11343814656 1946082816 19.195 99 38 76 5 1998415712 39466288 12866608
17:44:13 1160 8192000000 10960528704 11374354432 1973818192 19.416 100 77 153 1 2037591024 39982576 23790256
17:44:23 1893 8192000000 10974725328 11382120448 1979698800 19.462 100 86 172 1 2045379216 38939888 26740528
17:44:33 3252 8192000000 10950508096 11369381888 1980034992 19.465 100 81 162 1 2039273216 34353344 24884880
17:44:44 2748 8192000000 10960985040 11378716672 1984335824 19.499 100 68 134 2 2040391952 35721568 20334560
17:44:56 3593 8192000000 10966034384 11380072448 1988842528 19.535 100 72 143 1 2046992080 36052464 22097088
17:45:07 3059 8192000000 10986016160 11398590464 1997706944 19.605 100 78 155 2 2058241328 37620608 22913776
17:45:19 1431 8192000000 10973390848 11388268544 1980039440 19.465 99 83 167 1 2043685184 38602144 25043600
17:45:27 4055 8192000000 10972592608 11382636544 1983421888 19.492 100 86 172 1 2049933536 39260816 27250832
17:45:38 2954 8192000000 10946425232 11368812544 1963538448 19.334 99 67 135 2 2027056672 42243456 21274768
17:45:57 2694 8192000000 10940519008 11359621120 1946519568 19.199 99 71 142 3 2008748112 40711008 21517536
17:46:10 2038 8192000000 10943304992 11350290432 1956892000 19.281 99 84 166 3 2020339648 38963312 24484336
17:46:25 5077 8192000000 10946990896 11375501312 1971877472 19.400 100 60 120 0 2034028832 42608832 19542528
17:46:37 3723 8192000000 10957544432 11382329344 1975836800 19.432 100 64 128 0 2039472864 42747088 20888976
17:46:48 12976 8192000000 10936940128 11382951936 1956241920 19.276 99 40 80 1 2013408880 43486192 13680768
17:47:21 9993 8192000000 10936129520 11374329856 1972629440 19.406 100 32 64 3 2019011600 34972320 11409840
17:47:42 11666 8192000000 10921075248 11362996224 1941326640 19.157 98 31 62 1 1989022256 37266960 10428656
17:48:16 10779 8192000000 10925390544 11371917312 1966768672 19.360 100 33 66 0 2014426528 37032272 10625584
17:48:52 21530 8192000000 10934528000 11382251520 1971302944 19.396 100 31 62 2 2018524720 36481664 10740112
17:49:32 29075 8192000000 10907671072 11358744576 1928171296 19.052 98 30 59 1 1975086624 37011856 9903472
17:50:46 31385 8192000000 10908261632 11369680896 1907705056 18.888 98 23 47 1 1968309664 51159680 9444928
17:51:50 49429 8192000000 10867215744 11335897088 1882799296 18.688 97 18 36 2 1916011504 27173632 6038576
17:52:46 42998 8192000000 10884485312 11329523712 1924922320 19.026 99 31 63 3 1949948192 15380416 9645456
17:53:38 9700 8192000000 10874307696 11324989440 1920321088 18.989 99 30 60 1 1938215552 9137072 8757392
17:53:55 2883 8192000000 10879048880 11311583232 1930518896 19.071 100 60 120 1 1959186800 9995584 18672320
17:54:07 12483 8192000000 10857659360 11311894528 1915603248 18.952 99 29 58 1 1939267744 14708704 8955792
17:54:31 56159 8192000000 10852185872 11311906816 1909242528 18.901 99 29 58 2 1929930880 12533856 8154496
17:55:57 57489 8192000000 10858764912 11303010304 1859976416 18.503 96 25 50 3 1885178384 17525184 7676784
17:57:31 114880 8192000000 10876640640 11342401536 1909495248 18.903 99 14 28 0 1927548848 14110592 3943008
17:59:34 41548 8192000000 10879344208 11344961536 1931503088 19.079 99 11 22 0 1947329776 13101952 2724736
18:00:56 88004 8192000000 10869951904 11326341120 1906215968 18.876 98 21 41 2 1924976016 11601488 7158560
18:02:30 68678 8192000000 10885798320 11351367680 1936381616 19.118 99 30 62 1 1960138608 15442848 8314144
18:03:46 68397 8192000000 10883579296 11351719936 1937316560 19.125 99 10 20 0 1956607488 16440224 2850704
18:05:00 2489 8192000000 10897908496 11348193280 1955423616 19.270 100 37 73 0 1983710640 17358432 10928592
18:05:09 20247 8192000000 10891608464 11349155840 1967800768 19.368 100 38 76 0 1990982336 12297728 10883840
18:05:36 39717 8192000000 10899977104 11363053568 1970931696 19.393 100 31 62 3 1994184624 14416816 8836112
18:06:22 47086 8192000000 10906394368 11360337920 1955580992 19.271 99 31 63 1 1983797072 18649824 9566256
18:07:15 38063 8192000000 10928064464 11378769920 1975465088 19.429 100 44 86 0 2006969280 20247744 11256448
18:08:04 50286 8192000000 10909559664 11378597888 1980739216 19.471 100 29 58 1 2003685024 15105744 7840064
18:09:58 54906 8192000000 10906750448 11389186048 1966289280 19.356 99 13 26 1 1991650736 21763120 3598336
18:11:47 56682 8192000000 10933950608 11399704576 1987062432 19.521 100 23 46 1 2016202112 22156800 6982880
18:12:51 79097 8192000000 10901502800 11401547776 1941994880 19.163 98 12 24 1 1977747440 32005456 3747104
18:14:20 66499 8192000000 10898829456 11377844224 1970790944 19.392 100 8 16 1 1986161840 13019760 2351136
18:15:36 41450 8192000000 10911937296 11370500096 1963776960 19.336 99 24 48 0 1978898112 8749488 6371664
18:16:27 28716 8192000000 10916007776 11371507712 1966878208 19.361 99 34 68 1 1984376912 7912432 9586272
18:17:06 50559 8192000000 10879096592 11342479360 1912187728 18.924 96 36 72 2 1938132064 15591744 10352592
18:18:09 61680 8192000000 10883702880 11358904320 1942572672 19.167 99 11 22 1 1964290912 18377616 3340624
18:19:18 146782 8192000000 10912931200 11378470912 1929020144 19.059 98 9 18 0 1952858800 21154608 2684048
18:22:03 119350 8192000000 10914083408 11370688512 1900682160 18.832 96 25 50 1 1917096048 9433216 6980672
18:24:13 38783 8192000000 10880620656 11322048512 1905647984 18.872 97 29 58 1 1928160528 14419312 8093232
18:25:00 139019 8192000000 10872387024 11348111360 1838841472 18.331 94 9 18 0 1859699520 18020240 2837808
18:27:25 84267 8192000000 10880723328 11325075456 1896565744 18.799 97 35 67 2 1914660736 8998928 9096064
18:29:15 68208 8192000000 10889971456 11350695936 1939128480 19.140 99 35 70 1 1964118048 15289744 9699824
18:30:30 25862 8192000000 10880516272 11346120704 1933835104 19.098 99 13 23 2 1950425920 13509776 3081040
18:31:06 14434 8192000000 10882137712 11351814144 1956300224 19.277 100 10 20 0 1971276224 12663728 2312272
18:31:26 17883 8192000000 10873842624 11353239552 1955240624 19.268 100 15 30 1 1972685328 13620560 3824144
18:32:29 69547 8192000000 10886786032 11365425152 1970633408 19.390 100 16 32 0 1985280848 9969264 4678176
18:34:28 64047 8192000000 10888989744 11355992064 1961825712 19.321 100 18 36 0 1974949456 8186112 4937632
18:35:41 94028 8192000000 10863711088 11329900544 1858882736 18.494 94 15 31 0 1874184080 11286384 4014960
18:37:30 66500 8192000000 10843016384 11307589632 1857673600 18.484 96 19 37 1 1881262480 17873632 5715248
18:38:58 82759 8192000000 10833127808 11315032064 1891826224 18.760 98 14 28 3 1906841936 10576128 4439584
18:40:27 51601 8192000000 10872157424 11330555904 1919450144 18.982 99 20 40 0 1933140640 8043472 5647024
18:41:25 23115 8192000000 10881756032 11337973760 1947721792 19.208 100 30 58 2 1965945392 9655808 8567792
18:41:59 30129 8192000000 10889138128 11348983808 1960171760 19.307 100 25 49 1 1977851664 10614976 7064928
18:42:42 46381 8192000000 10853888944 11307888640 1860062384 18.504 95 17 34 1 1876007424 11067936 4877104
18:43:37 50616 8192000000 10872468464 11331862528 1911253744 18.917 98 37 74 2 1934625200 12508576 10862880
18:44:36 103483 8192000000 10861042352 11332583424 1889252128 18.740 97 29 57 1 1910274400 13174176 7848096
18:46:25 57622 8192000000 10862984704 11328155648 1890917584 18.753 97 19 38 0 1910767072 14729664 5119824
18:47:29 23575 8192000000 10860488496 11324477440 1919424208 18.982 99 17 34 0 1938776336 13922192 5429936
18:48:03 124680 8192000000 10868159168 11338481664 1807125120 18.072 93 22 44 2 1824798128 12088112 5584896
18:50:14 127592 8192000000 10845211952 11303464960 1726590880 17.407 89 18 36 0 1749601760 18412208 4598672
18:52:28 101326 8192000000 10858739472 11325186048 1923161552 19.012 100 28 56 2 1948045888 17022336 7862000
18:54:15 93424 8192000000 10849451920 11322658816 1892033264 18.762 98 9 18 0 1904351584 10261584 2056736
18:55:55 27966 8192000000 10855154736 11320012800 1930482880 19.071 100 10 20 0 1944290448 10969520 2838048
18:56:31 45333 8192000000 10868717760 11332739072 1946552816 19.199 100 38 76 1 1967923776 9900880 11470080
18:57:26 79768 8192000000 10870559152 11353681920 1957662976 19.287 100 7 14 0 1970277152 10804096 1810080
18:58:52 16831 8192000000 10871838288 11355783168 1959326416 19.301 100 3 6 0 1970374784 10563056 485312
18:59:18 39452 8192000000 10859475408 11333439488 1906887088 18.882 97 10 20 0 1920276976 10081472 3308416
19:00:04 40525 8192000000 10877463680 11352219648 1953384368 19.253 100 11 22 0 1962113680 6174128 2555184
19:01:01 73846 8192000000 10915398368 11382067200 1974516848 19.421 100 15 30 1 1987541520 9318208 3706464
19:02:21 95491 8192000000 10901656720 11372040192 1940411344 19.150 98 8 16 0 1954334080 11395920 2526816
19:04:03 64651 8192000000 10900935632 11386269696 1942934208 19.170 98 18 36 1 1962766256 13908848 5923200
19:05:14 98098 8192000000 10914103568 11382943744 1948458848 19.214 98 16 32 0 1964101312 10864048 4778416
19:06:58 106342 8192000000 10889119120 11363074048 1861099280 18.512 94 7 14 0 1874388160 11667808 1621072
19:08:51 123750 8192000000 10908448608 11376619520 1957135216 19.283 99 10 20 0 1972626752 13223472 2268064
19:11:05 54346 8192000000 10897861824 11361239040 1943868048 19.178 98 22 43 1 1958214272 8600608 5745616
19:12:13 26279 8192000000 10910949120 11362902016 1947806928 19.209 98 35 71 0 1972119104 14866224 9445952
19:13:35 137926 8192000000 10911938544 11378462720 1899176080 18.820 96 7 14 0 1922940736 22451296 1313360
19:16:57 89450 8192000000 10901902048 11369586688 1941392864 19.158 98 18 36 2 1957899616 10916976 5589776
19:18:33 51819 8192000000 10876422912 11348836352 1946745424 19.201 99 11 22 1 1960865600 10862336 3257840
19:20:17 89376 8192000000 10861679808 11335802880 1867615360 18.565 95 10 20 0 1879251024 8341968 3293696
19:21:55 49335 8192000000 10887944720 11349643264 1934496496 19.103 99 9 18 1 1942553152 5940656 2116000
19:22:52 86602 8192000000 10889859472 11364089856 1947715184 19.208 99 19 38 3 1967068512 13719392 5633936
19:24:28 63478 8192000000 10890614672 11358187520 1923656592 19.016 98 15 30 0 1943173712 14467968 5049152
19:26:16 48724 8192000000 10408224960 10833514496 1479238688 15.295 75 16 32 3 1493205856 8812560 5154608

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 21-11-2020 19:28:48 to 21-11-2020 19:29:19.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 149 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 21-11-2020 19:29:19 to 21-11-2020 19:29:21.

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          232041
MON$OLDEST_ACTIVE               233263
MON$OLDEST_SNAPSHOT             233263
MON$NEXT_TRANSACTION            233263
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                       2005184
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33393 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33393 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33393 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33393 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

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

Database validation

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

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

--- start of diff output ---
:15: 
:16: mscs-test-161.budzdorov.ru    Sat Nov 21 19:27:07 2020
:17:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:18: 
:19: 
:20: mscs-test-161.budzdorov.ru    Sat Nov 21 19:27:12 2020
:21:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:22: 
:23: 
:24: mscs-test-161.budzdorov.ru    Sat Nov 21 19:27:15 2020
:25:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:26: 
:27: 
:28: mscs-test-161.budzdorov.ru    Sat Nov 21 19:27:16 2020
:29:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:30: 
--- end of diff output ---

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

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