explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CEwe

Settings
# exclusive inclusive rows x rows loops node
1. 0.028 7,812.859 ↓ 14.5 29 1

Subquery Scan on vw_invoices_all_picking (cost=55,041.69..55,041.71 rows=2 width=589) (actual time=7,812.831..7,812.859 rows=29 loops=1)

2. 0.310 7,812.831 ↓ 14.5 29 1

Sort (cost=55,041.69..55,041.69 rows=2 width=593) (actual time=7,812.827..7,812.831 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: 38kB
3. 0.086 7,812.521 ↓ 14.5 29 1

Subquery Scan on vw_invoices_all_base (cost=49,323.47..55,041.68 rows=2 width=593) (actual time=790.082..7,812.521 rows=29 loops=1)

4. 0.682 7,812.435 ↓ 14.5 29 1

Nested Loop Left Join (cost=49,323.47..55,041.65 rows=2 width=589) (actual time=790.078..7,812.435 rows=29 loops=1)

  • Join Filter: ((inwh_1.autoid)::text = (inwh.autoid)::text)
5. 0.100 7,797.659 ↓ 14.5 29 1

Hash Left Join (cost=49,323.47..49,888.52 rows=2 width=560) (actual time=789.555..7,797.659 rows=29 loops=1)

  • Hash Cond: (pick_jobs.id = vw_jobs_shelved.pick_job)
6. 0.080 7,797.434 ↓ 14.5 29 1

Nested Loop Left Join (cost=49,303.58..49,868.62 rows=2 width=552) (actual time=789.418..7,797.434 rows=29 loops=1)

7. 0.693 7,797.122 ↓ 14.5 29 1

Merge Left Join (cost=49,303.31..49,849.16 rows=2 width=548) (actual time=789.401..7,797.122 rows=29 loops=1)

  • Merge Cond: ((arinvdet.doc_aid)::text = (pick_jobs_deleted.original_invoice)::text)
  • Join Filter: ((pick_jobs_deleted.original_warehouse)::text = (inwh_1.autoid)::text)
8. 0.185 7,788.010 ↓ 29.0 29 1

Nested Loop Left Join (cost=47,810.37..48,349.29 rows=1 width=530) (actual time=782.321..7,788.010 rows=29 loops=1)

9. 0.773 7,787.506 ↓ 29.0 29 1

Merge Left Join (cost=47,810.08..48,346.08 rows=1 width=536) (actual time=782.299..7,787.506 rows=29 loops=1)

  • Merge Cond: ((arinvdet.doc_aid)::text = (pick_jobs_updated.original_invoice)::text)
  • Join Filter: ((pick_jobs_updated.original_warehouse)::text = (inwh_1.autoid)::text)
10. 0.091 7,779.363 ↓ 29.0 29 1

Nested Loop Left Join (cost=47,629.00..48,164.69 rows=1 width=532) (actual time=776.355..7,779.363 rows=29 loops=1)

11. 0.157 7,779.214 ↓ 29.0 29 1

Nested Loop (cost=47,628.86..48,164.25 rows=1 width=519) (actual time=776.347..7,779.214 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))
12. 1,763.311 7,778.411 ↓ 17.0 34 1

Nested Loop (cost=47,628.44..48,157.45 rows=2 width=257) (actual time=776.242..7,778.411 rows=34 loops=1)

  • Join Filter: ((arinvdet.doc_aid)::text = (scheduled_invoices.invoice_autoid)::text)
  • Rows Removed by Join Filter: 9202196
13. 1.334 361.543 ↓ 531.0 531 1

Nested Loop Left Join (cost=11,506.40..11,565.42 rows=1 width=88) (actual time=346.381..361.543 rows=531 loops=1)

  • Filter: (pick_jobs.finished IS NULL)
  • Rows Removed by Filter: 129
14. 1.449 350.969 ↓ 94.3 660 1

Group (cost=11,505.99..11,506.24 rows=7 width=49) (actual time=346.323..350.969 rows=660 loops=1)

  • Group Key: arinvdet.doc_aid, inwh_1.autoid
15. 2.213 349.520 ↓ 437.3 3,061 1

Unique (cost=11,505.99..11,506.13 rows=7 width=154) (actual time=346.321..349.520 rows=3,061 loops=1)

16. 15.615 347.307 ↓ 437.3 3,061 1

Sort (cost=11,505.99..11,506.01 rows=7 width=154) (actual time=346.318..347.307 rows=3,061 loops=1)

  • Sort Key: arinvdet.doc_aid, arinvdet.autoid, arinvdet.descr, arinvdet.unit_meas, ((gbl_functions.fn_mainunit_to_uom_qty(inventry.id, arinvdet.unit_meas, arinvdet.quan))::integer), ((NULLIF((arinvdet.gpar_time)::text, ''::text))::character varying), (COALESCE(pick_transactions.qty_shipped, 0))
  • Sort Method: quicksort Memory: 758kB
17. 89.326 331.692 ↓ 437.3 3,061 1

Nested Loop Left Join (cost=1.14..11,505.89 rows=7 width=154) (actual time=1.153..331.692 rows=3,061 loops=1)

18. 3.068 214.817 ↓ 437.3 3,061 1

Nested Loop (cost=0.71..11,499.13 rows=7 width=132) (actual time=1.055..214.817 rows=3,061 loops=1)

19. 1.671 180.739 ↓ 387.6 3,101 1

Nested Loop (cost=0.43..11,496.40 rows=8 width=130) (actual time=1.039..180.739 rows=3,101 loops=1)

  • Join Filter: ((arinvdet.warehouse)::text = (inwh_1.warehouse)::text)
20. 0.015 0.015 ↑ 1.0 1 1

Seq Scan on inwh inwh_1 (cost=0.00..1.05 rows=1 width=64) (actual time=0.013..0.015 rows=1 loops=1)

  • Filter: ((autoid)::text = '2GA89EVTVE3SGAD1'::text)
  • Rows Removed by Filter: 3
21. 4.176 179.053 ↓ 81.6 3,101 1

Nested Loop (cost=0.43..11,494.87 rows=38 width=105) (actual time=1.023..179.053 rows=3,101 loops=1)

22. 162.907 162.907 ↓ 83.1 665 1

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

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

Index Scan using arinvdet_docaid_idx on arinvdet (cost=0.43..68.79 rows=6 width=105) (actual time=0.013..0.018 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
24. 31.010 31.010 ↑ 1.0 1 3,101

Index Scan using idx_btree_inventry_id on inventry (cost=0.29..0.33 rows=1 width=12) (actual time=0.009..0.010 rows=1 loops=3,101)

  • Index Cond: ((id)::text = (arinvdet.inven)::text)
  • Filter: (((c_type <> 1.0) OR (auto_cost IS NOT TRUE)) AND (discou_typ <= 0))
  • Rows Removed by Filter: 0
25. 27.549 27.549 ↓ 0.0 0 3,061

Index Scan using uc_item on pick_transactions (cost=0.42..0.71 rows=1 width=21) (actual time=0.009..0.009 rows=0 loops=3,061)

  • Index Cond: ((arinvdet.autoid)::text = (item)::text)
26. 9.240 9.240 ↓ 0.0 0 660

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

  • Index Cond: (((arinvdet.doc_aid)::text = (invoice)::text) AND ((inwh_1.autoid)::text = (warehouse)::text) AND ((warehouse)::text = '2GA89EVTVE3SGAD1'::text))
27. 2,503.665 5,653.557 ↓ 1.9 17,330 531

Append (cost=36,122.03..36,390.61 rows=8,952 width=209) (actual time=0.097..10.647 rows=17,330 loops=531)

28.          

CTE scheduled_invoices

29. 1.075 143.501 ↑ 1.8 160 1

Nested Loop Left Join (cost=2,115.72..12,945.81 rows=291 width=124) (actual time=51.181..143.501 rows=160 loops=1)

30. 0.188 142.106 ↑ 1.8 160 1

Hash Left Join (cost=2,115.44..12,839.53 rows=291 width=147) (actual time=51.129..142.106 rows=160 loops=1)

  • Hash Cond: ((arinv_3.company = (invoice.company)::text) AND ((arinv_3.invoice)::text = (invoice.invoice_id)::text))
31. 0.530 124.769 ↑ 1.8 160 1

Hash Left Join (cost=1,475.87..12,176.11 rows=291 width=144) (actual time=33.966..124.769 rows=160 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: 5
32. 0.405 98.591 ↑ 1.9 165 1

Subquery Scan on arinv_3 (cost=0.00..10,697.67 rows=313 width=232) (actual time=8.160..98.591 rows=165 loops=1)

  • Filter: (arinv_3.progress >= '40'::numeric)
  • Rows Removed by Filter: 718
33. 0.368 98.186 ↑ 1.1 883 1

Append (cost=0.00..10,685.94 rows=938 width=1,206) (actual time=0.656..98.186 rows=883 loops=1)

34. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..0.00 rows=0 width=1,206) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false
35. 0.001 0.002 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_1 (cost=0.00..0.00 rows=1 width=1,206) (actual time=0.001..0.002 rows=0 loops=1)

36. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..0.00 rows=0 width=1,206) (actual time=0.000..0.001 rows=0 loops=1)

  • One-Time Filter: false
37. 97.813 97.813 ↑ 1.1 883 1

Seq Scan on arinv arinv_4 (cost=0.00..10,676.59 rows=935 width=447) (actual time=0.651..97.813 rows=883 loops=1)

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

Subquery Scan on *SELECT* 4 (cost=0.00..0.00 rows=1 width=1,206) (actual time=0.002..0.002 rows=0 loops=1)

39. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..0.00 rows=0 width=1,178) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false
40. 14.851 25.648 ↑ 1.0 32,577 1

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

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

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

42. 5.938 17.149 ↓ 58.0 8,059 1

Hash (cost=637.48..637.48 rows=139 width=23) (actual time=17.149..17.149 rows=8,059 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 506kB
43. 11.211 11.211 ↓ 58.0 8,059 1

Seq Scan on invoice (cost=0.00..637.48 rows=139 width=23) (actual time=0.025..11.211 rows=8,059 loops=1)

  • Filter: ((company)::text = 'KFR'::text)
  • Rows Removed by Filter: 19840
44. 0.320 0.320 ↑ 1.0 1 160

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

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

CTE rushed_invoices

46. 164.298 164.356 ↑ 6.0 1 1

Seq Scan on arinv arinv_5 (cost=6.55..11,218.17 rows=6 width=21) (actual time=80.457..164.356 rows=1 loops=1)

  • Filter: (is_rushed AND (progress >= '30'::numeric) AND (NOT (hashed SubPlan 6)) AND ((status)::text = 'U'::text))
  • Rows Removed by Filter: 107008
47.          

SubPlan (forSeq Scan)

48. 0.058 0.058 ↑ 1.8 160 1

CTE Scan on scheduled_invoices scheduled_invoices_1 (cost=0.00..5.82 rows=291 width=32) (actual time=0.001..0.058 rows=160 loops=1)

49.          

CTE pick_jobs

50. 89.549 89.642 ↓ 2.0 17,169 1

Seq Scan on pick_jobs pick_jobs_2 (cost=6.68..11,958.06 rows=8,655 width=17) (actual time=22.455..89.642 rows=17,169 loops=1)

  • Filter: (NOT (hashed SubPlan 8))
  • Rows Removed by Filter: 140
51.          

SubPlan (forSeq Scan)

52. 0.043 0.093 ↑ 1.8 161 1

Append (cost=0.00..5.94 rows=297 width=32) (actual time=0.003..0.093 rows=161 loops=1)

53. 0.049 0.049 ↑ 1.8 160 1

CTE Scan on scheduled_invoices scheduled_invoices_2 (cost=0.00..5.82 rows=291 width=32) (actual time=0.002..0.049 rows=160 loops=1)

54. 0.001 0.001 ↑ 6.0 1 1

CTE Scan on rushed_invoices rushed_invoices_1 (cost=0.00..0.12 rows=6 width=32) (actual time=0.001..0.001 rows=1 loops=1)

55. 174.168 174.168 ↑ 1.8 160 531

CTE Scan on scheduled_invoices (cost=0.00..5.82 rows=291 width=235) (actual time=0.097..0.328 rows=160 loops=531)

56. 0.531 165.141 ↑ 6.0 1 531

Subquery Scan on *SELECT* 2 (cost=0.00..0.20 rows=6 width=209) (actual time=0.153..0.311 rows=1 loops=531)

57. 164.610 164.610 ↑ 6.0 1 531

CTE Scan on rushed_invoices (cost=0.00..0.12 rows=6 width=205) (actual time=0.152..0.310 rows=1 loops=531)

58. 2,810.583 2,810.583 ↓ 2.0 17,169 531

CTE Scan on pick_jobs pick_jobs_1 (cost=0.00..173.10 rows=8,655 width=209) (actual time=0.043..5.293 rows=17,169 loops=531)

59. 0.646 0.646 ↑ 1.0 1 34

Index Scan using arinv_pkey on arinv (cost=0.42..3.38 rows=1 width=279) (actual time=0.019..0.019 rows=1 loops=34)

  • 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: 0
60. 0.058 0.058 ↓ 0.0 0 29

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

  • Index Cond: (pick_jobs."current_user" = id)
61. 0.410 7.370 ↓ 80.9 1,213 1

Materialize (cost=181.08..181.34 rows=15 width=71) (actual time=5.925..7.370 rows=1,213 loops=1)

62. 0.611 6.960 ↓ 80.9 1,213 1

Unique (cost=181.08..181.15 rows=15 width=79) (actual time=5.921..6.960 rows=1,213 loops=1)

63. 5.646 6.349 ↓ 95.8 1,437 1

Sort (cost=181.08..181.12 rows=15 width=79) (actual time=5.920..6.349 rows=1,437 loops=1)

  • Sort Key: pick_jobs_updated.original_invoice, pick_jobs_updated.time_updated DESC NULLS LAST
  • Sort Method: quicksort Memory: 170kB
64. 0.484 0.703 ↓ 103.3 1,550 1

Bitmap Heap Scan on pick_jobs_updated (cost=127.47..180.79 rows=15 width=79) (actual time=0.227..0.703 rows=1,550 loops=1)

  • Recheck Cond: ((original_warehouse)::text = '2GA89EVTVE3SGAD1'::text)
  • Heap Blocks: exact=19
65. 0.219 0.219 ↓ 103.3 1,550 1

Bitmap Index Scan on idx_btree_originalinvoice_originalwarehouse_timeupdated (cost=0.00..127.46 rows=15 width=0) (actual time=0.218..0.219 rows=1,550 loops=1)

  • Index Cond: ((original_warehouse)::text = '2GA89EVTVE3SGAD1'::text)
66. 0.319 0.319 ↑ 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.011 rows=1 loops=29)

  • Index Cond: ((arinv.id)::text = (id)::text)
67. 0.391 8.419 ↓ 3.3 1,135 1

Materialize (cost=1,492.94..1,498.98 rows=345 width=85) (actual time=7.057..8.419 rows=1,135 loops=1)

68. 0.594 8.028 ↓ 3.3 1,135 1

Unique (cost=1,492.94..1,494.67 rows=345 width=93) (actual time=7.055..8.028 rows=1,135 loops=1)

69. 5.422 7.434 ↓ 3.9 1,337 1

Sort (cost=1,492.94..1,493.81 rows=345 width=93) (actual time=7.051..7.434 rows=1,337 loops=1)

  • Sort Key: pick_jobs_deleted.original_invoice, pick_jobs_deleted.time_deleted DESC NULLS LAST
  • Sort Method: quicksort Memory: 164kB
70. 2.012 2.012 ↓ 4.2 1,457 1

Seq Scan on pick_jobs_deleted (cost=0.00..1,478.40 rows=345 width=93) (actual time=0.030..2.012 rows=1,457 loops=1)

  • Filter: ((original_warehouse)::text = '2GA89EVTVE3SGAD1'::text)
71. 0.232 0.232 ↓ 0.0 0 29

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

  • Index Cond: (((arinvdet.doc_aid)::text = (invoice)::text) AND ((inwh_1.autoid)::text = (warehouse)::text) AND ((warehouse)::text = '2GA89EVTVE3SGAD1'::text))
72. 0.029 0.125 ↓ 9.8 49 1

Hash (cost=19.83..19.83 rows=5 width=12) (actual time=0.125..0.125 rows=49 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
73. 0.019 0.096 ↓ 9.8 49 1

Subquery Scan on vw_jobs_shelved (cost=19.76..19.83 rows=5 width=12) (actual time=0.051..0.096 rows=49 loops=1)

74. 0.019 0.077 ↓ 9.8 49 1

Unique (cost=19.76..19.78 rows=5 width=44) (actual time=0.050..0.077 rows=49 loops=1)

75. 0.030 0.058 ↓ 9.8 49 1

Sort (cost=19.76..19.77 rows=5 width=44) (actual time=0.050..0.058 rows=49 loops=1)

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

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

  • Filter: (unshelved_time IS NULL)
77. 0.017 0.029 ↑ 1.0 1 29

Materialize (cost=0.00..1.05 rows=1 width=64) (actual time=0.001..0.001 rows=1 loops=29)

78. 0.012 0.012 ↑ 1.0 1 1

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

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

SubPlan (forNested Loop Left Join)

80. 0.116 12.006 ↑ 1.0 1 29

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

81. 0.232 11.890 ↓ 4.0 4 29

Unique (cost=95.38..95.40 rows=1 width=154) (actual time=0.407..0.410 rows=4 loops=29)

82. 0.667 11.658 ↓ 4.0 4 29

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

  • Sort Key: arinvdet_1.autoid, arinvdet_1.descr, arinvdet_1.unit_meas, ((gbl_functions.fn_mainunit_to_uom_qty(inventry_1.id, arinvdet_1.unit_meas, arinvdet_1.quan))::integer), ((NULLIF((arinvdet_1.gpar_time)::text, ''::text))::character varying), (COALESCE(pick_transactions_1.qty_shipped, 0))
  • Sort Method: quicksort Memory: 28kB
83. 5.064 10.991 ↓ 4.0 4 29

Nested Loop Left Join (cost=1.55..95.37 rows=1 width=154) (actual time=0.162..0.379 rows=4 loops=29)

84. 0.251 4.640 ↓ 4.0 4 29

Nested Loop (cost=1.13..86.68 rows=1 width=132) (actual time=0.072..0.160 rows=4 loops=29)

85. 0.177 3.219 ↓ 4.0 4 29

Nested Loop (cost=0.71..78.23 rows=1 width=132) (actual time=0.058..0.111 rows=4 loops=29)

86. 0.667 1.508 ↓ 4.0 4 29

Nested Loop (cost=0.43..69.91 rows=1 width=130) (actual time=0.040..0.052 rows=4 loops=29)

  • Join Filter: ((arinvdet_1.warehouse)::text = (inwh_2.warehouse)::text)
87. 0.145 0.145 ↑ 1.0 1 29

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

  • Filter: ((autoid)::text = (inwh_1.autoid)::text)
  • Rows Removed by Filter: 3
88. 0.696 0.696 ↑ 1.5 4 29

Index Scan using arinvdet_docaid_idx on arinvdet arinvdet_1 (cost=0.43..68.79 rows=6 width=105) (actual time=0.018..0.024 rows=4 loops=29)

  • Index Cond: ((doc_aid)::text = (arinvdet.doc_aid)::text)
  • Filter: ((quan > 0.0) AND ((id)::text !~~ '($)%'::text))
  • Rows Removed by Filter: 0
89. 1.534 1.534 ↑ 1.0 1 118

Index Scan using idx_btree_inventry_id on inventry inventry_1 (cost=0.29..8.31 rows=1 width=12) (actual time=0.012..0.013 rows=1 loops=118)

  • Index Cond: ((id)::text = (arinvdet_1.inven)::text)
  • Filter: (((c_type <> 1.0) OR (auto_cost IS NOT TRUE)) AND (discou_typ <= 0))
  • Rows Removed by Filter: 0
90. 1.170 1.170 ↑ 1.0 1 117

Index Scan using arinv_pkey on arinv arinv_2 (cost=0.42..8.44 rows=1 width=17) (actual time=0.010..0.010 rows=1 loops=117)

  • Index Cond: ((autoid)::text = (arinvdet.doc_aid)::text)
  • Filter: ((is_rma IS NOT TRUE) AND (progress < '80'::numeric) AND ((status)::text = 'U'::text))
91. 1.287 1.287 ↓ 0.0 0 117

Index Scan using uc_item on pick_transactions pick_transactions_1 (cost=0.42..8.44 rows=1 width=21) (actual time=0.011..0.011 rows=0 loops=117)

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

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

93. 0.087 0.203 ↑ 689.0 1 29

Bitmap Heap Scan on pick_transactions pick_transactions_2 (cost=13.76..2,465.72 rows=689 width=17) (actual time=0.007..0.007 rows=1 loops=29)

  • Recheck Cond: (pick_job = pick_jobs.id)
  • Heap Blocks: exact=6
94. 0.116 0.116 ↑ 689.0 1 29

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

  • Index Cond: (pick_job = pick_jobs.id)
95. 0.812 0.812 ↓ 0.0 0 29

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

  • Filter: (id = pick_jobs_deleted.original_picker)
  • Rows Removed by Filter: 205
96. 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 : 14.333 ms
Execution time : 7,815.044 ms