explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HTGL : test

Settings
# exclusive inclusive rows x rows loops node
1. 155.603 531.870 ↓ 27,733.5 166,401 1

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

2. 82.000 94.065 ↓ 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=13.960..94.065 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
3. 12.065 12.065 ↓ 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=12.065..12.065 rows=175,193 loops=1)

  • Index Cond: (shop_id = 5)
4. 282.202 282.202 ↑ 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.002 rows=1 loops=141,101)

  • Index Cond: (shopify_order_id = sv.id)
  • Heap Fetches: 15
Planning time : 0.193 ms
Execution time : 564.267 ms