explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xhAX

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 527.822 ↑ 1.0 1 1

Aggregate (cost=1,626.40..1,626.41 rows=1 width=8) (actual time=527.822..527.822 rows=1 loops=1)

2. 0.002 527.820 ↓ 0.0 0 1

Nested Loop (cost=0.28..1,626.39 rows=1 width=0) (actual time=527.819..527.820 rows=0 loops=1)

3. 0.001 527.818 ↓ 0.0 0 1

Nested Loop (cost=0.00..1,618.09 rows=1 width=8) (actual time=527.818..527.818 rows=0 loops=1)

4. 0.061 527.817 ↓ 0.0 0 1

Nested Loop (cost=0.00..1,617.04 rows=1 width=16) (actual time=527.817..527.817 rows=0 loops=1)

  • Join Filter: (a.orgtypeid = d.orgtypeid)
  • Rows Removed by Join Filter: 20
5. 0.026 0.026 ↓ 10.0 10 1

Seq Scan on pl_orgtype d (cost=0.00..1.20 rows=1 width=8) (actual time=0.011..0.026 rows=10 loops=1)

  • Filter: (orgtypecategory = 1)
  • Rows Removed by Filter: 6
6. 527.730 527.730 ↑ 1.0 2 10

Seq Scan on pl_orgstruct a (cost=0.00..1,615.82 rows=2 width=32) (actual time=23.798..52.773 rows=2 loops=10)

  • Filter: ((orgstructid <> '1124974383253819392'::bigint) AND (orgstructtypeid = 1) AND (platstatus = 1) AND ((codepath)::text ~~ concat('1.1124971609753522176.1124971831758032896.1124972157378629632.1124973205375815680.1124974383253819392.', '%')))
  • Rows Removed by Filter: 21101
7. 0.000 0.000 ↓ 0.0 0

Seq Scan on pl_orgstructtype c (cost=0.00..1.04 rows=1 width=8) (never executed)

  • Filter: (orgstructtypeid = 1)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using pl_org_pkey on pl_org e (cost=0.28..8.30 rows=1 width=8) (never executed)

  • Index Cond: (orgid = a.orgid)
  • Filter: (platstatus = 1)