explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pNqN

Settings
# exclusive inclusive rows x rows loops node
1. 0.027 287.899 ↑ 1.0 300 1

Limit (cost=1.30..48,773.22 rows=300 width=203) (actual time=0.337..287.899 rows=300 loops=1)

2. 187.961 287.872 ↑ 2,784.5 300 1

Nested Loop Left Join (cost=1.30..135,804,614.54 rows=835,345 width=203) (actual time=0.336..287.872 rows=300 loops=1)

  • Join Filter: ("TagHeader".rowid = "*VALUES*".column1)
  • Rows Removed by Join Filter: 3236080
3. 0.182 5.711 ↑ 2,784.5 300 1

Nested Loop (cost=1.30..641,455.01 rows=835,345 width=211) (actual time=0.211..5.711 rows=300 loops=1)

4. 0.170 5.229 ↑ 2,784.5 300 1

Nested Loop Left Join (cost=1.15..505,779.04 rows=835,345 width=203) (actual time=0.194..5.229 rows=300 loops=1)

  • Filter: ((("TagHeader".rowid IS NULL) AND ("LogEvent_1"."tagHeader" IS NULL)) OR "TagHeader".active)
5. 0.036 1.159 ↑ 3,265.2 300 1

Merge Append (cost=0.73..53,175.61 rows=979,570 width=133) (actual time=0.141..1.159 rows=300 loops=1)

  • Sort Key: "LogEvent_1"."time" DESC
6. 0.008 0.008 ↓ 0.0 0 1

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

  • Index Cond: (("time" >= '1567503455000'::bigint) AND ("time" < '1567598000000'::bigint))
  • Filter: (upper(description) !~~ '%GOOSE%'::text)
7. 0.185 0.185 ↑ 9.9 18 1

Index Scan Backward using "LogEvent_2_time_idx" on "LogEvent_2" (cost=0.14..11.43 rows=178 width=194) (actual time=0.100..0.185 rows=18 loops=1)

  • Index Cond: (("time" >= '1567503455000'::bigint) AND ("time" < '1567598000000'::bigint))
  • Filter: (upper(description) !~~ '%GOOSE%'::text)
8. 0.930 0.930 ↑ 3,460.7 283 1

Index Scan Backward using "LogEvent_3_time_idx" on "LogEvent_3" (cost=0.42..40,501.24 rows=979,391 width=133) (actual time=0.032..0.930 rows=283 loops=1)

  • Index Cond: (("time" >= '1567503455000'::bigint) AND ("time" < '1567598000000'::bigint))
  • Filter: (upper(description) !~~ '%GOOSE%'::text)
9. 3.900 3.900 ↑ 1.0 1 300

Index Scan using "TagHeader_pkey" on "TagHeader" (cost=0.42..0.45 rows=1 width=9) (actual time=0.013..0.013 rows=1 loops=300)

  • Index Cond: ("LogEvent_1"."tagHeader" = rowid)
10. 0.300 0.300 ↑ 1.0 1 300

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=300)

  • Index Cond: (rowid = "LogEvent_1"."eventClass")
11. 92.319 94.200 ↑ 1.0 10,787 300

Materialize (cost=0.00..188.77 rows=10,787 width=4) (actual time=0.000..0.314 rows=10,787 loops=300)

12. 1.881 1.881 ↑ 1.0 10,787 1

Values Scan on "*VALUES*" (cost=0.00..134.84 rows=10,787 width=4) (actual time=0.001..1.881 rows=10,787 loops=1)

Planning time : 9.991 ms