explain.depesz.com

A tool for finding a real cause for slow queries.

Result: UF6

options
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0
→

Nested Loop Left Join (cost=12.80..343.25 rows=6 width=142) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=12.80..341.56 rows=6 width=138) (actual time=.. rows= loops=)

3. 0.000 0.000 ↓ 0.0
→

Hash Join (cost=12.80..307.85 rows=6 width=4) (actual time=.. rows= loops=)

  • Hash Cond: (usagexrefn0_."USG_UsageID" = usagenovas2_."ID")
4. 0.000 0.000 ↓ 0.0
→

Seq Scan on usg_xref_novasummary_billablecharge usagexrefn0_ (cost=0.00..234.17 rows=16217 width=8) (actual time=.. rows= loops=)

5. 0.000 0.000 ↓ 0.0
→

Hash (cost=11.90..11.90 rows=72 width=4) (actual time=.. rows= loops=)

6. 0.000 0.000 ↓ 0.0
→

Index Scan using "USG_Nova_Summary_USG_RequestID_index" on "USG_Nova_Summary" usagenovas2_ (cost=0.00..11.90 rows=72 width=4) (actual time=.. rows= loops=)

  • Index Cond: (("USG_RequestID")::text = '20120501040534991'::text)
7. 0.000 0.000 ↓ 0.0
→

Index Scan using "BIL_BillableCharge_pkey" on "BIL_BillableCharge" billablech1_ (cost=0.00..5.61 rows=1 width=138) (actual time=.. rows= loops=)

  • Index Cond: (billablech1_."ID" = usagexrefn0_."BIL_BillableChargeID")
8. 0.000 0.000 ↓ 0.0
→

Index Scan using "usg_xref_novasummary_billablecharge_BIL_BillableChargeID_index" on usg_xref_novasummary_billablecharge billablech1_1_ (cost=0.00..0.27 rows=1 width=8) (actual time=.. rows= loops=)

  • Index Cond: (billablech1_."ID" = billablech1_1_."BIL_BillableChargeID")