explain.depesz.com

PostgreSQL's explain analyze made readable

Result: patS

Settings
# exclusive inclusive rows x rows loops node
1. 213.274 31,754.505 ↓ 1.1 254,563 1

Sort (cost=984,065.00..984,656.66 rows=236,667 width=2) (actual time=31,706.240..31,754.505 rows=254,563 loops=1)

  • Sort Key: a.country
  • Sort Method: quicksort Memory: 18077kB
2. 1,259.353 31,541.231 ↓ 1.1 254,563 1

Hash Join (cost=465,562.28..962,939.51 rows=236,667 width=2) (actual time=17,390.946..31,541.231 rows=254,563 loops=1)

  • Hash Cond: (o.ship_address_id = a.id)
3. 12,915.982 14,005.919 ↓ 1.1 254,563 1

Bitmap Heap Scan on "order" o (cost=6,482.73..443,616.46 rows=236,667 width=8) (actual time=1,113.468..14,005.919 rows=254,563 loops=1)

  • Recheck Cond: (store_id = 15658562)
  • Heap Blocks: exact=101555
4. 1,089.937 1,089.937 ↓ 1.1 257,140 1

Bitmap Index Scan on ix_order_store_id (cost=0.00..6,423.56 rows=236,667 width=0) (actual time=1,089.937..1,089.937 rows=257,140 loops=1)

  • Index Cond: (store_id = 15658562)
5. 4,152.855 16,275.959 ↓ 1.0 10,788,407 1

Hash (cost=273,316.02..273,316.02 rows=10,686,602 width=10) (actual time=16,275.959..16,275.959 rows=10,788,407 loops=1)

  • Buckets: 65536 Batches: 32 Memory Usage: 15876kB
6. 12,123.104 12,123.104 ↓ 1.0 10,788,407 1

Seq Scan on address a (cost=0.00..273,316.02 rows=10,686,602 width=10) (actual time=1.170..12,123.104 rows=10,788,407 loops=1)