explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6tL5

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

Nested Loop Left Join (cost=559.13..579.16 rows=1 width=114) (actual time=5.348..5.348 rows=0 loops=1)

  • Output: s.inidversion, t.stname, m.stkeyattr, v.stnumber, s.iniduser, 'ÀÄÌÈÍÈÑÒÐÀÒÎÐ'::text, LOCALTIMESTAMP, decode(c.indone, '2'::smallint, 101, 100), e.indelivtype
  • Inner Unique: true
2. 0.000 5.348 ↓ 0.0 0 1

Nested Loop Left Join (cost=558.98..578.96 rows=1 width=74) (actual time=5.348..5.348 rows=0 loops=1)

  • Output: s.inidversion, s.iniduser, v.stnumber, m.stkeyattr, t.stname, e.indelivtype, lck.state
  • Inner Unique: true
3. 0.000 5.348 ↓ 0.0 0 1

Nested Loop (cost=558.82..570.79 rows=1 width=70) (actual time=5.348..5.348 rows=0 loops=1)

  • Output: s.inidversion, s.iniduser, v.stnumber, m.stkeyattr, t.stname, e.indelivtype
  • Join Filter: (s.inid = e.inid)
4. 0.000 5.348 ↓ 0.0 0 1

Nested Loop (cost=558.82..569.74 rows=1 width=70) (actual time=5.348..5.348 rows=0 loops=1)

  • Output: s.inidversion, s.iniduser, s.inid, v.stnumber, m.stkeyattr, t.stname
  • Inner Unique: true
5. 0.001 5.348 ↓ 0.0 0 1

Nested Loop (cost=558.68..569.57 rows=1 width=45) (actual time=5.348..5.348 rows=0 loops=1)

  • Output: s.inidversion, s.iniduser, s.inid, v.stnumber, m.stkeyattr, m.inidtype
  • Inner Unique: true
6. 0.000 5.347 ↓ 0.0 0 1

Nested Loop (cost=558.25..569.08 rows=1 width=18) (actual time=5.347..5.347 rows=0 loops=1)

  • Output: s.inidversion, s.iniduser, s.inid, v.stnumber, v.inidmain
  • Inner Unique: true
7. 0.012 5.347 ↓ 0.0 0 1

Hash Join (cost=557.82..560.63 rows=1 width=16) (actual time=5.347..5.347 rows=0 loops=1)

  • Output: lck_1.inidversion, s.inidversion, s.iniduser, s.inid
  • Hash Cond: (lck_1.inidversion = s.inidversion)
8. 0.214 5.311 ↑ 39.3 3 1

HashAggregate (cost=556.79..557.97 rows=118 width=4) (actual time=5.308..5.311 rows=3 loops=1)

  • Output: lck_1.inidversion
  • Group Key: lck_1.inidversion
9.          

CTE c

10. 0.005 0.012 ↑ 3.7 3 1

Bitmap Heap Scan on ora_dbo.stchanges (cost=4.24..14.91 rows=11 width=10) (actual time=0.011..0.012 rows=3 loops=1)

  • Output: stchanges.inid, stchanges.inidlock, stchanges.indone
  • Recheck Cond: (stchanges.inidlock = 1422)
  • Heap Blocks: exact=1
11. 0.007 0.007 ↑ 3.7 3 1

Bitmap Index Scan on stchanges_inidlock_indone_key (cost=0.00..4.24 rows=11 width=0) (actual time=0.007..0.007 rows=3 loops=1)

  • Index Cond: (stchanges.inidlock = 1422)
12. 0.071 5.097 ↓ 7.4 879 1

Append (cost=0.51..541.59 rows=118 width=4) (actual time=0.067..5.097 rows=879 loops=1)

13. 0.006 0.070 ↑ 56.0 2 1

Nested Loop Left Join (cost=0.51..62.38 rows=112 width=4) (actual time=0.067..0.070 rows=2 loops=1)

  • Output: lck_1.inidversion
  • Inner Unique: true
  • Filter: ((c_1.indone = ANY ('{0,2}'::smallint[])) OR (e_1.inid IS NOT NULL))
  • Rows Removed by Filter: 1
14. 0.015 0.052 ↑ 37.3 3 1

Hash Join (cost=0.36..39.53 rows=112 width=6) (actual time=0.048..0.052 rows=3 loops=1)

  • Output: c_1.indone, lck_1.inidversion
  • Hash Cond: (lck_1.state = c_1.inid)
15. 0.010 0.010 ↑ 680.0 3 1

Seq Scan on ora_dbo.stlocks lck_1 (cost=0.00..30.40 rows=2,040 width=8) (actual time=0.009..0.010 rows=3 loops=1)

  • Output: lck_1.inidversion, lck_1.state, lck_1.biisroot
16. 0.011 0.027 ↑ 3.7 3 1

Hash (cost=0.22..0.22 rows=11 width=6) (actual time=0.027..0.027 rows=3 loops=1)

  • Output: c_1.inid, c_1.indone
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
17. 0.016 0.016 ↑ 3.7 3 1

CTE Scan on c c_1 (cost=0.00..0.22 rows=11 width=6) (actual time=0.014..0.016 rows=3 loops=1)

  • Output: c_1.inid, c_1.indone
18. 0.012 0.012 ↓ 0.0 0 3

Index Only Scan using edtversions_pkey on ora_dbo.edtversions e_1 (cost=0.15..0.19 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=3)

  • Output: e_1.inid
  • Index Cond: (e_1.inid = lck_1.inidversion)
  • Heap Fetches: 0
19. 0.000 0.032 ↓ 0.0 0 1

Unique (cost=93.34..93.35 rows=1 width=4) (actual time=0.032..0.032 rows=0 loops=1)

  • Output: a.inidversion
20. 0.012 0.032 ↓ 0.0 0 1

Sort (cost=93.34..93.35 rows=1 width=4) (actual time=0.032..0.032 rows=0 loops=1)

  • Output: a.inidversion
  • Sort Key: a.inidversion
  • Sort Method: quicksort Memory: 25kB
21. 0.003 0.020 ↓ 0.0 0 1

Nested Loop (cost=0.44..93.33 rows=1 width=4) (actual time=0.020..0.020 rows=0 loops=1)

  • Output: a.inidversion
22. 0.002 0.002 ↑ 3.7 3 1

CTE Scan on c c_2 (cost=0.00..0.22 rows=11 width=4) (actual time=0.001..0.002 rows=3 loops=1)

  • Output: c_2.inid, c_2.inidlock, c_2.indone
23. 0.015 0.015 ↓ 0.0 0 3

Index Scan using idx_stattributes_state on ora_dbo.stattributes a (cost=0.44..8.46 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=3)

  • Output: a.inid, a.inidversion, a.inidtypeattr, a.stvalue, a.invalue, a.revalue, a.dtvalue, a.inidunit, a.inidexternal, a.dtmodified, a.state
  • Index Cond: (a.state = c_2.inid)
24. 0.000 0.015 ↓ 0.0 0 1

Unique (cost=9.47..9.48 rows=1 width=4) (actual time=0.015..0.015 rows=0 loops=1)

  • Output: fd.iniddocument
25. 0.009 0.015 ↓ 0.0 0 1

Sort (cost=9.47..9.48 rows=1 width=4) (actual time=0.015..0.015 rows=0 loops=1)

  • Output: fd.iniddocument
  • Sort Key: fd.iniddocument
  • Sort Method: quicksort Memory: 25kB
26. 0.000 0.006 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.42..9.46 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: fd.iniddocument
  • Inner Unique: true
  • Join Filter: (efd.inidfso = fd.inidfso)
  • Filter: ((fd.indone = ANY ('{0,2}'::integer[])) OR (efd.inidfso IS NOT NULL))
27. 0.006 0.006 ↓ 0.0 0 1

Index Scan using idx_stfiledescs_inidlock on ora_dbo.stfiledescs fd (cost=0.42..8.44 rows=1 width=12) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: fd.inidfso, fd.insize, fd.crc, fd.biencrypt, fd.bireadonly, fd.iniddocument, fd.inidlock, fd.indone
  • Index Cond: (fd.inidlock = 1422)
28. 0.000 0.000 ↓ 0.0 0

Seq Scan on ora_dbo.edtfiledescs efd (cost=0.00..1.01 rows=1 width=4) (never executed)

  • Output: efd.inidfso, efd.stname, efd.inidparent, efd.dtdateofcreate, efd.bireadonly
29. 0.128 0.385 ↓ 877.0 877 1

Nested Loop (cost=0.43..93.28 rows=1 width=4) (actual time=0.023..0.385 rows=877 loops=1)

  • Output: l.inidparent
30. 0.002 0.002 ↑ 3.7 3 1

CTE Scan on c c_3 (cost=0.00..0.22 rows=11 width=4) (actual time=0.001..0.002 rows=3 loops=1)

  • Output: c_3.inid, c_3.inidlock, c_3.indone
31. 0.255 0.255 ↓ 292.0 292 3

Index Scan using idx_stlinks_state on ora_dbo.stlinks l (cost=0.43..8.45 rows=1 width=8) (actual time=0.009..0.085 rows=292 loops=3)

  • Output: l.inid, l.inidparent, l.inidchild, l.inidtyperel, l.inmaxquantity, l.inminquantity, l.inidmeasure, l.inidunit, l.dtmodified, l.state
  • Index Cond: (l.state = c_3.inid)
32. 0.069 4.495 ↓ 0.0 0 1

Nested Loop (cost=0.85..93.82 rows=1 width=4) (actual time=4.495..4.495 rows=0 loops=1)

  • Output: l_1.inidchild
  • Inner Unique: true
33. 0.464 2.672 ↓ 877.0 877 1

Nested Loop (cost=0.71..93.58 rows=1 width=8) (actual time=0.038..2.672 rows=877 loops=1)

  • Output: l_1.inidchild, r.inidlinktype
  • Inner Unique: true
34. 0.213 0.454 ↓ 877.0 877 1

Nested Loop (cost=0.43..93.28 rows=1 width=8) (actual time=0.018..0.454 rows=877 loops=1)

  • Output: l_1.inidchild, l_1.inidtyperel
35. 0.001 0.001 ↑ 3.7 3 1

CTE Scan on c c_4 (cost=0.00..0.22 rows=11 width=4) (actual time=0.000..0.001 rows=3 loops=1)

  • Output: c_4.inid, c_4.inidlock, c_4.indone
36. 0.240 0.240 ↓ 292.0 292 3

Index Scan using idx_stlinks_state on ora_dbo.stlinks l_1 (cost=0.43..8.45 rows=1 width=12) (actual time=0.007..0.080 rows=292 loops=3)

  • Output: l_1.inid, l_1.inidparent, l_1.inidchild, l_1.inidtyperel, l_1.inmaxquantity, l_1.inminquantity, l_1.inidmeasure, l_1.inidunit, l_1.dtmodified, l_1.state
  • Index Cond: (l_1.state = c_4.inid)
37. 1.754 1.754 ↑ 1.0 1 877

Index Scan using rltypesandtypes_pkey on ora_dbo.rltypesandtypes r (cost=0.28..0.30 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=877)

  • Output: r.inid, r.inidparent, r.inidchild, r.inidlinktype, r.biquantity, r.inherited, r.inmultlink, r.bitransright
  • Index Cond: (r.inid = l_1.inidtyperel)
38. 1.754 1.754 ↓ 0.0 0 877

Index Scan using dslinktypes_pkey on ora_dbo.dslinktypes t_1 (cost=0.14..0.24 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=877)

  • Output: t_1.inid, t_1.intype, t_1.stname, t_1.stinversename, t_1.inorder, t_1.imicon
  • Index Cond: (t_1.inid = r.inidlinktype)
  • Filter: (t_1.intype = 1)
  • Rows Removed by Filter: 1
39. 0.000 0.016 ↓ 0.0 0 1

Nested Loop (cost=0.87..93.78 rows=1 width=4) (actual time=0.016..0.016 rows=0 loops=1)

  • Output: l_2.inidparent
  • Inner Unique: true
40. 0.000 0.016 ↓ 0.0 0 1

Nested Loop (cost=0.44..93.31 rows=1 width=4) (actual time=0.016..0.016 rows=0 loops=1)

  • Output: a_1.inidlink
41. 0.001 0.001 ↑ 3.7 3 1

CTE Scan on c c_5 (cost=0.00..0.22 rows=11 width=4) (actual time=0.000..0.001 rows=3 loops=1)

  • Output: c_5.inid, c_5.inidlock, c_5.indone
42. 0.015 0.015 ↓ 0.0 0 3

Index Scan using idx_stlinkattributes_state on ora_dbo.stlinkattributes a_1 (cost=0.44..8.45 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=3)

  • Output: a_1.inid, a_1.inidlink, a_1.inidlinkattr, a_1.stvalue, a_1.invalue, a_1.revalue, a_1.dtvalue, a_1.inidunit, a_1.inidexternal, a_1.dtmodified, a_1.state
  • Index Cond: (a_1.state = c_5.inid)
43. 0.000 0.000 ↓ 0.0 0

Index Scan using stlinks_pkey on ora_dbo.stlinks l_2 (cost=0.43..0.47 rows=1 width=8) (never executed)

  • Output: l_2.inid, l_2.inidparent, l_2.inidchild, l_2.inidtyperel, l_2.inmaxquantity, l_2.inminquantity, l_2.inidmeasure, l_2.inidunit, l_2.dtmodified, l_2.state
  • Index Cond: (l_2.inid = a_1.inidlink)
44. 0.000 0.013 ↓ 0.0 0 1

Nested Loop (cost=1.29..94.32 rows=1 width=4) (actual time=0.013..0.013 rows=0 loops=1)

  • Output: l_3.inidchild
  • Inner Unique: true
45. 0.000 0.013 ↓ 0.0 0 1

Nested Loop (cost=1.15..94.07 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=1)

  • Output: l_3.inidchild, r_1.inidlinktype
  • Inner Unique: true
46. 0.000 0.013 ↓ 0.0 0 1

Nested Loop (cost=0.87..93.78 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=1)

  • Output: l_3.inidchild, l_3.inidtyperel
  • Inner Unique: true
47. 0.000 0.013 ↓ 0.0 0 1

Nested Loop (cost=0.44..93.31 rows=1 width=4) (actual time=0.013..0.013 rows=0 loops=1)

  • Output: a_2.inidlink
48. 0.001 0.001 ↑ 3.7 3 1

CTE Scan on c c_6 (cost=0.00..0.22 rows=11 width=4) (actual time=0.000..0.001 rows=3 loops=1)

  • Output: c_6.inid, c_6.inidlock, c_6.indone
49. 0.012 0.012 ↓ 0.0 0 3

Index Scan using idx_stlinkattributes_state on ora_dbo.stlinkattributes a_2 (cost=0.44..8.45 rows=1 width=8) (actual time=0.003..0.004 rows=0 loops=3)

  • Output: a_2.inid, a_2.inidlink, a_2.inidlinkattr, a_2.stvalue, a_2.invalue, a_2.revalue, a_2.dtvalue, a_2.inidunit, a_2.inidexternal, a_2.dtmodified, a_2.state
  • Index Cond: (a_2.state = c_6.inid)
50. 0.000 0.000 ↓ 0.0 0

Index Scan using stlinks_pkey on ora_dbo.stlinks l_3 (cost=0.43..0.47 rows=1 width=12) (never executed)

  • Output: l_3.inid, l_3.inidparent, l_3.inidchild, l_3.inidtyperel, l_3.inmaxquantity, l_3.inminquantity, l_3.inidmeasure, l_3.inidunit, l_3.dtmodified, l_3.state
  • Index Cond: (l_3.inid = a_2.inidlink)
51. 0.000 0.000 ↓ 0.0 0

Index Scan using rltypesandtypes_pkey on ora_dbo.rltypesandtypes r_1 (cost=0.28..0.30 rows=1 width=8) (never executed)

  • Output: r_1.inid, r_1.inidparent, r_1.inidchild, r_1.inidlinktype, r_1.biquantity, r_1.inherited, r_1.inmultlink, r_1.bitransright
  • Index Cond: (r_1.inid = l_3.inidtyperel)
52. 0.000 0.000 ↓ 0.0 0

Index Scan using dslinktypes_pkey on ora_dbo.dslinktypes t_2 (cost=0.14..0.24 rows=1 width=4) (never executed)

  • Output: t_2.inid, t_2.intype, t_2.stname, t_2.stinversename, t_2.inorder, t_2.imicon
  • Index Cond: (t_2.inid = r_1.inidlinktype)
  • Filter: (t_2.intype = 1)
53. 0.007 0.024 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=12) (actual time=0.024..0.024 rows=1 loops=1)

  • Output: s.inidversion, s.iniduser, s.inid
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
54. 0.017 0.017 ↑ 1.0 1 1

Seq Scan on ora_dbo.stsubscribe s (cost=0.00..1.01 rows=1 width=12) (actual time=0.016..0.017 rows=1 loops=1)

  • Output: s.inidversion, s.iniduser, s.inid
55. 0.000 0.000 ↓ 0.0 0

Index Scan using stversions_pkey on ora_dbo.stversions v (cost=0.43..8.45 rows=1 width=10) (never executed)

  • Output: v.inid, v.inidmain, v.inidstate, v.stnumber, v.inidparentversion, v.inowner, v.dtdateofcreate, v.dtmodified, v.birevision, v.inlabel, v.inlevel
  • Index Cond: (v.inid = s.inidversion)
56. 0.000 0.000 ↓ 0.0 0

Index Scan using stmain_pkey on ora_dbo.stmain m (cost=0.43..0.49 rows=1 width=35) (never executed)

  • Output: m.inid, m.inidtype, m.stkeyattr, m.inhash
  • Index Cond: (m.inid = v.inidmain)
57. 0.000 0.000 ↓ 0.0 0

Index Scan using dstypes_pkey on ora_dbo.dstypes t (cost=0.15..0.17 rows=1 width=33) (never executed)

  • Output: t.inid, t.stname, t.stdocpath, t.inidkeyattribute, t.indefaultstate, t.binoversions, t.biabstract, t.bidocument, t.bicanbeproject, t.imicon
  • Index Cond: (t.inid = m.inidtype)
58. 0.000 0.000 ↓ 0.0 0

Seq Scan on ora_dbo.stobjevents e (cost=0.00..1.04 rows=1 width=8) (never executed)

  • Output: e.inid, e.ineventcode, e.indelivtype
  • Filter: (e.ineventcode = 100)
59. 0.000 0.000 ↓ 0.0 0

Index Scan using stlocks_pkey on ora_dbo.stlocks lck (cost=0.15..8.17 rows=1 width=8) (never executed)

  • Output: lck.inidversion, lck.state, lck.biisroot
  • Index Cond: (s.inidversion = lck.inidversion)
60. 0.000 0.000 ↓ 0.0 0

Index Scan using stchanges_pkey on ora_dbo.stchanges c (cost=0.16..0.20 rows=1 width=6) (never executed)

  • Output: c.inid, c.inidlock, c.indone
  • Index Cond: (lck.state = c.inid)
Planning time : 7.620 ms
Execution time : 5.810 ms