explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X4WR

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.104 ↓ 2.0 2 1

GroupAggregate (cost=3.61..3.64 rows=1 width=12) (actual time=0.097..0.104 rows=2 loops=1)

  • Group Key: order_id, pair_start
  • Filter: ((max(pair_end) IS NULL) OR (max(pair_end) <= '2019-12-31 21:06:49'::timestamp without time zone))
  • Rows Removed by Filter: 3
2. 0.038 0.093 ↓ 10.0 10 1

Sort (cost=3.61..3.62 rows=1 width=20) (actual time=0.092..0.093 rows=10 loops=1)

  • Sort Key: order_id, pair_start
  • Sort Method: quicksort Memory: 25kB
3. 0.055 0.055 ↓ 10.0 10 1

Index Scan using es_event_pairing_idx on es_event e (cost=0.29..3.60 rows=1 width=20) (actual time=0.030..0.055 rows=10 loops=1)

  • Index Cond: ((name = ANY ('{ORDER_IS_PAIR,ORDER_IS_UNPAIR}'::text[])) AND (mean_id = 7,732) AND ('2019-12-31 21:06:49'::timestamp without time zone >= pair_start))
Planning time : 1.123 ms
Execution time : 0.218 ms