explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JDBt

Settings

Optimization(s) for this plan:

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

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

2. 0.008 0.068 ↓ 2.0 2 1

GroupAggregate (cost=3.61..3.64 rows=1 width=12) (actual time=0.064..0.068 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.019 0.060 ↓ 10.0 10 1

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

  • Sort Key: es_event.order_id, es_event.pair_start
  • Sort Method: quicksort Memory: 25kB
4. 0.041 0.041 ↓ 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.019..0.041 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.242 ms
Execution time : 0.120 ms