explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CMMg : EXPLAIN ANALYZE SELECT * FROM products WHERE tags @> ARRAY['1111'] LIMIT 10;

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 481.530 ↑ 10.0 1 1

Limit (cost=0.00..64.24 rows=10 width=170) (actual time=481.522..481.530 rows=1 loops=1)

  • Execution Time: 481.585 ms(6 строк)
2. 481.522 481.522 ↑ 5,000.0 1 1

Seq Scan on products (cost=0.00..32,121.18 rows=5,000 width=170) (actual time=481.516..481.522 rows=1 loops=1)

  • Filter: (tags @> '{1111}'::text[])
  • Rows Removed by Filter: 1000013
Planning time : 1.511 ms