explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6GDP

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.014 2,328.176 ↑ 1.0 100 1

Limit (cost=1,000.00..24,192.60 rows=100 width=2,111) (actual time=2,288.423..2,328.176 rows=100 loops=1)

2. 44.098 2,328.162 ↑ 127.5 100 1

Gather (cost=1,000.00..2,956,896.25 rows=12,745 width=2,111) (actual time=2,288.421..2,328.162 rows=100 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 2,284.064 2,284.064 ↑ 144.8 22 5 / 5

Parallel Seq Scan on a_alt_sms_status altsmsstat0_ (cost=0.00..2,954,621.75 rows=3,186 width=2,111) (actual time=2,283.565..2,284.064 rows=22 loops=5)

  • Filter: ((modify_date_ IS NULL) AND ((alt_sms_id_)::text <> 'ERROR'::text))
  • Rows Removed by Filter: 600,165
Planning time : 0.116 ms
Execution time : 2,328.242 ms