explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sCr9

Settings
# exclusive inclusive rows x rows loops node
1. 0.876 3.197 ↑ 1.1 1,140 1

Append (cost=0.12..662.80 rows=1,200 width=23) (actual time=0.979..3.197 rows=1,140 loops=1)

2. 0.013 0.013 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_03_2018 on stg_mtx_transaction_header_dec_03_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
3. 0.008 0.008 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_04_2018 on stg_mtx_transaction_header_dec_04_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.007..0.008 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
4. 0.008 0.008 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_05_2018 on stg_mtx_transaction_header_dec_05_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
5. 0.011 0.011 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_06_2018 on stg_mtx_transaction_header_dec_06_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
6. 0.008 0.008 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_07_2018 on stg_mtx_transaction_header_dec_07_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.007..0.008 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
7. 0.008 0.008 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_08_2018 on stg_mtx_transaction_header_dec_08_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
8. 0.011 0.011 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_09_2018 on stg_mtx_transaction_header_dec_09_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.010..0.011 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
9. 0.008 0.008 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_10_2018 on stg_mtx_transaction_header_dec_10_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
10. 0.014 0.014 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_11_2018 on stg_mtx_transaction_header_dec_11_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
11. 0.009 0.009 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_12_2018 on stg_mtx_transaction_header_dec_12_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.008..0.009 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
12. 0.008 0.008 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_13_2018 on stg_mtx_transaction_header_dec_13_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.007..0.008 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
13. 0.779 0.779 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_14_2018 on stg_mtx_transaction_header_dec_14_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.779..0.779 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
14. 0.004 0.004 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_15_2018 on stg_mtx_transaction_header_dec_15_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
15. 0.016 0.016 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_16_2018 on stg_mtx_transaction_header_dec_16_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.015..0.016 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
16. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_17_2018 on stg_mtx_transaction_header_dec_17_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
17. 0.002 0.002 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_18_2018 on stg_mtx_transaction_header_dec_18_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
18. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_19_2018 on stg_mtx_transaction_header_dec_19_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
19. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_20_2018 on stg_mtx_transaction_header_dec_20_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
20. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_21_2018 on stg_mtx_transaction_header_dec_21_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
21. 0.002 0.002 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_22_2018 on stg_mtx_transaction_header_dec_22_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
22. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_23_2018 on stg_mtx_transaction_header_dec_23_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
23. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_24_2018 on stg_mtx_transaction_header_dec_24_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
24. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_25_2018 on stg_mtx_transaction_header_dec_25_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
25. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_26_2018 on stg_mtx_transaction_header_dec_26_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
26. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_27_2018 on stg_mtx_transaction_header_dec_27_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
27. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_28_2018 on stg_mtx_transaction_header_dec_28_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
28. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_29_2018 on stg_mtx_transaction_header_dec_29_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
29. 0.002 0.002 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_30_2018 on stg_mtx_transaction_header_dec_30_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
30. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_dec_31_2018 on stg_mtx_transaction_header_dec_31_2018 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
31. 0.002 0.002 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_01_2019 on stg_mtx_transaction_header_jan_01_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.001..0.002 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
32. 0.002 0.002 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_02_2019 on stg_mtx_transaction_header_jan_02_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
33. 1.274 1.274 ↑ 1.0 1,140 1

Seq Scan on stg_mtx_transaction_header_jan_03_2019 (cost=0.00..167.65 rows=1,140 width=21) (actual time=0.010..1.274 rows=1,140 loops=1)

  • Filter: ((transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone) AND (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019 (...)
34. 0.012 0.012 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_04_2019 on stg_mtx_transaction_header_jan_04_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.011..0.012 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
  • Rows Removed by Filter: 1
35. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_05_2019 on stg_mtx_transaction_header_jan_05_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
36. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_06_2019 on stg_mtx_transaction_header_jan_06_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
37. 0.002 0.002 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_07_2019 on stg_mtx_transaction_header_jan_07_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
38. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_08_2019 on stg_mtx_transaction_header_jan_08_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
39. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_09_2019 on stg_mtx_transaction_header_jan_09_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
40. 0.014 0.014 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_10_2019 on stg_mtx_transaction_header_jan_10_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.013..0.014 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
41. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_11_2019 on stg_mtx_transaction_header_jan_11_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
42. 0.002 0.002 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_12_2019 on stg_mtx_transaction_header_jan_12_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
43. 0.002 0.002 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_13_2019 on stg_mtx_transaction_header_jan_13_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
44. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_14_2019 on stg_mtx_transaction_header_jan_14_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
45. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_15_2019 on stg_mtx_transaction_header_jan_15_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
46. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_16_2019 on stg_mtx_transaction_header_jan_16_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
47. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_17_2019 on stg_mtx_transaction_header_jan_17_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
48. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_18_2019 on stg_mtx_transaction_header_jan_18_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
49. 0.002 0.002 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_19_2019 on stg_mtx_transaction_header_jan_19_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
50. 0.002 0.002 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_20_2019 on stg_mtx_transaction_header_jan_20_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
51. 0.002 0.002 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_21_2019 on stg_mtx_transaction_header_jan_21_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
52. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_22_2019 on stg_mtx_transaction_header_jan_22_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
53. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_23_2019 on stg_mtx_transaction_header_jan_23_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
54. 0.002 0.002 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_24_2019 on stg_mtx_transaction_header_jan_24_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
55. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_25_2019 on stg_mtx_transaction_header_jan_25_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
56. 0.002 0.002 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_26_2019 on stg_mtx_transaction_header_jan_26_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
57. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_27_2019 on stg_mtx_transaction_header_jan_27_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
58. 0.002 0.002 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_28_2019 on stg_mtx_transaction_header_jan_28_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.001..0.002 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
59. 0.002 0.002 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_29_2019 on stg_mtx_transaction_header_jan_29_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
60. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_30_2019 on stg_mtx_transaction_header_jan_30_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
61. 0.002 0.002 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_jan_31_2019 on stg_mtx_transaction_header_jan_31_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)
62. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_txn_hdr_transfer_id_feb_01_2019 on stg_mtx_transaction_header_feb_01_2019 (cost=0.12..8.15 rows=1 width=58) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (transfer_date >= '2018-12-03 00:00:00'::timestamp without time zone)
  • Filter: (((created_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (created_on < '2019-01-04 00:00:00'::timestamp without time zone)) OR ((modified_on >= '2019-01-03 00:00:00'::timestamp without time zone) AND (modified_on < '2019-01- (...)