explain.depesz.com

PostgreSQL's explain analyze made readable

Result: asmR

Settings
# exclusive inclusive rows x rows loops node
1. 0.060 46,829.232 ↑ 1.0 300 1

Limit (cost=1.61..630.68 rows=300 width=203) (actual time=77.186..46,829.232 rows=300 loops=1)

2. 0.330 46,829.172 ↑ 4,069.8 300 1

Nested Loop Left Join (cost=1.61..2,560,228.61 rows=1,220,946 width=203) (actual time=77.186..46,829.172 rows=300 loops=1)

3. 0.580 46,828.242 ↑ 4,069.8 300 1

Nested Loop Left Join (cost=1.46..2,361,926.11 rows=1,220,946 width=195) (actual time=77.175..46,828.242 rows=300 loops=1)

  • Filter: (("TagHeader".rowid IS NULL) OR "TagHeader".active)
4. 0.125 46,827.662 ↑ 5,805.7 300 1

Merge Append (cost=1.04..1,551,202.89 rows=1,741,720 width=159) (actual time=77.161..46,827.662 rows=300 loops=1)

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

Index Scan Backward using "LogEvent_1_time_idx" on "LogEvent_1" (cost=0.29..8,426.90 rows=359 width=179) (actual time=70.829..70.829 rows=0 loops=1)

  • Index Cond: ("time" >= '1561939200000'::bigint)
  • Filter: (("tagHeader" = ANY ('{83290,1507,149028,334785,115878,214452,165380,230801,269224,285588,198210,247286,132650,285582,165491,285570,50436,50557,1475,181832,1472,334637,83128,165475,230909,198059,383830,230899,66903,132624,269193,149107,1331,165456,99466,269189,214404,181681,66747,394452,165454,149094,198025,165445,1304,367427,181659,50499,83082,132713,83080,301864,99572,83081,50500,132716,247086,99560,367294,165291,50365,269277,198129,132699,149063,148923,115908,34114,230709,181754,148913,66701,230690,181757,165258,181731,334663,33965,17734,394246,1372,33959,165375,181720,165363,334514,269094,50308,230656,181718,269086,197937,334510,214301,285567,247141,33931}'::bigint[])) OR ("tagHeader" IS NULL))
  • Rows Removed by Filter: 46222
6. 195.634 195.634 ↑ 20.9 69 1

Index Scan Backward using "LogEvent_2_time_idx" on "LogEvent_2" (cost=0.29..8,273.69 rows=1,443 width=177) (actual time=0.108..195.634 rows=69 loops=1)

  • Index Cond: ("time" >= '1561939200000'::bigint)
  • Filter: (("tagHeader" = ANY ('{83290,1507,149028,334785,115878,214452,165380,230801,269224,285588,198210,247286,132650,285582,165491,285570,50436,50557,1475,181832,1472,334637,83128,165475,230909,198059,383830,230899,66903,132624,269193,149107,1331,165456,99466,269189,214404,181681,66747,394452,165454,149094,198025,165445,1304,367427,181659,50499,83082,132713,83080,301864,99572,83081,50500,132716,247086,99560,367294,165291,50365,269277,198129,132699,149063,148923,115908,34114,230709,181754,148913,66701,230690,181757,165258,181731,334663,33965,17734,394246,1372,33959,165375,181720,165363,334514,269094,50308,230656,181718,269086,197937,334510,214301,285567,247141,33931}'::bigint[])) OR ("tagHeader" IS NULL))
  • Rows Removed by Filter: 17972
7. 46,561.074 46,561.074 ↑ 7,499.6 232 1

Index Scan Backward using "LogEvent_3_time_idx" on "LogEvent_3" (cost=0.44..1,511,990.88 rows=1,739,918 width=159) (actual time=6.214..46,561.074 rows=232 loops=1)

  • Index Cond: ("time" >= '1561939200000'::bigint)
  • Filter: (("tagHeader" = ANY ('{83290,1507,149028,334785,115878,214452,165380,230801,269224,285588,198210,247286,132650,285582,165491,285570,50436,50557,1475,181832,1472,334637,83128,165475,230909,198059,383830,230899,66903,132624,269193,149107,1331,165456,99466,269189,214404,181681,66747,394452,165454,149094,198025,165445,1304,367427,181659,50499,83082,132713,83080,301864,99572,83081,50500,132716,247086,99560,367294,165291,50365,269277,198129,132699,149063,148923,115908,34114,230709,181754,148913,66701,230690,181757,165258,181731,334663,33965,17734,394246,1372,33959,165375,181720,165363,334514,269094,50308,230656,181718,269086,197937,334510,214301,285567,247141,33931}'::bigint[])) OR ("tagHeader" IS NULL))
  • Rows Removed by Filter: 9290615
8. 0.000 0.000 ↓ 0.0 0 300

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

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

Index Scan using "LogEventClass_pkey" on "LogEventClass" (cost=0.14..0.16 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=300)

  • Index Cond: ("LogEvent_1"."eventClass" = rowid)
Planning time : 168.453 ms
Execution time : 46,829.366 ms