explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2nRp

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.187 ↑ 2.5 40 1

Limit (cost=1.03..265.84 rows=100 width=140) (actual time=0.026..0.187 rows=40 loops=1)

2. 0.013 0.184 ↑ 46.9 40 1

Merge Left Join (cost=1.03..4,966.19 rows=1,875 width=140) (actual time=0.026..0.184 rows=40 loops=1)

  • Merge Cond: (t1.id = t3.interaction_id)
3. 0.008 0.164 ↑ 26.8 40 1

Merge Left Join (cost=0.88..4,874.91 rows=1,070 width=136) (actual time=0.022..0.164 rows=40 loops=1)

  • Merge Cond: (t1.id = t4.interaction_id)
4. 0.006 0.152 ↑ 24.2 40 1

Nested Loop (cost=0.72..4,795.91 rows=970 width=104) (actual time=0.018..0.152 rows=40 loops=1)

5. 0.014 0.106 ↑ 24.2 40 1

Nested Loop (cost=0.57..4,585.50 rows=970 width=56) (actual time=0.014..0.106 rows=40 loops=1)

6. 0.012 0.012 ↑ 24.2 40 1

Index Scan using call_interaction_pkey on call_interaction t1 (cost=0.15..62.70 rows=970 width=56) (actual time=0.005..0.012 rows=40 loops=1)

7. 0.080 0.080 ↑ 1.0 1 40

Index Only Scan using call_pkey on call t0 (cost=0.42..4.66 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=40)

  • Index Cond: (id = t1.call_id)
  • Heap Fetches: 4
8. 0.040 0.040 ↑ 1.0 1 40

Index Scan using lisa_user_pkey on lisa_user t2 (cost=0.15..0.22 rows=1 width=80) (actual time=0.001..0.001 rows=1 loops=40)

  • Index Cond: (id = t1.user_id)
9. 0.004 0.004 ↑ 133.8 8 1

Index Scan using call_comment_pkey on call_comment t4 (cost=0.15..64.20 rows=1,070 width=48) (actual time=0.002..0.004 rows=8 loops=1)

10. 0.007 0.007 ↑ 53.1 32 1

Index Scan using call_review_pkey on call_review t3 (cost=0.15..73.65 rows=1,700 width=20) (actual time=0.003..0.007 rows=32 loops=1)

Planning time : 0.427 ms
Execution time : 0.221 ms