explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 17nWB

Settings
# exclusive inclusive rows x rows loops node
1. 1.932 263.553 ↓ 6.1 6,097 1

Hash Join (cost=261.44..274.06 rows=1,000 width=162) (actual time=261.232..263.553 rows=6,097 loops=1)

  • Hash Cond: (apacl.id = ap.id)
2. 260.404 260.404 ↓ 6.1 6,097 1

Function Scan on get_attendance_period_acl_sum_for_user apacl (cost=0.25..10.25 rows=1,000 width=24) (actual time=259.998..260.404 rows=6,097 loops=1)

3. 0.707 1.217 ↑ 1.0 6,275 1

Hash (cost=182.75..182.75 rows=6,275 width=138) (actual time=1.217..1.217 rows=6,275 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 1033kB
4. 0.510 0.510 ↑ 1.0 6,275 1

Seq Scan on attendance_periods ap (cost=0.00..182.75 rows=6,275 width=138) (actual time=0.010..0.510 rows=6,275 loops=1)

Planning time : 0.115 ms
Execution time : 264.211 ms