explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H1JB

Settings
# 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: 65536 Batches: 1 Memory Usage: 2871kB
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