explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M2fg

Settings
# exclusive inclusive rows x rows loops node
1. 3.687 2,195.166 ↑ 2.7 984 1

Gather (cost=1,000.00..323,573.59 rows=2,656 width=32) (actual time=5.774..2,195.166 rows=984 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 2,191.479 2,191.479 ↑ 3.4 328 3 / 3

Parallel Seq Scan on _userprivate (cost=0.00..322,307.99 rows=1,107 width=32) (actual time=5.929..2,191.479 rows=328 loops=3)

  • Filter: ((NOT deleted) AND (((json -> 'deleted'::text) IS NULL) OR (NOT ((json ->> 'deleted'::text))::boolean)) AND (((json -> 'roles'::text) @> '""role_c1d73c81440c4f808ad58d6994ce7380""'::jsonb) OR ((json -> 'inactive_roles'::text) @> '""role_c1d73c81440c4f808ad58d6994ce7380""'::jsonb)))
  • Rows Removed by Filter: 882246
Planning time : 0.330 ms
Execution time : 2,195.306 ms