explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LSrm

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

GroupAggregate (cost=1.00..641.63 rows=1 width=12) (actual time=0.874..0.874 rows=0 loops=1)

  • Group Key: order_storekeepers.storekeeper_id
2. 0.005 0.874 ↓ 0.0 0 1

Nested Loop (cost=1.00..641.62 rows=1 width=8) (actual time=0.874..0.874 rows=0 loops=1)

3. 0.849 0.849 ↓ 5.0 5 1

Index Scan using order_storekeepers_storekeeper_id_index on order_storekeepers (cost=0.43..638.83 rows=1 width=12) (actual time=0.011..0.849 rows=5 loops=1)

  • Index Cond: (storekeeper_id = 154755)
  • Filter: (is_current AND (created_at > '2019-06-08 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 838
4. 0.020 0.020 ↓ 0.0 0 5

Index Scan using orders_pkey on orders calculated_order (cost=0.56..2.78 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=5)

  • Index Cond: (order_id = order_storekeepers.order_id)
  • Filter: is_active
  • Rows Removed by Filter: 1