explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 82yfO

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

Group (cost=1,306,173.12..2,576,888.30 rows=1 width=1,261) (actual time=105.874..105.874 rows=0 loops=1)

  • Group Key: (to_char(kx.createtime, 'yyyy-mm'::text)), org3.orgname, org4.orgname, org5.orgname, org6.orgname, pu.phonenumber, pl.positionid, a.orgname, (to_char(((((((to_char(kx.createtime, 'yyyy-mm'::text) || '-01'::text))::timestamp without time zone + '1 mon'::interval) + '-1 days'::interval))::date)::timestamp with time zone, 'dd'::text)), ((SubPlan 1)), (((to_char(((((((to_char(kx.createtime, 'yyyy-mm'::text) || '-01'::text))::timestamp without time zone + '1 mon'::interval) + '-1 days'::interval))::date)::timestamp with time zone, 'dd'::text))::integer - (SubPlan 2))), (CASE WHEN (alternatives: SubPlan 3 or hashed SubPlan 4) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 5 or hashed SubPlan 6) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 7 or hashed SubPlan 8) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 9 or hashed SubPlan 10) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 11 or hashed SubPlan 12) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 13 or hashed SubPlan 14) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 15 or hashed SubPlan 16) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 17 or hashed SubPlan 18) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 19 or hashed SubPlan 20) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 21 or hashed SubPlan 22) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 23 or hashed SubPlan 24) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 25 or hashed SubPlan 26) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 27 or hashed SubPlan 28) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 29 or hashed SubPlan 30) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 31 or hashed SubPlan 32) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 33 or hashed SubPlan 34) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 35 or hashed SubPlan 36) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 37 or hashed SubPlan 38) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 39 or hashed SubPlan 40) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 41 or hashed SubPlan 42) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 43 or hashed SubPlan 44) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 45 or hashed SubPlan 46) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 47 or hashed SubPlan 48) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 49 or hashed SubPlan 50) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 51 or hashed SubPlan 52) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 53 or hashed SubPlan 54) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 55 or hashed SubPlan 56) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 57 or hashed SubPlan 58) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 59 or hashed SubPlan 60) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 61 or hashed SubPlan 62) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 63 or hashed SubPlan 64) THEN '√'::text ELSE '×'::text END), org1.codepath
2. 0.072 105.873 ↓ 0.0 0 1

Sort (cost=1,306,173.12..1,306,173.12 rows=1 width=1,261) (actual time=105.873..105.873 rows=0 loops=1)

  • Sort Key: org3.orgname, org4.orgname, org5.orgname, org6.orgname, pu.phonenumber, pl.positionid, a.orgname, (to_char(((((((to_char(kx.createtime, 'yyyy-mm'::text) || '-01'::text))::timestamp without time zone + '1 mon'::interval) + '-1 days'::interval))::date)::timestamp with time zone, 'dd'::text)), ((SubPlan 1)), (((to_char(((((((to_char(kx.createtime, 'yyyy-mm'::text) || '-01'::text))::timestamp without time zone + '1 mon'::interval) + '-1 days'::interval))::date)::timestamp with time zone, 'dd'::text))::integer - (SubPlan 2))), (CASE WHEN (alternatives: SubPlan 3 or hashed SubPlan 4) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 5 or hashed SubPlan 6) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 7 or hashed SubPlan 8) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 9 or hashed SubPlan 10) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 11 or hashed SubPlan 12) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 13 or hashed SubPlan 14) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 15 or hashed SubPlan 16) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 17 or hashed SubPlan 18) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 19 or hashed SubPlan 20) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 21 or hashed SubPlan 22) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 23 or hashed SubPlan 24) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 25 or hashed SubPlan 26) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 27 or hashed SubPlan 28) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 29 or hashed SubPlan 30) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 31 or hashed SubPlan 32) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 33 or hashed SubPlan 34) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 35 or hashed SubPlan 36) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 37 or hashed SubPlan 38) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 39 or hashed SubPlan 40) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 41 or hashed SubPlan 42) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 43 or hashed SubPlan 44) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 45 or hashed SubPlan 46) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 47 or hashed SubPlan 48) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 49 or hashed SubPlan 50) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 51 or hashed SubPlan 52) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 53 or hashed SubPlan 54) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 55 or hashed SubPlan 56) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 57 or hashed SubPlan 58) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 59 or hashed SubPlan 60) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 61 or hashed SubPlan 62) THEN '√'::text ELSE '×'::text END), (CASE WHEN (alternatives: SubPlan 63 or hashed SubPlan 64) THEN '√'::text ELSE '×'::text END), org1.codepath
  • Sort Method: quicksort Memory: 25kB
3. 0.001 105.801 ↓ 0.0 0 1

Nested Loop (cost=1,003.24..1,306,173.11 rows=1 width=1,261) (actual time=105.801..105.801 rows=0 loops=1)

4. 0.000 105.800 ↓ 0.0 0 1

Nested Loop (cost=1,002.82..35,452.86 rows=1 width=197) (actual time=105.800..105.800 rows=0 loops=1)

5. 0.000 105.800 ↓ 0.0 0 1

Nested Loop (cost=1,002.40..35,447.67 rows=1 width=181) (actual time=105.800..105.800 rows=0 loops=1)

6. 0.000 105.800 ↓ 0.0 0 1

Nested Loop (cost=1,001.98..35,442.49 rows=1 width=165) (actual time=105.799..105.800 rows=0 loops=1)

7. 14.542 112.476 ↓ 0.0 0 1

Gather (cost=1,001.55..35,437.31 rows=1 width=149) (actual time=105.799..112.476 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
8. 0.002 97.934 ↓ 0.0 0 3

Nested Loop (cost=1.55..34,437.21 rows=1 width=149) (actual time=97.933..97.934 rows=0 loops=3)

  • Join Filter: (pl.positionid = org2.positionid)
9. 0.000 97.932 ↓ 0.0 0 3

Nested Loop (cost=1.13..34,432.01 rows=1 width=149) (actual time=97.932..97.932 rows=0 loops=3)

10. 0.001 97.932 ↓ 0.0 0 3

Nested Loop (cost=1.13..34,430.13 rows=1 width=126) (actual time=97.931..97.932 rows=0 loops=3)

11. 0.000 97.931 ↓ 0.0 0 3

Nested Loop (cost=0.84..34,425.50 rows=1 width=123) (actual time=97.931..97.931 rows=0 loops=3)

12. 0.003 97.931 ↓ 0.0 0 3

Nested Loop (cost=0.42..34,420.32 rows=1 width=48) (actual time=97.930..97.931 rows=0 loops=3)

13. 97.928 97.928 ↓ 0.0 0 3

Parallel Seq Scan on kx_workreport_report kx (cost=0.00..34,411.88 rows=1 width=16) (actual time=97.928..97.928 rows=0 loops=3)

  • Filter: ((tn_saleareaid = ANY ('{1131441229322653696,1131497856176361472}'::bigint[])) AND (platstatus = 1) AND (to_char(createtime, 'yyyy-mm'::text) = '2019-11'::text))
  • Rows Removed by Filter: 120830
14. 0.000 0.000 ↓ 0.0 0

Index Scan using pl_orgstruct_orgstructid on pl_orgstruct a (cost=0.42..8.44 rows=1 width=32) (never executed)

  • Index Cond: (orgstructid = kx.createop)
  • Filter: (platstatus = 1)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_pl_orgstruct_orgstructid on pl_orgstruct org1 (cost=0.42..5.18 rows=1 width=91) (never executed)

  • Index Cond: (orgstructid = a.orgstructid)
  • Filter: (platstatus = 1)
16. 0.000 0.000 ↓ 0.0 0

Index Scan using pl_userinfo_pkey on pl_userinfo pu (cost=0.29..4.63 rows=1 width=19) (never executed)

  • Index Cond: (userinfoid = a.userinfoid)
  • Filter: (platstatus = 1)
17. 0.000 0.000 ↓ 0.0 0

Seq Scan on pl_position pl (cost=0.00..1.58 rows=31 width=23) (never executed)

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

Index Scan using ix_pl_orgstruct_orgstructid on pl_orgstruct org2 (cost=0.42..5.18 rows=1 width=24) (never executed)

  • Index Cond: (orgstructid = org1.parentorgstructid)
  • Filter: (platstatus = 1)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_pl_orgstruct_orgstructid on pl_orgstruct org3 (cost=0.42..5.18 rows=1 width=32) (never executed)

  • Index Cond: (orgstructid = org2.parentorgstructid)
  • Filter: (platstatus = 1)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_pl_orgstruct_orgstructid on pl_orgstruct org4 (cost=0.42..5.18 rows=1 width=32) (never executed)

  • Index Cond: (orgstructid = org3.parentorgstructid)
  • Filter: (platstatus = 1)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_pl_orgstruct_orgstructid on pl_orgstruct org5 (cost=0.42..5.18 rows=1 width=32) (never executed)

  • Index Cond: (orgstructid = org4.parentorgstructid)
  • Filter: (platstatus = 1)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_pl_orgstruct_orgstructid on pl_orgstruct org6 (cost=0.42..5.18 rows=1 width=24) (never executed)

  • Index Cond: (orgstructid = org5.parentorgstructid)
  • Filter: (platstatus = 1)
23.          

SubPlan (for Nested Loop)

24. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=36,830.48..36,830.49 rows=1 width=8) (never executed)

25. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t (cost=0.00..36,830.18 rows=121 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1))
26. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=35,923.61..35,923.62 rows=1 width=8) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t_1 (cost=0.00..35,923.31 rows=121 width=0) (never executed)

  • Filter: (createop = a.orgstructid)
28. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t1 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '01'::text))
29. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
30. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t1_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '01'::text))
31. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t2 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '02'::text))
32. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
33. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t2_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '02'::text))
34. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t3 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '03'::text))
35. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
36. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t3_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '03'::text))
37. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t4 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '04'::text))
38. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
39. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t4_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '04'::text))
40. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t5 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '05'::text))
41. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
42. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t5_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '05'::text))
43. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t6 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '06'::text))
44. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
45. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t6_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '06'::text))
46. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t7 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '07'::text))
47. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
48. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t7_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '07'::text))
49. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t8 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '08'::text))
50. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
51. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t8_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '08'::text))
52. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t9 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '09'::text))
53. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
54. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t9_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '09'::text))
55. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t10 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '10'::text))
56. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
57. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t10_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '10'::text))
58. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t11 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '11'::text))
59. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
60. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t11_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '11'::text))
61. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t12 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '12'::text))
62. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
63. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t12_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '12'::text))
64. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t13 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '13'::text))
65. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
66. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t13_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '13'::text))
67. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t14 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '14'::text))
68. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
69. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t14_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '14'::text))
70. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t15 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '15'::text))
71. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
72. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t15_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '15'::text))
73. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t16 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '16'::text))
74. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
75. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t16_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '16'::text))
76. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t17 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '17'::text))
77. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
78. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t17_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '17'::text))
79. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t18 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '18'::text))
80. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
81. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t18_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '18'::text))
82. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t19 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '19'::text))
83. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
84. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t19_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '19'::text))
85. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t20 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '20'::text))
86. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
87. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t20_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '20'::text))
88. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t21 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '21'::text))
89. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
90. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t21_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '21'::text))
91. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t22 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '22'::text))
92. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
93. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t22_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '22'::text))
94. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t23 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '23'::text))
95. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
96. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t23_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '23'::text))
97. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t24 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '24'::text))
98. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
99. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t24_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '24'::text))
100. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t25 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '25'::text))
101. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
102. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t25_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '25'::text))
103. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t26 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '26'::text))
104. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
105. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t26_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '26'::text))
106. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t27 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '27'::text))
107. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
108. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t27_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '27'::text))
109. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t28 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '28'::text))
110. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
111. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t28_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '28'::text))
112. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t29 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '29'::text))
113. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
114. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t29_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '29'::text))
115. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t30 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '30'::text))
116. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
117. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t30_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '30'::text))
118. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_workreport_report t31 (cost=0.00..38,643.90 rows=1 width=0) (never executed)

  • Filter: ((createop = a.orgstructid) AND (platstatus = 1) AND (to_char(createtime, 'dd'::text) = '31'::text))
119. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..35,215.42 rows=1,814 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
120. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on kx_workreport_report t31_1 (cost=0.00..34,034.02 rows=756 width=8) (never executed)

  • Filter: ((platstatus = 1) AND (to_char(createtime, 'dd'::text) = '31'::text))
Planning time : 502.952 ms
Execution time : 113.808 ms