explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pw8X

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

Delete on instruction (cost=24.61..124.50 rows=25 width=6) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on instruction (cost=24.61..124.50 rows=25 width=6) (actual rows= loops=)

  • Recheck Cond: ((asdu_id)::text = '54265'::text)
  • Filter: (id <> 90127162)
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on asdu_id_time_start_time_end_index (cost=0.00..24.60 rows=25 width=0) (actual rows= loops=)

  • Index Cond: ((asdu_id)::text = '54265'::text)