explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NQhS

Settings
# exclusive inclusive rows x rows loops node
1. 49.811 24,069.512 ↑ 1.0 875,200 1

Gather (cost=1,007.43..551,139.21 rows=882,097 width=73) (actual time=2,642.638..24,069.512 rows=875,200 loops=1)

  • Buffers: shared hit=277 read=365396
2. 34.392 24,019.701 ↑ 1.3 175,040 5

Hash Join (cost=7.43..461,929.51 rows=220,524 width=73) (actual time=2,624.081..24,019.701 rows=175,040 loops=5)

  • Buffers: shared hit=277 read=365396
3. 23,985.247 23,985.247 ↑ 1.3 175,040 5

Seq Scan on acc_accession a (cost=0..461,330.75 rows=220,524 width=63) (actual time=2,623.928..23,985.247 rows=175,040 loops=5)

  • Filter: (a._mgitype_key = 11)
  • Buffers: shared read=365395
4. 0.025 0.062 ↑ 1.0 197 5

Hash (cost=4.97..4.97 rows=197 width=14) (actual time=0.062..0.062 rows=197 loops=5)

  • Buffers: shared hit=14 read=1
5. 0.037 0.037 ↑ 1.0 197 5

Seq Scan on acc_logicaldb l (cost=0..4.97 rows=197 width=14) (actual time=0.01..0.037 rows=197 loops=5)

  • Buffers: shared hit=14 read=1