explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DIQW

Settings
# exclusive inclusive rows x rows loops node
1. 121,625.369 121,936.545 ↓ 785.0 785 1

Nested Loop (cost=0.87..957.82 rows=1 width=54) (actual time=78.007..121,936.545 rows=785 loops=1)

  • Join Filter: (txt_te.data ~~* (('%'::text || (img_te.filename)::text) || '%'::text))
  • Rows Removed by Join Filter: 837430
2. 6.886 6.886 ↓ 26.2 315 1

Index Scan using theme_entry_theme_id on theme_entry txt_te (cost=0.43..478.00 rows=12 width=540) (actual time=0.057..6.886 rows=315 loops=1)

  • Index Cond: (theme_id = 2318782173::bigint)
  • Filter: (lower("right"((filename)::text, 3)) = ANY ('{txt,css,.js,htm,tml}'::text[]))
  • Rows Removed by Filter: 3987
3. 290.153 304.290 ↓ 266.1 2,661 315

Materialize (cost=0.43..477.44 rows=10 width=54) (actual time=0.000..0.966 rows=2,661 loops=315)

4. 14.137 14.137 ↓ 266.1 2,661 1

Index Scan using theme_entry_theme_id on theme_entry img_te (cost=0.43..477.39 rows=10 width=54) (actual time=0.024..14.137 rows=2,661 loops=1)

  • Index Cond: (theme_id = 2318782173::bigint)
  • Filter: (lower("right"((filename)::text, 3)) = ANY ('{jpg,gif,.peg,svg}'::text[]))
  • Rows Removed by Filter: 1641
Planning time : 0.239 ms
Execution time : 121,937.167 ms