explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M6AC

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 122,966.375 ↑ 1.0 1 1

Finalize Aggregate (cost=1,943,889.11..1,943,889.12 rows=1 width=8) (actual time=122,966.375..122,966.375 rows=1 loops=1)

2. 55.300 122,991.251 ↓ 1.1 8 1

Gather (cost=1,943,888.38..1,943,889.09 rows=7 width=8) (actual time=122,966.328..122,991.251 rows=8 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
3. 14.874 122,935.951 ↑ 1.0 1 8

Partial Aggregate (cost=1,942,888.38..1,942,888.39 rows=1 width=8) (actual time=122,935.951..122,935.951 rows=1 loops=8)

4. 122,921.077 122,921.077 ↓ 29.7 69,291 8

Parallel Seq Scan on "user" (cost=0.00..1,942,882.56 rows=2,331 width=0) (actual time=20.279..122,921.077 rows=69,291 loops=8)

  • Filter: (active AND (id_brand = 'AC'::bpchar) AND (((data -> 'activation'::text) -> 'token'::text) IS NULL) AND ((((profile ->> 'valid_email'::text))::boolean IS NULL) OR (NOT ((profile ->> 'valid_email'::text))::boolean)))
  • Rows Removed by Filter: 1809875
Planning time : 0.678 ms
Execution time : 122,991.297 ms