explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IMGH

Settings
# exclusive inclusive rows x rows loops node
1. 0.025 4,914.203 ↓ 29.0 29 1

Subquery Scan on vw_invoices_all_picking (cost=67,843.19..67,843.20 rows=1 width=589) (actual time=4,914.177..4,914.203 rows=29 loops=1)

2. 0.317 4,914.178 ↓ 29.0 29 1

Sort (cost=67,843.19..67,843.19 rows=1 width=593) (actual time=4,914.173..4,914.178 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.078 4,913.861 ↓ 29.0 29 1

Subquery Scan on vw_invoices_all_base (cost=63,134.49..67,843.18 rows=1 width=593) (actual time=746.102..4,913.861 rows=29 loops=1)

4. 0.919 4,913.783 ↓ 29.0 29 1

Nested Loop (cost=63,134.49..67,843.17 rows=1 width=589) (actual time=746.099..4,913.783 rows=29 loops=1)

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

CTE multiwarehouse

6. 0.930 169.760 ↓ 17.4 660 1

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

  • Group Key: arinvdet.doc_aid, arinvdet.warehouse
7. 9.076 168.830 ↓ 81.6 3,101 1

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

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

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

9. 146.666 146.666 ↓ 83.1 665 1

Seq Scan on arinv arinv_1 (cost=0.00..10,944.11 rows=8 width=17) (actual time=0.021..146.666 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. 9.975 9.975 ↑ 1.2 5 665

Index Scan using arinvdet_docaid_idx on arinvdet (cost=0.43..68.79 rows=6 width=24) (actual time=0.012..0.015 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.          

CTE vw_invoices_queue

12. 5.289 532.044 ↓ 1.9 17,670 1

Append (cost=27,285.24..40,297.61 rows=9,315 width=209) (actual time=290.378..532.044 rows=17,670 loops=1)

13.          

CTE scheduled_invoices

14. 1.923 306.106 ↑ 1.3 499 1

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

15. 15.364 303.684 ↑ 1.3 499 1

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

  • Merge Cond: (((arinv_2.invoice)::text = ((invoice.invoice_id)::text)) AND (arinv_2.company = ((invoice.company)::text)))
16. 1.975 120.793 ↑ 1.3 499 1

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

  • Sort Key: arinv_2.invoice, arinv_2.company
  • Sort Method: quicksort Memory: 95kB
17. 0.923 118.818 ↑ 1.3 499 1

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

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

Subquery Scan on arinv_2 (cost=0.29..11,667.83 rows=710 width=232) (actual time=0.030..91.012 rows=579 loops=1)

  • Filter: (arinv_2.progress >= '40'::numeric)
  • Rows Removed by Filter: 1474
19. 0.683 90.290 ↑ 1.0 2,053 1

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

20. 0.410 0.410 ↓ 1.1 188 1

Index Scan using idx_btree_arinv_status on arinv arinv_3 (cost=0.29..52.75 rows=169 width=395) (actual time=0.026..0.410 rows=188 loops=1)

  • Index Cond: ((status)::text = 'U'::text)
21. 0.495 2.299 ↑ 1.0 982 1

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

22. 1.804 1.804 ↑ 1.0 982 1

Index Scan using arinv_status_idx on arinv arinv_4 (cost=0.42..513.55 rows=1,025 width=450) (actual time=0.029..1.804 rows=982 loops=1)

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

Seq Scan on arinv arinv_5 (cost=0.00..10,676.59 rows=935 width=447) (actual time=0.021..85.256 rows=883 loops=1)

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

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

25. 1.640 1.640 ↓ 0.0 0 1

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

  • Filter: ((status)::text = 'U'::text)
  • Rows Removed by Filter: 3441
26. 15.410 26.883 ↑ 1.0 32,577 1

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

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

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

28. 149.135 167.527 ↑ 1.0 27,857 1

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

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

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

30. 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)
31.          

CTE rushed_invoices

32. 142.013 142.013 ↑ 1.1 11 1

Seq Scan on arinv arinv_7 (cost=0.00..10,944.11 rows=12 width=21) (actual time=1.510..142.013 rows=11 loops=1)

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

CTE Scan on scheduled_invoices (cost=0.00..13.20 rows=660 width=235) (actual time=290.376..306.635 rows=499 loops=1)

34. 0.005 142.372 ↑ 6.0 1 1

Subquery Scan on *SELECT* 2_1 (cost=21.45..21.98 rows=6 width=209) (actual time=137.941..142.372 rows=1 loops=1)

35. 0.039 142.367 ↑ 6.0 1 1

Hash Anti Join (cost=21.45..21.91 rows=6 width=205) (actual time=137.938..142.367 rows=1 loops=1)

  • Hash Cond: ((rushed_invoices.autoid)::text = (scheduled_invoices_1.invoice_autoid)::text)
36. 142.036 142.036 ↑ 1.1 11 1

CTE Scan on rushed_invoices (cost=0.00..0.24 rows=12 width=36) (actual time=1.513..142.036 rows=11 loops=1)

37. 0.151 0.292 ↑ 1.3 499 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 32kB
38. 0.141 0.141 ↑ 1.3 499 1

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

39. 7.777 77.748 ↓ 2.0 17,170 1

Hash Anti Join (cost=21.84..12,884.10 rows=8,649 width=194) (actual time=0.399..77.748 rows=17,170 loops=1)

  • Hash Cond: ((pick_jobs_1.invoice)::text = (rushed_invoices_1.autoid)::text)
40. 6.836 69.961 ↓ 2.0 17,171 1

Hash Anti Join (cost=21.45..12,774.49 rows=8,655 width=17) (actual time=0.373..69.961 rows=17,171 loops=1)

  • Hash Cond: ((pick_jobs_1.invoice)::text = (scheduled_invoices_2.invoice_autoid)::text)
41. 62.809 62.809 ↑ 1.0 17,310 1

Seq Scan on pick_jobs pick_jobs_1 (cost=0.00..11,908.10 rows=17,310 width=17) (actual time=0.029..62.809 rows=17,310 loops=1)

42. 0.153 0.316 ↑ 1.3 499 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 32kB
43. 0.163 0.163 ↑ 1.3 499 1

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

44. 0.006 0.010 ↑ 1.1 11 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
45. 0.004 0.004 ↑ 1.1 11 1

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

46. 0.353 4,910.196 ↓ 29.0 29 1

Nested Loop Left Join (cost=11,247.57..13,379.16 rows=1 width=575) (actual time=745.965..4,910.196 rows=29 loops=1)

  • Join Filter: (pick_jobs.id = pick_jobs_shelved.pick_job)
  • Rows Removed by Join Filter: 1421
47. 0.088 4,909.002 ↓ 29.0 29 1

Nested Loop Left Join (cost=11,227.81..13,359.26 rows=1 width=567) (actual time=745.861..4,909.002 rows=29 loops=1)

48. 0.147 4,908.711 ↓ 29.0 29 1

Nested Loop Left Join (cost=11,227.54..13,355.79 rows=1 width=563) (actual time=745.849..4,908.711 rows=29 loops=1)

49. 0.064 4,908.216 ↓ 29.0 29 1

Nested Loop Left Join (cost=11,227.25..13,352.58 rows=1 width=569) (actual time=745.828..4,908.216 rows=29 loops=1)

50. 2,339.776 4,908.123 ↓ 29.0 29 1

Nested Loop (cost=11,227.11..13,352.42 rows=1 width=556) (actual time=745.821..4,908.123 rows=29 loops=1)

  • Join Filter: (((multiwarehouse.invoice)::text = (vw_invoices_queue.invoice_autoid)::text) AND (NOT COALESCE(CASE WHEN vw_invoices_queue.scheduled 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: 9294391
51. 1.385 217.127 ↓ 526.0 526 1

Merge Left Join (cost=11,227.11..13,003.11 rows=1 width=404) (actual time=189.149..217.127 rows=526 loops=1)

  • Merge Cond: (((multiwarehouse.invoice)::text = (pick_jobs_deleted.original_invoice)::text) AND ((multiwarehouse.warehouse)::text = (pick_jobs_deleted.original_warehouse)::text))
52. 0.845 203.194 ↓ 526.0 526 1

Nested Loop (cost=856.68..1,239.69 rows=1 width=386) (actual time=177.883..203.194 rows=526 loops=1)

53. 1.097 188.489 ↓ 660.0 660 1

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

  • Filter: (pick_jobs.finished IS NULL)
54. 2.096 181.452 ↓ 17.4 660 1

Merge Left Join (cost=855.85..918.52 rows=38 width=68) (actual time=177.716..181.452 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))
55. 0.565 170.699 ↓ 17.4 660 1

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

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

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

57. 0.877 8.657 ↑ 2.0 1,309 1

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

58. 5.964 7.780 ↑ 2.0 1,549 1

Sort (cost=854.09..861.82 rows=3,091 width=79) (actual time=7.225..7.780 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
59. 1.816 1.816 ↑ 2.0 1,549 1

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

60. 5.940 5.940 ↓ 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.009..0.009 rows=0 loops=660)

  • Index Cond: (((multiwarehouse.invoice)::text = (invoice)::text) AND ((multiwarehouse.warehouse)::text = (warehouse)::text))
61. 13.860 13.860 ↑ 1.0 1 660

Index Scan using arinv_pkey on arinv (cost=0.42..8.33 rows=1 width=279) (actual time=0.021..0.021 rows=1 loops=660)

  • Index Cond: ((autoid)::text = (multiwarehouse.invoice)::text)
  • Filter: ((is_rma IS NOT TRUE) AND (progress < '80'::numeric) AND (progress < 60.0))
  • Rows Removed by Filter: 0
62. 0.769 12.548 ↑ 47.3 1,235 1

Unique (cost=10,370.43..10,887.03 rows=58,425 width=93) (actual time=11.251..12.548 rows=1,235 loops=1)

63. 5.760 11.779 ↑ 47.3 1,456 1

Sort (cost=10,370.43..10,542.63 rows=68,880 width=93) (actual time=11.250..11.779 rows=1,456 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. 6.019 6.019 ↑ 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.048..6.019 rows=1,456 loops=1)

65. 2,351.220 2,351.220 ↓ 1.9 17,670 526

CTE Scan on vw_invoices_queue (cost=0.00..186.30 rows=9,315 width=169) (actual time=0.552..4.470 rows=17,670 loops=526)

66. 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)
67. 0.348 0.348 ↑ 1.0 1 29

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

  • Index Cond: ((arinv.id)::text = (id)::text)
68. 0.203 0.203 ↓ 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.007..0.007 rows=0 loops=29)

  • Index Cond: (((multiwarehouse.invoice)::text = (invoice)::text) AND ((multiwarehouse.warehouse)::text = (warehouse)::text))
69. 0.493 0.841 ↓ 9.8 49 29

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

70. 0.318 0.348 ↓ 9.8 49 29

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

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

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

  • Filter: (unshelved_time IS NULL)
72. 0.087 0.087 ↑ 1.0 1 29

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

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

SubPlan (forNested Loop)

74. 0.087 0.870 ↑ 1.0 1 29

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

75. 0.174 0.783 ↓ 0.0 0 29

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

76. 0.348 0.609 ↓ 0.0 0 29

Sort (cost=95.38..95.39 rows=1 width=154) (actual time=0.021..0.021 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
77. 0.029 0.261 ↓ 0.0 0 29

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

78. 0.029 0.232 ↓ 0.0 0 29

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

79. 0.029 0.203 ↓ 0.0 0 29

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

80. 0.116 0.174 ↓ 0.0 0 29

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

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

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

  • Filter: ((autoid)::text = (multiwarehouse.warehouse)::text)
  • Rows Removed by Filter: 4
82. 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))
83. 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))
84. 0.000 0.000 ↓ 0.0 0

Index Scan using arinv_pkey on arinv arinv_8 (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))
85. 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)
86. 0.319 0.406 ↑ 1.0 1 29

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

87. 0.058 0.087 ↓ 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.003..0.003 rows=0 loops=29)

  • Recheck Cond: (pick_job = pick_jobs.id)
88. 0.029 0.029 ↓ 0.0 0 29

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

  • Index Cond: (pick_job = pick_jobs.id)
89. 0.725 0.725 ↓ 0.0 0 29

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

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

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

  • Filter: (id = pick_jobs_updated.original_picker)
  • Rows Removed by Filter: 205
Planning time : 13.701 ms
Execution time : 4,916.835 ms