explain.depesz.com

PostgreSQL's explain analyze made readable

Result: itFu

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

Limit (cost=5,525.32..5,525.60 rows=56 width=4) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Group (cost=5,525.32..5,525.60 rows=56 width=4) (actual rows= loops=)

  • Group Key: backup_slots.id
3. 0.000 0.000 ↓ 0.0

Sort (cost=5,525.32..5,525.46 rows=56 width=4) (actual rows= loops=)

  • Sort Key: backup_slots.id
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4,668.02..5,523.70 rows=56 width=4) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on backup_slots (cost=4,667.46..4,911.59 rows=219 width=8) (actual rows= loops=)

  • Recheck Cond: ((minute_slot = 435) AND (id >= 75428256) AND (id <= 76448256))
6. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=4,667.46..4,667.46 rows=219 width=0) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on index_backup_slots_on_minute_slot_and_service_id (cost=0.00..290.96 rows=21,266 width=0) (actual rows= loops=)

  • Index Cond: (minute_slot = 435)
8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on backup_slots_pkey (cost=0.00..4,376.14 rows=272,558 width=0) (actual rows= loops=)

  • Index Cond: ((id >= 75428256) AND (id <= 76448256))
9. 0.000 0.000 ↓ 0.0

Index Scan using services_pkey on services (cost=0.56..2.79 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = backup_slots.service_id)
  • Filter: (cassandra_backend = 0)