explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vl7l

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

Limit (cost=394.61..394.61 rows=1 width=8) (actual time=7.679..7.679 rows=0 loops=1)

2. 0.000 7.679 ↓ 0.0 0 1

Unique (cost=394.61..394.61 rows=1 width=8) (actual time=7.679..7.679 rows=0 loops=1)

3. 0.005 7.679 ↓ 0.0 0 1

Sort (cost=394.61..394.61 rows=1 width=8) (actual time=7.679..7.679 rows=0 loops=1)

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

Nested Loop Left Join (cost=379.38..394.60 rows=1 width=8) (actual time=7.674..7.674 rows=0 loops=1)

5. 0.011 7.674 ↓ 0.0 0 1

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

6. 0.108 7.519 ↓ 4.0 16 1

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

  • Recheck Cond: ((id >= 75428256) AND (id <= 75448256) AND (minute_slot = 435))
  • Heap Blocks: exact=20
7. 1.177 7.411 ↓ 0.0 0 1

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

8. 2.077 2.077 ↓ 1.8 9,521 1

Bitmap Index Scan on backup_slots_pkey (cost=0.00..87.04 rows=5,348 width=0) (actual time=2.077..2.077 rows=9,521 loops=1)

  • Index Cond: ((id >= 75428256) AND (id <= 75448256))
9. 4.157 4.157 ↓ 1.3 26,659 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=4.157..4.157 rows=26,659 loops=1)

  • Index Cond: (minute_slot = 435)
10. 0.144 0.144 ↓ 0.0 0 16

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

  • Index Cond: (id = backup_slots.service_id)
  • Filter: (cassandra_backend = 0)
  • Rows Removed by Filter: 1
11. 0.000 0.000 ↓ 0.0 0

Index Only Scan using index_backup_slots_on_service_id on backup_slots backup_slots_services (cost=0.56..0.66 rows=3 width=4) (never executed)

  • Index Cond: (service_id = services.id)
  • Heap Fetches: 0