explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NVge

Settings
# exclusive inclusive rows x rows loops node
1. 2,980.408 14,798.291 ↓ 1.2 571,036 1

Gather Merge (cost=552,166.79..607,543.69 rows=474,626 width=926) (actual time=11,636.295..14,798.291 rows=571,036 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 1,639.991 11,817.883 ↑ 1.2 190,345 3 / 3

Sort (cost=551,166.76..551,760.05 rows=237,313 width=926) (actual time=11,573.105..11,817.883 rows=190,345 loops=3)

  • Sort Key: ride_complete_report.appointment_fk, rs.id
  • Sort Method: external merge Disk: 84160kB
  • Worker 0: Sort Method: external merge Disk: 85768kB
  • Worker 1: Sort Method: external merge Disk: 82184kB
3. 2,507.204 10,177.892 ↑ 1.2 190,345 3 / 3

Hash Left Join (cost=111,008.13..336,925.95 rows=237,313 width=926) (actual time=5,481.342..10,177.892 rows=190,345 loops=3)

  • Hash Cond: (dynamite_claims.payer_id = org_payers.id)
4. 313.905 7,670.584 ↑ 1.2 190,345 3 / 3

Hash Left Join (cost=111,005.40..322,060.10 rows=237,313 width=763) (actual time=5,479.430..7,670.584 rows=190,345 loops=3)

  • Hash Cond: (dynamite_claims.claims_adjuster_id = dynamite_claims_adjuster.id)
5. 345.273 7,354.091 ↑ 1.2 190,345 3 / 3

Hash Left Join (cost=110,933.75..321,365.47 rows=237,313 width=740) (actual time=5,476.811..7,354.091 rows=190,345 loops=3)

  • Hash Cond: (organisations.market_segment_id = market_segments.id)
6. 428.907 7,008.290 ↑ 1.2 190,345 3 / 3

Hash Left Join (cost=110,916.54..320,719.50 rows=237,313 width=726) (actual time=5,476.266..7,008.290 rows=190,345 loops=3)

  • Hash Cond: (appointments.dynamite_claims_id = dynamite_claims.id)
7. 426.678 6,447.906 ↑ 1.2 190,345 3 / 3

Hash Join (cost=108,475.84..275,438.85 rows=237,313 width=696) (actual time=5,344.606..6,447.906 rows=190,345 loops=3)

  • Hash Cond: (ride_complete_report.org_fk = organisations.id)
8. 1,209.869 6,003.456 ↑ 1.2 194,979 3 / 3

Parallel Hash Join (cost=108,177.98..274,500.69 rows=243,723 width=613) (actual time=5,326.765..6,003.456 rows=194,979 loops=3)

  • Hash Cond: (rs.id = ride_complete_report.ride_details_fk)
9. 942.058 1,790.661 ↑ 1.3 201,368 3 / 3

Parallel Hash Left Join (cost=10,275.88..139,170.06 rows=251,737 width=460) (actual time=1,357.861..1,790.661 rows=201,368 loops=3)

  • Hash Cond: (rs.patient_id = patients.id)
10. 653.361 653.361 ↑ 1.3 201,368 3 / 3

Parallel Seq Scan on ride_details rs (cost=0.00..100,114.37 rows=251,737 width=416) (actual time=0.012..653.361 rows=201,368 loops=3)

11. 92.107 195.242 ↑ 1.2 88,036 3 / 3

Parallel Hash (cost=7,825.39..7,825.39 rows=110,039 width=56) (actual time=195.241..195.242 rows=88,036 loops=3)

  • Buckets: 65536 Batches: 8 Memory Usage: 3584kB
12. 103.135 103.135 ↑ 1.2 88,036 3 / 3

Parallel Seq Scan on patients (cost=0.00..7,825.39 rows=110,039 width=56) (actual time=0.012..103.135 rows=88,036 loops=3)

13. 294.770 3,002.926 ↑ 1.2 194,979 3 / 3

Parallel Hash (cost=89,380.57..89,380.57 rows=243,723 width=153) (actual time=3,002.925..3,002.926 rows=194,979 loops=3)

  • Buckets: 32768 Batches: 32 Memory Usage: 2368kB
14. 518.587 2,708.156 ↑ 1.2 194,979 3 / 3

Parallel Hash Join (cost=65,076.99..89,380.57 rows=243,723 width=153) (actual time=2,394.271..2,708.156 rows=194,979 loops=3)

  • Hash Cond: (ride_complete_report.appointment_fk = appointments.id)
15. 476.822 1,769.418 ↑ 1.2 194,979 3 / 3

Parallel Hash Left Join (cost=31,322.62..47,961.41 rows=243,723 width=40) (actual time=1,493.827..1,769.418 rows=194,979 loops=3)

  • Hash Cond: (ride_complete_report.appointment_fk = invoices.appt_id)
16. 446.555 1,044.438 ↑ 1.2 194,979 3 / 3

Parallel Hash Join (cost=21,225.71..33,345.71 rows=243,723 width=24) (actual time=772.583..1,044.438 rows=194,979 loops=3)

  • Hash Cond: (ride_complete_report.receipts_fk = receipts.id)
17. 172.664 172.664 ↑ 1.2 194,979 3 / 3

Parallel Seq Scan on ride_complete_report (cost=0.00..7,904.23 rows=243,723 width=16) (actual time=0.009..172.664 rows=194,979 loops=3)

18. 170.511 425.219 ↑ 1.3 195,547 3 / 3

Parallel Hash (cost=16,975.76..16,975.76 rows=244,476 width=16) (actual time=425.219..425.219 rows=195,547 loops=3)

  • Buckets: 131072 Batches: 16 Memory Usage: 2816kB
19. 254.708 254.708 ↑ 1.3 195,547 3 / 3

Parallel Seq Scan on receipts (cost=0.00..16,975.76 rows=244,476 width=16) (actual time=0.008..254.708 rows=195,547 loops=3)

20. 129.379 248.158 ↑ 1.2 139,269 3 / 3

Parallel Hash (cost=6,899.85..6,899.85 rows=174,085 width=20) (actual time=248.157..248.158 rows=139,269 loops=3)

  • Buckets: 65536 Batches: 8 Memory Usage: 3456kB
21. 118.779 118.779 ↑ 1.2 139,269 3 / 3

Parallel Seq Scan on invoices (cost=0.00..6,899.85 rows=174,085 width=20) (actual time=0.010..118.779 rows=139,269 loops=3)

22. 157.222 420.151 ↑ 1.3 146,274 3 / 3

Parallel Hash (cost=28,253.61..28,253.61 rows=182,861 width=117) (actual time=420.150..420.151 rows=146,274 loops=3)

  • Buckets: 32768 Batches: 32 Memory Usage: 1216kB
23. 262.929 262.929 ↑ 1.3 146,274 3 / 3

Parallel Seq Scan on appointments (cost=0.00..28,253.61 rows=182,861 width=117) (actual time=0.007..262.929 rows=146,274 loops=3)

24. 5.740 17.772 ↓ 1.0 5,021 3 / 3

Hash (cost=235.16..235.16 rows=5,016 width=91) (actual time=17.772..17.772 rows=5,021 loops=3)

  • Buckets: 8192 Batches: 1 Memory Usage: 642kB
25. 12.032 12.032 ↓ 1.0 5,021 3 / 3

Seq Scan on organisations (cost=0.00..235.16 rows=5,016 width=91) (actual time=0.011..12.032 rows=5,021 loops=3)

26. 73.607 131.477 ↑ 1.0 64,120 3 / 3

Hash (cost=1,138.20..1,138.20 rows=64,120 width=38) (actual time=131.476..131.477 rows=64,120 loops=3)

  • Buckets: 65536 Batches: 2 Memory Usage: 1681kB
27. 57.870 57.870 ↑ 1.0 64,120 3 / 3

Seq Scan on dynamite_claims (cost=0.00..1,138.20 rows=64,120 width=38) (actual time=0.014..57.870 rows=64,120 loops=3)

28. 0.270 0.528 ↓ 1.0 459 3 / 3

Hash (cost=11.54..11.54 rows=454 width=22) (actual time=0.527..0.528 rows=459 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 34kB
29. 0.258 0.258 ↓ 1.0 459 3 / 3

Seq Scan on market_segments (cost=0.00..11.54 rows=454 width=22) (actual time=0.012..0.258 rows=459 loops=3)

30. 1.401 2.588 ↑ 1.0 2,162 3 / 3

Hash (cost=44.62..44.62 rows=2,162 width=31) (actual time=2.588..2.588 rows=2,162 loops=3)

  • Buckets: 4096 Batches: 1 Memory Usage: 172kB
31. 1.187 1.187 ↑ 1.0 2,162 3 / 3

Seq Scan on dynamite_claims_adjuster (cost=0.00..44.62 rows=2,162 width=31) (actual time=0.012..1.187 rows=2,162 loops=3)

32. 0.052 0.104 ↑ 1.0 77 3 / 3

Hash (cost=1.77..1.77 rows=77 width=29) (actual time=0.104..0.104 rows=77 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
33. 0.052 0.052 ↑ 1.0 77 3 / 3

Seq Scan on org_payers (cost=0.00..1.77 rows=77 width=29) (actual time=0.013..0.052 rows=77 loops=3)

Planning time : 9.783 ms
Execution time : 16,542.724 ms