explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4kQc

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 8,238.417 ↓ 0.0 0 1

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

2. 9.280 8,238.411 ↓ 0.0 0 1

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

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

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

  • 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: 6181630