#	exclusive	inclusive	rows x	rows	loops	node
1.	0.003	151,950.872	↓ 0.0	0	1	→ Limit (cost=77,589.10..77,589.34 rows=95 width=1,104) (actual time=151,950.872..151,950.872 rows=0 loops=1)
2.	0.063	151,950.869	↓ 0.0	0	1	→ Sort (cost=77,589.10..77,589.34 rows=95 width=1,104) (actual time=151,950.869..151,950.869 rows=0 loops=1) Sort Key: call.uuid Sort Method: quicksort Memory: 25kB
3.	1.523	151,950.806	↓ 0.0	0	1	→ Hash Join (cost=12,715.66..77,585.98 rows=95 width=1,104) (actual time=151,950.806..151,950.806 rows=0 loops=1) Hash Cond: (call.uuid = params.uuidl)
4.	687.905	771.981	↑ 32.2	583	1	→ Bitmap Heap Scan on tbl_contact_interaction call (cost=1,450.45..66,083.65 rows=18,782 width=1,104) (actual time=98.047..771.981 rows=583 loops=1) Recheck Cond: ((projectuuid)::text = 'corebo00000000000mpo2fdiqgpttrkg'::text) Filter: ((type)::text = 'Voice'::text) Heap Blocks: exact=453
5.	84.076	84.076	↑ 33.2	583	1	→ Bitmap Index Scan on idx_contact_int_project (cost=0.00..1,445.75 rows=19,359 width=0) (actual time=84.076..84.076 rows=583 loops=1) Index Cond: ((projectuuid)::text = 'corebo00000000000mpo2fdiqgpttrkg'::text)
6.	94.871	151,177.302	↓ 1.0	60,370	1	→ Hash (cost=10,540.93..10,540.93 rows=57,942 width=8) (actual time=151,177.302..151,177.302 rows=60,370 loops=1) Buckets: 65,536 Batches: 1 Memory Usage: 2,871kB
7.	151,082.431	151,082.431	↓ 1.0	60,370	1	→ Index Scan using idx_call_listening_state on tbl_phone_call_qmparam params (cost=0.56..10,540.93 rows=57,942 width=8) (actual time=31.252..151,082.431 rows=60,370 loops=1) Index Cond: (listeningstate = 1) Filter: (fcr <> '-1'::integer)

Planning time	:	293.576 ms
Execution time	:	151,951.665 ms

Limit  (cost=77589.10..77589.34 rows=95 width=1104) (actual time=151950.872..151950.872 rows=0 loops=1)
   ->  Sort  (cost=77589.10..77589.34 rows=95 width=1104) (actual time=151950.869..151950.869 rows=0 loops=1)
         Sort Key: call.uuid
         Sort Method: quicksort  Memory: 25kB
         ->  Hash Join  (cost=12715.66..77585.98 rows=95 width=1104) (actual time=151950.806..151950.806 rows=0 loops=1)
               Hash Cond: (call.uuid = params.uuidl)
               ->  Bitmap Heap Scan on tbl_contact_interaction call  (cost=1450.45..66083.65 rows=18782 width=1104) (actual time=98.047..771.981 rows=583 loops=1)
                     Recheck Cond: ((projectuuid)::text = 'corebo00000000000mpo2fdiqgpttrkg'::text)
                     Filter: ((type)::text = 'Voice'::text)
                     Heap Blocks: exact=453
                     ->  Bitmap Index Scan on idx_contact_int_project  (cost=0.00..1445.75 rows=19359 width=0) (actual time=84.076..84.076 rows=583 loops=1)
                           Index Cond: ((projectuuid)::text = 'corebo00000000000mpo2fdiqgpttrkg'::text)
               ->  Hash  (cost=10540.93..10540.93 rows=57942 width=8) (actual time=151177.302..151177.302 rows=60370 loops=1)
                     Buckets: 65536  Batches: 1  Memory Usage: 2871kB
                     ->  Index Scan using idx_call_listening_state on tbl_phone_call_qmparam params  (cost=0.56..10540.93 rows=57942 width=8) (actual time=31.252..151082.431 rows=60370 loops=1)
                           Index Cond: (listeningstate = 1)
                           Filter: (fcr <> '-1'::integer)
 Planning time: 293.576 ms
 Execution time: 151951.665 ms
(19 rows)

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	687.905 ms	0.5 %
Bitmap Index Scan	1	84.076 ms	0.1 %
Hash	1	94.871 ms	0.1 %
Hash Join	1	1.523 ms	0.0 %
Index Scan	1	151,082.431 ms	99.4 %
Limit	1	0.003 ms	0.0 %
Sort	1	0.063 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
tbl_contact_interaction	1	687.905 ms	0.5 %
Bitmap Heap Scan	1	687.905 ms	100.0 %
tbl_phone_call_qmparam	1	151,082.431 ms	99.4 %
Index Scan	1	151,082.431 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H1JB

Color mode:

Visible columns:

Per node type stats

Per table stats