explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LlZG

Settings
# exclusive inclusive rows x rows loops node
1. 271.652 33,376.062 ↑ 1.0 4 1

HashAggregate (cost=3,133,603.04..3,133,603.08 rows=4 width=5) (actual time=33,376.060..33,376.062 rows=4 loops=1)

  • Group Key: modification_history.external_system
2. 1,128.663 33,104.410 ↑ 1.5 850,336 1

Hash Join (cost=207,017.79..3,130,330.42 rows=1,309,047 width=5) (actual time=3,220.692..33,104.410 rows=850,336 loops=1)

  • Hash Cond: (modification_history.user_id = users.id)
3. 28,755.445 28,755.445 ↑ 1.2 1,249,849 1

Index Scan using test on modification_history (cost=0.56..2,869,884.97 rows=1,439,167 width=9) (actual time=0.021..28,755.445 rows=1,249,849 loops=1)

  • Index Cond: ((external_system IS NOT NULL) AND (creation_type IS NOT NULL))
4. 1,299.847 3,220.302 ↓ 1.0 4,010,919 1

Hash (cost=141,969.73..141,969.73 rows=3,964,760 width=4) (actual time=3,220.302..3,220.302 rows=4,010,919 loops=1)

  • Buckets: 131072 Batches: 64 Memory Usage: 3241kB
5. 1,920.455 1,920.455 ↓ 1.0 4,010,919 1

Seq Scan on users (cost=0.00..141,969.73 rows=3,964,760 width=4) (actual time=0.013..1,920.455 rows=4,010,919 loops=1)

  • Filter: ((NOT deleted) AND ((user_type)::text = 'candidate'::text))
  • Rows Removed by Filter: 347063