Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 23.01.2021 16: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 17220508 kB
MemAvailable 31324248 kB
Buffers 0 kB
Cached 14498208 kB
SwapCached 4868 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-23 16:27:12
DTS_END                         2021-01-23 16:27:12.4710
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/48624
TRN_ID                          236925
ATT_ID                          685
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: 9367.42 25122 1124090
customer order: creation 163.84 383 19661
customer order: refuse 14.58 351 1749
order to supplier: creation 43.72 1310 5246
order to supplier: removal 3.23 121378 388
invoice (draft): creation 45.61 3503 5473
invoice (draft): removal 53.88 842 6465
invoice accept: apply 41.49 18070 4979
invoice accept: cancel 48.25 821 5790
customer reserve: creation 3925.99 174 471119
customer reserve: removal 4730.18 66 567622
realization accept: apply 80.69 174 9683
realization accept: cancel 89.93 109 10791
payment from customer: creation 57.88 114 6946
payment from customer: removal 5.83 69 700
payment to supplier: creation 47.40 152 5688
payment to supplier: removal 3.53 77 423
service: total inventory turnovers 4.10 1094 492
service: total monetary turnovers 6.39 29 767
service: aggregate perf. data 0.87 16474 104
service: refresh index statistics 0.03 337249 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 23-01-2021 16:29:05 to 23-01-2021 16:29:07.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3192
TEST_TIME 2 3788
TEST_TIME 3 4644
TEST_TIME 4 4771
TEST_TIME 5 4750
TEST_TIME 6 5136
TEST_TIME 7 4755
TEST_TIME 8 5005
TEST_TIME 9 5040
TEST_TIME 10 5052
TEST_TIME 11 5073
TEST_TIME 12 5405
TEST_TIME 13 5398
TEST_TIME 14 5686
TEST_TIME 15 5922
TEST_TIME 16 6207
TEST_TIME 17 6299
TEST_TIME 18 6672
TEST_TIME 19 7125
TEST_TIME 20 7733
TEST_TIME 21 8379
TEST_TIME 22 8687
TEST_TIME 23 9221
TEST_TIME 24 9405
TEST_TIME 25 9582
TEST_TIME 26 9429
TEST_TIME 27 10328
TEST_TIME 28 11271
TEST_TIME 29 11254
TEST_TIME 30 11254
TEST_TIME 31 11054
TEST_TIME 32 10931
TEST_TIME 33 10921
TEST_TIME 34 10810
TEST_TIME 35 10536
TEST_TIME 36 10337
TEST_TIME 37 10467
TEST_TIME 38 10307
TEST_TIME 39 10230
TEST_TIME 40 10126
TEST_TIME 41 10097
TEST_TIME 42 10194
TEST_TIME 43 10208
TEST_TIME 44 10065
TEST_TIME 45 10017
TEST_TIME 46 9971
TEST_TIME 47 9956
TEST_TIME 48 9771
TEST_TIME 49 9686
TEST_TIME 50 9609
TEST_TIME 51 9627
TEST_TIME 52 9518
TEST_TIME 53 9594
TEST_TIME 54 9561
TEST_TIME 55 9628
TEST_TIME 56 9613
TEST_TIME 57 9634
TEST_TIME 58 9700
TEST_TIME 59 9783
TEST_TIME 60 9719
TEST_TIME 61 9805
TEST_TIME 62 9871
TEST_TIME 63 9899
TEST_TIME 64 9929
TEST_TIME 65 9930
TEST_TIME 66 9957
TEST_TIME 67 9898
TEST_TIME 68 9796
TEST_TIME 69 9808
TEST_TIME 70 9732
TEST_TIME 71 9744
TEST_TIME 72 9676
TEST_TIME 73 9611
TEST_TIME 74 9607
TEST_TIME 75 9565
TEST_TIME 76 9556
TEST_TIME 77 9535
TEST_TIME 78 9570
TEST_TIME 79 9626
TEST_TIME 80 9597
TEST_TIME 81 9713
TEST_TIME 82 9712
TEST_TIME 83 9706
TEST_TIME 84 9706
TEST_TIME 85 9664
TEST_TIME 86 9717
TEST_TIME 87 9714
TEST_TIME 88 9811
TEST_TIME 89 9775
TEST_TIME 90 9692
TEST_TIME 91 9681
TEST_TIME 92 9630
TEST_TIME 93 9633
TEST_TIME 94 9597
TEST_TIME 95 9546
TEST_TIME 96 9528
TEST_TIME 97 9555
TEST_TIME 98 9560
TEST_TIME 99 9586
TEST_TIME 100 9630
TEST_TIME 101 9620
TEST_TIME 102 9594
TEST_TIME 103 9662
TEST_TIME 104 9662
TEST_TIME 105 9664
TEST_TIME 106 9671
TEST_TIME 107 9686
TEST_TIME 108 9678
TEST_TIME 109 9704
TEST_TIME 110 9634
TEST_TIME 111 9637
TEST_TIME 112 9592
TEST_TIME 113 9590
TEST_TIME 114 9534
TEST_TIME 115 9537
TEST_TIME 116 9518
TEST_TIME 117 9490
TEST_TIME 118 9438
TEST_TIME 119 9434
TEST_TIME 120 9373

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 23-01-2021 16:29:09 to 23-01-2021 16:29:12.

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 1559546 1559546 0 0.00 0 27424 6 0 0
doc_list_biud 1559545 1559545 0 0.00 0 32859 30 0 0
sp_add_invoice_to_stock 5081 4979 102 2.00 37 169207 18071 0 102
sp_cancel_adding_invoice 5790 5790 0 0.00 4 115683 821 0 0
sp_cancel_client_order 1749 1749 0 0.00 4 14539 352 0 0
sp_cancel_customer_reserve 567622 567622 0 0.00 1 24810 66 0 0
sp_cancel_pay_from_customer 700 700 0 0.00 2 4891 69 0 0
sp_cancel_pay_to_supplier 423 423 0 0.00 3 6182 78 0 0
sp_cancel_supplier_invoice 6475 6465 10 0.15 1 20088 842 0 10
sp_cancel_supplier_order 388 388 0 0.00 6 1081733 121378 0 0
sp_cancel_write_off 10791 10791 0 0.00 1 12670 110 0 0
sp_client_order 19661 19661 0 0.00 3 53343 383 0 0
sp_customer_reserve 471119 471119 0 0.00 0 56321 175 0 0
sp_fill_shopping_cart 30373 30373 0 0.00 1 13460 41 0 0
sp_fill_shopping_cart_clo_res 471113 471113 0 0.00 0 13479 14 0 0
sp_get_clo_for_invoice 4971 4971 0 0.00 0 26820 312 0 0
sp_kill_cost_storno 17704 17704 0 0.00 0 7075 57 0 0
sp_kill_qstorno_ret_qs2qd 1152888 1152888 0 0.00 0 24786 36 0 0
sp_kill_qty_storno 607459 607459 0 0.00 0 32859 76 0 0
sp_lock_selected_doc 20416 20416 0 0.00 0 7474 7 0 0
sp_make_cost_storno 27288 27288 0 0.00 0 27407 52 0 0
sp_multiply_rows_for_pdistr 27288 27288 0 0.00 0 7084 29 0 0
sp_multiply_rows_for_qdistr 19661 19661 0 0.00 0 53335 173 0 0
sp_pay_from_customer 6946 6946 0 0.00 4 13241 115 0 0
sp_pay_to_supplier 5688 5688 0 0.00 4 14935 152 0 0
sp_payment_common 12634 12634 0 0.00 1 13091 28 0 0
sp_qd_handle_on_cancel_clo 1749 1749 0 0.00 0 13534 302 0 0
sp_qd_handle_on_invoice_upd_sts 10761 10761 0 0.00 0 32857 327 0 0
sp_qd_handle_on_reserve_upd_sts 9683 9683 0 0.00 0 15924 54 0 0
sp_reserve_write_off 9683 9683 0 0.00 6 15958 175 0 0
sp_supplier_invoice 5473 5473 0 0.00 7 95457 3504 0 0
sp_supplier_order 5246 5246 0 0.00 5 76243 1311 0 0
srv_aggregate_perf_data 105 104 1 0.95 2777 171497 16474 0 1
srv_fill_mon_cache_memory 160 160 0 0.00 1434 112182 33125 0 0
srv_find_qd_qs_mism 1076628 1076628 0 0.00 0 15997 5 0 0
srv_make_invnt_saldo 492 492 0 0.00 34 31416 1094 0 0
srv_make_money_saldo 767 767 0 0.00 0 3900 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 213109 449075 337249 0 0
t$perf-abend:sp_add_invoice_to_stock 102 102 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 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 4979 4979 0 0.00 0 28554 158 0 0
t$perf-norm:sp_cancel_adding_invoice 418 418 0 0.00 0 3470 88 0 0
t$perf-norm:sp_cancel_client_order 1749 1749 0 0.00 0 3527 19 0 0
t$perf-norm:sp_cancel_customer_reserve 678 678 0 0.00 0 6716 25 0 0
t$perf-norm:sp_cancel_pay_from_customer 700 700 0 0.00 0 1728 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 423 423 0 0.00 0 573 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 403 403 0 0.00 0 413 13 0 0
t$perf-norm:sp_cancel_supplier_order 388 388 0 0.00 0 20994 1729 0 0
t$perf-norm:sp_cancel_write_off 1003 1003 0 0.00 0 6339 16 0 0
t$perf-norm:sp_client_order 19661 19661 0 0.00 0 8663 16 0 0
t$perf-norm:sp_customer_reserve 982 982 0 0.00 0 1055 4 0 0
t$perf-norm:sp_pay_from_customer 6946 6946 0 0.00 0 8086 12 0 0
t$perf-norm:sp_pay_to_supplier 5688 5688 0 0.00 0 3944 11 0 0
t$perf-norm:sp_reserve_write_off 9683 9683 0 0.00 0 5074 11 0 0
t$perf-norm:sp_supplier_invoice 5473 5473 0 0.00 0 4827 14 0 0
t$perf-norm:sp_supplier_order 5246 5246 0 0.00 0 3044 14 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 297 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 58 1 0 0
t$perf-norm:srv_make_invnt_saldo 492 492 0 0.00 0 767 21 0 0
t$perf-norm:srv_make_money_saldo 767 767 0 0.00 0 1534 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 10146 9942 204 2.01 0 11773 22 0 204
v_all_customers 36656 36656 0 0.00 0 13 1 0 0
v_all_suppliers 29964 29964 0 0.00 0 294 1 0 0
v_all_wares 39316 39316 0 0.00 0 15 1 0 0
v_cancel_adding_invoice 836 836 0 0.00 0 1451 8 0 0
v_cancel_client_order 3498 3498 0 0.00 0 14485 13 0 0
v_cancel_customer_prepayment 1400 1400 0 0.00 0 4873 8 0 0
v_cancel_customer_reserve 1356 1356 0 0.00 0 11640 15 0 0
v_cancel_payment_to_supplier 846 846 0 0.00 0 688 3 0 0
v_cancel_supplier_invoice 826 806 20 2.42 0 11749 30 0 20
v_cancel_supplier_order 776 776 0 0.00 0 4298 18 0 0
v_cancel_write_off 2006 2006 0 0.00 0 12562 26 0 0
v_max_id_clo_ord 5243 5243 0 0.00 0 148 1 0 0
v_max_id_clo_res 982 982 0 0.00 0 3097 11 0 0
v_max_id_ord_sup 5472 5472 0 0.00 0 5813 6 0 0
v_max_non_paid_invoice 1421 1421 0 0.00 0 181 2 0 0
v_max_non_paid_realizn 3427 3427 0 0.00 0 8820 7 0 0
v_min_id_clo_ord 5243 5243 0 0.00 0 2572 5 0 0
v_min_id_clo_res 982 982 0 0.00 0 5059 15 0 0
v_min_id_ord_sup 5472 5472 0 0.00 0 9236 13 0 0
v_min_non_paid_invoice 5688 5688 0 0.00 0 13081 23 0 0
v_min_non_paid_realizn 6946 6946 0 0.00 0 8993 16 0 0
v_our_firm 9698 9698 0 0.00 0 14 1 0 0
v_reserve_write_off 19366 19366 0 0.00 0 11782 10 0 0
x_lock_depdocs_on_canc_invoice 11852 11852 0 0.00 0 27555 112 0 0
x_lock_depdocs_on_canc_sup_ord 388 388 0 0.00 0 24793 460 0 0
x_make_qstorno_1000_1200 5246 5246 0 0.00 2 73780 1241 0 0
x_make_qstorno_1200_2000 5473 5473 0 0.00 3 95368 3347 0 0
x_make_qstorno_2100_3300 471119 471119 0 0.00 0 56319 158 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 23-01-2021 16:29:13 to 23-01-2021 16:29:17.

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
13:57:16 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:22 19597 8192000000 10254723664 10565414912 933061872 10.225 73 61 124 0 956692624 2752432 20878320
13:57:50 30374 8192000000 10346762320 10661806080 1380737488 14.423 100 81 162 0 1412090352 4911552 26441312
13:58:29 18527 8192000000 10380671440 10698928128 1430444144 14.865 100 87 174 0 1465155984 6221664 28490176
13:59:04 2859 8192000000 10394687744 10718179328 1455236336 15.084 100 88 176 0 1491161888 7267600 28657952
13:59:20 25122 8192000000 10418230944 10744225792 1470932736 15.222 100 90 179 0 1508321328 8152208 29236384
13:59:56 11645 8192000000 10430244592 10757619712 1481116032 15.311 100 91 182 1 1519467792 8885488 29466272
14:00:19 17526 8192000000 10437232720 10770010112 1490971760 15.397 100 87 174 0 1528233776 9376528 27885488
14:00:45 18433 8192000000 10461266720 10800386048 1510551712 15.568 100 82 164 0 1546169792 9606352 26011728
14:01:19 17524 8192000000 10498449584 10842505216 1551520704 15.923 100 81 162 1 1586359248 9774048 25064496
14:01:45 21053 8192000000 10523844096 10875305984 1585879120 16.219 100 86 172 0 1623775376 11138144 26758112
14:02:13 12277 8192000000 10547524560 10900713472 1603985744 16.373 100 81 162 1 1640005120 11376160 24643216
14:02:32 14498 8192000000 10565827184 10921242624 1621404416 16.522 100 82 164 1 1657204768 11293808 24506544
14:02:56 13999 8192000000 10593431760 10948923392 1642944640 16.705 100 85 170 1 1680202000 12468096 24789264
14:03:17 12326 8192000000 10602530640 10964647936 1656943648 16.823 100 90 180 1 1696737680 13245408 26548624
14:03:41 8544 8192000000 10612078128 10977640448 1673845360 16.966 100 80 161 0 1709560224 11489360 24225504
14:03:58 9811 8192000000 10624737696 10994262016 1687784848 17.083 100 79 158 2 1723585728 12287184 23513696
14:04:14 8855 8192000000 10644481456 11015651328 1708493040 17.256 100 79 157 2 1744049872 12998288 22558544
14:04:31 9329 8192000000 10665082928 11034558464 1721041360 17.361 100 87 174 1 1759339568 13841264 24456944
14:04:52 4343 8192000000 10674337296 11051307008 1744031872 17.552 100 72 143 1 1775999904 12045712 19922320
14:05:03 6883 8192000000 10701776320 11077558272 1762564928 17.706 100 77 154 0 1796900176 11759552 22575696
14:05:18 3800 8192000000 10714370720 11092594688 1773667888 17.797 100 80 162 0 1808103792 12798896 21637008
14:05:29 3831 8192000000 10723701120 11102572544 1784989968 17.891 100 82 164 0 1821393088 13144768 23258352
14:05:40 4043 8192000000 10732207136 11115782144 1794852272 17.972 100 84 166 1 1831211312 12912560 23446480
14:05:51 2905 8192000000 10736248304 11116232704 1803092640 18.039 100 88 175 0 1840232528 12479520 24660368
14:06:01 4144 8192000000 10741137136 11126566912 1813134896 18.122 100 85 167 0 1849597264 12202256 24260112
14:06:12 3169 8192000000 10752944560 11142246400 1814381600 18.132 100 82 162 3 1849603520 12842672 22379248
14:06:22 2279 8192000000 10768032784 11152441344 1824866064 18.217 100 91 181 2 1863581680 13028176 25687440
14:06:30 3913 8192000000 10762810064 11152867328 1825909072 18.226 100 70 138 1 1856133440 11249856 18974512
14:06:41 3227 8192000000 10777373696 11166527488 1830443264 18.263 100 84 166 0 1864627792 10951360 23233168
14:06:51 2168 8192000000 10784887440 11167756288 1841818240 18.356 100 84 168 3 1878063680 12630304 23615136
14:07:00 3092 8192000000 10790496336 11178647552 1848318016 18.408 100 95 190 1 1888340896 13871824 26151056
14:07:09 2828 8192000000 10791251584 11177517056 1846501168 18.394 100 91 182 0 1885207632 13465920 25240544
14:07:19 1442 8192000000 10798551232 11185938432 1853587056 18.451 100 93 187 1 1893571472 13976736 26007680
14:07:27 2048 8192000000 10806780656 11190845440 1860583584 18.508 100 90 179 0 1899899376 14644032 24671760
14:07:36 1906 8192000000 10801478624 11192193024 1858575984 18.492 100 88 174 0 1896524608 13169104 24779520
14:07:44 2067 8192000000 10802107136 11189714944 1858870240 18.494 100 84 165 1 1893714656 12061712 22782704
14:07:53 2305 8192000000 10805916176 11200413696 1867355952 18.563 100 84 168 1 1903837104 12762240 23718912
14:08:01 2334 8192000000 10809024560 11198488576 1870281552 18.587 100 91 181 1 1908368864 12759856 25327456
14:08:10 1734 8192000000 10824062544 11212095488 1875874816 18.632 100 95 190 0 1915798480 12744416 27179248
14:08:18 2103 8192000000 10824889488 11213930496 1877289408 18.643 100 90 180 1 1915925584 13331456 25304720
14:08:27 1497 8192000000 10828781264 11218296832 1881392576 18.676 100 96 193 0 1922585472 13732096 27460800
14:08:35 1812 8192000000 10829489024 11221446656 1884434064 18.701 100 95 190 2 1926496960 14826848 27236048
14:08:43 2316 8192000000 10842599840 11231440896 1888416352 18.733 100 90 180 1 1926505120 12104448 25984320
14:08:51 45947 8192000000 10820932080 11224915968 1886066704 18.714 100 64 128 0 1913387728 8643888 18677136
14:09:44 3157 8192000000 10820787968 11233873920 1890305184 18.748 100 62 124 1 1918510256 10998992 17206080
14:09:53 5649 8192000000 10798180352 11228086272 1884114864 18.698 100 30 60 1 1900866992 8660896 8091232
14:10:06 9710 8192000000 10817118576 11235590144 1892233280 18.764 100 42 83 0 1915144656 11654320 11257056
14:10:22 4650 8192000000 10808337616 11233312768 1888594768 18.734 100 32 64 1 1909016544 11387376 9034400
14:10:35 6428 8192000000 10804587376 11228868608 1889591392 18.742 100 30 60 0 1904671136 6357360 8722384
14:10:47 15285 8192000000 10794202448 11229995008 1889269520 18.740 100 17 34 0 1900487728 6223424 4994784
14:11:09 9569 8192000000 10798019872 11235155968 1890340736 18.749 100 14 27 0 1899690176 5662256 3687184
14:11:30 8279 8192000000 10796774672 11232628736 1891889056 18.761 100 14 24 1 1900765456 5324224 3552176
14:11:45 9932 8192000000 10807114624 11237994496 1895918864 18.793 100 18 36 5 1907295408 5856768 5519776
14:12:06 11287 8192000000 10811663152 11246714880 1895842304 18.793 100 17 34 0 1911806256 11211552 4752400
14:12:23 61136 8192000000 10828434928 11256709120 1905973344 18.874 100 44 89 1 1926217872 5979280 14265248
14:13:31 13345 8192000000 10816352176 11254030336 1906594128 18.879 100 19 37 1 1917595568 5464800 5536640
14:13:53 8064 8192000000 10819861072 11257671680 1910192192 18.908 100 27 54 2 1928578192 10326368 8059632
14:14:10 6892 8192000000 10831342496 11263516672 1912828336 18.929 100 30 59 1 1927442192 6293632 8320224
14:14:23 9493 8192000000 10825032608 11260305408 1907625216 18.888 100 14 26 2 1916679424 5760096 3294112
14:14:42 4370 8192000000 10837567760 11265695744 1916656624 18.960 100 37 73 2 1933001056 6095728 10248704
14:14:53 4110 8192000000 10837873360 11262746624 1912850672 18.930 100 26 49 4 1926696784 6151648 7694464
14:15:04 9620 8192000000 10823903232 11266699264 1913705792 18.936 100 23 46 3 1927126912 6265280 7155840
14:15:22 8619 8192000000 10831232064 11270742016 1915507296 18.951 100 24 48 0 1929549824 7098784 6943744
14:15:36 13041 8192000000 10827879376 11264602112 1915228640 18.949 100 23 46 0 1928639264 5641232 7769392
14:15:57 10957 8192000000 10823949360 11265785856 1912855376 18.930 100 22 45 1 1925648416 6727536 6065504
14:16:17 9045 8192000000 10817650112 11255775232 1879067120 18.658 98 17 34 2 1888059600 4684576 4307904
14:16:34 14677 8192000000 10806800336 11251003392 1885791488 18.712 99 10 20 1 1893818256 5217648 2809120
14:16:55 37716 8192000000 10803292176 11242373120 1868128336 18.569 98 17 34 0 1878275648 5031056 5116256
14:18:01 13625 8192000000 10769178048 11207147520 1838432384 18.328 98 16 32 2 1848809936 5850880 4526672
14:18:23 7722 8192000000 10770222688 11201966080 1845822464 18.388 99 20 40 0 1857628896 5166384 6640048
14:18:39 11584 8192000000 10741325552 11160768512 1766452000 17.738 95 26 52 2 1779974688 6144960 7377728
14:19:00 5163 8192000000 10720111168 11140313088 1790511856 17.936 98 23 46 2 1802832752 6366752 5954144
14:19:11 5567 8192000000 10729110784 11141222400 1779181552 17.843 98 22 44 0 1791981056 5729200 7070304
14:19:25 6926 8192000000 10709422864 11133222912 1772425040 17.787 98 23 46 0 1784930208 5992048 6513120
14:19:38 11928 8192000000 10703432880 11124150272 1713913088 17.301 95 21 42 0 1725881536 6170672 5797776
14:19:57 7603 8192000000 10699157744 11114950656 1753611008 17.632 98 30 60 0 1771886208 9489376 8785824
14:20:14 6742 8192000000 10695014864 11103391744 1735634960 17.482 97 36 72 3 1751653088 5346288 10671840
14:20:27 11292 8192000000 10673828256 11083132928 1731148320 17.445 97 26 52 0 1743932800 4730800 8053680
14:20:45 12339 8192000000 10720961792 11127816192 1784778352 17.889 100 23 46 0 1796738800 4971920 6988528
14:21:05 15904 8192000000 10710943056 11129610240 1742803440 17.542 97 16 32 2 1757442432 10468048 4170944
14:21:27 12017 8192000000 10711541552 11129065472 1750276592 17.604 97 13 27 0 1758719392 4596320 3846480
14:21:51 9042 8192000000 10724877744 11148886016 1810172592 18.097 100 18 36 2 1821663024 6531328 4959104
14:22:07 67289 8192000000 10709896928 11137470464 1765836640 17.733 97 36 71 2 1782038416 5895440 10306336
14:23:22 10725 8192000000 10741982704 11164250112 1823506800 18.206 100 38 76 0 1841245248 7610384 10128064
14:23:42 5976 8192000000 10750879840 11172741120 1832655088 18.281 100 47 94 0 1854439040 8723200 13060752
14:23:55 8693 8192000000 10749657840 11172188160 1828129408 18.244 100 22 42 2 1839651344 5730464 5791472
14:24:13 5834 8192000000 10749780032 11174416384 1836345872 18.311 100 33 66 1 1852429760 6590384 9493504
14:24:25 6781 8192000000 10741748544 11170111488 1831683344 18.273 100 22 44 1 1844147824 5773264 6691216
14:24:39 7618 8192000000 10754120512 11182178304 1841196368 18.351 100 30 60 5 1855587056 6011632 8379056
14:24:54 8536 8192000000 10759359296 11185090560 1840891712 18.348 100 15 30 0 1850872192 5657392 4323088
14:25:09 10373 8192000000 10758374080 11192262656 1847769968 18.404 100 19 39 0 1858911136 5852304 5288864
14:25:26 9965 8192000000 10770167280 11197263872 1854502672 18.459 100 27 54 2 1868380496 5844000 8033824
14:25:46 9708 8192000000 10774247888 11200466944 1858108800 18.488 100 29 57 1 1871809584 5282672 8418112
14:26:04 7523 8192000000 10780767392 11205562368 1860595968 18.508 100 25 50 2 1874106096 5705968 7804160
14:26:19 10634 8192000000 10789731408 11212079104 1864043728 18.536 100 32 64 5 1883182176 9402944 9735504
14:26:38 9695 8192000000 10786528112 11211591680 1866970672 18.560 100 36 71 2 1883154160 4995120 11188368
14:26:58 13848 8192000000 10792624016 11222454272 1879588192 18.662 100 23 46 1 1893545904 5337056 8620656
14:27:20 102408 8192000000 10847055712 11266985984 1900670480 18.832 100 32 62 3 1921710048 12235088 8804480
14:29:10 4286 8192000000 10855136656 11273117696 1918482384 18.975 100 52 103 0 1943502608 10831408 14188816
14:29:32 10021 8192000000 10865963424 11284320256 1927945904 19.050 100 57 114 0 1955721744 11815952 15959888
14:29:49 37098 8192000000 10880310592 11303989248 1937308864 19.125 100 57 111 3 1967674128 14839312 15525952
14:30:36 24772 8192000000 10884234112 11316326400 1946218752 19.196 100 52 99 2 1979945328 19689920 14036656
14:31:10 14970 8192000000 10896280080 11325157376 1952657920 19.248 100 45 90 2 1983824016 17926368 13239728
14:31:44 17539 8192000000 10907575168 11340087296 1967399920 19.365 100 59 118 1 2009153616 24161792 17591904
14:32:09 30712 8192000000 10917856768 11347996672 1969068544 19.378 100 42 84 2 2006174320 24534960 12570816
14:32:52 6783 8192000000 10919593440 11351621632 1974468240 19.421 100 58 115 4 2016903904 24866432 17569232
14:33:07 8121 8192000000 10931234592 11361193984 1980231936 19.467 100 54 107 0 2022797872 25959056 16606880
14:33:24 32941 8192000000 10922976128 11362549760 1977384720 19.444 100 46 92 1 2017739616 26676032 13678864
14:34:06 25613 8192000000 10933029728 11370721280 1980238720 19.467 100 35 70 1 2016721488 25628544 10854224
14:34:47 25615 8192000000 10940090128 11386384384 1993282528 19.570 100 42 85 1 2038514064 31665104 13566432
14:35:21 20322 8192000000 10945982992 11390693376 1997094896 19.600 100 40 79 2 2046341792 36640272 12606624
14:35:48 12260 8192000000 10959723072 11395395584 2002078640 19.639 100 56 112 1 2051545952 32330176 17137136
14:36:08 6460 8192000000 10963531392 11394994176 1999779568 19.621 100 53 106 1 2049752368 34238560 15734240
14:36:24 8180 8192000000 10966072928 11401973760 2006845808 19.677 100 53 106 0 2056712784 33962976 15904000
14:36:43 9347 8192000000 10964490880 11397263360 2002599728 19.643 100 53 103 1 2052897120 34512640 15784752
14:36:59 9426 8192000000 10976433232 11409412096 2007727408 19.684 100 52 103 3 2061704736 38885520 15091808
14:37:16 7688 8192000000 10979174832 11409702912 2013832304 19.732 100 65 128 2 2069253920 35755872 19665744
14:37:33 4436 8192000000 10987502224 11415826432 2012823344 19.724 100 72 144 1 2072382416 37825488 21733584
14:37:44 3448 8192000000 10989012800 11416276992 2019032720 19.773 100 72 144 1 2080365152 38682992 22649440
14:37:57 3274 8192000000 10996995248 11421851648 2019510128 19.776 100 70 139 0 2079529008 38451968 21566912
14:38:11 5047 8192000000 10987339328 11419209728 2001260448 19.633 99 65 129 1 2060611184 39462704 19888032
14:38:23 12310 8192000000 10991536880 11419545600 2012949408 19.725 100 65 130 1 2073616208 40427600 20239200
14:38:45 3538 8192000000 10995382688 11417235456 1999730480 19.621 99 73 146 0 2064360464 42058752 22571232
14:38:59 7152 8192000000 10996510336 11422879744 2020033568 19.780 100 74 147 3 2087410560 44481696 22895296
14:39:19 11212 8192000000 10991751408 11427115008 2019937824 19.780 100 59 118 1 2082092512 43219504 18935184
14:39:38 4435 8192000000 10988127168 11418271744 2015948768 19.748 100 66 132 0 2076253824 39908992 20396064
14:39:51 4055 8192000000 10992550608 11424739328 2021476128 19.792 100 67 134 2 2083293600 40910288 20907184
14:40:10 9704 8192000000 11000261392 11433959424 2027278608 19.837 100 61 121 2 2088484576 41420160 19785808
14:40:27 4621 8192000000 11005350720 11434110976 2025525360 19.824 100 65 126 3 2088350848 42239696 20585792
14:40:39 4896 8192000000 11013883664 11431907328 2024300768 19.814 100 76 151 2 2092636544 44743312 23592464
14:41:01 3396 8192000000 11016258608 11446665216 2030879264 19.866 100 69 136 0 2098600592 46241792 21479536
14:41:21 2124 8192000000 11017594736 11445207040 2032195856 19.876 100 79 158 0 2106308352 47666576 26445920
14:41:31 8456 8192000000 11007996672 11436474368 2013865072 19.732 99 69 136 2 2081094784 45898768 21330944
14:41:51 3001 8192000000 11020448896 11445870592 1998515008 19.611 98 79 157 1 2073700944 49960256 25225680
14:42:03 4668 8192000000 11012190624 11437535232 2025381952 19.822 100 72 142 2 2098988480 50480224 23126304
14:42:15 1725 8192000000 11014058864 11431391232 2005518624 19.666 99 85 170 3 2082229680 50302384 26408672
14:42:27 4077 8192000000 11017448896 11431342080 2017716624 19.762 100 87 173 0 2097777472 52838496 27222352
14:42:40 1864 8192000000 11013470192 11430662144 2014834944 19.740 100 85 170 1 2095941088 54012544 27093600
14:42:48 4191 8192000000 11008491632 11426144256 2010567280 19.706 100 86 172 0 2092978704 55201216 27210208
14:43:04 5372 8192000000 11014493472 11429842944 2016110320 19.750 100 85 170 0 2098384192 55631664 26642208
14:43:16 2889 8192000000 11004916544 11418726400 1986976192 19.520 99 89 178 0 2075004480 59218736 28809552
14:43:27 3456 8192000000 11024584368 11439521792 2014423328 19.736 100 84 168 4 2105888064 63963168 27501568
14:43:39 2360 8192000000 11026151344 11445280768 2018324384 19.767 100 86 172 0 2111102736 64942016 27836336
14:43:53 10862 8192000000 11003875312 11431903232 1975456112 19.429 98 60 120 0 2061436320 65764128 20216080
14:44:18 7850 8192000000 11007960784 11429662720 1997824160 19.606 100 66 131 2 2086854000 67151552 21878288
14:44:40 8274 8192000000 11001766272 11429285888 1967371680 19.365 98 66 132 2 2064217312 74744640 22100992
14:45:04 3692 8192000000 10983513936 11404861440 1974688240 19.423 100 68 136 0 2065807664 68957392 22162032
14:45:16 2417 8192000000 11012494272 11425566720 1992309552 19.562 100 84 168 3 2090348992 70848464 27190976
14:45:25 3765 8192000000 11020733760 11435790336 2002333232 19.641 100 86 172 0 2099644944 69716560 27595152
14:45:35 2670 8192000000 11029495856 11442069504 2004812640 19.661 100 83 165 1 2103097248 71825072 26459536
14:45:46 4024 8192000000 11032557008 11441504256 2005776976 19.668 100 91 182 2 2106217824 71911680 28529168
14:45:58 2943 8192000000 11019741792 11436417024 2003026832 19.647 100 83 166 0 2102553520 72765424 26761264
14:46:08 9609 8192000000 11004070992 11443417088 1998188720 19.608 100 55 110 0 2090862576 73849424 18824432
14:46:37 4430 8192000000 10991004512 11407380480 1961161200 19.315 98 72 143 0 2051604832 66547200 23896432
14:46:51 1432 8192000000 10982574048 11405299712 1961665168 19.319 99 84 167 1 2058881888 69862544 27354176
14:47:03 1478 8192000000 11013771232 11425177600 1989220816 19.538 100 94 187 2 2088958544 69556016 30181712
14:47:11 4304 8192000000 10996764480 11429421056 1990436000 19.547 100 73 146 1 2085909424 71583824 23889600
14:47:31 2898 8192000000 11002377648 11432480768 1988083024 19.529 100 73 146 1 2087860112 75275440 24501648
14:47:46 7690 8192000000 11007880832 11449950208 1997077856 19.600 100 60 120 2 2094251616 77024608 20149152
14:48:36 9373 8192000000 10937347824 11377311744 1943852096 19.177 99 37 74 0 2010962880 53946800 13163984
14:48:52 8032 8192000000 10922041376 11364646912 1939804608 19.145 100 33 66 0 2008615392 57161632 11649152
14:49:12 25631 8192000000 10924735056 11371286528 1929720064 19.065 99 33 66 2 1994388912 53141040 11527808
14:49:49 12973 8192000000 10933676160 11381264384 1953318896 19.253 100 30 60 0 2022394992 57991472 11084624
14:50:08 7725 8192000000 10930600736 11382235136 1956772848 19.280 100 29 58 2 2021104096 53646752 10684496
14:50:25 9677 8192000000 10909316736 11352178688 1911884144 18.922 98 29 58 1 1975988992 53430320 10674528
14:50:41 7737 8192000000 10912008048 11367161856 1933685008 19.096 100 31 62 3 1993837728 49806416 10346304
14:51:03 19231 8192000000 10912986976 11355123712 1933462960 19.095 100 22 44 2 1986078832 45080544 7535328
14:51:36 17645 8192000000 10888148400 11336720384 1906979472 18.882 99 22 44 1 1957648032 43190912 7477648
14:52:02 17805 8192000000 10869010944 11315916800 1886661424 18.719 98 24 48 2 1942062144 46934288 8466432
14:52:51 19451 8192000000 10883844400 11337154560 1908186624 18.892 100 18 36 3 1964589056 49480368 6922064
14:53:29 12831 8192000000 10888574528 11337003008 1906873520 18.882 100 33 66 1 1976437200 57968128 11595552
14:53:58 27614 8192000000 10886154592 11341389824 1891158736 18.755 99 20 40 1 1955486304 56570624 7756944
14:54:32 21555 8192000000 10862782784 11313451008 1868656016 18.573 98 25 49 0 1925573680 48495968 8421696
14:55:01 22599 8192000000 10849963728 11318341632 1888089392 18.730 99 16 31 3 1933290944 39018944 6182608
14:55:31 28788 8192000000 10849814176 11319242752 1883769216 18.696 99 5 10 1 1906079744 20707376 1603152
14:56:28 40696 8192000000 10860150448 11289804800 1859724400 18.501 97 36 70 3 1876947200 7747360 9475440
14:57:18 11186 8192000000 10852440400 11304112128 1917624960 18.968 100 36 72 2 1937039104 8568064 10846080
14:57:39 89494 8192000000 10872000768 11315724288 1872780544 18.607 97 17 33 0 1886354576 9492736 4081296
14:59:42 38967 8192000000 10865316496 11317063680 1896979792 18.802 98 27 51 1 1910147888 5870096 7298000
15:00:42 100318 8192000000 10868169616 11325591552 1887745200 18.728 97 12 24 3 1901463168 10631472 3086496
15:02:47 86660 8192000000 10876563824 11332608000 1903849152 18.857 98 36 70 1 1926506288 12441088 10216048
15:04:21 86142 8192000000 10874007696 11359358976 1937713280 19.129 100 11 22 0 1960519216 19315856 3490080
15:05:56 41860 8192000000 10897039824 11360313344 1956911440 19.281 100 15 30 0 1971434992 10347120 4176432
15:06:55 41702 8192000000 10914478000 11365986304 1962424832 19.325 100 34 67 1 1984911072 12575488 9910752
15:07:48 18648 8192000000 10915089776 11372470272 1973861200 19.416 100 43 86 4 2001438336 14738960 12838176
15:08:20 27013 8192000000 10909201440 11372584960 1933931280 19.098 98 35 70 2 1963616944 19310176 10375488
15:08:59 51746 8192000000 10892473616 11371585536 1960189088 19.308 100 16 32 0 1977706208 12754464 4762656
15:10:31 37295 8192000000 10887433472 11364651008 1961116896 19.315 100 6 13 0 1969506352 6630640 1758816
15:11:20 49739 8192000000 10897490560 11374854144 1970372320 19.388 100 14 28 1 1986998848 12538288 4088240
15:12:15 18228 8192000000 10893273584 11373232128 1968509472 19.374 100 5 10 0 1982189808 12488096 1192240
15:12:40 24357 8192000000 10899475312 11372818432 1972529424 19.406 100 11 20 2 1983821264 8182848 3108992
15:13:11 45649 8192000000 10904003040 11373834240 1962239120 19.324 99 29 57 3 1978737696 8511280 7987296
15:14:03 46662 8192000000 10889487840 11378130944 1950557040 19.231 99 6 12 1 1964154656 12355392 1242224
15:14:56 33737 8192000000 10889279392 11378941952 1972390720 19.404 100 5 10 0 1984013744 9961728 1661296
15:15:36 77390 8192000000 10899488416 11372830720 1961638928 19.319 99 21 42 0 1973589520 6433472 5517120
15:17:09 38458 8192000000 10919046960 11386273792 1985876432 19.511 100 27 54 0 2004163152 9966032 8320688
15:17:59 85558 8192000000 10900992832 11392913408 1984426960 19.500 100 13 26 0 1999897824 11866768 3604096
15:19:38 53093 8192000000 10919948400 11404193792 1990482016 19.548 100 12 24 1 2009602896 15485632 3635248
15:21:23 85765 8192000000 10927454080 11409088512 1982945328 19.488 99 15 30 0 2000007712 12697664 4364720
15:22:55 34753 8192000000 10916778192 11385286656 1938984704 19.139 97 12 25 0 1951164272 8900208 3279360
15:23:46 43009 8192000000 10903939984 11394953216 1946803888 19.201 98 19 38 1 1967902864 15015632 6083344
15:24:39 39637 8192000000 10948580304 11397685248 1966567984 19.358 99 17 34 0 1988659376 17167616 4923776
15:25:28 32184 8192000000 10926201056 11390574592 1967115456 19.363 99 30 61 0 1989818560 14153808 8549296
15:26:09 66237 8192000000 10941566400 11386421248 1922389504 19.006 97 20 40 0 1938736256 10744512 5602240
15:27:28 18717 8192000000 10916588304 11374641152 1946226672 19.196 98 32 64 0 1966167808 11257584 8683552
15:27:54 27400 8192000000 10871784864 11326357504 1874070656 18.617 95 39 78 0 1897928784 13316560 10541568
15:28:30 64886 8192000000 10875055232 11350093824 1874085840 18.617 96 21 42 0 1900520048 20327024 6107184
15:29:44 43931 8192000000 10884740272 11355668480 1951679216 19.240 100 13 26 0 1964322064 9276928 3365920
15:30:34 84655 8192000000 10864885584 11332976640 1846557808 18.394 94 8 16 0 1858848928 10332288 1958832
15:32:05 45850 8192000000 10868063488 11331567616 1900091424 18.827 97 14 28 0 1914584352 10405984 4086944
15:32:56 61757 8192000000 10862172720 11326050304 1869004000 18.576 96 28 56 2 1890410256 13589808 7816448
15:34:06 44062 8192000000 10881438064 11335241728 1908768144 18.897 98 51 101 3 1937422144 14254752 14399248
15:34:56 104620 8192000000 10853791488 11313078272 1822984064 18.202 94 26 52 0 1840123008 9612976 7525968
15:36:54 60075 8192000000 10876902416 11323424768 1927740400 19.049 100 44 88 0 1949669808 8570720 13358688
15:38:00 23497 8192000000 10883369664 11326726144 1930016464 19.067 100 43 86 0 1952719792 10316656 12386672
15:38:32 42760 8192000000 10841132960 11322118144 1912047568 18.923 99 14 28 2 1927801584 11518960 4235056
15:39:24 60297 8192000000 10808694592 11279724544 1800669760 18.019 94 12 24 1 1819248096 15409904 3168432
15:40:43 59639 8192000000 10804595360 11276386304 1845327264 18.384 97 10 19 1 1860634896 12021680 3285952
15:41:55 48143 8192000000 10822531424 11294388224 1883839920 18.696 99 15 30 1 1898785488 11076112 3869456
15:43:36 70627 8192000000 10831533408 11311132672 1876989952 18.641 98 8 17 0 1896377584 16961248 2426384
15:44:53 54076 8192000000 10836522544 11293831168 1844990816 18.381 97 18 37 0 1868056960 17782448 5283696
15:45:53 46770 8192000000 10834061968 11292426240 1861674288 18.517 98 14 26 1 1874370640 8182400 4513952
15:46:54 38495 8192000000 10863813568 11319713792 1903035776 18.851 99 32 64 0 1924216112 11782064 9398272
15:47:40 58740 8192000000 10863728896 11341893632 1932518032 19.087 100 19 38 1 1959965616 21868480 5579104
15:48:48 63328 8192000000 10872538736 11345338368 1921172448 18.996 99 15 31 1 1940093344 14103616 4817280
15:49:58 31732 8192000000 10891269168 11346599936 1905379872 18.870 98 20 38 0 1927093488 16276224 5437392
15:50:38 44964 8192000000 10869284320 11333869568 1903483072 18.854 98 30 60 2 1926159984 13687360 8989552
15:51:29 37152 8192000000 10882382480 11314180096 1903923600 18.858 98 39 77 1 1925104208 9710704 11469904
15:52:14 44773 8192000000 10869326208 11333206016 1923241872 19.013 99 36 72 1 1945956576 12845008 9869696
15:53:42 20126 8192000000 10886972512 11336994816 1924792640 19.025 99 39 78 0 1943813776 8026800 10994336
15:54:09 11204 8192000000 10864185920 11311046656 1893730624 18.776 98 37 74 1 1913219968 9039312 10450032
15:54:27 11668 8192000000 10884428272 11328647168 1931249376 19.077 100 45 89 2 1955696992 11088480 13359136
15:54:44 85643 8192000000 10857151488 11323682816 1878003216 18.649 97 18 35 1 1898177056 15463072 4710768
15:56:23 90093 8192000000 10899663280 11332722688 1942019088 19.163 100 37 74 1 1961061264 8340256 10701920
15:58:15 94292 8192000000 10881352832 11328761856 1904245696 18.860 97 33 67 0 1922469104 8870320 9353088
15:59:56 41381 8192000000 10918044000 11371880448 1967664816 19.367 100 40 80 0 1991796080 13397104 10734160
16:00:53 112182 8192000000 10895480960 11368824832 1952614176 19.247 99 9 18 0 1967950640 13034688 2301776
16:02:58 68588 8192000000 10917896528 11395825664 1980104192 19.466 100 12 24 0 1998486800 14860144 3522464
16:04:14 66530 8192000000 10916976304 11396427776 1982692896 19.486 100 15 31 0 2002970832 16209136 4068800
16:05:34 100999 8192000000 10910540272 11397767168 1972588576 19.406 99 23 46 0 1993312144 13487200 7236368
16:07:21 61062 8192000000 10943532128 11404070912 1994048240 19.576 100 20 40 0 2013125520 12783616 6293664
16:08:29 64491 8192000000 10920636624 11399950336 1961314048 19.316 98 13 26 0 1978271776 13144448 3813280
16:10:04 45383 8192000000 10923784656 11395067904 1958899344 19.297 98 26 52 1 1980541888 13976464 7666080
16:11:45 53060 8192000000 10911661552 11379793920 1942813936 19.169 98 30 60 1 1961528464 10338432 8376096
16:12:44 89428 8192000000 10918420128 11396222976 1947806416 19.209 98 10 20 0 1962174784 11759056 2609312
16:14:23 73501 8192000000 10902449504 11366318080 1902429248 18.846 96 25 50 0 1920037312 10594448 7013616
16:15:43 58906 8192000000 10893166800 11359596544 1860657952 18.509 94 23 46 1 1880600288 13272576 6669760
16:16:49 61449 8192000000 10884964160 11356704768 1939701680 19.144 99 15 30 0 1953120960 9371808 4047472
16:18:15 104797 8192000000 10876654336 11360313344 1910913056 18.914 97 20 40 1 1925259408 8577456 5768896
16:20:06 32549 8192000000 10906431136 11362390016 1932404256 19.086 98 40 80 1 1953464208 8112432 12947520
16:20:46 45957 8192000000 10871231216 11361927168 1941520672 19.159 99 8 14 0 1955705360 12281840 1902848
16:21:39 25106 8192000000 10857949456 11345772544 1924050608 19.019 99 10 20 1 1941185824 14145072 2990144
16:22:29 32776 8192000000 10844002096 11318886400 1916412688 18.958 99 9 18 0 1927221312 8480992 2327632
16:23:12 46418 8192000000 10852821648 11333480448 1903571008 18.855 98 10 20 0 1915232128 9021488 2639632
16:24:05 75665 8192000000 10847910176 11323166720 1853779584 18.453 95 20 40 1 1867892640 7888560 6224496
16:25:26 78288 8192000000 10846814096 11321294848 1878767232 18.655 97 19 38 0 1893826256 9798048 5260976
16:26:51 33908 8192000000 9977011280 10363011072 1103472368 11.871 57 4 8 0 1110740624 6377184 891072

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 23-01-2021 16:29:19 to 23-01-2021 16:29:50.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 102 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 23-01-2021 16:29:51 to 23-01-2021 16:29:53.

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          237137
MON$OLDEST_ACTIVE               237138
MON$OLDEST_SNAPSHOT             237138
MON$NEXT_TRANSACTION            237138
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                       2027808
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.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 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 ---
:294: 
:295: mscs-test-161.budzdorov.ru    Sat Jan 23 16:27:37 2021
:296:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:297: 
:298: 
:299: mscs-test-161.budzdorov.ru    Sat Jan 23 16:27:37 2021
:300:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:301: 
--- end of diff output ---

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

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