explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VysD

Settings
# exclusive inclusive rows x rows loops node
1. 437.833 4,390.513 ↓ 1.2 5 1

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

  • Group Key: external_system
2. 1,477.724 3,952.680 ↑ 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,479.869..3,952.680 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.999 2,474.956 ↓ 0.0 0 1

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

4. 586.840 586.840 ↓ 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=586.840..586.840 rows=4,522,843 loops=1)

5. 1,803.117 1,803.117 ↓ 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.117..1,803.117 rows=17,470,405 loops=1)

  • Index Cond: (external_system IS NOT NULL)
Planning time : 0.117 ms