explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zRBl

Settings
# exclusive inclusive rows x rows loops node
1. 52,594.167 119,696.874 ↓ 0.0 0 1

Delete on history_uint (cost=860.43..357,315.86 rows=150,509 width=6) (actual time=119,696.874..119,696.874 rows=0 loops=1)

  • Delete on history_uint_2018_12
  • Delete on history_uint_2019_01
  • Delete on history_uint_2019_02
  • Planning Time: 0.458 ms
  • Execution Time: 119696.951 ms
2. 23,188.574 23,639.245 ↓ 1.1 50,527 1

Bitmap Heap Scan on history_uint_2018_12 (cost=860.43..92,779.08 rows=45,930 width=6) (actual time=464.010..23,639.245 rows=50,527 loops=1)

  • Recheck Cond: (itemid = 624664)
  • Filter: (clock < 1549706829)
  • Heap Blocks: exact=48230
3. 450.671 450.671 ↓ 1.1 50,527 1

Bitmap Index Scan on history_uint_2018_12_itemid_idx (cost=0.00..848.95 rows=45,935 width=0) (actual time=450.671..450.671 rows=50,527 loops=1)

  • Index Cond: (itemid = 624664)
4. 20,277.185 20,403.640 ↑ 1.1 89,248 1

Bitmap Heap Scan on history_uint_2019_01 (cost=1,849.68..197,039.79 rows=98,715 width=6) (actual time=149.464..20,403.640 rows=89,248 loops=1)

  • Recheck Cond: (itemid = 624664)
  • Filter: (clock < 1549706829)
  • Heap Blocks: exact=83340
5. 126.455 126.455 ↑ 1.1 89,248 1

Bitmap Index Scan on history_uint_2019_01_itemid_idx (cost=0.00..1,825.00 rows=98,725 width=0) (actual time=126.455..126.455 rows=89,248 loops=1)

  • Index Cond: (itemid = 624664)
6. 22,952.467 23,059.822 ↓ 4.1 24,222 1

Bitmap Heap Scan on history_uint_2019_02 (cost=399.12..67,497.00 rows=5,864 width=6) (actual time=127.894..23,059.822 rows=24,222 loops=1)

  • Recheck Cond: (itemid = 624664)
  • Filter: (clock < 1549706829)
  • Rows Removed by Filter: 56344
  • Heap Blocks: exact=77388
7. 107.355 107.355 ↓ 3.8 80,566 1

Bitmap Index Scan on history_uint_2019_02_itemid_idx (cost=0.00..397.66 rows=21,479 width=0) (actual time=107.355..107.355 rows=80,566 loops=1)

  • Index Cond: (itemid = 624664)