explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gDF1

Settings
# exclusive inclusive rows x rows loops node
1. 0.037 133,825.023 ↓ 29.0 29 1

Subquery Scan on vw_invoices_all_picking (cost=67,645.55..67,645.57 rows=1 width=589) (actual time=133,824.985..133,825.023 rows=29 loops=1)

2. 0.457 133,824.986 ↓ 29.0 29 1

Sort (cost=67,645.55..67,645.56 rows=1 width=593) (actual time=133,824.979..133,824.986 rows=29 loops=1)

  • Sort Key: vw_invoices_all_base.has_changed DESC, ((vw_invoices_all_base."time")::date), vw_invoices_all_base.is_rushed DESC, vw_invoices_all_base."time", vw_invoices_all_base.lane, vw_invoices_all_base.customer_priority, vw_invoices_all_base.invoice_priority
  • Sort Method: quicksort Memory: 37kB
3. 0.101 133,824.529 ↓ 29.0 29 1

Subquery Scan on vw_invoices_all_base (cost=50,028.96..67,645.54 rows=1 width=593) (actual time=1,429.311..133,824.529 rows=29 loops=1)

4. 1.214 133,824.428 ↓ 29.0 29 1

Nested Loop (cost=50,028.96..67,645.53 rows=1 width=589) (actual time=1,429.308..133,824.428 rows=29 loops=1)

  • Join Filter: ((multiwarehouse.warehouse)::text = (inwh.warehouse)::text)
5.          

CTE multiwarehouse

6. 0.933 158.599 ↓ 17.4 660 1

Group (cost=11,495.87..11,496.16 rows=38 width=24) (actual time=157.182..158.599 rows=660 loops=1)

  • Group Key: arinvdet.doc_aid, arinvdet.warehouse
7. 9.407 157.666 ↓ 81.6 3,101 1

Sort (cost=11,495.87..11,495.97 rows=38 width=24) (actual time=157.179..157.666 rows=3,101 loops=1)

  • Sort Key: arinvdet.doc_aid, arinvdet.warehouse
  • Sort Method: quicksort Memory: 339kB
8. 3.547 148.259 ↓ 81.6 3,101 1

Nested Loop (cost=0.43..11,494.87 rows=38 width=24) (actual time=1.662..148.259 rows=3,101 loops=1)

9. 130.747 130.747 ↓ 83.1 665 1

Seq Scan on arinv arinv_1 (cost=0.00..10,944.11 rows=8 width=17) (actual time=1.623..130.747 rows=665 loops=1)

  • Filter: ((is_rma IS NOT TRUE) AND (progress < '80'::numeric) AND ((status)::text = 'U'::text))
  • Rows Removed by Filter: 106344
10. 13.965 13.965 ↑ 1.2 5 665

Index Scan using arinvdet_docaid_idx on arinvdet (cost=0.43..68.79 rows=6 width=24) (actual time=0.016..0.021 rows=5 loops=665)

  • Index Cond: ((doc_aid)::text = (arinv_1.autoid)::text)
  • Filter: ((quan > 0.0) AND ((id)::text !~~ '($)%'::text))
  • Rows Removed by Filter: 0
11. 0.457 133,819.038 ↓ 29.0 29 1

Nested Loop Left Join (cost=38,532.81..53,572.29 rows=1 width=575) (actual time=1,429.161..133,819.038 rows=29 loops=1)

  • Join Filter: (pick_jobs.id = pick_jobs_shelved.pick_job)
  • Rows Removed by Join Filter: 1421
12. 0.126 133,817.508 ↓ 29.0 29 1

Nested Loop Left Join (cost=38,513.05..53,552.39 rows=1 width=567) (actual time=1,429.040..133,817.508 rows=29 loops=1)

13. 0.243 133,816.512 ↓ 29.0 29 1

Nested Loop Left Join (cost=38,512.78..53,548.92 rows=1 width=563) (actual time=1,429.026..133,816.512 rows=29 loops=1)

14. 0.979 133,815.834 ↓ 29.0 29 1

Merge Left Join (cost=38,512.49..53,545.71 rows=1 width=569) (actual time=1,428.990..133,815.834 rows=29 loops=1)

  • Merge Cond: (((multiwarehouse.invoice)::text = (pick_jobs_deleted.original_invoice)::text) AND ((multiwarehouse.warehouse)::text = (pick_jobs_deleted.original_warehouse)::text))
15. 0.115 133,800.194 ↓ 29.0 29 1

Nested Loop Left Join (cost=28,142.07..41,782.29 rows=1 width=551) (actual time=1,415.667..133,800.194 rows=29 loops=1)

16. 0.824 133,800.050 ↓ 29.0 29 1

Nested Loop (cost=28,141.92..41,782.13 rows=1 width=538) (actual time=1,415.660..133,800.050 rows=29 loops=1)

  • Join Filter: (NOT COALESCE(CASE WHEN (true) THEN ((arinv.ship_date <> pick_jobs.original_ship_date) OR ((arinv.ship_via)::text <> (pick_jobs.original_ship_method)::text)) ELSE true END, false))
  • Rows Removed by Join Filter: 1
17. 2,837.757 133,794.798 ↓ 12.6 164 1

Nested Loop (cost=28,141.50..41,738.53 rows=13 width=276) (actual time=701.897..133,794.798 rows=164 loops=1)

  • Join Filter: ((multiwarehouse.invoice)::text = (scheduled_invoices.invoice_autoid)::text)
  • Rows Removed by Join Filter: 11662036
18. 6.275 203.121 ↓ 660.0 660 1

Nested Loop Left Join (cost=856.26..1,231.33 rows=1 width=107) (actual time=167.056..203.121 rows=660 loops=1)

  • Filter: (pick_jobs.finished IS NULL)
19. 11.265 182.986 ↓ 17.4 660 1

Merge Left Join (cost=855.85..918.52 rows=38 width=68) (actual time=167.029..182.986 rows=660 loops=1)

  • Merge Cond: (((multiwarehouse.invoice)::text = (pick_jobs_updated.original_invoice)::text) AND ((multiwarehouse.warehouse)::text = (pick_jobs_updated.original_warehouse)::text))
20. 1.418 160.385 ↓ 17.4 660 1

Sort (cost=1.76..1.85 rows=38 width=64) (actual time=159.322..160.385 rows=660 loops=1)

  • Sort Key: multiwarehouse.invoice, multiwarehouse.warehouse
  • Sort Method: quicksort Memory: 76kB
21. 158.967 158.967 ↓ 17.4 660 1

CTE Scan on multiwarehouse (cost=0.00..0.76 rows=38 width=64) (actual time=157.186..158.967 rows=660 loops=1)

22. 2.666 11.336 ↑ 2.0 1,309 1

Unique (cost=854.09..877.28 rows=2,612 width=79) (actual time=7.694..11.336 rows=1,309 loops=1)

23. 6.438 8.670 ↑ 2.0 1,549 1

Sort (cost=854.09..861.82 rows=3,091 width=79) (actual time=7.692..8.670 rows=1,549 loops=1)

  • Sort Key: pick_jobs_updated.original_invoice, pick_jobs_updated.original_warehouse, pick_jobs_updated.time_updated DESC NULLS LAST
  • Sort Method: quicksort Memory: 170kB
24. 2.232 2.232 ↑ 2.0 1,549 1

Seq Scan on pick_jobs_updated (cost=0.00..674.91 rows=3,091 width=79) (actual time=0.037..2.232 rows=1,549 loops=1)

25. 13.860 13.860 ↓ 0.0 0 660

Index Scan using uc_invoice_warehouse on pick_jobs (cost=0.41..8.22 rows=1 width=106) (actual time=0.021..0.021 rows=0 loops=660)

  • Index Cond: (((multiwarehouse.invoice)::text = (invoice)::text) AND ((multiwarehouse.warehouse)::text = (warehouse)::text))
26. 3,932.280 130,753.920 ↓ 1.9 17,670 660

Append (cost=27,285.24..40,297.61 rows=9,315 width=209) (actual time=0.410..198.112 rows=17,670 loops=660)

27.          

CTE scheduled_invoices

28. 1.874 284.275 ↑ 1.3 499 1

Nested Loop Left Join (cost=15,738.79..16,341.14 rows=660 width=124) (actual time=268.514..284.275 rows=499 loops=1)

29. 15.457 281.902 ↑ 1.3 499 1

Merge Left Join (cost=15,738.51..16,100.09 rows=660 width=147) (actual time=268.449..281.902 rows=499 loops=1)

  • Merge Cond: (((arinv_3.invoice)::text = ((invoice.invoice_id)::text)) AND (arinv_3.company = ((invoice.company)::text)))
30. 2.008 98.029 ↑ 1.3 499 1

Sort (cost=13,180.47..13,182.12 rows=660 width=144) (actual time=97.910..98.029 rows=499 loops=1)

  • Sort Key: arinv_3.invoice, arinv_3.company
  • Sort Method: quicksort Memory: 95kB
31. 1.047 96.021 ↑ 1.3 499 1

Hash Left Join (cost=1,476.16..13,149.56 rows=660 width=144) (actual time=27.576..96.021 rows=499 loops=1)

  • Hash Cond: ((arinv_3.ship_cat = customer_entry.ship_cat) AND (arinv_3.ship_date = customer_entry.date) AND ((((COALESCE((arinv_3.c_id)::text, ''::text) || COALESCE((arinv_3.c_zip)::text, ''::text)) || '_'::text) || COALESCE((arinv_3.c_address1)::text, ''::text)) = (customer_entry.sch_cust_id)::text))
  • Filter: ((arinv_3.ship_cat > 2) OR (customer_entry.load_id IS NOT NULL))
  • Rows Removed by Filter: 80
32. 0.737 67.613 ↑ 1.2 579 1

Subquery Scan on arinv_3 (cost=0.29..11,667.83 rows=710 width=232) (actual time=0.026..67.613 rows=579 loops=1)

  • Filter: (arinv_3.progress >= '40'::numeric)
  • Rows Removed by Filter: 1474
33. 0.655 66.876 ↑ 1.0 2,053 1

Append (cost=0.29..11,641.21 rows=2,130 width=1,206) (actual time=0.023..66.876 rows=2,053 loops=1)

34. 0.415 0.415 ↓ 1.1 188 1

Index Scan using idx_btree_arinv_status on arinv arinv_4 (cost=0.29..52.75 rows=169 width=395) (actual time=0.022..0.415 rows=188 loops=1)

  • Index Cond: ((status)::text = 'U'::text)
35. 0.508 2.421 ↑ 1.0 982 1

Subquery Scan on *SELECT* 2_1 (cost=0.42..523.80 rows=1,025 width=442) (actual time=0.037..2.421 rows=982 loops=1)

36. 1.913 1.913 ↑ 1.0 982 1

Index Scan using arinv_status_idx on arinv arinv_5 (cost=0.42..513.55 rows=1,025 width=450) (actual time=0.035..1.913 rows=982 loops=1)

  • Index Cond: ((status)::text = 'U'::text)
37. 61.758 61.758 ↑ 1.1 883 1

Seq Scan on arinv arinv_6 (cost=0.00..10,676.59 rows=935 width=447) (actual time=0.491..61.758 rows=883 loops=1)

  • Filter: ((status)::text = 'U'::text)
  • Rows Removed by Filter: 106126
38. 0.002 1.627 ↓ 0.0 0 1

Subquery Scan on *SELECT* 4 (cost=0.00..377.02 rows=1 width=630) (actual time=1.627..1.627 rows=0 loops=1)

39. 1.625 1.625 ↓ 0.0 0 1

Seq Scan on arinv arinv_7 (cost=0.00..377.01 rows=1 width=602) (actual time=1.625..1.625 rows=0 loops=1)

  • Filter: ((status)::text = 'U'::text)
  • Rows Removed by Filter: 3441
40. 15.682 27.361 ↑ 1.0 32,577 1

Hash (cost=905.77..905.77 rows=32,577 width=41) (actual time=27.361..27.361 rows=32,577 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 2689kB
41. 11.679 11.679 ↑ 1.0 32,577 1

Seq Scan on customer_entry (cost=0.00..905.77 rows=32,577 width=41) (actual time=0.020..11.679 rows=32,577 loops=1)

42. 150.157 168.416 ↑ 1.0 27,857 1

Sort (cost=2,558.04..2,627.79 rows=27,899 width=23) (actual time=163.196..168.416 rows=27,857 loops=1)

  • Sort Key: ((invoice.invoice_id)::text), ((invoice.company)::text)
  • Sort Method: quicksort Memory: 2955kB
43. 18.259 18.259 ↑ 1.0 27,899 1

Seq Scan on invoice (cost=0.00..497.99 rows=27,899 width=23) (actual time=0.109..18.259 rows=27,899 loops=1)

44. 0.499 0.499 ↑ 1.0 1 499

Index Scan using uc_id_date on load (cost=0.28..0.31 rows=1 width=24) (actual time=0.001..0.001 rows=1 loops=499)

  • Index Cond: (id = customer_entry.load_id)
45.          

CTE rushed_invoices

46. 116.043 116.043 ↑ 1.1 11 1

Seq Scan on arinv arinv_8 (cost=0.00..10,944.11 rows=12 width=21) (actual time=12.729..116.043 rows=11 loops=1)

  • Filter: (is_rushed AND (progress >= '30'::numeric) AND ((status)::text = 'U'::text))
  • Rows Removed by Filter: 106998
47. 445.500 445.500 ↑ 1.3 499 660

CTE Scan on scheduled_invoices (cost=0.00..13.20 rows=660 width=235) (actual time=0.410..0.675 rows=499 loops=660)

48. 1.320 128.040 ↑ 6.0 1 660

Subquery Scan on *SELECT* 2 (cost=21.45..21.98 rows=6 width=209) (actual time=0.054..0.194 rows=1 loops=660)

49. 7.634 126.720 ↑ 6.0 1 660

Hash Anti Join (cost=21.45..21.91 rows=6 width=205) (actual time=0.053..0.192 rows=1 loops=660)

  • Hash Cond: ((rushed_invoices.autoid)::text = (scheduled_invoices_1.invoice_autoid)::text)
50. 118.800 118.800 ↑ 1.1 11 660

CTE Scan on rushed_invoices (cost=0.00..0.24 rows=12 width=36) (actual time=0.020..0.180 rows=11 loops=660)

51. 0.147 0.286 ↑ 1.3 499 1

Hash (cost=13.20..13.20 rows=660 width=32) (actual time=0.286..0.286 rows=499 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 32kB
52. 0.139 0.139 ↑ 1.3 499 1

CTE Scan on scheduled_invoices scheduled_invoices_1 (cost=0.00..13.20 rows=660 width=32) (actual time=0.002..0.139 rows=499 loops=1)

53. 6,122.144 126,248.100 ↓ 2.0 17,170 660

Hash Anti Join (cost=21.84..12,884.10 rows=8,649 width=194) (actual time=111.668..191.285 rows=17,170 loops=660)

  • Hash Cond: ((pick_jobs_1.invoice)::text = (rushed_invoices_1.autoid)::text)
54. 5,564.721 120,125.940 ↓ 2.0 17,171 660

Hash Anti Join (cost=21.45..12,774.49 rows=8,655 width=17) (actual time=111.665..182.009 rows=17,171 loops=660)

  • Hash Cond: ((pick_jobs_1.invoice)::text = (scheduled_invoices_2.invoice_autoid)::text)
55. 114,560.820 114,560.820 ↑ 1.0 17,310 660

Seq Scan on pick_jobs pick_jobs_1 (cost=0.00..11,908.10 rows=17,310 width=17) (actual time=111.659..173.577 rows=17,310 loops=660)

56. 0.197 0.399 ↑ 1.3 499 1

Hash (cost=13.20..13.20 rows=660 width=32) (actual time=0.399..0.399 rows=499 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 32kB
57. 0.202 0.202 ↑ 1.3 499 1

CTE Scan on scheduled_invoices scheduled_invoices_2 (cost=0.00..13.20 rows=660 width=32) (actual time=0.004..0.202 rows=499 loops=1)

58. 0.009 0.016 ↑ 1.1 11 1

Hash (cost=0.24..0.24 rows=12 width=32) (actual time=0.015..0.016 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
59. 0.007 0.007 ↑ 1.1 11 1

CTE Scan on rushed_invoices rushed_invoices_1 (cost=0.00..0.24 rows=12 width=32) (actual time=0.002..0.007 rows=11 loops=1)

60. 4.428 4.428 ↓ 0.0 0 164

Index Scan using arinv_pkey on arinv (cost=0.42..3.34 rows=1 width=279) (actual time=0.027..0.027 rows=0 loops=164)

  • Index Cond: ((autoid)::text = (scheduled_invoices.invoice_autoid)::text)
  • Filter: ((is_rma IS NOT TRUE) AND (progress < '80'::numeric) AND (progress < 60.0))
  • Rows Removed by Filter: 1
61. 0.029 0.029 ↓ 0.0 0 29

Index Scan using user_pkey on "user" (cost=0.14..0.16 rows=1 width=17) (actual time=0.001..0.001 rows=0 loops=29)

  • Index Cond: (pick_jobs."current_user" = id)
62. 0.914 14.661 ↑ 51.5 1,134 1

Unique (cost=10,370.43..10,887.03 rows=58,425 width=93) (actual time=13.289..14.661 rows=1,134 loops=1)

63. 5.586 13.747 ↑ 51.6 1,336 1

Sort (cost=10,370.43..10,542.63 rows=68,880 width=93) (actual time=13.281..13.747 rows=1,336 loops=1)

  • Sort Key: pick_jobs_deleted.original_invoice, pick_jobs_deleted.original_warehouse, pick_jobs_deleted.time_deleted DESC NULLS LAST
  • Sort Method: quicksort Memory: 164kB
64. 8.161 8.161 ↑ 47.3 1,456 1

Seq Scan on pick_jobs_deleted (cost=0.00..1,303.80 rows=68,880 width=93) (actual time=0.170..8.161 rows=1,456 loops=1)

65. 0.435 0.435 ↑ 1.0 1 29

Index Scan using arcust_id_idx on arcust (cost=0.29..3.19 rows=1 width=8) (actual time=0.014..0.015 rows=1 loops=29)

  • Index Cond: ((arinv.id)::text = (id)::text)
66. 0.870 0.870 ↓ 0.0 0 29

Index Scan using uc_invoice_warehosue on invoice_pictures (cost=0.27..3.45 rows=1 width=71) (actual time=0.030..0.030 rows=0 loops=29)

  • Index Cond: (((multiwarehouse.invoice)::text = (invoice)::text) AND ((multiwarehouse.warehouse)::text = (warehouse)::text))
67. 0.667 1.073 ↓ 9.8 49 29

Unique (cost=19.76..19.78 rows=5 width=44) (actual time=0.004..0.037 rows=49 loops=29)

68. 0.360 0.406 ↓ 9.8 49 29

Sort (cost=19.76..19.77 rows=5 width=44) (actual time=0.004..0.014 rows=49 loops=29)

  • Sort Key: pick_jobs_shelved.pick_job, pick_jobs_shelved.shelved_time DESC NULLS LAST
  • Sort Method: quicksort Memory: 27kB
69. 0.046 0.046 ↓ 9.8 49 1

Seq Scan on pick_jobs_shelved (cost=0.00..19.70 rows=5 width=44) (actual time=0.033..0.046 rows=49 loops=1)

  • Filter: (unshelved_time IS NULL)
70. 0.145 0.145 ↑ 1.0 1 29

Seq Scan on inwh (cost=0.00..1.05 rows=1 width=64) (actual time=0.005..0.005 rows=1 loops=29)

  • Filter: ((autoid)::text = '2GA89EVTVE3SGAD1'::text)
  • Rows Removed by Filter: 2
71.          

SubPlan (forNested Loop)

72. 0.116 1.392 ↑ 1.0 1 29

Aggregate (cost=95.42..95.43 rows=1 width=8) (actual time=0.048..0.048 rows=1 loops=29)

73. 0.261 1.276 ↓ 0.0 0 29

Unique (cost=95.38..95.40 rows=1 width=154) (actual time=0.044..0.044 rows=0 loops=29)

74. 0.667 1.015 ↓ 0.0 0 29

Sort (cost=95.38..95.39 rows=1 width=154) (actual time=0.035..0.035 rows=0 loops=29)

  • Sort Key: arinvdet_1.autoid, arinvdet_1.descr, arinvdet_1.unit_meas, ((gbl_functions.fn_mainunit_to_uom_qty(inventry.id, arinvdet_1.unit_meas, arinvdet_1.quan))::integer), ((NULLIF((arinvdet_1.gpar_time)::text, ''::text))::character varying), (COALESCE(pick_transactions.qty_shipped, 0))
  • Sort Method: quicksort Memory: 25kB
75. 0.029 0.348 ↓ 0.0 0 29

Nested Loop Left Join (cost=1.55..95.37 rows=1 width=154) (actual time=0.012..0.012 rows=0 loops=29)

76. 0.029 0.319 ↓ 0.0 0 29

Nested Loop (cost=1.13..86.68 rows=1 width=132) (actual time=0.011..0.011 rows=0 loops=29)

77. 0.029 0.290 ↓ 0.0 0 29

Nested Loop (cost=0.71..78.23 rows=1 width=132) (actual time=0.010..0.010 rows=0 loops=29)

78. 0.174 0.261 ↓ 0.0 0 29

Nested Loop (cost=0.43..69.91 rows=1 width=130) (actual time=0.009..0.009 rows=0 loops=29)

  • Join Filter: ((arinvdet_1.warehouse)::text = (inwh_1.warehouse)::text)
79. 0.087 0.087 ↓ 0.0 0 29

Seq Scan on inwh inwh_1 (cost=0.00..1.05 rows=1 width=64) (actual time=0.003..0.003 rows=0 loops=29)

  • Filter: ((autoid)::text = (multiwarehouse.warehouse)::text)
  • Rows Removed by Filter: 4
80. 0.000 0.000 ↓ 0.0 0

Index Scan using arinvdet_docaid_idx on arinvdet arinvdet_1 (cost=0.43..68.79 rows=6 width=105) (never executed)

  • Index Cond: ((doc_aid)::text = (multiwarehouse.invoice)::text)
  • Filter: ((quan > 0.0) AND ((id)::text !~~ '($)%'::text))
81. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_btree_inventry_id on inventry (cost=0.29..8.31 rows=1 width=12) (never executed)

  • Index Cond: ((id)::text = (arinvdet_1.inven)::text)
  • Filter: (((c_type <> 1.0) OR (auto_cost IS NOT TRUE)) AND (discou_typ <= 0))
82. 0.000 0.000 ↓ 0.0 0

Index Scan using arinv_pkey on arinv arinv_2 (cost=0.42..8.44 rows=1 width=17) (never executed)

  • Index Cond: ((autoid)::text = (multiwarehouse.invoice)::text)
  • Filter: ((is_rma IS NOT TRUE) AND (progress < '80'::numeric) AND ((status)::text = 'U'::text))
83. 0.000 0.000 ↓ 0.0 0

Index Scan using uc_item on pick_transactions (cost=0.42..8.44 rows=1 width=21) (never executed)

  • Index Cond: ((arinvdet_1.autoid)::text = (item)::text)
84. 0.522 0.667 ↑ 1.0 1 29

Aggregate (cost=2,467.44..2,467.45 rows=1 width=8) (actual time=0.022..0.023 rows=1 loops=29)

85. 0.087 0.145 ↓ 0.0 0 29

Bitmap Heap Scan on pick_transactions pick_transactions_1 (cost=13.76..2,465.72 rows=689 width=17) (actual time=0.005..0.005 rows=0 loops=29)

  • Recheck Cond: (pick_job = pick_jobs.id)
86. 0.058 0.058 ↓ 0.0 0 29

Bitmap Index Scan on idx_btree_picktransactions_pickjob (cost=0.00..13.59 rows=689 width=0) (actual time=0.002..0.002 rows=0 loops=29)

  • Index Cond: (pick_job = pick_jobs.id)
87. 1.131 1.131 ↓ 0.0 0 29

Seq Scan on "user" user_1 (cost=0.00..6.56 rows=1 width=13) (actual time=0.039..0.039 rows=0 loops=29)

  • Filter: (id = pick_jobs_deleted.original_picker)
  • Rows Removed by Filter: 205
88. 0.841 0.841 ↓ 0.0 0 29

Seq Scan on "user" user_1_1 (cost=0.00..6.56 rows=1 width=13) (actual time=0.029..0.029 rows=0 loops=29)

  • Filter: (id = pick_jobs_updated.original_picker)
  • Rows Removed by Filter: 205
Planning time : 21.554 ms
Execution time : 133,827.820 ms