explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Sqhw

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

Aggregate (cost=163,424.86..163,424.87 rows=1 width=32) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..163,407.76 rows=570 width=19) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on order_storekeepers (cost=0.00..161,905.86 rows=570 width=8) (actual rows= loops=)

  • Filter: (is_current AND (storekeeper_id = 1234))
4. 0.000 0.000 ↓ 0.0

Index Scan using orders_copy_pkey on orders (cost=0.43..2.62 rows=1 width=23) (actual rows= loops=)

  • Index Cond: (id = order_storekeepers.order_id)