explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZGIH

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 3,361.840 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.43..665,129.98 rows=1 width=3,013) (actual time=1,589.902..3,361.840 rows=1 loops=1)

  • Output: deal0_.id, deal0_.cancel_reason, deal0_.channel, deal0_.deal_number, deal0_.source_id, deal0_.discriminator, deal0_.error_message, deal0_.input_message, deal0_.mapping_warning, deal0_.output_message, deal0_.output_order, deal0
  • Buffers: shared hit=500477 read=106056
2. 3,361.806 3,361.806 ↑ 1.0 1 1

Seq Scan on fx_foa.general_deal deal0_ (cost=0.00..665,121.52 rows=1 width=2,475) (actual time=1,589.871..3,361.806 rows=1 loops=1)

  • Output: deal0_.id, deal0_."timestamp", deal0_.send_time, deal0_.remarks, deal0_.channel, deal0_.input_message, deal0_.output_message, deal0_.status_id, deal0_.source_id, deal0_.last_status_id, deal0_.mapping_warning, deal0_.erro
  • Filter: (((deal0_.deal_number)::text = 'CVP1446690'::text) AND ((deal0_.discriminator)::text = ANY ('{DEAL,NDF,SWAP,MFC,FORW,MM,OPT,SPOT}'::text[])))
  • Rows Removed by Filter: 2610814
  • Buffers: shared hit=500473 read=106056
3. 0.021 0.021 ↑ 1.0 1 1

Index Scan using pk_deal_detail on fx_foa.deal_detail deal0_1_ (cost=0.43..8.45 rows=1 width=546) (actual time=0.020..0.021 rows=1 loops=1)

  • Output: deal0_1_.additional_trade_id, deal0_1_.amount, deal0_1_.broker_code, deal0_1_.brokerage_amount, deal0_1_.brokerage_ccy, deal0_1_.buy_si, deal0_1_.ccy, deal0_1_.client_code, deal0_1_.counter_amount, deal0_1_.counter_ccy,
  • Index Cond: (deal0_.id = deal0_1_.id)
  • Buffers: shared hit=4
Planning time : 0.437 ms
Execution time : 3,361.936 ms