explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pwil

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 548.830 ↑ 1.0 1 1

Limit (cost=0.56..50.91 rows=1 width=63) (actual time=548.829..548.830 rows=1 loops=1)

2. 548.828 548.828 ↑ 9,675.0 1 1

Index Scan Backward using shopify_collects_pkey on shopify_collects (cost=0.56..487,123.07 rows=9,675 width=63) (actual time=548.828..548.828 rows=1 loops=1)

  • Filter: (shop_id = 1,081)
  • Rows Removed by Filter: 1,455,120
Planning time : 0.056 ms
Execution time : 548.844 ms