From the Bug Tracker:
Vlad Khorsun commented on CORE-1999:
------------------------------------
gbak now has a new command-line switch
-ST(ATISTICS) TDRW show statistics:
T time from start
D delta time
R page reads
W page writes
Sample output:
firebird>gbak -v -stat tdrw -r o a.fbk a.fdb
gbak:opened file a.fbk
gbak: time delta reads writes
gbak: 0.173 0.173 0 0 transportable backup -- data in XDR format
gbak: 0.175 0.002 0 0 backup file is compressed
gbak: 0.177 0.001 0 0 backup version is 10
gbak: 0.270 0.092 0 650 created database s:\Temp\A+.FDB, page_size 8192 bytes
gbak: 0.273 0.002 0 2 started transaction
gbak: 0.274 0.001 0 0 restoring domain RDB$29
gbak: 0.275 0.001 0 0 restoring domain RDB$12
...
gbak: 18.661 0.002 0 0 restoring data for table TEST1
gbak: 18.698 0.036 0 0 10000 records restored
gbak: 18.735 0.036 0 0 20000 records restored
...
gbak: 25.177 0.036 0 0 1770000 records restored
gbak: 25.220 0.042 0 1633 1780000 records restored
gbak: 25.256 0.036 0 0 1790000 records restored
...
gbak: 38.702 0.002 0 0 restoring privilege for user SYSDBA
gbak: 38.707 0.004 22 0 creating indexes
gbak: 45.015 6.308 82 38394 activating and creating deferred index T2_VAL
gbak: 45.132 0.116 3 9 activating and creating deferred index TEST_S_UNQ
gbak: 46.486 1.354 0 10775 activating and creating deferred index RDB$PRIMARY1
gbak: 46.566 0.079 0 9 activating and creating deferred index T1_IDX
gbak: 46.661 0.095 5 15 committing metadata
gbak: 46.665 0.003 8 10 fixing views dbkey length
gbak: 46.666 0.001 1 18 updating ownership of packages, procedures and tables
gbak: 46.671 0.005 0 0 adding missing privileges
gbak: 46.673 0.001 0 0 fixing system generators
gbak: 46.682 0.008 4 13 finishing, closing, and going home
gbak: 46.684 0.002 171 82442 total statistics
gbak:adjusting the ONLINE and FORCED WRITES flags
Monday, July 27, 2015
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment