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.0112 seconds.)
SELECT * FROM `schema_table_statistics`
[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
|
|
|
Number of rows:
Filter rows:
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.12 s 7284691 17.12 s 45 969.26 us 27 475.85 us 0  0 ps 15915211 1.06 GiB 13.92 s 145 20.87 KiB 1.47 ms 8412683 1.74 s
phpmyadmin pma__recent 13.21 s 21582 155.01 ms 20907 12.30 s 20907 761.06 ms 0  0 ps 3 48.00 KiB 25.85 ms 6716 104.94 MiB 474.93 ms 6721 2.30 min
simpedak_db sidokaf_accreditation_transaction 2.92 s 6146656 2.91 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.14 s 393143 1.14 s 0  0 ps 0  0 ps 0  0 ps 786665 136.24 MiB 766.29 ms 0   0 bytes  0 ps 393394 106.69 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 449.02 ms 26967 448.98 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.22 ms 2966 189.22 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.10 ms 936 38.98 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 97.89 ms 22366 97.89 ms 0  0 ps 0  0 ps 0  0 ps 38770 11.78 MiB 80.79 ms 0   0 bytes  0 ps 19430 5.80 ms
phpmyadmin pma__table_info 49.55 ms 5278 49.55 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
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__table_uiprefs 46.60 ms 1915 46.60 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
phpmyadmin pma__central_columns 42.60 ms 16 42.60 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.01 ms 38840 31.01 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.57 ms 2880 15.73 ms 0  0 ps 28 1.84 ms 0  0 ps 5 80.00 KiB 29.16 ms 26 416.00 KiB 7.81 ms 31 267.33 ms
simpedak_db user_log 17.00 ms 272 14.08 ms 26 2.83 ms 2 98.95 us 0  0 ps 99 1.55 MiB 132.04 ms 26 416.00 KiB 26.85 ms 31 782.36 ms
simpedak_db user_group_access 16.94 ms 47233 16.94 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 location_city 15.30 ms 1237 15.30 ms 0  0 ps 0  0 ps 0  0 ps 2478 50.75 KiB 34.74 ms 0   0 bytes  0 ps 1293 1.47 ms

|
|
|
Number of rows:
Filter rows:
Query results operationsPrint PrintCopy to clipboard Copy to clipboardExport Export Display chart Display chart Create view Create view

Bookmark this SQL query Bookmark this SQL query