explain.depesz.com

PostgreSQL's explain analyze made readable

Result: caln

Settings
# exclusive inclusive rows x rows loops node
1. 1,068.887 2,223.914 ↑ 1.0 1 1

Aggregate (cost=9,872.31..9,872.31 rows=1 width=32) (actual time=2,223.899..2,223.914 rows=1 loops=1)

2.          

Initplan (forAggregate)

3. 36.714 90.510 ↑ 1.0 1 1

Aggregate (cost=3,327.15..3,327.16 rows=1 width=8) (actual time=90.495..90.510 rows=1 loops=1)

4. 53.796 53.796 ↑ 9.6 4,539 1

Seq Scan on activity_metadata activity_metadata_1 (cost=0.00..3,217.98 rows=43,666 width=0) (actual time=0.025..53.796 rows=4,539 loops=1)

  • Filter: (array_length(child_ids, 1) > 0)
  • Rows Removed by Filter: 126460
5. 5.538 27.081 ↑ 1.0 1 1

Aggregate (cost=3,327.15..3,327.16 rows=1 width=8) (actual time=27.066..27.081 rows=1 loops=1)

6. 21.543 21.543 ↑ 66.0 662 1

Seq Scan on activity_metadata activity_metadata_2 (cost=0.00..3,217.98 rows=43,666 width=0) (actual time=0.046..21.543 rows=662 loops=1)

  • Filter: (array_length(dimension_ids, 1) > 0)
  • Rows Removed by Filter: 130337
7. 1,037.436 1,037.436 ↑ 1.0 130,999 1

Seq Scan on activity_metadata (cost=0.00..2,562.99 rows=130,999 width=8) (actual time=0.017..1,037.436 rows=130,999 loops=1)

Planning time : 0.110 ms