explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rQHk

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 4,511.318 ↓ 0.0 0 1

Limit (cost=1,000.00..1,657,220.52 rows=1 width=724) (actual time=4,511.318..4,511.318 rows=0 loops=1)

2. 12.758 4,511.312 ↓ 0.0 0 1

Gather (cost=1,000.00..1,657,220.52 rows=1 width=724) (actual time=4,511.312..4,511.312 rows=0 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
3. 4,498.554 4,498.554 ↓ 0.0 0 8 / 8

Parallel Seq Scan on register_document registerdo0_ (cost=0.00..1,656,220.42 rows=1 width=724) (actual time=4,498.554..4,498.554 rows=0 loops=8)

  • Filter: ((rec_status_id = 0) AND ((holder_id)::text = '1'::text) AND (register_document_date = '2010-09-23'::date) AND (lower((register_document_name)::text) ~~ '1'::text))
  • Rows Removed by Filter: 3090800