explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yGzX

Settings
# exclusive inclusive rows x rows loops node
1. 737.845 737.845 ↑ 10.5 4 1

Seq Scan on safekids.person per (cost=0.00..32,224.00 rows=42 width=4) (actual time=31.121..737.845 rows=4 loops=1)

  • Output: id
  • Filter: (fullname(per.lastname, per.firstname, per.patrname) @@ to_tsquery('Киселев | Юдита | Петровна'::text))
  • Rows Removed by Filter: 41596
  • Buffers: shared hit=608
Planning time : 0.060 ms
Execution time : 737.858 ms