explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v9Nt

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

Limit (cost=393.91..393.92 rows=1 width=4) (actual time=6.513..6.513 rows=0 loops=1)

2. 0.000 6.513 ↓ 0.0 0 1

Group (cost=393.91..393.92 rows=1 width=4) (actual time=6.513..6.513 rows=0 loops=1)

  • Group Key: backup_slots.id
3. 0.008 6.513 ↓ 0.0 0 1

Sort (cost=393.91..393.92 rows=1 width=4) (actual time=6.513..6.513 rows=0 loops=1)

  • Sort Key: backup_slots.id
  • Sort Method: quicksort Memory: 25kB
4. 0.004 6.505 ↓ 0.0 0 1

Nested Loop (cost=378.82..393.90 rows=1 width=4) (actual time=6.505..6.505 rows=0 loops=1)

5. 0.078 6.325 ↓ 4.0 16 1

Bitmap Heap Scan on backup_slots (cost=378.25..382.72 rows=4 width=8) (actual time=6.293..6.325 rows=16 loops=1)

  • Recheck Cond: ((id >= 75428256) AND (id <= 75448256) AND (minute_slot = 435))
  • Heap Blocks: exact=21
6. 0.944 6.247 ↓ 0.0 0 1

BitmapAnd (cost=378.25..378.25 rows=4 width=0) (actual time=6.247..6.247 rows=0 loops=1)

7. 1.602 1.602 ↓ 1.6 8,539 1

Bitmap Index Scan on backup_slots_pkey (cost=0.00..87.04 rows=5,348 width=0) (actual time=1.602..1.602 rows=8,539 loops=1)

  • Index Cond: ((id >= 75428256) AND (id <= 75448256))
8. 3.701 3.701 ↓ 1.3 27,051 1

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

  • Index Cond: (minute_slot = 435)
9. 0.176 0.176 ↓ 0.0 0 16

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

  • Index Cond: (id = backup_slots.service_id)
  • Filter: (cassandra_backend = 0)
  • Rows Removed by Filter: 1
Planning time : 0.445 ms
Execution time : 6.592 ms