explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DqUB

Settings
# exclusive inclusive rows x rows loops node
1. 0.364 3.695 ↓ 5.8 924 1

Hash Join (cost=184.26..304.07 rows=158 width=633) (actual time=1.924..3.695 rows=924 loops=1)

  • Hash Cond: ((r.request_status_key)::text = (rs.status_key)::text)
2. 0.193 3.283 ↓ 2.0 1,144 1

Hash Join (cost=179.81..291.13 rows=572 width=416) (actual time=1.868..3.283 rows=1,144 loops=1)

  • Hash Cond: (r.request_type = rt.id)
3. 0.183 3.085 ↑ 1.0 1,144 1

Hash Join (cost=178.72..284.91 rows=1,144 width=214) (actual time=1.861..3.085 rows=1,144 loops=1)

  • Hash Cond: (d.type = refterm.id)
4. 0.196 2.886 ↑ 1.0 1,144 1

Hash Join (cost=177.04..279.81 rows=1,144 width=230) (actual time=1.842..2.886 rows=1,144 loops=1)

  • Hash Cond: (udm.department_id = d.id)
5. 0.379 2.560 ↑ 1.0 1,144 1

Hash Join (cost=163.90..263.63 rows=1,144 width=209) (actual time=1.709..2.560 rows=1,144 loops=1)

  • Hash Cond: (udm.user_id = u.id)
6. 0.509 0.509 ↑ 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.008..0.509 rows=3,352 loops=1)

  • Filter: is_active
  • Rows Removed by Filter: 20
7. 0.106 1.672 ↑ 1.0 286 1

Hash (cost=160.32..160.32 rows=286 width=225) (actual time=1.672..1.672 rows=286 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 82kB
8. 0.054 1.566 ↑ 1.0 286 1

Hash Join (cost=137.44..160.32 rows=286 width=225) (actual time=1.292..1.566 rows=286 loops=1)

  • Hash Cond: (r.event_id = e.id)
9. 0.056 0.866 ↑ 1.0 286 1

Hash Join (cost=67.84..89.97 rows=286 width=184) (actual time=0.642..0.866 rows=286 loops=1)

  • Hash Cond: (rd.attendee_id = a.id)
10. 0.053 0.684 ↑ 1.0 286 1

Hash Join (cost=51.95..73.33 rows=286 width=186) (actual time=0.510..0.684 rows=286 loops=1)

  • Hash Cond: (r.request_details_id = rd.id)
11. 0.067 0.521 ↑ 1.0 286 1

Hash Join (cost=36.86..57.47 rows=286 width=186) (actual time=0.394..0.521 rows=286 loops=1)

  • Hash Cond: (r.requester = u.id)
12. 0.070 0.070 ↑ 1.0 286 1

Seq Scan on request r (cost=0.00..19.86 rows=286 width=129) (actual time=0.003..0.070 rows=286 loops=1)

  • Filter: is_active
13. 0.152 0.384 ↑ 1.0 838 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 82kB
14. 0.232 0.232 ↑ 1.0 838 1

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

  • Filter: is_active
15. 0.036 0.110 ↓ 1.1 286 1

Hash (cost=11.71..11.71 rows=271 width=32) (actual time=0.110..0.110 rows=286 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 26kB
16. 0.074 0.074 ↓ 1.1 286 1

Seq Scan on request_details rd (cost=0.00..11.71 rows=271 width=32) (actual time=0.003..0.074 rows=286 loops=1)

  • Filter: is_active
17. 0.046 0.126 ↑ 1.1 286 1

Hash (cost=12.06..12.06 rows=306 width=30) (actual time=0.126..0.126 rows=286 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 26kB
18. 0.080 0.080 ↑ 1.1 286 1

Seq Scan on attendee a (cost=0.00..12.06 rows=306 width=30) (actual time=0.004..0.080 rows=286 loops=1)

  • Filter: is_active
19. 0.242 0.646 ↑ 1.0 1,271 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 147kB
20. 0.404 0.404 ↑ 1.0 1,271 1

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

  • Filter: is_active
21. 0.046 0.130 ↑ 1.0 362 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 39kB
22. 0.084 0.084 ↑ 1.0 362 1

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
24. 0.013 0.013 ↑ 1.0 30 1

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

25. 0.002 0.005 ↓ 2.0 6 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
26. 0.003 0.003 ↓ 2.0 6 1

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

  • Filter: is_active
27. 0.004 0.048 ↑ 1.0 10 1

Hash (cost=4.33..4.33 rows=10 width=53) (actual time=0.048..0.048 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
28. 0.044 0.044 ↑ 1.0 10 1

Seq Scan on request_status rs (cost=0.00..4.33 rows=10 width=53) (actual time=0.018..0.044 rows=10 loops=1)

  • Filter: (is_active AND ((parent_status)::text = 'Requester Pending'::text))
  • Rows Removed by Filter: 96
Planning time : 1.939 ms