explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RS8S

Settings
# exclusive inclusive rows x rows loops node
1. 188.588 987.104 ↑ 62,752.0 2 1

Nested Loop (cost=0.85..892,511.27 rows=125,504 width=1,312) (actual time=79.339..987.104 rows=2 loops=1)

  • -> Index Scan using pk_ismv_exchange_logs_data on ismv_exchange_logs_data ield (cost=0.43..274568.46 rows=1179023 width=1288) (actual time=0.037..256.811 rows=399
2. 798.516 798.516 ↓ 0.0 0 399,258

Index Scan using pk_ismv_exchange_logs on ismv_exchange_logs iel (cost=0.43..0.52 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=399,258)

  • Index Cond: (id = ield.ismv_exchange_log_id)
  • Filter: ((type = 'Ismv::AdjustmentsResponse::In'::text) AND (state = 3) AND (response_code = 1))
  • Rows Removed by Filter: 1