explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iE8P

Settings
# exclusive inclusive rows x rows loops node
1. 651.446 34,044.680 ↓ 0.0 0 1

Insert on processed_feed_data_keys_2019_10_2_5 (cost=0.00..608.68 rows=1 width=7,550) (actual time=34,044.680..34,044.680 rows=0 loops=1)

  • Buffers: shared hit=150645 read=791, temp read=3839520 written=479
2. 13,188.561 33,393.234 ↓ 8,000.0 8,000 1

Nested Loop (cost=0.00..608.68 rows=1 width=7,550) (actual time=3.648..33,393.234 rows=8,000 loops=1)

  • Join Filter: (filterkeys.raw_record_id = ukey.raw_record_id)
  • Rows Removed by Join Filter: 63992000
  • Buffers: shared hit=9102, temp read=3839520 written=479
3. 12.673 12.673 ↓ 888.9 8,000 1

Seq Scan on s77coffee_processed_feed_data_keys1572938458742 ukey (cost=0.00..78.72 rows=9 width=524) (actual time=0.022..12.673 rows=8,000 loops=1)

  • Filter: ((db_category)::text = ANY ('{I,U}'::text[]))
  • Buffers: shared hit=67
4. 20,182.111 20,192.000 ↓ 2,666.7 8,000 8,000

Materialize (cost=0.00..529.55 rows=3 width=7,382) (actual time=0.003..2.524 rows=8,000 loops=8,000)

  • Buffers: shared hit=1035, temp read=3839520 written=479
5. 9.889 9.889 ↓ 2,666.7 8,000 1

Seq Scan on s77coffee_processed_feed_data_keys1572938456778 filterkeys (cost=0.00..529.54 rows=3 width=7,382) (actual time=0.156..9.889 rows=8,000 loops=1)

  • Filter: (effective_begin_date = '2019-10-31'::date)
  • Buffers: shared hit=1035