explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2hsv

Settings
# exclusive inclusive rows x rows loops node
1. 0.960 91.717 ↑ 1.0 51 1

Limit (cost=1.27..242.64 rows=51 width=24) (actual time=4.109..91.717 rows=51 loops=1)

2. 2.164 90.757 ↑ 1,835.1 51 1

Nested Loop (cost=1.27..442,934.15 rows=93,591 width=24) (actual time=4.092..90.757 rows=51 loops=1)

3. 15.512 54.066 ↑ 1,835.1 51 1

Nested Loop (cost=0.85..395,902.91 rows=93,591 width=40) (actual time=2.489..54.066 rows=51 loops=1)

4. 15.004 15.004 ↑ 510.7 785 1

Index Scan Backward using idx_thread_date_updated on thread (cost=0.42..69,926.85 rows=400,911 width=24) (actual time=2.304..15.004 rows=785 loops=1)

  • Filter: (NOT anonymized)
5. 23.550 23.550 ↓ 0.0 0 785

Index Scan using idx_thread_participant_thread_id on thread_participant_organization (cost=0.43..0.80 rows=1 width=16) (actual time=0.029..0.030 rows=0 loops=785)

  • Index Cond: (thread_id = thread.id)
  • Filter: (has_contributed AND (organization_type = 'OPERATOR'::text) AND (organization_id = '8bc90562-4eeb-4c7b-8207-ad38c5e43331'::text))
  • Rows Removed by Filter: 3
6. 34.527 34.527 ↑ 1.0 1 51

Index Scan using idx_thread_entity_thread_id on thread_entity (cost=0.42..0.49 rows=1 width=16) (actual time=0.668..0.677 rows=1 loops=51)

  • Index Cond: (thread_id = thread.id)
  • Filter: (entity_type = ANY ('{MMP_ORDER,MMP_OFFER,MPS_ORDER}'::text[]))
Planning time : 0.786 ms
Execution time : 92.183 ms