explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5LVy : Query

Settings
# exclusive inclusive rows x rows loops node
1. 109.044 202,247.326 ↓ 3.8 27,309 1

Sort (cost=509,806.88..509,824.75 rows=7,148 width=4,940) (actual time=202,219.563..202,247.326 rows=27,309 loops=1)

  • Sort Key: "*SELECT* 1".value0, "*SELECT* 1".dateacct
  • Sort Method: external merge Disk: 10736kB
  • Buffers: shared hit=1153351 dirtied=3, temp read=4117 written=4135
  • Functions: 197
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 34.505 ms, Inlining 25.053 ms, Optimization 2428.923 ms, Emission 1486.890 ms, Total 3975.370 ms
2. 34.367 202,138.282 ↓ 3.8 27,309 1

Unique (cost=490,700.16..491,575.79 rows=7,148 width=4,940) (actual time=202,082.849..202,138.282 rows=27,309 loops=1)

  • Buffers: shared hit=1153351 dirtied=3, temp read=2059 written=2068
3. 165.162 202,103.915 ↓ 3.8 27,309 1

Sort (cost=490,700.16..490,718.03 rows=7,148 width=4,940) (actual time=202,082.846..202,103.915 rows=27,309 loops=1)

  • Sort Key: "*SELECT* 1".fact_acct_id, "*SELECT* 1".saldosa, ((0)::numeric), ((0)::numeric), "*SELECT* 1".saldof, "*SELECT* 1".documentno, "*SELECT* 1".record_id, "*SELECT* 1".c_period_id, "*SELECT* 1".name1, "*SELECT* 1".dateacct, "*SELECT* 1".amtacctdr, "*SELECT* 1".amtacctcr, "*SELECT* 1".saldos, "*SELECT* 1".description1, "*SELECT* 1".account_id, "*SELECT* 1".gr1, "*SELECT* 1".name9, "*SELECT* 1".gr2, "*SELECT* 1".name10, "*SELECT* 1".gr3, "*SELECT* 1".name11, "*SELECT* 1".gr4, "*SELECT* 1".name12, "*SELECT* 1".value0, "*SELECT* 1".name13, "*SELECT* 1".description2, "*SELECT* 1".c_bpartner_id, "*SELECT* 1".value1, "*SELECT* 1".name2, "*SELECT* 1".ad_table_id, "*SELECT* 1".tablename, "*SELECT* 1".name3, "*SELECT* 1".m_product_id, "*SELECT* 1".value2, "*SELECT* 1".name4, "*SELECT* 1".qty, "*SELECT* 1".c_project_id, "*SELECT* 1".value3, "*SELECT* 1".name5, "*SELECT* 1".c_projecttask_id, "*SELECT* 1".name6, "*SELECT* 1".user1_id, "*SELECT* 1".value4, "*SELECT* 1".name7, "*SELECT* 1".user2_id, "*SELECT* 1".value5, "*SELECT* 1".name8, "*SELECT* 1".empre99
  • Sort Method: external merge Disk: 10736kB
  • Buffers: shared hit=1153351 dirtied=3, temp read=2059 written=2068
4. 13.554 201,938.753 ↓ 3.8 27,309 1

Append (cost=983.59..472,469.07 rows=7,148 width=4,940) (actual time=3,963.042..201,938.753 rows=27,309 loops=1)

  • Buffers: shared hit=1153351 dirtied=3
5. 8.842 45,688.054 ↓ 1.1 7,847 1

Subquery Scan on *SELECT* 1 (cost=983.59..246,534.57 rows=7,042 width=1,328) (actual time=3,963.041..45,688.054 rows=7,847 loops=1)

  • Buffers: shared hit=339371 dirtied=3
6. 40,039.794 45,679.212 ↓ 1.1 7,847 1

Hash Left Join (cost=983.59..246,428.94 rows=7,042 width=1,272) (actual time=3,963.037..45,679.212 rows=7,847 loops=1)

  • Hash Cond: (f.c_projecttask_id = cpt.c_projecttask_id)
  • Buffers: shared hit=339371 dirtied=3
7. 7.090 4,666.342 ↓ 1.1 7,847 1

Hash Left Join (cost=979.36..173,803.21 rows=7,042 width=505) (actual time=3,955.227..4,666.342 rows=7,847 loops=1)

  • Hash Cond: (f.c_project_id = cp.c_project_id)
  • Buffers: shared hit=83446 dirtied=3
8. 14.241 4,657.892 ↓ 1.1 7,847 1

Nested Loop Left Join (cost=817.24..173,622.61 rows=7,042 width=488) (actual time=3,953.855..4,657.892 rows=7,847 loops=1)

  • Buffers: shared hit=83349 dirtied=3
9. 5.585 4,620.110 ↓ 1.1 7,847 1

Hash Left Join (cost=816.96..171,469.77 rows=7,042 width=449) (actual time=3,953.848..4,620.110 rows=7,847 loops=1)

  • Hash Cond: (f.user2_id = ce2.c_elementvalue_id)
  • Buffers: shared hit=70503 dirtied=3
10. 7.052 4,611.841 ↓ 1.1 7,847 1

Hash Left Join (cost=549.14..171,183.46 rows=7,042 width=415) (actual time=3,951.147..4,611.841 rows=7,847 loops=1)

  • Hash Cond: (f.user1_id = ce1.c_elementvalue_id)
  • Buffers: shared hit=70372 dirtied=3
11. 13.520 4,602.076 ↓ 1.1 7,847 1

Hash Left Join (cost=281.32..170,897.15 rows=7,042 width=381) (actual time=3,948.416..4,602.076 rows=7,847 loops=1)

  • Hash Cond: (f.ad_table_id = ad.ad_table_id)
  • Buffers: shared hit=70241 dirtied=3
12. 14.276 4,587.912 ↓ 1.1 7,847 1

Nested Loop Left Join (cost=195.70..170,792.98 rows=7,042 width=348) (actual time=3,945.675..4,587.912 rows=7,847 loops=1)

  • Buffers: shared hit=70184 dirtied=3
13. 11.543 4,542.248 ↓ 1.1 7,847 1

Hash Left Join (cost=195.41..168,271.54 rows=7,042 width=307) (actual time=3,945.656..4,542.248 rows=7,847 loops=1)

  • Hash Cond: (f.c_period_id = per.c_period_id)
  • Buffers: shared hit=54143 dirtied=3
14. 4.733 4,530.355 ↓ 1.1 7,847 1

Nested Loop (cost=156.81..168,214.37 rows=7,042 width=299) (actual time=3,943.387..4,530.355 rows=7,847 loops=1)

  • Buffers: shared hit=54126 dirtied=3
15. 3,942.779 3,942.779 ↑ 1.0 1 1

Seq Scan on ad_client cl (cost=0.00..1.07 rows=1 width=114) (actual time=3,942.775..3,942.779 rows=1 loops=1)

  • Filter: (ad_client_id = '1000001'::numeric)
  • Rows Removed by Filter: 5
  • Buffers: shared hit=1
16. 23.878 582.843 ↓ 1.1 7,847 1

Hash Join (cost=156.81..168,142.88 rows=7,042 width=207) (actual time=0.606..582.843 rows=7,847 loops=1)

  • Hash Cond: (f.account_id = ce.c_elementvalue_id)
  • Buffers: shared hit=54125 dirtied=3
17. 558.475 558.475 ↑ 8.6 7,847 1

Index Scan using fact_acct_table_record on fact_acct f (cost=0.43..167,808.52 rows=67,753 width=169) (actual time=0.101..558.475 rows=7,847 loops=1)

  • Index Cond: (ad_client_id = '1000001'::numeric)
  • Filter: ((isactive = 'Y'::bpchar) AND (trunc((dateacct)::timestamp with time zone) < to_date('2019-01-01'::text, 'YYYY-MM-DD'::text)))
  • Rows Removed by Filter: 202701
  • Buffers: shared hit=54084 dirtied=3
18. 0.175 0.490 ↓ 1.0 633 1

Hash (cost=148.48..148.48 rows=632 width=44) (actual time=0.489..0.490 rows=633 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 59kB
  • Buffers: shared hit=41
19. 0.192 0.315 ↓ 1.0 633 1

Bi tmap Heap Scan on c_elementvalue ce (cost=9.58..148.48 rows=632 width=44) (actual time=0.135..0.315 rows=633 loops=1)

  • Recheck Cond: (c_element_id = '1000001'::numeric)
  • Heap Blocks: exact=20
  • Buffers: shared hit=41
20. 0.123 0.123 ↓ 1.8 1,153 1

Bitmap Index Scan on c_elementvalue_value (cost=0.00..9.42 rows=632 width=0) (actual time=0.123..0.123 rows=1,153 loops=1)

  • Index Cond: (c_element_id = '1000001'::numeric)
  • Buffers: shared hit=8
21. 0.181 0.350 ↑ 1.2 770 1

Hash (cost=26.60..26.60 rows=960 width=14) (actual time=0.350..0.350 rows=770 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 44kB
  • Buffers: shared hit=17
22. 0.169 0.169 ↑ 1.2 770 1

Seq Scan on c_period per (cost=0.00..26.60 rows=960 width=14) (actual time=0.013..0.169 rows=770 loops=1)

  • Buffers: shared hit=17
23. 31.388 31.388 ↑ 1.0 1 7,847

Index Scan using c_bpartner_pkey on c_bpartner bp (cost=0.29..0.36 rows=1 width=47) (actual time=0.004..0.004 rows=1 loops=7,847)

  • Index Cond: (c_bpartner_id = f.c_bpartner_id)
  • Buffers: shared hit=16041
24. 0.298 0.644 ↓ 1.0 1,275 1

Hash (cost=69.72..69.72 rows=1,272 width=38) (actual time=0.644..0.644 rows=1,275 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 106kB
  • Buffers: shared hit=57
25. 0.346 0.346 ↓ 1.0 1,275 1

Seq Scan on ad_table ad (cost=0.00..69.72 rows=1,272 width=38) (actual time=0.009..0.346 rows=1,275 loops=1)

  • Buffers: shared hit=57
26. 1.489 2.713 ↑ 1.0 6,081 1

Hash (cost=191.81..191.81 rows=6,081 width=40) (actual time=2.713..2.713 rows=6,081 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 505kB
  • Buffers: shared hit=131
27. 1.224 1.224 ↑ 1.0 6,081 1

Seq Scan on c_elementvalue ce1 (cost=0.00..191.81 rows=6,081 width=40) (actual time=0.009..1.224 rows=6,081 loops=1)

  • Buffers: shared hit=131
28. 1.625 2.684 ↑ 1.0 6,081 1

Hash (cost=191.81..191.81 rows=6,081 width=40) (actual time=2.684..2.684 rows=6,081 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 505kB
  • Buffers: shared hit=131
29. 1.059 1.059 ↑ 1.0 6,081 1

Seq Scan on c_elementvalue ce2 (cost=0.00..191.81 rows=6,081 width=40) (actual time=0.019..1.059 rows=6,081 loops=1)

  • Buffers: shared hit=131
30. 23.541 23.541 ↑ 1.0 1 7,847

Index Scan using m_product_pkey on m_product mp (cost=0.28..0.31 rows=1 width=45) (actual time=0.003..0.003 rows=1 loops=7,847)

  • Index Cond: (m_product_id = f.m_product_id)
  • Buffers: shared hit=12846
31. 0.691 1.360 ↑ 1.0 2,762 1

Hash (cost=125.94..125.94 rows=2,894 width=23) (actual time=1.360..1.360 rows=2,762 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 186kB
  • Buffers: shared hit=97
32. 0.669 0.669 ↑ 1.0 2,762 1

Seq Scan on c_project cp (cost=0.00..125.94 rows=2,894 width=23) (actual time=0.009..0.669 rows=2,762 loops=1)

  • Buffers: shared hit=97
33. 0.023 0.048 ↑ 1.0 99 1

Hash (cost=2.99..2.99 rows=99 width=23) (actual time=0.048..0.048 rows=99 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
  • Buffers: shared hit=2
34. 0.025 0.025 ↑ 1.0 99 1

Seq Scan on c_projecttask cpt (cost=0.00..2.99 rows=99 width=23) (actual time=0.008..0.025 rows=99 loops=1)

  • Buffers: shared hit=2
35.          

SubPlan (for Hash Left Join)

36. 102.011 102.011 ↑ 1.0 1 7,847

Index Scan using c_elementvalue_description on c_elementvalue ev (cost=0.28..2.51 rows=1 width=25) (actual time=0.009..0.013 rows=1 loops=7,847)

  • Index Cond: ((description)::text = '1'::text)
  • Filter: ((c_element_id = '1000001'::numeric) AND ("substring"((value)::text, 1, 2) = "substring"((ce.value)::text, 1, 2)))
  • Rows Removed by Filter: 7
  • Buffers: shared hit=23541
37. 125.552 125.552 ↑ 1.0 1 7,847

Index Scan using c_elementvalue_description on c_elementvalue ev_1 (cost=0.28..2.51 rows=1 width=25) (actual time=0.010..0.016 rows=1 loops=7,847)

  • Index Cond: ((description)::text = '2'::text)
  • Filter: ((c_element_id = '1000001'::numeric) AND ("substring"((value)::text, 1, 4) = "substring"((ce.value)::text, 1, 4)))
  • Rows Removed by Filter: 16
  • Buffers: shared hit=54929
38. 227.563 227.563 ↑ 1.0 1 7,847

Index Scan using c_elementvalue_description on c_elementvalue ev_2 (cost=0.28..2.51 rows=1 width=25) (actual time=0.009..0.029 rows=1 loops=7,847)

  • Index Cond: ((description)::text = '3'::text)
  • Filter: ((c_element_id = '1000001'::numeric) AND ("substring"((value)::text, 1, 7) = "substring"((ce.value)::text, 1, 7)))
  • Rows Removed by Filter: 42
  • Buffers: shared hit=47082
39. 517.902 517.902 ↑ 1.0 1 7,847

Index Scan using c_elementvalue_description on c_elementvalue ev_3 (cost=0.28..2.51 rows=1 width=25) (actual time=0.036..0.066 rows=1 loops=7,847)

  • Index Cond: ((description)::text = '4'::text)
  • Filter: ((c_element_id = '1000001'::numeric) AND ("substring"((value)::text, 1, 10) = "substring"((ce.value)::text, 1, 10)))
  • Rows Removed by Filter: 100
  • Buffers: shared hit=94164
40. 23.491 156,237.145 ↓ 183.6 19,462 1

Subquery Scan on *SELECT* 2 (cost=2.12..225,898.76 rows=106 width=1,272) (actual time=13.196..156,237.145 rows=19,462 loops=1)

  • Buffers: shared hit=813980
41. 146,573.689 156,213.654 ↓ 183.6 19,462 1

Nested Loop Left Join (cost=2.12..225,897.43 rows=106 width=1,244) (actual time=13.191..156,213.654 rows=19,462 loops=1)

  • Join Filter: (f_1.c_projecttask_id = cpt_1.c_projecttask_id)
  • Rows Removed by Join Filter: 1926738
  • Buffers: shared hit=813980
42. 30.849 7,090.443 ↓ 183.6 19,462 1

Nested Loop Left Join (cost=2.12..224,644.19 rows=106 width=505) (actual time=5.318..7,090.443 rows=19,462 loops=1)

  • Buffers: shared hit=181369
43. 42.184 7,059.594 ↓ 183.6 19,462 1

Nested Loop Left Join (cost=1.84..224,600.38 rows=106 width=488) (actual time=5.310..7,059.594 rows=19,462 loops=1)

  • Buffers: shared hit=180910
44. 2,006.042 6,978.486 ↓ 183.6 19,462 1

Nested Loop Left Join (cost=1.56..224,528.18 rows=106 width=449) (actual time=5.301..6,978.486 rows=19,462 loops=1)

  • Join Filter: (f_1.c_period_id = per_1.c_period_id)
  • Rows Removed by Join Filter: 13973716
  • Buffers: shared hit=156019
45. 35.062 4,155.040 ↓ 183.6 19,462 1

Nested Loop Left Join (cost=1.56..222,972.78 rows=106 width=441) (actual time=4.836..4,155.040 rows=19,462 loops=1)

  • Buffers: shared hit=156006
46. 29.605 4,042.130 ↓ 183.6 19,462 1

Nested Loop Left Join (cost=1.28..222,818.26 rows=106 width=400) (actual time=2.528..4,042.130 rows=19,462 loops=1)

  • Buffers: shared hit=112524
47. 39.824 4,012.525 ↓ 183.6 19,462 1

Nested Loop Left Join (cost=0.99..222,769.02 rows=106 width=366) (actual time=2.520..4,012.525 rows=19,462 loops=1)

  • Buffers: shared hit=112524
48. 12.179 3,972.701 ↓ 183.6 19,462 1

Nested Loop (cost=0.71..222,719.77 rows=106 width=332) (actual time=2.512..3,972.701 rows=19,462 loops=1)

  • Buffers: shared hit=112524
49. 0.078 0.078 ↑ 1.0 1 1

Seq Scan on ad_client cl_1 (cost=0.00..1.07 rows=1 width=114) (actual time=0.075..0.078 rows=1 loops=1)

  • Filter: (ad_client_id = '1000001'::numeric)
  • Rows Removed by Filter: 5
  • Buffers: shared hit=1
50. 1,987.300 3,960.444 ↓ 183.6 19,462 1

Nested Loop Left Join (cost=0.71..222,717.64 rows=106 width=240) (actual time=2.433..3,960.444 rows=19,462 loops=1)

  • Join Filter: (f_1.ad_table_id = ad_1.ad_table_id)
  • Rows Removed by Join Filter: 13513863
  • Buffers: shared hit=112523
51. 76.218 1,175.202 ↓ 183.6 19,462 1

Nested Loop (cost=0.71..220,622.26 rows=106 width=207) (actual time=1.148..1,175.202 rows=19,462 loops=1)

  • Buffers: shared hit=112468
52. 1,001.674 1,001.674 ↓ 19.2 19,462 1

Index Scan using fact_acct_table_record on fact_acct f_1 (cost=0.43..220,147.72 rows=1,016 width=169) (actual time=1.126..1,001.674 rows=19,462 loops=1)

  • Index Cond: (ad_client_id = '1000001'::numeric)
  • Filter: ((isactive = 'Y'::bpchar) AND (trunc((dateacct)::timestamp with time zone) >= to_date('2019-01-01'::text, 'YYYY-MM-DD'::text)) AND (trunc((dateacct)::timestamp with time zone) <= to_date('2019-01-31'::text, 'YYYY-MM-DD'::text)))
  • Rows Removed by Filter: 191086
  • Buffers: shared hit=54082
53. 97.310 97.310 ↑ 1.0 1 19,462

Index Scan using c_elementvalue_pkey on c_elementvalue ce_1 (cost=0.28..0.47 rows=1 width=44) (actual time=0.005..0.005 rows=1 loops=19,462)

  • Index Cond: (c_elementvalue_id = f_1.account_id)
  • Filter: (c_element_id = '1000001'::numeric)
  • Buffers: shared hit=58386
54. 797.592 797.942 ↑ 1.8 695 19,462

Materialize (cost=0.00..76.08 rows=1,272 width=38) (actual time=0.000..0.041 rows=695 loops=19,462)

  • Buffers: shared hit=55
55. 0.350 0.350 ↑ 1.0 1,239 1

Seq Scan on ad_table ad_1 (cost=0.00..69.72 rows=1,272 width=38) (actual time=0.008..0.350 rows=1,239 loops=1)

  • Buffers: shared hit=55
56. 0.000 0.000 ↓ 0.0 0 19,462

Index Scan using c_elementvalue_pkey on c_elementvalue ce1_1 (cost=0.28..0.46 rows=1 width=40) (actual time=0.000..0.000 rows=0 loops=19,462)

  • Index Cond: (c_elementvalue_id = f_1.user1_id)
57. 0.000 0.000 ↓ 0.0 0 19,462

Index Scan using c_elementvalue_pkey on c_elementvalue ce2_1 (cost=0.28..0.46 rows=1 width=40) (actual time=0.000..0.000 rows=0 loops=19,462)

  • Index Cond: (c_elementvalue_id = f_1.user2_id)
58. 77.848 77.848 ↑ 1.0 1 19,462

Index Scan using c_bpartner_pkey on c_bpartner bp_1 (cost=0.29..1.46 rows=1 width=47) (actual time=0.004..0.004 rows=1 loops=19,462)

  • Index Cond: (c_bpartner_id = f_1.c_bpartner_id)
  • Buffers: shared hit=43482
59. 817.236 817.404 ↑ 1.3 719 19,462

Materialize (cost=0.00..31.40 rows=960 width=14) (actual time=0.000..0.042 rows=719 loops=19,462)

  • Buffers: shared hit=13
60. 0.168 0.168 ↑ 1.3 719 1

Seq Scan on c_period per_1 (cost=0.00..26.60 rows=960 width=14) (actual time=0.013..0.168 rows=719 loops=1)

  • Buffers: shared hit=13
61. 38.924 38.924 ↓ 0.0 0 19,462

Index Scan using m_product_pkey on m_product mp_1 (cost=0.28..0.68 rows=1 width=45) (actual time=0.002..0.002 rows=0 loops=19,462)

  • Index Cond: (m_product_id = f_1.m_product_id)
  • Buffers: shared hit=24891
62. 0.000 0.000 ↓ 0.0 0 19,462

Index Scan using c_project_pkey on c_project cp_1 (cost=0.28..0.41 rows=1 width=23) (actual time=0.000..0.000 rows=0 loops=19,462)

  • Index Cond: (c_project_id = f_1.c_project_id)
  • Buffers: shared hit=459
63. 116.731 116.772 ↑ 1.0 99 19,462

Materialize (cost=0.00..3.49 rows=99 width=23) (actual time=0.000..0.006 rows=99 loops=19,462)

  • Buffers: shared hit=2
64. 0.041 0.041 ↑ 1.0 99 1

Seq Scan on c_projecttask cpt_1 (cost=0.00..2.99 rows=99 width=23) (actual time=0.025..0.041 rows=99 loops=1)

  • Buffers: shared hit=2
65.          

SubPlan (for Nested Loop Left Join)

66. 253.006 253.006 ↑ 1.0 1 19,462

Index Scan using c_elementvalue_description on c_elementvalue ev_4 (cost=0.28..2.51 rows=1 width=25) (actual time=0.010..0.013 rows=1 loops=19,462)

  • Index Cond: ((description)::text = '1'::text)
  • Filter: ((c_element_id = '1000001'::numeric) AND ("substring"((value)::text, 1, 2) = "substring"((ce_1.value)::text, 1, 2)))
  • Rows Removed by Filter: 7
  • Buffers: shared hit=58386
67. 330.854 330.854 ↑ 1.0 1 19,462

Index Scan using c_elementvalue_description on c_elementvalue ev_5 (cost=0.28..2.51 rows=1 width=25) (actual time=0.010..0.017 rows=1 loops=19,462)

  • Index Cond: ((description)::text = '2'::text)
  • Filter: ((c_element_id = '1000001'::numeric) AND ("substring"((value)::text, 1, 4) = "substring"((ce_1.value)::text, 1, 4)))
  • Rows Removed by Filter: 16
  • Buffers: shared hit=136234
68. 564.398 564.398 ↑ 1.0 1 19,462

Index Scan using c_elementvalue_description on c_elementvalue ev_6 (cost=0.28..2.51 rows=1 width=25) (actual time=0.011..0.029 rows=1 loops=19,462)

  • Index Cond: ((description)::text = '3'::text)
  • Filter: ((c_element_id = '1000001'::numeric) AND ("substring"((value)::text, 1, 7) = "substring"((ce_1.value)::text, 1, 7)))
  • Rows Removed by Filter: 42
  • Buffers: shared hit=116772
69. 1,284.492 1,284.492 ↑ 1.0 1 19,462

Index Scan using c_elementvalue_description on c_elementvalue ev_7 (cost=0.28..2.51 rows=1 width=25) (actual time=0.027..0.066 rows=1 loops=19,462)

  • Index Cond: ((description)::text = '4'::text)
  • Filter: ((c_element_id = '1000001'::numeric) AND ("substring"((value)::text, 1, 10) = "substring"((ce_1.value)::text, 1, 10)))
  • Rows Removed by Filter: 100
  • Buffers: shared hit=233544
Planning time : 11.347 ms