explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CgoD

Settings
# exclusive inclusive rows x rows loops node
1. 0.673 956.549 ↑ 1.0 51 1

Limit (cost=1.70..15,657.59 rows=51 width=24) (actual time=16.403..956.549 rows=51 loops=1)

2. 1.571 955.876 ↑ 25.7 51 1

Nested Loop (cost=1.70..402,757.02 rows=1,312 width=24) (actual time=16.387..955.876 rows=51 loops=1)

3. 34.723 952.775 ↑ 25.7 51 1

Nested Loop (cost=1.28..402,097.72 rows=1,312 width=56) (actual time=16.333..952.775 rows=51 loops=1)

4. 335.029 886.189 ↑ 2.3 2,451 1

Nested Loop Semi Join (cost=0.85..397,528.16 rows=5,620 width=40) (actual time=0.384..886.189 rows=2,451 loops=1)

5. 187.428 187.428 ↑ 18.7 21,396 1

Index Scan Backward using toto4 on thread (cost=0.42..75,505.02 rows=400,911 width=24) (actual time=0.033..187.428 rows=21,396 loops=1)

  • Filter: (NOT anonymized)
6. 363.732 363.732 ↓ 0.0 0 21,396

Index Scan using idx_thread_participant_thread_id on thread_participant_organization sub_thread_participant (cost=0.43..0.80 rows=1 width=16) (actual time=0.017..0.017 rows=0 loops=21,396)

  • Index Cond: (thread_id = thread.id)
  • Filter: (has_contributed AND (organization_type = 'SHOP'::text) AND (organization_id = '2630'::text))
  • Rows Removed by Filter: 3
7. 31.863 31.863 ↓ 0.0 0 2,451

Index Scan using idx_thread_participant_thread_id on thread_participant_organization (cost=0.43..0.80 rows=1 width=16) (actual time=0.012..0.013 rows=0 loops=2,451)

  • 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
8. 1.530 1.530 ↑ 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.023..0.030 rows=1 loops=51)

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