explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L4ZR

Settings
# exclusive inclusive rows x rows loops node
1. 0.942 48.682 ↑ 1.0 51 1

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

2. 1.688 47.740 ↑ 1,835.1 51 1

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

3. 14.414 44.318 ↑ 1,835.1 51 1

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

4. 11.064 11.064 ↑ 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=0.036..11.064 rows=785 loops=1)

  • Filter: (NOT anonymized)
5. 18.840 18.840 ↓ 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.023..0.024 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. 1.734 1.734 ↑ 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.026..0.034 rows=1 loops=51)

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