explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FYZM : slow query

Settings
# exclusive inclusive rows x rows loops node
1. 712.903 44,704.129 ↑ 1.0 1 1

Aggregate (cost=1,753,871.75..1,753,871.76 rows=1 width=8) (actual time=44,704.129..44,704.129 rows=1 loops=1)

2. 10,938.169 43,991.226 ↑ 1.3 5,623,001 1

Hash Anti Join (cost=527,889.06..1,700,286.84 rows=7,144,655 width=8) (actual time=6,339.715..43,991.226 rows=5,623,001 loops=1)

  • Hash Cond: (omo.tid = artistmetadata.tid)
3. 26,716.053 26,716.053 ↓ 1.0 17,539,892 1

Seq Scan on omo (cost=0.00..725,169.24 rows=17,204,099 width=8) (actual time=0.018..26,716.053 rows=17,539,892 loops=1)

  • Filter: (said IS NOT NULL)
  • Rows Removed by Filter: 3058814
4. 2,330.648 6,337.004 ↑ 1.0 11,916,891 1

Hash (cost=332,259.47..332,259.47 rows=11,924,047 width=8) (actual time=6,337.004..6,337.004 rows=11,916,891 loops=1)

  • Buckets: 131072 Batches: 256 Memory Usage: 2839kB
5. 4,006.356 4,006.356 ↑ 1.0 11,916,891 1

Seq Scan on artistmetadata (cost=0.00..332,259.47 rows=11,924,047 width=8) (actual time=0.067..4,006.356 rows=11,916,891 loops=1)