explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7PcN : psql_11_CalculateUsageChargeBilling_with_MAT_VIEW

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 0.393 ↓ 25.0 25 1

Subquery Scan on sq (cost=15.93..15.97 rows=1 width=384) (actual time=0.248..0.393 rows=25 loops=1)

  • Filter: (sq.row_number = 1)
2. 0.170 0.379 ↓ 25.0 25 1

WindowAgg (cost=15.93..15.95 rows=1 width=348) (actual time=0.245..0.379 rows=25 loops=1)

3. 0.070 0.209 ↓ 25.0 25 1

Sort (cost=15.93..15.93 rows=1 width=348) (actual time=0.205..0.209 rows=25 loops=1)

  • Sort Key: "URT"."UsageRateTypeId", "UR"."EffectiveEpoch" DESC
  • Sort Method: quicksort Memory: 30kB
4. 0.056 0.139 ↓ 25.0 25 1

Hash Join (cost=13.39..15.92 rows=1 width=348) (actual time=0.101..0.139 rows=25 loops=1)

  • Hash Cond: ("UR"."UsageRateTypeId" = "URT"."UsageRateTypeId")
5. 0.029 0.029 ↑ 1.0 38 1

Seq Scan on "UsageRate" "UR" (cost=0.00..2.38 rows=38 width=89) (actual time=0.016..0.029 rows=38 loops=1)

  • Filter: (("InactiveEpoch" IS NULL) AND ("DeletedEpoch" IS NULL))
6. 0.023 0.054 ↓ 25.0 25 1

Hash (cost=13.38..13.38 rows=1 width=263) (actual time=0.054..0.054 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
7. 0.031 0.031 ↓ 25.0 25 1

Seq Scan on "UsageRateReadTypes11" "URT" (cost=0.00..13.38 rows=1 width=263) (actual time=0.010..0.031 rows=25 loops=1)

  • Filter: (("InactiveEpoch" IS NULL) AND ("UtilityId" = 1))
  • Rows Removed by Filter: 18
Planning time : 0.412 ms
Execution time : 0.543 ms