explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UeZ8

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 1,270.777 ↑ 1.0 1 1

Limit (cost=0.99..17.05 rows=1 width=24) (actual time=1,270.773..1,270.777 rows=1 loops=1)

  • Buffers: shared hit=857,789
2. 0.020 1,270.771 ↑ 1.0 1 1

Nested Loop Anti Join (cost=0.99..17.05 rows=1 width=24) (actual time=1,270.770..1,270.771 rows=1 loops=1)

  • Join Filter: ((brl.business_id)::text = (dp.business_id)::text)
  • Rows Removed by Join Filter: 1
  • Buffers: shared hit=857,789
3. 1.553 1.553 ↓ 2.0 2 1

Index Scan using idx02_data_policy_next_process on data_policy dp (cost=0.57..8.60 rows=1 width=24) (actual time=1.547..1.553 rows=2 loops=1)

  • Index Cond: ((next_process IS NOT NULL) AND ('2020-06-29 11:01:40'::timestamp without time zone > next_process) AND (next_process >= '2020-06-29 10:31:40'::timestamp without time zone))
  • Filter: ((status)::text = ANY ('{PROCESS_ERROR,ADMINISTRATION_TO_REPROCESS,NEW,TO_REPROCESS,VERSION_MISSING}'::text[]))
  • Buffers: shared hit=991
4. 1,269.198 1,269.198 ↑ 1.0 1 2

Index Only Scan using business_record_lock_pkey on business_record_lock brl (cost=0.43..8.45 rows=1 width=17) (actual time=394.456..634.599 rows=1 loops=2)

  • Index Cond: (business_class = 'Policy.process'::text)
  • Heap Fetches: 903,048
  • Buffers: shared hit=856,798