explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r7Za

Settings
# exclusive inclusive rows x rows loops node
1. 10.529 44.565 ↓ 1.1 36,589 1

Hash Left Join (cost=4,282.78..5,168.83 rows=33,996 width=69) (actual time=25.865..44.565 rows=36,589 loops=1)

  • Hash Cond: (tbl_users.public_user_id = group_users.id)
  • Join Filter: (tbl_users.user_type = 4)
  • Rows Removed by Join Filter: 125
2. 7.651 25.664 ↓ 1.1 36,589 1

Hash Right Join (cost=2,902.52..3,261.93 rows=33,996 width=39) (actual time=17.398..25.664 rows=36,589 loops=1)

  • Hash Cond: (party_user_report_xref.user_id = tbl_users.id)
  • Join Filter: (tbl_users.user_type = 4)
3. 0.813 0.813 ↑ 1.0 11,990 1

Seq Scan on party_user_report_xref (cost=0.00..196.90 rows=11,990 width=12) (actual time=0.020..0.813 rows=11,990 loops=1)

4. 6.800 17.200 ↑ 1.0 33,955 1

Hash (cost=2,477.57..2,477.57 rows=33,996 width=35) (actual time=17.200..17.200 rows=33,955 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2766kB
5. 10.400 10.400 ↑ 1.0 33,955 1

Seq Scan on tbl_users (cost=0.00..2,477.57 rows=33,996 width=35) (actual time=0.017..10.400 rows=33,955 loops=1)

  • Filter: (user_type = ANY ('{1,2,4}'::integer[]))
  • Rows Removed by Filter: 8620
6. 3.083 8.372 ↓ 1.0 18,163 1

Hash (cost=1,153.26..1,153.26 rows=18,160 width=37) (actual time=8.372..8.372 rows=18,163 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1484kB
7. 3.514 5.289 ↓ 1.0 18,163 1

Hash Left Join (cost=94.96..1,153.26 rows=18,160 width=37) (actual time=0.234..5.289 rows=18,163 loops=1)

  • Hash Cond: (group_users.group_id = groups.id)
8. 1.563 1.563 ↓ 1.0 18,163 1

Seq Scan on group_users (cost=0.00..808.60 rows=18,160 width=8) (actual time=0.012..1.563 rows=18,163 loops=1)

9. 0.091 0.212 ↑ 1.0 576 1

Hash (cost=87.76..87.76 rows=576 width=33) (actual time=0.212..0.212 rows=576 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 45kB
10. 0.121 0.121 ↑ 1.0 576 1

Seq Scan on groups (cost=0.00..87.76 rows=576 width=33) (actual time=0.006..0.121 rows=576 loops=1)

Planning time : 0.364 ms
Execution time : 45.988 ms