explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ST8V

Settings
# exclusive inclusive rows x rows loops node
1. 284.397 6,001.394 ↑ 1.0 4 1

HashAggregate (cost=3,133,603.04..3,133,603.08 rows=4 width=5) (actual time=6,001.392..6,001.394 rows=4 loops=1)

  • Group Key: modification_history.external_system
2. 1,224.688 5,716.997 ↑ 1.5 850,336 1

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

  • Hash Cond: (modification_history.user_id = users.id)
3. 1,368.897 1,368.897 ↑ 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.013..1,368.897 rows=1,249,849 loops=1)

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

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

  • Buckets: 131072 Batches: 64 Memory Usage: 3241kB
5. 1,820.567 1,820.567 ↓ 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.009..1,820.567 rows=4,010,919 loops=1)

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