explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RhDJ : aaa

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 61.719 ↓ 0.0 0 1

Gather Merge (cost=45,356.28..45,360.18 rows=33 width=198) (actual time=57.809..61.719 rows=0 loops=1)

  • Output: tg.trade_group_id, tg.trade_group_type_code, tg.created_timestamp, tg.trading_date, tg.nex_user_id, tg.auction_id, usr.last_name, usr.first_name, org.name, mt.matched_trade_id, mt.itm_account_code, mt.lots, tg.trade_status_code, mt.trade_price, mt.price_warning_flag, mt.skip_calculation_flag, mt.group_id, mt.lots_display_option, mt.expiry_id, e.expiration_date, e.contract_term_code, e.contract_type, e.contract_class_code, c.physical_commodity_code, i.iso_name, cn.contract_node_name, ed.lot_size, esp.auction_price, mt.marking_price, pc.commodity_type_code, mt.deal_id
  • Workers Planned: 3
  • Workers Launched: 3
  • Buffers: shared hit=5995
2. 0.116 99.700 ↓ 0.0 0 4

Sort (cost=44,356.24..44,356.27 rows=11 width=198) (actual time=24.925..24.925 rows=0 loops=4)

  • Output: tg.trade_group_id, tg.trade_group_type_code, tg.created_timestamp, tg.trading_date, tg.nex_user_id, tg.auction_id, usr.last_name, usr.first_name, org.name, mt.matched_trade_id, mt.itm_account_code, mt.lots, tg.trade_status_code, mt.trade_price, mt.price_warning_flag, mt.skip_calculation_flag, mt.group_id, mt.lots_display_option, mt.expiry_id, e.expiration_date, e.contract_term_code, e.contract_type, e.contract_class_code, c.physical_commodity_code, i.iso_name, cn.contract_node_name, ed.lot_size, esp.auction_price, mt.marking_price, pc.commodity_type_code, mt.deal_id
  • Sort Key: tg.trade_group_id DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=5995
  • Worker 0: actual time=25.541..25.541 rows=0 loops=1
  • Buffers: shared hit=1519
  • Worker 1: actual time=24.195..24.195 rows=0 loops=1
  • Buffers: shared hit=1519
  • Worker 2: actual time=25.541..25.541 rows=0 loops=1
  • Buffers: shared hit=1519
3. 0.068 99.584 ↓ 0.0 0 4

Hash Join (cost=15,954.14..44,356.05 rows=11 width=198) (actual time=24.896..24.896 rows=0 loops=4)

  • Output: tg.trade_group_id, tg.trade_group_type_code, tg.created_timestamp, tg.trading_date, tg.nex_user_id, tg.auction_id, usr.last_name, usr.first_name, org.name, mt.matched_trade_id, mt.itm_account_code, mt.lots, tg.trade_status_code, mt.trade_price, mt.price_warning_flag, mt.skip_calculation_flag, mt.group_id, mt.lots_display_option, mt.expiry_id, e.expiration_date, e.contract_term_code, e.contract_type, e.contract_class_code, c.physical_commodity_code, i.iso_name, cn.contract_node_name, ed.lot_size, esp.auction_price, mt.marking_price, pc.commodity_type_code, mt.deal_id
  • Hash Cond: (e.expiry_id = mt.expiry_id)
  • Buffers: shared hit=5974
  • Worker 0: actual time=25.506..25.506 rows=0 loops=1
  • Buffers: shared hit=1512
  • Worker 1: actual time=24.158..24.159 rows=0 loops=1
  • Buffers: shared hit=1512
  • Worker 2: actual time=25.506..25.506 rows=0 loops=1
  • Buffers: shared hit=1512
4. 0.708 88.132 ↑ 89,086.0 1 4

Hash Join (cost=1,664.81..29,287.10 rows=89,086 width=52) (actual time=22.033..22.033 rows=1 loops=4)

  • Output: e.expiration_date, e.contract_term_code, e.contract_type, e.contract_class_code, e.expiry_id, c.physical_commodity_code, pc.commodity_type_code, cn.contract_node_name, i.iso_name, ed.lot_size
  • Inner Unique: true
  • Hash Cond: ((e.expiration_date = ed.expiration_date) AND ((e.contract_term_code)::text = (ed.contract_term_code)::text) AND ((e.contract_class_code)::text = (ed.contract_class_code)::text) AND (pc.iso_code = ed.iso_code))
  • Buffers: shared hit=1836
  • Worker 0: actual time=22.285..22.285 rows=1 loops=1
  • Buffers: shared hit=477
  • Worker 1: actual time=21.898..21.898 rows=1 loops=1
  • Buffers: shared hit=477
  • Worker 2: actual time=22.287..22.287 rows=1 loops=1
  • Buffers: shared hit=477
5. 0.060 77.764 ↑ 83,367.0 1 4

Hash Join (cost=1,391.66..28,138.42 rows=83,367 width=83) (actual time=19.441..19.441 rows=1 loops=4)

  • Output: e.expiration_date, e.contract_term_code, e.contract_type, e.contract_class_code, e.iso_code, e.expiry_id, c.physical_commodity_code, pc.commodity_type_code, pc.iso_code, cn.contract_node_name, cn.iso_code, i.iso_name, i.iso_code, cc.contract_class_code
  • Inner Unique: true
  • Hash Cond: ((e.contract_class_code)::text = (cc.contract_class_code)::text)
  • Buffers: shared hit=1380
  • Worker 0: actual time=19.653..19.653 rows=1 loops=1
  • Buffers: shared hit=345
  • Worker 1: actual time=19.249..19.249 rows=1 loops=1
  • Buffers: shared hit=345
  • Worker 2: actual time=19.655..19.655 rows=1 loops=1
  • Buffers: shared hit=345
6. 0.340 77.640 ↑ 83,367.0 1 4

Hash Join (cost=1,390.55..27,732.99 rows=83,367 width=79) (actual time=19.410..19.410 rows=1 loops=4)

  • Output: e.expiration_date, e.contract_term_code, e.contract_type, e.contract_class_code, e.iso_code, e.expiry_id, c.physical_commodity_code, pc.commodity_type_code, pc.iso_code, cn.contract_node_name, cn.iso_code, i.iso_name, i.iso_code
  • Hash Cond: ((e.contract_id = c.contract_id) AND (e.iso_code = pc.iso_code))
  • Buffers: shared hit=1376
  • Worker 0: actual time=19.621..19.621 rows=1 loops=1
  • Buffers: shared hit=344
  • Worker 1: actual time=19.213..19.213 rows=1 loops=1
  • Buffers: shared hit=344
  • Worker 2: actual time=19.622..19.622 rows=1 loops=1
  • Buffers: shared hit=344
7. 0.040 0.040 ↑ 387,987.0 1 4

Parallel Seq Scan on mos.expiry e (cost=0.00..22,598.87 rows=387,987 width=35) (actual time=0.010..0.010 rows=1 loops=4)

  • Output: e.expiry_id, e.expiry_status_code, e.expiration_date, e.contract_term_code, e.contract_class_code, e.iso_code, e.contract_id, e.parent_expiry_id, e.node_type_tier, e.parent_price_move_weight, e.activation_date, e.closing_date, e.restriction_date, e.include_lmp_flag, e.updated_timestamp, e.exclude_var_flag, e.latest_price, e.contract_type, e.average_daily_volume
  • Buffers: shared hit=4
  • Worker 0: actual time=0.012..0.012 rows=1 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.011..0.011 rows=1 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.012..0.012 rows=1 loops=1
  • Buffers: shared hit=1
8. 8.256 77.260 ↑ 1.6 8,451 4

Hash (cost=1,184.24..1,184.24 rows=13,754 width=60) (actual time=19.315..19.315 rows=8,451 loops=4)

  • Output: c.physical_commodity_code, c.contract_id, pc.commodity_type_code, pc.iso_code, cn.contract_node_name, cn.iso_code, i.iso_name, i.iso_code
  • Buckets: 16384 Batches: 1 Memory Usage: 1008kB
  • Buffers: shared hit=1372
  • Worker 0: actual time=19.533..19.533 rows=8451 loops=1
  • Buffers: shared hit=343
  • Worker 1: actual time=19.099..19.099 rows=8451 loops=1
  • Buffers: shared hit=343
  • Worker 2: actual time=19.531..19.531 rows=8451 loops=1
  • Buffers: shared hit=343
9. 8.436 69.004 ↑ 1.6 8,451 4

Hash Join (cost=744.61..1,184.24 rows=13,754 width=60) (actual time=14.129..17.251 rows=8,451 loops=4)

  • Output: c.physical_commodity_code, c.contract_id, pc.commodity_type_code, pc.iso_code, cn.contract_node_name, cn.iso_code, i.iso_name, i.iso_code
  • Hash Cond: ((c.physical_commodity_code)::text = (pc.physical_commodity_code)::text)
  • Buffers: shared hit=1372
  • Worker 0: actual time=14.378..17.567 rows=8451 loops=1
  • Buffers: shared hit=343
  • Worker 1: actual time=13.994..16.976 rows=8451 loops=1
  • Buffers: shared hit=343
  • Worker 2: actual time=14.397..17.520 rows=8451 loops=1
  • Buffers: shared hit=343
10. 4.424 4.424 ↑ 1.6 8,451 4

Seq Scan on mos.contract c (cost=0.00..303.54 rows=13,754 width=12) (actual time=0.011..1.106 rows=8,451 loops=4)

  • Output: c.contract_id, c.physical_commodity_code, c.contract_term_code, c.parent_contract_id, c.parent_price_move_weight, c.last_active_date, c.first_active_date, c.hub_contract_id, c.updated_timestamp, c.cftc_position_limit, c.contract_status, c.expiry_count, c.expected_expiry_count
  • Buffers: shared hit=664
  • Worker 0: actual time=0.012..1.139 rows=8451 loops=1
  • Buffers: shared hit=166
  • Worker 1: actual time=0.011..1.013 rows=8451 loops=1
  • Buffers: shared hit=166
  • Worker 2: actual time=0.010..1.103 rows=8451 loops=1
  • Buffers: shared hit=166
11. 7.752 56.144 ↑ 1.0 8,451 4

Hash (cost=638.97..638.97 rows=8,451 width=52) (actual time=14.036..14.036 rows=8,451 loops=4)

  • Output: pc.commodity_type_code, pc.physical_commodity_code, pc.iso_code, cn.contract_node_name, cn.iso_code, i.iso_name, i.iso_code
  • Buckets: 16384 Batches: 1 Memory Usage: 876kB
  • Buffers: shared hit=708
  • Worker 0: actual time=14.290..14.290 rows=8451 loops=1
  • Buffers: shared hit=177
  • Worker 1: actual time=13.885..13.885 rows=8451 loops=1
  • Buffers: shared hit=177
  • Worker 2: actual time=14.308..14.308 rows=8451 loops=1
  • Buffers: shared hit=177
12. 6.340 48.392 ↑ 1.0 8,451 4

Hash Join (cost=144.52..638.97 rows=8,451 width=52) (actual time=1.444..12.098 rows=8,451 loops=4)

  • Output: pc.commodity_type_code, pc.physical_commodity_code, pc.iso_code, cn.contract_node_name, cn.iso_code, i.iso_name, i.iso_code
  • Hash Cond: ((cn.auction_schedule_type_code)::text = (st.schedule_type_code)::text)
  • Buffers: shared hit=708
  • Worker 0: actual time=1.463..12.354 rows=8451 loops=1
  • Buffers: shared hit=177
  • Worker 1: actual time=1.459..11.862 rows=8451 loops=1
  • Buffers: shared hit=177
  • Worker 2: actual time=1.460..12.369 rows=8451 loops=1
  • Buffers: shared hit=177
13. 5.356 41.996 ↑ 1.0 8,451 4

Hash Join (cost=143.48..521.72 rows=8,451 width=56) (actual time=1.418..10.499 rows=8,451 loops=4)

  • Output: pc.commodity_type_code, pc.physical_commodity_code, pc.iso_code, cn.contract_node_name, cn.iso_code, cn.auction_schedule_type_code, i.iso_name, i.iso_code
  • Inner Unique: true
  • Hash Cond: ((pc.commodity_type_code)::text = (ct.commodity_type_code)::text)
  • Buffers: shared hit=704
  • Worker 0: actual time=1.435..10.727 rows=8451 loops=1
  • Buffers: shared hit=176
  • Worker 1: actual time=1.425..10.300 rows=8451 loops=1
  • Buffers: shared hit=176
  • Worker 2: actual time=1.436..10.711 rows=8451 loops=1
  • Buffers: shared hit=176
14. 5.392 36.568 ↑ 1.0 8,451 4

Hash Join (cost=142.32..484.95 rows=8,451 width=56) (actual time=1.386..9.142 rows=8,451 loops=4)

  • Output: pc.commodity_type_code, pc.physical_commodity_code, pc.iso_code, cn.contract_node_name, cn.iso_code, cn.auction_schedule_type_code, i.iso_name, i.iso_code
  • Inner Unique: true
  • Hash Cond: ((pc.lch_grouping_code)::text = (pcg.lch_grouping_code)::text)
  • Buffers: shared hit=700
  • Worker 0: actual time=1.397..9.336 rows=8451 loops=1
  • Buffers: shared hit=175
  • Worker 1: actual time=1.392..8.971 rows=8451 loops=1
  • Buffers: shared hit=175
  • Worker 2: actual time=1.400..9.309 rows=8451 loops=1
  • Buffers: shared hit=175
15. 5.728 31.116 ↑ 1.0 8,451 4

Hash Join (cost=140.94..455.86 rows=8,451 width=60) (actual time=1.360..7.779 rows=8,451 loops=4)

  • Output: pc.commodity_type_code, pc.physical_commodity_code, pc.iso_code, pc.lch_grouping_code, cn.contract_node_name, cn.iso_code, cn.auction_schedule_type_code, i.iso_name, i.iso_code
  • Inner Unique: true
  • Hash Cond: ((cn.node_type_code)::text = (nt.node_type_code)::text)
  • Buffers: shared hit=696
  • Worker 0: actual time=1.371..7.910 rows=8451 loops=1
  • Buffers: shared hit=174
  • Worker 1: actual time=1.361..7.636 rows=8451 loops=1
  • Buffers: shared hit=174
  • Worker 2: actual time=1.373..7.910 rows=8451 loops=1
  • Buffers: shared hit=174
16. 5.916 25.332 ↑ 1.0 8,451 4

Hash Join (cost=139.60..426.07 rows=8,451 width=64) (actual time=1.332..6.333 rows=8,451 loops=4)

  • Output: pc.commodity_type_code, pc.physical_commodity_code, pc.iso_code, pc.lch_grouping_code, cn.contract_node_name, cn.iso_code, cn.node_type_code, cn.auction_schedule_type_code, i.iso_name, i.iso_code
  • Inner Unique: true
  • Hash Cond: (pc.iso_code = i.iso_code)
  • Buffers: shared hit=692
  • Worker 0: actual time=1.342..6.443 rows=8451 loops=1
  • Buffers: shared hit=173
  • Worker 1: actual time=1.328..6.224 rows=8451 loops=1
  • Buffers: shared hit=173
  • Worker 2: actual time=1.345..6.401 rows=8451 loops=1
  • Buffers: shared hit=173
17. 9.800 19.352 ↑ 1.0 8,451 4

Hash Join (cost=138.38..393.26 rows=8,451 width=51) (actual time=1.306..4.838 rows=8,451 loops=4)

  • Output: pc.commodity_type_code, pc.physical_commodity_code, pc.iso_code, pc.lch_grouping_code, cn.contract_node_name, cn.iso_code, cn.node_type_code, cn.auction_schedule_type_code
  • Inner Unique: true
  • Hash Cond: (((pc.contract_node_name)::text = (cn.contract_node_name)::text) AND (pc.iso_code = cn.iso_code))
  • Buffers: shared hit=688
  • Worker 0: actual time=1.317..4.926 rows=8451 loops=1
  • Buffers: shared hit=172
  • Worker 1: actual time=1.299..4.761 rows=8451 loops=1
  • Buffers: shared hit=172
  • Worker 2: actual time=1.314..4.830 rows=8451 loops=1
  • Buffers: shared hit=172
18. 4.496 4.496 ↑ 1.0 8,451 4

Seq Scan on mos.physical_commodity pc (cost=0.00..210.51 rows=8,451 width=35) (actual time=0.012..1.124 rows=8,451 loops=4)

  • Output: pc.physical_commodity_code, pc.commodity_type_code, pc.contract_class_code, pc.contract_node_name, pc.iso_code, pc.lch_grouping_code, pc.expiry_count, pc.temp_contract_flag, pc.fee_per_lot_adjustment, pc.parent_physical_commodity_code, pc.real_time_price_additive, pc.jitters_parameter, pc.temp_deploy_date, pc.fee_group_id, pc.updated_timestamp
  • Buffers: shared hit=504
  • Worker 0: actual time=0.014..1.157 rows=8451 loops=1
  • Buffers: shared hit=126
  • Worker 1: actual time=0.016..1.100 rows=8451 loops=1
  • Buffers: shared hit=126
  • Worker 2: actual time=0.012..1.058 rows=8451 loops=1
  • Buffers: shared hit=126
19. 2.756 5.056 ↑ 1.0 3,695 4

Hash (cost=82.95..82.95 rows=3,695 width=31) (actual time=1.264..1.264 rows=3,695 loops=4)

  • Output: cn.contract_node_name, cn.iso_code, cn.node_type_code, cn.auction_schedule_type_code
  • Buckets: 4096 Batches: 1 Memory Usage: 272kB
  • Buffers: shared hit=184
  • Worker 0: actual time=1.274..1.274 rows=3695 loops=1
  • Buffers: shared hit=46
  • Worker 1: actual time=1.251..1.251 rows=3695 loops=1
  • Buffers: shared hit=46
  • Worker 2: actual time=1.277..1.277 rows=3695 loops=1
  • Buffers: shared hit=46
20. 2.300 2.300 ↑ 1.0 3,695 4

Seq Scan on mos.contract_node cn (cost=0.00..82.95 rows=3,695 width=31) (actual time=0.008..0.575 rows=3,695 loops=4)

  • Output: cn.contract_node_name, cn.iso_code, cn.node_type_code, cn.auction_schedule_type_code
  • Buffers: shared hit=184
  • Worker 0: actual time=0.008..0.590 rows=3695 loops=1
  • Buffers: shared hit=46
  • Worker 1: actual time=0.008..0.551 rows=3695 loops=1
  • Buffers: shared hit=46
  • Worker 2: actual time=0.009..0.581 rows=3695 loops=1
  • Buffers: shared hit=46
21. 0.020 0.064 ↑ 1.0 10 4

Hash (cost=1.10..1.10 rows=10 width=13) (actual time=0.016..0.016 rows=10 loops=4)

  • Output: i.iso_name, i.iso_code
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=4
  • Worker 0: actual time=0.016..0.016 rows=10 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.017..0.017 rows=10 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.021..0.021 rows=10 loops=1
  • Buffers: shared hit=1
22. 0.044 0.044 ↑ 1.0 10 4

Seq Scan on mos.iso i (cost=0.00..1.10 rows=10 width=13) (actual time=0.010..0.011 rows=10 loops=4)

  • Output: i.iso_name, i.iso_code
  • Buffers: shared hit=4
  • Worker 0: actual time=0.011..0.012 rows=10 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.012..0.013 rows=10 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.013..0.014 rows=10 loops=1
  • Buffers: shared hit=1
23. 0.024 0.056 ↑ 1.0 15 4

Hash (cost=1.15..1.15 rows=15 width=4) (actual time=0.014..0.014 rows=15 loops=4)

  • Output: nt.node_type_code
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=4
  • Worker 0: actual time=0.014..0.014 rows=15 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.014..0.014 rows=15 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.017..0.017 rows=15 loops=1
  • Buffers: shared hit=1
24. 0.032 0.032 ↑ 1.0 15 4

Seq Scan on mos.node_type nt (cost=0.00..1.15 rows=15 width=4) (actual time=0.007..0.008 rows=15 loops=4)

  • Output: nt.node_type_code
  • Buffers: shared hit=4
  • Worker 0: actual time=0.008..0.009 rows=15 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.008..0.009 rows=15 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.009..0.010 rows=15 loops=1
  • Buffers: shared hit=1
25. 0.024 0.060 ↑ 1.0 17 4

Hash (cost=1.17..1.17 rows=17 width=4) (actual time=0.015..0.015 rows=17 loops=4)

  • Output: pcg.lch_grouping_code
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=4
  • Worker 0: actual time=0.015..0.015 rows=17 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.017..0.017 rows=17 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.017..0.017 rows=17 loops=1
  • Buffers: shared hit=1
26. 0.036 0.036 ↑ 1.0 17 4

Seq Scan on mos.physical_commodity_group pcg (cost=0.00..1.17 rows=17 width=4) (actual time=0.007..0.009 rows=17 loops=4)

  • Output: pcg.lch_grouping_code
  • Buffers: shared hit=4
  • Worker 0: actual time=0.008..0.009 rows=17 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.009..0.010 rows=17 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.009..0.011 rows=17 loops=1
  • Buffers: shared hit=1
27. 0.020 0.072 ↑ 1.0 7 4

Hash (cost=1.07..1.07 rows=7 width=4) (actual time=0.018..0.018 rows=7 loops=4)

  • Output: ct.commodity_type_code
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=4
  • Worker 0: actual time=0.026..0.026 rows=7 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.017..0.017 rows=7 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.023..0.023 rows=7 loops=1
  • Buffers: shared hit=1
28. 0.052 0.052 ↑ 1.0 7 4

Seq Scan on mos.commodity_type ct (cost=0.00..1.07 rows=7 width=4) (actual time=0.012..0.013 rows=7 loops=4)

  • Output: ct.commodity_type_code
  • Buffers: shared hit=4
  • Worker 0: actual time=0.019..0.020 rows=7 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.009..0.010 rows=7 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.018..0.018 rows=7 loops=1
  • Buffers: shared hit=1
29. 0.012 0.056 ↑ 1.0 2 4

Hash (cost=1.02..1.02 rows=2 width=4) (actual time=0.014..0.014 rows=2 loops=4)

  • Output: st.schedule_type_code
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=4
  • Worker 0: actual time=0.016..0.016 rows=2 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.019..0.019 rows=2 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.015..0.015 rows=2 loops=1
  • Buffers: shared hit=1
30. 0.044 0.044 ↑ 1.0 2 4

Seq Scan on mos.auction_default_schedule_type st (cost=0.00..1.02 rows=2 width=4) (actual time=0.011..0.011 rows=2 loops=4)

  • Output: st.schedule_type_code
  • Buffers: shared hit=4
  • Worker 0: actual time=0.013..0.013 rows=2 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.015..0.015 rows=2 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.013..0.013 rows=2 loops=1
  • Buffers: shared hit=1
31. 0.016 0.064 ↑ 1.0 5 4

Hash (cost=1.05..1.05 rows=5 width=4) (actual time=0.016..0.016 rows=5 loops=4)

  • Output: cc.contract_class_code
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=4
  • Worker 0: actual time=0.017..0.017 rows=5 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.018..0.018 rows=5 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.019..0.019 rows=5 loops=1
  • Buffers: shared hit=1
32. 0.048 0.048 ↑ 1.0 5 4

Seq Scan on mos.contract_class cc (cost=0.00..1.05 rows=5 width=4) (actual time=0.012..0.012 rows=5 loops=4)

  • Output: cc.contract_class_code
  • Buffers: shared hit=4
  • Worker 0: actual time=0.013..0.014 rows=5 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.014..0.014 rows=5 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.015..0.015 rows=5 loops=1
  • Buffers: shared hit=1
33. 5.784 9.660 ↑ 1.0 7,305 4

Hash (cost=127.05..127.05 rows=7,305 width=22) (actual time=2.415..2.415 rows=7,305 loops=4)

  • Output: ed.lot_size, ed.expiration_date, ed.contract_term_code, ed.contract_class_code, ed.iso_code
  • Buckets: 8192 Batches: 1 Memory Usage: 521kB
  • Buffers: shared hit=216
  • Worker 0: actual time=2.402..2.402 rows=7305 loops=1
  • Buffers: shared hit=54
  • Worker 1: actual time=2.442..2.442 rows=7305 loops=1
  • Buffers: shared hit=54
  • Worker 2: actual time=2.400..2.400 rows=7305 loops=1
  • Buffers: shared hit=54
34. 3.876 3.876 ↑ 1.0 7,305 4

Seq Scan on mos.expiry_date ed (cost=0.00..127.05 rows=7,305 width=22) (actual time=0.022..0.969 rows=7,305 loops=4)

  • Output: ed.lot_size, ed.expiration_date, ed.contract_term_code, ed.contract_class_code, ed.iso_code
  • Buffers: shared hit=216
  • Worker 0: actual time=0.024..0.969 rows=7305 loops=1
  • Buffers: shared hit=54
  • Worker 1: actual time=0.024..0.939 rows=7305 loops=1
  • Buffers: shared hit=54
  • Worker 2: actual time=0.023..0.983 rows=7305 loops=1
  • Buffers: shared hit=54
35. 0.000 11.384 ↓ 0.0 0 4

Hash (cost=14,287.50..14,287.50 rows=147 width=154) (actual time=2.846..2.846 rows=0 loops=4)

  • Output: tg.trade_group_id, tg.trade_group_type_code, tg.created_timestamp, tg.trading_date, tg.nex_user_id, tg.auction_id, tg.trade_status_code, usr.last_name, usr.first_name, org.name, mt.matched_trade_id, mt.itm_account_code, mt.lots, mt.trade_price, mt.price_warning_flag, mt.skip_calculation_flag, mt.group_id, mt.lots_display_option, mt.expiry_id, mt.marking_price, mt.deal_id, esp.auction_price
  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=4138
  • Worker 0: actual time=3.205..3.205 rows=0 loops=1
  • Buffers: shared hit=1035
  • Worker 1: actual time=2.242..2.242 rows=0 loops=1
  • Buffers: shared hit=1035
  • Worker 2: actual time=3.203..3.203 rows=0 loops=1
  • Buffers: shared hit=1035
36. 0.004 11.384 ↓ 0.0 0 4

Merge Join (cost=1.65..14,287.50 rows=147 width=154) (actual time=2.846..2.846 rows=0 loops=4)

  • Output: tg.trade_group_id, tg.trade_group_type_code, tg.created_timestamp, tg.trading_date, tg.nex_user_id, tg.auction_id, tg.trade_status_code, usr.last_name, usr.first_name, org.name, mt.matched_trade_id, mt.itm_account_code, mt.lots, mt.trade_price, mt.price_warning_flag, mt.skip_calculation_flag, mt.group_id, mt.lots_display_option, mt.expiry_id, mt.marking_price, mt.deal_id, esp.auction_price
  • Inner Unique: true
  • Merge Cond: ((usr.organization_code)::text = (org.organization_code)::text)
  • Buffers: shared hit=4138
  • Worker 0: actual time=3.205..3.205 rows=0 loops=1
  • Buffers: shared hit=1035
  • Worker 1: actual time=2.242..2.242 rows=0 loops=1
  • Buffers: shared hit=1035
  • Worker 2: actual time=3.203..3.203 rows=0 loops=1
  • Buffers: shared hit=1035
37. 0.004 11.380 ↓ 0.0 0 4

Nested Loop Left Join (cost=1.43..56,728.45 rows=147 width=136) (actual time=2.845..2.845 rows=0 loops=4)

  • Output: tg.trade_group_id, tg.trade_group_type_code, tg.created_timestamp, tg.trading_date, tg.nex_user_id, tg.auction_id, tg.trade_status_code, usr.last_name, usr.first_name, usr.organization_code, mt.matched_trade_id, mt.itm_account_code, mt.lots, mt.trade_price, mt.price_warning_flag, mt.skip_calculation_flag, mt.group_id, mt.lots_display_option, mt.expiry_id, mt.marking_price, mt.deal_id, esp.auction_price
  • Buffers: shared hit=4138
  • Worker 0: actual time=3.204..3.204 rows=0 loops=1
  • Buffers: shared hit=1035
  • Worker 1: actual time=2.241..2.241 rows=0 loops=1
  • Buffers: shared hit=1035
  • Worker 2: actual time=3.202..3.202 rows=0 loops=1
  • Buffers: shared hit=1035
38. 0.004 11.376 ↓ 0.0 0 4

Nested Loop (cost=1.00..637.30 rows=147 width=129) (actual time=2.844..2.844 rows=0 loops=4)

  • Output: tg.trade_group_id, tg.trade_group_type_code, tg.created_timestamp, tg.trading_date, tg.nex_user_id, tg.auction_id, tg.trade_status_code, usr.last_name, usr.first_name, usr.organization_code, mt.matched_trade_id, mt.itm_account_code, mt.lots, mt.trade_price, mt.price_warning_flag, mt.skip_calculation_flag, mt.group_id, mt.lots_display_option, mt.expiry_id, mt.marking_price, mt.deal_id
  • Buffers: shared hit=4138
  • Worker 0: actual time=3.202..3.202 rows=0 loops=1
  • Buffers: shared hit=1035
  • Worker 1: actual time=2.240..2.240 rows=0 loops=1
  • Buffers: shared hit=1035
  • Worker 2: actual time=3.201..3.201 rows=0 loops=1
  • Buffers: shared hit=1035
39. 2.496 11.372 ↓ 0.0 0 4

Nested Loop (cost=0.57..619.97 rows=4 width=61) (actual time=2.843..2.843 rows=0 loops=4)

  • Output: tg.trade_group_id, tg.trade_group_type_code, tg.created_timestamp, tg.trading_date, tg.nex_user_id, tg.auction_id, tg.trade_status_code, usr.last_name, usr.first_name, usr.organization_code
  • Join Filter: (tg.nex_user_id = usr.nex_user_id)
  • Buffers: shared hit=4138
  • Worker 0: actual time=3.202..3.202 rows=0 loops=1
  • Buffers: shared hit=1035
  • Worker 1: actual time=2.240..2.240 rows=0 loops=1
  • Buffers: shared hit=1035
  • Worker 2: actual time=3.201..3.201 rows=0 loops=1
  • Buffers: shared hit=1035
40. 8.876 8.876 ↓ 1.0 5,568 4

Index Scan using organization_code_fki on mos.nex_user usr (cost=0.28..279.07 rows=5,567 width=25) (actual time=0.032..2.219 rows=5,568 loops=4)

  • Output: usr.nex_user_id, usr.username, usr.user_account_status_code, usr.itm_account_code, usr.ncp_account_code, usr.organization_code, usr.first_name, usr.last_name, usr.address, usr.country, usr.city, usr.state, usr.zip, usr.primary_phone, usr.secondary_phone, usr.fax, usr.primary_email, usr.secondary_email, usr.password_hash, usr.registration_date, usr.activation_date, usr.user_order_price_limit, usr.user_order_volume_limit, usr.user_trade_price_limit, usr.user_trade_volume_limit, usr.admin_order_price_limit, usr.admin_order_volume_limit, usr.admin_trade_price_limit, usr.admin_trade_volume_limit, usr.source_ip_address, usr.updated_timestamp, usr.updated_by_nex_user_id, usr.fix_name, usr.allow_fix_access_flag, usr.cc_email, usr.allow_sftp_access_flag, usr.trader_name_alias
  • Buffers: shared hit=4091
  • Worker 0: actual time=0.037..2.562 rows=5568 loops=1
  • Buffers: shared hit=1023
  • Worker 1: actual time=0.039..1.617 rows=5568 loops=1
  • Buffers: shared hit=1023
  • Worker 2: actual time=0.036..2.575 rows=5568 loops=1
  • Buffers: shared hit=1023
41. 0.000 0.000 ↓ 0.0 0 22,272

Materialize (cost=0.29..6.88 rows=4 width=44) (actual time=0.000..0.000 rows=0 loops=22,272)

  • Output: tg.trade_group_id, tg.trade_group_type_code, tg.created_timestamp, tg.trading_date, tg.nex_user_id, tg.auction_id, tg.trade_status_code
  • Buffers: shared hit=47
  • Worker 0: actual time=0.000..0.000 rows=0 loops=5568
  • Buffers: shared hit=12
  • Worker 1: actual time=0.000..0.000 rows=0 loops=5568
  • Buffers: shared hit=12
  • Worker 2: actual time=0.000..0.000 rows=0 loops=5568
  • Buffers: shared hit=12
42. 0.192 0.192 ↓ 0.0 0 4

Index Scan Backward using trade_group_pkey on mos.trade_group tg (cost=0.29..6.86 rows=4 width=44) (actual time=0.048..0.048 rows=0 loops=4)

  • Output: tg.trade_group_id, tg.trade_group_type_code, tg.created_timestamp, tg.trading_date, tg.nex_user_id, tg.auction_id, tg.trade_status_code
  • Index Cond: (tg.trade_group_id = ANY ('{1,2,3,4}'::bigint[]))
  • Buffers: shared hit=47
  • Worker 0: actual time=0.050..0.050 rows=0 loops=1
  • Buffers: shared hit=12
  • Worker 1: actual time=0.051..0.051 rows=0 loops=1
  • Buffers: shared hit=12
  • Worker 2: actual time=0.050..0.050 rows=0 loops=1
  • Buffers: shared hit=12
43. 0.000 0.000 ↓ 0.0 0

Index Scan using matched_trade_group_fki on mos.matched_trade mt (cost=0.43..3.82 rows=51 width=76) (never executed)

  • Output: mt.matched_trade_id, mt.itm_account_code, mt.trade_group_id, mt.expiry_id, mt.nex_user_id, mt.lots, mt.trade_price, mt.marking_price, mt.half_slip_number, mt.skip_calculation_flag, mt.send_to_lch_flag, mt.price_warning_flag, mt.group_id, mt.deal_id, mt.updated_timestamp, mt.broker_comments, mt.lots_display_option
  • Index Cond: (mt.trade_group_id = tg.trade_group_id)
44. 0.000 0.000 ↓ 0.0 0

Append (cost=0.43..380.11 rows=146 width=19) (never executed)

45. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2012_05_pkey on mos.expiry_settlement_price_2012_05 esp (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp.auction_price, esp.trading_date, esp.expiry_id
  • Index Cond: ((tg.trading_date = esp.trading_date) AND (mt.expiry_id = esp.expiry_id))
46. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2012_06_pkey on mos.expiry_settlement_price_2012_06 esp_1 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_1.auction_price, esp_1.trading_date, esp_1.expiry_id
  • Index Cond: ((tg.trading_date = esp_1.trading_date) AND (mt.expiry_id = esp_1.expiry_id))
47. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2012_07_pkey on mos.expiry_settlement_price_2012_07 esp_2 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_2.auction_price, esp_2.trading_date, esp_2.expiry_id
  • Index Cond: ((tg.trading_date = esp_2.trading_date) AND (mt.expiry_id = esp_2.expiry_id))
48. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2012_08_pkey on mos.expiry_settlement_price_2012_08 esp_3 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_3.auction_price, esp_3.trading_date, esp_3.expiry_id
  • Index Cond: ((tg.trading_date = esp_3.trading_date) AND (mt.expiry_id = esp_3.expiry_id))
49. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2012_09_pkey on mos.expiry_settlement_price_2012_09 esp_4 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_4.auction_price, esp_4.trading_date, esp_4.expiry_id
  • Index Cond: ((tg.trading_date = esp_4.trading_date) AND (mt.expiry_id = esp_4.expiry_id))
50. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2012_10_pkey on mos.expiry_settlement_price_2012_10 esp_5 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_5.auction_price, esp_5.trading_date, esp_5.expiry_id
  • Index Cond: ((tg.trading_date = esp_5.trading_date) AND (mt.expiry_id = esp_5.expiry_id))
51. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2012_11_pkey on mos.expiry_settlement_price_2012_11 esp_6 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_6.auction_price, esp_6.trading_date, esp_6.expiry_id
  • Index Cond: ((tg.trading_date = esp_6.trading_date) AND (mt.expiry_id = esp_6.expiry_id))
52. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2012_12_pkey on mos.expiry_settlement_price_2012_12 esp_7 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_7.auction_price, esp_7.trading_date, esp_7.expiry_id
  • Index Cond: ((tg.trading_date = esp_7.trading_date) AND (mt.expiry_id = esp_7.expiry_id))
53. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2013_01_pkey on mos.expiry_settlement_price_2013_01 esp_8 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_8.auction_price, esp_8.trading_date, esp_8.expiry_id
  • Index Cond: ((tg.trading_date = esp_8.trading_date) AND (mt.expiry_id = esp_8.expiry_id))
54. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2013_02_pkey on mos.expiry_settlement_price_2013_02 esp_9 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_9.auction_price, esp_9.trading_date, esp_9.expiry_id
  • Index Cond: ((tg.trading_date = esp_9.trading_date) AND (mt.expiry_id = esp_9.expiry_id))
55. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2013_03_pkey on mos.expiry_settlement_price_2013_03 esp_10 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_10.auction_price, esp_10.trading_date, esp_10.expiry_id
  • Index Cond: ((tg.trading_date = esp_10.trading_date) AND (mt.expiry_id = esp_10.expiry_id))
56. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2013_04_pkey on mos.expiry_settlement_price_2013_04 esp_11 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_11.auction_price, esp_11.trading_date, esp_11.expiry_id
  • Index Cond: ((tg.trading_date = esp_11.trading_date) AND (mt.expiry_id = esp_11.expiry_id))
57. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2013_05_pkey on mos.expiry_settlement_price_2013_05 esp_12 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_12.auction_price, esp_12.trading_date, esp_12.expiry_id
  • Index Cond: ((tg.trading_date = esp_12.trading_date) AND (mt.expiry_id = esp_12.expiry_id))
58. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2013_06_pkey on mos.expiry_settlement_price_2013_06 esp_13 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_13.auction_price, esp_13.trading_date, esp_13.expiry_id
  • Index Cond: ((tg.trading_date = esp_13.trading_date) AND (mt.expiry_id = esp_13.expiry_id))
59. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2013_07_pkey on mos.expiry_settlement_price_2013_07 esp_14 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_14.auction_price, esp_14.trading_date, esp_14.expiry_id
  • Index Cond: ((tg.trading_date = esp_14.trading_date) AND (mt.expiry_id = esp_14.expiry_id))
60. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2013_08_pkey on mos.expiry_settlement_price_2013_08 esp_15 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_15.auction_price, esp_15.trading_date, esp_15.expiry_id
  • Index Cond: ((tg.trading_date = esp_15.trading_date) AND (mt.expiry_id = esp_15.expiry_id))
61. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2013_09_pkey on mos.expiry_settlement_price_2013_09 esp_16 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_16.auction_price, esp_16.trading_date, esp_16.expiry_id
  • Index Cond: ((tg.trading_date = esp_16.trading_date) AND (mt.expiry_id = esp_16.expiry_id))
62. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2013_10_pkey on mos.expiry_settlement_price_2013_10 esp_17 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_17.auction_price, esp_17.trading_date, esp_17.expiry_id
  • Index Cond: ((tg.trading_date = esp_17.trading_date) AND (mt.expiry_id = esp_17.expiry_id))
63. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2013_11_pkey on mos.expiry_settlement_price_2013_11 esp_18 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_18.auction_price, esp_18.trading_date, esp_18.expiry_id
  • Index Cond: ((tg.trading_date = esp_18.trading_date) AND (mt.expiry_id = esp_18.expiry_id))
64. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2013_12_pkey on mos.expiry_settlement_price_2013_12 esp_19 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_19.auction_price, esp_19.trading_date, esp_19.expiry_id
  • Index Cond: ((tg.trading_date = esp_19.trading_date) AND (mt.expiry_id = esp_19.expiry_id))
65. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2014_01_pkey on mos.expiry_settlement_price_2014_01 esp_20 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_20.auction_price, esp_20.trading_date, esp_20.expiry_id
  • Index Cond: ((tg.trading_date = esp_20.trading_date) AND (mt.expiry_id = esp_20.expiry_id))
66. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2014_02_pkey on mos.expiry_settlement_price_2014_02 esp_21 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_21.auction_price, esp_21.trading_date, esp_21.expiry_id
  • Index Cond: ((tg.trading_date = esp_21.trading_date) AND (mt.expiry_id = esp_21.expiry_id))
67. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2014_03_pkey on mos.expiry_settlement_price_2014_03 esp_22 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_22.auction_price, esp_22.trading_date, esp_22.expiry_id
  • Index Cond: ((tg.trading_date = esp_22.trading_date) AND (mt.expiry_id = esp_22.expiry_id))
68. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2014_04_pkey on mos.expiry_settlement_price_2014_04 esp_23 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_23.auction_price, esp_23.trading_date, esp_23.expiry_id
  • Index Cond: ((tg.trading_date = esp_23.trading_date) AND (mt.expiry_id = esp_23.expiry_id))
69. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2014_05_pkey on mos.expiry_settlement_price_2014_05 esp_24 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_24.auction_price, esp_24.trading_date, esp_24.expiry_id
  • Index Cond: ((tg.trading_date = esp_24.trading_date) AND (mt.expiry_id = esp_24.expiry_id))
70. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2014_06_pkey on mos.expiry_settlement_price_2014_06 esp_25 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_25.auction_price, esp_25.trading_date, esp_25.expiry_id
  • Index Cond: ((tg.trading_date = esp_25.trading_date) AND (mt.expiry_id = esp_25.expiry_id))
71. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2014_07_pkey on mos.expiry_settlement_price_2014_07 esp_26 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_26.auction_price, esp_26.trading_date, esp_26.expiry_id
  • Index Cond: ((tg.trading_date = esp_26.trading_date) AND (mt.expiry_id = esp_26.expiry_id))
72. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2014_08_pkey on mos.expiry_settlement_price_2014_08 esp_27 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_27.auction_price, esp_27.trading_date, esp_27.expiry_id
  • Index Cond: ((tg.trading_date = esp_27.trading_date) AND (mt.expiry_id = esp_27.expiry_id))
73. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2014_09_pkey on mos.expiry_settlement_price_2014_09 esp_28 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_28.auction_price, esp_28.trading_date, esp_28.expiry_id
  • Index Cond: ((tg.trading_date = esp_28.trading_date) AND (mt.expiry_id = esp_28.expiry_id))
74. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2014_10_pkey on mos.expiry_settlement_price_2014_10 esp_29 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_29.auction_price, esp_29.trading_date, esp_29.expiry_id
  • Index Cond: ((tg.trading_date = esp_29.trading_date) AND (mt.expiry_id = esp_29.expiry_id))
75. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2014_11_pkey on mos.expiry_settlement_price_2014_11 esp_30 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_30.auction_price, esp_30.trading_date, esp_30.expiry_id
  • Index Cond: ((tg.trading_date = esp_30.trading_date) AND (mt.expiry_id = esp_30.expiry_id))
76. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2014_12_pkey on mos.expiry_settlement_price_2014_12 esp_31 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_31.auction_price, esp_31.trading_date, esp_31.expiry_id
  • Index Cond: ((tg.trading_date = esp_31.trading_date) AND (mt.expiry_id = esp_31.expiry_id))
77. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2015_01_pkey on mos.expiry_settlement_price_2015_01 esp_32 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_32.auction_price, esp_32.trading_date, esp_32.expiry_id
  • Index Cond: ((tg.trading_date = esp_32.trading_date) AND (mt.expiry_id = esp_32.expiry_id))
78. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2015_02_pkey on mos.expiry_settlement_price_2015_02 esp_33 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_33.auction_price, esp_33.trading_date, esp_33.expiry_id
  • Index Cond: ((tg.trading_date = esp_33.trading_date) AND (mt.expiry_id = esp_33.expiry_id))
79. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2015_03_pkey on mos.expiry_settlement_price_2015_03 esp_34 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_34.auction_price, esp_34.trading_date, esp_34.expiry_id
  • Index Cond: ((tg.trading_date = esp_34.trading_date) AND (mt.expiry_id = esp_34.expiry_id))
80. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2015_04_pkey on mos.expiry_settlement_price_2015_04 esp_35 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_35.auction_price, esp_35.trading_date, esp_35.expiry_id
  • Index Cond: ((tg.trading_date = esp_35.trading_date) AND (mt.expiry_id = esp_35.expiry_id))
81. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2015_05_pkey on mos.expiry_settlement_price_2015_05 esp_36 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_36.auction_price, esp_36.trading_date, esp_36.expiry_id
  • Index Cond: ((tg.trading_date = esp_36.trading_date) AND (mt.expiry_id = esp_36.expiry_id))
82. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2015_06_pkey on mos.expiry_settlement_price_2015_06 esp_37 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_37.auction_price, esp_37.trading_date, esp_37.expiry_id
  • Index Cond: ((tg.trading_date = esp_37.trading_date) AND (mt.expiry_id = esp_37.expiry_id))
83. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2015_07_pkey on mos.expiry_settlement_price_2015_07 esp_38 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_38.auction_price, esp_38.trading_date, esp_38.expiry_id
  • Index Cond: ((tg.trading_date = esp_38.trading_date) AND (mt.expiry_id = esp_38.expiry_id))
84. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2015_08_pkey on mos.expiry_settlement_price_2015_08 esp_39 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_39.auction_price, esp_39.trading_date, esp_39.expiry_id
  • Index Cond: ((tg.trading_date = esp_39.trading_date) AND (mt.expiry_id = esp_39.expiry_id))
85. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2015_09_pkey on mos.expiry_settlement_price_2015_09 esp_40 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_40.auction_price, esp_40.trading_date, esp_40.expiry_id
  • Index Cond: ((tg.trading_date = esp_40.trading_date) AND (mt.expiry_id = esp_40.expiry_id))
86. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2015_10_pkey on mos.expiry_settlement_price_2015_10 esp_41 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_41.auction_price, esp_41.trading_date, esp_41.expiry_id
  • Index Cond: ((tg.trading_date = esp_41.trading_date) AND (mt.expiry_id = esp_41.expiry_id))
87. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2015_11_pkey on mos.expiry_settlement_price_2015_11 esp_42 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_42.auction_price, esp_42.trading_date, esp_42.expiry_id
  • Index Cond: ((tg.trading_date = esp_42.trading_date) AND (mt.expiry_id = esp_42.expiry_id))
88. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2015_12_pkey on mos.expiry_settlement_price_2015_12 esp_43 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_43.auction_price, esp_43.trading_date, esp_43.expiry_id
  • Index Cond: ((tg.trading_date = esp_43.trading_date) AND (mt.expiry_id = esp_43.expiry_id))
89. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2016_01_pkey on mos.expiry_settlement_price_2016_01 esp_44 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_44.auction_price, esp_44.trading_date, esp_44.expiry_id
  • Index Cond: ((tg.trading_date = esp_44.trading_date) AND (mt.expiry_id = esp_44.expiry_id))
90. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2016_02_pkey on mos.expiry_settlement_price_2016_02 esp_45 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_45.auction_price, esp_45.trading_date, esp_45.expiry_id
  • Index Cond: ((tg.trading_date = esp_45.trading_date) AND (mt.expiry_id = esp_45.expiry_id))
91. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2016_03_pkey on mos.expiry_settlement_price_2016_03 esp_46 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_46.auction_price, esp_46.trading_date, esp_46.expiry_id
  • Index Cond: ((tg.trading_date = esp_46.trading_date) AND (mt.expiry_id = esp_46.expiry_id))
92. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2016_04_pkey on mos.expiry_settlement_price_2016_04 esp_47 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_47.auction_price, esp_47.trading_date, esp_47.expiry_id
  • Index Cond: ((tg.trading_date = esp_47.trading_date) AND (mt.expiry_id = esp_47.expiry_id))
93. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2016_05_pkey on mos.expiry_settlement_price_2016_05 esp_48 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_48.auction_price, esp_48.trading_date, esp_48.expiry_id
  • Index Cond: ((tg.trading_date = esp_48.trading_date) AND (mt.expiry_id = esp_48.expiry_id))
94. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2016_06_pkey on mos.expiry_settlement_price_2016_06 esp_49 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_49.auction_price, esp_49.trading_date, esp_49.expiry_id
  • Index Cond: ((tg.trading_date = esp_49.trading_date) AND (mt.expiry_id = esp_49.expiry_id))
95. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2016_07_pkey on mos.expiry_settlement_price_2016_07 esp_50 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_50.auction_price, esp_50.trading_date, esp_50.expiry_id
  • Index Cond: ((tg.trading_date = esp_50.trading_date) AND (mt.expiry_id = esp_50.expiry_id))
96. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2016_08_pkey on mos.expiry_settlement_price_2016_08 esp_51 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_51.auction_price, esp_51.trading_date, esp_51.expiry_id
  • Index Cond: ((tg.trading_date = esp_51.trading_date) AND (mt.expiry_id = esp_51.expiry_id))
97. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2016_09_pkey on mos.expiry_settlement_price_2016_09 esp_52 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_52.auction_price, esp_52.trading_date, esp_52.expiry_id
  • Index Cond: ((tg.trading_date = esp_52.trading_date) AND (mt.expiry_id = esp_52.expiry_id))
98. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2016_10_pkey on mos.expiry_settlement_price_2016_10 esp_53 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_53.auction_price, esp_53.trading_date, esp_53.expiry_id
  • Index Cond: ((tg.trading_date = esp_53.trading_date) AND (mt.expiry_id = esp_53.expiry_id))
99. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2016_11_pkey on mos.expiry_settlement_price_2016_11 esp_54 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_54.auction_price, esp_54.trading_date, esp_54.expiry_id
  • Index Cond: ((tg.trading_date = esp_54.trading_date) AND (mt.expiry_id = esp_54.expiry_id))
100. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2016_12_pkey on mos.expiry_settlement_price_2016_12 esp_55 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_55.auction_price, esp_55.trading_date, esp_55.expiry_id
  • Index Cond: ((tg.trading_date = esp_55.trading_date) AND (mt.expiry_id = esp_55.expiry_id))
101. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2017_01_pkey on mos.expiry_settlement_price_2017_01 esp_56 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_56.auction_price, esp_56.trading_date, esp_56.expiry_id
  • Index Cond: ((tg.trading_date = esp_56.trading_date) AND (mt.expiry_id = esp_56.expiry_id))
102. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2017_02_pkey on mos.expiry_settlement_price_2017_02 esp_57 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_57.auction_price, esp_57.trading_date, esp_57.expiry_id
  • Index Cond: ((tg.trading_date = esp_57.trading_date) AND (mt.expiry_id = esp_57.expiry_id))
103. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2017_03_pkey on mos.expiry_settlement_price_2017_03 esp_58 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_58.auction_price, esp_58.trading_date, esp_58.expiry_id
  • Index Cond: ((tg.trading_date = esp_58.trading_date) AND (mt.expiry_id = esp_58.expiry_id))
104. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2017_04_pkey on mos.expiry_settlement_price_2017_04 esp_59 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_59.auction_price, esp_59.trading_date, esp_59.expiry_id
  • Index Cond: ((tg.trading_date = esp_59.trading_date) AND (mt.expiry_id = esp_59.expiry_id))
105. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2017_05_pkey on mos.expiry_settlement_price_2017_05 esp_60 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_60.auction_price, esp_60.trading_date, esp_60.expiry_id
  • Index Cond: ((tg.trading_date = esp_60.trading_date) AND (mt.expiry_id = esp_60.expiry_id))
106. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2017_06_pkey on mos.expiry_settlement_price_2017_06 esp_61 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_61.auction_price, esp_61.trading_date, esp_61.expiry_id
  • Index Cond: ((tg.trading_date = esp_61.trading_date) AND (mt.expiry_id = esp_61.expiry_id))
107. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2017_07_pkey on mos.expiry_settlement_price_2017_07 esp_62 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_62.auction_price, esp_62.trading_date, esp_62.expiry_id
  • Index Cond: ((tg.trading_date = esp_62.trading_date) AND (mt.expiry_id = esp_62.expiry_id))
108. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2017_08_pkey on mos.expiry_settlement_price_2017_08 esp_63 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_63.auction_price, esp_63.trading_date, esp_63.expiry_id
  • Index Cond: ((tg.trading_date = esp_63.trading_date) AND (mt.expiry_id = esp_63.expiry_id))
109. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2017_09_pkey on mos.expiry_settlement_price_2017_09 esp_64 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_64.auction_price, esp_64.trading_date, esp_64.expiry_id
  • Index Cond: ((tg.trading_date = esp_64.trading_date) AND (mt.expiry_id = esp_64.expiry_id))
110. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2017_10_pkey on mos.expiry_settlement_price_2017_10 esp_65 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_65.auction_price, esp_65.trading_date, esp_65.expiry_id
  • Index Cond: ((tg.trading_date = esp_65.trading_date) AND (mt.expiry_id = esp_65.expiry_id))
111. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2017_11_pkey on mos.expiry_settlement_price_2017_11 esp_66 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_66.auction_price, esp_66.trading_date, esp_66.expiry_id
  • Index Cond: ((tg.trading_date = esp_66.trading_date) AND (mt.expiry_id = esp_66.expiry_id))
112. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2017_12_pkey on mos.expiry_settlement_price_2017_12 esp_67 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_67.auction_price, esp_67.trading_date, esp_67.expiry_id
  • Index Cond: ((tg.trading_date = esp_67.trading_date) AND (mt.expiry_id = esp_67.expiry_id))
113. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2018_01_pkey on mos.expiry_settlement_price_2018_01 esp_68 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_68.auction_price, esp_68.trading_date, esp_68.expiry_id
  • Index Cond: ((tg.trading_date = esp_68.trading_date) AND (mt.expiry_id = esp_68.expiry_id))
114. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2018_02_pkey on mos.expiry_settlement_price_2018_02 esp_69 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_69.auction_price, esp_69.trading_date, esp_69.expiry_id
  • Index Cond: ((tg.trading_date = esp_69.trading_date) AND (mt.expiry_id = esp_69.expiry_id))
115. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2018_03_pkey on mos.expiry_settlement_price_2018_03 esp_70 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_70.auction_price, esp_70.trading_date, esp_70.expiry_id
  • Index Cond: ((tg.trading_date = esp_70.trading_date) AND (mt.expiry_id = esp_70.expiry_id))
116. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2018_04_pkey on mos.expiry_settlement_price_2018_04 esp_71 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_71.auction_price, esp_71.trading_date, esp_71.expiry_id
  • Index Cond: ((tg.trading_date = esp_71.trading_date) AND (mt.expiry_id = esp_71.expiry_id))
117. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2018_05_pkey on mos.expiry_settlement_price_2018_05 esp_72 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_72.auction_price, esp_72.trading_date, esp_72.expiry_id
  • Index Cond: ((tg.trading_date = esp_72.trading_date) AND (mt.expiry_id = esp_72.expiry_id))
118. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2018_06_pkey on mos.expiry_settlement_price_2018_06 esp_73 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_73.auction_price, esp_73.trading_date, esp_73.expiry_id
  • Index Cond: ((tg.trading_date = esp_73.trading_date) AND (mt.expiry_id = esp_73.expiry_id))
119. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2018_07_pkey on mos.expiry_settlement_price_2018_07 esp_74 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_74.auction_price, esp_74.trading_date, esp_74.expiry_id
  • Index Cond: ((tg.trading_date = esp_74.trading_date) AND (mt.expiry_id = esp_74.expiry_id))
120. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2018_08_pkey on mos.expiry_settlement_price_2018_08 esp_75 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_75.auction_price, esp_75.trading_date, esp_75.expiry_id
  • Index Cond: ((tg.trading_date = esp_75.trading_date) AND (mt.expiry_id = esp_75.expiry_id))
121. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2018_09_pkey on mos.expiry_settlement_price_2018_09 esp_76 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_76.auction_price, esp_76.trading_date, esp_76.expiry_id
  • Index Cond: ((tg.trading_date = esp_76.trading_date) AND (mt.expiry_id = esp_76.expiry_id))
122. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2018_10_pkey on mos.expiry_settlement_price_2018_10 esp_77 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_77.auction_price, esp_77.trading_date, esp_77.expiry_id
  • Index Cond: ((tg.trading_date = esp_77.trading_date) AND (mt.expiry_id = esp_77.expiry_id))
123. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2018_11_pkey on mos.expiry_settlement_price_2018_11 esp_78 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_78.auction_price, esp_78.trading_date, esp_78.expiry_id
  • Index Cond: ((tg.trading_date = esp_78.trading_date) AND (mt.expiry_id = esp_78.expiry_id))
124. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2018_12_pkey on mos.expiry_settlement_price_2018_12 esp_79 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_79.auction_price, esp_79.trading_date, esp_79.expiry_id
  • Index Cond: ((tg.trading_date = esp_79.trading_date) AND (mt.expiry_id = esp_79.expiry_id))
125. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2019_01_pkey on mos.expiry_settlement_price_2019_01 esp_80 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_80.auction_price, esp_80.trading_date, esp_80.expiry_id
  • Index Cond: ((tg.trading_date = esp_80.trading_date) AND (mt.expiry_id = esp_80.expiry_id))
126. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2019_02_pkey on mos.expiry_settlement_price_2019_02 esp_81 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_81.auction_price, esp_81.trading_date, esp_81.expiry_id
  • Index Cond: ((tg.trading_date = esp_81.trading_date) AND (mt.expiry_id = esp_81.expiry_id))
127. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2019_03_pkey on mos.expiry_settlement_price_2019_03 esp_82 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_82.auction_price, esp_82.trading_date, esp_82.expiry_id
  • Index Cond: ((tg.trading_date = esp_82.trading_date) AND (mt.expiry_id = esp_82.expiry_id))
128. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2019_04_pkey on mos.expiry_settlement_price_2019_04 esp_83 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_83.auction_price, esp_83.trading_date, esp_83.expiry_id
  • Index Cond: ((tg.trading_date = esp_83.trading_date) AND (mt.expiry_id = esp_83.expiry_id))
129. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2019_05_pkey on mos.expiry_settlement_price_2019_05 esp_84 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_84.auction_price, esp_84.trading_date, esp_84.expiry_id
  • Index Cond: ((tg.trading_date = esp_84.trading_date) AND (mt.expiry_id = esp_84.expiry_id))
130. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2019_06_pkey on mos.expiry_settlement_price_2019_06 esp_85 (cost=0.42..5.97 rows=4 width=32) (never executed)

  • Output: esp_85.auction_price, esp_85.trading_date, esp_85.expiry_id
  • Index Cond: ((tg.trading_date = esp_85.trading_date) AND (mt.expiry_id = esp_85.expiry_id))
131. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2019_07_expiry_id_idx on mos.expiry_settlement_price_2019_07 esp_86 (cost=0.14..2.37 rows=1 width=32) (never executed)

  • Output: esp_86.auction_price, esp_86.trading_date, esp_86.expiry_id
  • Index Cond: (mt.expiry_id = esp_86.expiry_id)
  • Filter: (tg.trading_date = esp_86.trading_date)
132. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2019_08_expiry_id_idx on mos.expiry_settlement_price_2019_08 esp_87 (cost=0.14..2.37 rows=1 width=32) (never executed)

  • Output: esp_87.auction_price, esp_87.trading_date, esp_87.expiry_id
  • Index Cond: (mt.expiry_id = esp_87.expiry_id)
  • Filter: (tg.trading_date = esp_87.trading_date)
133. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2019_09_expiry_id_idx on mos.expiry_settlement_price_2019_09 esp_88 (cost=0.14..2.37 rows=1 width=32) (never executed)

  • Output: esp_88.auction_price, esp_88.trading_date, esp_88.expiry_id
  • Index Cond: (mt.expiry_id = esp_88.expiry_id)
  • Filter: (tg.trading_date = esp_88.trading_date)
134. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2019_10_expiry_id_idx on mos.expiry_settlement_price_2019_10 esp_89 (cost=0.14..2.37 rows=1 width=32) (never executed)

  • Output: esp_89.auction_price, esp_89.trading_date, esp_89.expiry_id
  • Index Cond: (mt.expiry_id = esp_89.expiry_id)
  • Filter: (tg.trading_date = esp_89.trading_date)
135. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2019_11_expiry_id_idx on mos.expiry_settlement_price_2019_11 esp_90 (cost=0.14..2.37 rows=1 width=32) (never executed)

  • Output: esp_90.auction_price, esp_90.trading_date, esp_90.expiry_id
  • Index Cond: (mt.expiry_id = esp_90.expiry_id)
  • Filter: (tg.trading_date = esp_90.trading_date)
136. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2019_12_expiry_id_idx on mos.expiry_settlement_price_2019_12 esp_91 (cost=0.14..2.37 rows=1 width=32) (never executed)

  • Output: esp_91.auction_price, esp_91.trading_date, esp_91.expiry_id
  • Index Cond: (mt.expiry_id = esp_91.expiry_id)
  • Filter: (tg.trading_date = esp_91.trading_date)
137. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2020_expiry_id_idx on mos.expiry_settlement_price_2020 esp_92 (cost=0.14..2.37 rows=1 width=32) (never executed)

  • Output: esp_92.auction_price, esp_92.trading_date, esp_92.expiry_id
  • Index Cond: (mt.expiry_id = esp_92.expiry_id)
  • Filter: (tg.trading_date = esp_92.trading_date)
138. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2008_03_pkey on mos.expiry_settlement_price_2008_03 esp_93 (cost=0.42..2.64 rows=1 width=32) (never executed)

  • Output: esp_93.auction_price, esp_93.trading_date, esp_93.expiry_id
  • Index Cond: ((tg.trading_date = esp_93.trading_date) AND (mt.expiry_id = esp_93.expiry_id))
139. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2008_04_pkey on mos.expiry_settlement_price_2008_04 esp_94 (cost=0.43..2.65 rows=1 width=32) (never executed)

  • Output: esp_94.auction_price, esp_94.trading_date, esp_94.expiry_id
  • Index Cond: ((tg.trading_date = esp_94.trading_date) AND (mt.expiry_id = esp_94.expiry_id))
140. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2008_05_pkey on mos.expiry_settlement_price_2008_05 esp_95 (cost=0.43..2.65 rows=1 width=32) (never executed)

  • Output: esp_95.auction_price, esp_95.trading_date, esp_95.expiry_id
  • Index Cond: ((tg.trading_date = esp_95.trading_date) AND (mt.expiry_id = esp_95.expiry_id))
141. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2008_06_pkey on mos.expiry_settlement_price_2008_06 esp_96 (cost=0.43..2.65 rows=1 width=32) (never executed)

  • Output: esp_96.auction_price, esp_96.trading_date, esp_96.expiry_id
  • Index Cond: ((tg.trading_date = esp_96.trading_date) AND (mt.expiry_id = esp_96.expiry_id))
142. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2008_07_pkey on mos.expiry_settlement_price_2008_07 esp_97 (cost=0.43..2.65 rows=1 width=32) (never executed)

  • Output: esp_97.auction_price, esp_97.trading_date, esp_97.expiry_id
  • Index Cond: ((tg.trading_date = esp_97.trading_date) AND (mt.expiry_id = esp_97.expiry_id))
143. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2008_08_pkey on mos.expiry_settlement_price_2008_08 esp_98 (cost=0.43..2.65 rows=1 width=32) (never executed)

  • Output: esp_98.auction_price, esp_98.trading_date, esp_98.expiry_id
  • Index Cond: ((tg.trading_date = esp_98.trading_date) AND (mt.expiry_id = esp_98.expiry_id))
144. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2008_09_pkey on mos.expiry_settlement_price_2008_09 esp_99 (cost=0.43..2.65 rows=1 width=32) (never executed)

  • Output: esp_99.auction_price, esp_99.trading_date, esp_99.expiry_id
  • Index Cond: ((tg.trading_date = esp_99.trading_date) AND (mt.expiry_id = esp_99.expiry_id))
145. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2008_10_pkey on mos.expiry_settlement_price_2008_10 esp_100 (cost=0.43..2.65 rows=1 width=32) (never executed)

  • Output: esp_100.auction_price, esp_100.trading_date, esp_100.expiry_id
  • Index Cond: ((tg.trading_date = esp_100.trading_date) AND (mt.expiry_id = esp_100.expiry_id))
146. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2008_11_pkey on mos.expiry_settlement_price_2008_11 esp_101 (cost=0.43..2.65 rows=1 width=32) (never executed)

  • Output: esp_101.auction_price, esp_101.trading_date, esp_101.expiry_id
  • Index Cond: ((tg.trading_date = esp_101.trading_date) AND (mt.expiry_id = esp_101.expiry_id))
147. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2008_12_pkey on mos.expiry_settlement_price_2008_12 esp_102 (cost=0.43..2.65 rows=1 width=32) (never executed)

  • Output: esp_102.auction_price, esp_102.trading_date, esp_102.expiry_id
  • Index Cond: ((tg.trading_date = esp_102.trading_date) AND (mt.expiry_id = esp_102.expiry_id))
148. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2009_01_pkey on mos.expiry_settlement_price_2009_01 esp_103 (cost=0.43..2.65 rows=1 width=32) (never executed)

  • Output: esp_103.auction_price, esp_103.trading_date, esp_103.expiry_id
  • Index Cond: ((tg.trading_date = esp_103.trading_date) AND (mt.expiry_id = esp_103.expiry_id))
149. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2009_02_pkey on mos.expiry_settlement_price_2009_02 esp_104 (cost=0.43..2.65 rows=1 width=32) (never executed)

  • Output: esp_104.auction_price, esp_104.trading_date, esp_104.expiry_id
  • Index Cond: ((tg.trading_date = esp_104.trading_date) AND (mt.expiry_id = esp_104.expiry_id))
150. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2009_03_pkey on mos.expiry_settlement_price_2009_03 esp_105 (cost=0.43..2.65 rows=1 width=32) (never executed)

  • Output: esp_105.auction_price, esp_105.trading_date, esp_105.expiry_id
  • Index Cond: ((tg.trading_date = esp_105.trading_date) AND (mt.expiry_id = esp_105.expiry_id))
151. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2009_04_pkey on mos.expiry_settlement_price_2009_04 esp_106 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_106.auction_price, esp_106.trading_date, esp_106.expiry_id
  • Index Cond: ((tg.trading_date = esp_106.trading_date) AND (mt.expiry_id = esp_106.expiry_id))
152. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2009_05_pkey on mos.expiry_settlement_price_2009_05 esp_107 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_107.auction_price, esp_107.trading_date, esp_107.expiry_id
  • Index Cond: ((tg.trading_date = esp_107.trading_date) AND (mt.expiry_id = esp_107.expiry_id))
153. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2009_06_pkey on mos.expiry_settlement_price_2009_06 esp_108 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_108.auction_price, esp_108.trading_date, esp_108.expiry_id
  • Index Cond: ((tg.trading_date = esp_108.trading_date) AND (mt.expiry_id = esp_108.expiry_id))
154. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2009_07_pkey on mos.expiry_settlement_price_2009_07 esp_109 (cost=0.43..2.65 rows=1 width=19) (never executed)

  • Output: esp_109.auction_price, esp_109.trading_date, esp_109.expiry_id
  • Index Cond: ((tg.trading_date = esp_109.trading_date) AND (mt.expiry_id = esp_109.expiry_id))
155. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2009_08_pkey on mos.expiry_settlement_price_2009_08 esp_110 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_110.auction_price, esp_110.trading_date, esp_110.expiry_id
  • Index Cond: ((tg.trading_date = esp_110.trading_date) AND (mt.expiry_id = esp_110.expiry_id))
156. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2009_09_pkey on mos.expiry_settlement_price_2009_09 esp_111 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_111.auction_price, esp_111.trading_date, esp_111.expiry_id
  • Index Cond: ((tg.trading_date = esp_111.trading_date) AND (mt.expiry_id = esp_111.expiry_id))
157. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2009_10_pkey on mos.expiry_settlement_price_2009_10 esp_112 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_112.auction_price, esp_112.trading_date, esp_112.expiry_id
  • Index Cond: ((tg.trading_date = esp_112.trading_date) AND (mt.expiry_id = esp_112.expiry_id))
158. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2009_11_pkey on mos.expiry_settlement_price_2009_11 esp_113 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_113.auction_price, esp_113.trading_date, esp_113.expiry_id
  • Index Cond: ((tg.trading_date = esp_113.trading_date) AND (mt.expiry_id = esp_113.expiry_id))
159. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2009_12_pkey on mos.expiry_settlement_price_2009_12 esp_114 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_114.auction_price, esp_114.trading_date, esp_114.expiry_id
  • Index Cond: ((tg.trading_date = esp_114.trading_date) AND (mt.expiry_id = esp_114.expiry_id))
160. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2010_01_pkey on mos.expiry_settlement_price_2010_01 esp_115 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_115.auction_price, esp_115.trading_date, esp_115.expiry_id
  • Index Cond: ((tg.trading_date = esp_115.trading_date) AND (mt.expiry_id = esp_115.expiry_id))
161. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2010_02_pkey on mos.expiry_settlement_price_2010_02 esp_116 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_116.auction_price, esp_116.trading_date, esp_116.expiry_id
  • Index Cond: ((tg.trading_date = esp_116.trading_date) AND (mt.expiry_id = esp_116.expiry_id))
162. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2010_03_pkey on mos.expiry_settlement_price_2010_03 esp_117 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_117.auction_price, esp_117.trading_date, esp_117.expiry_id
  • Index Cond: ((tg.trading_date = esp_117.trading_date) AND (mt.expiry_id = esp_117.expiry_id))
163. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2010_04_pkey on mos.expiry_settlement_price_2010_04 esp_118 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_118.auction_price, esp_118.trading_date, esp_118.expiry_id
  • Index Cond: ((tg.trading_date = esp_118.trading_date) AND (mt.expiry_id = esp_118.expiry_id))
164. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2010_05_pkey on mos.expiry_settlement_price_2010_05 esp_119 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_119.auction_price, esp_119.trading_date, esp_119.expiry_id
  • Index Cond: ((tg.trading_date = esp_119.trading_date) AND (mt.expiry_id = esp_119.expiry_id))
165. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2010_06_pkey on mos.expiry_settlement_price_2010_06 esp_120 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_120.auction_price, esp_120.trading_date, esp_120.expiry_id
  • Index Cond: ((tg.trading_date = esp_120.trading_date) AND (mt.expiry_id = esp_120.expiry_id))
166. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2010_07_pkey on mos.expiry_settlement_price_2010_07 esp_121 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_121.auction_price, esp_121.trading_date, esp_121.expiry_id
  • Index Cond: ((tg.trading_date = esp_121.trading_date) AND (mt.expiry_id = esp_121.expiry_id))
167. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2010_08_pkey on mos.expiry_settlement_price_2010_08 esp_122 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_122.auction_price, esp_122.trading_date, esp_122.expiry_id
  • Index Cond: ((tg.trading_date = esp_122.trading_date) AND (mt.expiry_id = esp_122.expiry_id))
168. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2010_09_pkey on mos.expiry_settlement_price_2010_09 esp_123 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_123.auction_price, esp_123.trading_date, esp_123.expiry_id
  • Index Cond: ((tg.trading_date = esp_123.trading_date) AND (mt.expiry_id = esp_123.expiry_id))
169. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2010_10_pkey on mos.expiry_settlement_price_2010_10 esp_124 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_124.auction_price, esp_124.trading_date, esp_124.expiry_id
  • Index Cond: ((tg.trading_date = esp_124.trading_date) AND (mt.expiry_id = esp_124.expiry_id))
170. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2010_11_pkey on mos.expiry_settlement_price_2010_11 esp_125 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_125.auction_price, esp_125.trading_date, esp_125.expiry_id
  • Index Cond: ((tg.trading_date = esp_125.trading_date) AND (mt.expiry_id = esp_125.expiry_id))
171. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2010_12_pkey on mos.expiry_settlement_price_2010_12 esp_126 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_126.auction_price, esp_126.trading_date, esp_126.expiry_id
  • Index Cond: ((tg.trading_date = esp_126.trading_date) AND (mt.expiry_id = esp_126.expiry_id))
172. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2011_01_pkey on mos.expiry_settlement_price_2011_01 esp_127 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_127.auction_price, esp_127.trading_date, esp_127.expiry_id
  • Index Cond: ((tg.trading_date = esp_127.trading_date) AND (mt.expiry_id = esp_127.expiry_id))
173. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2011_02_pkey on mos.expiry_settlement_price_2011_02 esp_128 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_128.auction_price, esp_128.trading_date, esp_128.expiry_id
  • Index Cond: ((tg.trading_date = esp_128.trading_date) AND (mt.expiry_id = esp_128.expiry_id))
174. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2011_03_pkey on mos.expiry_settlement_price_2011_03 esp_129 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_129.auction_price, esp_129.trading_date, esp_129.expiry_id
  • Index Cond: ((tg.trading_date = esp_129.trading_date) AND (mt.expiry_id = esp_129.expiry_id))
175. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2011_04_pkey on mos.expiry_settlement_price_2011_04 esp_130 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_130.auction_price, esp_130.trading_date, esp_130.expiry_id
  • Index Cond: ((tg.trading_date = esp_130.trading_date) AND (mt.expiry_id = esp_130.expiry_id))
176. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2011_05_pkey on mos.expiry_settlement_price_2011_05 esp_131 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_131.auction_price, esp_131.trading_date, esp_131.expiry_id
  • Index Cond: ((tg.trading_date = esp_131.trading_date) AND (mt.expiry_id = esp_131.expiry_id))
177. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2011_06_pkey on mos.expiry_settlement_price_2011_06 esp_132 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_132.auction_price, esp_132.trading_date, esp_132.expiry_id
  • Index Cond: ((tg.trading_date = esp_132.trading_date) AND (mt.expiry_id = esp_132.expiry_id))
178. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2011_07_pkey on mos.expiry_settlement_price_2011_07 esp_133 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_133.auction_price, esp_133.trading_date, esp_133.expiry_id
  • Index Cond: ((tg.trading_date = esp_133.trading_date) AND (mt.expiry_id = esp_133.expiry_id))
179. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2011_08_pkey on mos.expiry_settlement_price_2011_08 esp_134 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_134.auction_price, esp_134.trading_date, esp_134.expiry_id
  • Index Cond: ((tg.trading_date = esp_134.trading_date) AND (mt.expiry_id = esp_134.expiry_id))
180. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2011_09_pkey on mos.expiry_settlement_price_2011_09 esp_135 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_135.auction_price, esp_135.trading_date, esp_135.expiry_id
  • Index Cond: ((tg.trading_date = esp_135.trading_date) AND (mt.expiry_id = esp_135.expiry_id))
181. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2011_10_pkey on mos.expiry_settlement_price_2011_10 esp_136 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_136.auction_price, esp_136.trading_date, esp_136.expiry_id
  • Index Cond: ((tg.trading_date = esp_136.trading_date) AND (mt.expiry_id = esp_136.expiry_id))
182. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2011_11_pkey on mos.expiry_settlement_price_2011_11 esp_137 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_137.auction_price, esp_137.trading_date, esp_137.expiry_id
  • Index Cond: ((tg.trading_date = esp_137.trading_date) AND (mt.expiry_id = esp_137.expiry_id))
183. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2011_12_pkey on mos.expiry_settlement_price_2011_12 esp_138 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_138.auction_price, esp_138.trading_date, esp_138.expiry_id
  • Index Cond: ((tg.trading_date = esp_138.trading_date) AND (mt.expiry_id = esp_138.expiry_id))
184. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2012_01_pkey on mos.expiry_settlement_price_2012_01 esp_139 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_139.auction_price, esp_139.trading_date, esp_139.expiry_id
  • Index Cond: ((tg.trading_date = esp_139.trading_date) AND (mt.expiry_id = esp_139.expiry_id))
185. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2012_02_pkey on mos.expiry_settlement_price_2012_02 esp_140 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_140.auction_price, esp_140.trading_date, esp_140.expiry_id
  • Index Cond: ((tg.trading_date = esp_140.trading_date) AND (mt.expiry_id = esp_140.expiry_id))
186. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2012_03_pkey on mos.expiry_settlement_price_2012_03 esp_141 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_141.auction_price, esp_141.trading_date, esp_141.expiry_id
  • Index Cond: ((tg.trading_date = esp_141.trading_date) AND (mt.expiry_id = esp_141.expiry_id))
187. 0.000 0.000 ↓ 0.0 0

Index Scan using expiry_settlement_price_2012_04_pkey on mos.expiry_settlement_price_2012_04 esp_142 (cost=0.43..2.65 rows=1 width=18) (never executed)

  • Output: esp_142.auction_price, esp_142.trading_date, esp_142.expiry_id
  • Index Cond: ((tg.trading_date = esp_142.trading_date) AND (mt.expiry_id = esp_142.expiry_id))
188. 0.000 0.000 ↓ 0.0 0

Index Scan using organization_pkey on mos.organization org (cost=0.14..7.13 rows=99 width=26) (never executed)

  • Output: org.organization_code, org.organization_type_code, org.name, org.gcm_account_status, org.address, org.city, org.state, org.country, org.registration_date, org.activation_date, org.zip, org.primary_phone, org.primary_contact_email, org.primary_contact, org.updated_timestamp, org.updated_by_nex_user_id, org.organization_group_id, org.user_account_status_code, org.member_type, org.client_account_type, org.legal_entity_identifier, org.im_gf_standing_validated