explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9XQS : tyer

Settings
# exclusive inclusive rows x rows loops node
1. 0.039 1.608 ↑ 8.6 33 1

Limit (cost=1,100.66..1,101.37 rows=285 width=338) (actual time=1.556..1.608 rows=33 loops=1)

2. 0.046 1.569 ↑ 8.6 33 1

Sort (cost=1,100.66..1,101.37 rows=285 width=338) (actual time=1.554..1.569 rows=33 loops=1)

  • Sort Key: order_order.create_time_local DESC
  • Sort Method: quicksort Memory: 33kB
3. 0.028 1.523 ↑ 8.6 33 1

Custom Scan (ConstraintAwareAppend) (cost=236.54..1,089.04 rows=285 width=338) (actual time=0.899..1.523 rows=33 loops=1)

  • Hypertable: order_order
  • Chunks left after exclusion: 2
4. 0.120 1.495 ↑ 8.6 33 1

Append (cost=236.54..1,089.04 rows=285 width=338) (actual time=0.897..1.495 rows=33 loops=1)

  • -> Bitmap Heap Scan on _hyper_3_4613_chunk (cost=236.54..474.37 rows=132 width=338) (actual time=0.896..0.941 r
  • Recheck Cond: ((exconf_id = 37) AND (create_time_local > (now() - '00:05:00'::interval)) AND (status = 1))
  • Filter: ((account_id = 3) AND ((side)::text = 'buy'::text))
  • Rows Removed by Filter: 40
  • Heap Blocks: exact=12
  • -> Bitmap Heap Scan on _hyper_3_4612_chunk (cost=318.56..431.90 rows=54 width=338) (actual time=0.526..0.527 ro
  • Recheck Cond: ((exconf_id = 37) AND (create_time_local > (now() - '00:05:00'::interval)) AND (status = 1))
  • Filter: ((account_id = 3) AND ((side)::text = 'buy'::text))
5. 0.850 0.850 ↓ 0.0 0 1

BitmapAnd (cost=236.54..236.54 rows=262 width=0) (actual time=0.849..0.850 rows=0 loops=1)

  • -> Bitmap Index Scan on _hyper_3_4613_chunk_order_order_exconf_id_idx (cost=0.00..27.01 rows=1803 w
  • Index Cond: (exconf_id = 37)
  • -> Bitmap Index Scan on _hyper_3_4613_chunk_order_order_status_create_time_local_idx (cost=0.00..20
  • Index Cond: (create_time_local > (now() - '00:05:00'::interval))
6. 0.525 0.525 ↓ 0.0 0 1

BitmapAnd (cost=318.56..318.56 rows=107 width=0) (actual time=0.525..0.525 rows=0 loops=1)

  • -> Bitmap Index Scan on _hyper_3_4612_chunk_order_order_exconf_id_idx (cost=0.00..57.08 rows=4052 w
  • Index Cond: (exconf_id = 37)
  • -> Bitmap Index Scan on _hyper_3_4612_chunk_order_order_status_create_time_local_idx (cost=0.00..26
  • Index Cond: (create_time_local > (now() - '00:05:00'::interval))