explain.depesz.com

PostgreSQL's explain analyze made readable

Result: q9jW : test

Settings
# exclusive inclusive rows x rows loops node
1. 21.525 542.404 ↓ 1.4 62,781 1

Group (cost=82,308.25..87,074.47 rows=44,079 width=34) (actual time=458.764..542.404 rows=62,781 loops=1)

  • Group Key: email, number, name
2. 0.000 520.879 ↓ 1.7 62,781 1

Gather Merge (cost=82,308.25..86,795.04 rows=37,258 width=34) (actual time=458.762..520.879 rows=62,781 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 25.569 1,322.172 ↓ 1.1 20,927 3

Group (cost=81,308.23..81,494.52 rows=18,629 width=34) (actual time=428.623..440.724 rows=20,927 loops=3)

  • Group Key: email, number, name
4. 354.054 1,296.603 ↓ 1.1 20,927 3

Sort (cost=81,308.23..81,354.80 rows=18,629 width=34) (actual time=428.620..432.201 rows=20,927 loops=3)

  • Sort Key: email, number, name
  • Sort Method: quicksort Memory: 1638kB
5. 942.549 942.549 ↓ 1.1 20,927 3

Parallel Seq Scan on shopify_orders sv (cost=0.00..79,986.94 rows=18,629 width=34) (actual time=0.340..314.183 rows=20,927 loops=3)

  • Filter: ((created_at >= '2018-12-31 18:30:00'::timestamp without time zone) AND (created_at <= '2019-07-18 06:18:05.33'::timestamp without time zone) AND (shop_id = 80))
  • Rows Removed by Filter: 296362
Planning time : 0.148 ms
Execution time : 545.849 ms