explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5Omt

Settings
# exclusive inclusive rows x rows loops node
1. 643.426 10,942.296 ↓ 1.0 759,737 1

Sort (cost=642,198.46..644,081.53 rows=753,230 width=139) (actual time=10,765.511..10,942.296 rows=759,737 loops=1)

  • Sort Key: journal.verification_date DESC
  • Sort Method: external merge Disk: 145,272kB
2. 768.960 10,298.870 ↓ 1.0 759,737 1

WindowAgg (cost=511,665.58..537,004.52 rows=753,230 width=139) (actual time=10,060.444..10,298.870 rows=759,737 loops=1)

3. 179.134 9,529.910 ↓ 1.0 759,737 1

Hash Left Join (cost=511,665.58..527,589.15 rows=753,230 width=131) (actual time=8,216.956..9,529.910 rows=759,737 loops=1)

  • Hash Cond: ((journal.verification_type_id)::text = (verification_type.id)::text)
4. 394.851 9,350.720 ↓ 1.0 759,737 1

Merge Left Join (cost=511,663.08..525,260.27 rows=753,230 width=99) (actual time=8,216.865..9,350.720 rows=759,737 loops=1)

  • Merge Cond: (((journal.developer_id)::text = (organisation.external_id)::text) AND ((journal.task_id)::text = (organisation.task_id)::text))
5. 2,421.400 6,373.916 ↓ 1.0 759,737 1

Sort (cost=417,795.53..419,678.61 rows=753,230 width=93) (actual time=5,998.651..6,373.916 rows=759,737 loops=1)

  • Sort Key: journal.developer_id, journal.task_id
  • Sort Method: external merge Disk: 77,936kB
6. 3,952.516 3,952.516 ↓ 1.0 759,737 1

Seq Scan on journal (cost=0.00..321,650.30 rows=753,230 width=93) (actual time=147.717..3,952.516 rows=759,737 loops=1)

7. 80.262 2,581.953 ↓ 2.4 1,173,289 1

Materialize (cost=93,867.55..96,326.07 rows=491,705 width=51) (actual time=2,217.338..2,581.953 rows=1,173,289 loops=1)

8. 2,136.574 2,501.691 ↑ 1.1 453,844 1

Sort (cost=93,867.55..95,096.81 rows=491,705 width=51) (actual time=2,217.333..2,501.691 rows=453,844 loops=1)

  • Sort Key: organisation.external_id, organisation.task_id
  • Sort Method: external merge Disk: 30,016kB
9. 365.117 365.117 ↑ 1.0 487,001 1

Seq Scan on organisation (cost=0.00..37,539.05 rows=491,705 width=51) (actual time=0.028..365.117 rows=487,001 loops=1)

10. 0.015 0.056 ↓ 1.1 24 1

Hash (cost=2.22..2.22 rows=22 width=64) (actual time=0.055..0.056 rows=24 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
11. 0.041 0.041 ↓ 1.1 24 1

Seq Scan on verification_type (cost=0.00..2.22 rows=22 width=64) (actual time=0.033..0.041 rows=24 loops=1)

Planning time : 7.712 ms
Execution time : 11,034.042 ms