explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ESK6

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

Nested Loop (cost=0.29..1,112.54 rows=1 width=40) (actual rows= loops=)

  • Output: derivative_map_values_pl.unrealised_dal, derivative_map_values_pl.unrealised_fs_fxpl
  • Join Filter: (derivative_map_values_pl.pl_type_tag_value_id = rd_tag_value.id)
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..1,106.28 rows=1 width=48) (actual rows= loops=)

  • Output: derivative_map_values_pl.unrealised_dal, derivative_map_values_pl.unrealised_fs_fxpl, derivative_map_values_pl.pl_type_tag_value_id
  • Join Filter: (exposure_component_map.derivative_component_map_id = derivative_map_values_pl.derivative_component_map_id)
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..1,095.26 rows=1 width=16) (actual rows= loops=)

  • Output: exposure_component_map.derivative_component_map_id, derivative_component_map.id
  • Join Filter: (exposure_component_map.derivative_component_map_id = derivative_component_map.id)
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..1,091.97 rows=1 width=8) (actual rows= loops=)

  • Output: exposure_component_map.derivative_component_map_id
5. 0.000 0.000 ↓ 0.0

Index Only Scan using uk_exposure_component_no on sansera.exposure_component exposure (cost=0.29..8.30 rows=1 width=25) (actual rows= loops=)

  • Output: exposure.exposure_component_no
  • Index Cond: (exposure.exposure_component_no = 'EC/SANSERA/2019-20/08602'::text)
6. 0.000 0.000 ↓ 0.0

Seq Scan on sansera.exposure_component_map (cost=0.00..1,083.66 rows=1 width=33) (actual rows= loops=)

  • Output: exposure_component_map.id, exposure_component_map.business_unit_id, exposure_component_map.exposure_component_no, exposure_component_map.ec_notional_from, exposure_component_map.ec_notional_to, exposure_component_map (...)
  • Filter: ((exposure_component_map.from_date <= '2020-10-14'::date) AND (exposure_component_map.to_date >= '2020-10-14'::date) AND ((exposure_component_map.exposure_component_no)::text = 'EC/SANSERA/2019-20/08602'::text) AND ( (...)
7. 0.000 0.000 ↓ 0.0

Seq Scan on sansera.derivative_component_map (cost=0.00..2.57 rows=57 width=8) (actual rows= loops=)

  • Output: derivative_component_map.id, derivative_component_map.business_unit_id, derivative_component_map.nominal_derivative_component_no, derivative_component_map.dc_notional_from, derivative_component_map.dc_notional_to, derivati (...)
8. 0.000 0.000 ↓ 0.0

Seq Scan on sansera.derivative_map_values_pl (cost=0.00..10.88 rows=12 width=56) (actual rows= loops=)

  • Output: derivative_map_values_pl.id, derivative_map_values_pl.derivative_component_map_id, derivative_map_values_pl.event_date, derivative_map_values_pl.event_no, derivative_map_values_pl.pl_type_tag_value_id, derivative_map_values_pl.c (...)
  • Filter: (derivative_map_values_pl.active AND (derivative_map_values_pl.event_date <= '2020-10-14'::date))
9. 0.000 0.000 ↓ 0.0

Seq Scan on nimbus.rd_tag_value (cost=0.00..6.24 rows=2 width=8) (actual rows= loops=)

  • Output: rd_tag_value.id, rd_tag_value.tag_id, rd_tag_value.tag_value, rd_tag_value.active, rd_tag_value.code
  • Filter: ((rd_tag_value.code)::text = ANY ('{MTM,BOUGHTFORWARD}'::text[]))