explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FIpb

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

Limit (cost=5.56..911.66 rows=1 width=36) (never executed)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5.56..3,274,661.58 rows=3,614 width=36) (never executed)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5.42..3,274,612.24 rows=3,614 width=40) (never executed)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.86..3,241,719.98 rows=45,952 width=40) (never executed)

5. 0.000 0.000 ↓ 0.0

Index Scan using index_spree_slots_on_start_time on spree_slots spree_slots (cost=0.56..2,303,826.68 rows=31,270,365 width=36) (never executed)

  • Index Cond: (spree_slots.start_time >= '2020-07-24 17:00:00'::timestamp without time zone)
6. 0.000 0.000 ↓ 0.0

Materialize (cost=4.29..12.11 rows=2 width=8) (never executed)

7. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on spree_stock_locations spree_stock_locations (cost=4.29..12.1 rows=2 width=8) (never executed)

8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on index_spree_stock_locations_on_cluster_id (cost=0..4.29 rows=2 width=0) (never executed)

  • Index Cond: (spree_stock_locations.cluster_id = 251)
9. 0.000 0.000 ↓ 0.0

Index Only Scan using index_spree_shipments_on_slot_id on spree_shipments spree_shipments (cost=0.56..0.67 rows=5 width=4) (never executed)

  • Index Cond: (spree_shipments.slot_id = spree_slots.id)
10. 0.000 0.000 ↓ 0.0

Materialize (cost=0.14..4.17 rows=1 width=4) (never executed)

11. 0.000 0.000 ↓ 0.0

Index Only Scan using clusters_pkey on clusters clusters (cost=0.14..4.16 rows=1 width=4) (never executed)

  • Index Cond: (clusters.id = 251)