#	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

                                                                         QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------------------
 Nested Loop  (cost=0.87..957.82 rows=1 width=54) (actual time=78.007..121936.545 rows=785 loops=1)
   Join Filter: (txt_te.data ~~* (('%'::text || (img_te.filename)::text) || '%'::text))
   Rows Removed by Join Filter: 837430
   ->  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
   ->  Materialize  (cost=0.43..477.44 rows=10 width=54) (actual time=0.000..0.966 rows=2661 loops=315)
         ->  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=2661 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: 121937.167 ms
(14 rows)

Per node type stats

node type	count	sum of times	% of query
Index Scan	2	21.023 ms	0.0 %
Materialize	1	290.153 ms	0.2 %
Nested Loop	1	121,625.369 ms	99.7 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
theme_entry	2	21.023 ms	0.0 %
Index Scan	2	21.023 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DIQW

Color mode:

Visible columns:

Per node type stats

Per table stats