explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qmKM

Settings
# exclusive inclusive rows x rows loops node
1. 89.134 559.418 ↑ 4.3 126,950 1

Hash Join (cost=242.16..94,399.81 rows=546,542 width=36) (actual time=2.698..559.418 rows=126,950 loops=1)

  • Hash Cond: (f.mlayer = vsxlayers.mid)
2. 467.977 467.977 ↑ 1.0 546,542 1

Seq Scan on vsxfeature f (cost=0.00..88,524.42 rows=546,542 width=52) (actual time=0.076..467.977 rows=546,542 loops=1)

3. 0.516 2.307 ↑ 1.0 3,110 1

Hash (cost=203.29..203.29 rows=3,110 width=16) (actual time=2.307..2.307 rows=3,110 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 178kB
4. 1.791 1.791 ↑ 1.0 3,110 1

Seq Scan on vsxlayers (cost=0.00..203.29 rows=3,110 width=16) (actual time=0.048..1.791 rows=3,110 loops=1)

  • Filter: (mowner = '79610a40-aeaa-4bff-a9d6-5444a5aa94c9'::uuid)
  • Rows Removed by Filter: 1633