explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v39 : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=71,203.95..71,204.05 rows=1 width=32) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Group (cost=71,183.14..71,203.95 rows=200 width=32) (actual rows= loops=)

  • Group Key: sv.name
3. 0.000 0.000 ↓ 0.0

Sort (cost=71,183.14..71,193.54 rows=4,162 width=32) (actual rows= loops=)

  • Sort Key: sv.name
4. 0.000 0.000 ↓ 0.0

Subquery Scan on sv (cost=10,015.15..70,932.94 rows=4,162 width=32) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Append (cost=10,015.15..70,891.32 rows=4,162 width=1,223) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Result (cost=10,015.15..70,890.29 rows=4,161 width=1,223) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Append (cost=10,015.15..70,827.87 rows=4,161 width=1,215) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Result (cost=10,015.15..70,827.87 rows=4,160 width=1,215) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Append (cost=10,015.15..70,775.87 rows=4,160 width=1,211) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1 (cost=10,015.15..70,775.87 rows=4,159 width=968) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=10,015.15..70,723.88 rows=4,159 width=964) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on shopify_orders o (cost=10,014.72..20,288.63 rows=3,077 width=620) (actual rows= loops=)

  • Recheck Cond: ((created_at >= '2019-01-01 18:30:00'::timestamp without time zone) AND (created_at <= '2019-02-01 06:18:05.33'::timestamp without time zone) AND (shop_id = 80))
13. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=10,014.72..10,014.72 rows=3,077 width=0) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ix_shopify_orders_created_at (cost=0.00..1,873.71 rows=22,529 width=0) (actual rows= loops=)

  • Index Cond: ((created_at >= '2019-01-01 18:30:00'::timestamp without time zone) AND (created_at <= '2019-02-01 06:18:05.33'::timestamp without time zone))
15. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on index_shopify_orders_on_shop_id (cost=0.00..8,139.22 rows=128,906 width=0) (actual rows= loops=)

  • Index Cond: (shop_id = 80)
16. 0.000 0.000 ↓ 0.0

Index Scan using index_shopify_line_items_on_shopify_order_id on shopify_line_items l (cost=0.43..14.33 rows=3 width=220) (actual rows= loops=)

  • Index Cond: (shopify_order_id = o.id)
17. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=0.00..0.00 rows=1 width=1,169) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.00 rows=0 width=1,165) (actual rows= loops=)

  • One-Time Filter: false
19. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 3 (cost=0.00..0.01 rows=1 width=1,192) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.00 rows=0 width=1,184) (actual rows= loops=)

  • One-Time Filter: false
21. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 4 (cost=0.00..1.03 rows=1 width=1,200) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1.01 rows=1 width=1,188) (actual rows= loops=)

  • Group Key: id
23. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.00 rows=0 width=49) (actual rows= loops=)

  • One-Time Filter: false