explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j62z

Settings
# exclusive inclusive rows x rows loops node
1. 0.760 8,073.418 ↑ 1.0 50 1

Limit (cost=39,112.53..39,112.78 rows=50 width=28) (actual time=8,071.680..8,073.418 rows=50 loops=1)

2. 0.695 8,072.658 ↑ 3,442.2 50 1

Unique (cost=39,112.53..39,973.08 rows=172,110 width=28) (actual time=8,071.666..8,072.658 rows=50 loops=1)

3. 1,289.690 8,071.963 ↑ 3,442.2 50 1

Sort (cost=39,112.53..39,542.80 rows=172,110 width=28) (actual time=8,071.649..8,071.963 rows=50 loops=1)

  • Sort Key: qm.object_id, qm.uploaded DESC
  • Sort Method: quicksort Memory: 19,571kB
4. 2,514.673 6,782.273 ↑ 1.0 171,854 1

Hash Join (cost=7,352.94..24,145.01 rows=172,110 width=28) (actual time=2,941.390..6,782.273 rows=171,854 loops=1)

  • Hash Cond: (qm.object_id = qo.id)
5. 1,326.412 1,326.412 ↑ 1.0 174,786 1

Seq Scan on qbank_media qm (cost=0.00..16,333.17 rows=174,814 width=16) (actual time=0.014..1,326.412 rows=174,786 loops=1)

  • Filter: ((replacedby IS NULL) AND ((parent_id IS NULL) OR (parent_id = id)) AND (mediastatus_id = 4))
  • Rows Removed by Filter: 92
6. 1,482.378 2,941.188 ↑ 1.0 195,133 1

Hash (cost=4,913.34..4,913.34 rows=195,168 width=4) (actual time=2,941.176..2,941.188 rows=195,133 loops=1)

  • Buckets: 262,144 Batches: 1 Memory Usage: 8,909kB
7. 1,458.810 1,458.810 ↑ 1.0 195,133 1

Seq Scan on qbank_object qo (cost=0.00..4,913.34 rows=195,168 width=4) (actual time=0.018..1,458.810 rows=195,133 loops=1)

  • Filter: (NOT deleted)
  • Rows Removed by Filter: 3,101
Planning time : 0.334 ms
Execution time : 8,077.617 ms