#	exclusive	inclusive	rows x	rows	loops	node
1.	2.439	2.439	↓ 1.0	617	1	→ Seq Scan on plivo_billing_outgoingcharge (cost=0.00..1668.81 rows=614 width=8) (actual time=0.010..2.439 rows=617 loops=1) Filter: ((prefix)::text ~~ '1%'::text)

                                                         QUERY PLAN                                                          
-----------------------------------------------------------------------------------------------------------------------------
 Seq Scan on plivo_billing_outgoingcharge  (cost=0.00..1668.81 rows=614 width=8) (actual time=0.010..2.439 rows=617 loops=1)
   Filter: ((prefix)::text ~~ '1%'::text)
 Total runtime: 2.838 ms
(3 rows)

Per node type stats

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

Per table stats

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

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: aQ0

Colorize:

Columns visibility:

Per node type stats

Per table stats