Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: sys »View: schema_table_statistics
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation
Showing rows 0 - ... This view has at least this number of rows. Please refer to documentation. (Query took 0.0104 seconds.)
SELECT * FROM `schema_table_statistics`
table_schematable_nametotal_latencyrows_fetchedfetch_latencyrows_insertedinsert_latencyrows_updatedupdate_latencyrows_deleteddelete_latencyio_read_requestsio_readio_read_latencyio_write_requestsio_writeio_write_latencyio_misc_requestsio_misc_latency
simpedak_db sidokaf_accreditation_institution_document 17.24 s 7336827 17.24 s 45 969.26 us 27 475.85 us 0  0 ps 16029075 1.07 GiB 14.02 s 145 20.87 KiB 1.47 ms 8472859 1.75 s
phpmyadmin pma__recent 13.22 s 21690 155.61 ms 21008 12.30 s 21008 765.09 ms 0  0 ps 3 48.00 KiB 25.85 ms 6815 106.48 MiB 482.18 ms 6820 2.34 min
simpedak_db sidokaf_accreditation_transaction 2.93 s 6191316 2.93 s 0  0 ps 87 1.98 ms 0  0 ps 40 640.00 KiB 1.34 ms 87 1.36 MiB 28.01 ms 90 1.69 s
simpedak_db accreditation_instrument 1.15 s 396371 1.15 s 0  0 ps 0  0 ps 0  0 ps 793121 137.47 MiB 772.66 ms 0   0 bytes  0 ps 396622 107.59 ms
material-teknik permintaan 901.80 ms 320013 901.80 ms 0  0 ps 0  0 ps 0  0 ps NULL NULL NULL NULL NULL NULL NULL NULL
arsip_surat tbl_suma 755.61 ms 1460277 754.51 ms 17 1.04 ms 1 67.40 us 0  0 ps 525 8.20 MiB 19.77 ms 20 320.00 KiB 3.40 ms 24 417.92 ms
phpmyadmin pma__userconfig 450.80 ms 27079 450.76 ms 0  0 ps 1 35.26 us 0  0 ps 3 48.00 KiB 14.47 ms 1 16.00 KiB 682.83 us 6 28.22 ms
pengiriman pengiriman 260.02 ms 29 259.22 ms 4 544.14 us 0  0 ps 4 246.99 us 4 64.00 KiB 1.58 ms 5 80.00 KiB 4.75 ms 10 165.10 ms
phpmyadmin pma__column_info 189.44 ms 2970 189.44 ms 0  0 ps 0  0 ps 0  0 ps 4 64.00 KiB 51.12 ms 0   0 bytes  0 ps 5 124.05 us
phpmyadmin pma__favorite 150.15 ms 943 39.03 ms 252 102.53 ms 251 8.59 ms 0  0 ps 3 48.00 KiB 30.83 ms 161 2.52 MiB 14.65 ms 166 3.17 s
phpmyadmin pma__tracking 113.14 ms 13020 113.14 ms 0  0 ps 0  0 ps 0  0 ps 3 48.00 KiB 30.03 ms 0   0 bytes  0 ps 5 147.09 us
simpedak_db accreditation_instrument_standard 98.00 ms 22426 98.00 ms 0  0 ps 0  0 ps 0  0 ps 38830 11.78 MiB 80.84 ms 0   0 bytes  0 ps 19460 5.81 ms
phpmyadmin pma__table_info 49.74 ms 5303 49.74 ms 0  0 ps 0  0 ps 0  0 ps 3 48.00 KiB 13.80 ms 0   0 bytes  0 ps 5 142.47 us
phpmyadmin pma__table_uiprefs 47.01 ms 1944 47.01 ms 0  0 ps 0  0 ps 0  0 ps 3 48.00 KiB 19.52 ms 0   0 bytes  0 ps 5 146.34 us
pengiriman user 46.74 ms 23 46.74 ms 0  0 ps 0  0 ps 0  0 ps 3 48.00 KiB 45.74 ms 0   0 bytes  0 ps 5 405.80 us
phpmyadmin pma__central_columns 42.63 ms 16 42.63 ms 0  0 ps 0  0 ps 0  0 ps 3 48.00 KiB 19.86 ms 0   0 bytes  0 ps 5 175.71 us
phpmyadmin pma__designer_settings 39.96 ms 36 39.96 ms 0  0 ps 0  0 ps 0  0 ps 3 48.00 KiB 39.41 ms 0   0 bytes  0 ps 5 218.79 us
arsip_surat tbl_bidang 32.64 ms 52931 32.64 ms 0  0 ps 0  0 ps 0  0 ps 3 48.00 KiB 1.01 ms 0   0 bytes  0 ps 5 154.07 us
simpedak_db modules 31.96 ms 40103 31.96 ms 0  0 ps 0  0 ps 0  0 ps 3 48.00 KiB 68.35 ms 0   0 bytes  0 ps 5 138.83 us
pengiriman layanan 25.70 ms 34 25.70 ms 0  0 ps 0  0 ps 0  0 ps 3 48.00 KiB 25.06 ms 0   0 bytes  0 ps 5 143.68 us
simpedak_db location_village 20.48 ms 509 20.48 ms 0  0 ps 0  0 ps 0  0 ps 291 4.55 MiB 40.38 ms 0   0 bytes  0 ps 5 142.85 us
simpedak_db user_profile 17.93 ms 2967 16.07 ms 0  0 ps 29 1.86 ms 0  0 ps 5 80.00 KiB 29.16 ms 27 432.00 KiB 7.85 ms 32 277.08 ms
simpedak_db user_group_access 17.51 ms 48837 17.51 ms 0  0 ps 0  0 ps 0  0 ps 3 48.00 KiB 37.34 ms 0   0 bytes  0 ps 5 128.34 us
simpedak_db user_log 17.07 ms 272 14.08 ms 27 2.90 ms 2 98.95 us 0  0 ps 99 1.55 MiB 132.04 ms 27 432.00 KiB 26.94 ms 32 801.91 ms
simpedak_db location_city 15.37 ms 1262 15.37 ms 0  0 ps 0  0 ps 0  0 ps 2528 51.62 KiB 34.80 ms 0   0 bytes  0 ps 1318 1.48 ms