#	exclusive	inclusive	rows x	rows	loops	node
1.	4.605	431.338	↑ 1.0	1	1	→ Aggregate (cost=182,193.31..182,193.32 rows=1 width=0) (actual time=431.338..431.338 rows=1 loops=1)
2.	11.633	426.733	↓ 2.4	24,785	1	→ Nested Loop (cost=1.12..182,167.46 rows=10,342 width=0) (actual time=0.196..426.733 rows=24,785 loops=1)
3.	291.175	291.175	↓ 1.8	24,785	1	→ Index Scan using index_trade_audit_brief_query on tb_trade_audit_brief (cost=0.56..47,747.16 rows=13,719 width=4) (actual time=0.174..291.175 rows=24,785 loops=1) Index Cond: (((dteventtime)::text >= '2019-01-14 01:00:00'::text) AND ((dteventtime)::text <= '2019-01-14 17:30:46'::text) AND (game_id = 2) AND (istreasure = 1))
4.	123.925	123.925	↑ 1.0	1	24,785	→ Index Scan using com_seq_id_index on tb_ws_punishdetail (cost=0.56..9.79 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=24,785) Index Cond: (com_seq_id = tb_trade_audit_brief.com_seq_id) Filter: (p_person = 1) Rows Removed by Filter: 1

 Aggregate  (cost=182193.31..182193.32 rows=1 width=0) (actual time=431.338..431.338 rows=1 loops=1)
   ->  Nested Loop  (cost=1.12..182167.46 rows=10342 width=0) (actual time=0.196..426.733 rows=24785 loops=1)
         ->  Index Scan using index_trade_audit_brief_query on tb_trade_audit_brief  (cost=0.56..47747.16 rows=13719 width=4) (actual time=0.174..291.175 rows=24785 loops=1)
               Index Cond: (((dteventtime)::text >= '2019-01-14 01:00:00'::text) AND ((dteventtime)::text <= '2019-01-14 17:30:46'::text) AND (game_id = 2) AND (istreasure = 1))
         ->  Index Scan using com_seq_id_index on tb_ws_punishdetail  (cost=0.56..9.79 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=24785)
               Index Cond: (com_seq_id = tb_trade_audit_brief.com_seq_id)
               Filter: (p_person = 1)
               Rows Removed by Filter: 1
 Planning time: 2.647 ms
 Execution time: 431.401 ms

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	4.605 ms	1.1 %
Index Scan	2	415.100 ms	96.2 %
Nested Loop	1	11.633 ms	2.7 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
tb_trade_audit_brief	1	291.175 ms	67.5 %
Index Scan	1	291.175 ms	100.0 %
tb_ws_punishdetail	1	123.925 ms	28.7 %
Index Scan	1	123.925 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RpOQ

Color mode:

Visible columns:

Per node type stats

Per table stats