explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DSOm

Settings
# exclusive inclusive rows x rows loops node
1. 188.333 730.610 ↑ 1.0 10,000 1

Hash Left Join (cost=68.25..455.33 rows=10,000 width=136) (actual time=51.011..730.610 rows=10,000 loops=1)

  • Hash Cond: ((main_session.session_type_code)::text = (st.code)::text)
2. 195.516 539.686 ↑ 1.0 10,000 1

Hash Left Join (cost=64.00..398.72 rows=10,000 width=109) (actual time=48.333..539.686 rows=10,000 loops=1)

  • Hash Cond: (main_session.room_id = r.id)
3. 192.457 322.932 ↑ 1.0 10,000 1

Hash Left Join (cost=32.50..340.86 rows=10,000 width=101) (actual time=27.050..322.932 rows=10,000 loops=1)

  • Hash Cond: (main_session.person_id = p.id)
4. 103.478 103.478 ↑ 1.0 10,000 1

Seq Scan on session main_session (cost=0.00..282.00 rows=10,000 width=92) (actual time=0.022..103.478 rows=10,000 loops=1)

5. 14.577 26.997 ↑ 1.0 1,000 1

Hash (cost=20.00..20.00 rows=1,000 width=25) (actual time=26.989..26.997 rows=1,000 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 65kB
6. 12.420 12.420 ↑ 1.0 1,000 1

Seq Scan on person p (cost=0.00..20.00 rows=1,000 width=25) (actual time=0.018..12.420 rows=1,000 loops=1)

7. 10.882 21.238 ↑ 1.0 1,000 1

Hash (cost=19.00..19.00 rows=1,000 width=24) (actual time=21.230..21.238 rows=1,000 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 64kB
8. 10.356 10.356 ↑ 1.0 1,000 1

Seq Scan on room r (cost=0.00..19.00 rows=1,000 width=24) (actual time=0.019..10.356 rows=1,000 loops=1)

9. 1.450 2.591 ↑ 1.0 100 1

Hash (cost=3.00..3.00 rows=100 width=39) (actual time=2.584..2.591 rows=100 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
10. 1.141 1.141 ↑ 1.0 100 1

Seq Scan on session_type st (cost=0.00..3.00 rows=100 width=39) (actual time=0.018..1.141 rows=100 loops=1)