explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ysqz

Settings
# exclusive inclusive rows x rows loops node
1. 0.279 5,326.029 ↑ 20.6 10 1

Aggregate (cost=645,694.73..645,702.64 rows=206 width=14) (actual time=5,325.789..5,326.029 rows=10 loops=1)

  • Group Key: packages_events.originator_type, packages_events.event_type, packages_events.event_scope
  • Buffers: shared hit=105 read=92,851
  • I/O Timings: read=2,025.531
2. 1.055 5,325.750 ↓ 1.2 539 1

Sort (cost=645,694.73..645,695.90 rows=468 width=14) (actual time=5,325.707..5,325.750 rows=539 loops=1)

  • Sort Key: packages_events.originator_type, packages_events.event_type, packages_events.event_scope
  • Sort Method: quicksort Memory: 50kB
  • Buffers: shared hit=96 read=92,851
  • I/O Timings: read=2,025.531
3. 5,324.695 5,324.695 ↓ 1.2 539 1

Seq Scan on public.packages_events (cost=0.00..645,673.97 rows=468 width=14) (actual time=0.260..5,324.695 rows=539 loops=1)

  • Filter: ((packages_events.created_at >= '2020-09-15 17:34:51.086253+00'::timestamp with time zone) AND (packages_events.created_at <= '2020-10-13 17:34:51.086455+00'::timestamp with time zone) AND (packages_events.originator_type <> 2) AND (packages_events.originator >= 0) AND (packages_events.originator <= 9,999))
  • Rows Removed by Filter: 12,172,171
  • Buffers: shared hit=96 read=92,851
  • I/O Timings: read=2,025.531