explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uLbw

Settings
# exclusive inclusive rows x rows loops node
1. 2.721 12.837 ↓ 2.3 3,136 1

Hash Join (cost=184.86..325.47 rows=1,364 width=633) (actual time=6.477..12.837 rows=3,136 loops=1)

  • Hash Cond: ((r.request_status_key)::text = (rs.status_key)::text)
2. 0.543 9.955 ↓ 2.0 1,136 1

Hash Join (cost=179.71..290.80 rows=566 width=416) (actual time=6.223..9.955 rows=1,136 loops=1)

  • Hash Cond: (r.request_type = rt.id)
3. 0.497 9.359 ↓ 1.0 1,136 1

Hash Join (cost=178.62..284.63 rows=1,132 width=214) (actual time=6.104..9.359 rows=1,136 loops=1)

  • Hash Cond: (d.type = refterm.id)
4. 0.626 8.816 ↓ 1.0 1,136 1

Hash Join (cost=176.94..279.56 rows=1,132 width=230) (actual time=6.028..8.816 rows=1,136 loops=1)

  • Hash Cond: (udm.department_id = d.id)
5. 1.116 7.793 ↓ 1.0 1,136 1

Hash Join (cost=163.80..263.41 rows=1,132 width=209) (actual time=5.599..7.793 rows=1,136 loops=1)

  • Hash Cond: (udm.user_id = u.id)
6. 1.224 1.224 ↑ 1.0 3,352 1

Seq Scan on user_department_map udm (cost=0.00..75.72 rows=3,352 width=32) (actual time=0.019..1.224 rows=3,352 loops=1)

  • Filter: is_active
  • Rows Removed by Filter: 20
7. 0.372 5.453 ↓ 1.0 284 1

Hash (cost=160.26..160.26 rows=283 width=225) (actual time=5.452..5.453 rows=284 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 81kB
8. 0.221 5.081 ↓ 1.0 284 1

Hash Join (cost=137.44..160.26 rows=283 width=225) (actual time=3.998..5.081 rows=284 loops=1)

  • Hash Cond: (r.event_id = e.id)
9. 0.223 3.046 ↓ 1.0 284 1

Hash Join (cost=67.84..89.92 rows=283 width=184) (actual time=2.156..3.046 rows=284 loops=1)

  • Hash Cond: (rd.attendee_id = a.id)
10. 0.210 2.396 ↓ 1.0 284 1

Hash Join (cost=51.95..73.28 rows=283 width=186) (actual time=1.698..2.396 rows=284 loops=1)

  • Hash Cond: (r.request_details_id = rd.id)
11. 0.292 1.834 ↓ 1.0 284 1

Hash Join (cost=36.86..57.43 rows=283 width=186) (actual time=1.309..1.834 rows=284 loops=1)

  • Hash Cond: (r.requester = u.id)
12. 0.284 0.284 ↓ 1.0 284 1

Seq Scan on request r (cost=0.00..19.83 rows=283 width=129) (actual time=0.015..0.284 rows=284 loops=1)

  • Filter: is_active
13. 0.549 1.258 ↑ 1.0 838 1

Hash (cost=26.38..26.38 rows=838 width=57) (actual time=1.258..1.258 rows=838 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 82kB
14. 0.709 0.709 ↑ 1.0 838 1

Seq Scan on user_info u (cost=0.00..26.38 rows=838 width=57) (actual time=0.015..0.709 rows=838 loops=1)

  • Filter: is_active
15. 0.128 0.352 ↓ 1.0 284 1

Hash (cost=11.71..11.71 rows=271 width=32) (actual time=0.352..0.352 rows=284 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 26kB
16. 0.224 0.224 ↓ 1.0 284 1

Seq Scan on request_details rd (cost=0.00..11.71 rows=271 width=32) (actual time=0.009..0.224 rows=284 loops=1)

  • Filter: is_active
17. 0.154 0.427 ↑ 1.1 284 1

Hash (cost=12.06..12.06 rows=306 width=30) (actual time=0.426..0.427 rows=284 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 26kB
18. 0.273 0.273 ↑ 1.1 284 1

Seq Scan on attendee a (cost=0.00..12.06 rows=306 width=30) (actual time=0.010..0.273 rows=284 loops=1)

  • Filter: is_active
19. 0.799 1.814 ↑ 1.0 1,271 1

Hash (cost=53.71..53.71 rows=1,271 width=73) (actual time=1.814..1.814 rows=1,271 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 147kB
20. 1.015 1.015 ↑ 1.0 1,271 1

Seq Scan on event e (cost=0.00..53.71 rows=1,271 width=73) (actual time=0.025..1.015 rows=1,271 loops=1)

  • Filter: is_active
21. 0.212 0.397 ↑ 1.0 362 1

Hash (cost=8.62..8.62 rows=362 width=53) (actual time=0.397..0.397 rows=362 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 39kB
22. 0.185 0.185 ↑ 1.0 362 1

Seq Scan on department d (cost=0.00..8.62 rows=362 width=53) (actual time=0.019..0.185 rows=362 loops=1)

  • Filter: is_active
23. 0.016 0.046 ↑ 1.0 30 1

Hash (cost=1.30..1.30 rows=30 width=16) (actual time=0.045..0.046 rows=30 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
24. 0.030 0.030 ↑ 1.0 30 1

Seq Scan on ref_term refterm (cost=0.00..1.30 rows=30 width=16) (actual time=0.024..0.030 rows=30 loops=1)

25. 0.019 0.053 ↓ 2.0 6 1

Hash (cost=1.06..1.06 rows=3 width=234) (actual time=0.053..0.053 rows=6 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
26. 0.034 0.034 ↓ 2.0 6 1

Seq Scan on request_type rt (cost=0.00..1.06 rows=3 width=234) (actual time=0.030..0.034 rows=6 loops=1)

  • Filter: is_active
27. 0.074 0.161 ↑ 1.0 87 1

Hash (cost=4.06..4.06 rows=87 width=53) (actual time=0.161..0.161 rows=87 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
28. 0.087 0.087 ↑ 1.0 87 1

Seq Scan on request_status rs (cost=0.00..4.06 rows=87 width=53) (actual time=0.028..0.087 rows=87 loops=1)

  • Filter: is_active
  • Rows Removed by Filter: 19