explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 75HZ

Settings
# exclusive inclusive rows x rows loops node
1. 6.703 31.539 ↑ 196.0 2 1

Gather Merge (cost=5,439.63..5,485.37 rows=392 width=254) (actual time=31.492..31.539 rows=2 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.031 24.836 ↑ 196.0 1 3 / 3

Sort (cost=4,439.61..4,440.10 rows=196 width=254) (actual time=24.836..24.836 rows=1 loops=3)

  • Sort Key: id
  • Sort Method: quicksort Memory: 25kB
3. 24.805 24.805 ↑ 196.0 1 3 / 3

Parallel Seq Scan on users (cost=0.00..4,432.14 rows=196 width=254) (actual time=24.743..24.805 rows=1 loops=3)

  • Filter: (is_guest AND (pwhash IS NULL) AND (lower((mailing_list_email)::text) = 'dimaofman@gmail.com'::text))
  • Rows Removed by Filter: 66170
Planning time : 0.172 ms
Execution time : 31.573 ms