explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ISz

Settings
# exclusive inclusive rows x rows loops node
1. 30,132.832 39,247.923 ↓ 0.0 0 1

Update on firedrill_vendorproductqueryresult vpqr (cost=296,658.33..623,778.28 rows=1,091,162 width=707) (actual time=39,247.923..39,247.923 rows=0 loops=1)

2. 2,837.575 9,115.091 ↑ 2.5 440,472 1

Hash Join (cost=296,658.33..623,778.28 rows=1,091,162 width=707) (actual time=3,553.862..9,115.091 rows=440,472 loops=1)

  • Hash Cond: (vpqr.phase_result_id = pr.id)
3. 2,724.899 2,724.899 ↑ 2.5 440,472 1

Seq Scan on firedrill_vendorproductqueryresult vpqr (cost=0.00..107,546.62 rows=1,091,162 width=653) (actual time=0.028..2,724.899 rows=440,472 loops=1)

4. 797.367 3,552.617 ↓ 1.0 2,480,156 1

Hash (cost=246,405.70..246,405.70 rows=2,473,970 width=38) (actual time=3,552.617..3,552.617 rows=2,480,156 loops=1)

  • Buckets: 65536 Batches: 64 Memory Usage: 3144kB
5. 2,755.250 2,755.250 ↓ 1.0 2,480,156 1

Seq Scan on firedrill_phaseresult pr (cost=0.00..246,405.70 rows=2,473,970 width=38) (actual time=0.010..2,755.250 rows=2,480,156 loops=1)