explain.depesz.com

PostgreSQL's explain analyze made readable

Result: drro

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 562.445 ↑ 1.0 100 1

Limit (cost=70,556.60..70,556.85 rows=100 width=12) (actual time=562.429..562.445 rows=100 loops=1)

2. 18.914 562.435 ↑ 2,568.6 100 1

Sort (cost=70,556.60..71,198.75 rows=256,861 width=12) (actual time=562.427..562.435 rows=100 loops=1)

  • Sort Key: (round(date_part('epoch'::text, updated_at))), id_outfit
  • Sort Method: top-N heapsort Memory: 29kB
3. 543.521 543.521 ↑ 1.4 190,150 1

Seq Scan on outfit (cost=0.00..60,739.55 rows=256,861 width=12) (actual time=0.604..543.521 rows=190,150 loops=1)

  • Filter: (((deleted_at IS NOT NULL) OR private_flag OR (NOT export_flag)) AND (round(date_part('epoch'::text, updated_at)) >= '1257894000'::double precision))
  • Rows Removed by Filter: 809850
Planning time : 0.089 ms
Execution time : 562.469 ms