explain.depesz.com

PostgreSQL's explain analyze made readable

Result: K1Il

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.021 ↓ 0.0 0 1

Delete on pojazd_miejsca_aktywnosc (cost=24,896.59..82,121.61 rows=1,175,762 width=6) (actual time=0.021..0.021 rows=0 loops=1)

2. 0.003 0.019 ↓ 0.0 0 1

Bitmap Heap Scan on pojazd_miejsca_aktywnosc (cost=24,896.59..82,121.61 rows=1,175,762 width=6) (actual time=0.019..0.019 rows=0 loops=1)

  • Recheck Cond: (data_wjazdu >= '2019-07-20 00:00:00'::timestamp without time zone)
3. 0.016 0.016 ↓ 0.0 0 1

Bitmap Index Scan on pojazd_miejsca_aktywnosc_data_wjazdu (cost=0.00..24,602.65 rows=1,175,762 width=0) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (data_wjazdu >= '2019-07-20 00:00:00'::timestamp without time zone)
Planning time : 0.141 ms
Execution time : 0.068 ms