explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GUey

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 1.479 ↓ 9.2 101 1

Group (cost=1,051.44..1,051.52 rows=11 width=27) (actual time=1.459..1.479 rows=101 loops=1)

  • Group Key: ng.terms, nng.weight
2.          

CTE input_rows

3. 0.026 0.026 ↑ 1.0 121 1

Values Scan on "*VALUES*" (cost=0.00..1.51 rows=121 width=32) (actual time=0.002..0.026 rows=121 loops=1)

4. 0.136 1.463 ↓ 11.0 121 1

Sort (cost=1,049.92..1,049.95 rows=11 width=27) (actual time=1.458..1.463 rows=121 loops=1)

  • Sort Key: ng.terms, nng.weight
  • Sort Method: quicksort Memory: 33kB
5. 0.086 1.327 ↓ 11.0 121 1

Nested Loop (cost=0.84..1,049.73 rows=11 width=27) (actual time=0.061..1.327 rows=121 loops=1)

6. 0.093 0.636 ↑ 1.0 121 1

Nested Loop (cost=0.42..963.06 rows=121 width=23) (actual time=0.037..0.636 rows=121 loops=1)

7. 0.059 0.059 ↑ 1.0 121 1

CTE Scan on input_rows ir (cost=0.00..2.42 rows=121 width=32) (actual time=0.003..0.059 rows=121 loops=1)

8. 0.484 0.484 ↑ 1.0 1 121

Index Scan using ngrams_terms_idx on ngrams ng (cost=0.42..7.94 rows=1 width=23) (actual time=0.004..0.004 rows=1 loops=121)

  • Index Cond: ((terms)::text = ir.terms)
9. 0.605 0.605 ↑ 1.0 1 121

Index Scan using node_node_ngrams_node1_id_node2_id_ngrams_id_ngrams_type_idx on node_node_ngrams nng (cost=0.42..0.72 rows=1 width=12) (actual time=0.005..0.005 rows=1 loops=121)

  • Index Cond: ((node1_id = 1771) AND (node2_id = 11791) AND (ngrams_id = ng.id) AND (ngrams_type = 4))
Planning time : 0.839 ms
Execution time : 1.561 ms