explain.depesz.com

PostgreSQL's explain analyze made readable

Result: riAz : Optimization for: plan #pHtt

Settings

Optimization path:

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

Unique (cost=2,638.23..2,638.31 rows=8 width=41) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=2,638.23..2,638.25 rows=8 width=41) (actual rows= loops=)

  • Sort Key: ((regexp_replace((tst.tags)::text, '[^0-9]'::text, ''::text, 'g'::text))::integer), tst.tags, (row_number() OVER (?))
3. 0.000 0.000 ↓ 0.0

WindowAgg (cost=2,637.91..2,638.11 rows=8 width=41) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=2,637.91..2,637.93 rows=8 width=33) (actual rows= loops=)

  • Sort Key: ((regexp_replace((tst.tags)::text, '[^0-9]'::text, ''::text, 'g'::text))::integer)
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,057.08..2,637.79 rows=8 width=33) (actual rows= loops=)

  • Hash Cond: ((tst.test_suite_id)::text = (test_suite.id)::text)
6. 0.000 0.000 ↓ 0.0

Seq Scan on test_suite_tags tst (cost=0.00..1,579.84 rows=312 width=48) (actual rows= loops=)

  • Filter: ("substring"((tags)::text, 1, 5) = 'OWASP'::text)
7. 0.000 0.000 ↓ 0.0

Hash (cost=1,052.92..1,052.92 rows=332 width=47) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on test_suite (cost=0.00..1,052.92 rows=332 width=47) (actual rows= loops=)

  • Filter: (((project_id)::text = 'ff808181738192710173819c57f40000'::text) AND ((category)::text = 'NoSQL_Injection'::text))