explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JfE7

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 39,312.696 ↓ 0.0 0 1

Limit (cost=7,042,289.880..8,870,605.250 rows=426 width=57) (actual time=39,312.696..39,312.696 rows=0 loops=1)

2. 96.500 39,312.694 ↓ 0.0 0 1

Merge Join (cost=7,042,289.880..8,870,605.250 rows=426 width=57) (actual time=39,312.694..39,312.694 rows=0 loops=1)

  • Merge Cond: ((sierra.bravo = quebec.bravo) AND (sierra.yankee = quebec.yankee))
3. 72.641 498.403 ↑ 2.0 51,944 1

Sort (cost=107,599.240..107,857.400 rows=103,261 width=53) (actual time=489.205..498.403 rows=51,944 loops=1)

  • Sort Key: sierra.bravo, sierra.yankee
  • Sort Method: external merge Disk: 3272kB
4. 425.762 425.762 ↑ 2.0 51,944 1

Seq Scan on kilo sierra (cost=0.000..95,468.200 rows=103,261 width=53) (actual time=0.059..425.762 rows=51,944 loops=1)

  • Filter: (whiskey five NULL)
  • Rows Removed by Filter: 1163623
5. 0.000 38,717.791 ↑ 6.0 945,606 1

Finalize GroupAggregate (cost=6,934,690.640..8,677,229.880 rows=5,666,494 width=57) (actual time=30,203.887..38,717.791 rows=945,606 loops=1)

  • Group Key: quebec.bravo, quebec.yankee
6. 1,228.092 38,746.171 ↑ 7.2 1,580,765 1

Gather Merge (cost=6,934,690.640..8,535,567.530 rows=11,332,988 width=57) (actual time=30,203.867..38,746.171 rows=1,580,765 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
7. 2,742.275 37,518.079 ↑ 10.8 527,007 3 / 3

Partial GroupAggregate (cost=6,933,690.620..7,226,459.490 rows=5,666,494 width=57) (actual time=30,007.655..37,518.079 rows=527,007 loops=3)

  • Group Key: quebec.bravo, quebec.yankee
8. 27,593.829 34,775.804 ↑ 1.3 18,886,684 3 / 3

Sort (cost=6,933,690.620..6,992,716.600 rows=23,610,393 width=49) (actual time=30,007.639..34,775.804 rows=18,886,684 loops=3)

  • Sort Key: quebec.bravo, quebec.yankee
  • Sort Method: external merge Disk: 1100064kB
  • Worker 0: Sort Method: external merge Disk: 1112024kB
  • Worker 1: Sort Method: external merge Disk: 1117024kB
9. 7,181.975 7,181.975 ↑ 1.3 18,886,864 3 / 3

Parallel Seq Scan on quebec (cost=0.000..1,621,257.930 rows=23,610,393 width=49) (actual time=0.126..7,181.975 rows=18,886,864 loops=3)

Planning time : 0.560 ms
Execution time : 40,149.159 ms