explain.depesz.com

PostgreSQL's explain analyze made readable

Result: e9A2

Settings
# exclusive inclusive rows x rows loops node
1. 0.027 8.188 ↑ 1.0 2 1

GroupAggregate (cost=865.32..865.53 rows=2 width=12) (actual time=8.178..8.188 rows=2 loops=1)

  • Group Key: order_id, (((data #>> '{attributes,last_pair,start}'::text[]))::timestamp without time zone)
  • Filter: ((max(((data #>> '{attributes,last_pair,end}'::text[]))::timestamp without time zone) IS NULL) OR (max(((data #>> '{attributes,last_pair,end}'::text[]))::timestamp without time zone) <= '2019-12-31 21:06:49'::timestamp without time zone))
  • Rows Removed by Filter: 3
2. 0.016 8.161 ↓ 2.0 10 1

Sort (cost=865.32..865.33 rows=5 width=472) (actual time=8.160..8.161 rows=10 loops=1)

  • Sort Key: order_id, (((data #>> '{attributes,last_pair,start}'::text[]))::timestamp without time zone)
  • Sort Method: quicksort Memory: 30kB
3. 8.145 8.145 ↓ 2.0 10 1

Index Scan using es_event_creation_ts_name_idx on es_event e (cost=0.29..865.26 rows=5 width=472) (actual time=0.212..8.145 rows=10 loops=1)

  • Index Cond: (name = ANY ('{ORDER_IS_PAIR,ORDER_IS_UNPAIR}'::text[]))
  • Filter: (('2019-12-31 21:06:49'::timestamp without time zone >= ((data #>> '{attributes,last_pair,start}'::text[]))::timestamp without time zone) AND (((data #>> '{attributes,last_pair,mean_id}'::text[]))::integer = 7732))
  • Rows Removed by Filter: 2776
Planning time : 0.176 ms
Execution time : 8.232 ms