explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pul9

Settings
# exclusive inclusive rows x rows loops node
1. 0.031 0.050 ↑ 1.0 1 1

Index Scan using contractdelivery_pkey on contractdelivery cdp (cost=0.42..8.47 rows=1 width=20) (actual time=0.049..0.050 rows=1 loops=1)

  • Index Cond: (contractdeliveryid = 914,596)
2.          

SubPlan (for Index Scan)

3. 0.006 0.019 ↑ 1.0 1 1

Aggregate (cost=6.02..6.03 rows=1 width=8) (actual time=0.019..0.019 rows=1 loops=1)

4. 0.000 0.013 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.13..6.02 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=1)

5. 0.004 0.013 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.71..5.55 rows=1 width=4) (actual time=0.012..0.013 rows=0 loops=1)

6. 0.009 0.009 ↓ 0.0 0 1

Index Scan using crmprocessdelivery_contractdeliveryid_idx on crmprocessdelivery crm (cost=0.29..2.31 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (contractdeliveryid = cdp.contractdeliveryid)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using transactioncrossref_externaltxid_idx on transactioncrossref tcr (cost=0.42..3.23 rows=1 width=20) (never executed)

  • Index Cond: ((externaltxid)::text = (crm.externaltxid)::text)
  • Filter: (((type)::text = 'STANDARD'::text) AND ((counterpart)::text = 'BackOffice'::text))
8. 0.000 0.000 ↓ 0.0 0

Index Scan using process_pkey on process p (cost=0.42..0.47 rows=1 width=12) (never executed)

  • Index Cond: (processid = tcr.processid)
  • Filter: (((type)::text = ANY ('{Activation,CustomerSwitch,Gain,GainDispute}'::text[])) AND ((status)::text <> ALL ('{Started,Rejected,Cancelled,ToConfirm}'::text[])))
Planning time : 1.236 ms
Execution time : 0.159 ms