explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1cKG

Settings
# exclusive inclusive rows x rows loops node
1. 430.092 4,376.710 ↓ 1.2 5 1

HashAggregate (cost=3,579,529.51..3,579,529.55 rows=4 width=5) (actual time=4,376.708..4,376.710 rows=5 loops=1)

  • Group Key: external_system
2. 1,459.658 3,946.618 ↑ 1.2 1,249,849 1

Bitmap Heap Scan on modification_history (cost=383,481.21..3,575,931.59 rows=1,439,167 width=5) (actual time=2,491.934..3,946.618 rows=1,249,849 loops=1)

  • Recheck Cond: ((creation_type IS NOT NULL) AND (external_system IS NOT NULL))
  • Rows Removed by Index Recheck: 4896889
  • Heap Blocks: exact=9674 lossy=665302
3. 84.178 2,486.960 ↓ 0.0 0 1

BitmapAnd (cost=383,481.21..383,481.21 rows=1,439,167 width=0) (actual time=2,486.960..2,486.960 rows=0 loops=1)

4. 599.207 599.207 ↓ 1.0 4,522,843 1

Bitmap Index Scan on partial_index_on_user_id_where_creation_type_not_null (cost=0.00..69,579.98 rows=4,356,710 width=0) (actual time=599.207..599.207 rows=4,522,843 loops=1)

5. 1,803.575 1,803.575 ↓ 1.0 17,470,405 1

Bitmap Index Scan on test (cost=0.00..313,181.39 rows=16,957,977 width=0) (actual time=1,803.575..1,803.575 rows=17,470,405 loops=1)

  • Index Cond: (external_system IS NOT NULL)