explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CvGR

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

Update on "epg_series_api" (cost=288,523.60..315,534.92 rows=2,222 width=779) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=288,523.60..315,534.92 rows=2,222 width=779) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Subquery Scan on s (cost=288,523.31..313,170.32 rows=2,222 width=104) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=288,523.31..313,148.10 rows=2,222 width=40) (actual rows= loops=)

  • Group Key: "sub"."series_id
5. 0.000 0.000 ↓ 0.0

Subquery Scan on sub (cost=288,523.31..313,079.40 rows=2,339 width=175) (actual rows= loops=)

  • Filter: ("sub"."image_rank" = 1)
6. 0.000 0.000 ↓ 0.0

WindowAgg (cost=288,523.31..307,232.71 rows=467,735 width=227) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Sort (cost=288,523.31..289,692.65 rows=467,735 width=219) (actual rows= loops=)

  • Sort Key: "pi"."series_id", "pi"."image_type_id", ("round"((("if"."file_width")::numeric / ("if"."file_height")::numeric), 2)), (("if"."file_width" * "if"."file_height")) DESC, "if"."image_id
8. 0.000 0.000 ↓ 0.0

Hash Join (cost=186,998.42..216,153.59 rows=467,735 width=219) (actual rows= loops=)

  • Hash Cond: ("pi"."image_type_id" = "it"."image_type_id")
9. 0.000 0.000 ↓ 0.0

Hash Join (cost=186,955.12..203,832.24 rows=467,735 width=168) (actual rows= loops=)

  • Hash Cond: ("pi"."image_id" = "if"."image_id")
10. 0.000 0.000 ↓ 0.0

Seq Scan on "rovi_programimages" "pi" (cost=0.00..15,423.72 rows=553,672 width=24) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=182,892.99..182,892.99 rows=324,971 width=152) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Index Scan using "rovi_imagefiles_image_id_file_format_id_idx" on "rovi_imagefiles" "if" (cost=0.43..182,892.99 rows=324,971 width=152) (actual rows= loops=)

  • Index Cond: ("file_format_id" = 0)
  • Filter: (("file_type")::"text" = ANY ('{jpg,jpeg,png}'::"text"[]))
13. 0.000 0.000 ↓ 0.0

Hash (cost=24.80..24.80 rows=1,480 width=23) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on "rovi_image_types" "it" (cost=0.00..24.80 rows=1,480 width=23) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Index Scan using "ix_epg_series_api_series_id" on "epg_series_api" (cost=0.29..1.05 rows=1 width=683) (actual rows= loops=)

  • Index Cond: ("series_id" = "s"."series_id")