explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7m9o

Settings
# exclusive inclusive rows x rows loops node
1. 71.657 3,740.902 ↓ 1.1 141,859 1

Group (cost=300,264.21..335,096.67 rows=133,971 width=299) (actual time=3,641.143..3,740.902 rows=141,859 loops=1)

  • Group Key: billing_invoice.id, billing_invoice.created, billing_invoice.backend, billing_invoice.payed, billing_invoice.cancelled, billing_invoice.is_proforma, billing_product.id, billing_product.title, billing_product.credits, billing_invoiceproducts.qty, (CASE WHEN ((accounts_sellervat.number IS NOT NULL) AND (accounts_sellervat.country_id <> 74)) THEN CASE WHEN (billing_product.id = ANY ('{50,138,230}'::integer[])) THEN ((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) ELSE (((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) / 1.24) END ELSE CASE WHEN (billing_product.id = ANY ('{50,138,230}'::integer[])) THEN (((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) * 1.24) ELSE ((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) END END), billing_invoice.user_id, (CASE WHEN (billing_invoice.created_by_id IS NULL) THEN billing_invoice.user_id ELSE billing_invoice.created_by_id END), (CASE WHEN (sales_reps.id IS NOT NULL) THEN concat(sales_reps.first_name, ' ', sales_reps.last_name) ELSE NULL::text END), (CASE WHEN (billing_unattendedregistration_invoices.invoice_id IS NOT NULL) THEN 1 ELSE 0 END), billing_invoice.confirmed, billing_invoice.uid, paid_invoices.created, job_ids.job_ids, (CASE WHEN ((accounts_sellervat.number IS NOT NULL) AND (accounts_sellervat.country_id <> 74)) THEN CASE WHEN (billing_product.id = ANY ('{50,138,230}'::integer[])) THEN ((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) ELSE (((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) / 1.24) END ELSE CASE WHEN (billing_product.id = ANY ('{50,138,230}'::integer[])) THEN ((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) ELSE (((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) / 1.24) END END), billing_product.bids, c.category_id
2. 197.853 3,669.245 ↓ 1.1 141,859 1

Sort (cost=300,264.21..300,599.14 rows=133,971 width=258) (actual time=3,641.136..3,669.245 rows=141,859 loops=1)

  • Sort Key: billing_invoice.id, billing_invoice.created, billing_invoice.backend, billing_invoice.payed, billing_invoice.cancelled, billing_invoice.is_proforma, billing_product.id, billing_product.title, billing_product.credits, billing_invoiceproducts.qty, (CASE WHEN ((accounts_sellervat.number IS NOT NULL) AND (accounts_sellervat.country_id <> 74)) THEN CASE WHEN (billing_product.id = ANY ('{50,138,230}'::integer[])) THEN ((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) ELSE (((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) / 1.24) END ELSE CASE WHEN (billing_product.id = ANY ('{50,138,230}'::integer[])) THEN (((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) * 1.24) ELSE ((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) END END), billing_invoice.user_id, (CASE WHEN (billing_invoice.created_by_id IS NULL) THEN billing_invoice.user_id ELSE billing_invoice.created_by_id END), (CASE WHEN (sales_reps.id IS NOT NULL) THEN concat(sales_reps.first_name, ' ', sales_reps.last_name) ELSE NULL::text END), (CASE WHEN (billing_unattendedregistration_invoices.invoice_id IS NOT NULL) THEN 1 ELSE 0 END), billing_invoice.confirmed, billing_invoice.uid, paid_invoices.created, job_ids.job_ids, (CASE WHEN ((accounts_sellervat.number IS NOT NULL) AND (accounts_sellervat.country_id <> 74)) THEN CASE WHEN (billing_product.id = ANY ('{50,138,230}'::integer[])) THEN ((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) ELSE (((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) / 1.24) END ELSE CASE WHEN (billing_product.id = ANY ('{50,138,230}'::integer[])) THEN ((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) ELSE (((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) / 1.24) END END), billing_product.bids, c.category_id
  • Sort Method: external merge Disk: 25,664kB
3. 263.098 3,471.392 ↓ 1.1 141,859 1

Hash Left Join (cost=244,513.40..279,200.03 rows=133,971 width=258) (actual time=2,601.547..3,471.392 rows=141,859 loops=1)

  • Hash Cond: (billing_invoice.id = c.invoice_id)
4. 73.058 2,315.408 ↓ 1.1 141,859 1

Hash Left Join (cost=187,634.31..207,415.50 rows=133,971 width=191) (actual time=1,708.693..2,315.408 rows=141,859 loops=1)

  • Hash Cond: (billing_invoice.id = billing_invoice_1.id)
5. 67.292 2,141.583 ↓ 1.1 141,859 1

Hash Left Join (cost=179,892.73..198,539.05 rows=133,971 width=183) (actual time=1,607.258..2,141.583 rows=141,859 loops=1)

  • Hash Cond: (billing_invoice.id = job_ids.invoice_id)
6. 58.194 817.916 ↓ 1.1 141,859 1

Hash Left Join (cost=51,836.16..70,130.80 rows=133,971 width=151) (actual time=350.987..817.916 rows=141,859 loops=1)

  • Hash Cond: (accounts_duser.id = accounts_sellervat.user_id)
7. 60.330 757.050 ↓ 1.1 141,859 1

Hash Left Join (cost=51,546.21..69,308.75 rows=133,971 width=141) (actual time=348.255..757.050 rows=141,859 loops=1)

  • Hash Cond: (billing_invoice.user_id = accounts_duser.id)
8. 42.614 542.768 ↓ 1.1 141,859 1

Hash Left Join (cost=28,645.78..46,056.65 rows=133,971 width=137) (actual time=194.013..542.768 rows=141,859 loops=1)

  • Hash Cond: (billing_invoice.id = billing_unattendedregistration_invoices.invoice_id)
9. 42.935 499.643 ↓ 1.1 141,859 1

Hash Left Join (cost=28,579.64..45,466.16 rows=133,971 width=133) (actual time=193.492..499.643 rows=141,859 loops=1)

  • Hash Cond: (billing_invoiceproducts.product_id = billing_product.id)
10. 84.321 456.588 ↓ 1.1 141,859 1

Hash Left Join (cost=28,565.97..45,094.89 rows=133,971 width=79) (actual time=193.354..456.588 rows=141,859 loops=1)

  • Hash Cond: (billing_invoice.created_by_id = sales_reps.id)
11. 56.130 179.293 ↓ 1.1 141,859 1

Merge Left Join (cost=0.89..11,003.14 rows=133,971 width=46) (actual time=0.024..179.293 rows=141,859 loops=1)

  • Merge Cond: (billing_invoice.id = billing_invoiceproducts.invoice_id)
12. 77.344 77.344 ↓ 1.0 135,695 1

Index Scan using billing_invoice_idx on billing_invoice (cost=0.42..5,681.31 rows=133,971 width=38) (actual time=0.013..77.344 rows=135,695 loops=1)

  • Filter: (((backend)::text <> 'manual'::text) OR (((backend)::text = 'manual'::text) AND (created_by_id IS NOT NULL)))
  • Rows Removed by Filter: 8,315
13. 45.819 45.819 ↑ 1.0 140,994 1

Index Scan using billing_invoiceproducts_invoice_id_idx on billing_invoiceproducts (cost=0.42..3,323.69 rows=141,126 width=12) (actual time=0.009..45.819 rows=140,994 loops=1)

14. 90.245 192.974 ↑ 1.0 355,658 1

Hash (cost=21,236.59..21,236.59 rows=360,759 width=33) (actual time=192.974..192.974 rows=355,658 loops=1)

  • Buckets: 262,144 Batches: 4 Memory Usage: 7,841kB
15. 102.729 102.729 ↑ 1.0 355,658 1

Seq Scan on accounts_duser sales_reps (cost=0.00..21,236.59 rows=360,759 width=33) (actual time=0.011..102.729 rows=355,658 loops=1)

16. 0.042 0.120 ↑ 1.0 252 1

Hash (cost=10.52..10.52 rows=252 width=58) (actual time=0.120..0.120 rows=252 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 32kB
17. 0.078 0.078 ↑ 1.0 252 1

Seq Scan on billing_product (cost=0.00..10.52 rows=252 width=58) (actual time=0.008..0.078 rows=252 loops=1)

18. 0.244 0.511 ↑ 1.0 2,362 1

Hash (cost=36.62..36.62 rows=2,362 width=4) (actual time=0.510..0.511 rows=2,362 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 116kB
19. 0.267 0.267 ↑ 1.0 2,362 1

Seq Scan on billing_unattendedregistration_invoices (cost=0.00..36.62 rows=2,362 width=4) (actual time=0.008..0.267 rows=2,362 loops=1)

20. 12.410 153.952 ↑ 1.0 60,236 1

Hash (cost=22,138.49..22,138.49 rows=60,955 width=4) (actual time=153.952..153.952 rows=60,236 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 2,630kB
21. 141.542 141.542 ↑ 1.0 60,236 1

Seq Scan on accounts_duser (cost=0.00..22,138.49 rows=60,955 width=4) (actual time=0.011..141.542 rows=60,236 loops=1)

  • Filter: (favorite_category_id <> 354)
  • Rows Removed by Filter: 295,422
22. 1.385 2.672 ↓ 1.0 7,999 1

Hash (cost=189.98..189.98 rows=7,998 width=18) (actual time=2.671..2.672 rows=7,999 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 471kB
23. 1.287 1.287 ↓ 1.0 7,999 1

Seq Scan on accounts_sellervat (cost=0.00..189.98 rows=7,998 width=18) (actual time=0.014..1.287 rows=7,999 loops=1)

24. 6.685 1,256.375 ↓ 181.5 36,308 1

Hash (cost=128,054.07..128,054.07 rows=200 width=36) (actual time=1,256.251..1,256.375 rows=36,308 loops=1)

  • Buckets: 65,536 (originally 1024) Batches: 1 (originally 1) Memory Usage: 2,715kB
25. 4.633 1,249.690 ↓ 181.5 36,308 1

Subquery Scan on job_ids (cost=128,049.57..128,054.07 rows=200 width=36) (actual time=1,228.016..1,249.690 rows=36,308 loops=1)

26. 79.222 1,245.057 ↓ 181.5 36,308 1

HashAggregate (cost=128,049.57..128,052.07 rows=200 width=36) (actual time=1,228.014..1,245.057 rows=36,308 loops=1)

  • Group Key: billing_invoice_2.id
27. 24.274 1,165.835 ↑ 1.2 118,258 1

Group (cost=114,873.86..125,232.11 rows=140,873 width=8) (actual time=1,051.831..1,165.835 rows=118,258 loops=1)

  • Group Key: jobs_job.id, billing_invoice_2.id
28. 60.641 1,141.561 ↓ 1.8 147,785 1

Gather Merge (cost=114,873.86..124,817.78 rows=82,866 width=8) (actual time=1,051.829..1,141.561 rows=147,785 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
29. 20.670 1,080.920 ↑ 1.1 73,892 2 / 2

Group (cost=113,873.85..114,495.34 rows=82,866 width=8) (actual time=1,042.966..1,080.920 rows=73,892 loops=2)

  • Group Key: jobs_job.id, billing_invoice_2.id
30. 73.338 1,060.250 ↓ 1.6 135,722 2 / 2

Sort (cost=113,873.85..114,081.01 rows=82,866 width=8) (actual time=1,042.960..1,060.250 rows=135,722 loops=2)

  • Sort Key: jobs_job.id, billing_invoice_2.id
  • Sort Method: quicksort Memory: 10,221kB
31. 0.000 986.912 ↓ 1.6 135,722 2 / 2

Nested Loop Left Join (cost=4,208.89..107,104.32 rows=82,866 width=8) (actual time=43.377..986.912 rows=135,722 loops=2)

32. 124.702 591.930 ↓ 1.6 135,722 2 / 2

Nested Loop Left Join (cost=4,208.47..65,158.79 rows=82,866 width=8) (actual time=43.333..591.930 rows=135,722 loops=2)

33. 84.163 195.784 ↓ 1.6 135,722 2 / 2

Hash Join (cost=4,208.04..27,147.82 rows=82,866 width=8) (actual time=43.300..195.784 rows=135,722 loops=2)

  • Hash Cond: (accounting_moneyflow.invoice_id = billing_invoice_2.id)
34. 69.093 69.093 ↑ 1.2 596,649 2 / 2

Parallel Seq Scan on accounting_moneyflow (cost=0.00..21,097.22 rows=701,922 width=8) (actual time=0.015..69.093 rows=596,649 loops=2)

35. 15.534 42.528 ↑ 1.0 67,414 2 / 2

Hash (cost=3,357.74..3,357.74 rows=68,024 width=4) (actual time=42.527..42.528 rows=67,414 loops=2)

  • Buckets: 131,072 Batches: 1 Memory Usage: 3,395kB
36. 26.994 26.994 ↑ 1.0 67,414 2 / 2

Index Scan using billing_invoice_is_proforma_idx on billing_invoice billing_invoice_2 (cost=0.42..3,357.74 rows=68,024 width=4) (actual time=0.050..26.994 rows=67,414 loops=2)

  • Index Cond: (is_proforma = true)
  • Filter: (is_proforma IS TRUE)
37. 271.444 271.444 ↑ 1.0 1 271,444 / 2

Index Scan using bids_bid_idx on bids_bid (cost=0.42..0.46 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=271,444)

  • Index Cond: (accounting_moneyflow.object_pk = id)
38. 407.166 407.166 ↑ 1.0 1 271,444 / 2

Index Only Scan using jobs_job_idx on jobs_job (cost=0.42..0.51 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=271,444)

  • Index Cond: (id = bids_bid.job_id)
  • Heap Fetches: 143,467
39. 15.775 100.767 ↑ 1.0 67,414 1

Hash (cost=6,891.28..6,891.28 rows=68,024 width=12) (actual time=100.766..100.767 rows=67,414 loops=1)

  • Buckets: 131,072 Batches: 1 Memory Usage: 3,892kB
40. 20.731 84.992 ↑ 1.0 67,414 1

Merge Left Join (cost=0.84..6,891.28 rows=68,024 width=12) (actual time=1.089..84.992 rows=67,414 loops=1)

  • Merge Cond: (billing_invoice_1.id = paid_invoices.proforma_id)
41. 44.209 44.209 ↑ 1.0 67,414 1

Index Scan using billing_invoice_idx on billing_invoice billing_invoice_1 (cost=0.42..4,960.87 rows=68,024 width=4) (actual time=1.075..44.209 rows=67,414 loops=1)

  • Filter: (is_proforma IS TRUE)
  • Rows Removed by Filter: 76,596
42. 20.052 20.052 ↑ 3.4 42,451 1

Index Scan using billing_invoice_proforma_id_idx on billing_invoice paid_invoices (cost=0.42..4,992.52 rows=144,088 width=12) (actual time=0.011..20.052 rows=42,451 loops=1)

43. 3.889 892.886 ↓ 205.8 25,932 1

Hash (cost=56,877.51..56,877.51 rows=126 width=8) (actual time=892.814..892.886 rows=25,932 loops=1)

  • Buckets: 32,768 (originally 1024) Batches: 1 (originally 1) Memory Usage: 1,269kB
44. 3.830 888.997 ↓ 205.8 25,932 1

Subquery Scan on c (cost=53,463.87..56,877.51 rows=126 width=8) (actual time=787.925..888.997 rows=25,932 loops=1)

  • Filter: (c.row_number = 1)
  • Rows Removed by Filter: 6,171
45. 14.445 885.167 ↓ 1.3 32,103 1

WindowAgg (cost=53,463.87..56,562.13 rows=25,231 width=16) (actual time=787.923..885.167 rows=32,103 loops=1)

46. 3.189 870.722 ↓ 1.3 32,103 1

Subquery Scan on a (cost=53,463.87..56,183.66 rows=25,231 width=8) (actual time=787.916..870.722 rows=32,103 loops=1)

47. 31.388 867.533 ↓ 1.3 32,103 1

Finalize GroupAggregate (cost=53,463.87..55,931.35 rows=25,231 width=40) (actual time=787.915..867.533 rows=32,103 loops=1)

  • Group Key: billing_invoice_3.id, categories_category.id
  • Filter: (sum(accounting_moneyflow_1.amount) <> '0'::numeric)
  • Rows Removed by Filter: 12
48. 22.542 836.145 ↓ 3.0 44,469 1

Gather Merge (cost=53,463.87..55,467.54 rows=14,842 width=40) (actual time=787.898..836.145 rows=44,469 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
49. 25.764 813.603 ↓ 1.5 22,234 2 / 2

Partial GroupAggregate (cost=52,463.86..52,797.81 rows=14,842 width=40) (actual time=782.378..813.603 rows=22,234 loops=2)

  • Group Key: billing_invoice_3.id, categories_category.id
50. 31.516 787.839 ↓ 4.6 67,570 2 / 2

Sort (cost=52,463.86..52,500.97 rows=14,842 width=12) (actual time=782.355..787.839 rows=67,570 loops=2)

  • Sort Key: billing_invoice_3.id, categories_category.id
  • Sort Method: quicksort Memory: 6,489kB
51. 15.596 756.323 ↓ 4.6 67,570 2 / 2

Hash Left Join (cost=7,273.24..51,435.51 rows=14,842 width=12) (actual time=80.464..756.323 rows=67,570 loops=2)

  • Hash Cond: (categories_categoryform.category_id = categories_category.id)
52. 19.672 740.578 ↓ 4.6 67,570 2 / 2

Hash Join (cost=7,259.22..51,382.11 rows=14,842 width=12) (actual time=80.292..740.578 rows=67,570 loops=2)

  • Hash Cond: (jobs_job_1.category_form_id = categories_categoryform.id)
53. 38.169 713.315 ↓ 4.3 67,760 2 / 2

Nested Loop (cost=6,521.87..50,603.62 rows=15,667 width=12) (actual time=72.525..713.315 rows=67,760 loops=2)

54. 15.231 471.868 ↓ 4.3 67,760 2 / 2

Nested Loop (cost=6,521.44..42,673.22 rows=15,667 width=12) (actual time=72.494..471.868 rows=67,760 loops=2)

55. 33.187 253.358 ↓ 4.3 67,760 2 / 2

Hash Join (cost=6,521.02..35,232.84 rows=15,667 width=12) (actual time=72.459..253.358 rows=67,760 loops=2)

  • Hash Cond: (accounting_moneyflow_1.invoice_id = billing_invoice_3.id)
56. 147.925 147.925 ↑ 3.0 116,192 2 / 2

Parallel Seq Scan on accounting_moneyflow accounting_moneyflow_1 (cost=0.00..27,239.04 rows=350,961 width=12) (actual time=0.020..147.925 rows=116,192 loops=2)

  • Filter: CASE WHEN ((action)::text = ANY ('{success,penalty,acquisition}'::text[])) THEN (amount < '0'::numeric) ELSE (amount > '0'::numeric) END
  • Rows Removed by Filter: 480,458
57. 5.804 72.246 ↓ 1.2 30,958 2 / 2

Hash (cost=6,199.49..6,199.49 rows=25,722 width=8) (actual time=72.242..72.246 rows=30,958 loops=2)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,466kB
58. 3.067 66.442 ↓ 1.2 30,958 2 / 2

Nested Loop (cost=4,208.61..6,199.49 rows=25,722 width=8) (actual time=37.079..66.442 rows=30,958 loops=2)

59. 0.038 0.038 ↑ 1.0 1 2 / 2

Index Only Scan using billing_product_idx on billing_product billing_product_1 (cost=0.14..2.36 rows=1 width=4) (actual time=0.036..0.038 rows=1 loops=2)

  • Index Cond: (id = 138)
  • Heap Fetches: 1
60. 16.617 63.337 ↓ 1.2 30,958 2 / 2

Hash Join (cost=4,208.46..5,939.91 rows=25,722 width=12) (actual time=37.034..63.337 rows=30,958 loops=2)

  • Hash Cond: (billing_invoiceproducts_1.invoice_id = billing_invoice_3.id)
61. 10.345 10.345 ↓ 1.0 54,628 2 / 2

Index Scan using billing_invoiceproducts_product_id_idx on billing_invoiceproducts billing_invoiceproducts_1 (cost=0.42..1,588.85 rows=54,484 width=8) (actual time=0.025..10.345 rows=54,628 loops=2)

  • Index Cond: (product_id = 138)
62. 13.009 36.375 ↑ 1.0 67,414 2 / 2

Hash (cost=3,357.74..3,357.74 rows=68,024 width=4) (actual time=36.374..36.375 rows=67,414 loops=2)

  • Buckets: 131,072 Batches: 1 Memory Usage: 3,395kB
63. 23.366 23.366 ↑ 1.0 67,414 2 / 2

Index Scan using billing_invoice_is_proforma_idx on billing_invoice billing_invoice_3 (cost=0.42..3,357.74 rows=68,024 width=4) (actual time=0.039..23.366 rows=67,414 loops=2)

  • Index Cond: (is_proforma = true)
  • Filter: (is_proforma IS TRUE)
64. 203.279 203.279 ↑ 1.0 1 135,519 / 2

Index Scan using bids_bid_idx on bids_bid bids_bid_1 (cost=0.42..0.47 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=135,519)

  • Index Cond: (id = accounting_moneyflow_1.object_pk)
65. 203.279 203.279 ↑ 1.0 1 135,519 / 2

Index Scan using jobs_job_idx on jobs_job jobs_job_1 (cost=0.42..0.51 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=135,519)

  • Index Cond: (id = bids_bid_1.job_id)
66. 3.506 7.591 ↑ 1.0 23,481 2 / 2

Hash (cost=443.84..443.84 rows=23,481 width=8) (actual time=7.590..7.591 rows=23,481 loops=2)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,174kB
67. 4.085 4.085 ↑ 1.0 23,481 2 / 2

Seq Scan on categories_categoryform (cost=0.00..443.84 rows=23,481 width=8) (actual time=0.028..4.085 rows=23,481 loops=2)

  • Filter: (category_id <> ALL ('{356,354}'::integer[]))
  • Rows Removed by Filter: 1,306
68. 0.064 0.149 ↑ 1.0 401 2 / 2

Hash (cost=9.01..9.01 rows=401 width=4) (actual time=0.148..0.149 rows=401 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 23kB
69. 0.085 0.085 ↑ 1.0 401 2 / 2

Seq Scan on categories_category (cost=0.00..9.01 rows=401 width=4) (actual time=0.024..0.085 rows=401 loops=2)

Planning time : 6.575 ms
Execution time : 3,751.823 ms