explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AtAt

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 106,288.430 ↓ 0.0 0 1

Limit (cost=1.61..992.99 rows=300 width=203) (actual time=106,288.430..106,288.430 rows=0 loops=1)

2. 0.000 106,288.429 ↓ 0.0 0 1

Nested Loop (cost=1.61..10,912,317.85 rows=3,302,170 width=203) (actual time=106,288.429..106,288.429 rows=0 loops=1)

3. 61,302.101 106,288.429 ↓ 0.0 0 1

Nested Loop (cost=1.46..10,375,996.73 rows=3,302,170 width=195) (actual time=106,288.429..106,288.429 rows=0 loops=1)

  • Join Filter: (((("TagHeader".rowid IS NULL) AND ("LogEvent_1"."tagHeader" IS NULL)) OR "TagHeader".active) AND ("TagHeader".rowid = "LogEvent_1"."tagHeader"))
  • Rows Removed by Join Filter: 631162090
4. 1,049.985 25,565.956 ↑ 1.0 9,710,186 1

Merge Append (cost=1.04..468,817.67 rows=9,712,688 width=159) (actual time=18.468..25,565.956 rows=9,710,186 loops=1)

  • Sort Key: "LogEvent_1".rowid DESC
5. 150.359 150.359 ↑ 1.0 46,222 1

Index Scan Backward using "LogEvent_1_pkey" on "LogEvent_1" (cost=0.29..2,806.71 rows=46,222 width=179) (actual time=3.140..150.359 rows=46,222 loops=1)

  • Filter: ("time" >= '1561939200000'::bigint)
6. 120.741 120.741 ↑ 1.0 49,780 1

Index Scan Backward using "LogEvent_2_pkey" on "LogEvent_2" (cost=0.29..2,234.42 rows=49,780 width=177) (actual time=7.293..120.741 rows=49,780 loops=1)

  • Filter: ("time" >= '1561939200000'::bigint)
7. 24,244.871 24,244.871 ↑ 1.0 9,614,184 1

Index Scan Backward using "LogEvent_3_pkey" on "LogEvent_3" (cost=0.44..338,241.84 rows=9,616,686 width=159) (actual time=8.024..24,244.871 rows=9,614,184 loops=1)

  • Filter: ("time" >= '1561939200000'::bigint)
8. 18,941.600 19,420.372 ↑ 1.0 65 9,710,186

Materialize (cost=0.42..237.48 rows=68 width=13) (actual time=0.000..0.002 rows=65 loops=9,710,186)

9. 0.399 478.772 ↑ 1.0 65 1

Nested Loop (cost=0.42..237.14 rows=68 width=13) (actual time=10.619..478.772 rows=65 loops=1)

10. 0.357 0.357 ↑ 1.0 97 1

Values Scan on "*VALUES*" (cost=0.00..1.21 rows=97 width=4) (actual time=0.003..0.357 rows=97 loops=1)

11. 478.016 478.016 ↑ 1.0 1 97

Index Scan using "TagHeader_pkey" on "TagHeader" (cost=0.42..2.43 rows=1 width=9) (actual time=4.928..4.928 rows=1 loops=97)

  • Index Cond: (rowid = "*VALUES*".column1)
  • Filter: ((rowid IS NULL) OR active)
  • Rows Removed by Filter: 0
12. 0.000 0.000 ↓ 0.0 0

Index Scan using "LogEventClass_pkey" on "LogEventClass" (cost=0.14..0.16 rows=1 width=16) (never executed)

  • Index Cond: (rowid = "LogEvent_1"."eventClass")
Planning time : 22.097 ms