explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 10dC

Settings
# exclusive inclusive rows x rows loops node
1. 254.586 815,569.411 ↑ 1.3 3 1

HashAggregate (cost=5,562,872.97..5,562,873.01 rows=4 width=5) (actual time=815,569.409..815,569.411 rows=3 loops=1)

  • Group Key: modification_history.external_system
2. 1,519.077 815,314.825 ↑ 1.7 747,974 1

Hash Join (cost=276,979.73..5,559,605.80 rows=1,306,868 width=5) (actual time=135,061.632..815,314.825 rows=747,974 loops=1)

  • Hash Cond: (modification_history.user_id = users.id)
3. 809,731.119 810,789.632 ↑ 1.3 1,147,482 1

Bitmap Heap Scan on modification_history (cost=69,962.50..5,299,224.12 rows=1,436,771 width=9) (actual time=132,051.796..810,789.632 rows=1,147,482 loops=1)

  • Recheck Cond: (creation_type IS NOT NULL)
  • Rows Removed by Index Recheck: 12648443
  • Filter: ((external_system IS NOT NULL) AND ((external_system)::text <> 't'::text))
  • Rows Removed by Filter: 3375361
  • Heap Blocks: exact=13201 lossy=1384521
4. 1,058.513 1,058.513 ↓ 1.0 4,522,843 1

Bitmap Index Scan on partial_index_on_user_id_where_creation_type_not_null (cost=0.00..69,603.31 rows=4,358,175 width=0) (actual time=1,058.513..1,058.513 rows=4,522,843 loops=1)

5. 1,295.490 3,006.116 ↓ 1.0 4,010,919 1

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

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

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