explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nf22

Settings
# exclusive inclusive rows x rows loops node
1. 0.027 6.403 ↓ 0.0 0 1

Hash Join (cost=81,180.67..87,040.01 rows=1,230 width=114) (actual time=6.403..6.403 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
  • Hash Cond: (lck_1.inidversion = s.inidversion)
2. 2.973 6.146 ↑ 81,977.3 3 1

HashAggregate (cost=81,161.12..83,620.44 rows=245,932 width=4) (actual time=3.500..6.146 rows=3 loops=1)

  • Output: lck_1.inidversion
  • Group Key: lck_1.inidversion
3. 0.067 3.173 ↑ 279.8 879 1

Append (cost=15.20..80,546.29 rows=245,932 width=4) (actual time=0.092..3.173 rows=879 loops=1)

4. 0.013 0.095 ↑ 5.0 2 1

Nested Loop Left Join (cost=15.20..52.93 rows=10 width=4) (actual time=0.091..0.095 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) AND ((e_1.inid)::text <> ''::text)))
  • Rows Removed by Filter: 1
5. 0.021 0.067 ↑ 3.3 3 1

Hash Join (cost=15.05..50.82 rows=10 width=6) (actual time=0.064..0.067 rows=3 loops=1)

  • Output: c_1.indone, lck_1.inidversion
  • Inner Unique: true
  • Hash Cond: (lck_1.state = c_1.inid)
6. 0.022 0.022 ↑ 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.021..0.022 rows=3 loops=1)

  • Output: lck_1.inidversion, lck_1.state, lck_1.biisroot
7. 0.009 0.024 ↑ 3.7 3 1

Hash (cost=14.91..14.91 rows=11 width=6) (actual time=0.024..0.024 rows=3 loops=1)

  • Output: c_1.inid, c_1.indone
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.007 0.015 ↑ 3.7 3 1

Bitmap Heap Scan on ora_dbo.stchanges c_1 (cost=4.24..14.91 rows=11 width=6) (actual time=0.014..0.015 rows=3 loops=1)

  • Output: c_1.inid, c_1.indone
  • Recheck Cond: (c_1.inidlock = 1422)
  • Heap Blocks: exact=1
9. 0.008 0.008 ↑ 3.7 3 1

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

  • Index Cond: (c_1.inidlock = 1422)
10. 0.015 0.015 ↓ 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.005..0.005 rows=0 loops=3)

  • Output: e_1.inid
  • Index Cond: (e_1.inid = lck_1.inidversion)
  • Heap Fetches: 0
11. 0.688 0.730 ↓ 0.0 0 1

HashAggregate (cost=351.66..1,326.19 rows=97,453 width=4) (actual time=0.730..0.730 rows=0 loops=1)

  • Output: a.inidversion
  • Group Key: a.inidversion
12. 0.004 0.042 ↓ 0.0 0 1

Nested Loop (cost=4.68..108.03 rows=97,453 width=4) (actual time=0.042..0.042 rows=0 loops=1)

  • Output: a.inidversion
13. 0.002 0.005 ↑ 3.7 3 1

Bitmap Heap Scan on ora_dbo.stchanges c_2 (cost=4.24..14.91 rows=11 width=4) (actual time=0.005..0.005 rows=3 loops=1)

  • Output: c_2.inid, c_2.inidlock, c_2.indone
  • Recheck Cond: (c_2.inidlock = 1422)
  • Heap Blocks: exact=1
14. 0.003 0.003 ↑ 3.7 3 1

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

  • Index Cond: (c_2.inidlock = 1422)
15. 0.033 0.033 ↓ 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.011..0.011 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)
16. 0.000 0.072 ↓ 0.0 0 1

Unique (cost=9.48..9.49 rows=1 width=4) (actual time=0.072..0.072 rows=0 loops=1)

  • Output: fd.iniddocument
17. 0.054 0.072 ↓ 0.0 0 1

Sort (cost=9.48..9.49 rows=1 width=4) (actual time=0.071..0.072 rows=0 loops=1)

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

Nested Loop Left Join (cost=0.42..9.47 rows=1 width=4) (actual time=0.018..0.018 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) AND ((efd.inidfso)::text <> ''::text)))
19. 0.018 0.018 ↓ 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.017..0.018 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)
20. 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
21. 0.127 0.456 ↑ 42.4 877 1

Nested Loop (cost=4.67..107.97 rows=37,211 width=4) (actual time=0.054..0.456 rows=877 loops=1)

  • Output: l.inidparent
22. 0.003 0.005 ↑ 3.7 3 1

Bitmap Heap Scan on ora_dbo.stchanges c_3 (cost=4.24..14.91 rows=11 width=4) (actual time=0.005..0.005 rows=3 loops=1)

  • Output: c_3.inid, c_3.inidlock, c_3.indone
  • Recheck Cond: (c_3.inidlock = 1422)
  • Heap Blocks: exact=1
23. 0.002 0.002 ↑ 3.7 3 1

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

  • Index Cond: (c_3.inidlock = 1422)
24. 0.324 0.324 ↓ 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.017..0.108 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)
25. 0.113 1.673 ↓ 0.0 0 1

Hash Join (cost=60.34..362.92 rows=9,944 width=4) (actual time=1.672..1.673 rows=0 loops=1)

  • Output: l_1.inidchild
  • Inner Unique: true
  • Hash Cond: (r.inidlinktype = t_1.inid)
26. 0.375 1.425 ↑ 42.4 877 1

Hash Join (cost=39.50..240.84 rows=37,211 width=8) (actual time=0.627..1.425 rows=877 loops=1)

  • Output: l_1.inidchild, r.inidlinktype
  • Inner Unique: true
  • Hash Cond: (l_1.inidtyperel = r.inid)
27. 0.213 0.474 ↑ 42.4 877 1

Nested Loop (cost=4.67..107.97 rows=37,211 width=8) (actual time=0.034..0.474 rows=877 loops=1)

  • Output: l_1.inidchild, l_1.inidtyperel
28. 0.003 0.009 ↑ 3.7 3 1

Bitmap Heap Scan on ora_dbo.stchanges c_4 (cost=4.24..14.91 rows=11 width=4) (actual time=0.008..0.009 rows=3 loops=1)

  • Output: c_4.inid, c_4.inidlock, c_4.indone
  • Recheck Cond: (c_4.inidlock = 1422)
  • Heap Blocks: exact=1
29. 0.006 0.006 ↑ 3.7 3 1

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

  • Index Cond: (c_4.inidlock = 1422)
30. 0.252 0.252 ↓ 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.010..0.084 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)
31. 0.269 0.576 ↑ 1.0 1,148 1

Hash (cost=20.48..20.48 rows=1,148 width=8) (actual time=0.576..0.576 rows=1,148 loops=1)

  • Output: r.inid, r.inidlinktype
  • Buckets: 2048 Batches: 1 Memory Usage: 61kB
32. 0.307 0.307 ↑ 1.0 1,148 1

Seq Scan on ora_dbo.rltypesandtypes r (cost=0.00..20.48 rows=1,148 width=8) (actual time=0.019..0.307 rows=1,148 loops=1)

  • Output: r.inid, r.inidlinktype
33. 0.015 0.135 ↑ 1.0 31 1

Hash (cost=20.45..20.45 rows=31 width=4) (actual time=0.135..0.135 rows=31 loops=1)

  • Output: t_1.inid
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
34. 0.120 0.120 ↑ 1.0 31 1

Seq Scan on ora_dbo.dslinktypes t_1 (cost=0.00..20.45 rows=31 width=4) (actual time=0.031..0.120 rows=31 loops=1)

  • Output: t_1.inid
  • Filter: (t_1.intype = 1)
  • Rows Removed by Filter: 85
35. 0.000 0.032 ↓ 0.0 0 1

Nested Loop (cost=5.11..37,832.79 rows=79,948 width=4) (actual time=0.032..0.032 rows=0 loops=1)

  • Output: l_2.inidparent
  • Inner Unique: true
36. 0.003 0.032 ↓ 0.0 0 1

Nested Loop (cost=4.68..108.00 rows=79,948 width=4) (actual time=0.032..0.032 rows=0 loops=1)

  • Output: a_1.inidlink
37. 0.003 0.005 ↑ 3.7 3 1

Bitmap Heap Scan on ora_dbo.stchanges c_5 (cost=4.24..14.91 rows=11 width=4) (actual time=0.004..0.005 rows=3 loops=1)

  • Output: c_5.inid, c_5.inidlock, c_5.indone
  • Recheck Cond: (c_5.inidlock = 1422)
  • Heap Blocks: exact=1
38. 0.002 0.002 ↑ 3.7 3 1

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

  • Index Cond: (c_5.inidlock = 1422)
39. 0.024 0.024 ↓ 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.008..0.008 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)
40. 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)
41. 0.001 0.048 ↓ 0.0 0 1

Hash Join (cost=53.39..38,394.68 rows=21,365 width=4) (actual time=0.048..0.048 rows=0 loops=1)

  • Output: l_3.inidchild
  • Hash Cond: (l_3.inidtyperel = r_1.inid)
42. 0.000 0.047 ↓ 0.0 0 1

Nested Loop (cost=5.11..37,832.79 rows=79,948 width=8) (actual time=0.047..0.047 rows=0 loops=1)

  • Output: l_3.inidchild, l_3.inidtyperel
  • Inner Unique: true
43. 0.004 0.047 ↓ 0.0 0 1

Nested Loop (cost=4.68..108.00 rows=79,948 width=4) (actual time=0.047..0.047 rows=0 loops=1)

  • Output: a_2.inidlink
44. 0.002 0.004 ↑ 3.7 3 1

Bitmap Heap Scan on ora_dbo.stchanges c_6 (cost=4.24..14.91 rows=11 width=4) (actual time=0.003..0.004 rows=3 loops=1)

  • Output: c_6.inid, c_6.inidlock, c_6.indone
  • Recheck Cond: (c_6.inidlock = 1422)
  • Heap Blocks: exact=1
45. 0.002 0.002 ↑ 3.7 3 1

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

  • Index Cond: (c_6.inidlock = 1422)
46. 0.039 0.039 ↓ 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.013..0.013 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)
47. 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)
48. 0.000 0.000 ↓ 0.0 0

Hash (cost=44.44..44.44 rows=307 width=4) (never executed)

  • Output: r_1.inid
49. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=20.84..44.44 rows=307 width=4) (never executed)

  • Output: r_1.inid
  • Inner Unique: true
  • Hash Cond: (r_1.inidlinktype = t_2.inid)
50. 0.000 0.000 ↓ 0.0 0

Seq Scan on ora_dbo.rltypesandtypes r_1 (cost=0.00..20.48 rows=1,148 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
51. 0.000 0.000 ↓ 0.0 0

Hash (cost=20.45..20.45 rows=31 width=4) (never executed)

  • Output: t_2.inid
52. 0.000 0.000 ↓ 0.0 0

Seq Scan on ora_dbo.dslinktypes t_2 (cost=0.00..20.45 rows=31 width=4) (never executed)

  • Output: t_2.inid
  • Filter: (t_2.intype = 1)
53. 0.009 0.230 ↑ 1.0 1 1

Hash (cost=19.54..19.54 rows=1 width=76) (actual time=0.230..0.230 rows=1 loops=1)

  • Output: s.inidversion, s.iniduser, v.stnumber, v.inid, m.stkeyattr, t.stname, e.indelivtype, c.indone
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
54. 0.002 0.221 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.32..19.54 rows=1 width=76) (actual time=0.218..0.221 rows=1 loops=1)

  • Output: s.inidversion, s.iniduser, v.stnumber, v.inid, m.stkeyattr, t.stname, e.indelivtype, c.indone
  • Inner Unique: true
55. 0.002 0.210 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.16..19.34 rows=1 width=78) (actual time=0.207..0.210 rows=1 loops=1)

  • Output: s.inidversion, s.iniduser, v.stnumber, v.inid, m.stkeyattr, t.stname, e.indelivtype, lck.state
  • Inner Unique: true
56. 0.001 0.194 ↑ 1.0 1 1

Nested Loop (cost=1.01..11.17 rows=1 width=74) (actual time=0.192..0.194 rows=1 loops=1)

  • Output: s.inidversion, s.iniduser, v.stnumber, v.inid, m.stkeyattr, t.stname, e.indelivtype
  • Join Filter: (s.inid = e.inid)
57. 0.001 0.173 ↑ 1.0 1 1

Nested Loop (cost=1.01..10.12 rows=1 width=74) (actual time=0.172..0.173 rows=1 loops=1)

  • Output: s.inidversion, s.iniduser, s.inid, v.stnumber, v.inid, m.stkeyattr, t.stname
  • Inner Unique: true
58. 0.003 0.153 ↑ 1.0 1 1

Nested Loop (cost=0.86..9.95 rows=1 width=49) (actual time=0.152..0.153 rows=1 loops=1)

  • Output: s.inidversion, s.iniduser, s.inid, v.stnumber, v.inid, m.stkeyattr, m.inidtype
  • Inner Unique: true
59. 0.006 0.126 ↑ 1.0 1 1

Nested Loop (cost=0.43..9.46 rows=1 width=22) (actual time=0.125..0.126 rows=1 loops=1)

  • Output: s.inidversion, s.iniduser, s.inid, v.stnumber, v.inid, v.inidmain
  • Inner Unique: true
60. 0.037 0.037 ↑ 1.0 1 1

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

  • Output: s.inid, s.inidversion, s.iniduser
61. 0.083 0.083 ↑ 1.0 1 1

Index Scan using stversions_pkey on ora_dbo.stversions v (cost=0.43..8.45 rows=1 width=10) (actual time=0.083..0.083 rows=1 loops=1)

  • 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)
62. 0.024 0.024 ↑ 1.0 1 1

Index Scan using stmain_pkey on ora_dbo.stmain m (cost=0.43..0.49 rows=1 width=35) (actual time=0.024..0.024 rows=1 loops=1)

  • Output: m.inid, m.inidtype, m.stkeyattr, m.inhash
  • Index Cond: (m.inid = v.inidmain)
63. 0.019 0.019 ↑ 1.0 1 1

Index Scan using dstypes_pkey on ora_dbo.dstypes t (cost=0.15..0.17 rows=1 width=33) (actual time=0.019..0.019 rows=1 loops=1)

  • 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)
64. 0.020 0.020 ↑ 1.0 1 1

Seq Scan on ora_dbo.stobjevents e (cost=0.00..1.04 rows=1 width=8) (actual time=0.018..0.020 rows=1 loops=1)

  • Output: e.inid, e.ineventcode, e.indelivtype
  • Filter: (e.ineventcode = 100)
  • Rows Removed by Filter: 2
65. 0.014 0.014 ↓ 0.0 0 1

Index Scan using stlocks_pkey on ora_dbo.stlocks lck (cost=0.15..8.17 rows=1 width=8) (actual time=0.014..0.014 rows=0 loops=1)

  • Output: lck.inidversion, lck.state, lck.biisroot
  • Index Cond: (s.inidversion = lck.inidversion)
66. 0.009 0.009 ↓ 0.0 0 1

Index Scan using stchanges_pkey on ora_dbo.stchanges c (cost=0.16..0.20 rows=1 width=6) (actual time=0.009..0.009 rows=0 loops=1)

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