explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VOWV

Settings
# exclusive inclusive rows x rows loops node
1. 0.025 13,571.321 ↑ 1.0 10 1

Limit (cost=0.43..735.88 rows=10 width=244) (actual time=366.483..13,571.321 rows=10 loops=1)

  • Output: id, code, name, startdate, enddate, created, changed, data
  • Buffers: shared hit=16808 read=1277
2. 13,571.296 13,571.296 ↑ 5,011.6 10 1

Index Scan using svjul_pkey on public.svjul (cost=0.43..3,685,771.22 rows=50,116 width=244) (actual time=366.480..13,571.296 rows=10 loops=1)

  • Output: id, code, name, startdate, enddate, created, changed, data
  • Filter: (to_tsvector('russian'::regconfig, (svjul.data)::text) @@ '''177'''::tsquery)
  • Rows Removed by Filter: 4317
  • Buffers: shared hit=16808 read=1277
Planning time : 0.836 ms
Execution time : 13,571.375 ms