explain.depesz.com

PostgreSQL's explain analyze made readable

Result: F323

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 205.833 ↓ 0.0 0 1

Limit (cost=538,347.47..538,347.52 rows=20 width=948) (actual time=205.833..205.833 rows=0 loops=1)

2. 0.010 205.832 ↓ 0.0 0 1

Sort (cost=538,347.47..538,348.76 rows=515 width=948) (actual time=205.832..205.832 rows=0 loops=1)

  • Sort Key: e.exectime DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.006 205.822 ↓ 0.0 0 1

HashAggregate (cost=538,323.47..538,328.62 rows=515 width=948) (actual time=205.822..205.822 rows=0 loops=1)

  • Group Key: e.id, s.storename, p.costname, p.begindate, p.enddate, e.exectime, (NULL::timestamp without time zone), e.exectime, ('已执行'::text), (''::text), w.recordid
4. 0.001 205.816 ↓ 0.0 0 1

Append (cost=860.45..538,309.30 rows=515 width=948) (actual time=205.816..205.816 rows=0 loops=1)

5. 0.000 0.040 ↓ 0.0 0 1

Nested Loop Left Join (cost=860.45..514,884.95 rows=403 width=165) (actual time=0.040..0.040 rows=0 loops=1)

6. 0.000 0.040 ↓ 0.0 0 1

Nested Loop Left Join (cost=860.02..511,551.70 rows=403 width=75) (actual time=0.040..0.040 rows=0 loops=1)

7. 0.006 0.040 ↓ 0.0 0 1

Hash Right Join (cost=859.75..510,858.10 rows=403 width=40) (actual time=0.040..0.040 rows=0 loops=1)

  • Hash Cond: (w.visitcontentid = e.id)
8. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_visit_workrecord w (cost=0.00..474,317.54 rows=13,592,683 width=16) (never executed)

  • Filter: (platstatus = 1)
9. 0.000 0.034 ↓ 0.0 0 1

Hash (cost=856.87..856.87 rows=230 width=32) (actual time=0.034..0.034 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
10. 0.034 0.034 ↓ 0.0 0 1

Index Scan using kx_cost_display_exec_execop_idx on kx_cost_display_exec e (cost=0.43..856.87 rows=230 width=32) (actual time=0.034..0.034 rows=0 loops=1)

  • Index Cond: (execop = '1300365132085465088'::bigint)
  • Filter: (platstatus = 1)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using kx_cost_plan_pkey on kx_cost_plan p (cost=0.28..1.72 rows=1 width=51) (never executed)

  • Index Cond: (e.costid = id)
  • Filter: (platstatus = 1)
12. 0.000 0.000 ↓ 0.0 0

Index Scan using kx_kq_store_pkey on kx_kq_store s (cost=0.42..8.27 rows=1 width=26) (never executed)

  • Index Cond: (id = e.customerid)
  • Filter: (platstatus = 1)
13. 0.000 205.775 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,001.55..23,419.20 rows=112 width=165) (actual time=205.775..205.775 rows=0 loops=1)

14. 0.921 205.854 ↓ 0.0 0 1

Gather (cost=1,001.28..23,097.60 rows=112 width=46) (actual time=205.775..205.854 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 0
15. 0.001 204.933 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.28..22,086.40 rows=47 width=46) (actual time=204.933..204.933 rows=0 loops=1)

16. 0.000 204.932 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.85..22,048.53 rows=47 width=50) (actual time=204.932..204.932 rows=0 loops=1)

17. 0.001 204.932 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.42..21,653.18 rows=47 width=50) (actual time=204.932..204.932 rows=0 loops=1)

18. 204.931 204.931 ↓ 0.0 0 1

Parallel Seq Scan on kx_cost_display_cash c (cost=0.00..21,259.62 rows=47 width=40) (actual time=204.931..204.931 rows=0 loops=1)

  • Filter: ((createop = '6515543727'::bigint) AND (platstatus = 1))
  • Rows Removed by Filter: 264,992
19. 0.000 0.000 ↓ 0.0 0

Index Scan using kx_kq_store_pkey on kx_kq_store s_1 (cost=0.42..8.37 rows=1 width=26) (never executed)

  • Index Cond: (id = c.tn_customerid)
  • Filter: (platstatus = 1)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_kx_cost_customerapply_detail_1 on kx_cost_customerapply_detail a (cost=0.43..8.41 rows=1 width=16) (never executed)

  • Index Cond: (id = c.tn_applyid)
  • Filter: (platstatus = 1)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using kx_cost_customerapply_pkey on kx_cost_customerapply y (cost=0.43..0.81 rows=1 width=12) (never executed)

  • Index Cond: (id = a.caid)
  • Filter: (platstatus = 1)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using kx_cost_plan_pkey on kx_cost_plan p_1 (cost=0.28..2.87 rows=1 width=51) (never executed)

  • Index Cond: (c.costid = id)
  • Filter: (platstatus = 1)
Planning time : 1.909 ms
Execution time : 206.087 ms