explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LCRE

Settings
# exclusive inclusive rows x rows loops node
1. 440.929 3,428.535 ↑ 1.0 1 1

Aggregate (cost=922,420.60..922,420.61 rows=1 width=8) (actual time=3,428.535..3,428.535 rows=1 loops=1)

  • Buffers: shared hit=208846
2. 2,987.606 2,987.606 ↑ 1.0 5,746,940 1

Seq Scan on projects (cost=0.00..908,053.18 rows=5,746,969 width=0) (actual time=0.041..2,987.606 rows=5,746,940 loops=1)

  • Filter: (visibility_level = ANY ('{0,20}'::integer[]))
  • Rows Removed by Filter: 65677
  • Buffers: shared hit=208846
Planning time : 2.861 ms
Execution time : 3,428.596 ms