explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2CHo

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

Limit (cost=1,687,371.05..1,687,382.55 rows=100 width=338) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=1,687,371.05..1,687,951.34 rows=5,046 width=338) (actual rows= loops=)

  • Workers Planned: 1
3. 0.000 0.000 ↓ 0.0

Sort (cost=1,686,371.04..1,686,383.66 rows=5,046 width=338) (actual rows= loops=)

  • Sort Key: etax_process_log.document_type_code, etax_process_log.document_id, etax_process_log.document_date
4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=75,348.89..1,686,060.69 rows=5,046 width=338) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on etax_process_log (cost=75,348.34..1,649,432.12 rows=5,046 width=270) (actual rows= loops=)

  • Recheck Cond: ((seller_serial_no)::text = '5A2D-3ABC-RWHS'::text)
  • Filter: (((document_id)::text <> ''::text) AND ((document_type_code)::text <> ''::text) AND (document_date <> ''::bpchar) AND (process_finish_ind = 'Y'::bpchar) AND ("left"((document_date)::text, 8) >= '20200809'::text) AND ("left"((document_date)::text, 8) <= '20200908'::text) AND ((document_type_code)::text = ANY ('{388,T02,T03,T04,T01,80,81}'::text[])))
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_seller_serial_no (cost=0.00..75,346.20 rows=1,978,885 width=0) (actual rows= loops=)

  • Index Cond: ((seller_serial_no)::text = '5A2D-3ABC-RWHS'::text)
7. 0.000 0.000 ↓ 0.0

Index Scan using etax_process_error_log_pk on etax_process_error_log (cost=0.55..7.25 rows=1 width=170) (actual rows= loops=)

  • Index Cond: (etax_process_log.process_id = process_id)