explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DMCE

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.076 ↓ 2.0 14 1

Nested Loop (cost=3.90..7.46 rows=7 width=464) (actual time=0.062..0.076 rows=14 loops=1)

2. 0.008 0.056 ↓ 2.0 2 1

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

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

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

  • Sort Key: es_event.order_id, es_event.pair_start
  • Sort Method: quicksort Memory: 25kB
4. 0.040 0.040 ↓ 10.0 10 1

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

  • Index Cond: ((name = ANY ('{ORDER_IS_PAIR,ORDER_IS_UNPAIR}'::text[])) AND (mean_id = 7732) AND ('2019-12-31 21:06:49'::timestamp without time zone >= pair_start))
5. 0.016 0.016 ↑ 1.0 7 2

Index Scan using es_event_order_id_idx on es_event e (cost=0.29..3.74 rows=7 width=464) (actual time=0.006..0.008 rows=7 loops=2)

  • Index Cond: (order_id = es_event.order_id)
Planning time : 0.224 ms
Execution time : 0.107 ms