#	exclusive	inclusive	rows x	node
1.	0.000	0.000	↓ 0.0	→ Index Scan using idx_index_1 on inode (cost=34772.40..404652805.05 rows=100391 width=36) (actual time=.. rows= loops=) Index Cond: ((type)::text = 'contentlet'::text) Filter: (NOT (SubPlan 1))
2.				SubPlan (forIndex Scan)
3.	0.000	0.000	↓ 0.0	→ Materialize (cost=34772.40..38306.40 rows=198400 width=36) (actual time=.. rows= loops=)
4.	0.000	0.000	↓ 0.0	→ Seq Scan on contentlet (cost=0.00..33024.00 rows=198400 width=36) (actual time=.. rows= loops=)

 Index Scan using idx_index_1 on inode  (cost=34772.40..404652805.05 rows=100391 width=36)
   Index Cond: ((type)::text = 'contentlet'::text)
   Filter: (NOT (SubPlan 1))
   SubPlan 1
     ->  Materialize  (cost=34772.40..38306.40 rows=198400 width=36)
           ->  Seq Scan on contentlet  (cost=0.00..33024.00 rows=198400 width=36)

Per node type stats

node type	count	sum of times	% of query
Index Scan	1	0.000 ms	0.0 %
Materialize	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
contentlet	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
inode	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: m5aj

Colorize:

Columns visibility:

Per node type stats

Per table stats