explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 17xl : Optimization for: plan #P8rl

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 0.192 ↓ 0.0 0 1

HashAggregate (cost=25.51..25.54 rows=3 width=192) (actual time=0.192..0.192 rows=0 loops=1)

  • Output: latest_orders_prev31days_liquid.source_system, latest_orders_prev31days_liquid.instrument_id, latest_orders_prev31days_liquid.local_security_code, latest_orders_prev31days_liquid.security_board, latest_orders_prev31days_liquid.oms_exchange_id
  • Group Key: latest_orders_prev31days_liquid.source_system, latest_orders_prev31days_liquid.instrument_id, latest_orders_prev31days_liquid.local_security_code, latest_orders_prev31days_liquid.security_board, latest_orders_prev31days_liquid.oms_exchange_id
  • Buffers: shared read=9
2. 0.001 0.190 ↓ 0.0 0 1

Append (cost=8.47..25.47 rows=3 width=192) (actual time=0.190..0.190 rows=0 loops=1)

  • Buffers: shared read=9
3. 0.000 0.089 ↓ 0.0 0 1

Unique (cost=8.47..8.49 rows=1 width=24) (actual time=0.089..0.089 rows=0 loops=1)

  • Output: latest_orders_prev31days_liquid.source_system, latest_orders_prev31days_liquid.instrument_id, latest_orders_prev31days_liquid.local_security_code, latest_orders_prev31days_liquid.security_board, latest_orders_prev31days_liquid.oms_exc (...)
  • Buffers: shared read=3
4. 0.015 0.089 ↓ 0.0 0 1

Sort (cost=8.47..8.47 rows=1 width=24) (actual time=0.089..0.089 rows=0 loops=1)

  • Output: latest_orders_prev31days_liquid.source_system, latest_orders_prev31days_liquid.instrument_id, latest_orders_prev31days_liquid.local_security_code, latest_orders_prev31days_liquid.security_board, latest_orders_prev31days_liquid.o (...)
  • Sort Key: latest_orders_prev31days_liquid.source_system, latest_orders_prev31days_liquid.instrument_id, latest_orders_prev31days_liquid.local_security_code, latest_orders_prev31days_liquid.security_board, latest_orders_prev31days_liquid (...)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared read=3
5. 0.074 0.074 ↓ 0.0 0 1

Index Scan using latest_orders_prev31days_liquid_trade_date_order_id_idx on trade_brain.latest_orders_prev31days_liquid (cost=0.43..8.46 rows=1 width=24) (actual time=0.074..0.074 rows=0 loops=1)

  • Output: latest_orders_prev31days_liquid.source_system, latest_orders_prev31days_liquid.instrument_id, latest_orders_prev31days_liquid.local_security_code, latest_orders_prev31days_liquid.security_board, latest_orders_prev31days_li (...)
  • Index Cond: ((latest_orders_prev31days_liquid.trade_date >= '2020-03-27'::date) AND (latest_orders_prev31days_liquid.trade_date <= '2020-03-28'::date))
  • Filter: (((latest_orders_prev31days_liquid.order_rank)::text = 'CLOG'::text) AND (latest_orders_prev31days_liquid.client_reference = 5151411) AND ((latest_orders_prev31days_liquid.exchange_id)::text = ANY ('{JTOS,JCHX,JSBI,JTSE}': (...)
  • Buffers: shared read=3
6. 0.000 0.055 ↓ 0.0 0 1

Unique (cost=8.47..8.49 rows=1 width=22) (actual time=0.055..0.055 rows=0 loops=1)

  • Output: latest_orders_prev31days_viper.source_system, latest_orders_prev31days_viper.instrument_id, latest_orders_prev31days_viper.local_security_code, latest_orders_prev31days_viper.security_board, latest_orders_prev31days_viper.oms_exchange (...)
  • Buffers: shared read=3
7. 0.012 0.055 ↓ 0.0 0 1

Sort (cost=8.47..8.47 rows=1 width=22) (actual time=0.055..0.055 rows=0 loops=1)

  • Output: latest_orders_prev31days_viper.source_system, latest_orders_prev31days_viper.instrument_id, latest_orders_prev31days_viper.local_security_code, latest_orders_prev31days_viper.security_board, latest_orders_prev31days_viper.oms_ex (...)
  • Sort Key: latest_orders_prev31days_viper.source_system, latest_orders_prev31days_viper.instrument_id, latest_orders_prev31days_viper.local_security_code, latest_orders_prev31days_viper.security_board, latest_orders_prev31days_viper.oms_ (...)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared read=3
8. 0.043 0.043 ↓ 0.0 0 1

Index Scan using latest_orders_prev31days_viper_client_reference_trade_date_idx on trade_brain.latest_orders_prev31days_viper (cost=0.43..8.46 rows=1 width=22) (actual time=0.043..0.043 rows=0 loops=1)

  • Output: latest_orders_prev31days_viper.source_system, latest_orders_prev31days_viper.instrument_id, latest_orders_prev31days_viper.local_security_code, latest_orders_prev31days_viper.security_board, latest_orders_prev31days_viper. (...)
  • Index Cond: ((latest_orders_prev31days_viper.client_reference = 5151411) AND (latest_orders_prev31days_viper.trade_date >= '2020-03-27'::date) AND (latest_orders_prev31days_viper.trade_date <= '2020-03-28'::date))
  • Filter: ((latest_orders_prev31days_viper.order_rank)::text = 'DealingOrder'::text)
  • Buffers: shared read=3
9. 0.000 0.045 ↓ 0.0 0 1

Unique (cost=8.45..8.47 rows=1 width=24) (actual time=0.045..0.045 rows=0 loops=1)

  • Output: latest_orders_prev31days_python.source_system, latest_orders_prev31days_python.instrument_id, latest_orders_prev31days_python.local_security_code, latest_orders_prev31days_python.security_board, latest_orders_prev31days_python.oms_exc (...)
  • Buffers: shared read=3
10. 0.007 0.045 ↓ 0.0 0 1

Sort (cost=8.45..8.46 rows=1 width=24) (actual time=0.045..0.045 rows=0 loops=1)

  • Output: latest_orders_prev31days_python.source_system, latest_orders_prev31days_python.instrument_id, latest_orders_prev31days_python.local_security_code, latest_orders_prev31days_python.security_board, latest_orders_prev31days_python.o (...)
  • Sort Key: latest_orders_prev31days_python.source_system, latest_orders_prev31days_python.instrument_id, latest_orders_prev31days_python.local_security_code, latest_orders_prev31days_python.security_board, latest_orders_prev31days_python (...)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared read=3
11. 0.038 0.038 ↓ 0.0 0 1

Index Scan using latest_orders_prev31days_python_trade_date_order_id_idx on trade_brain.latest_orders_prev31days_python (cost=0.42..8.44 rows=1 width=24) (actual time=0.038..0.038 rows=0 loops=1)

  • Output: latest_orders_prev31days_python.source_system, latest_orders_prev31days_python.instrument_id, latest_orders_prev31days_python.local_security_code, latest_orders_prev31days_python.security_board, latest_orders_prev31days_py (...)
  • Index Cond: ((latest_orders_prev31days_python.trade_date >= '2020-03-27'::date) AND (latest_orders_prev31days_python.trade_date <= '2020-03-28'::date))
  • Filter: ((latest_orders_prev31days_python.order_rank)::text = 'SalesOrder'::text)
  • Buffers: shared read=3
Planning time : 8.027 ms
Execution time : 0.332 ms