explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oR6j

Settings
# exclusive inclusive rows x rows loops node
1. 4,207.347 20,625.758 ↓ 0.0 0 1

Insert on processed_feed_data (cost=0.00..155.00 rows=1 width=3,524) (actual time=20,625.758..20,625.758 rows=0 loops=1)

  • Buffers: shared hit=284273 read=246
2. 5,402.723 16,418.411 ↓ 5,000.0 5,000 1

Nested Loop (cost=0.00..155.00 rows=1 width=3,524) (actual time=1.544..16,418.411 rows=5,000 loops=1)

  • Join Filter: (filterkeys.raw_record_id = ukey.raw_record_id)
  • Rows Removed by Join Filter: 24995000
  • Buffers: shared hit=215103
3. 10.688 10.688 ↓ 5,000.0 5,000 1

Seq Scan on s86coffee_processed_feed_data1557800297115 filterkeys (cost=0.00..105.58 rows=1 width=3,488) (actual time=0.012..10.688 rows=5,000 loops=1)

  • Filter: (effective_begin_date = '2019-04-30'::date)
  • Buffers: shared hit=103
4. 11,005.000 11,005.000 ↓ 833.3 5,000 5,000

Seq Scan on s86coffee_processed_feed_data_keys1557800297814 ukey (cost=0.00..49.35 rows=6 width=524) (actual time=0.006..2.201 rows=5,000 loops=5,000)

  • Filter: ((db_category)::text = ANY ('{I,U}'::text[]))
  • Buffers: shared hit=210000