explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TWMR

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

HashAggregate (cost=5,562,872.97..5,562,873.01 rows=4 width=5) (actual rows= loops=)

  • Group Key: modification_history.external_system
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=276,979.73..5,559,605.80 rows=1,306,868 width=5) (actual rows= loops=)

  • Hash Cond: (modification_history.user_id = users.id)
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on modification_history (cost=69,962.50..5,299,224.12 rows=1,436,771 width=9) (actual rows= loops=)

  • Recheck Cond: (creation_type IS NOT NULL)
  • Filter: ((external_system IS NOT NULL) AND ((external_system)::text <> 't'::text))
4. 0.000 0.000 ↓ 0.0

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 rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=141,969.73..141,969.73 rows=3,964,760 width=4) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on users (cost=0.00..141,969.73 rows=3,964,760 width=4) (actual rows= loops=)