explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D36x

Settings
# exclusive inclusive rows x rows loops node
1. 15.132 374,499.859 ↑ 2.7 2,121 1

Sort (cost=7,456,288.20..7,456,302.64 rows=5,777 width=64) (actual time=374,498.788..374,499.859 rows=2,121 loops=1)

  • Sort Key: o.docauthorinstitutionname
  • Sort Method: quicksort Memory: 480kB
  • Buffers: shared hit=123124 read=4709902 dirtied=16227 written=260, temp read=641001 written=640939
2. 9,241.596 374,484.727 ↑ 2.7 2,121 1

HashAggregate (cost=7,455,869.48..7,455,927.25 rows=5,777 width=64) (actual time=374,483.217..374,484.727 rows=2,121 loops=1)

  • Group Key: o.docauthorinstitutionname, d.docentrytypecodedisplayname
  • Buffers: shared hit=123121 read=4709902 dirtied=16227 written=260, temp read=641001 written=640939
3. 54,586.018 365,243.131 ↓ 3.0 11,451,724 1

Hash Join (cost=5,039,326.01..7,426,887.44 rows=3,864,272 width=64) (actual time=222,785.926..365,243.131 rows=11,451,724 loops=1)

  • Hash Cond: ((o.docentryentryuuid)::text = (d.docentryentryuuid)::text)
  • Buffers: shared hit=123121 read=4709902 dirtied=16227 written=260, temp read=641001 written=640939
4. 88,602.368 88,602.368 ↓ 1.0 36,580,400 1

Seq Scan on documententryauthorinstitution o (cost=0.00..1,085,683.55 rows=36,571,355 width=79) (actual time=0.685..88,602.368 rows=36,580,400 loops=1)

  • Buffers: shared hit=40091 read=679879 dirtied=399
5. 11,611.463 222,054.745 ↓ 3.0 11,451,724 1

Hash (cost=4,930,642.61..4,930,642.61 rows=3,864,272 width=97) (actual time=222,054.745..222,054.745 rows=11,451,724 loops=1)

  • Buckets: 524288 (originally 524288) Batches: 32 (originally 16) Memory Usage: 61441kB
  • Buffers: shared hit=83030 read=4030023 dirtied=15828 written=260, temp written=156258
6. 210,443.282 210,443.282 ↓ 3.0 11,451,724 1

Seq Scan on documententry d (cost=0.00..4,930,642.61 rows=3,864,272 width=97) (actual time=6.915..210,443.282 rows=11,451,724 loops=1)

  • Filter: (((docentryrepositoryuniqueid)::text = '2.16.858.2.10001442.71867.2'::text) AND (timezone('UTC-3'::text, docentryinternalcreationtime) < ('now'::cstring)::date))
  • Rows Removed by Filter: 24987803
  • Buffers: shared hit=83030 read=4030023 dirtied=15828 written=260
Planning time : 49.126 ms
Execution time : 374,501.482 ms