explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xju6

Settings
# exclusive inclusive rows x rows loops node
1. 470.123 2,036.296 ↑ 6.0 1 1

GroupAggregate (cost=0.56..332,640.86 rows=6 width=45) (actual time=2,036.296..2,036.296 rows=1 loops=1)

  • Group Key: list_id
  • Buffers: shared hit=3235292 read=55879
2. 1,566.173 1,566.173 ↓ 1.0 4,461,302 1

Index Only Scan using list_person_pkey on list_person (cost=0.56..310,442.52 rows=4,439,655 width=74) (actual time=0.146..1,566.173 rows=4,461,302 loops=1)

  • Index Cond: (list_id = '7496ea81-9bdf-42a8-b8fe-0ae5eb4617c5'::text)
  • Heap Fetches: 368
  • Buffers: shared hit=3235292 read=55879
Planning time : 0.332 ms
Execution time : 2,036.361 ms