explain.depesz.com

A tool for finding a real cause for slow queries.

Result: EuzQ

options
exclusive inclusive rows x rows loops node
272.612 1572.893 ↓ 10.3 161815 1
→

Result (cost=0.00..66262.41 rows=15651 width=8) (actual time=0.405..1572.893 rows=161815 loops=1)

282.597 1300.281 ↓ 10.3 161815 1
→

Append (cost=0.00..66262.41 rows=15651 width=8) (actual time=0.401..1300.281 rows=161815 loops=1)

268.381 268.381 ↑ 3.0 1727 1
→

Seq Scan on tsv_test (cost=0.00..22035.30 rows=5217 width=8) (actual time=0.398..268.381 rows=1727 loops=1)

  • Filter: (v @@ '''lexeme3179'''::tsquery)
422.665 422.665 ↓ 11.5 60088 1
→

Seq Scan on tsv_test (cost=0.00..22035.30 rows=5217 width=8) (actual time=0.048..422.665 rows=60088 loops=1)

  • Filter: (v @@ '''lexeme5'''::tsquery)
326.638 326.638 ↓ 19.2 100000 1
→

Seq Scan on tsv_test (cost=0.00..22035.30 rows=5217 width=8) (actual time=0.025..326.638 rows=100000 loops=1)

  • Filter: (v @@ '''fooblablabla'''::tsquery)