explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yWwC : getDeletesAn

Settings
# exclusive inclusive rows x rows loops node
1. 7,815.342 79,655.300 ↓ 1.5 61,830,050 1

Group (cost=9,292,253.50..15,732,210.11 rows=40,079,721 width=12) (actual time=46,792.556..79,655.300 rows=61,830,050 loops=1)

  • Group Key: s.partid, s.datid
2. 15,218.868 71,839.958 ↓ 1.4 70,731,843 1

Gather Merge (cost=9,292,253.50..15,472,900.01 rows=51,862,020 width=12) (actual time=46,792.549..71,839.958 rows=70,731,843 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 5,332.273 56,621.090 ↑ 1.1 23,577,281 3 / 3

Group (cost=9,291,253.48..9,485,736.05 rows=25,931,010 width=12) (actual time=46,492.614..56,621.090 rows=23,577,281 loops=3)

  • Group Key: s.partid, s.datid
4. 23,570.088 51,288.817 ↑ 1.0 25,180,418 3 / 3

Sort (cost=9,291,253.48..9,356,081.00 rows=25,931,010 width=12) (actual time=46,492.510..51,288.817 rows=25,180,418 loops=3)

  • Sort Key: s.partid, s.datid
  • Sort Method: external merge Disk: 675,200kB
  • Worker 0: Sort Method: external merge Disk: 614,200kB
  • Worker 1: Sort Method: external merge Disk: 632,576kB
5. 13,135.841 27,718.729 ↑ 1.0 25,180,418 3 / 3

Hash Join (cost=7.95..4,768,607.71 rows=25,931,010 width=12) (actual time=191.003..27,718.729 rows=25,180,418 loops=3)

  • Hash Cond: (s.an_id = c.an_id)
6. 14,391.959 14,391.959 ↑ 1.2 133,600,325 3 / 3

Parallel Seq Scan on def_sync_set_an s (cost=0.00..4,223,262.39 rows=166,998,839 width=16) (actual time=0.050..14,391.959 rows=133,600,325 loops=3)

7. 0.007 190.929 ↑ 1.0 3 3 / 3

Hash (cost=7.91..7.91 rows=3 width=4) (actual time=190.928..190.929 rows=3 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
8. 190.922 190.922 ↑ 1.0 3 3 / 3

Seq Scan on con_ressource_an c (cost=0.00..7.91 rows=3 width=4) (actual time=190.865..190.922 rows=3 loops=3)

  • Filter: ((kid)::text = 'tp.edi'::text)
  • Rows Removed by Filter: 390