explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sUbt

Settings
# exclusive inclusive rows x rows loops node
1. 1,895.883 1,140,222.822 ↑ 346.4 1,624,520 1

Sort (cost=249,366,812.52..250,773,749.58 rows=562,774,823 width=139) (actual time=1,139,811.942..1,140,222.822 rows=1,624,520 loops=1)

  • Sort Key: journal.verification_date DESC
  • Sort Method: external merge Disk: 309,352kB
  • loops=3)
2. 60,849.149 1,138,326.939 ↑ 346.4 1,624,520 1

WindowAgg (cost=53,225,178.27..120,253,916.75 rows=562,774,823 width=139) (actual time=1,136,819.887..1,138,326.939 rows=1,624,520 loops=1)

3. 754.485 1,077,477.790 ↑ 346.4 1,624,520 1

Group (cost=53,225,178.27..113,219,231.47 rows=562,774,823 width=131) (actual time=517,870.796..1,077,477.790 rows=1,624,520 loops=1)

  • Group Key: journal.id, verification_type.description, organisation.inn
4. 168,535.719 1,076,723.305 ↑ 288.7 1,624,520 1

Gather Merge (cost=53,225,178.27..109,701,888.82 rows=468,979,020 width=131) (actual time=517,870.737..1,076,723.305 rows=1,624,520 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 10,089.802 908,187.586 ↑ 433.0 541,507 3 / 3

Group (cost=53,224,178.24..55,569,073.34 rows=234,489,510 width=131) (actual time=501,847.826..908,187.586 rows=541,507 loops=3)

  • Group Key: journal.id, verification_type.description, organisation.inn
6. 895,544.007 898,097.784 ↑ 4.0 58,862,851 3 / 3

Sort (cost=53,224,178.24..53,810,402.02 rows=234,489,510 width=131) (actual time=501,819.923..898,097.784 rows=58,862,851 loops=3)

  • Sort Key: journal.id, verification_type.description, organisation.inn
  • Sort Method: external merge Disk: 10,738,640kB
  • Worker 0: Sort Method: external merge Disk: 10,747,808kB
  • Worker 1: Sort Method: external merge Disk: 10,682,688kB
  • -> Parallel Hash Left Join (cost=37,234.23..1846851.51 rows=234,489,510 width=131) (actual time=205.797..16928.471 rows=58,862,851
  • Hash Cond: ((journal.developer_id)::text = (organisation.external_id)::text)
7. 222.680 2,351.414 ↑ 4.8 458,151 3 / 3

Hash Left Join (cost=2.50..342,708.72 rows=2,177,208 width=125) (actual time=0.598..2,351.414 rows=458,151 loops=3)

  • Hash Cond: ((journal.verification_type_id)::text = (verification_type.id)::text)
8. 2,125.412 2,125.412 ↑ 4.8 458,151 3 / 3

Parallel Seq Scan on journal (cost=0.00..335,890.08 rows=2,177,208 width=93) (actual time=0.024..2,125.412 rows=458,151 loops=3)

9. 3.277 3.322 ↓ 1.1 24 3 / 3

Hash (cost=2.22..2.22 rows=22 width=64) (actual time=0.069..3.322 rows=24 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
10. 0.045 0.045 ↓ 1.1 24 3 / 3

Seq Scan on verification_type (cost=0.00..2.22 rows=22 width=64) (actual time=0.038..0.045 rows=24 loops=3)

11. 71.201 202.363 ↑ 1.3 162,334 3 / 3

Parallel Hash (cost=34,670.77..34,670.77 rows=204,877 width=14) (actual time=202.363..202.363 rows=162,334 loops=3)

  • Buckets: 524,288 Batches: 1 Memory Usage: 27,264kB
12. 131.162 131.162 ↑ 1.3 162,334 3 / 3

Parallel Seq Scan on organisation (cost=0.00..34,670.77 rows=204,877 width=14) (actual time=0.017..131.162 rows=162,334 loops=3)

Planning time : 24.860 ms
Execution time : 1,141,500.983 ms