explain.depesz.com

PostgreSQL's explain analyze made readable

Result: psja

Settings
# exclusive inclusive rows x rows loops node
1. 0.262 611.371 ↑ 20.6 10 1

Aggregate (cost=201,023.29..201,031.20 rows=206 width=14) (actual time=611.085..611.371 rows=10 loops=1)

  • Group Key: packages_events.originator_type, packages_events.event_type, packages_events.event_scope
  • Buffers: shared hit=57,161
2. 0.547 611.109 ↓ 1.2 539 1

Sort (cost=201,023.29..201,024.46 rows=468 width=14) (actual time=611.058..611.109 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=57,161
3. 610.562 610.562 ↓ 1.2 539 1

Index Scan using index_packages_events_on_created_and_types_and_originator on public.packages_events (cost=0.56..201,002.53 rows=468 width=14) (actual time=0.032..610.562 rows=539 loops=1)

  • Index Cond: ((packages_events.originator >= 0) AND (packages_events.originator <= 9,999))
  • Buffers: shared hit=57,161