explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oVZa

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 104.067 ↓ 0.0 0 1

Group (cost=1,306,123.07..2,576,787.70 rows=1 width=1,261) (actual time=104.067..104.067 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 104.067 ↓ 0.0 0 1

Sort (cost=1,306,123.07..1,306,123.07 rows=1 width=1,261) (actual time=104.066..104.067 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 103.995 ↓ 0.0 0 1

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

4. 0.000 103.994 ↓ 0.0 0 1

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

5. 0.001 103.994 ↓ 0.0 0 1

Nested Loop (cost=1,002.40..35,448.17 rows=1 width=181) (actual time=103.993..103.994 rows=0 loops=1)

6. 0.000 103.993 ↓ 0.0 0 1

Nested Loop (cost=1,001.98..35,442.99 rows=1 width=165) (actual time=103.993..103.993 rows=0 loops=1)

7. 14.505 110.599 ↓ 0.0 0 1

Gather (cost=1,001.55..35,437.81 rows=1 width=149) (actual time=103.993..110.599 rows=0 loops=1)

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

Nested Loop (cost=1.55..34,437.71 rows=1 width=149) (actual time=96.094..96.094 rows=0 loops=3)

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

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

10. 0.001 96.092 ↓ 0.0 0 3

Nested Loop (cost=1.13..34,430.63 rows=1 width=126) (actual time=96.092..96.092 rows=0 loops=3)

11. 0.000 96.091 ↓ 0.0 0 3

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

12. 0.002 96.091 ↓ 0.0 0 3

Nested Loop (cost=0.42..34,420.82 rows=1 width=48) (actual time=96.091..96.091 rows=0 loops=3)

13. 96.089 96.089 ↓ 0.0 0 3

Parallel Seq Scan on kx_workreport_report kx (cost=0.00..34,412.38 rows=1 width=16) (actual time=96.088..96.089 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: 120838
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,829.78..36,829.79 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,829.47 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.36..35,923.38 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.06 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 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,642.30 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,216.00 rows=1,813 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.70 rows=755 width=8) (never executed)

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