explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HLy1

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 6,548.328 ↑ 1.0 1 1

Aggregate (cost=348,722.94..348,722.95 rows=1 width=8) (actual time=6,548.327..6,548.328 rows=1 loops=1)

2. 6,548.323 6,548.323 ↓ 0.0 0 1

Seq Scan on fields (cost=0.00..348,722.94 rows=1 width=4) (actual time=6,548.322..6,548.323 rows=0 loops=1)

  • Filter: ((uuid)::text = '1234567'::text)
  • Rows Removed by Filter: 6700
Planning time : 0.094 ms
Execution time : 6,548.367 ms