explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Nu9

options
# exclusive inclusive rows x rows loops node
1. 0.006 0.040 ↑ 1.0 1 1
→

Nested Loop (cost=0.00..337.70 rows=1 width=70) (actual time=0.038..0.040 rows=1 loops=1)

  • Output: trade.t_bid_price, trade.t_exec_name, trade.t_is_cash, trade_type.tt_is_mrkt, trade.t_trade_price
  • Join Filter: (trade.t_tt_id = trade_type.tt_id)
  • Total runtime: 0.079 ms
2. 0.030 0.030 ↑ 1.0 1 1
→

Index Scan using idx_t on trade (cost=0.00..336.59 rows=1 width=72) (actual time=0.029..0.030 rows=1 loops=1)

  • Output: trade.t_id, trade.t_dts, trade.t_st_id, trade.t_tt_id, trade.t_is_cash, trade.t_s_symb, trade.t_qty, tr
  • Index Cond: ((t_id)::numeric = 200000000000008::numeric)
3. 0.004 0.004 ↑ 1.0 5 1
→

Seq Scan on trade_type (cost=0.00..1.05 rows=5 width=6) (actual time=0.003..0.004 rows=5 loops=1)

  • Output: trade_type.tt_id, trade_type.tt_name, trade_type.tt_is_sell, trade_type.tt_is_mrkt