explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z2cA

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 1.454 ↑ 1.0 1 1

Aggregate (cost=707.60..707.61 rows=1 width=8) (actual time=1.454..1.454 rows=1 loops=1)

2. 0.011 1.444 ↑ 42.6 16 1

Nested Loop (cost=6.85..705.90 rows=681 width=0) (actual time=0.320..1.444 rows=16 loops=1)

3. 0.015 1.289 ↑ 42.6 16 1

Nested Loop (cost=6.57..491.68 rows=681 width=8) (actual time=0.300..1.289 rows=16 loops=1)

  • Join Filter: ((loctp.linknodeidentifier)::text = (locnr.name)::text)
4. 0.026 0.970 ↓ 16.0 16 1

Nested Loop (cost=6.14..19.26 rows=1 width=1,032) (actual time=0.264..0.970 rows=16 loops=1)

5. 0.160 0.356 ↓ 49.0 49 1

Hash Join (cost=6.00..18.87 rows=1 width=2,064) (actual time=0.154..0.356 rows=49 loops=1)

  • Hash Cond: (((lnk.aendname)::text = (loctp.name)::text) AND ((lnk.aendnodeidentifier)::text = (loctp.linknodeidentifier)::text))
6. 0.084 0.084 ↓ 1.0 107 1

Seq Scan on link lnk (cost=0.00..12.06 rows=106 width=2,064) (actual time=0.019..0.084 rows=107 loops=1)

7. 0.043 0.112 ↑ 1.1 76 1

Hash (cost=4.80..4.80 rows=80 width=1,032) (actual time=0.112..0.112 rows=76 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
8. 0.069 0.069 ↓ 1.1 84 1

Seq Scan on linkterminationpoint loctp (cost=0.00..4.80 rows=80 width=1,032) (actual time=0.011..0.069 rows=84 loops=1)

9. 0.588 0.588 ↓ 0.0 0 49

Index Only Scan using ix_tp_linkterminationpoint on linkterminationpoint remtp (cost=0.14..0.39 rows=1 width=1,032) (actual time=0.012..0.012 rows=0 loops=49)

  • Index Cond: ((name = (lnk.bendname)::text) AND (linknodeidentifier = (lnk.bendnodeidentifier)::text))
  • Heap Fetches: 16
10. 0.304 0.304 ↑ 681.0 1 16

Index Only Scan using ix_nr_tp on networkresource locnr (cost=0.42..463.90 rows=681 width=26) (actual time=0.018..0.019 rows=1 loops=16)

  • Index Cond: (name = (lnk.aendnodeidentifier)::text)
  • Heap Fetches: 16
11. 0.144 0.144 ↑ 1.0 1 16

Index Only Scan using managedelementinterface_pkey on managedelementinterface locmei (cost=0.28..0.30 rows=1 width=8) (actual time=0.008..0.009 rows=1 loops=16)

  • Index Cond: (id = locnr.managedelementinterface_id)
  • Heap Fetches: 16