explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cAcp

Settings
# exclusive inclusive rows x rows loops node
1. 0.124 26,678.336 ↑ 1.0 1 1

Aggregate (cost=255,331.19..255,331.20 rows=1 width=8) (actual time=26,678.336..26,678.336 rows=1 loops=1)

  • Buffers: shared hit=24873 read=517592
2. 0.112 26,678.212 ↑ 1,171.0 854 1

Limit (cost=0.00..242,831.19 rows=1,000,000 width=120) (actual time=15,205.724..26,678.212 rows=854 loops=1)

  • Buffers: shared hit=24873 read=517592
3. 26,678.100 26,678.100 ↑ 3,376.5 854 1

Seq Scan on katastar (cost=0.00..700,218.54 rows=2,883,561 width=120) (actual time=15,205.723..26,678.100 rows=854 loops=1)

  • Filter: (the_geom && '0103000020110F00000100000005000000107E01A8501A374138BE79C5F6945541107E01A8501A3741F915FE842896554114DD12A6171F3741F915FE842896554114DD12A6171F374138BE79C5F6945541107E01A8501A374138BE79C5F6945541'::geometry)
  • Rows Removed by Filter: 14416949
  • Buffers: shared hit=24873 read=517592
Planning time : 0.091 ms
Execution time : 26,678.357 ms