explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NBsQ

Settings
# exclusive inclusive rows x rows loops node
1. 12.184 966.960 ↓ 3.4 11,979 1

Sort (cost=42,045.39..42,054.29 rows=3,557 width=2) (actual time=964.784..966.960 rows=11,979 loops=1)

  • Sort Key: a.country
  • Sort Method: quicksort Memory: 946kB
2. 17.696 954.776 ↓ 3.4 11,979 1

Nested Loop (cost=1.00..41,835.59 rows=3,557 width=2) (actual time=4.937..954.776 rows=11,979 loops=1)

3. 98.550 98.550 ↓ 3.4 11,979 1

Index Scan using ix_order_store_id on "order" o (cost=0.56..12,513.59 rows=3,557 width=8) (actual time=2.943..98.550 rows=11,979 loops=1)

  • Index Cond: (store_id = 37916992)
4. 838.530 838.530 ↑ 1.0 1 11,979

Index Scan using address_pkey on address a (cost=0.43..8.23 rows=1 width=10) (actual time=0.070..0.070 rows=1 loops=11,979)

  • Index Cond: (id = o.ship_address_id)
Planning time : 11.607 ms
Execution time : 969.229 ms