#	exclusive	inclusive	rows x	rows	loops	node
1.	0.072	0.072	↑ 1.0	1	1	→ Seq Scan on dim_payinstrument (cost=0.00..2.04 rows=1 width=65) (actual time=0.068..0.072 rows=1 loops=1) Filter: (((payment_instrument)::text = 'WALLET'::text) AND ((sub_payment_type_name)::text = 'Normal'::text)) Rows Removed by Filter: 68

"Seq Scan on dim_payinstrument  (cost=0.00..2.04 rows=1 width=65) (actual time=0.068..0.072 rows=1 loops=1)"
"  Filter: (((payment_instrument)::text = 'WALLET'::text) AND ((sub_payment_type_name)::text = 'Normal'::text))"
"  Rows Removed by Filter: 68"
"Planning Time: 169.636 ms"
"Execution Time: 0.096 ms"

Per node type stats

node type	count	sum of times	% of query
Seq Scan	1	0.072 ms	100.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
dim_payinstrument	1	0.072 ms	100.0 %
Seq Scan	1	0.072 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PfEo

Color mode:

Visible columns:

Per node type stats

Per table stats