explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 14KT

Settings
# exclusive inclusive rows x rows loops node
1. 14.878 1,250.890 ↓ 0.0 0 1

Delete on entitys (cost=445.64..5,972.18 rows=1,406 width=6) (actual time=1,250.890..1,250.890 rows=0 loops=1)

2. 1,156.889 1,236.012 ↓ 2.2 3,085 1

Bitmap Heap Scan on entitys (cost=445.64..5,972.18 rows=1,406 width=6) (actual time=79.628..1,236.012 rows=3,085 loops=1)

  • Recheck Cond: (((agententityid >= 11038) AND (agententityid <= 11039) AND (hostid = 1331665)) OR ((agententityid >= 11064) AND (agententityid <= 11065)))
  • Heap Blocks: exact=1837
3. 0.003 79.123 ↓ 0.0 0 1

BitmapOr (cost=445.64..445.64 rows=1,406 width=0) (actual time=79.123..79.123 rows=0 loops=1)

4. 0.142 57.210 ↓ 0.0 0 1

BitmapAnd (cost=378.66..378.66 rows=1 width=0) (actual time=57.210..57.210 rows=0 loops=1)

5. 24.212 24.212 ↓ 2.4 3,416 1

Bitmap Index Scan on entity_agententityid (cost=0.00..66.62 rows=1,406 width=0) (actual time=24.212..24.212 rows=3,416 loops=1)

  • Index Cond: ((agententityid >= 11038) AND (agententityid <= 11039))
6. 32.856 32.856 ↓ 1.4 16,543 1

Bitmap Index Scan on entity_hostid (cost=0.00..311.08 rows=11,536 width=0) (actual time=32.856..32.856 rows=16,543 loops=1)

  • Index Cond: (hostid = 1331665)
7. 21.910 21.910 ↓ 2.4 3,419 1

Bitmap Index Scan on entity_agententityid (cost=0.00..66.62 rows=1,406 width=0) (actual time=21.910..21.910 rows=3,419 loops=1)

  • Index Cond: ((agententityid >= 11064) AND (agententityid <= 11065))