explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dU3R

Settings
# exclusive inclusive rows x rows loops node
1. 0.298 1,647.405 ↑ 20.6 10 1

Aggregate (cost=273,618.03..273,625.94 rows=206 width=14) (actual time=1,647.168..1,647.405 rows=10 loops=1)

  • Group Key: packages_events.originator_type, packages_events.event_type, packages_events.event_scope
  • Buffers: shared hit=60,038 read=436
  • I/O Timings: read=508.425
2. 1.134 1,647.107 ↓ 1.2 539 1

Sort (cost=273,618.03..273,619.20 rows=468 width=14) (actual time=1,647.067..1,647.107 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=60,035 read=436
  • I/O Timings: read=508.425
3. 1,645.973 1,645.973 ↓ 1.2 539 1

Index Scan using index_packages_events_on_created_and_types_and_originator on public.packages_events (cost=0.56..273,597.28 rows=468 width=14) (actual time=2.380..1,645.973 rows=539 loops=1)

  • Index Cond: ((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 >= 0) AND (packages_events.originator <= 9,999))
  • Filter: (packages_events.originator_type <> 2)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=60,032 read=436
  • I/O Timings: read=508.425