explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ryHS

Settings
# exclusive inclusive rows x rows loops node
1. 1.189 158.932 ↑ 23.0 3,636 1

GroupAggregate (cost=0.99..350,151.75 rows=83,688 width=12) (actual time=0.197..158.932 rows=3,636 loops=1)

  • Group Key: cc.shopper_id
  • Buffers: shared hit=212,020
2. 32.937 157.743 ↑ 23.1 3,637 1

Nested Loop (cost=0.99..348,895.08 rows=83,958 width=4) (actual time=0.129..157.743 rows=3,637 loops=1)

  • Buffers: shared hit=212,020
3. 20.140 20.140 ↑ 1.7 52,333 1

Index Only Scan using index_club_memberships_on_marco_test_2 on club_memberships cc (cost=0.43..5,044.67 rows=88,893 width=4) (actual time=0.020..20.140 rows=52,333 loops=1)

  • Index Cond: ((enabled = true) AND (warehouse_id = 5) AND (effective_date <= now()) AND (expiration_date >= now()))
  • Filter: enabled
  • Heap Fetches: 240
  • Buffers: shared hit=742
4. 104.666 104.666 ↓ 0.0 0 52,333

Index Only Scan using index_drivers_zones_on_driver_id_and_zone_id on drivers_zones dd (cost=0.56..3.87 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=52,333)

  • Index Cond: ((driver_id = cc.shopper_id) AND (zone_id = 27))
  • Heap Fetches: 50
  • Buffers: shared hit=211,278
Planning time : 0.447 ms
Execution time : 159.182 ms