explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rqfy

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.615 346.471 ↑ 1.0 100 1

Limit (cost=378,234.40..378,234.65 rows=100 width=24) (actual time=346.449..346.471 rows=100 loops=1)

2. 11.229 345.856 ↑ 1.1 10,100 1

Sort (cost=378,209.40..378,236.00 rows=10,640 width=24) (actual time=345.169..345.856 rows=10,100 loops=1)

  • Sort Key: (COALESCE(string_to_timestamp(((entity -> 'maybeErpTime'::text) ->> 'value'::text)), string_to_timestamp(((entity -> 'maybeWmsTime'::text) ->> 'value'::text)), created_at))
  • Sort Method: top-N heapsort Memory: 1558kB
3. 334.627 334.627 ↓ 2.0 21,506 1

Index Scan using orders_ordertime_releasetime_idx on orders (cost=0.56..377,497.73 rows=10,640 width=24) (actual time=179.654..334.627 rows=21,506 loops=1)

  • Index Cond: ((string_to_timestamp(((entity -> 'maybeReleasedAt'::text) ->> 'value'::text)) IS NULL) AND (COALESCE(string_to_timestamp(((entity -> 'maybeErpTime'::text) ->> 'value'::text)), string_to_timestamp(((entity -> 'maybeWmsTime'::text
  • Filter: ((canceled_at IS NULL) AND ((entity ->> 'dcId'::text) = '68c3abf7-ef96-386d-b0dc-2e6a01edba16'::text))
  • Rows Removed by Filter: 174
Planning time : 0.304 ms