explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ApIr

Settings
# exclusive inclusive rows x rows loops node
1. 0.026 3,667.649 ↑ 1.0 300 1

Limit (cost=1.16..12.27 rows=300 width=203) (actual time=0.261..3,667.649 rows=300 loops=1)

2. 48.547 3,667.623 ↑ 175,375.5 300 1

Nested Loop Left Join (cost=1.16..1,947,766.13 rows=52,612,660 width=203) (actual time=0.259..3,667.623 rows=300 loops=1)

  • Filter: (("LogEvent_1"."tagHeader" IS NULL) OR (th.tagheaderid IS NOT NULL))
  • Rows Removed by Filter: 982982
3. 197.902 2,635.794 ↓ 1.0 983,282 1

Nested Loop (cost=0.87..212,448.93 rows=980,360 width=203) (actual time=0.130..2,635.794 rows=983,282 loops=1)

4. 60.551 1,454.610 ↓ 1.0 983,282 1

Merge Append (cost=0.73..53,219.76 rows=980,360 width=133) (actual time=0.112..1,454.610 rows=983,282 loops=1)

  • Sort Key: "LogEvent_1"."time" DESC
5. 0.013 0.013 ↓ 0.0 0 1

Index Scan Backward using "LogEvent_1_time_idx" on "LogEvent_1" (cost=0.14..2.16 rows=1 width=191) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (("time" >= '1567503455000'::bigint) AND ("time" < '1567598000000'::bigint))
  • Filter: (upper(description) !~~ '%GOOSE%'::text)
6. 0.586 0.586 ↓ 1.0 178 1

Index Scan Backward using "LogEvent_2_time_idx" on "LogEvent_2" (cost=0.14..11.92 rows=177 width=193) (actual time=0.070..0.586 rows=178 loops=1)

  • Index Cond: (("time" >= '1567503455000'::bigint) AND ("time" < '1567598000000'::bigint))
  • Filter: (upper(description) !~~ '%GOOSE%'::text)
7. 1,393.460 1,393.460 ↓ 1.0 983,105 1

Index Scan Backward using "LogEvent_3_time_idx" on "LogEvent_3" (cost=0.42..40,534.68 rows=980,182 width=133) (actual time=0.026..1,393.460 rows=983,105 loops=1)

  • Index Cond: (("time" >= '1567503455000'::bigint) AND ("time" < '1567598000000'::bigint))
  • Filter: (upper(description) !~~ '%GOOSE%'::text)
8. 983.282 983.282 ↑ 1.0 1 983,282

Index Scan using "LogEventClass_pkey" on "LogEventClass" (cost=0.14..0.16 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=983,282)

  • Index Cond: (rowid = "LogEvent_1"."eventClass")
9. 983.282 983.282 ↓ 0.0 0 983,282

Index Only Scan using temp_tagheaderind on temp_tagheader th (cost=0.29..1.23 rows=54 width=8) (actual time=0.001..0.001 rows=0 loops=983,282)

  • Index Cond: (tagheaderid = "LogEvent_1"."tagHeader")
  • Heap Fetches: 236
Planning time : 7.032 ms