explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7T9E : test

Settings
# exclusive inclusive rows x rows loops node
1. 87.393 1,552.098 ↓ 28,220.2 141,101 1

Group (cost=3,053.84..3,053.90 rows=5 width=68) (actual time=1,286.664..1,552.098 rows=141,101 loops=1)

  • Group Key: sv.email, sv.number, sv.name
2. 764.734 1,464.705 ↓ 27,733.5 166,401 1

Sort (cost=3,053.84..3,053.85 rows=6 width=68) (actual time=1,286.659..1,464.705 rows=166,401 loops=1)

  • Sort Key: sv.email, sv.number, sv.name
  • Sort Method: external merge Disk: 7584kB
3. 180.099 699.971 ↓ 27,733.5 166,401 1

Nested Loop (cost=59.94..3,053.76 rows=6 width=68) (actual time=15.292..699.971 rows=166,401 loops=1)

4. 83.264 96.569 ↓ 28,220.2 141,101 1

Bitmap Heap Scan on shopify_orders sv (cost=59.52..3,031.39 rows=5 width=76) (actual time=15.277..96.569 rows=141,101 loops=1)

  • Recheck Cond: (shop_id = 5)
  • Filter: ((created_at >= '2018-01-01 18:30:00'::timestamp without time zone) AND (created_at <= '2019-07-18 06:18:05.33'::timestamp without time zone))
  • Rows Removed by Filter: 33261
  • Heap Blocks: exact=13357
5. 13.305 13.305 ↓ 185.2 175,193 1

Bitmap Index Scan on index_shopify_orders_on_shop_id (cost=0.00..59.52 rows=946 width=0) (actual time=13.305..13.305 rows=175,193 loops=1)

  • Index Cond: (shop_id = 5)
6. 423.303 423.303 ↑ 2.0 1 141,101

Index Only Scan using index_shopify_line_items_on_shopify_order_id on shopify_line_items l (cost=0.42..4.45 rows=2 width=8) (actual time=0.002..0.003 rows=1 loops=141,101)

  • Index Cond: (shopify_order_id = sv.id)
  • Heap Fetches: 15
Planning time : 0.229 ms
Execution time : 1,580.008 ms