explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lwbs

Settings
# exclusive inclusive rows x rows loops node
1. 105.063 22,456.018 ↑ 1.1 875,200 1

Gather (cost=1,007.43..619,496.48 rows=921,252 width=73) (actual time=1,884.054..22,456.018 rows=875,200 loops=1)

  • Buffers: shared hit=143 read=365394
2. 55.704 22,350.955 ↑ 1.3 291,733 3

Hash Join (cost=7.43..526,371.28 rows=383,855 width=73) (actual time=1,833.07..22,350.955 rows=291,733 loops=3)

  • Buffers: shared hit=143 read=365394
3. 22,295.101 22,295.101 ↑ 1.3 291,733 3

Seq Scan on acc_accession a (cost=0..525,334.54 rows=383,855 width=63) (actual time=1,832.656..22,295.101 rows=291,733 loops=3)

  • Filter: (a._mgitype_key = 11)
  • Buffers: shared hit=2 read=365393
4. 0.098 0.150 ↑ 1.0 197 3

Hash (cost=4.97..4.97 rows=197 width=14) (actual time=0.15..0.15 rows=197 loops=3)

  • Buffers: shared hit=8 read=1
5. 0.052 0.052 ↑ 1.0 197 3

Seq Scan on acc_logicaldb l (cost=0..4.97 rows=197 width=14) (actual time=0.016..0.052 rows=197 loops=3)

  • Buffers: shared hit=8 read=1