explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hQkD

Settings
# exclusive inclusive rows x rows loops node
1. 38.007 66.884 ↓ 1.0 28,087 1

Sort (cost=10,340.01..10,409.94 rows=27,971 width=156) (actual time=58.447..66.884 rows=28,087 loops=1)

  • Sort Key: id DESC
  • Sort Method: external merge Disk: 4784kB
2. 28.877 28.877 ↓ 1.0 28,087 1

Seq Scan on images (cost=0.00..6,072.62 rows=27,971 width=156) (actual time=0.014..28.877 rows=28,087 loops=1)

  • Filter: (((status)::text <> 'Deleted'::text) AND (organisation_id = 8))
  • Rows Removed by Filter: 44039