explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CeN3

Settings
# exclusive inclusive rows x rows loops node
1. 0.026 12.126 ↑ 1.0 2 1

GroupAggregate (cost=1,322.20..1,322.42 rows=2 width=12) (actual time=12.115..12.126 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.048 12.100 ↓ 2.0 10 1

Sort (cost=1,322.20..1,322.22 rows=5 width=472) (actual time=12.099..12.100 rows=10 loops=1)

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

Seq Scan on es_event e (cost=0.00..1,322.14 rows=5 width=472) (actual time=0.064..12.052 rows=10 loops=1)

  • Filter: ((name = ANY ('{ORDER_IS_PAIR,ORDER_IS_UNPAIR}'::text[])) AND ('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: 12698
Planning time : 1.497 ms
Execution time : 12.273 ms