explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xrul

Settings
# exclusive inclusive rows x rows loops node
1. 22.473 403.470 ↑ 1.3 41,025 1

Hash Join (cost=1,768.87..467,598.11 rows=55,136 width=743) (actual time=29.397..403.470 rows=41,025 loops=1)

  • Hash Cond: (sapu.user_account_uid = pd.user_account_uid)
2. 29.637 377.256 ↑ 1.3 41,025 1

Hash Join (cost=1,325.47..466,396.59 rows=55,136 width=706) (actual time=25.640..377.256 rows=41,025 loops=1)

  • Hash Cond: (s.uid = sapu.screening_uid)
3. 38.818 322.252 ↑ 1.3 41,025 1

Nested Loop (cost=8.32..461,633.44 rows=55,136 width=703) (actual time=0.033..322.252 rows=41,025 loops=1)

4. 7.754 7.754 ↑ 1.0 55,136 1

Seq Scan on contact_info ci (cost=0.00..1,661.36 rows=55,136 width=646) (actual time=0.010..7.754 rows=55,136 loops=1)

5. 0.000 275.680 ↑ 1.0 1 55,136

Limit (cost=8.32..8.32 rows=1 width=65) (actual time=0.005..0.005 rows=1 loops=55,136)

6. 110.272 275.680 ↑ 1.0 1 55,136

Sort (cost=8.32..8.32 rows=1 width=65) (actual time=0.005..0.005 rows=1 loops=55,136)

  • Sort Key: s.creation DESC
  • Sort Method: quicksort Memory: 25kB
7. 165.408 165.408 ↑ 1.0 1 55,136

Index Scan using screening_patient_contact_info_uid_idx1 on screening s (cost=0.29..8.31 rows=1 width=65) (actual time=0.003..0.003 rows=1 loops=55,136)

  • Index Cond: (patient_contact_info_uid = ci.uid)
8. 14.141 25.367 ↑ 1.0 41,340 1

Hash (cost=800.40..800.40 rows=41,340 width=35) (actual time=25.367..25.367 rows=41,340 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 3,217kB
9. 11.226 11.226 ↑ 1.0 41,340 1

Seq Scan on screening_attributes_per_user sapu (cost=0.00..800.40 rows=41,340 width=35) (actual time=0.008..11.226 rows=41,340 loops=1)

  • Filter: has_access_right
10. 0.283 3.741 ↑ 1.0 909 1

Hash (cost=432.04..432.04 rows=909 width=69) (actual time=3.741..3.741 rows=909 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 85kB
11. 1.823 3.458 ↑ 1.0 909 1

Hash Join (cost=41.45..432.04 rows=909 width=69) (actual time=0.537..3.458 rows=909 loops=1)

  • Hash Cond: (ua.uid = pd.user_account_uid)
12. 1.123 1.123 ↑ 1.0 7,745 1

Seq Scan on user_account ua (cost=0.00..352.45 rows=7,745 width=32) (actual time=0.008..1.123 rows=7,745 loops=1)

13. 0.200 0.512 ↑ 1.0 909 1

Hash (cost=30.09..30.09 rows=909 width=37) (actual time=0.512..0.512 rows=909 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 71kB
14. 0.312 0.312 ↑ 1.0 909 1

Seq Scan on practice_details pd (cost=0.00..30.09 rows=909 width=37) (actual time=0.004..0.312 rows=909 loops=1)

Planning time : 1.583 ms
Execution time : 406.078 ms