explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OjQe

Settings
# exclusive inclusive rows x rows loops node
1. 1.626 6.766 ↓ 2.3 3,136 1

Hash Join (cost=184.89..325.67 rows=1,368 width=633) (actual time=3.005..6.766 rows=3,136 loops=1)

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

Hash Join (cost=179.75..290.90 rows=568 width=416) (actual time=2.888..5.069 rows=1,136 loops=1)

  • Hash Cond: (r.request_type = rt.id)
3. 0.309 4.728 ↑ 1.0 1,136 1

Hash Join (cost=178.65..284.72 rows=1,136 width=214) (actual time=2.842..4.728 rows=1,136 loops=1)

  • Hash Cond: (d.type = refterm.id)
4. 0.350 4.398 ↑ 1.0 1,136 1

Hash Join (cost=176.97..279.64 rows=1,136 width=230) (actual time=2.807..4.398 rows=1,136 loops=1)

  • Hash Cond: (udm.department_id = d.id)
5. 0.649 3.854 ↑ 1.0 1,136 1

Hash Join (cost=163.83..263.48 rows=1,136 width=209) (actual time=2.598..3.854 rows=1,136 loops=1)

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

  • Filter: is_active
  • Rows Removed by Filter: 20
7. 0.181 2.531 ↑ 1.0 284 1

Hash (cost=160.28..160.28 rows=284 width=225) (actual time=2.531..2.531 rows=284 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 81kB
8. 0.109 2.350 ↑ 1.0 284 1

Hash Join (cost=137.44..160.28 rows=284 width=225) (actual time=1.891..2.350 rows=284 loops=1)

  • Hash Cond: (r.event_id = e.id)
9. 0.105 1.399 ↑ 1.0 284 1

Hash Join (cost=67.84..89.94 rows=284 width=184) (actual time=1.033..1.399 rows=284 loops=1)

  • Hash Cond: (rd.attendee_id = a.id)
10. 0.094 1.078 ↑ 1.0 284 1

Hash Join (cost=51.95..73.29 rows=284 width=186) (actual time=0.802..1.078 rows=284 loops=1)

  • Hash Cond: (r.request_details_id = rd.id)
11. 0.121 0.804 ↑ 1.0 284 1

Hash Join (cost=36.86..57.44 rows=284 width=186) (actual time=0.603..0.804 rows=284 loops=1)

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

Seq Scan on request r (cost=0.00..19.84 rows=284 width=129) (actual time=0.003..0.101 rows=284 loops=1)

  • Filter: is_active
13. 0.261 0.582 ↑ 1.0 838 1

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

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

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

  • Filter: is_active
15. 0.060 0.180 ↓ 1.0 284 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 26kB
16. 0.120 0.120 ↓ 1.0 284 1

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

  • Filter: is_active
17. 0.076 0.216 ↑ 1.1 284 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 26kB
18. 0.140 0.140 ↑ 1.1 284 1

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

  • Filter: is_active
19. 0.365 0.842 ↑ 1.0 1,271 1

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

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

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

  • Filter: is_active
21. 0.107 0.194 ↑ 1.0 362 1

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

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

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

  • Filter: is_active
23. 0.010 0.021 ↑ 1.0 30 1

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

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

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

25. 0.008 0.017 ↓ 2.0 6 1

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

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

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

  • Filter: is_active
27. 0.035 0.071 ↑ 1.0 87 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
28. 0.036 0.036 ↑ 1.0 87 1

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

  • Filter: is_active
  • Rows Removed by Filter: 19
Planning time : 2.827 ms