explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IKQM

Settings
# exclusive inclusive rows x rows loops node
1. 34.112 57.481 ↓ 1.0 57,946 1

Hash Left Join (cost=5.35..4,844.55 rows=57,185 width=551) (actual time=0.073..57.481 rows=57,946 loops=1)

  • Hash Cond: (cr.init_obj_id = p.obj_id)
2. 23.310 23.310 ↓ 1.0 57,946 1

Seq Scan on collection_report cr (cost=0.00..4,678.49 rows=57,185 width=463) (actual time=0.007..23.310 rows=57,946 loops=1)

  • Filter: ((comment IS NOT NULL) AND (comment <> ''::text))
  • Rows Removed by Filter: 71
3. 0.027 0.059 ↑ 1.0 60 1

Hash (cost=4.60..4.60 rows=60 width=56) (actual time=0.058..0.059 rows=60 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
4. 0.032 0.032 ↑ 1.0 60 1

Seq Scan on person p (cost=0.00..4.60 rows=60 width=56) (actual time=0.003..0.032 rows=60 loops=1)