explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1jUx

Settings
# exclusive inclusive rows x rows loops node
1. 44.188 880.108 ↓ 1.0 64,232 1

Unique (cost=15,564.06..16,992.85 rows=63,502 width=148) (actual time=604.922..880.108 rows=64,232 loops=1)

2. 745.767 835.920 ↓ 1.0 64,269 1

Sort (cost=15,564.06..15,722.81 rows=63,502 width=148) (actual time=604.921..835.920 rows=64,269 loops=1)

  • Sort Key: cc.text, cc.collection_id, cc.init_obj_id, cc.create_time, ('comment'::text), p.name, p.obj_id, p.email
  • Sort Method: external merge Disk: 33048kB
3. 24.568 90.153 ↓ 1.0 64,269 1

Append (cost=5.35..5,720.84 rows=63,502 width=148) (actual time=0.064..90.153 rows=64,269 loops=1)

4. 3.892 5.646 ↓ 1.0 6,323 1

Hash Left Join (cost=5.35..241.27 rows=6,317 width=251) (actual time=0.064..5.646 rows=6,323 loops=1)

  • Hash Cond: (cc.init_obj_id = p.obj_id)
5. 1.702 1.702 ↓ 1.0 6,323 1

Seq Scan on collection_comment cc (cost=0.00..218.17 rows=6,317 width=163) (actual time=0.004..1.702 rows=6,323 loops=1)

6. 0.023 0.052 ↑ 1.0 60 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
7. 0.029 0.029 ↑ 1.0 60 1

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

8. 36.132 59.939 ↓ 1.0 57,946 1

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

  • Hash Cond: (cr.init_obj_id = p_1.obj_id)
9. 23.748 23.748 ↓ 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.004..23.748 rows=57,946 loops=1)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
11. 0.025 0.025 ↑ 1.0 60 1

Seq Scan on person p_1 (cost=0.00..4.60 rows=60 width=56) (actual time=0.002..0.025 rows=60 loops=1)