explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x66k : s

Settings
# exclusive inclusive rows x rows loops node
1. 4,700.705 141,823.540 ↓ 400.1 16,723,566 1

Gather (cost=1,006.00..155,182.05 rows=41,803 width=302) (actual time=0.711..141,823.540 rows=16,723,566 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 7,128.130 137,122.835 ↓ 320.0 5,574,522 3 / 3

Nested Loop (cost=6.00..149,818.86 rows=17,418 width=302) (actual time=0.598..137,122.835 rows=5,574,522 loops=3)

3. 7,504.997 74,249.485 ↓ 320.0 5,574,522 3 / 3

Nested Loop (cost=5.57..141,332.46 rows=17,418 width=251) (actual time=0.558..74,249.485 rows=5,574,522 loops=3)

4. 4,704.994 5,424.746 ↓ 320.0 5,574,522 3 / 3

Hash Join (cost=5.01..130,869.12 rows=17,418 width=175) (actual time=0.513..5,424.746 rows=5,574,522 loops=3)

  • Hash Cond: (lpad((claim_services_eob.eob_cd)::text, 5, '0'::text) = (e.eob_reason)::text)
5. 719.706 719.706 ↑ 1.2 2,787,261 3 / 3

Parallel Seq Scan on claim_services_eob (cost=0.00..104,562.96 rows=3,483,596 width=25) (actual time=0.368..719.706 rows=2,787,261 loops=3)

6. 0.015 0.046 ↓ 18.0 18 3 / 3

Hash (cost=5.00..5.00 rows=1 width=268) (actual time=0.046..0.046 rows=18 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
7. 0.031 0.031 ↓ 18.0 18 3 / 3

Seq Scan on eob_explanation e (cost=0.00..5.00 rows=1 width=268) (actual time=0.022..0.031 rows=18 loops=3)

8. 61,319.742 61,319.742 ↑ 3.0 1 16,723,566 / 3

Index Scan using claim_services_pkey on claim_services (cost=0.56..0.69 rows=3 width=80) (actual time=0.011..0.011 rows=1 loops=16,723,566)

  • Index Cond: ((profile_id = claim_services_eob.profile_id) AND (line_number = claim_services_eob.line_number))
9. 55,745.220 55,745.220 ↑ 1.0 1 16,723,566 / 3

Index Scan using claim_pkey on claim (cost=0.43..0.48 rows=1 width=25) (actual time=0.010..0.010 rows=1 loops=16,723,566)

  • Index Cond: (profile_id = claim_services.profile_id)
Planning time : 2.819 ms
Execution time : 143,076.606 ms