explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KZ6d

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

Aggregate (cost=1,291.16..1,291.17 rows=1 width=8) (actual time=6.001..6.001 rows=1 loops=1)

2. 0.001 5.999 ↓ 0.0 0 1

Nested Loop (cost=40.74..1,291.16 rows=1 width=0) (actual time=5.998..5.999 rows=0 loops=1)

3. 0.000 5.998 ↓ 0.0 0 1

Nested Loop (cost=40.46..1,282.86 rows=1 width=8) (actual time=5.998..5.998 rows=0 loops=1)

4. 0.026 5.998 ↓ 0.0 0 1

Nested Loop (cost=40.46..1,281.81 rows=1 width=16) (actual time=5.998..5.998 rows=0 loops=1)

5. 0.012 0.012 ↓ 10.0 10 1

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

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

Bitmap Heap Scan on pl_orgstruct a (cost=40.46..1,280.60 rows=1 width=32) (actual time=0.596..0.596 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.470 0.470 ↑ 2.3 714 10

Bitmap Index Scan on test_orgtypeid (cost=0.00..40.46 rows=1,623 width=0) (actual time=0.047..0.047 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)
Planning time : 1.047 ms
Execution time : 6.105 ms