explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yHuW

Settings
# exclusive inclusive rows x rows loops node
1. 48.262 255.209 ↑ 1.0 1 1

Aggregate (cost=310.59..310.60 rows=1 width=8) (actual time=255.192..255.209 rows=1 loops=1)

2. 100.925 206.947 ↓ 1.0 5,080 1

Hash Right Join (cost=94.22..297.97 rows=5,048 width=39) (actual time=57.674..206.947 rows=5,080 loops=1)

  • Hash Cond: ((sp.session_id)::text = (session.id)::text)
3. 48.398 48.398 ↓ 1.0 5,080 1

Seq Scan on session_participant sp (cost=0.00..190.48 rows=5,048 width=78) (actual time=0.022..48.398 rows=5,080 loops=1)

4. 30.205 57.624 ↑ 1.0 2,540 1

Hash (cost=62.43..62.43 rows=2,543 width=39) (actual time=57.615..57.624 rows=2,540 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 210kB
5. 27.419 27.419 ↑ 1.0 2,540 1

Seq Scan on session (cost=0.00..62.43 rows=2,543 width=39) (actual time=0.016..27.419 rows=2,540 loops=1)

Planning time : 0.305 ms
Execution time : 255.358 ms