explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EB5D

Settings
# exclusive inclusive rows x rows loops node
1. 0.046 7.045 ↑ 11.8 16 1

Nested Loop (cost=205.36..1,327.05 rows=188 width=1,590) (actual time=3.726..7.045 rows=16 loops=1)

2. 0.004 0.006 ↑ 1.0 3 1

Append (cost=0.00..0.06 rows=3 width=36) (actual time=0.001..0.006 rows=3 loops=1)

3. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=1)

4. 0.002 0.002 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=1)

5. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=1)

6. 0.045 6.993 ↑ 12.6 5 3

Bitmap Heap Scan on search s (cost=205.36..441.70 rows=63 width=1,554) (actual time=2.323..2.331 rows=5 loops=3)

  • Recheck Cond: ((fulltext @@ ('''vliegen'''::tsquery)) AND ((language)::oid = (('english'::regconfig))::oid))
  • Heap Blocks: exact=16
7. 0.030 6.948 ↓ 0.0 0 3

BitmapAnd (cost=205.36..205.36 rows=63 width=0) (actual time=2.316..2.316 rows=0 loops=3)

8. 0.066 0.066 ↑ 20.9 9 3

Bitmap Index Scan on search_fulltext (cost=0.00..17.41 rows=188 width=0) (actual time=0.022..0.022 rows=9 loops=3)

  • Index Cond: (fulltext @@ ('''vliegen'''::tsquery))
9. 6.852 6.852 ↑ 1.0 12,539 3

Bitmap Index Scan on search_language (cost=0.00..187.67 rows=12,539 width=0) (actual time=2.284..2.284 rows=12,539 loops=3)

  • Index Cond: ((language)::oid = (('english'::regconfig))::oid)
Planning time : 0.234 ms
Execution time : 7.088 ms