explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N6KT : FreshPorts: package UPDATE

Settings
# exclusive inclusive rows x rows loops node
1. 41.206 305.336 ↓ 0.0 0 1

Update on packages p (cost=15,321.52..26,841.38 rows=17,989 width=69) (actual time=305.336..305.336 rows=0 loops=1)

  • Buffers: shared hit=9,313 read=7,201 dirtied=1,105 written=10
  • I/O Timings: read=72.845
2. 19.725 264.130 ↑ 38.4 469 1

Hash Join (cost=15,321.52..26,841.38 rows=17,989 width=69) (actual time=234.095..264.130 rows=469 loops=1)

  • Hash Cond: ((pr.abi_id = p.abi_id) AND (pr.package_name = p.package_name))
  • Join Filter: (p.package_version <> pr.package_version)
  • Rows Removed by Join Filter: 30,880
  • Buffers: shared hit=154 read=6,374 dirtied=135
  • I/O Timings: read=48.906
3. 16.200 34.032 ↓ 1.6 31,401 1

Bitmap Heap Scan on packages_raw pr (cost=480.97..11,900.62 rows=19,088 width=36) (actual time=17.957..34.032 rows=31,401 loops=1)

  • Recheck Cond: ((abi = 'FreeBSD:13:amd64'::text) AND (package_set = 'latest'::package_sets))
  • Heap Blocks: exact=530
  • Buffers: shared read=1,668
  • I/O Timings: read=17.758
4. 17.832 17.832 ↓ 3.3 62,784 1

Bitmap Index Scan on packages_raw_abi_package_set_idx (cost=0.00..476.20 rows=19,088 width=0) (actual time=17.832..17.832 rows=62,784 loops=1)

  • Index Cond: ((abi = 'FreeBSD:13:amd64'::text) AND (package_set = 'latest'::package_sets))
  • Buffers: shared read=773
  • I/O Timings: read=10.732
5. 96.391 210.373 ↑ 1.0 275,766 1

Hash (cost=10,655.10..10,655.10 rows=279,030 width=47) (actual time=210.372..210.373 rows=275,766 loops=1)

  • Buckets: 524,288 Batches: 1 Memory Usage: 26,085kB
  • Buffers: shared hit=154 read=4,706 dirtied=135
  • I/O Timings: read=31.148
6. 113.982 113.982 ↑ 1.0 275,766 1

Seq Scan on packages p (cost=0.00..10,655.10 rows=279,030 width=47) (actual time=0.023..113.982 rows=275,766 loops=1)

  • Filter: (package_set = 'latest'::package_sets)
  • Rows Removed by Filter: 183,263
  • Buffers: shared hit=154 read=4,706 dirtied=135
  • I/O Timings: read=31.148
Planning time : 0.583 ms
Execution time : 308.639 ms