explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Upke

Settings
# exclusive inclusive rows x rows loops node
1. 46.388 201.269 ↓ 1.0 22,823 1

Gather (cost=1,000.09..17,610.53 rows=21,875 width=40) (actual time=0.386..201.269 rows=22,823 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 14.833 154.881 ↑ 1.1 11,412 2 / 2

Nested Loop (cost=0.09..14,423.03 rows=12,868 width=40) (actual time=0.153..154.881 rows=11,412 loops=2)

3. 14.522 14.522 ↑ 1.1 11,412 2 / 2

Parallel Index Scan using tb_tm_investor_billing_plan_id_plan_idx on tb_tm_investor_billing_plan (cost=0.04..378.66 rows=12,868 width=8) (actual time=0.040..14.522 rows=11,412 loops=2)

  • Index Cond: (id_plan = 16)
4. 125.526 125.526 ↑ 1.0 1 22,823 / 2

Index Scan using tb_investor_pk on tb_investor (cost=0.04..1.09 rows=1 width=28) (actual time=0.011..0.011 rows=1 loops=22,823)

  • Index Cond: (id_investor = tb_tm_investor_billing_plan.id_investor)
Planning time : 0.269 ms
Execution time : 202.293 ms