explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yEIwF

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 721.589 ↑ 1.0 1 1

Sort (cost=240,250.97..240,250.98 rows=1 width=6) (actual time=721.588..721.589 rows=1 loops=1)

  • Sort Key: priority DESC, id DESC
  • Sort Method: quicksort Memory: 25kB
2. 84.785 803.455 ↑ 1.0 1 1

Gather (cost=1,000.00..240,250.96 rows=1 width=6) (actual time=721.529..803.455 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 718.670 718.670 ↓ 0.0 0 3 / 3

Parallel Seq Scan on crm_lead (cost=0.00..239,250.86 rows=1 width=6) (actual time=697.768..718.670 rows=0 loops=3)

  • Filter: (active AND ((probability IS NULL) OR (probability < '100'::double precision)) AND ((email_normalized)::text = 'chris.kuczynski@irob.co.uk'::text))
  • Rows Removed by Filter: 967,981
Planning time : 1.417 ms
Execution time : 803.510 ms