explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5g8P : 123

Settings
# exclusive inclusive rows x rows loops node
1. 55.762 27,052.355 ↓ 0.0 0 1

Nested Loop (cost=0.01..9,544.99 rows=12,290 width=72) (actual time=27,052.355..27,052.355 rows=0 loops=1)

  • Planning time: 2.717 ms
  • Execution time: 27052.394 ms
2. 8,431.461 8,431.461 ↑ 1.1 180,244 1

Index Scan using idx_repeat_times_modification_date_status_fault_retied_times on message_event messageeve0_ (cost=0.01..3,247.84 rows=204,947 width=72) (actual time=6.079..8,431.461 rows=180,244 loops=1)

  • Index Cond: ((repeat_times <= 5) AND (modification_date <= '2019-01-15 09:10:48.009'::timestamp without time zone))
  • Filter: (((status)::text = 'SKIPPED'::text) OR (((status)::text = 'SAVED'::text) AND (fault_retried_times > 5)))
  • Rows Removed by Filter: 34044
3. 18,565.132 18,565.132 ↓ 0.0 0 180,244

Index Only Scan using idx_request_number_id_app_code on request_number requestnum1_ (cost=0.01..0.02 rows=1 width=8) (actual time=0.103..0.103 rows=0 loops=180,244)

  • Index Cond: ((id = messageeve0_.request_number_id) AND (app_code = 'P10.01'::text))
  • Heap Fetches: 0