explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hKI7r

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

Aggregate (cost=989.16..989.17 rows=1 width=8) (actual time=9.789..9.789 rows=1 loops=1)

2. 0.002 9.787 ↓ 0.0 0 1

Nested Loop (cost=32.74..989.16 rows=1 width=0) (actual time=9.787..9.787 rows=0 loops=1)

3. 0.000 9.785 ↓ 0.0 0 1

Nested Loop (cost=32.46..980.85 rows=1 width=8) (actual time=9.785..9.785 rows=0 loops=1)

4. 0.021 9.785 ↓ 0.0 0 1

Nested Loop (cost=32.46..979.80 rows=1 width=16) (actual time=9.785..9.785 rows=0 loops=1)

5. 0.014 0.014 ↓ 10.0 10 1

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

  • Filter: (orgtypecategory = 1)
  • Rows Removed by Filter: 6
6. 9.130 9.750 ↓ 0.0 0 10

Bitmap Heap Scan on pl_orgstruct a (cost=32.46..978.59 rows=1 width=32) (actual time=0.975..0.975 rows=0 loops=10)

  • Recheck Cond: (orgtypeid = d.orgtypeid)
  • Filter: ((orgstructid <> '1124974383253819392'::bigint) AND (orgstructtypeid = 1) AND (platstatus = 1) AND ((codepath)::text ~~ concat('1.1124971609753522176.1124971831758032896.1124972157378629632.1124973205375815680.1124974383253819392.', '%')))
  • Rows Removed by Filter: 714
  • Heap Blocks: exact=418
7. 0.620 0.620 ↑ 2.3 714 10

Bitmap Index Scan on test_orgtypeid (cost=0.00..32.46 rows=1,623 width=0) (actual time=0.062..0.062 rows=714 loops=10)

  • Index Cond: (orgtypeid = d.orgtypeid)
8. 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)
9. 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)