explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nlUg : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #88f1; plan #8l1n; plan #WF1s; plan #IQfk; plan #h6JT

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1,372.813 2,301.260 ↓ 1.0 13,875,937 1

Result (cost=0.94..296,329.03 rows=13,875,909 width=60) (actual time=6.406..2,301.260 rows=13,875,937 loops=1)

  • One-Time Filter: ($1 = ANY ('{51,400,407,410,411,420}'::integer[]))
  • JIT:
  • Functions: 13
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 0.667 ms, Inlining 0.000 ms, Optimization 0.340 ms, Emission 5.868 ms, Total 6.875 ms
2.          

Initplan (for Result)

3. 0.001 0.004 ↑ 1.0 1 1

Limit (cost=0.43..0.46 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=1)

4. 0.003 0.003 ↑ 13,875,909.0 1 1

Index Scan Backward using campaigns_actionworkflowitemstatus_fde81f11 on campaigns_actionworkflowitemstatus u0 (cost=0.43..407,651.73 rows=13,875,909 width=12) (actual time=0.003..0.003 rows=1 loops=1)

  • Filter: (action_workflow_item_id IS NOT NULL)
5. 0.004 0.072 ↑ 1.0 1 1

Limit (cost=0.43..0.46 rows=1 width=12) (actual time=0.071..0.072 rows=1 loops=1)

6. 0.068 0.068 ↑ 13,875,909.0 1 1

Index Scan Backward using campaigns_actionworkflowitemstatus_fde81f11 on campaigns_actionworkflowitemstatus u0_1 (cost=0.43..407,651.73 rows=13,875,909 width=12) (actual time=0.068..0.068 rows=1 loops=1)

  • Filter: (action_workflow_item_id IS NOT NULL)
7. 928.371 928.371 ↓ 1.0 13,875,937 1

Seq Scan on campaigns_actionworkflowitemstatus (cost=0.01..296,328.10 rows=13,875,909 width=56) (actual time=0.014..928.371 rows=13,875,937 loops=1)

Planning time : 1.180 ms
Execution time : 2,638.314 ms