explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4Jw4

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 139.397 ↓ 0.0 0 1

Nested Loop (cost=620.23..6,894.47 rows=37,292 width=21) (actual time=139.397..139.397 rows=0 loops=1)

  • Join Filter: ((hdr.transfer_date >= datetym.transfer_date) AND (hdr.transfer_date < datetym.cut_off))
2.          

CTE datetym

3. 0.003 0.003 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=1)

4. 0.006 0.006 ↑ 1.0 1 1

CTE Scan on datetym (cost=0.00..0.02 rows=1 width=8) (actual time=0.004..0.006 rows=1 loops=1)

5. 3.400 139.388 ↓ 0.0 0 1

Nested Loop (cost=620.22..1,859.99 rows=335,630 width=29) (actual time=139.388..139.388 rows=0 loops=1)

6. 1.636 4.888 ↓ 22.4 1,140 1

HashAggregate (cost=620.09..620.60 rows=51 width=22) (actual time=3.978..4.888 rows=1,140 loops=1)

  • Group Key: (shdr.transfer_id)::text
7. 0.917 3.252 ↓ 22.4 1,140 1

Nested Loop (cost=0.12..619.97 rows=51 width=22) (actual time=0.290..3.252 rows=1,140 loops=1)

8. 0.003 0.003 ↑ 1.0 1 1

CTE Scan on datetym datetym_1 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.003 rows=1 loops=1)

9. 0.909 2.332 ↓ 10.4 1,140 1

Append (cost=0.12..618.85 rows=110 width=46) (actual time=0.281..2.332 rows=1,140 loops=1)

10. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_02_2018 on stg_mtx_transaction_header_dec_02_2018 shdr (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_03_2018 on stg_mtx_transaction_header_dec_03_2018 shdr_1 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
12. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_04_2018 on stg_mtx_transaction_header_dec_04_2018 shdr_2 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
13. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_05_2018 on stg_mtx_transaction_header_dec_05_2018 shdr_3 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_06_2018 on stg_mtx_transaction_header_dec_06_2018 shdr_4 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_07_2018 on stg_mtx_transaction_header_dec_07_2018 shdr_5 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
16. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_08_2018 on stg_mtx_transaction_header_dec_08_2018 shdr_6 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
17. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_09_2018 on stg_mtx_transaction_header_dec_09_2018 shdr_7 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
18. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_10_2018 on stg_mtx_transaction_header_dec_10_2018 shdr_8 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_11_2018 on stg_mtx_transaction_header_dec_11_2018 shdr_9 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_12_2018 on stg_mtx_transaction_header_dec_12_2018 shdr_10 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_13_2018 on stg_mtx_transaction_header_dec_13_2018 shdr_11 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_14_2018 on stg_mtx_transaction_header_dec_14_2018 shdr_12 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
23. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_15_2018 on stg_mtx_transaction_header_dec_15_2018 shdr_13 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
24. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_16_2018 on stg_mtx_transaction_header_dec_16_2018 shdr_14 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
25. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_17_2018 on stg_mtx_transaction_header_dec_17_2018 shdr_15 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
26. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_18_2018 on stg_mtx_transaction_header_dec_18_2018 shdr_16 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
27. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_19_2018 on stg_mtx_transaction_header_dec_19_2018 shdr_17 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
28. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_20_2018 on stg_mtx_transaction_header_dec_20_2018 shdr_18 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
29. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_21_2018 on stg_mtx_transaction_header_dec_21_2018 shdr_19 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
30. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_22_2018 on stg_mtx_transaction_header_dec_22_2018 shdr_20 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
31. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_23_2018 on stg_mtx_transaction_header_dec_23_2018 shdr_21 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
32. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_24_2018 on stg_mtx_transaction_header_dec_24_2018 shdr_22 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
33. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_25_2018 on stg_mtx_transaction_header_dec_25_2018 shdr_23 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
34. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_26_2018 on stg_mtx_transaction_header_dec_26_2018 shdr_24 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
35. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_27_2018 on stg_mtx_transaction_header_dec_27_2018 shdr_25 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
36. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_28_2018 on stg_mtx_transaction_header_dec_28_2018 shdr_26 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
37. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_29_2018 on stg_mtx_transaction_header_dec_29_2018 shdr_27 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
38. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_30_2018 on stg_mtx_transaction_header_dec_30_2018 shdr_28 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
39. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_dec_31_2018 on stg_mtx_transaction_header_dec_31_2018 shdr_29 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
40. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_01_2019 on stg_mtx_transaction_header_jan_01_2019 shdr_30 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
41. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_02_2019 on stg_mtx_transaction_header_jan_02_2019 shdr_31 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
42. 1.168 1.423 ↓ 42.2 1,140 1

Bitmap Heap Scan on stg_mtx_transaction_header_jan_03_2019 shdr_32 (cost=28.91..100.24 rows=27 width=45) (actual time=0.274..1.423 rows=1,140 loops=1)

  • Recheck Cond: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_dat (...)
  • Heap Blocks: exact=142
43. 0.009 0.255 ↓ 0.0 0 1

BitmapAnd (cost=28.91..28.91 rows=28 width=0) (actual time=0.254..0.255 rows=0 loops=1)

44. 0.086 0.086 ↓ 9.0 1,140 1

Bitmap Index Scan on idx_txn_hdr_transfer_date_jan_03_2019 (cost=0.00..9.55 rows=127 width=0) (actual time=0.086..0.086 rows=1,140 loops=1)

  • Index Cond: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off))
45. 0.002 0.160 ↓ 0.0 0 1

BitmapOr (cost=19.11..19.11 rows=253 width=0) (actual time=0.159..0.160 rows=0 loops=1)

46. 0.082 0.082 ↓ 9.0 1,140 1

Bitmap Index Scan on idx_txn_hdr_created_on_jan_03_2019 (cost=0.00..9.55 rows=127 width=0) (actual time=0.081..0.082 rows=1,140 loops=1)

  • Index Cond: ((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off))
47. 0.076 0.076 ↓ 9.0 1,140 1

Bitmap Index Scan on idx_txn_hdr_modified_on_jan_03_2019 (cost=0.00..9.55 rows=127 width=0) (actual time=0.076..0.076 rows=1,140 loops=1)

  • Index Cond: ((modified_on >= datetym_1.transfer_date) AND (modified_on < datetym_1.cut_off))
48. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_date_jan_04_2019 on stg_mtx_transaction_header_jan_04_2019 shdr_33 (cost=0.28..28.76 rows=23 width=45) (never executed)

  • Index Cond: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off))
  • Filter: (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (modified_on < datetym_1.cut_off)))
49. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_05_2019 on stg_mtx_transaction_header_jan_05_2019 shdr_34 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
50. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_06_2019 on stg_mtx_transaction_header_jan_06_2019 shdr_35 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
51. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_07_2019 on stg_mtx_transaction_header_jan_07_2019 shdr_36 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
52. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_08_2019 on stg_mtx_transaction_header_jan_08_2019 shdr_37 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
53. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_09_2019 on stg_mtx_transaction_header_jan_09_2019 shdr_38 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
54. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_10_2019 on stg_mtx_transaction_header_jan_10_2019 shdr_39 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
55. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_11_2019 on stg_mtx_transaction_header_jan_11_2019 shdr_40 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
56. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_12_2019 on stg_mtx_transaction_header_jan_12_2019 shdr_41 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
57. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_13_2019 on stg_mtx_transaction_header_jan_13_2019 shdr_42 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
58. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_14_2019 on stg_mtx_transaction_header_jan_14_2019 shdr_43 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
59. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_15_2019 on stg_mtx_transaction_header_jan_15_2019 shdr_44 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
60. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_16_2019 on stg_mtx_transaction_header_jan_16_2019 shdr_45 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
61. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_17_2019 on stg_mtx_transaction_header_jan_17_2019 shdr_46 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
62. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_18_2019 on stg_mtx_transaction_header_jan_18_2019 shdr_47 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
63. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_19_2019 on stg_mtx_transaction_header_jan_19_2019 shdr_48 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
64. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_20_2019 on stg_mtx_transaction_header_jan_20_2019 shdr_49 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
65. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_21_2019 on stg_mtx_transaction_header_jan_21_2019 shdr_50 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
66. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_22_2019 on stg_mtx_transaction_header_jan_22_2019 shdr_51 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
67. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_23_2019 on stg_mtx_transaction_header_jan_23_2019 shdr_52 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
68. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_24_2019 on stg_mtx_transaction_header_jan_24_2019 shdr_53 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
69. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_25_2019 on stg_mtx_transaction_header_jan_25_2019 shdr_54 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
70. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_26_2019 on stg_mtx_transaction_header_jan_26_2019 shdr_55 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
71. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_27_2019 on stg_mtx_transaction_header_jan_27_2019 shdr_56 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
72. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_28_2019 on stg_mtx_transaction_header_jan_28_2019 shdr_57 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
73. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_29_2019 on stg_mtx_transaction_header_jan_29_2019 shdr_58 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
74. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_30_2019 on stg_mtx_transaction_header_jan_30_2019 shdr_59 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
75. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_jan_31_2019 on stg_mtx_transaction_header_jan_31_2019 shdr_60 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
76. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_txn_hdr_transfer_id_feb_01_2019 on stg_mtx_transaction_header_feb_01_2019 shdr_61 (cost=0.12..8.15 rows=1 width=82) (never executed)

  • Filter: ((transfer_date >= datetym_1.transfer_date) AND (transfer_date < datetym_1.cut_off) AND (((created_on >= datetym_1.transfer_date) AND (created_on < datetym_1.cut_off)) OR ((modified_on >= datetym_1.transfer_date) AND (...)
77. 44.460 131.100 ↓ 0.0 0 1,140

Append (cost=0.12..23.68 rows=62 width=29) (actual time=0.115..0.115 rows=0 loops=1,140)

78. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_02_2018 on fact_transaction_header_dec_02_2018 hdr (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
79. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_03_2018 on fact_transaction_header_dec_03_2018 hdr_1 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
80. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_04_2018 on fact_transaction_header_dec_04_2018 hdr_2 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
81. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_05_2018 on fact_transaction_header_dec_05_2018 hdr_3 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
82. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_06_2018 on fact_transaction_header_dec_06_2018 hdr_4 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
83. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_07_2018 on fact_transaction_header_dec_07_2018 hdr_5 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
84. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_08_2018 on fact_transaction_header_dec_08_2018 hdr_6 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
85. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_09_2018 on fact_transaction_header_dec_09_2018 hdr_7 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
86. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_10_2018 on fact_transaction_header_dec_10_2018 hdr_8 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
87. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_11_2018 on fact_transaction_header_dec_11_2018 hdr_9 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
88. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_12_2018 on fact_transaction_header_dec_12_2018 hdr_10 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
89. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_13_2018 on fact_transaction_header_dec_13_2018 hdr_11 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
90. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_14_2018 on fact_transaction_header_dec_14_2018 hdr_12 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
91. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_15_2018 on fact_transaction_header_dec_15_2018 hdr_13 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
92. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_16_2018 on fact_transaction_header_dec_16_2018 hdr_14 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
93. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_17_2018 on fact_transaction_header_dec_17_2018 hdr_15 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
94. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_18_2018 on fact_transaction_header_dec_18_2018 hdr_16 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
95. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_19_2018 on fact_transaction_header_dec_19_2018 hdr_17 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
96. 5.700 5.700 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_20_2018 on fact_transaction_header_dec_20_2018 hdr_18 (cost=0.42..5.39 rows=1 width=29) (actual time=0.005..0.005 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
97. 4.560 4.560 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_21_2018 on fact_transaction_header_dec_21_2018 hdr_19 (cost=0.28..0.46 rows=1 width=29) (actual time=0.004..0.004 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
98. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_22_2018 on fact_transaction_header_dec_22_2018 hdr_20 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
99. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_23_2018 on fact_transaction_header_dec_23_2018 hdr_21 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
100. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_24_2018 on fact_transaction_header_dec_24_2018 hdr_22 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
101. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_25_2018 on fact_transaction_header_dec_25_2018 hdr_23 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
102. 5.700 5.700 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_26_2018 on fact_transaction_header_dec_26_2018 hdr_24 (cost=0.42..7.46 rows=1 width=29) (actual time=0.005..0.005 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
103. 3.420 3.420 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_27_2018 on fact_transaction_header_dec_27_2018 hdr_25 (cost=0.28..0.59 rows=1 width=29) (actual time=0.003..0.003 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
104. 2.280 2.280 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_28_2018 on fact_transaction_header_dec_28_2018 hdr_26 (cost=0.14..0.19 rows=1 width=29) (actual time=0.002..0.002 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
105. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_29_2018 on fact_transaction_header_dec_29_2018 hdr_27 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
106. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_30_2018 on fact_transaction_header_dec_30_2018 hdr_28 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
107. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_dec_31_2018 on fact_transaction_header_dec_31_2018 hdr_29 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
108. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_01_2019 on fact_transaction_header_jan_01_2019 hdr_30 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
109. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_02_2019 on fact_transaction_header_jan_02_2019 hdr_31 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
110. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_03_2019 on fact_transaction_header_jan_03_2019 hdr_32 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
111. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_04_2019 on fact_transaction_header_jan_04_2019 hdr_33 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
112. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_05_2019 on fact_transaction_header_jan_05_2019 hdr_34 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
113. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_06_2019 on fact_transaction_header_jan_06_2019 hdr_35 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
114. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_07_2019 on fact_transaction_header_jan_07_2019 hdr_36 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
115. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_08_2019 on fact_transaction_header_jan_08_2019 hdr_37 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
116. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_09_2019 on fact_transaction_header_jan_09_2019 hdr_38 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
117. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_10_2019 on fact_transaction_header_jan_10_2019 hdr_39 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
118. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_11_2019 on fact_transaction_header_jan_11_2019 hdr_40 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
119. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_12_2019 on fact_transaction_header_jan_12_2019 hdr_41 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
120. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_13_2019 on fact_transaction_header_jan_13_2019 hdr_42 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
121. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_14_2019 on fact_transaction_header_jan_14_2019 hdr_43 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
122. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_15_2019 on fact_transaction_header_jan_15_2019 hdr_44 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
123. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_16_2019 on fact_transaction_header_jan_16_2019 hdr_45 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
124. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_17_2019 on fact_transaction_header_jan_17_2019 hdr_46 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
125. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_18_2019 on fact_transaction_header_jan_18_2019 hdr_47 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
126. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_19_2019 on fact_transaction_header_jan_19_2019 hdr_48 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
127. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_20_2019 on fact_transaction_header_jan_20_2019 hdr_49 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
128. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_21_2019 on fact_transaction_header_jan_21_2019 hdr_50 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
129. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_22_2019 on fact_transaction_header_jan_22_2019 hdr_51 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
130. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_23_2019 on fact_transaction_header_jan_23_2019 hdr_52 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
131. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_24_2019 on fact_transaction_header_jan_24_2019 hdr_53 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
132. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_25_2019 on fact_transaction_header_jan_25_2019 hdr_54 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
133. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_26_2019 on fact_transaction_header_jan_26_2019 hdr_55 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
134. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_27_2019 on fact_transaction_header_jan_27_2019 hdr_56 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
135. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_28_2019 on fact_transaction_header_jan_28_2019 hdr_57 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
136. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_29_2019 on fact_transaction_header_jan_29_2019 hdr_58 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
137. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_30_2019 on fact_transaction_header_jan_30_2019 hdr_59 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
138. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_jan_31_2019 on fact_transaction_header_jan_31_2019 hdr_60 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)
139. 1.140 1.140 ↓ 0.0 0 1,140

Index Scan using transfer_id_pk_feb_01_2019 on fact_transaction_header_feb_01_2019 hdr_61 (cost=0.12..0.16 rows=1 width=66) (actual time=0.001..0.001 rows=0 loops=1,140)

  • Index Cond: ((transfer_id)::text = (shdr.transfer_id)::text)