synex.uk / 127.0.0.1 / pg_dashboard / pg_tracking

There are no favorite tables.

New
agent_dashboard
dv_pro
genie_pg
information_schema
monitor_number
mysql
performance_schema
pg_dashboard
- pg_dashboard
- pg_dashboard_restore_test
phpmyadmin
sms_dashboard
superbrands_dashboard
telegram_dashboard
test

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

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

Browse mode

Customize browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 24 (2426682 total, Query took 2.2823 seconds.) [brand: SPBJ... - SPBJ...]

SELECT * FROM `pg_tracking` ORDER BY `brand` DESC

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

Sort by key:

			id	brand 1	currency	report_type	reference	channel	pg_chart_id	pg_processing_time	pg_completed_time	pg_status	payment_chart_id	pyt_processing_time	pyt_completed_time	pyt_status	error_note	pg_amount	pg_pic_primary	pg_pic_secondary	pg_pic_override	pg_speed_seconds	pyt_speed_seconds	total_speed_seconds	record_date	pg_pic	created_at	updated_at
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 1195049216	1195049216	SPBJ	BDT	main	DJD9VSQELT	SMEXPAY	D1597129326	2026-10-14 00:33:49	2026-10-14 00:33:49	PYT-Auto Success	D1597129326	2026-10-14 00:33:49	2026-10-14 00:35:08	Approved By System		500.00	SLDev			0	79	79	2026-10-13	SLDev	2026-10-14 00:33:49	2026-10-14 00:49:01
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 314901760	314901760	SPBJ	BDT	main	75OMTCH5	SmartPay	D1175748290	2026-07-17 01:09:48	2026-07-17 01:27:32	PYT-Mark as success	D1175748290	2026-07-17 01:27:32	2026-07-17 01:28:23	Order Approved	INCOMPLETE	300.00	SLShash			1064	51	1115	2026-07-16	SLShash	2026-07-17 01:09:48	2026-07-17 01:28:23
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 248841728	248841728	SPBJ	BDT	main	75N4KRDP	EXMerchantPay	D1170045046	2026-07-09 00:47:58	2026-07-09 00:48:17	PYT-Mark as success	D1170045046	2026-07-09 00:48:17	2026-07-09 00:49:11	Order Approved	NO SMS	10000.00	EX-RC	BVLINLIN		19	54	73	2026-07-08	EX-RC	2026-07-09 00:32:18	2026-07-09 00:49:11
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 341837568	341837568	SPBJ	BDT	main	75P7MORE	AutoPay		2026-07-20 11:43:50	NULL	PG-Processing		NULL	NULL			NULL	SLLakshi			NULL	NULL	NULL	2026-07-20	SLLakshi	2026-07-20 11:43:50	2026-07-20 11:43:50
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 788992	788992	SPBJ	BDT	main	DDB4202UTW	SmartPay		2026-04-14 18:35:04	2026-04-14 19:08:01	CS - kindly ask player raised correct reference ag...		NULL	NULL			NULL				NULL	NULL	NULL	2026-04-14	REAKSA	2026-04-14 15:59:10	2026-04-14 19:08:01
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 425855488	425855488	SPBJ	BDT	main	DGU3W2SQ2N	Cashthru	D1184142546	2026-07-31 08:56:29	2026-07-31 21:57:51	PYT-Mark as success	D1184142546	2026-07-31 21:57:51	2026-07-31 21:58:58	Order Approved	NO SMS	500.00	CT-BOT	DV		46882	67	46949	2026-07-30	CT-BOT	2026-07-31 00:35:57	2026-07-31 21:58:58
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 345704960	345704960	SPBJ	BDT	main	DGK1KETBWP	SmartPay	D1178439228	2026-07-22 08:56:13	2026-07-23 05:51:41	PYT-Auto Success	D1178439228	2026-07-23 05:51:41	2026-07-23 05:52:29	Approved By System		500.00	SLSri	SLShash		75328	48	75376	2026-07-21	SLSri	2026-07-21 00:45:56	2026-07-23 05:52:29
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 726665984	726665984	SPBJ	BDT	main	75WAUTEC	SmartPay	D1563667065	2026-08-28 23:18:27	2026-08-28 23:18:27	PYT-Auto Success	D1563667065	2026-08-28 23:18:27	2026-08-28 23:19:49	Approved By System		500.00	SP-BOT			0	82	82	2026-08-28	SP-BOT	2026-08-28 23:18:27	2026-08-28 23:19:49
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 1248136448	1248136448	SPBJ	BDT	main	DJJ29FD02S	AutoPay	D1600976380	2026-10-19 23:24:00	2026-10-19 23:50:19	PYT-Mark as success	D1600976380	2026-10-19 23:50:19	2026-10-19 23:51:15	Order Approved	NO SMS	700.00	SLSri	BVFOU		1579	56	1635	2026-10-19	SLSri	2026-10-19 23:24:00	2026-10-19 23:51:15
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 266240	266240	SPBJ	BDT	main	756F1TDJ	EXMerchantPay	D1108653026	2026-04-05 23:58:56	2026-04-05 23:59:29	PYT-Auto Success	D1108653026	2026-04-05 23:59:29	2026-04-05 23:59:29	Approved By System		NULL				33	0	33	2026-04-05	EX-BOT	2026-04-05 23:58:56	2026-04-05 23:59:29
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 1162219776	1162219776	SPBJ	BDT	main	764AUX7W	AutoPay	D1594357020	2026-10-10 15:22:38	2026-10-10 22:40:30	PYT-Mark as success	D1594357020	2026-10-10 22:40:30	2026-10-10 22:41:40	Order Approved	NO SMS	600.00	AP-BOT	SLShash		26272	70	26342	2026-10-10	AP-BOT	2026-10-10 15:21:09	2026-10-10 22:41:40
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 738857472	738857472	SPBJ	BDT	main	DHT3WEQEH5	SMEXPAY	D1564370553	2026-08-30 09:38:37	2026-08-30 09:39:37	PYT-Mark as success	D1564370553	2026-08-30 09:39:37	2026-08-30 09:39:37	Order Approved	NO SMS	300.00	SLDhaya			60	0	60	2026-08-30	SLDhaya	2026-08-30 00:37:34	2026-08-30 09:39:37
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 1082397184	1082397184	SPBJ	BDT	main	DIT44PM6E8	SmartPay	D1586943128	2026-09-29 20:41:58	2026-09-29 20:43:10	PYT-Auto Success	D1586943128	2026-09-29 20:43:10	2026-09-29 20:45:31	Order Approved		13500.00	SLPavani			72	141	213	2026-09-29	SLPavani	2026-09-29 20:41:58	2026-09-29 20:45:31
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 293606400	293606400	SPBJ	BDT	main	75NZ0PY2	SmartPay	D1173403987	2026-07-14 05:47:35	2026-07-14 05:49:44	PYT-Mark as success	D1173861708	2026-07-14 05:49:44	2026-07-14 05:51:39	Manually Credited	INCOMPLETE	100.00	SLThusa			129	115	244	2026-07-13	SLThusa	2026-07-14 05:47:35	2026-07-14 05:51:39
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 471669248	471669248	SPBJ	BDT	main	DH565HK982	SmartPay	S03-18BKASH-8641 (24/7)	2026-08-05 17:37:55	2026-08-05 17:59:28	CS-Refund Success		NULL	NULL		X cash out	200.00	SLDev	SLHari		1293	NULL	NULL	2026-08-05	SLDev	2026-08-05 17:37:03	2026-08-05 17:59:46
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 591665664	591665664	SPBJ	BDT	main	DHF1HIMSYH	SMEXPAY	D1551528789	2026-08-15 22:08:13	2026-08-15 22:08:13	PYT-Mark as success	D1551528789	2026-08-15 22:08:13	2026-08-15 22:09:16	Approved By System	Suspicious	550.00	EX-BOT			0	63	63	2026-08-15	EX-BOT	2026-08-15 22:08:13	2026-08-15 22:09:16
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 442571264	442571264	SPBJ	BDT	main	DH1205G77W	MerchantPay	D1184826286	2026-08-01 22:01:05	2026-08-01 22:01:05	PYT-Mark as success	D1184826286	2026-08-01 22:01:05	2026-08-01 22:01:05	Order Approved	SMS	500.00	CT-BOT			0	0	0	2026-08-01	CT-BOT	2026-08-01 22:01:05	2026-08-01 22:01:05
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 989952	989952	SPBJ	BDT	main	7588KH4P	SMEXPAY	D1117244018	2026-04-17 11:40:53	2026-04-17 11:54:02	PYT-Mark as success	D1117244018	2026-04-17 11:54:02	2026-04-17 12:14:33	Approved By System		NULL			BVRAVUTH	789	1231	2020	2026-04-17	BVRAVUTH	2026-04-17 11:40:53	2026-04-20 01:02:07
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 1068375040	1068375040	SPBJ	BDT	main	7624CT3R	EXMerchantPay	D1585773779	2026-09-27 19:34:58	2026-09-28 00:01:46	PYT-Auto Success	D1585773779	2026-09-28 00:01:46	2026-09-28 00:02:25	Approved By System	NO SMS	600.00	BVMey			16008	39	16047	2026-09-27	BVMey	2026-09-27 18:57:22	2026-09-28 00:02:25
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 268115456	268115456	SPBJ	BDT	main	DGB09EWFYQ	SmartPay	S33-1BKASH-1936	2026-07-11 12:39:16	2026-07-11 13:38:08	CS-Refund Success		NULL	NULL		X cash out	200.00	SLHarani	SLSanjay		3532	NULL	NULL	2026-07-11	SLHarani	2026-07-11 12:37:02	2026-07-11 13:38:08
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 1239032576	1239032576	SPBJ	BDT	main	765ZIPNE	SMEXPAY	D1600366200	2026-10-18 23:42:42	2026-10-18 23:42:42	PYT-Auto Success	D1600366200	2026-10-18 23:42:42	2026-10-18 23:42:42	Approved By System		25000.00	EX-BOT			0	0	0	2026-10-18	EX-BOT	2026-10-18 23:42:42	2026-10-18 23:42:42
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 23274496	23274496	SPBJ	BDT	main	75AH6Z19	SMSmartPay	D1126645775	2026-05-02 07:03:26	2026-05-02 07:06:33	PYT-Mark as success	D1126645775	2026-05-02 07:06:33	2026-05-02 07:07:20	Order Approved	INCOMPLETE	1000.00	BDSPG			187	47	234	2026-05-01	BDSPG	2026-05-02 07:03:26	2026-05-02 07:16:03
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 604579328	604579328	SPBJ	BDT	main	75TZXJCG	SMEXPAY	D1552281421	2026-08-17 08:56:58	2026-08-17 09:53:12	PYT-Auto Success	D1552281421	2026-08-17 09:53:12	2026-08-17 09:54:17	Approved By System	NO SMS	3000.00	SLDhaya			3374	65	3439	2026-08-16	SLDhaya	2026-08-16 22:40:20	2026-08-17 09:54:17
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 206120448	206120448	SPBJ	BDT	main	75LRSFUA	AutoPay	MAN20260701205437629	2026-07-01 19:53:20	2026-07-01 19:54:56	PYT-Make Up Success	D1165624427	2026-07-01 19:54:56	2026-07-01 19:56:32	Manually Credited	X cash out	450.00	SLDilu			96	96	192	2026-07-01	SLDilu	2026-07-01 19:53:20	2026-07-01 19:56:32
Edit	Copy	Delete DELETE FROM pg_tracking WHERE `pg_tracking`.`id` = 1184835072	1184835072	SPBJ	BDT	main	DJC3TG0B7P	AutoPay	D1596284469	2026-10-13 08:57:12	2026-10-13 08:57:12	PYT-Mark as success	D1596284469	2026-10-13 08:57:12	2026-10-13 08:57:12	Order Approved	NO SMS	1960.00	SLUthesh	SLHari		0	0	0	2026-10-12	SLUthesh	2026-10-12 20:46:56	2026-10-13 08:57:12

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view