explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EHKT : onespan

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 129,973.392 ↑ 9.1 11 1

Limit (cost=1,690,430.02..1,690,441.52 rows=100 width=338) (actual time=129,973.379..129,973.392 rows=11 loops=1)

2. 33.096 129,973.383 ↑ 458.6 11 1

Gather Merge (cost=1,690,430.02..1,691,010.20 rows=5,045 width=338) (actual time=129,973.372..129,973.383 rows=11 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 0.107 129,940.287 ↑ 840.8 6 2 / 2

Sort (cost=1,689,430.01..1,689,442.63 rows=5,045 width=338) (actual time=129,940.286..129,940.287 rows=6 loops=2)

  • Sort Key: etax_process_log.document_type_code, etax_process_log.document_id, etax_process_log.document_date
  • Sort Method: quicksort Memory: 26kB
4. 0.050 129,940.180 ↑ 840.8 6 2 / 2

Nested Loop Left Join (cost=77,334.12..1,689,119.73 rows=5,045 width=338) (actual time=91,505.618..129,940.180 rows=6 loops=2)

5. 129,464.838 129,807.569 ↑ 840.8 6 2 / 2

Parallel Bitmap Heap Scan on etax_process_log (cost=77,333.57..1,652,493.69 rows=5,045 width=270) (actual time=91,495.997..129,807.569 rows=6 loops=2)

  • Recheck Cond: ((seller_serial_no)::text = '5A2D-3ABC-RWHS'::text)
  • Rows Removed by Index Recheck: 1,138,802
  • 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[])))
  • Rows Removed by Filter: 1,007,884
  • Heap Blocks: exact=23,077 lossy=275,222
6. 342.731 342.731 ↓ 1.1 2,078,743 1 / 2

Bitmap Index Scan on idx_seller_serial_no (cost=0.00..77,331.43 rows=1,976,382 width=0) (actual time=685.463..685.463 rows=2,078,743 loops=1)

  • Index Cond: ((seller_serial_no)::text = '5A2D-3ABC-RWHS'::text)
7. 132.561 132.561 ↓ 0.0 0 11 / 2

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

  • Index Cond: (etax_process_log.process_id = process_id)