explain.depesz.com

PostgreSQL's explain analyze made readable

Result: q3dA : dasdadas

Settings
# exclusive inclusive rows x rows loops node
1. 55.160 20,669.851 ↑ 2,052.5 54,720 1

Hash Left Join (cost=30,045,225,815.34..345,693,397,414.39 rows=112,311,123 width=329) (actual time=11,661.658..20,669.851 rows=54,720 loops=1)

  • Hash Cond: (("UAT EMI Central$Cust_ Ledger Entry_1"."Document No_")::text = ("UAT EMI Central$Sales Cr_Memo Header"."No_")::text)
  • Buffers: shared hit=12,095,382 read=190,468, temp read=20,172 written=20,182
  • I/O Timings: read=674.377
2.          

Initplan (for Hash Left Join)

3. 0.112 0.112 ↑ 1.0 1 1

Index Scan using "Company_pkey" on "Company" (cost=0.14..8.15 rows=1 width=4) (actual time=0.020..0.112 rows=1 loops=1)

  • Index Cond: (("Name")::text = 'UAT EMI Central'::text)
  • Buffers: shared read=2
  • I/O Timings: read=0.012
4. 29.078 19,457.503 ↑ 148.8 54,720 1

Hash Left Join (cost=30,045,225,590.01..79,080,453,785.90 rows=8,141,437 width=414) (actual time=11,660.267..19,457.503 rows=54,720 loops=1)

  • Hash Cond: (("UAT EMI Central$Cust_ Ledger Entry_1"."Document No_")::text = (ah1cle."Document No_")::text)
  • Buffers: shared hit=10,228,832 read=183,654, temp read=20,172 written=20,182
  • I/O Timings: read=646.108
5. 261.744 16,748.935 ↑ 148.8 54,720 1

Hash Left Join (cost=30,000,340,444.02..79,035,546,815.77 rows=8,141,437 width=382) (actual time=8,983.121..16,748.935 rows=54,720 loops=1)

  • Hash Cond: ("UAT EMI Central$Cust_ Ledger Entry_1"."Entry No_" = ahcle."Cust_ Ledger Entry No_")
  • Buffers: shared hit=7,887,416 read=127,606, temp read=19,552 written=19,562
  • I/O Timings: read=454.300
6. 229.889 9,521.242 ↑ 148.8 54,720 1

Hash Left Join (cost=30,000,098,755.05..79,035,283,302.66 rows=8,141,437 width=354) (actual time=2,018.476..9,521.242 rows=54,720 loops=1)

  • Hash Cond: (("UAT EMI Central$Cust_ Ledger Entry"."Document No_")::text = (adwsr2."Document No_")::text)
  • Buffers: shared hit=5,268,026 read=69,649, temp read=9,158 written=9,168
  • I/O Timings: read=238.261
7. 29.628 8,114.787 ↑ 148.8 54,720 1

Merge Left Join (cost=30,000,044,898.49..79,035,207,621.97 rows=8,141,437 width=361) (actual time=776.029..8,114.787 rows=54,720 loops=1)

  • Merge Cond: (("UAT EMI Central$Sales Invoice Header"."No_")::text = ("UAT EMI Central$Cust_ Ledger Entry_2"."Document No_")::text)
  • Buffers: shared hit=5,267,991 read=59,907, temp read=2,135 written=2,145
  • I/O Timings: read=208.545
8. 43.963 7,101.880 ↑ 148.8 54,720 1

Merge Left Join (cost=30,000,044,896.02..70,250,954,257.30 rows=8,141,437 width=329) (actual time=751.219..7,101.880 rows=54,720 loops=1)

  • Merge Cond: (("UAT EMI Central$Sales Invoice Header"."No_")::text = ("UAT EMI Central$Sales Invoice Line"."Document No_")::text)
  • Buffers: shared hit=4,220,606 read=53,737, temp read=2,135 written=2,145
  • I/O Timings: read=185.792
9. 17.659 3,484.339 ↑ 148.8 54,720 1

Merge Left Join (cost=20,000,044,893.85..60,250,502,084.66 rows=8,141,437 width=233) (actual time=378.425..3,484.339 rows=54,720 loops=1)

  • Merge Cond: (("UAT EMI Central$Cust_ Ledger Entry"."Document No_")::text = (adwsr."Document No_")::text)
  • Buffers: shared hit=2,337,228 read=50,247, temp read=2,135 written=2,145
  • I/O Timings: read=172.078
10. 46.120 3,463.580 ↑ 148.8 54,720 1

Nested Loop Left Join (cost=20,000,044,716.23..60,250,400,138.08 rows=8,141,437 width=217) (actual time=377.391..3,463.580 rows=54,720 loops=1)

  • Buffers: shared hit=2,337,227 read=50,234, temp read=2,135 written=2,145
  • I/O Timings: read=172.024
11. 41.031 3,362.740 ↑ 44.0 54,720 1

Nested Loop Left Join (cost=20,000,044,715.80..60,243,873,694.24 rows=2,407,170 width=186) (actual time=377.379..3,362.740 rows=54,720 loops=1)

  • Join Filter: (('EMI Central'::text) = ('EMI Central'::text))
  • Rows Removed by Join Filter: 448
  • Buffers: shared hit=2,337,227 read=50,234, temp read=2,135 written=2,145
  • I/O Timings: read=172.024
12. 51.216 3,102.829 ↑ 44.0 54,720 1

Nested Loop Left Join (cost=20,000,044,715.65..60,240,667,769.47 rows=2,407,170 width=208) (actual time=377.306..3,102.829 rows=54,720 loops=1)

  • Buffers: shared hit=1,899,010 read=50,123, temp read=2,135 written=2,145
  • I/O Timings: read=171.508
13. 92.346 2,942.173 ↑ 44.0 54,720 1

Merge Join (cost=20,000,044,715.36..60,239,919,859.44 rows=2,407,170 width=202) (actual time=377.274..2,942.173 rows=54,720 loops=1)

  • Merge Cond: (("UAT EMI Central$Cust_ Ledger Entry"."Document No_")::text = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Join Filter: CASE WHEN ((SubPlan 10) > 1) THEN CASE WHEN (('EMI Central'::text) = 'EMI Central'::text) THEN true ELSE false END ELSE true END
  • Rows Removed by Join Filter: 14,835
  • Buffers: shared hit=1,734,936 read=49,923, temp read=2,135 written=2,145
  • I/O Timings: read=170.699
14. 105.050 1,824.878 ↓ 19.6 153,581 1

Nested Loop Left Join (cost=10,000,000,002.05..50,000,266,852.01 rows=7,844 width=157) (actual time=14.626..1,824.878 rows=153,581 loops=1)

  • Buffers: shared hit=858,826 read=48,080
  • I/O Timings: read=164.822
15. 169.340 1,566.247 ↓ 19.6 153,581 1

Nested Loop (cost=10,000,000,001.62..50,000,262,198.22 rows=7,844 width=132) (actual time=14.592..1,566.247 rows=153,581 loops=1)

  • Join Filter: (('EMI Central'::text) = ('EMI Central'::text))
  • Rows Removed by Join Filter: 614,324
  • Buffers: shared hit=398,084 read=48,032
  • I/O Timings: read=164.614
16. 25.953 1,396.907 ↑ 2.0 153,581 1

Merge Append (cost=1.62..238,662.63 rows=313,740 width=74) (actual time=14.573..1,396.907 rows=153,581 loops=1)

  • Sort Key: "UAT EMI Central$Cust_ Ledger Entry"."Document No_", "UAT EMI Central$Cust_ Ledger Entry"."Entry No_
  • Buffers: shared hit=398,084 read=48,027
  • I/O Timings: read=164.595
17. 1,345.908 1,345.908 ↑ 2.3 136,571 1

Index Scan using "UAT_EMI_Central$Cust_Ledger_Entry_Document_No1__IDX" on "UAT EMI Central$Cust_ Ledger Entry" (cost=0.43..229,029.51 rows=308,070 width=74) (actual time=14.486..1,345.908 rows=136,571 loops=1)

  • Filter: (("Document Type" = 2) AND (("Document Date")::date >= (CURRENT_DATE - '2 years'::interval)))
  • Rows Removed by Filter: 2,152,214
  • Buffers: shared hit=396,781 read=47,660
  • I/O Timings: read=163.222
18. 6.240 6.240 ↓ 3.0 4,070 1

Index Scan using "UAT WAG BE$Cust_Ledger_Entry_Document_No1__IDX" on "UAT WAG BE$Cust_ Ledger Entry" (cost=0.29..1,121.91 rows=1,357 width=73) (actual time=0.031..6.240 rows=4,070 loops=1)

  • Filter: (("Document Type" = 2) AND (("Document Date")::date >= (CURRENT_DATE - '2 years'::interval)))
  • Rows Removed by Filter: 7,702
  • Buffers: shared hit=221 read=76
  • I/O Timings: read=0.271
19. 4.511 4.511 ↓ 3.0 3,118 1

Index Scan using "UAT WAG ES$Cust_Ledger_Entry_Document_No1__IDX" on "UAT WAG ES$Cust_ Ledger Entry" (cost=0.29..768.78 rows=1,039 width=73) (actual time=0.017..4.511 rows=3,118 loops=1)

  • Filter: (("Document Type" = 2) AND (("Document Date")::date >= (CURRENT_DATE - '2 years'::interval)))
  • Rows Removed by Filter: 5,920
  • Buffers: shared hit=128 read=83
  • I/O Timings: read=0.310
20. 13.488 13.488 ↓ 3.0 9,293 1

Index Scan using "UAT WAG FR$Cust_Ledger_Entry_Document_No1__IDX" on "UAT WAG FR$Cust_ Ledger Entry" (cost=0.29..2,448.95 rows=3,098 width=73) (actual time=0.018..13.488 rows=9,293 loops=1)

  • Filter: (("Document Type" = 2) AND (("Document Date")::date >= (CURRENT_DATE - '2 years'::interval)))
  • Rows Removed by Filter: 17,764
  • Buffers: shared hit=895 read=204
  • I/O Timings: read=0.772
21. 0.807 0.807 ↓ 3.0 529 1

Index Scan using "UAT_WAG_CZ$Cust_Ledger_Entry_Document_No1__IDX" on "UAT WAG CZ$Cust_ Ledger Entry" (cost=0.28..82.31 rows=176 width=73) (actual time=0.018..0.807 rows=529 loops=1)

  • Filter: (("Document Type" = 2) AND (("Document Date")::date >= (CURRENT_DATE - '2 years'::interval)))
  • Rows Removed by Filter: 163
  • Buffers: shared hit=59 read=4
  • I/O Timings: read=0.019
22. 0.000 0.000 ↑ 1.0 5 153,581

Materialize (cost=10,000,000,000.00..50,000,000,005.10 rows=5 width=90) (actual time=0.000..0.000 rows=5 loops=153,581)

  • Buffers: shared read=5
  • I/O Timings: read=0.019
23. 0.769 1.161 ↑ 1.0 5 1

Append (cost=10,000,000,000.00..50,000,000,005.08 rows=5 width=90) (actual time=0.014..1.161 rows=5 loops=1)

  • Buffers: shared read=5
  • I/O Timings: read=0.019
24. 0.084 0.084 ↑ 1.0 1 1

Seq Scan on "UAT EMI Central$General Ledger Setup" (cost=10,000,000,000.00..10,000,000,001.01 rows=1 width=90) (actual time=0.012..0.084 rows=1 loops=1)

  • Buffers: shared read=1
  • I/O Timings: read=0.004
25. 0.087 0.087 ↑ 1.0 1 1

Seq Scan on "UAT WAG BE$General Ledger Setup" (cost=10,000,000,000.00..10,000,000,001.01 rows=1 width=90) (actual time=0.030..0.087 rows=1 loops=1)

  • Buffers: shared read=1
  • I/O Timings: read=0.004
26. 0.078 0.078 ↑ 1.0 1 1

Seq Scan on "UAT WAG ES$General Ledger Setup" (cost=10,000,000,000.00..10,000,000,001.01 rows=1 width=90) (actual time=0.010..0.078 rows=1 loops=1)

  • Buffers: shared read=1
  • I/O Timings: read=0.003
27. 0.082 0.082 ↑ 1.0 1 1

Seq Scan on "UAT WAG FR$General Ledger Setup" (cost=10,000,000,000.00..10,000,000,001.01 rows=1 width=90) (actual time=0.011..0.082 rows=1 loops=1)

  • Buffers: shared read=1
  • I/O Timings: read=0.004
28. 0.061 0.061 ↑ 1.0 1 1

Seq Scan on "UAT WAG CZ$General Ledger Setup" (cost=10,000,000,000.00..10,000,000,001.01 rows=1 width=90) (actual time=0.009..0.061 rows=1 loops=1)

  • Buffers: shared read=1
  • I/O Timings: read=0.004
29. 153.581 153.581 ↓ 0.0 0 153,581

Index Scan using assignment_history_source_customer_entry_no__idx on "Assignment History" ap (cost=0.42..0.58 rows=1 width=25) (actual time=0.001..0.001 rows=0 loops=153,581)

  • Index Cond: (("Source Customer Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_") AND ("Source Company ID" = $12))
  • Buffers: shared hit=460,742 read=46
  • I/O Timings: read=0.196
30. 16.507 398.954 ↓ 1.1 137,594 1

Materialize (cost=10,000,044,713.32..10,000,045,327.12 rows=122,760 width=77) (actual time=347.692..398.954 rows=137,594 loops=1)

  • Buffers: shared hit=11,154 read=1,699, temp read=2,135 written=2,145
  • I/O Timings: read=5.207
31. 126.183 382.447 ↑ 1.0 122,759 1

Sort (cost=10,000,044,713.32..10,000,045,020.22 rows=122,760 width=77) (actual time=347.690..382.447 rows=122,759 loops=1)

  • Sort Key: "UAT EMI Central$Sales Invoice Header"."No_
  • Sort Method: external merge Disk: 8,896kB
  • Buffers: shared hit=11,154 read=1,699, temp read=2,135 written=2,145
  • I/O Timings: read=5.207
32. 43.959 256.264 ↑ 1.0 122,760 1

Merge Left Join (cost=10,000,025,869.32..10,000,028,880.23 rows=122,760 width=77) (actual time=152.289..256.264 rows=122,760 loops=1)

  • Merge Cond: (("UAT EMI Central$Sales Invoice Header"."Bill-to Customer No_")::text = (outerlim."Customer No_")::text)
  • Buffers: shared hit=11,154 read=1,699, temp read=1,023 written=1,028
  • I/O Timings: read=5.207
33. 113.718 160.286 ↑ 1.0 122,760 1

Sort (cost=22,773.52..23,080.42 rows=122,760 width=71) (actual time=132.780..160.286 rows=122,760 loops=1)

  • Sort Key: "UAT EMI Central$Sales Invoice Header"."Bill-to Customer No_
  • Sort Method: external merge Disk: 8,184kB
  • Buffers: shared hit=11,046 read=1,616, temp read=1,023 written=1,028
  • I/O Timings: read=4.972
34. 11.038 46.568 ↑ 1.0 122,760 1

Append (cost=0.42..7,360.43 rows=122,760 width=71) (actual time=0.033..46.568 rows=122,760 loops=1)

  • Buffers: shared hit=11,046 read=1,616
  • I/O Timings: read=4.972
35. 30.733 30.733 ↑ 1.0 105,738 1

Index Scan using "UAT_EMI_Central$Sales_Invoice_Header_No__IDX" on "UAT EMI Central$Sales Invoice Header" (cost=0.42..6,009.56 rows=105,738 width=71) (actual time=0.032..30.733 rows=105,738 loops=1)

  • Buffers: shared hit=10,989 read=1,384
  • I/O Timings: read=4.228
36. 1.133 1.133 ↑ 1.0 4,072 1

Index Scan using "UAT WAG BE$Sales_Invoice_Header_No__IDX" on "UAT WAG BE$Sales Invoice Header" (cost=0.28..181.89 rows=4,072 width=72) (actual time=0.047..1.133 rows=4,072 loops=1)

  • Buffers: shared hit=10 read=56
  • I/O Timings: read=0.183
37. 0.893 0.893 ↑ 1.0 3,120 1

Index Scan using "UAT WAG ES$Sales_Invoice_Header_No__IDX" on "UAT WAG ES$Sales Invoice Header" (cost=0.28..136.11 rows=3,120 width=72) (actual time=0.032..0.893 rows=3,120 loops=1)

  • Buffers: shared hit=20 read=43
  • I/O Timings: read=0.130
38. 2.554 2.554 ↑ 1.0 9,300 1

Index Scan using "UAT WAG FR$Sales_Invoice_Header_No__IDX" on "UAT WAG FR$Sales Invoice Header" (cost=0.29..381.91 rows=9,300 width=72) (actual time=0.055..2.554 rows=9,300 loops=1)

  • Buffers: shared hit=23 read=124
  • I/O Timings: read=0.388
39. 0.217 0.217 ↑ 1.0 530 1

Index Scan using "UAT_WAG_CZ$Sales_Invoice_Header_No__IDX" on "UAT WAG CZ$Sales Invoice Header" (cost=0.28..37.16 rows=530 width=72) (actual time=0.034..0.217 rows=530 loops=1)

  • Buffers: shared hit=4 read=9
  • I/O Timings: read=0.042
40. 9.472 52.019 ↓ 14.6 133,491 1

Materialize (cost=10,000,003,095.81..10,000,004,623.02 rows=9,118 width=12) (actual time=19.503..52.019 rows=133,491 loops=1)

  • Buffers: shared hit=108 read=83
  • I/O Timings: read=0.235
41. 2.891 42.547 ↓ 2.1 18,808 1

Subquery Scan on outerlim (cost=10,000,003,095.81..10,000,004,600.22 rows=9,118 width=12) (actual time=19.500..42.547 rows=18,808 loops=1)

  • Filter: (outerlim.rn <= 1)
  • Rows Removed by Filter: 8,545
  • Buffers: shared hit=108 read=83
  • I/O Timings: read=0.235
42. 16.479 39.656 ↑ 1.0 27,353 1

WindowAgg (cost=10,000,003,095.81..10,000,004,258.31 rows=27,353 width=126) (actual time=19.498..39.656 rows=27,353 loops=1)

  • Buffers: shared hit=108 read=83
  • I/O Timings: read=0.235
43. 17.204 23.177 ↑ 1.0 27,353 1

Sort (cost=10,000,003,095.81..10,000,003,164.19 rows=27,353 width=16) (actual time=19.486..23.177 rows=27,353 loops=1)

  • Sort Key: lim."Customer No_", (CASE WHEN ((lim."Behaviour Code")::text = 'EW_ONE'::text) THEN 1 WHEN ((lim."Behaviour Code")::text = 'EW_FLEET'::text) THEN 2 WHEN ((lim."Behaviour Code")::text = 'EW_VECTOR_HAULIER'::text) THEN 3 WHEN ((lim."Behaviour Code")::text = 'EW_EASY_FUEL'::text) THEN 4 WHEN ((lim."Behaviour Code")::text = 'EW_EASY_TOLL'::text) THEN 5 WHEN ((lim."Behaviour Code")::text = 'EWMC'::text) THEN 6 WHEN ((lim."Behaviour Code")::text = 'EW_ONE'::text) THEN 7 WHEN ((lim."Behaviour Code")::text = 'EW_VECTOR_FORWARDER'::text) THEN 8 WHEN ((lim."Behaviour Code")::text = 'PRINCIP'::text) THEN 9 ELSE NULL::integer END)
  • Sort Method: quicksort Memory: 2,894kB
  • Buffers: shared hit=108 read=83
  • I/O Timings: read=0.235
44. 5.973 5.973 ↑ 1.0 27,353 1

Seq Scan on "Limit" lim (cost=10,000,000,000.00..10,000,001,079.97 rows=27,353 width=16) (actual time=0.025..5.973 rows=27,353 loops=1)

  • Buffers: shared hit=108 read=83
  • I/O Timings: read=0.235
45.          

SubPlan (for Merge Join)

46. 69.555 625.995 ↑ 1.0 1 69,555

Aggregate (cost=49.74..49.75 rows=1 width=8) (actual time=0.009..0.009 rows=1 loops=69,555)

  • Buffers: shared hit=864,956 read=144
  • I/O Timings: read=0.671
47. 139.110 556.440 ↑ 7.0 1 69,555

Append (cost=0.43..49.72 rows=7 width=0) (actual time=0.003..0.008 rows=1 loops=69,555)

  • Buffers: shared hit=864,956 read=144
  • I/O Timings: read=0.671
48. 139.110 139.110 ↑ 3.0 1 69,555

Index Only Scan using "UAT_EMI_Central$Cust_Ledger_Entry_Document_No__IDX" on "UAT EMI Central$Cust_ Ledger Entry" "UAT EMI Central$Cust_ Ledger Entry_6" (cost=0.43..16.48 rows=3 width=0) (actual time=0.002..0.002 rows=1 loops=69,555)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 67,488
  • Buffers: shared hit=276,475 read=102
  • I/O Timings: read=0.481
49. 69.555 69.555 ↓ 0.0 0 69,555

Index Only Scan using "UAT WAG BE$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG BE$Cust_ Ledger Entry" "UAT WAG BE$Cust_ Ledger Entry_6" (cost=0.29..8.30 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=69,555)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 7,276
  • Buffers: shared hit=146,430 read=10
  • I/O Timings: read=0.047
50. 69.555 69.555 ↓ 0.0 0 69,555

Index Only Scan using "UAT WAG ES$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG ES$Cust_ Ledger Entry" "UAT WAG ES$Cust_ Ledger Entry_6" (cost=0.29..8.30 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=69,555)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 6,073
  • Buffers: shared hit=145,214 read=13
  • I/O Timings: read=0.060
51. 69.555 69.555 ↓ 0.0 0 69,555

Index Only Scan using "UAT WAG FR$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG FR$Cust_ Ledger Entry" "UAT WAG FR$Cust_ Ledger Entry_6" (cost=0.29..8.30 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=69,555)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 17,887
  • Buffers: shared hit=157,118 read=15
  • I/O Timings: read=0.064
52. 69.555 69.555 ↓ 0.0 0 69,555

Index Only Scan using "UAT_WAG_CZ$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG CZ$Cust_ Ledger Entry" "UAT WAG CZ$Cust_ Ledger Entry_6" (cost=0.28..8.29 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=69,555)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 609
  • Buffers: shared hit=139,719 read=4
  • I/O Timings: read=0.018
53. 109.440 109.440 ↑ 1.0 1 54,720

Index Scan using "Customer_pkey" on "Customer" cus (cost=0.29..0.31 rows=1 width=18) (actual time=0.002..0.002 rows=1 loops=54,720)

  • Index Cond: (("UAT EMI Central$Sales Invoice Header"."Bill-to Customer No_")::text = ("No_")::text)
  • Buffers: shared hit=164,074 read=200
  • I/O Timings: read=0.809
54. 54.720 218.880 ↓ 0.0 0 54,720

Append (cost=0.15..1.27 rows=5 width=42) (actual time=0.004..0.004 rows=0 loops=54,720)

  • Buffers: shared hit=438,217 read=111
  • I/O Timings: read=0.516
55. 0.000 0.000 ↓ 0.0 0 54,720

Index Scan using "UAT EMI Central$SCP Assignment History_pkey" on "UAT EMI Central$SCP Assignment History" (cost=0.15..0.17 rows=1 width=68) (actual time=0.000..0.000 rows=0 loops=54,720)

  • Index Cond: ("Customer Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Filter: ("Skipped" = 0)
  • Buffers: shared hit=54,717 read=3
  • I/O Timings: read=0.015
56. 54.720 54.720 ↓ 0.0 0 54,720

Index Scan using "UAT WAG BE$SCP Assignment History_pkey" on "UAT WAG BE$SCP Assignment History" (cost=0.28..0.30 rows=1 width=42) (actual time=0.001..0.001 rows=0 loops=54,720)

  • Index Cond: ("Customer Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Filter: ("Skipped" = 0)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=109,538 read=27
  • I/O Timings: read=0.138
57. 54.720 54.720 ↓ 0.0 0 54,720

Index Scan using "UAT WAG ES$SCP Assignment History_pkey" on "UAT WAG ES$SCP Assignment History" (cost=0.28..0.30 rows=1 width=42) (actual time=0.001..0.001 rows=0 loops=54,720)

  • Index Cond: ("Customer Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Filter: ("Skipped" = 0)
  • Buffers: shared hit=109,604 read=28
  • I/O Timings: read=0.123
58. 54.720 54.720 ↓ 0.0 0 54,720

Index Scan using "UAT WAG FR$SCP Assignment History_pkey" on "UAT WAG FR$SCP Assignment History" (cost=0.29..0.31 rows=1 width=42) (actual time=0.001..0.001 rows=0 loops=54,720)

  • Index Cond: ("Customer Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Filter: ("Skipped" = 0)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=109,552 read=49
  • I/O Timings: read=0.218
59. 0.000 0.000 ↓ 0.0 0 54,720

Index Scan using "UAT WAG CZ$SCP Assignment History_pkey" on "UAT WAG CZ$SCP Assignment History" (cost=0.14..0.17 rows=1 width=40) (actual time=0.000..0.000 rows=0 loops=54,720)

  • Index Cond: ("Customer Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Filter: ("Skipped" = 0)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=54,806 read=4
  • I/O Timings: read=0.021
60. 54.720 54.720 ↓ 0.0 0 54,720

Append (cost=0.43..2.66 rows=5 width=35) (actual time=0.001..0.001 rows=0 loops=54,720)

61. 0.000 0.000 ↓ 0.0 0 54,720

Index Scan using "UAT EMI Central$Cust_ Ledger Entry_pkey" on "UAT EMI Central$Cust_ Ledger Entry" "UAT EMI Central$Cust_ Ledger Entry_1" (cost=0.43..1.41 rows=1 width=35) (actual time=0.000..0.000 rows=0 loops=54,720)

  • Index Cond: ("Entry No_" = ap."New Customer Ledger Entry No_")
62. 0.000 0.000 ↓ 0.0 0 54,720

Index Scan using "UAT WAG BE$Cust_ Ledger Entry_pkey" on "UAT WAG BE$Cust_ Ledger Entry" "UAT WAG BE$Cust_ Ledger Entry_1" (cost=0.29..0.31 rows=1 width=36) (actual time=0.000..0.000 rows=0 loops=54,720)

  • Index Cond: ("Entry No_" = ap."New Customer Ledger Entry No_")
63. 0.000 0.000 ↓ 0.0 0 54,720

Index Scan using "UAT WAG ES$Cust_ Ledger Entry_pkey" on "UAT WAG ES$Cust_ Ledger Entry" "UAT WAG ES$Cust_ Ledger Entry_1" (cost=0.29..0.31 rows=1 width=36) (actual time=0.000..0.000 rows=0 loops=54,720)

  • Index Cond: ("Entry No_" = ap."New Customer Ledger Entry No_")
64. 0.000 0.000 ↓ 0.0 0 54,720

Index Scan using "UAT WAG FR$Cust_ Ledger Entry_pkey" on "UAT WAG FR$Cust_ Ledger Entry" "UAT WAG FR$Cust_ Ledger Entry_1" (cost=0.29..0.32 rows=1 width=36) (actual time=0.000..0.000 rows=0 loops=54,720)

  • Index Cond: ("Entry No_" = ap."New Customer Ledger Entry No_")
65. 0.000 0.000 ↓ 0.0 0 54,720

Index Scan using "UAT WAG CZ$Cust_ Ledger Entry_pkey" on "UAT WAG CZ$Cust_ Ledger Entry" "UAT WAG CZ$Cust_ Ledger Entry_1" (cost=0.28..0.29 rows=1 width=34) (actual time=0.000..0.000 rows=0 loops=54,720)

  • Index Cond: ("Entry No_" = ap."New Customer Ledger Entry No_")
66. 0.494 3.100 ↓ 3.3 658 1

Sort (cost=177.61..178.11 rows=200 width=28) (actual time=0.929..3.100 rows=658 loops=1)

  • Sort Key: adwsr."Document No_
  • Sort Method: quicksort Memory: 76kB
  • Buffers: shared hit=1 read=13
  • I/O Timings: read=0.055
67. 0.264 2.606 ↓ 3.3 658 1

Subquery Scan on adwsr (cost=165.97..169.97 rows=200 width=28) (actual time=0.450..2.606 rows=658 loops=1)

  • Buffers: shared hit=1 read=13
  • I/O Timings: read=0.055
68. 0.462 2.342 ↓ 3.3 658 1

HashAggregate (cost=165.97..167.97 rows=200 width=28) (actual time=0.449..2.342 rows=658 loops=1)

  • Group Key: "UAT EMI Central$WEB Documents ShowHide"."Document No_
  • Buffers: shared hit=1 read=13
  • I/O Timings: read=0.055
69. 0.626 1.880 ↑ 1.0 658 1

Append (cost=17.38..157.55 rows=674 width=14) (actual time=0.065..1.880 rows=658 loops=1)

  • Buffers: shared hit=1 read=13
  • I/O Timings: read=0.055
70. 0.273 0.407 ↑ 1.0 658 1

Bitmap Heap Scan on "UAT EMI Central$WEB Documents ShowHide" (cost=17.38..103.61 rows=658 width=13) (actual time=0.065..0.407 rows=658 loops=1)

  • Recheck Cond: ("Table ID" = 112)
  • Heap Blocks: exact=5
  • Buffers: shared hit=1 read=9
  • I/O Timings: read=0.032
71. 0.134 0.134 ↑ 1.0 658 1

Bitmap Index Scan on "UAT EMI Central$WEB Documents ShowHide_pkey" (cost=0.00..17.22 rows=658 width=0) (actual time=0.051..0.134 rows=658 loops=1)

  • Index Cond: ("Table ID" = 112)
  • Buffers: shared read=5
  • I/O Timings: read=0.020
72. 0.171 0.234 ↓ 0.0 0 1

Bitmap Heap Scan on "UAT WAG BE$WEB Documents ShowHide" (cost=4.18..12.64 rows=4 width=60) (actual time=0.008..0.234 rows=0 loops=1)

  • Recheck Cond: ("Table ID" = 112)
  • Buffers: shared read=1
  • I/O Timings: read=0.006
73. 0.063 0.063 ↓ 0.0 0 1

Bitmap Index Scan on "UAT WAG BE$WEB Documents ShowHide_pkey" (cost=0.00..4.18 rows=4 width=0) (actual time=0.008..0.063 rows=0 loops=1)

  • Index Cond: ("Table ID" = 112)
  • Buffers: shared read=1
  • I/O Timings: read=0.006
74. 0.141 0.207 ↓ 0.0 0 1

Bitmap Heap Scan on "UAT WAG ES$WEB Documents ShowHide" (cost=4.18..12.64 rows=4 width=60) (actual time=0.008..0.207 rows=0 loops=1)

  • Recheck Cond: ("Table ID" = 112)
  • Buffers: shared read=1
  • I/O Timings: read=0.006
75. 0.066 0.066 ↓ 0.0 0 1

Bitmap Index Scan on "UAT WAG ES$WEB Documents ShowHide_pkey" (cost=0.00..4.18 rows=4 width=0) (actual time=0.007..0.066 rows=0 loops=1)

  • Index Cond: ("Table ID" = 112)
  • Buffers: shared read=1
  • I/O Timings: read=0.006
76. 0.135 0.205 ↓ 0.0 0 1

Bitmap Heap Scan on "UAT WAG FR$WEB Documents ShowHide" (cost=4.18..12.64 rows=4 width=60) (actual time=0.008..0.205 rows=0 loops=1)

  • Recheck Cond: ("Table ID" = 112)
  • Buffers: shared read=1
  • I/O Timings: read=0.005
77. 0.070 0.070 ↓ 0.0 0 1

Bitmap Index Scan on "UAT WAG FR$WEB Documents ShowHide_pkey" (cost=0.00..4.18 rows=4 width=0) (actual time=0.008..0.070 rows=0 loops=1)

  • Index Cond: ("Table ID" = 112)
  • Buffers: shared read=1
  • I/O Timings: read=0.005
78. 0.127 0.201 ↓ 0.0 0 1

Bitmap Heap Scan on "UAT WAG CZ$WEB Documents ShowHide" (cost=4.18..12.64 rows=4 width=60) (actual time=0.009..0.201 rows=0 loops=1)

  • Recheck Cond: ("Table ID" = 112)
  • Buffers: shared read=1
  • I/O Timings: read=0.006
79. 0.074 0.074 ↓ 0.0 0 1

Bitmap Index Scan on "UAT WAG CZ$WEB Documents ShowHide_pkey" (cost=0.00..4.18 rows=4 width=0) (actual time=0.008..0.074 rows=0 loops=1)

  • Index Cond: ("Table ID" = 112)
  • Buffers: shared read=1
  • I/O Timings: read=0.006
80. 649.018 3,573.578 ↓ 611.3 122,258 1

GroupAggregate (cost=10,000,000,002.17..10,000,350,402.18 rows=200 width=109) (actual time=0.316..3,573.578 rows=122,258 loops=1)

  • Group Key: "UAT EMI Central$Sales Invoice Line"."Document No_
  • Buffers: shared hit=1,883,378 read=3,490
  • I/O Timings: read=13.714
81. 1,081.077 2,924.560 ↑ 1.0 258,904 1

Nested Loop Left Join (cost=10,000,000,002.17..10,000,342,614.82 rows=259,412 width=572) (actual time=0.216..2,924.560 rows=258,904 loops=1)

  • Join Filter: ((ac."NAV4 Business Area")::text = (sc.service)::text)
  • Rows Removed by Join Filter: 10,127,985
  • Buffers: shared hit=1,883,378 read=3,490
  • I/O Timings: read=13.714
82. 32.908 1,325.675 ↑ 1.0 258,904 1

Nested Loop Left Join (cost=2.17..186,966.12 rows=259,412 width=56) (actual time=0.184..1,325.675 rows=258,904 loops=1)

  • Buffers: shared hit=1,883,378 read=3,489
  • I/O Timings: read=13.710
83. 180.454 1,033.863 ↑ 1.0 258,904 1

Nested Loop Left Join (cost=2.03..139,779.37 rows=259,412 width=49) (actual time=0.171..1,033.863 rows=258,904 loops=1)

  • Buffers: shared hit=1,420,124 read=3,487
  • I/O Timings: read=13.699
84. 131.030 594.505 ↑ 1.0 258,904 1

Nested Loop Left Join (cost=1.76..63,881.83 rows=259,412 width=36) (actual time=0.146..594.505 rows=258,904 loops=1)

  • Buffers: shared hit=670,697 read=3,478
  • I/O Timings: read=13.660
85. 60.410 204.571 ↑ 1.0 258,904 1

Merge Append (cost=1.61..21,737.64 rows=259,412 width=28) (actual time=0.132..204.571 rows=258,904 loops=1)

  • Sort Key: "UAT EMI Central$Sales Invoice Line"."Document No_
  • Buffers: shared hit=180,167 read=3,476
  • I/O Timings: read=13.649
86. 125.720 125.720 ↑ 1.0 228,597 1

Index Scan using "UAT EMI Central$Sales Invoice Line_pkey" on "UAT EMI Central$Sales Invoice Line" (cost=0.42..15,384.97 rows=229,105 width=28) (actual time=0.031..125.720 rows=228,597 loops=1)

  • Buffers: shared hit=159,135 read=3,070
  • I/O Timings: read=11.849
87. 2.964 2.964 ↑ 1.0 5,339 1

Index Scan using "UAT WAG BE$Sales Invoice Line_pkey" on "UAT WAG BE$Sales Invoice Line" (cost=0.28..342.40 rows=5,339 width=29) (actual time=0.026..2.964 rows=5,339 loops=1)

  • Buffers: shared hit=2,374 read=73
  • I/O Timings: read=0.324
88. 2.500 2.500 ↑ 1.0 4,302 1

Index Scan using "UAT WAG ES$Sales Invoice Line_pkey" on "UAT WAG ES$Sales Invoice Line" (cost=0.28..288.82 rows=4,302 width=29) (actual time=0.023..2.500 rows=4,302 loops=1)

  • Buffers: shared hit=2,054 read=59
  • I/O Timings: read=0.287
89. 11.662 11.662 ↑ 1.0 18,588 1

Index Scan using "UAT WAG FR$Sales Invoice Line_pkey" on "UAT WAG FR$Sales Invoice Line" (cost=0.29..1,269.66 rows=18,588 width=29) (actual time=0.025..11.662 rows=18,588 loops=1)

  • Buffers: shared hit=14,889 read=247
  • I/O Timings: read=1.058
90. 1.315 1.315 ↑ 1.0 2,078 1

Index Scan using "UAT WAG CZ$Sales Invoice Line_pkey" on "UAT WAG CZ$Sales Invoice Line" (cost=0.28..142.99 rows=2,078 width=21) (actual time=0.023..1.315 rows=2,078 loops=1)

  • Buffers: shared hit=1,715 read=27
  • I/O Timings: read=0.130
91. 258.904 258.904 ↑ 1.0 1 258,904

Index Scan using "Posting Location_pkey" on "Posting Location" pl (cost=0.14..0.16 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=258,904)

  • Index Cond: (("UAT EMI Central$Sales Invoice Line"."Posting Location")::text = ("Code")::text)
  • Buffers: shared hit=490,530 read=2
  • I/O Timings: read=0.011
92. 258.904 258.904 ↑ 1.0 1 258,904

Index Scan using "Article_pkey" on "Article" ab (cost=0.28..0.29 rows=1 width=13) (actual time=0.001..0.001 rows=1 loops=258,904)

  • Index Cond: (("UAT EMI Central$Sales Invoice Line"."Article No_")::text = ("No_")::text)
  • Buffers: shared hit=749,427 read=9
  • I/O Timings: read=0.039
93. 258.904 258.904 ↑ 1.0 1 258,904

Index Scan using "Transaction Types_pkey" on "Transaction Types" ac (cost=0.14..0.18 rows=1 width=7) (actual time=0.001..0.001 rows=1 loops=258,904)

  • Index Cond: (ab."Transaction Type ID" = "ID")
  • Buffers: shared hit=463,254 read=2
  • I/O Timings: read=0.011
94. 517.726 517.808 ↑ 1.0 40 258,904

Materialize (cost=10,000,000,000.00..10,000,000,001.60 rows=40 width=1,032) (actual time=0.000..0.002 rows=40 loops=258,904)

  • Buffers: shared read=1
  • I/O Timings: read=0.004
95. 0.082 0.082 ↑ 1.0 40 1

Seq Scan on service_category sc (cost=10,000,000,000.00..10,000,000,001.40 rows=40 width=1,032) (actual time=0.014..0.082 rows=40 loops=1)

  • Buffers: shared read=1
  • I/O Timings: read=0.004
96. 61.968 983.279 ↓ 154.5 30,901 1

GroupAggregate (cost=2.47..8,784,151,594.20 rows=200 width=47) (actual time=6.226..983.279 rows=30,901 loops=1)

  • Group Key: "UAT EMI Central$Cust_ Ledger Entry_2"."Document No_
  • Buffers: shared hit=1,047,385 read=6,170
  • I/O Timings: read=22.753
97. 41.647 921.311 ↑ 35,399,577.4 39,886 1

Nested Loop (cost=2.47..1,724,413,865.46 rows=1,411,947,545,149 width=26) (actual time=6.140..921.311 rows=39,886 loops=1)

  • Buffers: shared hit=1,047,385 read=6,170
  • I/O Timings: read=22.753
98. 23.776 581.459 ↑ 23,862.4 59,641 1

Nested Loop (cost=2.05..696,206.15 rows=1,423,176,407 width=26) (actual time=6.009..581.459 rows=59,641 loops=1)

  • Buffers: shared hit=570,758 read=5,225
  • I/O Timings: read=18.797
99. 17.969 204.398 ↑ 4.4 70,657 1

Merge Append (cost=1.62..237,325.20 rows=313,740 width=15) (actual time=5.960..204.398 rows=70,657 loops=1)

  • Sort Key: "UAT EMI Central$Cust_ Ledger Entry_2"."Document No_
  • Buffers: shared hit=17,587 read=3,793
  • I/O Timings: read=12.926
100. 161.398 161.398 ↑ 5.7 53,647 1

Index Scan using "UAT_EMI_Central$Cust_Ledger_Entry_Document_No__IDX" on "UAT EMI Central$Cust_ Ledger Entry" "UAT EMI Central$Cust_ Ledger Entry_2" (cost=0.43..228,252.48 rows=308,070 width=15) (actual time=5.914..161.398 rows=53,647 loops=1)

  • Filter: (("Document Type" = 2) AND (("Document Date")::date >= (CURRENT_DATE - '2 years'::interval)))
  • Rows Removed by Filter: 129,833
  • Buffers: shared hit=16,647 read=3,081
  • I/O Timings: read=10.443
101. 6.059 6.059 ↓ 3.0 4,070 1

Index Scan using "UAT WAG BE$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG BE$Cust_ Ledger Entry" "UAT WAG BE$Cust_ Ledger Entry_2" (cost=0.29..1,028.50 rows=1,357 width=16) (actual time=0.013..6.059 rows=4,070 loops=1)

  • Filter: (("Document Type" = 2) AND (("Document Date")::date >= (CURRENT_DATE - '2 years'::interval)))
  • Rows Removed by Filter: 7,702
  • Buffers: shared hit=108 read=185
  • I/O Timings: read=0.863
102. 4.715 4.715 ↓ 3.0 3,118 1

Index Scan using "UAT WAG ES$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG ES$Cust_ Ledger Entry" "UAT WAG ES$Cust_ Ledger Entry_2" (cost=0.29..620.95 rows=1,039 width=16) (actual time=0.009..4.715 rows=3,118 loops=1)

  • Filter: (("Document Type" = 2) AND (("Document Date")::date >= (CURRENT_DATE - '2 years'::interval)))
  • Rows Removed by Filter: 5,920
  • Buffers: shared hit=94 read=114
  • I/O Timings: read=0.337
103. 13.567 13.567 ↓ 3.0 9,293 1

Index Scan using "UAT WAG FR$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG FR$Cust_ Ledger Entry" "UAT WAG FR$Cust_ Ledger Entry_2" (cost=0.29..2,135.92 rows=3,098 width=16) (actual time=0.010..13.567 rows=9,293 loops=1)

  • Filter: (("Document Type" = 2) AND (("Document Date")::date >= (CURRENT_DATE - '2 years'::interval)))
  • Rows Removed by Filter: 17,764
  • Buffers: shared hit=687 read=402
  • I/O Timings: read=1.236
104. 0.690 0.690 ↓ 3.0 529 1

Index Scan using "UAT_WAG_CZ$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG CZ$Cust_ Ledger Entry" "UAT WAG CZ$Cust_ Ledger Entry_2" (cost=0.28..76.19 rows=176 width=14) (actual time=0.011..0.690 rows=529 loops=1)

  • Filter: (("Document Type" = 2) AND (("Document Date")::date >= (CURRENT_DATE - '2 years'::interval)))
  • Rows Removed by Filter: 163
  • Buffers: shared hit=51 read=11
  • I/O Timings: read=0.048
105. 211.971 353.285 ↑ 5.0 1 70,657

Append (cost=0.43..1.41 rows=5 width=23) (actual time=0.003..0.005 rows=1 loops=70,657)

  • Buffers: shared hit=553,171 read=1,432
  • I/O Timings: read=5.871
106. 141.314 141.314 ↑ 1.0 1 70,657

Index Scan using "UAT_EMI_Central$Cover_Letter_Line_Source_Document_No_IDX" on "UAT EMI Central$Cover Letter Line" (cost=0.43..0.64 rows=1 width=23) (actual time=0.002..0.002 rows=1 loops=70,657)

  • Index Cond: (("Source Document No_")::text = ("UAT EMI Central$Cust_ Ledger Entry_2"."Document No_")::text)
  • Filter: ("Source Document Type" = 0)
  • Buffers: shared hit=270,555 read=1,424
  • I/O Timings: read=5.830
107. 0.000 0.000 ↓ 0.0 0 70,656

Index Scan using "UAT_WAG_BE$Cover_Letter_Line_Source_Document_No_IDX" on "UAT WAG BE$Cover Letter Line" (cost=0.15..0.19 rows=1 width=116) (actual time=0.000..0.000 rows=0 loops=70,656)

  • Index Cond: (("Source Document No_")::text = ("UAT EMI Central$Cust_ Ledger Entry_2"."Document No_")::text)
  • Filter: ("Source Document Type" = 0)
  • Buffers: shared hit=70,654 read=2
  • I/O Timings: read=0.010
108. 0.000 0.000 ↓ 0.0 0 70,656

Index Scan using "UAT_WAG_ES$Cover_Letter_Line_Source_Document_No_IDX" on "UAT WAG ES$Cover Letter Line" (cost=0.15..0.19 rows=1 width=116) (actual time=0.000..0.000 rows=0 loops=70,656)

  • Index Cond: (("Source Document No_")::text = ("UAT EMI Central$Cust_ Ledger Entry_2"."Document No_")::text)
  • Filter: ("Source Document Type" = 0)
  • Buffers: shared hit=70,654 read=2
  • I/O Timings: read=0.010
109. 0.000 0.000 ↓ 0.0 0 70,656

Index Scan using "UAT_WAG_FR$Cover_Letter_Line_Source_Document_No_IDX" on "UAT WAG FR$Cover Letter Line" (cost=0.15..0.19 rows=1 width=116) (actual time=0.000..0.000 rows=0 loops=70,656)

  • Index Cond: (("Source Document No_")::text = ("UAT EMI Central$Cust_ Ledger Entry_2"."Document No_")::text)
  • Filter: ("Source Document Type" = 0)
  • Buffers: shared hit=70,654 read=2
  • I/O Timings: read=0.011
110. 0.000 0.000 ↓ 0.0 0 70,656

Index Scan using "UAT_WAG_CZ$Cover_Letter_Line_Source_Document_No_IDX" on "UAT WAG CZ$Cover Letter Line" (cost=0.15..0.19 rows=1 width=116) (actual time=0.000..0.000 rows=0 loops=70,656)

  • Index Cond: (("Source Document No_")::text = ("UAT EMI Central$Cust_ Ledger Entry_2"."Document No_")::text)
  • Filter: ("Source Document Type" = 0)
  • Buffers: shared hit=70,654 read=2
  • I/O Timings: read=0.011
111. 119.282 298.205 ↑ 5.0 1 59,641

Append (cost=0.42..1.16 rows=5 width=11) (actual time=0.003..0.005 rows=1 loops=59,641)

  • Buffers: shared hit=476,627 read=945
  • I/O Timings: read=3.956
112. 178.923 178.923 ↑ 1.0 1 59,641

Index Scan using "UAT EMI Central$Cover Letter Header_pkey" on "UAT EMI Central$Cover Letter Header" (cost=0.42..0.47 rows=1 width=11) (actual time=0.002..0.003 rows=1 loops=59,641)

  • Index Cond: (("No_")::text = ("UAT EMI Central$Cover Letter Line"."Document No_")::text)
  • Filter: ("Fictive" = 0)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=238,075 read=937
  • I/O Timings: read=3.916
113. 0.000 0.000 ↓ 0.0 0 59,640

Index Scan using "UAT WAG BE$Cover Letter Header_pkey" on "UAT WAG BE$Cover Letter Header" (cost=0.15..0.17 rows=1 width=58) (actual time=0.000..0.000 rows=0 loops=59,640)

  • Index Cond: (("No_")::text = ("UAT EMI Central$Cover Letter Line"."Document No_")::text)
  • Filter: ("Fictive" = 0)
  • Buffers: shared hit=59,638 read=2
  • I/O Timings: read=0.010
114. 0.000 0.000 ↓ 0.0 0 59,640

Index Scan using "UAT WAG ES$Cover Letter Header_pkey" on "UAT WAG ES$Cover Letter Header" (cost=0.15..0.17 rows=1 width=58) (actual time=0.000..0.000 rows=0 loops=59,640)

  • Index Cond: (("No_")::text = ("UAT EMI Central$Cover Letter Line"."Document No_")::text)
  • Filter: ("Fictive" = 0)
  • Buffers: shared hit=59,638 read=2
  • I/O Timings: read=0.009
115. 0.000 0.000 ↓ 0.0 0 59,640

Index Scan using "UAT WAG FR$Cover Letter Header_pkey" on "UAT WAG FR$Cover Letter Header" (cost=0.15..0.17 rows=1 width=58) (actual time=0.000..0.000 rows=0 loops=59,640)

  • Index Cond: (("No_")::text = ("UAT EMI Central$Cover Letter Line"."Document No_")::text)
  • Filter: ("Fictive" = 0)
  • Buffers: shared hit=59,638 read=2
  • I/O Timings: read=0.010
116. 0.000 0.000 ↓ 0.0 0 59,640

Index Scan using "UAT WAG CZ$Cover Letter Header_pkey" on "UAT WAG CZ$Cover Letter Header" (cost=0.15..0.17 rows=1 width=58) (actual time=0.000..0.000 rows=0 loops=59,640)

  • Index Cond: (("No_")::text = ("UAT EMI Central$Cover Letter Line"."Document No_")::text)
  • Filter: ("Fictive" = 0)
  • Buffers: shared hit=59,638 read=2
  • I/O Timings: read=0.010
117. 193.285 1,176.566 ↓ 4,645.4 929,083 1

Hash (cost=53,854.06..53,854.06 rows=200 width=19) (actual time=1,174.495..1,176.566 rows=929,083 loops=1)

  • Buckets: 131,072 (originally 1024) Batches: 16 (originally 1) Memory Usage: 3,948kB
  • Buffers: shared hit=35 read=9,742, temp written=4,177
  • I/O Timings: read=29.716
118. 107.422 983.281 ↓ 4,645.4 929,083 1

Subquery Scan on adwsr2 (cost=53,850.06..53,854.06 rows=200 width=19) (actual time=647.691..983.281 rows=929,083 loops=1)

  • Buffers: shared hit=35 read=9,742
  • I/O Timings: read=29.716
119. 584.388 875.859 ↓ 4,645.4 929,083 1

HashAggregate (cost=53,850.06..53,852.06 rows=200 width=19) (actual time=647.689..875.859 rows=929,083 loops=1)

  • Group Key: "UAT EMI Central$Posted Document Web Info"."Document No_
  • Buffers: shared hit=35 read=9,742
  • I/O Timings: read=29.716
120. 77.980 291.471 ↓ 1.0 939,101 1

Append (cost=22,125.96..49,167.94 rows=936,423 width=11) (actual time=48.282..291.471 rows=939,101 loops=1)

  • Buffers: shared hit=35 read=9,742
  • I/O Timings: read=29.716
121. 162.591 210.138 ↓ 1.0 928,811 1

Bitmap Heap Scan on "UAT EMI Central$Posted Document Web Info" (cost=22,125.96..43,943.95 rows=926,133 width=11) (actual time=48.281..210.138 rows=928,811 loops=1)

  • Recheck Cond: ("Table ID" = 112)
  • Filter: ("Send Electronically" = 1)
  • Heap Blocks: exact=5,932
  • Buffers: shared read=9,620
  • I/O Timings: read=29.318
122. 47.547 47.547 ↓ 1.0 928,811 1

Bitmap Index Scan on "UAT EMI Central$Posted Document Web Info_pkey" (cost=0.00..21,894.42 rows=926,133 width=0) (actual time=47.443..47.547 rows=928,811 loops=1)

  • Index Cond: ("Table ID" = 112)
  • Buffers: shared read=3,688
  • I/O Timings: read=10.841
123. 0.423 0.590 ↑ 1.0 1,408 1

Bitmap Heap Scan on "UAT WAG BE$Posted Document Web Info" (cost=47.19..77.31 rows=1,408 width=14) (actual time=0.119..0.590 rows=1,408 loops=1)

  • Recheck Cond: ("Table ID" = 112)
  • Filter: ("Send Electronically" = 1)
  • Heap Blocks: exact=9
  • Buffers: shared read=17
  • I/O Timings: read=0.067
124. 0.167 0.167 ↑ 1.0 1,408 1

Bitmap Index Scan on "UAT WAG BE$Posted Document Web Info_pkey" (cost=0.00..46.84 rows=1,408 width=0) (actual time=0.103..0.167 rows=1,408 loops=1)

  • Index Cond: ("Table ID" = 112)
  • Buffers: shared read=8
  • I/O Timings: read=0.040
125. 0.645 0.900 ↑ 1.0 2,915 1

Bitmap Heap Scan on "UAT WAG ES$Posted Document Web Info" (cost=90.87..153.60 rows=2,915 width=14) (actual time=0.202..0.900 rows=2,915 loops=1)

  • Recheck Cond: ("Table ID" = 112)
  • Filter: ("Send Electronically" = 1)
  • Heap Blocks: exact=19
  • Buffers: shared read=35
  • I/O Timings: read=0.108
126. 0.255 0.255 ↑ 1.0 2,915 1

Bitmap Index Scan on "UAT WAG ES$Posted Document Web Info_pkey" (cost=0.00..90.14 rows=2,915 width=0) (actual time=0.188..0.255 rows=2,915 loops=1)

  • Index Cond: ("Table ID" = 112)
  • Buffers: shared read=16
  • I/O Timings: read=0.050
127. 1.355 1.712 ↑ 1.0 5,777 1

Bitmap Heap Scan on "UAT WAG FR$Posted Document Web Info" (cost=169.05..292.71 rows=5,777 width=14) (actual time=0.304..1.712 rows=5,777 loops=1)

  • Recheck Cond: ("Table ID" = 112)
  • Filter: ("Send Electronically" = 1)
  • Heap Blocks: exact=37
  • Buffers: shared read=67
  • I/O Timings: read=0.203
128. 0.357 0.357 ↑ 1.0 5,777 1

Bitmap Index Scan on "UAT WAG FR$Posted Document Web Info_pkey" (cost=0.00..167.61 rows=5,777 width=0) (actual time=0.289..0.357 rows=5,777 loops=1)

  • Index Cond: ("Table ID" = 112)
  • Buffers: shared read=30
  • I/O Timings: read=0.089
129. 0.151 0.151 ↑ 1.0 190 1

Index Scan using "UAT WAG CZ$Posted Document Web Info_pkey" on "UAT WAG CZ$Posted Document Web Info" (cost=0.14..18.26 rows=190 width=14) (actual time=0.032..0.151 rows=190 loops=1)

  • Index Cond: ("Table ID" = 112)
  • Filter: ("Send Electronically" = 1)
  • Buffers: shared hit=35 read=3
  • I/O Timings: read=0.020
130. 459.582 6,965.949 ↓ 11,621.6 2,324,325 1

Hash (cost=241,686.47..241,686.47 rows=200 width=36) (actual time=6,964.634..6,965.949 rows=2,324,325 loops=1)

  • Buckets: 131,072 (originally 1024) Batches: 32 (originally 1) Memory Usage: 3,878kB
  • Buffers: shared hit=2,619,390 read=57,957, temp written=7,749
  • I/O Timings: read=216.040
131. 263.698 6,506.367 ↓ 11,621.6 2,324,325 1

Subquery Scan on ahcle (cost=241,681.97..241,686.47 rows=200 width=36) (actual time=4,968.683..6,506.367 rows=2,324,325 loops=1)

  • Buffers: shared hit=2,619,390 read=57,957
  • I/O Timings: read=216.040
132. 3,432.262 6,242.669 ↓ 11,621.6 2,324,325 1

HashAggregate (cost=241,681.97..241,684.47 rows=200 width=36) (actual time=4,968.682..6,242.669 rows=2,324,325 loops=1)

  • Group Key: "UAT EMI Central$Detailed Cust_ Ledg_ Entry"."Cust_ Ledger Entry No_
  • Buffers: shared hit=2,619,390 read=57,957
  • I/O Timings: read=216.040
133. 465.631 2,810.407 ↓ 1.0 5,589,963 1

Append (cost=0.43..213,735.66 rows=5,589,262 width=10) (actual time=0.013..2,810.407 rows=5,589,963 loops=1)

  • Buffers: shared hit=2,619,390 read=57,957
  • I/O Timings: read=216.040
134. 2,318.206 2,318.206 ↓ 1.0 5,509,880 1

Index Scan using "UAT_EMI_Central$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT EMI Central$Detailed Cust_ Ledg_ Entry" (cost=0.43..182,857.36 rows=5,509,179 width=10) (actual time=0.012..2,318.206 rows=5,509,880 loops=1)

  • Buffers: shared hit=2,589,360 read=57,175
  • I/O Timings: read=213.214
135. 6.151 6.151 ↑ 1.0 19,462 1

Index Scan using "UAT WAG BE$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG BE$Detailed Cust_ Ledg_ Entry" (cost=0.29..664.93 rows=19,462 width=10) (actual time=0.046..6.151 rows=19,462 loops=1)

  • Buffers: shared hit=7,064 read=191
  • I/O Timings: read=0.708
136. 4.948 4.948 ↑ 1.0 14,954 1

Index Scan using "UAT WAG ES$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG ES$Detailed Cust_ Ledg_ Entry" (cost=0.29..635.28 rows=14,954 width=10) (actual time=0.043..4.948 rows=14,954 loops=1)

  • Buffers: shared hit=5,630 read=146
  • I/O Timings: read=0.523
137. 15.164 15.164 ↑ 1.0 44,813 1

Index Scan using "UAT WAG FR$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG FR$Detailed Cust_ Ledg_ Entry" (cost=0.29..1,588.19 rows=44,813 width=10) (actual time=0.039..15.164 rows=44,813 loops=1)

  • Buffers: shared hit=17,284 read=435
  • I/O Timings: read=1.541
138. 0.307 0.307 ↑ 1.0 854 1

Index Scan using "UAT_WAG_CZ$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG CZ$Detailed Cust_ Ledg_ Entry" (cost=0.28..43.59 rows=854 width=9) (actual time=0.046..0.307 rows=854 loops=1)

  • Buffers: shared hit=52 read=10
  • I/O Timings: read=0.054
139. 39.682 2,679.490 ↓ 693.7 138,745 1

Hash (cost=44,885,143.49..44,885,143.49 rows=200 width=47) (actual time=2,677.085..2,679.490 rows=138,745 loops=1)

  • Buckets: 131,072 (originally 1024) Batches: 4 (originally 1) Memory Usage: 3,260kB
  • Buffers: shared hit=2,341,416 read=56,048, temp written=471
  • I/O Timings: read=191.807
140. 20.509 2,639.808 ↓ 693.7 138,745 1

Subquery Scan on ah1cle (cost=2.05..44,885,143.49 rows=200 width=47) (actual time=14.383..2,639.808 rows=138,745 loops=1)

  • Buffers: shared hit=2,341,416 read=56,048
  • I/O Timings: read=191.807
141. 125.544 2,619.299 ↓ 693.7 138,745 1

GroupAggregate (cost=2.05..44,885,141.49 rows=200 width=47) (actual time=14.382..2,619.299 rows=138,745 loops=1)

  • Group Key: "UAT EMI Central$Cust_ Ledger Entry_3"."Document No_
  • Buffers: shared hit=2,341,416 read=56,048
  • I/O Timings: read=191.807
142. 24.493 2,493.755 ↑ 29,635.6 295,856 1

Nested Loop (cost=2.05..1,045,762.50 rows=8,767,875,299 width=21) (actual time=14.331..2,493.755 rows=295,856 loops=1)

  • Buffers: shared hit=2,341,416 read=56,048
  • I/O Timings: read=191.807
143. 24.917 1,394.195 ↑ 2.0 153,581 1

Merge Append (cost=1.62..237,325.20 rows=313,740 width=19) (actual time=14.300..1,394.195 rows=153,581 loops=1)

  • Sort Key: "UAT EMI Central$Cust_ Ledger Entry_3"."Document No_
  • Buffers: shared hit=392,854 read=53,047
  • I/O Timings: read=180.346
144. 1,344.275 1,344.275 ↑ 2.3 136,571 1

Index Scan using "UAT_EMI_Central$Cust_Ledger_Entry_Document_No__IDX" on "UAT EMI Central$Cust_ Ledger Entry" "UAT EMI Central$Cust_ Ledger Entry_3" (cost=0.43..228,252.48 rows=308,070 width=19) (actual time=14.212..1,344.275 rows=136,571 loops=1)

  • Filter: (("Document Type" = 2) AND (("Document Date")::date >= (CURRENT_DATE - '2 years'::interval)))
  • Rows Removed by Filter: 2,152,214
  • Buffers: shared hit=392,074 read=52,175
  • I/O Timings: read=177.339
145. 6.111 6.111 ↓ 3.0 4,070 1

Index Scan using "UAT WAG BE$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG BE$Cust_ Ledger Entry" "UAT WAG BE$Cust_ Ledger Entry_3" (cost=0.29..1,028.50 rows=1,357 width=20) (actual time=0.024..6.111 rows=4,070 loops=1)

  • Filter: (("Document Type" = 2) AND (("Document Date")::date >= (CURRENT_DATE - '2 years'::interval)))
  • Rows Removed by Filter: 7,702
  • Buffers: shared hit=82 read=211
  • I/O Timings: read=0.674
146. 4.474 4.474 ↓ 3.0 3,118 1

Index Scan using "UAT WAG ES$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG ES$Cust_ Ledger Entry" "UAT WAG ES$Cust_ Ledger Entry_3" (cost=0.29..620.95 rows=1,039 width=20) (actual time=0.021..4.474 rows=3,118 loops=1)

  • Filter: (("Document Type" = 2) AND (("Document Date")::date >= (CURRENT_DATE - '2 years'::interval)))
  • Rows Removed by Filter: 5,920
  • Buffers: shared hit=45 read=163
  • I/O Timings: read=0.520
147. 13.728 13.728 ↓ 3.0 9,293 1

Index Scan using "UAT WAG FR$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG FR$Cust_ Ledger Entry" "UAT WAG FR$Cust_ Ledger Entry_3" (cost=0.29..2,135.92 rows=3,098 width=20) (actual time=0.021..13.728 rows=9,293 loops=1)

  • Filter: (("Document Type" = 2) AND (("Document Date")::date >= (CURRENT_DATE - '2 years'::interval)))
  • Rows Removed by Filter: 17,764
  • Buffers: shared hit=604 read=485
  • I/O Timings: read=1.763
148. 0.690 0.690 ↓ 3.0 529 1

Index Scan using "UAT_WAG_CZ$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG CZ$Cust_ Ledger Entry" "UAT WAG CZ$Cust_ Ledger Entry_3" (cost=0.28..76.19 rows=176 width=18) (actual time=0.019..0.690 rows=529 loops=1)

  • Filter: (("Document Type" = 2) AND (("Document Date")::date >= (CURRENT_DATE - '2 years'::interval)))
  • Rows Removed by Filter: 163
  • Buffers: shared hit=49 read=13
  • I/O Timings: read=0.050
149. 153.581 1,075.067 ↑ 5.0 2 153,581

Append (cost=0.43..2.48 rows=10 width=10) (actual time=0.002..0.007 rows=2 loops=153,581)

  • Buffers: shared hit=1,948,562 read=3,001
  • I/O Timings: read=11.462
150. 307.162 307.162 ↑ 1.5 2 153,581

Index Scan using "UAT_EMI_Central$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT EMI Central$Detailed Cust_ Ledg_ Entry" "UAT EMI Central$Detailed Cust_ Ledg_ Entry_1" (cost=0.43..1.16 rows=3 width=10) (actual time=0.002..0.002 rows=2 loops=153,581)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_3"."Entry No_")
  • Buffers: shared hit=675,009 read=2,950
  • I/O Timings: read=11.280
151. 153.581 153.581 ↓ 0.0 0 153,581

Index Scan using "UAT WAG BE$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG BE$Detailed Cust_ Ledg_ Entry" "UAT WAG BE$Detailed Cust_ Ledg_ Entry_1" (cost=0.29..0.32 rows=2 width=10) (actual time=0.001..0.001 rows=0 loops=153,581)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_3"."Entry No_")
  • Buffers: shared hit=318,871 read=6
  • I/O Timings: read=0.025
152. 153.581 153.581 ↓ 0.0 0 153,581

Index Scan using "UAT WAG ES$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG ES$Detailed Cust_ Ledg_ Entry" "UAT WAG ES$Detailed Cust_ Ledg_ Entry_1" (cost=0.29..0.32 rows=2 width=10) (actual time=0.001..0.001 rows=0 loops=153,581)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_3"."Entry No_")
  • Buffers: shared hit=317,057 read=2
  • I/O Timings: read=0.009
153. 153.581 153.581 ↓ 0.0 0 153,581

Index Scan using "UAT WAG FR$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG FR$Detailed Cust_ Ledg_ Entry" "UAT WAG FR$Detailed Cust_ Ledg_ Entry_1" (cost=0.29..0.33 rows=2 width=10) (actual time=0.001..0.001 rows=0 loops=153,581)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_3"."Entry No_")
  • Buffers: shared hit=329,421 read=41
  • I/O Timings: read=0.140
154. 153.581 153.581 ↓ 0.0 0 153,581

Index Scan using "UAT_WAG_CZ$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG CZ$Detailed Cust_ Ledg_ Entry" "UAT WAG CZ$Detailed Cust_ Ledg_ Entry_1" (cost=0.28..0.29 rows=1 width=9) (actual time=0.001..0.001 rows=0 loops=153,581)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_3"."Entry No_")
  • Buffers: shared hit=308,204 read=2
  • I/O Timings: read=0.008
155. 0.522 2.562 ↑ 1.2 2,379 1

Hash (cost=182.69..182.69 rows=2,759 width=30) (actual time=1.163..2.562 rows=2,379 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 146kB
  • Buffers: shared read=40
  • I/O Timings: read=0.156
156. 0.728 2.040 ↑ 1.2 2,379 1

Append (cost=68.66..182.69 rows=2,759 width=30) (actual time=0.144..2.040 rows=2,379 loops=1)

  • Buffers: shared read=40
  • I/O Timings: read=0.156
157. 0.577 0.773 ↑ 1.0 2,359 1

Bitmap Heap Scan on "UAT EMI Central$Sales Cr_Memo Header" (cost=68.66..112.25 rows=2,359 width=16) (actual time=0.143..0.773 rows=2,359 loops=1)

  • Heap Blocks: exact=20
  • Buffers: shared read=33
  • I/O Timings: read=0.111
158. 0.196 0.196 ↑ 1.0 2,359 1

Bitmap Index Scan on "UAT_EMI_Central$Sales_Cr_Memo_Header_Invoicing_Group_IDX" (cost=0.00..68.08 rows=2,359 width=0) (actual time=0.129..0.196 rows=2,359 loops=1)

  • Buffers: shared read=13
  • I/O Timings: read=0.055
159. 0.100 0.100 ↑ 1.0 11 1

Index Scan using "UAT WAG BE$Sales_Cr_Memo_Header_No_IDX" on "UAT WAG BE$Sales Cr_Memo Header" (cost=0.14..12.30 rows=11 width=116) (actual time=0.020..0.100 rows=11 loops=1)

  • Buffers: shared read=2
  • I/O Timings: read=0.014
160. 0.105 0.105 ↑ 1.0 3 1

Index Scan using "UAT WAG ES$Sales_Cr_Memo_Header_No_IDX" on "UAT WAG ES$Sales Cr_Memo Header" (cost=0.13..12.18 rows=3 width=116) (actual time=0.018..0.105 rows=3 loops=1)

  • Buffers: shared read=2
  • I/O Timings: read=0.013
161. 0.077 0.077 ↑ 1.0 6 1

Index Scan using "UAT WAG FR$Sales_Cr_Memo_Header_No_IDX" on "UAT WAG FR$Sales Cr_Memo Header" (cost=0.13..12.22 rows=6 width=116) (actual time=0.017..0.077 rows=6 loops=1)

  • Buffers: shared read=2
  • I/O Timings: read=0.013
162. 0.184 0.257 ↓ 0.0 0 1

Bitmap Heap Scan on "UAT WAG CZ$Sales Cr_Memo Header" (cost=6.14..19.94 rows=380 width=116) (actual time=0.009..0.257 rows=0 loops=1)

  • Buffers: shared read=1
  • I/O Timings: read=0.006
163. 0.073 0.073 ↓ 0.0 0 1

Bitmap Index Scan on "UAT_WAG_CZ$Sales_Cr_Memo_Header_Invoicing_Group_IDX" (cost=0.00..6.05 rows=380 width=0) (actual time=0.008..0.073 rows=0 loops=1)

  • Buffers: shared read=1
  • I/O Timings: read=0.006
164.          

SubPlan (for Hash Left Join)

165. 105.748 105.748 ↑ 1.0 1 52,874

Index Scan using "Limit_pkey" on "Limit" li (cost=0.29..8.30 rows=1 width=6) (actual time=0.002..0.002 rows=1 loops=52,874)

  • Index Cond: ("ID" = "UAT EMI Central$Cust_ Ledger Entry"."Limit ID")
  • Buffers: shared hit=158,519 read=355
  • I/O Timings: read=1.475
166. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=32) (never executed)

167. 39.885 199.425 ↑ 1.0 1 39,885

Aggregate (cost=40.76..40.77 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=39,885)

  • Buffers: shared hit=398,830 read=20
  • I/O Timings: read=0.105
168. 0.000 159.540 ↓ 0.0 0 39,885

Append (cost=0.12..40.75 rows=5 width=0) (actual time=0.004..0.004 rows=0 loops=39,885)

  • Buffers: shared hit=398,830 read=20
  • I/O Timings: read=0.105
169. 39.885 39.885 ↓ 0.0 0 39,885

Index Only Scan using "UAT EMI_Central$Billing_Cycle_Setup_NI_Cancel_TRX_Invoicing_Gro" on "UAT EMI Central$Billing Cycle Setup" (cost=0.12..8.14 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=39,885)

  • Filter: ((("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Rows Removed by Filter: 1
  • Heap Fetches: 39,885
  • Buffers: shared hit=79,766 read=4
  • I/O Timings: read=0.022
170. 39.885 39.885 ↓ 0.0 0 39,885

Index Only Scan using "UAT WAG BE$Billing_Cycle_Setup_NI_Cancel_TRX_Invoicing_Gro" on "UAT WAG BE$Billing Cycle Setup" (cost=0.12..8.14 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=39,885)

  • Filter: ((("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Rows Removed by Filter: 1
  • Heap Fetches: 39,885
  • Buffers: shared hit=79,766 read=4
  • I/O Timings: read=0.020
171. 39.885 39.885 ↓ 0.0 0 39,885

Index Only Scan using "UAT WAG ES$Billing_Cycle_Setup_NI_Cancel_TRX_Invoicing_Gro" on "UAT WAG ES$Billing Cycle Setup" (cost=0.12..8.14 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=39,885)

  • Filter: ((("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Rows Removed by Filter: 1
  • Heap Fetches: 39,885
  • Buffers: shared hit=79,766 read=4
  • I/O Timings: read=0.021
172. 39.885 39.885 ↓ 0.0 0 39,885

Index Only Scan using "UAT WAG FR$Billing_Cycle_Setup_NI_Cancel_TRX_Invoicing_Gro" on "UAT WAG FR$Billing Cycle Setup" (cost=0.12..8.14 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=39,885)

  • Filter: ((("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Rows Removed by Filter: 1
  • Heap Fetches: 39,885
  • Buffers: shared hit=79,766 read=4
  • I/O Timings: read=0.022
173. 39.885 39.885 ↓ 0.0 0 39,885

Index Only Scan using "UAT WAG_CZ$Billing_Cycle_Setup_NI_Cancel_TRX_Invoicing_Gro" on "UAT WAG CZ$Billing Cycle Setup" (cost=0.12..8.14 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=39,885)

  • Filter: ((("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Rows Removed by Filter: 1
  • Heap Fetches: 39,885
  • Buffers: shared hit=79,766 read=4
  • I/O Timings: read=0.021
174. 0.282 4.888 ↑ 1.0 1 94

Aggregate (cost=1,321.86..1,321.87 rows=1 width=32) (actual time=0.032..0.052 rows=1 loops=94)

  • Buffers: shared hit=2,986 read=43
  • I/O Timings: read=0.208
175. 0.403 4.606 ↑ 65,208.0 3 94

Nested Loop (cost=0.86..343.74 rows=195,624 width=10) (actual time=0.010..0.049 rows=3 loops=94)

  • Buffers: shared hit=2,986 read=43
  • I/O Timings: read=0.208
176. 0.752 2.162 ↑ 3.5 2 94

Append (cost=0.43..49.72 rows=7 width=4) (actual time=0.005..0.023 rows=2 loops=94)

  • Buffers: shared hit=1,100 read=28
  • I/O Timings: read=0.146
177. 0.470 0.470 ↑ 1.5 2 94

Index Only Scan using "UAT_EMI_Central$Cust_Ledger_Entry_Document_No1__IDX" on "UAT EMI Central$Cust_ Ledger Entry" "UAT EMI Central$Cust_ Ledger Entry_4" (cost=0.43..16.48 rows=3 width=4) (actual time=0.005..0.005 rows=2 loops=94)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 157
  • Buffers: shared hit=364 read=12
  • I/O Timings: read=0.059
178. 0.282 0.282 ↓ 0.0 0 94

Index Only Scan using "UAT WAG BE$Cust_Ledger_Entry_Document_No1__IDX" on "UAT WAG BE$Cust_ Ledger Entry" "UAT WAG BE$Cust_ Ledger Entry_4" (cost=0.29..8.30 rows=1 width=4) (actual time=0.002..0.003 rows=0 loops=94)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 0
  • Buffers: shared hit=184 read=4
  • I/O Timings: read=0.030
179. 0.188 0.188 ↓ 0.0 0 94

Index Only Scan using "UAT WAG ES$Cust_Ledger_Entry_Document_No1__IDX" on "UAT WAG ES$Cust_ Ledger Entry" "UAT WAG ES$Cust_ Ledger Entry_4" (cost=0.29..8.30 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=94)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 0
  • Buffers: shared hit=184 read=4
  • I/O Timings: read=0.019
180. 0.282 0.282 ↓ 0.0 0 94

Index Only Scan using "UAT WAG FR$Cust_Ledger_Entry_Document_No1__IDX" on "UAT WAG FR$Cust_ Ledger Entry" "UAT WAG FR$Cust_ Ledger Entry_4" (cost=0.29..8.30 rows=1 width=4) (actual time=0.002..0.003 rows=0 loops=94)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 0
  • Buffers: shared hit=184 read=4
  • I/O Timings: read=0.018
181. 0.188 0.188 ↓ 0.0 0 94

Index Only Scan using "UAT_WAG_CZ$Cust_Ledger_Entry_Document_No1__IDX" on "UAT WAG CZ$Cust_ Ledger Entry" "UAT WAG CZ$Cust_ Ledger Entry_4" (cost=0.28..8.29 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=94)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 0
  • Buffers: shared hit=184 read=4
  • I/O Timings: read=0.020
182. 0.785 2.041 ↑ 5.0 2 157

Append (cost=0.43..41.90 rows=10 width=14) (actual time=0.003..0.013 rows=2 loops=157)

  • Buffers: shared hit=1,886 read=15
  • I/O Timings: read=0.062
183. 0.628 0.628 ↑ 1.5 2 157

Index Scan using "UAT_EMI_Central$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT EMI Central$Detailed Cust_ Ledg_ Entry" "UAT EMI Central$Detailed Cust_ Ledg_ Entry_2" (cost=0.43..8.64 rows=3 width=14) (actual time=0.003..0.004 rows=2 loops=157)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_4"."Entry No_")
  • Buffers: shared hit=630 read=15
  • I/O Timings: read=0.062
184. 0.157 0.157 ↓ 0.0 0 157

Index Scan using "UAT WAG BE$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG BE$Detailed Cust_ Ledg_ Entry" "UAT WAG BE$Detailed Cust_ Ledg_ Entry_2" (cost=0.29..8.42 rows=2 width=14) (actual time=0.001..0.001 rows=0 loops=157)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_4"."Entry No_")
  • Buffers: shared hit=314
185. 0.157 0.157 ↓ 0.0 0 157

Index Scan using "UAT WAG ES$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG ES$Detailed Cust_ Ledg_ Entry" "UAT WAG ES$Detailed Cust_ Ledg_ Entry_2" (cost=0.29..10.02 rows=2 width=14) (actual time=0.001..0.001 rows=0 loops=157)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_4"."Entry No_")
  • Buffers: shared hit=314
186. 0.157 0.157 ↓ 0.0 0 157

Index Scan using "UAT WAG FR$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG FR$Detailed Cust_ Ledg_ Entry" "UAT WAG FR$Detailed Cust_ Ledg_ Entry_2" (cost=0.29..8.76 rows=2 width=14) (actual time=0.001..0.001 rows=0 loops=157)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_4"."Entry No_")
  • Buffers: shared hit=314
187. 0.157 0.157 ↓ 0.0 0 157

Index Scan using "UAT_WAG_CZ$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG CZ$Detailed Cust_ Ledg_ Entry" "UAT WAG CZ$Detailed Cust_ Ledg_ Entry_2" (cost=0.28..6.01 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=157)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_4"."Entry No_")
  • Buffers: shared hit=314
188. 109.252 491.634 ↑ 1.0 1 54,626

Aggregate (cost=44.24..44.25 rows=1 width=32) (actual time=0.008..0.009 rows=1 loops=54,626)

  • Buffers: shared hit=672,091 read=6,356
  • I/O Timings: read=26.326
189. 0.000 382.382 ↑ 5.0 2 54,626

Append (cost=0.43..44.19 rows=10 width=10) (actual time=0.003..0.007 rows=2 loops=54,626)

  • Buffers: shared hit=672,091 read=6,356
  • I/O Timings: read=26.326
190. 163.878 163.878 ↑ 1.5 2 54,626

Index Scan using "UAT_EMI_Central$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT EMI Central$Detailed Cust_ Ledg_ Entry" "UAT EMI Central$Detailed Cust_ Ledg_ Entry_3" (cost=0.43..8.64 rows=3 width=10) (actual time=0.002..0.003 rows=2 loops=54,626)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Buffers: shared hit=230,680 read=5,589
  • I/O Timings: read=23.066
191. 54.626 54.626 ↓ 0.0 0 54,626

Index Scan using "UAT WAG BE$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG BE$Detailed Cust_ Ledg_ Entry" "UAT WAG BE$Detailed Cust_ Ledg_ Entry_3" (cost=0.29..8.42 rows=2 width=10) (actual time=0.001..0.001 rows=0 loops=54,626)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Buffers: shared hit=111,042 read=228
  • I/O Timings: read=0.976
192. 54.626 54.626 ↓ 0.0 0 54,626

Index Scan using "UAT WAG ES$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG ES$Detailed Cust_ Ledg_ Entry" "UAT WAG ES$Detailed Cust_ Ledg_ Entry_3" (cost=0.29..10.02 rows=2 width=10) (actual time=0.001..0.001 rows=0 loops=54,626)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Buffers: shared hit=110,044 read=189
  • I/O Timings: read=0.774
193. 54.626 54.626 ↓ 0.0 0 54,626

Index Scan using "UAT WAG FR$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG FR$Detailed Cust_ Ledg_ Entry" "UAT WAG FR$Detailed Cust_ Ledg_ Entry_3" (cost=0.29..8.76 rows=2 width=10) (actual time=0.001..0.001 rows=0 loops=54,626)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Buffers: shared hit=110,622 read=332
  • I/O Timings: read=1.443
194. 54.626 54.626 ↓ 0.0 0 54,626

Index Scan using "UAT_WAG_CZ$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG CZ$Detailed Cust_ Ledg_ Entry" "UAT WAG CZ$Detailed Cust_ Ledg_ Entry_3" (cost=0.28..8.29 rows=1 width=9) (actual time=0.001..0.001 rows=0 loops=54,626)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Buffers: shared hit=109,703 read=18
  • I/O Timings: read=0.068
195. 21.168 105.840 ↑ 1.0 1 21,168

Aggregate (cost=40.76..40.77 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=21,168)

  • Buffers: shared hit=211,680
196. 0.000 84.672 ↓ 0.0 0 21,168

Append (cost=0.12..40.75 rows=5 width=0) (actual time=0.004..0.004 rows=0 loops=21,168)

  • Buffers: shared hit=211,680
197. 21.168 21.168 ↓ 0.0 0 21,168

Index Only Scan using "UAT EMI_Central$Billing_Cycle_Setup_NI_Cancel_TRX_Invoicing_Gro" on "UAT EMI Central$Billing Cycle Setup" "UAT EMI Central$Billing Cycle Setup_1" (cost=0.12..8.14 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=21,168)

  • Filter: ((("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Rows Removed by Filter: 1
  • Heap Fetches: 21,168
  • Buffers: shared hit=42,336
198. 21.168 21.168 ↓ 0.0 0 21,168

Index Only Scan using "UAT WAG BE$Billing_Cycle_Setup_NI_Cancel_TRX_Invoicing_Gro" on "UAT WAG BE$Billing Cycle Setup" "UAT WAG BE$Billing Cycle Setup_1" (cost=0.12..8.14 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=21,168)

  • Filter: ((("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Rows Removed by Filter: 1
  • Heap Fetches: 21,168
  • Buffers: shared hit=42,336
199. 21.168 21.168 ↓ 0.0 0 21,168

Index Only Scan using "UAT WAG ES$Billing_Cycle_Setup_NI_Cancel_TRX_Invoicing_Gro" on "UAT WAG ES$Billing Cycle Setup" "UAT WAG ES$Billing Cycle Setup_1" (cost=0.12..8.14 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=21,168)

  • Filter: ((("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Rows Removed by Filter: 1
  • Heap Fetches: 21,168
  • Buffers: shared hit=42,336
200. 21.168 21.168 ↓ 0.0 0 21,168

Index Only Scan using "UAT WAG FR$Billing_Cycle_Setup_NI_Cancel_TRX_Invoicing_Gro" on "UAT WAG FR$Billing Cycle Setup" "UAT WAG FR$Billing Cycle Setup_1" (cost=0.12..8.14 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=21,168)

  • Filter: ((("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Rows Removed by Filter: 1
  • Heap Fetches: 21,168
  • Buffers: shared hit=42,336
201. 21.168 21.168 ↓ 0.0 0 21,168

Index Only Scan using "UAT WAG_CZ$Billing_Cycle_Setup_NI_Cancel_TRX_Invoicing_Gro" on "UAT WAG CZ$Billing Cycle Setup" "UAT WAG CZ$Billing Cycle Setup_1" (cost=0.12..8.14 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=21,168)

  • Filter: ((("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Rows Removed by Filter: 1
  • Heap Fetches: 21,168
  • Buffers: shared hit=42,336
202. 0.237 3.792 ↑ 1.0 1 79

Aggregate (cost=832.80..832.81 rows=1 width=32) (actual time=0.024..0.048 rows=1 loops=79)

  • Buffers: shared hit=2,535
203. 0.338 3.555 ↑ 65,208.0 3 79

Nested Loop (cost=0.86..343.74 rows=195,624 width=6) (actual time=0.006..0.045 rows=3 loops=79)

  • Buffers: shared hit=2,535
204. 0.632 1.501 ↑ 3.5 2 79

Append (cost=0.43..49.72 rows=7 width=4) (actual time=0.003..0.019 rows=2 loops=79)

  • Buffers: shared hit=948
205. 0.237 0.237 ↑ 1.5 2 79

Index Only Scan using "UAT_EMI_Central$Cust_Ledger_Entry_Document_No1__IDX" on "UAT EMI Central$Cust_ Ledger Entry" "UAT EMI Central$Cust_ Ledger Entry_5" (cost=0.43..16.48 rows=3 width=4) (actual time=0.002..0.003 rows=2 loops=79)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 132
  • Buffers: shared hit=316
206. 0.158 0.158 ↓ 0.0 0 79

Index Only Scan using "UAT WAG BE$Cust_Ledger_Entry_Document_No1__IDX" on "UAT WAG BE$Cust_ Ledger Entry" "UAT WAG BE$Cust_ Ledger Entry_5" (cost=0.29..8.30 rows=1 width=4) (actual time=0.001..0.002 rows=0 loops=79)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 0
  • Buffers: shared hit=158
207. 0.158 0.158 ↓ 0.0 0 79

Index Only Scan using "UAT WAG ES$Cust_Ledger_Entry_Document_No1__IDX" on "UAT WAG ES$Cust_ Ledger Entry" "UAT WAG ES$Cust_ Ledger Entry_5" (cost=0.29..8.30 rows=1 width=4) (actual time=0.001..0.002 rows=0 loops=79)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 0
  • Buffers: shared hit=158
208. 0.158 0.158 ↓ 0.0 0 79

Index Only Scan using "UAT WAG FR$Cust_Ledger_Entry_Document_No1__IDX" on "UAT WAG FR$Cust_ Ledger Entry" "UAT WAG FR$Cust_ Ledger Entry_5" (cost=0.29..8.30 rows=1 width=4) (actual time=0.001..0.002 rows=0 loops=79)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 0
  • Buffers: shared hit=158
209. 0.158 0.158 ↓ 0.0 0 79

Index Only Scan using "UAT_WAG_CZ$Cust_Ledger_Entry_Document_No1__IDX" on "UAT WAG CZ$Cust_ Ledger Entry" "UAT WAG CZ$Cust_ Ledger Entry_5" (cost=0.28..8.29 rows=1 width=4) (actual time=0.001..0.002 rows=0 loops=79)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 0
  • Buffers: shared hit=158
210. 0.792 1.716 ↑ 5.0 2 132

Append (cost=0.43..41.90 rows=10 width=10) (actual time=0.002..0.013 rows=2 loops=132)

  • Buffers: shared hit=1,587
211. 0.396 0.396 ↑ 1.5 2 132

Index Scan using "UAT_EMI_Central$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT EMI Central$Detailed Cust_ Ledg_ Entry" "UAT EMI Central$Detailed Cust_ Ledg_ Entry_4" (cost=0.43..8.64 rows=3 width=10) (actual time=0.002..0.003 rows=2 loops=132)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_5"."Entry No_")
  • Buffers: shared hit=531
212. 0.132 0.132 ↓ 0.0 0 132

Index Scan using "UAT WAG BE$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG BE$Detailed Cust_ Ledg_ Entry" "UAT WAG BE$Detailed Cust_ Ledg_ Entry_4" (cost=0.29..8.42 rows=2 width=10) (actual time=0.001..0.001 rows=0 loops=132)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_5"."Entry No_")
  • Buffers: shared hit=264
213. 0.132 0.132 ↓ 0.0 0 132

Index Scan using "UAT WAG ES$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG ES$Detailed Cust_ Ledg_ Entry" "UAT WAG ES$Detailed Cust_ Ledg_ Entry_4" (cost=0.29..10.02 rows=2 width=10) (actual time=0.001..0.001 rows=0 loops=132)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_5"."Entry No_")
  • Buffers: shared hit=264
214. 0.132 0.132 ↓ 0.0 0 132

Index Scan using "UAT WAG FR$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG FR$Detailed Cust_ Ledg_ Entry" "UAT WAG FR$Detailed Cust_ Ledg_ Entry_4" (cost=0.29..8.76 rows=2 width=10) (actual time=0.001..0.001 rows=0 loops=132)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_5"."Entry No_")
  • Buffers: shared hit=264
215. 0.132 0.132 ↓ 0.0 0 132

Index Scan using "UAT_WAG_CZ$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG CZ$Detailed Cust_ Ledg_ Entry" "UAT WAG CZ$Detailed Cust_ Ledg_ Entry_4" (cost=0.28..6.01 rows=1 width=9) (actual time=0.001..0.001 rows=0 loops=132)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_5"."Entry No_")
  • Buffers: shared hit=264
216. 34.741 243.187 ↑ 1.0 1 34,741

Aggregate (cost=44.22..44.23 rows=1 width=32) (actual time=0.007..0.007 rows=1 loops=34,741)

  • Buffers: shared hit=419,909
217. 0.000 208.446 ↑ 10.0 1 34,741

Append (cost=0.43..44.19 rows=10 width=6) (actual time=0.002..0.006 rows=1 loops=34,741)

  • Buffers: shared hit=419,909
218. 69.482 69.482 ↑ 3.0 1 34,741

Index Scan using "UAT_EMI_Central$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT EMI Central$Detailed Cust_ Ledg_ Entry" "UAT EMI Central$Detailed Cust_ Ledg_ Entry_5" (cost=0.43..8.64 rows=3 width=6) (actual time=0.002..0.002 rows=1 loops=34,741)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Buffers: shared hit=139,775
219. 34.741 34.741 ↓ 0.0 0 34,741

Index Scan using "UAT WAG BE$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG BE$Detailed Cust_ Ledg_ Entry" "UAT WAG BE$Detailed Cust_ Ledg_ Entry_5" (cost=0.29..8.42 rows=2 width=6) (actual time=0.001..0.001 rows=0 loops=34,741)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Buffers: shared hit=70,051
220. 34.741 34.741 ↓ 0.0 0 34,741

Index Scan using "UAT WAG ES$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG ES$Detailed Cust_ Ledg_ Entry" "UAT WAG ES$Detailed Cust_ Ledg_ Entry_5" (cost=0.29..10.02 rows=2 width=6) (actual time=0.001..0.001 rows=0 loops=34,741)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Buffers: shared hit=69,988
221. 34.741 34.741 ↓ 0.0 0 34,741

Index Scan using "UAT WAG FR$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG FR$Detailed Cust_ Ledg_ Entry" "UAT WAG FR$Detailed Cust_ Ledg_ Entry_5" (cost=0.29..8.76 rows=2 width=6) (actual time=0.001..0.001 rows=0 loops=34,741)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Buffers: shared hit=70,255
222. 34.741 34.741 ↓ 0.0 0 34,741

Index Scan using "UAT_WAG_CZ$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG CZ$Detailed Cust_ Ledg_ Entry" "UAT WAG CZ$Detailed Cust_ Ledg_ Entry_5" (cost=0.28..8.29 rows=1 width=5) (actual time=0.001..0.001 rows=0 loops=34,741)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Buffers: shared hit=69,840
223. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=40.76..40.77 rows=1 width=8) (never executed)

224. 0.000 0.000 ↓ 0.0 0

Append (cost=0.12..40.75 rows=5 width=0) (never executed)

225. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "UAT EMI_Central$Billing_Cycle_Setup_NI_Cancel_TRX_Invoicing_Gro" on "UAT EMI Central$Billing Cycle Setup" "UAT EMI Central$Billing Cycle Setup_2" (cost=0.12..8.14 rows=1 width=0) (never executed)

  • Filter: ((("UAT EMI Central$Sales Cr_Memo Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Cr_Memo Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Heap Fetches: 0
226. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "UAT WAG BE$Billing_Cycle_Setup_NI_Cancel_TRX_Invoicing_Gro" on "UAT WAG BE$Billing Cycle Setup" "UAT WAG BE$Billing Cycle Setup_2" (cost=0.12..8.14 rows=1 width=0) (never executed)

  • Filter: ((("UAT EMI Central$Sales Cr_Memo Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Cr_Memo Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Heap Fetches: 0
227. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "UAT WAG ES$Billing_Cycle_Setup_NI_Cancel_TRX_Invoicing_Gro" on "UAT WAG ES$Billing Cycle Setup" "UAT WAG ES$Billing Cycle Setup_2" (cost=0.12..8.14 rows=1 width=0) (never executed)

  • Filter: ((("UAT EMI Central$Sales Cr_Memo Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Cr_Memo Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Heap Fetches: 0
228. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "UAT WAG FR$Billing_Cycle_Setup_NI_Cancel_TRX_Invoicing_Gro" on "UAT WAG FR$Billing Cycle Setup" "UAT WAG FR$Billing Cycle Setup_2" (cost=0.12..8.14 rows=1 width=0) (never executed)

  • Filter: ((("UAT EMI Central$Sales Cr_Memo Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Cr_Memo Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Heap Fetches: 0
229. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "UAT WAG_CZ$Billing_Cycle_Setup_NI_Cancel_TRX_Invoicing_Gro" on "UAT WAG CZ$Billing Cycle Setup" "UAT WAG CZ$Billing Cycle Setup_2" (cost=0.12..8.14 rows=1 width=0) (never executed)

  • Filter: ((("UAT EMI Central$Sales Cr_Memo Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Cr_Memo Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Heap Fetches: 0