explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9yqN

Settings
# exclusive inclusive rows x rows loops node
1. 3.654 107,535.641 ↓ 24,664.0 24,664 1

Limit (cost=0.56..1,360,018.37 rows=1 width=1,762) (actual time=98,936.478..107,535.641 rows=24,664 loops=1)

  • Buffers: shared hit=1158538 read=1010677
  • I/O Timings: read=399.690
2. 17.513 107,531.987 ↓ 24,664.0 24,664 1

Nested Loop Left Join (cost=0.56..1,360,018.37 rows=1 width=1,762) (actual time=98,936.477..107,531.987 rows=24,664 loops=1)

  • Join Filter: (COALESCE(c.review_status_id, 1) = d.review_status_id)
  • Rows Removed by Join Filter: 24664
  • Buffers: shared hit=1158538 read=1010677
  • I/O Timings: read=399.690
3. 161.985 107,489.810 ↓ 24,664.0 24,664 1

Nested Loop Left Join (cost=0.56..1,360,017.32 rows=1 width=1,246) (actual time=98,936.469..107,489.810 rows=24,664 loops=1)

  • Join Filter: ((a.raw_record_id = c.raw_record_id) AND (a.parser_id = c.parser_id))
  • Rows Removed by Join Filter: 1455176
  • Filter: ((c.knowledge_end_date IS NULL) OR (c.knowledge_end_date > now()))
  • Buffers: shared hit=1133874 read=1010677
  • I/O Timings: read=399.690
4. 6.810 107,179.841 ↓ 24,664.0 24,664 1

Nested Loop Left Join (cost=0.56..1,360,014.79 rows=1 width=1,213) (actual time=98,936.439..107,179.841 rows=24,664 loops=1)

  • Buffers: shared hit=1109210 read=1010677
  • I/O Timings: read=399.690
5. 106,975.735 106,975.735 ↓ 24,662.0 24,662 1

Seq Scan on processed_feed_exclusion a (cost=0.00..1,360,010.20 rows=1 width=496) (actual time=98,933.534..106,975.735 rows=24,662 loops=1)

  • Filter: ((archival_date >= '2019-11-01'::date) AND (archival_date <= '2019-11-01'::date) AND ((record_type)::text = 'KICKOUT'::text) AND (knowledge_end_date > now()))
  • Rows Removed by Filter: 17280901
  • Buffers: shared hit=1010510 read=1010572
  • I/O Timings: read=261.369
6. 197.296 197.296 ↓ 0.0 0 24,662

Index Scan using coffee_raw_file_records_raw_record_id_idx on raw_feed_records b (cost=0.56..4.58 rows=1 width=725) (actual time=0.008..0.008 rows=0 loops=24,662)

  • Index Cond: (a.raw_record_id = raw_record_id)
  • Buffers: shared hit=98700 read=105
  • I/O Timings: read=138.321
7. 147.984 147.984 ↓ 1.2 59 24,664

Seq Scan on feed_exclusion_manifestation c (cost=0.00..1.51 rows=51 width=53) (actual time=0.001..0.006 rows=59 loops=24,664)

  • Buffers: shared hit=24664
8. 24.664 24.664 ↑ 1.0 2 24,664

Seq Scan on feed_exclusion_review_status d (cost=0.00..1.02 rows=2 width=520) (actual time=0.000..0.001 rows=2 loops=24,664)

  • Buffers: shared hit=24664