explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zNIb

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 12,060.018 ↓ 0.0 0 1

Limit (cost=57,343.32..57,343.35 rows=10 width=24) (actual time=12,060.018..12,060.018 rows=0 loops=1)

2. 0.019 12,060.002 ↓ 0.0 0 1

Sort (cost=57,343.32..57,343.35 rows=10 width=24) (actual time=12,060.002..12,060.002 rows=0 loops=1)

  • Sort Key: thread.date_updated DESC, thread.id DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.016 12,059.983 ↓ 0.0 0 1

Nested Loop (cost=16,606.34..57,343.16 rows=10 width=24) (actual time=12,059.983..12,059.983 rows=0 loops=1)

4. 3,743.421 12,059.967 ↓ 0.0 0 1

Hash Join (cost=16,605.91..57,307.38 rows=44 width=40) (actual time=12,059.967..12,059.967 rows=0 loops=1)

  • Hash Cond: (thread.id = thread_entity.thread_id)
  • Join Filter: (((thread.topic_type = 'FREE_TEXT'::text) AND (thread.topic_value ~~* '%test%'::text)) OR (thread_entity.entity_id ~~* '%test%'::text))
  • Rows Removed by Join Filter: 400,911
5. 2,791.776 2,791.776 ↑ 1.0 400,911 1

Seq Scan on thread (cost=0.00..20,043.11 rows=400,911 width=66) (actual time=0.018..2,791.776 rows=400,911 loops=1)

  • Filter: (NOT anonymized)
6. 2,750.322 5,524.770 ↑ 1.0 400,911 1

Hash (cost=8,853.53..8,853.53 rows=400,911 width=28) (actual time=5,524.770..5,524.770 rows=400,911 loops=1)

  • Buckets: 65,536 Batches: 8 Memory Usage: 3,443kB
7. 2,774.448 2,774.448 ↑ 1.0 400,911 1

Seq Scan on thread_entity (cost=0.00..8,853.53 rows=400,911 width=28) (actual time=0.020..2,774.448 rows=400,911 loops=1)

  • Filter: (entity_type = ANY ('{MMP_ORDER,MMP_OFFER,MPS_ORDER}'::text[]))
8. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_thread_participant_thread_id on thread_participant_organization (cost=0.43..0.80 rows=1 width=16) (never executed)

  • Index Cond: (thread_id = thread.id)
  • Filter: (has_contributed AND (organization_type = 'OPERATOR'::text) AND (organization_id = '8bc90562-4eeb-4c7b-8207-ad38c5e43331'::text))
Planning time : 1.428 ms
Execution time : 12,060.092 ms