explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r47C : A

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 37.800 ↓ 0.0 0 1

Append (cost=0.00..4,768.87 rows=2 width=4) (actual time=37.800..37.800 rows=0 loops=1)

2. 26.504 26.504 ↓ 0.0 0 1

Seq Scan on "management_performancestatistics_2020-03-16_2020-03-23" (cost=0.00..3,366.26 rows=1 width=4) (actual time=26.504..26.504 rows=0 loops=1)

  • Filter: (id = 13000)
  • Rows Removed by Filter: 118440
3. 11.292 11.292 ↓ 0.0 0 1

Seq Scan on "management_performancestatistics_2020-03-23_2020-03-30" (cost=0.00..1,402.60 rows=1 width=4) (actual time=11.292..11.292 rows=0 loops=1)

  • Filter: (id = 13000)
  • Rows Removed by Filter: 50200
Planning time : 0.485 ms
Execution time : 37.932 ms