explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xp1P

Settings
# exclusive inclusive rows x rows loops node
1. 1.664 44,241.544 ↓ 191.0 191 1

Nested Loop (cost=2,590.72..181,983.30 rows=1 width=5,244) (actual time=275.651..44,241.544 rows=191 loops=1)

  • Output: (row_number() OVER (?)), clearedins1_.rds_id, clearingpr2_.rds_id, clearingho3_.rds_id, currencyus4_.rds_id, ci.rds_id, ch.symbol, ci.currency_id, dsp.price, dsp.creation_time, ((SubPlan 2)), (CASE WHEN (deliverable.basket_isin IS NOT NULL) THEN (...)
2. 1,774.741 44,237.397 ↓ 191.0 191 1

Nested Loop (cost=2,590.58..181,983.13 rows=1 width=3,151) (actual time=275.612..44,237.397 rows=191 loops=1)

  • Output: (row_number() OVER (?)), ci.rds_id, ch.symbol, ci.currency_id, dsp.price, dsp.creation_time, ((SubPlan 2)), (CASE WHEN (deliverable.basket_isin IS NOT NULL) THEN (SubPlan 3) WHEN (rds_delivery_component.security_isin IS NOT NULL) THEN (SubP (...)
  • Join Filter: (clearedins1_.rds_id = ci.rds_id)
  • Rows Removed by Join Filter: 1077240
3. 0.752 2.210 ↓ 191.0 191 1

Nested Loop (cost=5.04..208.16 rows=1 width=2,531) (actual time=0.225..2.210 rows=191 loops=1)

  • Output: clearedins1_.rds_id, clearedins1_.description, clearedins1_.instrument_type, clearedins1_.unique_instrument_id, clearedins1_.clearing_product_id, clearedins1_.contract_date, clearedins1_.contract_size, clearedins1_.currency_id, cleare (...)
4. 0.012 0.076 ↑ 1.0 1 1

Nested Loop (cost=0.28..16.33 rows=1 width=1,782) (actual time=0.066..0.076 rows=1 loops=1)

  • Output: clearingpr2_.rds_id, clearingpr2_.business_date, clearingpr2_.clearing_house_id, clearingpr2_.cooperation_partner_symbol, clearingpr2_.daily_expiration, clearingpr2_.daily_settlement, clearingpr2_.default_currency_id, clearingpr (...)
5. 0.035 0.035 ↑ 1.0 1 1

Index Scan using idx_cleaprod_symbol on public.clearing_product clearingpr2_ (cost=0.14..8.16 rows=1 width=136) (actual time=0.032..0.035 rows=1 loops=1)

  • Output: clearingpr2_.rds_id, clearingpr2_.business_date, clearingpr2_.clearing_house_id, clearingpr2_.cooperation_partner_symbol, clearingpr2_.daily_expiration, clearingpr2_.daily_settlement, clearingpr2_.face_value, clearingpr2_. (...)
  • Index Cond: ((clearingpr2_.symbol)::text = 'ALV'::text)
6. 0.029 0.029 ↑ 1.0 1 1

Index Scan using clearing_house_pkey on public.clearing_house clearingho3_ (cost=0.14..8.16 rows=1 width=1,646) (actual time=0.025..0.029 rows=1 loops=1)

  • Output: clearingho3_.rds_id, clearingho3_.description, clearingho3_.name, clearingho3_.root_account_id, clearingho3_.status, clearingho3_.symbol
  • Index Cond: (clearingho3_.rds_id = clearingpr2_.clearing_house_id)
  • Filter: ((clearingho3_.symbol)::text = 'ECAG'::text)
7. 1.285 1.382 ↓ 6.4 191 1

Bitmap Heap Scan on public.cleared_instrument clearedins1_ (cost=4.75..191.53 rows=30 width=749) (actual time=0.150..1.382 rows=191 loops=1)

  • Output: clearedins1_.rds_id, clearedins1_.description, clearedins1_.instrument_type, clearedins1_.unique_instrument_id, clearedins1_.contract_date, clearedins1_.contract_size, clearedins1_.exchange_identifier, clearedins1_.exercise_styl (...)
  • Recheck Cond: (clearedins1_.clearing_product_id = clearingpr2_.rds_id)
  • Filter: (((clearedins1_.status)::text = 'ACTIVE'::text) AND ((clearedins1_.put_or_call)::text = 'CALL'::text))
  • Rows Removed by Filter: 191
  • Heap Blocks: exact=15
8. 0.097 0.097 ↓ 6.2 382 1

Bitmap Index Scan on idx_cleinst_cleproid (cost=0.00..4.75 rows=62 width=0) (actual time=0.096..0.097 rows=382 loops=1)

  • Index Cond: (clearedins1_.clearing_product_id = clearingpr2_.rds_id)
9. 7,671.324 42,460.446 ↑ 1.0 5,641 191

WindowAgg (cost=2,585.54..181,644.38 rows=5,804 width=620) (actual time=0.868..222.306 rows=5,641 loops=191)

  • Output: row_number() OVER (?), ci.rds_id, ci.currency_id, ch.symbol, dsp.price, dsp.creation_time, (SubPlan 2), CASE WHEN (deliverable.basket_isin IS NOT NULL) THEN (SubPlan 3) WHEN (rds_delivery_component.security_isin IS NOT NULL) THEN (Sub (...)
10.          

CTE dsp

11. 0.003 0.042 ↓ 0.0 0 1

Unique (cost=3.04..3.05 rows=1 width=149) (actual time=0.041..0.042 rows=0 loops=1)

  • Output: p.dtype, p.id, p.business_date, p.creation_time, p.instrument_id, p.price, p.price_type, p.is_approved, p.price_validity_state
12. 0.019 0.039 ↓ 0.0 0 1

Sort (cost=3.04..3.04 rows=1 width=149) (actual time=0.039..0.039 rows=0 loops=1)

  • Output: p.dtype, p.id, p.business_date, p.creation_time, p.instrument_id, p.price, p.price_type, p.is_approved, p.price_validity_state
  • Sort Key: p.instrument_id, p.creation_time DESC
  • Sort Method: quicksort Memory: 25kB
13. 0.020 0.020 ↓ 0.0 0 1

Seq Scan on public.prices p (cost=0.00..3.03 rows=1 width=149) (actual time=0.019..0.020 rows=0 loops=1)

  • Output: p.dtype, p.id, p.business_date, p.creation_time, p.instrument_id, p.price, p.price_type, p.is_approved, p.price_validity_state
  • Filter: ((p.is_approved IS TRUE) AND ((p.dtype)::text = 'ClearedInstrumentPrices'::text) AND ((p.price_type)::text = 'SETTLEMENT'::text))
  • Rows Removed by Filter: 2
14. 5,612.344 9,012.526 ↑ 1.0 5,641 191

Merge Left Join (cost=2,582.50..2,834.60 rows=5,804 width=1,117) (actual time=0.836..47.186 rows=5,641 loops=191)

  • Output: ci.rds_id, ci.currency_id, ch.symbol, dsp.price, dsp.creation_time, cp.unique_prod_id, cp.business_date, ci.expiration_date, deliverable.basket_isin, rds_delivery_component.security_isin, rds_delivery_component.cleared_instrumen (...)
  • Merge Cond: (ci.rds_id = instrument_deliverable.cleared_instrument_id)
  • Join Filter: (((cp.product_type)::text <> 'FBND'::text) AND (((rds_delivery_component.settlement_location)::text <> 'NCA'::text) OR ((ch.symbol)::text <> 'ECC'::text) OR ((rds_delivery_component.dtype)::text <> 'DeliveryComponentInstrum (...)
  • Rows Removed by Join Filter: 69
15. 1,900.740 1,950.683 ↑ 1.0 5,641 191

Sort (cost=1,243.64..1,258.15 rows=5,804 width=592) (actual time=0.322..10.213 rows=5,641 loops=191)

  • Output: ci.rds_id, ci.currency_id, ci.expiration_date, cp.unique_prod_id, cp.business_date, cp.product_line, cp.product_type, ch.symbol, dsp.price, dsp.creation_time
  • Sort Key: ci.rds_id
  • Sort Method: quicksort Memory: 986kB
16. 14.846 49.943 ↑ 1.0 5,641 1

Hash Left Join (cost=25.38..880.81 rows=5,804 width=592) (actual time=0.942..49.943 rows=5,641 loops=1)

  • Output: ci.rds_id, ci.currency_id, ci.expiration_date, cp.unique_prod_id, cp.business_date, cp.product_line, cp.product_type, ch.symbol, dsp.price, dsp.creation_time
  • Hash Cond: ((ci.unique_instrument_id = dsp.instrument_id) AND (cp.business_date = dsp.business_date))
17. 18.511 35.051 ↑ 1.0 5,641 1

Hash Join (cost=25.34..837.24 rows=5,804 width=572) (actual time=0.872..35.051 rows=5,641 loops=1)

  • Output: ci.rds_id, ci.currency_id, ci.expiration_date, ci.unique_instrument_id, cp.unique_prod_id, cp.business_date, cp.product_line, cp.product_type, ch.symbol
  • Hash Cond: (ci.clearing_product_id = cp.rds_id)
18. 15.738 15.738 ↑ 1.0 5,641 1

Seq Scan on public.cleared_instrument ci (cost=0.00..732.09 rows=5,804 width=40) (actual time=0.022..15.738 rows=5,641 loops=1)

  • Output: ci.rds_id, ci.description, ci.instrument_type, ci.unique_instrument_id, ci.contract_date, ci.contract_size, ci.exchange_identifier, ci.exercise_style, ci.expiration_date, ci.front_month_execution_start, c (...)
  • Filter: ((ci.is_lepo IS NOT TRUE) OR ((ci.put_or_call)::text <> 'PUT'::text))
  • Rows Removed by Filter: 44
19. 0.186 0.802 ↑ 1.0 95 1

Hash (cost=24.16..24.16 rows=95 width=548) (actual time=0.801..0.802 rows=95 loops=1)

  • Output: cp.unique_prod_id, cp.business_date, cp.rds_id, cp.product_line, cp.product_type, ch.symbol
  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
20. 0.345 0.616 ↑ 1.0 95 1

Hash Join (cost=10.90..24.16 rows=95 width=548) (actual time=0.061..0.616 rows=95 loops=1)

  • Output: cp.unique_prod_id, cp.business_date, cp.rds_id, cp.product_line, cp.product_type, ch.symbol
  • Hash Cond: (cp.clearing_house_id = ch.rds_id)
21. 0.250 0.250 ↑ 1.0 95 1

Seq Scan on public.clearing_product cp (cost=0.00..11.95 rows=95 width=40) (actual time=0.013..0.250 rows=95 loops=1)

  • Output: cp.rds_id, cp.business_date, cp.clearing_house_id, cp.cooperation_partner_symbol, cp.daily_expiration, cp.daily_settlement, cp.face_value, cp.is23hour_eligible, cp.isin_code, cp.late_closing_f (...)
22. 0.011 0.021 ↑ 20.0 2 1

Hash (cost=10.40..10.40 rows=40 width=524) (actual time=0.020..0.021 rows=2 loops=1)

  • Output: ch.symbol, ch.rds_id
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
23. 0.010 0.010 ↑ 20.0 2 1

Seq Scan on public.clearing_house ch (cost=0.00..10.40 rows=40 width=524) (actual time=0.006..0.010 rows=2 loops=1)

  • Output: ch.symbol, ch.rds_id
24. 0.002 0.046 ↓ 0.0 0 1

Hash (cost=0.02..0.02 rows=1 width=40) (actual time=0.046..0.046 rows=0 loops=1)

  • Output: dsp.price, dsp.creation_time, dsp.instrument_id, dsp.business_date
  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
25. 0.044 0.044 ↓ 0.0 0 1

CTE Scan on dsp (cost=0.00..0.02 rows=1 width=40) (actual time=0.044..0.044 rows=0 loops=1)

  • Output: dsp.price, dsp.creation_time, dsp.instrument_id, dsp.business_date
26. 1,342.777 1,449.499 ↓ 1.0 5,700 191

Materialize (cost=1,338.84..1,422.85 rows=5,601 width=578) (actual time=0.509..7.589 rows=5,700 loops=191)

  • Output: (NULL::bigint), (NULL::character varying(255)), (NULL::character varying(255)), instrument_deliverable.cleared_instrument_id, (NULL::character varying(255)), (NULL::bigint), (NULL::bigint), rds_delivery_component.settlemen (...)
27. 21.532 106.722 ↓ 1.0 5,700 1

Sort (cost=1,338.84..1,352.84 rows=5,601 width=2,150) (actual time=96.872..106.722 rows=5,700 loops=1)

  • Output: NULL::bigint, NULL::character varying(255), NULL::character varying(255), instrument_deliverable.cleared_instrument_id, NULL::character varying(255), NULL::bigint, NULL::bigint, rds_delivery_component.settlement_loca (...)
  • Sort Key: instrument_deliverable.cleared_instrument_id
  • Sort Method: quicksort Memory: 994kB
28. 17.640 85.190 ↓ 1.0 5,700 1

Hash Join (cost=635.66..990.14 rows=5,601 width=2,150) (actual time=25.438..85.190 rows=5,700 loops=1)

  • Output: NULL::bigint, NULL::character varying(255), NULL::character varying(255), instrument_deliverable.cleared_instrument_id, NULL::character varying(255), NULL::bigint, NULL::bigint, rds_delivery_component.settlemen (...)
  • Hash Cond: (ci_1.clearing_product_id = cp_1.rds_id)
29. 17.035 67.236 ↓ 1.0 5,700 1

Hash Join (cost=622.53..899.98 rows=5,601 width=586) (actual time=25.107..67.236 rows=5,700 loops=1)

  • Output: rds_delivery_component.settlement_location, rds_delivery_component.security_isin, rds_delivery_component.cleared_instrument_id, rds_delivery_component.dtype, instrument_deliverable.cleared_instrument_id, (...)
  • Hash Cond: (instrument_deliverable.cleared_instrument_id = ci_1.rds_id)
30. 17.982 30.198 ↓ 1.0 5,700 1

Hash Join (cost=41.45..241.89 rows=5,601 width=578) (actual time=5.046..30.198 rows=5,700 loops=1)

  • Output: rds_delivery_component.settlement_location, rds_delivery_component.security_isin, rds_delivery_component.cleared_instrument_id, rds_delivery_component.dtype, instrument_deliverable.cleared_instrumen (...)
  • Hash Cond: (instrument_deliverable.deliverable_id = deliverable_component.deliverable_id)
31. 7.191 7.191 ↑ 1.0 5,682 1

Seq Scan on public.instrument_deliverable (cost=0.00..101.82 rows=5,682 width=16) (actual time=0.006..7.191 rows=5,682 loops=1)

  • Output: instrument_deliverable.cleared_instrument_id, instrument_deliverable.deliverable_id
32. 0.381 5.025 ↑ 1.0 209 1

Hash (cost=38.84..38.84 rows=209 width=586) (actual time=5.024..5.025 rows=209 loops=1)

  • Output: rds_delivery_component.settlement_location, rds_delivery_component.security_isin, rds_delivery_component.cleared_instrument_id, rds_delivery_component.dtype, deliverable_component.deliverable_ (...)
  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
33. 0.649 4.644 ↑ 1.0 209 1

Hash Join (cost=18.00..38.84 rows=209 width=586) (actual time=2.991..4.644 rows=209 loops=1)

  • Output: rds_delivery_component.settlement_location, rds_delivery_component.security_isin, rds_delivery_component.cleared_instrument_id, rds_delivery_component.dtype, deliverable_component.delive (...)
  • Hash Cond: (deliverable_component.deliverable_id = deliverable.deliverable_id)
34. 0.695 3.287 ↑ 1.0 209 1

Hash Join (cost=6.70..24.67 rows=209 width=62) (actual time=2.250..3.287 rows=209 loops=1)

  • Output: rds_delivery_component.settlement_location, rds_delivery_component.security_isin, rds_delivery_component.cleared_instrument_id, rds_delivery_component.dtype, deliverable_component. (...)
  • Hash Cond: (rds_delivery_component.delivery_component_id = deliverable_component.rds_delivery_component_id)
35. 0.384 0.384 ↑ 1.0 209 1

Seq Scan on public.rds_delivery_component (cost=0.00..15.09 rows=209 width=62) (actual time=0.015..0.384 rows=209 loops=1)

  • Output: rds_delivery_component.dtype, rds_delivery_component.delivery_component_id, rds_delivery_component.settlement_location, rds_delivery_component.security_isin, rds_delivery_com (...)
36. 1.891 2.208 ↑ 1.0 209 1

Hash (cost=4.09..4.09 rows=209 width=16) (actual time=2.207..2.208 rows=209 loops=1)

  • Output: deliverable_component.rds_delivery_component_id, deliverable_component.deliverable_id
  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
37. 0.317 0.317 ↑ 1.0 209 1

Seq Scan on public.deliverable_component (cost=0.00..4.09 rows=209 width=16) (actual time=0.015..0.317 rows=209 loops=1)

  • Output: deliverable_component.rds_delivery_component_id, deliverable_component.deliverable_id
38. 0.347 0.708 ↑ 1.0 191 1

Hash (cost=8.91..8.91 rows=191 width=524) (actual time=0.707..0.708 rows=191 loops=1)

  • Output: deliverable.basket_isin, deliverable.deliverable_id
  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
39. 0.361 0.361 ↑ 1.0 191 1

Seq Scan on public.deliverable (cost=0.00..8.91 rows=191 width=524) (actual time=0.024..0.361 rows=191 loops=1)

  • Output: deliverable.basket_isin, deliverable.deliverable_id
40. 9.495 20.003 ↑ 1.0 5,685 1

Hash (cost=507.99..507.99 rows=5,847 width=16) (actual time=20.002..20.003 rows=5,685 loops=1)

  • Output: ci_1.rds_id, ci_1.clearing_product_id
  • Buckets: 8192 Batches: 1 Memory Usage: 331kB
41. 10.508 10.508 ↑ 1.0 5,685 1

Index Only Scan using idx_cleinst_proid_rdsid on public.cleared_instrument ci_1 (cost=0.28..507.99 rows=5,847 width=16) (actual time=0.023..10.508 rows=5,685 loops=1)

  • Output: ci_1.rds_id, ci_1.clearing_product_id
  • Heap Fetches: 0
42. 0.147 0.314 ↑ 1.0 95 1

Hash (cost=11.95..11.95 rows=95 width=8) (actual time=0.313..0.314 rows=95 loops=1)

  • Output: cp_1.rds_id
  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
43. 0.167 0.167 ↑ 1.0 95 1

Seq Scan on public.clearing_product cp_1 (cost=0.00..11.95 rows=95 width=8) (actual time=0.010..0.167 rows=95 loops=1)

  • Output: cp_1.rds_id
44.          

SubPlan (forWindowAgg)

45. 3,232.293 10,774.310 ↓ 0.0 0 1,077,431

Unique (cost=3.06..3.06 rows=1 width=23) (actual time=0.010..0.010 rows=0 loops=1,077,431)

  • Output: fsp.price, fsp.instrument_id, fsp.creation_time
46. 5,387.155 7,542.017 ↓ 0.0 0 1,077,431

Sort (cost=3.06..3.06 rows=1 width=23) (actual time=0.007..0.007 rows=0 loops=1,077,431)

  • Output: fsp.price, fsp.instrument_id, fsp.creation_time
  • Sort Key: fsp.creation_time DESC
  • Sort Method: quicksort Memory: 25kB
47. 2,009.702 2,154.862 ↓ 0.0 0 1,077,431

Result (cost=0.01..3.05 rows=1 width=23) (actual time=0.002..0.002 rows=0 loops=1,077,431)

  • Output: fsp.price, fsp.instrument_id, fsp.creation_time
  • One-Time Filter: (cp.business_date = date(ci.expiration_date))
48. 145.160 145.160 ↓ 0.0 0 36,290

Seq Scan on public.prices fsp (cost=0.01..3.05 rows=1 width=23) (actual time=0.004..0.004 rows=0 loops=36,290)

  • Output: fsp.dtype, fsp.id, fsp.business_date, fsp.creation_time, fsp.instrument_id, fsp.price, fsp.price_type, fsp.is_approved, fsp.price_validity_state
  • Filter: (((fsp.dtype)::text = 'ProductPrices'::text) AND (cp.unique_prod_id = fsp.instrument_id) AND ((fsp.price_type)::text = 'FINALSETTLEMENT'::text) AND (fsp.business_date = date(ci.expiration_date)))
  • Rows Removed by Filter: 2
49. 0.000 0.000 ↓ 0.0 0

Unique (cost=8.18..8.19 rows=1 width=27) (never executed)

  • Output: underlying_prices.price, underlying_prices.isin, underlying_prices.creation_time
50. 0.000 0.000 ↓ 0.0 0

Sort (cost=8.18..8.19 rows=1 width=27) (never executed)

  • Output: underlying_prices.price, underlying_prices.isin, underlying_prices.creation_time
  • Sort Key: underlying_prices.creation_time DESC
51. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_undlprs_isin on public.underlying_prices (cost=0.15..8.17 rows=1 width=27) (never executed)

  • Output: underlying_prices.price, underlying_prices.isin, underlying_prices.creation_time
  • Index Cond: ((underlying_prices.isin)::text = (deliverable.basket_isin)::text)
  • Filter: (underlying_prices.business_date = cp.business_date)
52. 2,711.436 10,845.744 ↓ 0.0 0 903,812

Unique (cost=8.18..8.19 rows=1 width=27) (actual time=0.012..0.012 rows=0 loops=903,812)

  • Output: underlying_prices_1.price, underlying_prices_1.isin, underlying_prices_1.creation_time
53. 5,422.872 8,134.308 ↓ 0.0 0 903,812

Sort (cost=8.18..8.19 rows=1 width=27) (actual time=0.009..0.009 rows=0 loops=903,812)

  • Output: underlying_prices_1.price, underlying_prices_1.isin, underlying_prices_1.creation_time
  • Sort Key: underlying_prices_1.creation_time DESC
  • Sort Method: quicksort Memory: 25kB
54. 2,711.436 2,711.436 ↓ 0.0 0 903,812

Index Scan using idx_undlprs_isin on public.underlying_prices underlying_prices_1 (cost=0.15..8.17 rows=1 width=27) (actual time=0.003..0.003 rows=0 loops=903,812)

  • Output: underlying_prices_1.price, underlying_prices_1.isin, underlying_prices_1.creation_time
  • Index Cond: ((underlying_prices_1.isin)::text = (rds_delivery_component.security_isin)::text)
  • Filter: (underlying_prices_1.business_date = cp.business_date)
55. 0.000 4,156.542 ↓ 0.0 0 153,946

Unique (cost=11.35..11.36 rows=1 width=23) (actual time=0.027..0.027 rows=0 loops=153,946)

  • Output: prices.price, prices.instrument_id, prices.creation_time
56.          

Initplan (forUnique)

57. 1,077.622 1,077.622 ↑ 1.0 1 153,946

Index Scan using cleared_instrument_pkey on public.cleared_instrument (cost=0.28..8.30 rows=1 width=8) (actual time=0.005..0.007 rows=1 loops=153,946)

  • Output: cleared_instrument.unique_instrument_id
  • Index Cond: (cleared_instrument.rds_id = rds_delivery_component.cleared_instrument_id)
58. 1,077.622 3,694.704 ↓ 0.0 0 153,946

Sort (cost=3.05..3.05 rows=2 width=23) (actual time=0.024..0.024 rows=0 loops=153,946)

  • Output: prices.price, prices.instrument_id, prices.creation_time
  • Sort Key: prices.creation_time DESC
  • Sort Method: quicksort Memory: 25kB
59. 2,617.082 2,617.082 ↓ 0.0 0 153,946

Seq Scan on public.prices (cost=0.00..3.04 rows=2 width=23) (actual time=0.017..0.017 rows=0 loops=153,946)

  • Output: prices.price, prices.instrument_id, prices.creation_time
  • Filter: (((prices.dtype)::text = 'ClearedInstrumentPrices'::text) AND (prices.instrument_id = $9) AND (prices.business_date = cp.business_date) AND ((prices.price_type)::text = 'SETTLEMENT'::text))
  • Rows Removed by Filter: 2
60. 2.483 2.483 ↑ 1.0 1 191

Index Scan using currency_usage_rule_pkey on public.currency_usage_rule currencyus4_ (cost=0.14..0.16 rows=1 width=2,093) (actual time=0.011..0.013 rows=1 loops=191)

  • Output: currencyus4_.rds_id, currencyus4_.cash_collectable_conversion_rate, currencyus4_.cash_collectable_currency_symbol, currencyus4_.clearing_house, currencyus4_.name, currencyus4_.primary_currency, currencyus4_.rounding_decimals, currencyus4_.s (...)
  • Index Cond: (currencyus4_.rds_id = ci.currency_id)
  • Filter: ((currencyus4_.symbol)::text = 'EUR'::text)
Planning time : 6.289 ms
Execution time : 44,242.898 ms