explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RpOQ

Settings
# 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