explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oOOc

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 14,073.614 ↑ 1.0 100 1
→

Limit (cost=7,944.51..7,944.76 rows=100 width=78) (actual time=14,073.584..14,073.614 rows=100 loops=1)

2. 26.711 14,073.603 ↑ 19.0 100 1
→

Sort (cost=7,944.51..7,949.27 rows=1,904 width=78) (actual time=14,073.582..14,073.603 rows=100 loops=1)

  • Sort Key: element_id
  • Sort Method: top-N heapsort Memory: 114kB
3. 13,935.593 14,046.892 ↓ 22.6 42,951 1
→

Bitmap Heap Scan on core_storedchunk chunk (cost=254.76..7,871.74 rows=1,904 width=78) (actual time=118.186..14,046.892 rows=42,951 loops=1)

  • Recheck Cond: (core_storedchunk_tsvector(chunk.*) @@ '''liabil'' & ''limit'''::tsquery)
  • Heap Blocks: exact=30,354
4. 111.299 111.299 ↓ 24.1 45,845 1
→

Bitmap Index Scan on core_storedchunk_tsvector (cost=0.00..254.28 rows=1,904 width=0) (actual time=111.294..111.299 rows=45,845 loops=1)

  • Index Cond: (core_storedchunk_tsvector(chunk.*) @@ '''liabil'' & ''limit'''::tsquery)
Planning time : 5.934 ms
Execution time : 14,074.270 ms