explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1W8M

Settings
# exclusive inclusive rows x rows loops node
1. 1.990 39,892.151 ↑ 1.0 900 1

Unique (cost=9,666.1..9,668.62 rows=918 width=622) (actual time=39,890.073..39,892.151 rows=900 loops=1)

  • Buffers: shared hit=18175 dirtied=4
2. 17.707 39,890.161 ↓ 1.0 923 1

Sort (cost=9,666.1..9,666.33 rows=918 width=622) (actual time=39,890.069..39,890.161 rows=923 loops=1)

  • Sort Key: t7._owneridrref, t6._fld4557, t6._fld5639, ((t14._fld4934)::mvarchar(1000)), t8._fld669rref, t13._number, t13._date_time, t8._description, t15._description, t15._code
  • Sort Method: quicksort Memory: 970kB
  • Buffers: shared hit=18175 dirtied=4
3. 6.733 39,872.454 ↓ 1.0 923 1

Hash Join (cost=5,450.14..9,661.58 rows=918 width=622) (actual time=592.668..39,872.454 rows=923 loops=1)

  • Buffers: shared hit=18161 dirtied=4
4. 5.355 39,865.688 ↓ 1.0 923 1

Nested Loop (cost=5,449.54..9,660.2 rows=918 width=466) (actual time=592.597..39,865.688 rows=923 loops=1)

  • Buffers: shared hit=18160 dirtied=4
5. 1.346 39,846.488 ↓ 1.0 923 1

Nested Loop (cost=5,449.51..9,537.88 rows=918 width=282) (actual time=592.537..39,846.488 rows=923 loops=1)

  • Buffers: shared hit=15391 dirtied=4
6. 0.095 0.095 ↑ 1.0 1 1

Index Scan using _document144ng_pkey on _document144 t13 (cost=0.03..0.84 rows=1 width=28) (actual time=0.079..0.095 rows=1 loops=1)

  • Index Cond: (t13._idrref = '\\200\\322\\000PV\\273\\033}\\021\\351\\242\\016\\263*/\\\\'::bytea)
  • Buffers: shared hit=3
7. 5.669 39,845.047 ↓ 1.0 923 1

Hash Join (cost=5,449.48..9,527.85 rows=918 width=271) (actual time=592.449..39,845.047 rows=923 loops=1)

  • Buffers: shared hit=15388 dirtied=4
8. 16.406 39,835.982 ↓ 1.0 923 1

Nested Loop (cost=5,377.31..9,455.32 rows=918 width=271) (actual time=589.029..39,835.982 rows=923 loops=1)

  • Buffers: shared hit=15296 dirtied=4
9. 13.660 39,808.500 ↓ 1.0 923 1

Nested Loop (cost=5,377.28..9,396.96 rows=918 width=68) (actual time=588.987..39,808.5 rows=923 loops=1)

  • Buffers: shared hit=12527 dirtied=4
10. 26,530.490 39,768.996 ↓ 1.0 923 1

Nested Loop (cost=5,377.26..9,316.23 rows=918 width=66) (actual time=588.87..39,768.996 rows=923 loops=1)

  • Buffers: shared hit=9758 dirtied=4
11. 12.296 55.297 ↓ 1.0 923 1

Nested Loop (cost=0.08..821.39 rows=918 width=51) (actual time=0.362..55.297 rows=923 loops=1)

  • Buffers: shared hit=4192
12. 14.388 14.388 ↓ 1.0 923 1

Index Scan using _inforg3727_2 on _inforg3727 t1 (cost=0.04..164.84 rows=918 width=51) (actual time=0.179..14.388 rows=923 loops=1)

  • Index Cond: ((t1._recordertref = '\\000\\000\\000\\220'::bytea) AND (t1._recorderrref = '\\200\\322\\000PV\\273\\033}\\021\\351\\242\\016\\263*/\\\\'::bytea))
  • Filter: t1._fld5335
  • Buffers: shared hit=495
13. 28.613 28.613 ↑ 1.0 1 923

Index Scan using _reference46_pkey on _reference46 t2 (cost=0.04..0.72 rows=1 width=36) (actual time=0.031..0.031 rows=1 loops=923)

  • Index Cond: (t1._fld3729rref = t2._idrref)
  • Buffers: shared hit=3697
14. 12,600.534 13,183.209 ↓ 149,258.0 149,258 923

Materialize (cost=5,377.17..8,485.19 rows=1 width=49) (actual time=0.392..14.283 rows=149,258 loops=923)

  • Buffers: shared hit=5566 dirtied=4
15. 155.028 582.675 ↓ 149,258.0 149,258 1

Hash Join (cost=5,377.17..8,485.19 rows=1 width=49) (actual time=360.793..582.675 rows=149,258 loops=1)

  • Buffers: shared hit=5566 dirtied=4
16. 182.951 213.695 ↑ 1.0 149,258 1

Aggregate (cost=1,923.42..3,418.56 rows=149,514 width=42) (actual time=144.8..213.695 rows=149,258 loops=1)

  • Buffers: shared hit=2783
17. 30.744 30.744 ↑ 1.0 152,741 1

Seq Scan on _inforg4555 t5 (cost=0..1,808.64 rows=153,034 width=42) (actual time=0.016..30.744 rows=152,741 loops=1)

  • Buffers: shared hit=2783
18. 137.593 213.952 ↑ 1.0 152,741 1

Hash (cost=1,808.64..1,808.64 rows=153,034 width=74) (actual time=213.952..213.952 rows=152,741 loops=1)

  • Buffers: shared hit=2783 dirtied=4
19. 76.359 76.359 ↑ 1.0 152,741 1

Seq Scan on _inforg4555 t6 (cost=0..1,808.64 rows=153,034 width=74) (actual time=0.033..76.359 rows=152,741 loops=1)

  • Buffers: shared hit=2783 dirtied=4
20. 25.844 25.844 ↑ 1.0 1 923

Index Scan using _reference4464_pkey on _reference4464 t7 (cost=0.03..0.09 rows=1 width=38) (actual time=0.028..0.028 rows=1 loops=923)

  • Index Cond: (t1._fld4539rref = t7._idrref)
  • Buffers: shared hit=2769
21. 11.076 11.076 ↑ 1.0 1 923

Index Scan using _reference45_pkey on _reference45 t8 (cost=0.03..0.06 rows=1 width=222) (actual time=0.012..0.012 rows=1 loops=923)

  • Index Cond: (t7._owneridrref = t8._idrref)
  • Buffers: shared hit=2769
22. 0.151 3.396 ↓ 396.0 396 1

Hash (cost=72.16..72.16 rows=1 width=34) (actual time=3.396..3.396 rows=396 loops=1)

  • Buffers: shared hit=92
23. 0.670 3.245 ↓ 396.0 396 1

Hash Join (cost=42.09..72.16 rows=1 width=34) (actual time=2.289..3.245 rows=396 loops=1)

  • Buffers: shared hit=92
24. 0.342 0.342 ↑ 1.0 2,420 1

Seq Scan on _inforg4774 t12 (cost=0..28.8 rows=2,420 width=42) (actual time=0.041..0.342 rows=2,420 loops=1)

  • Buffers: shared hit=46
25. 0.136 2.233 ↑ 1.0 396 1

Hash (cost=37.93..37.93 rows=396 width=25) (actual time=2.233..2.233 rows=396 loops=1)

  • Buffers: shared hit=46
26. 1.192 2.097 ↑ 1.0 396 1

Aggregate (cost=30.01..33.97 rows=396 width=25) (actual time=2.004..2.097 rows=396 loops=1)

  • Buffers: shared hit=46
27. 0.905 0.905 ↑ 1.0 2,420 1

Seq Scan on _inforg4774 t11 (cost=0..28.8 rows=2,420 width=25) (actual time=0.008..0.905 rows=2,420 loops=1)

  • Buffers: shared hit=46
28. 13.845 13.845 ↑ 1.0 1 923

Index Scan using _reference4593_pkey on _reference4593 t14 (cost=0.03..0.13 rows=1 width=218) (actual time=0.015..0.015 rows=1 loops=923)

  • Index Cond: (t12._fld4776rref = t14._idrref)
  • Buffers: shared hit=2769
29. 0.016 0.033 ↑ 1.0 25 1

Hash (cost=0.35..0.35 rows=25 width=78) (actual time=0.033..0.033 rows=25 loops=1)

  • Buffers: shared hit=1
30. 0.017 0.017 ↑ 1.0 25 1

Seq Scan on _reference114 t15 (cost=0..0.35 rows=25 width=78) (actual time=0.011..0.017 rows=25 loops=1)

  • Buffers: shared hit=1