explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b1d8

Settings
# exclusive inclusive rows x rows loops node
1. 240.760 13,223.395 ↑ 11.6 47,801 1

Sort (cost=199,249.42..200,629.69 rows=552,106 width=52) (actual time=13,120.251..13,223.395 rows=47,801 loops=1)

  • Sort Key: f.created DESC
  • Sort Method: external merge Disk: 3,080kB
2. 1,813.203 12,982.635 ↑ 11.6 47,801 1

GroupAggregate (cost=116,679.34..127,721.46 rows=552,106 width=52) (actual time=9,384.275..12,982.635 rows=47,801 loops=1)

  • Group Key: s.dataset, f.id
3. 3,953.391 11,169.432 ↓ 1.4 790,049 1

Sort (cost=116,679.34..118,059.60 rows=552,106 width=52) (actual time=9,384.232..11,169.432 rows=790,049 loops=1)

  • Sort Key: s.dataset, f.id
  • Sort Method: external merge Disk: 50,984kB
4. 3,411.404 7,216.041 ↓ 1.4 790,049 1

Merge Join (cost=36,133.31..45,151.37 rows=552,106 width=52) (actual time=1,203.202..7,216.041 rows=790,049 loops=1)

  • Merge Cond: (f.content_id = s.dataset)
5. 246.180 359.974 ↑ 1.0 47,934 1

Sort (cost=7,102.07..7,224.22 rows=48,858 width=44) (actual time=251.848..359.974 rows=47,934 loops=1)

  • Sort Key: f.content_id
  • Sort Method: external merge Disk: 2,760kB
6. 113.794 113.794 ↓ 1.0 49,049 1

Seq Scan on files f (cost=0.00..3,296.94 rows=48,858 width=44) (actual time=0.012..113.794 rows=49,049 loops=1)

  • Filter: (content_type <> 1)
  • Rows Removed by Filter: 649
7. 2,037.552 3,444.663 ↓ 3.9 790,516 1

Materialize (cost=29,031.22..30,032.63 rows=200,281 width=24) (actual time=951.342..3,444.663 rows=790,516 loops=1)

8. 960.239 1,407.111 ↑ 1.0 196,758 1

Sort (cost=29,031.22..29,531.92 rows=200,281 width=24) (actual time=951.334..1,407.111 rows=196,758 loops=1)

  • Sort Key: s.dataset
  • Sort Method: external merge Disk: 6,528kB
9. 446.872 446.872 ↑ 1.0 196,758 1

Seq Scan on analysis_status s (cost=0.00..7,285.81 rows=200,281 width=24) (actual time=0.014..446.872 rows=196,758 loops=1)

Planning time : 0.306 ms
Execution time : 13,338.440 ms