explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fGF5

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=247,383.97..247,386.89 rows=25 width=1,723) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=247,383.97..247,683.83 rows=2,570 width=1,723) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Sort (cost=246,383.95..246,387.16 rows=1,285 width=1,723) (actual rows= loops=)

  • Sort Key: created_at DESC
  • -> Parallel Seq Scan on licenses (cost=0.00..246347.69 rows=1,285 width=1,723)" Filter: ((lower((company)::text) ~~ '%2775594d08de9f2e393ec31f3a67d49a%'::text) OR (lower((name)::text) ~~ '%2775594d08de9f2e393ec31f3a67d49a%'::text) OR (lower((email)::text) ~~ '%2775594d08de9f2e393ec31f3a67d49a%'::text) OR (license_file_md5 = '2775594d-08de-9f2e-393e-c31f3a67d49a'::uuid) OR (md5(regexp_replace(license_file, '\n'::text, '""'::text, 'g'::text)) = '2775594d08de9f2e393ec31f3a67d49a'::text) OR (md5(regexp_replace(regexp_replace(license_file, '\n$'::text, ''::text), '\n'::text, '""'::text, 'g'::text)) = '2775594d08de9f2e393ec31f3a67d49a'::text))