explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jv91

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

Finalize GroupAggregate (cost=83,934.13..84,214.66 rows=15 width=627) (actual rows= loops=)

  • Group Key: shops.id
2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=83,934.13..84,214.28 rows=30 width=627) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=82,934.10..83,210.80 rows=15 width=627) (actual rows= loops=)

  • Group Key: shops.id
4. 0.000 0.000 ↓ 0.0

Sort (cost=82,934.10..82,963.21 rows=11,644 width=633) (actual rows= loops=)

  • Sort Key: shops.id
5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.57..82,147.71 rows=11,644 width=633) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on shops (cost=0.00..4,953.33 rows=6 width=611) (actual rows= loops=)

  • Filter: ((alt_rename_enabled OR file_rename_enabled) AND (closed_at IS NULL) AND ((shopify_token)::text <> ''::text) AND (state = 2) AND ((shopify_charge_active AND (plan <> 1)) OR (plan = 10)))
7. 0.000 0.000 ↓ 0.0

Index Scan using test_fix_new2 on images (cost=0.57..12,737.49 rows=12,824 width=26) (actual rows= loops=)

  • Index Cond: ((shop_id = shops.id) AND (active = true))
  • Filter: active