explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZwSo

Settings
# exclusive inclusive rows x rows loops node
1. 0.773 6.276 ↓ 5.9 924 1

Hash Join (cost=184.20..303.78 rows=157 width=633) (actual time=2.692..6.276 rows=924 loops=1)

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

Hash Join (cost=179.75..290.90 rows=568 width=416) (actual time=2.636..5.458 rows=1,144 loops=1)

  • Hash Cond: (r.request_type = rt.id)
3. 0.379 5.051 ↓ 1.0 1,144 1

Hash Join (cost=178.65..284.72 rows=1,136 width=214) (actual time=2.622..5.051 rows=1,144 loops=1)

  • Hash Cond: (d.type = refterm.id)
4. 0.422 4.663 ↓ 1.0 1,144 1

Hash Join (cost=176.97..279.64 rows=1,136 width=230) (actual time=2.610..4.663 rows=1,144 loops=1)

  • Hash Cond: (udm.department_id = d.id)
5. 0.828 4.125 ↓ 1.0 1,144 1

Hash Join (cost=163.83..263.48 rows=1,136 width=209) (actual time=2.490..4.125 rows=1,144 loops=1)

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

  • Filter: is_active
  • Rows Removed by Filter: 20
7. 0.243 2.433 ↓ 1.0 286 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 82kB
8. 0.121 2.190 ↓ 1.0 286 1

Hash Join (cost=137.44..160.28 rows=284 width=225) (actual time=1.513..2.190 rows=286 loops=1)

  • Hash Cond: (r.event_id = e.id)
9. 0.123 1.522 ↓ 1.0 286 1

Hash Join (cost=67.84..89.94 rows=284 width=184) (actual time=0.963..1.522 rows=286 loops=1)

  • Hash Cond: (rd.attendee_id = a.id)
10. 0.122 1.275 ↓ 1.0 286 1

Hash Join (cost=51.95..73.29 rows=284 width=186) (actual time=0.831..1.275 rows=286 loops=1)

  • Hash Cond: (r.request_details_id = rd.id)
11. 0.167 1.031 ↓ 1.0 286 1

Hash Join (cost=36.86..57.44 rows=284 width=186) (actual time=0.697..1.031 rows=286 loops=1)

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

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

  • Filter: is_active
13. 0.294 0.683 ↑ 1.0 838 1

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

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

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

  • Filter: is_active
15. 0.042 0.122 ↓ 1.1 286 1

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

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

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

  • Filter: is_active
17. 0.049 0.124 ↑ 1.1 286 1

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

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

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

  • Filter: is_active
19. 0.200 0.547 ↑ 1.0 1,271 1

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

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

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

  • Filter: is_active
21. 0.053 0.116 ↑ 1.0 362 1

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

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

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

  • Filter: is_active
23. 0.004 0.009 ↑ 1.0 30 1

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

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

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

25. 0.001 0.010 ↓ 2.0 6 1

Hash (cost=1.06..1.06 rows=3 width=234) (actual time=0.010..0.010 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.008..0.009 rows=6 loops=1)

  • Filter: is_active
27. 0.005 0.045 ↑ 1.0 10 1

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

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

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

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