explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ehKQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.960 1.524 ↓ 1.3 108 1

Append (cost=0.00..5.27 rows=85 width=48) (actual time=0.130..1.524 rows=108 loops=1)

2. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on stats_db_group_master_by_1_day (cost=0.00..0.00 rows=1 width=48) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (type = ANY ('{1,2,3,4,5,6,7,8,9,12,15,17,18,19}'::integer[]))
3. 0.557 0.557 ↓ 1.3 108 1

Seq Scan on "stats_db_group_master_by_1_day_2019-03" (cost=0.00..5.27 rows=84 width=48) (actual time=0.113..0.557 rows=108 loops=1)

  • Filter: (type = ANY ('{1,2,3,4,5,6,7,8,9,12,15,17,18,19}'::integer[]))
  • Rows Removed by Filter: 45