explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ajRA

Settings
# exclusive inclusive rows x rows loops node
1. 2,934.388 3,928.118 ↑ 1.0 1 1

Aggregate (cost=58,867.47..58,867.50 rows=1 width=37) (actual time=3,928.117..3,928.118 rows=1 loops=1)

  • Buffers: shared hit=15753 read=234, temp read=2776 written=2776
  • I/O Timings: read=2.757
2. 678.581 993.730 ↑ 1.0 553,672 1

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

  • Hash Cond: ((medicaldev2_.manufacturer_id)::text = (manufactur1_.id)::text)
  • Buffers: shared hit=15753 read=234
  • I/O Timings: read=2.757
3. 248.033 248.033 ↑ 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.006..248.033 rows=553,672 loops=1)

  • Buffers: shared hit=14947 read=198
  • I/O Timings: read=1.087
4. 16.182 67.116 ↑ 1.0 26,478 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 1777kB
  • Buffers: shared hit=806 read=36
  • I/O Timings: read=1.670
5. 31.715 50.934 ↑ 1.0 26,478 1

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

  • Hash Cond: ((manufactur1_.company_id)::text = (company0_.id)::text)
  • Buffers: shared hit=806 read=36
  • I/O Timings: read=1.670
6. 13.409 13.409 ↑ 1.0 26,478 1

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

  • Buffers: shared hit=803 read=7
  • I/O Timings: read=0.045
7. 2.174 5.810 ↑ 1.0 1,887 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 127kB
  • Buffers: shared hit=3 read=29
  • I/O Timings: read=1.625
8. 3.636 3.636 ↑ 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.086..3.636 rows=1,887 loops=1)

  • Heap Fetches: 12
  • Buffers: shared hit=3 read=29
  • I/O Timings: read=1.625