explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i93j

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.198 ↑ 1.0 5 1

Limit (cost=50.05..50.06 rows=5 width=2,315) (actual time=0.197..0.198 rows=5 loops=1)

  • Buffers: shared hit=5
2.          

Initplan (for Limit)

3. 0.019 0.019 ↑ 1.0 1 1

Seq Scan on status_request_meeting srm (cost=0.00..13.15 rows=1 width=4) (actual time=0.017..0.019 rows=1 loops=1)

  • Filter: (upper((code)::text) = 'PLANNED'::text)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=1
4. 0.020 0.197 ↑ 1.0 5 1

Sort (cost=36.90..36.91 rows=5 width=2,315) (actual time=0.196..0.197 rows=5 loops=1)

  • Sort Key: (((date_part('day'::text, (now() - ((requestmee0_.meeting_dt + requestmee0_.to_time))::timestamp with time zone)) > '5'::double precision) AND (requestmee0_.status_request_meeting_id = $0))) DESC, requestmee0_.meeting_dt DESC
  • Sort Method: quicksort Memory: 27kB
  • Buffers: shared hit=5
5. 0.047 0.177 ↑ 1.0 5 1

Hash Right Join (cost=23.81..36.84 rows=5 width=2,315) (actual time=0.146..0.177 rows=5 loops=1)

  • Hash Cond: (statusrequ1_.id = requestmee0_.status_request_meeting_id)
  • Buffers: shared hit=5
6. 0.011 0.011 ↑ 70.0 3 1

Seq Scan on status_request_meeting statusrequ1_ (cost=0.00..12.10 rows=210 width=344) (actual time=0.010..0.011 rows=3 loops=1)

  • Buffers: shared hit=1
7. 0.010 0.119 ↑ 1.0 5 1

Hash (cost=23.75..23.75 rows=5 width=1,970) (actual time=0.119..0.119 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=3
8. 0.017 0.109 ↑ 1.0 5 1

Hash Right Join (cost=12.19..23.75 rows=5 width=1,970) (actual time=0.103..0.109 rows=5 loops=1)

  • Hash Cond: (department2_.id = requestmee0_.department_id)
  • Buffers: shared hit=3
9. 0.010 0.010 ↑ 55.0 2 1

Seq Scan on department department2_ (cost=0.00..11.10 rows=110 width=663) (actual time=0.010..0.010 rows=2 loops=1)

  • Buffers: shared hit=1
10. 0.007 0.082 ↑ 1.0 5 1

Hash (cost=12.13..12.13 rows=5 width=1,307) (actual time=0.082..0.082 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
11. 0.021 0.075 ↑ 1.0 5 1

Hash Right Join (cost=1.11..12.13 rows=5 width=1,307) (actual time=0.067..0.075 rows=5 loops=1)

  • Hash Cond: (employeeen3_.id = requestmee0_.employee_id)
  • Buffers: shared hit=2
12. 0.011 0.011 ↑ 14.0 5 1

Seq Scan on employee employeeen3_ (cost=0.00..10.70 rows=70 width=1,002) (actual time=0.011..0.011 rows=5 loops=1)

  • Buffers: shared hit=1
13. 0.015 0.043 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=305) (actual time=0.042..0.043 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
14. 0.028 0.028 ↑ 1.0 5 1

Seq Scan on request_meeting requestmee0_ (cost=0.00..1.05 rows=5 width=305) (actual time=0.024..0.028 rows=5 loops=1)

  • Buffers: shared hit=1
Planning time : 0.845 ms
Execution time : 0.675 ms