explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0y9U

Settings
# exclusive inclusive rows x rows loops node
1. 0.808 39.094 ↑ 1.0 51 1

Limit (cost=1.27..245.68 rows=51 width=24) (actual time=0.266..39.094 rows=51 loops=1)

2. 1.780 38.286 ↑ 1,835.1 51 1

Nested Loop (cost=1.27..448,512.32 rows=93,591 width=24) (actual time=0.198..38.286 rows=51 loops=1)

3. 14.134 35.282 ↑ 1,835.1 51 1

Nested Loop (cost=0.85..401,481.07 rows=93,591 width=40) (actual time=0.158..35.282 rows=51 loops=1)

4. 7.803 7.803 ↑ 510.7 785 1

Index Scan Backward using toto4 on thread (cost=0.42..75,505.02 rows=400,911 width=24) (actual time=0.029..7.803 rows=785 loops=1)

  • Filter: (NOT anonymized)
5. 13.345 13.345 ↓ 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.016..0.017 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.224 1.224 ↑ 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.016..0.024 rows=1 loops=51)

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