explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DuVD

Settings
# exclusive inclusive rows x rows loops node
1. 3,060.026 4,138.914 ↑ 1.0 1 1

Aggregate (cost=58,867.47..58,867.50 rows=1 width=37) (actual time=4,138.913..4,138.914 rows=1 loops=1)

  • Buffers: shared hit=12239 read=3748, temp read=2776 written=2776
  • I/O Timings: read=17.586
2. 726.367 1,078.888 ↑ 1.0 553,672 1

Hash Join (cost=3,581.26..57,483.29 rows=553,672 width=37) (actual time=84.721..1,078.888 rows=553,672 loops=1)

  • Hash Cond: ((medicaldev2_.manufacturer_id)::text = (manufactur1_.id)::text)
  • Buffers: shared hit=12239 read=3748
  • I/O Timings: read=17.586
3. 267.831 267.831 ↑ 1.0 553,672 1

Seq Scan on medical_device medicaldev2_ (cost=0.00..31,755.16 rows=553,672 width=70) (actual time=0.003..267.831 rows=553,672 loops=1)

  • Buffers: shared hit=12209 read=2936
  • I/O Timings: read=12.726
4. 20.730 84.690 ↑ 1.0 26,478 1

Hash (cost=2,720.72..2,720.72 rows=26,478 width=36) (actual time=84.690..84.690 rows=26,478 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 1777kB
  • Buffers: shared hit=30 read=812
  • I/O Timings: read=4.860
5. 39.571 63.960 ↑ 1.0 26,478 1

Hash Join (cost=189.65..2,720.72 rows=26,478 width=36) (actual time=2.048..63.960 rows=26,478 loops=1)

  • Hash Cond: ((manufactur1_.company_id)::text = (company0_.id)::text)
  • Buffers: shared hit=30 read=812
  • I/O Timings: read=4.860
6. 22.382 22.382 ↑ 1.0 26,478 1

Seq Scan on manufacturer manufactur1_ (cost=0.00..1,604.34 rows=26,478 width=72) (actual time=0.029..22.382 rows=26,478 loops=1)

  • Buffers: shared hit=22 read=788
  • I/O Timings: read=4.765
7. 1.004 2.007 ↑ 1.0 1,887 1

Hash (cost=128.32..128.32 rows=1,887 width=36) (actual time=2.007..2.007 rows=1,887 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 127kB
  • Buffers: shared hit=8 read=24
  • I/O Timings: read=0.095
8. 1.003 1.003 ↑ 1.0 1,887 1

Index Only Scan using company_pk on company company0_ (cost=0.28..128.32 rows=1,887 width=36) (actual time=0.020..1.003 rows=1,887 loops=1)

  • Heap Fetches: 12
  • Buffers: shared hit=8 read=24
  • I/O Timings: read=0.095
Planning time : 1.165 ms
Execution time : 4,139.012 ms