explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9gRZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 356,722.176 ↓ 0.0 0 1

Limit (cost=0.45..237,943.07 rows=25,000 width=972) (actual time=356,722.176..356,722.176 rows=0 loops=1)

2. 0.003 356,722.175 ↓ 0.0 0 1

Merge Append (cost=0.45..7,578,168.52 rows=796,218 width=972) (actual time=356,722.175..356,722.175 rows=0 loops=1)

  • Sort Key: partition_order_line_staged_event_seq_101_2020_7.event_timestamp
3. 356,722.172 356,722.172 ↓ 0.0 0 1

Index Scan using partition_order_line_staged_event_seq_101__event_timestamp_idx2 on partition_order_line_staged_event_seq_101_2020_7 (cost=0.43..7,570,206.33 rows=796,218 width=972) (actual time=356,722.172..356,722.172 rows=0 loops=1)

  • Index Cond: ((event_timestamp >= '2020-07-01 05:30:18.849'::timestamp without time zone) AND (event_timestamp <= '2020-07-02 09:30:18.849'::timestamp without time zone))
  • Filter: ((processed_count <= '3'::numeric) AND (sequence_number = '101'::numeric) AND (sub_sequence_number = ANY ('{1,2,3,4,5}'::numeric[])))
  • Rows Removed by Filter: 7,357,077
Planning time : 1.513 ms
Execution time : 356,723.056 ms