explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Dzlu

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

Limit (cost=192,917.96..192,920.88 rows=25 width=1,724) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=192,917.96..193,509.50 rows=5,070 width=1,724) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Sort (cost=191,917.94..191,924.28 rows=2,535 width=1,724) (actual rows= loops=)

  • Sort Key: created_at DESC
4. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on licenses (cost=0.00..191,846.40 rows=2,535 width=1,724) (actual rows= loops=)

  • Filter: ((lower((company)::text) ~~ '%2775594d08de9f2e393ec31f4a67d49a%'::text) OR (lower((name)::text) ~~ '%2775594d08de9f2e393ec31f4a67d49a%'::text) OR (lower((email)::text) ~~ '%2775594d08de9f2e393ec31f4a67d49a%'::text) OR (md5(license_file) = '2775594d08de9f2e393ec31f4a67d49a'::text) OR (md5(regexp_replace(license_file, '\n'::text, '