explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n5zk

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Unique (cost=17.19..17.21 rows=1 width=148) (actual rows= loops=)

  • +-Sort (cost=17.19..17.20 rows=1 width=148) Sort Key: rcv.user_cd, rcv.format_set_id, rcv.format_id, rcv.error_cd, rcv.locale_id, rcv.pattern
  • +-Nested Loop Left Join (cost=1.12..17.18 rows=1 width=148) Join Filter: (((rcv.user_cd)::text = (lastexec.user_cd)::text) AND ((rcv.format_set_id)::text = (lastexec.format_set_id)::text) AND ((rcv.format_id)::text = (lastexec.format_id)::text)) Filter: ((lastexec.user_cd IS NULL) OR ((rcv.pattern)::text <> (lastexec.pattern)::text))
  • +-Index Scan using rcv_account_dtf_pk on rcv_account_dtf rcv (cost=0.56..8.58 rows=1 width=148) Index Cond: ((torikomi_ymd = '2019-12-12'::date) AND (seq_no = 0)) Filter: (error_cd IS NULL)
  • +-Index Scan using rcv_account_dtf_pk on rcv_account_dtf lastexec (cost=0.56..8.58 rows=1 width=79) Index Cond: ((torikomi_ymd = '2019-12-12'::date) AND (seq_no = 0))