explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AdeD

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 14,321.373 ↑ 1.0 5 1

Limit (cost=24,014.82..24,014.98 rows=5 width=1,034) (actual time=14,321.350..14,321.373 rows=5 loops=1)

2. 0.058 14,321.371 ↑ 15,920.0 5 1

GroupAggregate (cost=24,014.82..26,482.42 rows=79,600 width=1,034) (actual time=14,321.349..14,321.371 rows=5 loops=1)

  • Group Key: o.id, (((obj.offer_item ->> 'product_id'::text))::uuid), ((((o.properties -> 'owner'::text) ->> 'id'::text))::uuid)
3. 273.770 14,321.313 ↑ 13,266.7 6 1

Sort (cost=24,014.82..24,054.62 rows=79,600 width=842) (actual time=14,321.311..14,321.313 rows=6 loops=1)

  • Sort Key: o.id, (((obj.offer_item ->> 'product_id'::text))::uuid), ((((o.properties -> 'owner'::text) ->> 'id'::text))::uuid)
  • Sort Method: external merge Disk: 88,944kB
4. 13,888.848 14,047.543 ↓ 1.6 126,845 1

Nested Loop (cost=0.00..1,533.90 rows=79,600 width=842) (actual time=0.311..14,047.543 rows=126,845 loops=1)

5. 4.675 4.675 ↑ 1.1 755 1

Seq Scan on offers o (cost=0.00..777.69 rows=796 width=778) (actual time=0.011..4.675 rows=755 loops=1)

  • Filter: ((created_at > '2019-11-01 00:00:00-04'::timestamp with time zone) AND (offer_type = ANY ('{business_plan.premier,business_plan.preferred,business_plan.premier.historical,business_plan.preferred.historical}'::text[])))
  • Rows Removed by Filter: 3,934
6. 154.020 154.020 ↓ 1.7 168 755

Function Scan on jsonb_array_elements obj (cost=0.00..0.30 rows=100 width=32) (actual time=0.182..0.204 rows=168 loops=755)

Planning time : 0.268 ms
Execution time : 14,334.194 ms