explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ysWG : FreshPorts: packages DELETE

Settings
# exclusive inclusive rows x rows loops node
1. 0.076 52.662 ↓ 0.0 0 1

Delete on packages p (cost=3.08..6,108.16 rows=19,353 width=12) (actual time=52.662..52.662 rows=0 loops=1)

  • Buffers: shared hit=35,880
2. 11.269 52.586 ↑ 537.6 36 1

Merge Anti Join (cost=3.08..6,108.16 rows=19,353 width=12) (actual time=23.933..52.586 rows=36 loops=1)

  • Merge Cond: (p.package_name = pr.package_name)
  • Join Filter: ((p.abi_id = pr.abi_id) AND (p.package_set = pr.package_set))
  • Buffers: shared hit=35,844
3. 15.736 15.736 ↓ 1.6 31,384 1

Index Scan using packages_all_idx on packages p (cost=0.42..6,057.09 rows=19,354 width=28) (actual time=0.018..15.736 rows=31,384 loops=1)

  • Index Cond: ((abi_id = 11) AND (package_set = 'latest'::package_sets))
  • Buffers: shared hit=27,257
4. 10.692 25.581 ↓ 31,383.0 31,383 1

Sort (cost=2.66..2.66 rows=1 width=29) (actual time=23.518..25.581 rows=31,383 loops=1)

  • Sort Key: pr.package_name
  • Sort Method: quicksort Memory: 3,278kB
  • Buffers: shared hit=8,587
5. 14.889 14.889 ↓ 31,383.0 31,383 1

Index Scan using packages_raw_all on packages_raw pr (cost=0.42..2.65 rows=1 width=29) (actual time=0.021..14.889 rows=31,383 loops=1)

  • Index Cond: ((abi_id = 11) AND (package_set = 'latest'::package_sets))
  • Filter: (abi = 'FreeBSD:13:amd64'::text)
  • Buffers: shared hit=8,587
Planning time : 0.421 ms
Execution time : 52.712 ms