explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5aiY

Settings
# exclusive inclusive rows x rows loops node
1. 0.384 61,755.764 ↑ 1.0 50 1

Limit (cost=0.42..1,362.75 rows=50 width=2,626) (actual time=61,748.097..61,755.764 rows=50 loops=1)

2. 296.130 61,755.380 ↑ 1,805.6 50 1

Nested Loop (cost=0.42..2,459,864.13 rows=90,282 width=2,626) (actual time=61,747.722..61,755.380 rows=50 loops=1)

  • Join Filter: (((i.collection)::text = (c.id)::text) AND ((((i.properties ->> 'eo:cloud_cover'::text))::numeric < '30'::numeric) OR (((c.properties ->> 'eo:cloud_cover'::text))::numeric < '30'::numeric)) AND ((((i.properties ->> 'eo:cloud_cover'::text))::numeric > '25'::numeric) OR (((c.properties ->> 'eo:cloud_cover'::text))::numeric > '25'::numeric)))
  • Rows Removed by Join Filter: 188,172
3. 61,082.706 61,459.250 ↑ 2.1 94,136 1

Index Scan using idx_cloud_cover on items i (cost=0.42..2,212,942.57 rows=199,708 width=1,477) (actual time=1.449..61,459.250 rows=94,136 loops=1)

  • Filter: ((datetime > '2017-04-05 00:00:00'::timestamp without time zone) AND (datetime < '2018-05-02 23:59:00'::timestamp without time zone))
  • Rows Removed by Filter: 422,365
4.          

SubPlan (for Index Scan)

5. 94.136 376.544 ↑ 1.0 1 94,136

Result (cost=0.17..0.19 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=94,136)

6.          

Initplan (for Result)

7. 94.136 188.272 ↑ 1.0 1 94,136

Limit (cost=0.00..0.09 rows=1 width=32) (actual time=0.001..0.002 rows=1 loops=94,136)

8. 94.136 94.136 ↑ 150.0 1 94,136

Seq Scan on apiurls (cost=0.00..13.00 rows=150 width=32) (actual time=0.001..0.001 rows=1 loops=94,136)

9. 94.136 94.136 ↑ 1.0 1 94,136

Limit (cost=0.00..0.08 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=94,136)

10. 0.000 0.000 ↑ 150.0 1 94,136

Seq Scan on apiurls apiurls_1 (cost=0.00..12.25 rows=150 width=32) (actual time=0.000..0.000 rows=1 loops=94,136)

11. 0.000 0.000 ↑ 1.0 2 94,136

Materialize (cost=0.00..1.03 rows=2 width=1,127) (actual time=0.000..0.000 rows=2 loops=94,136)

12. 0.457 0.457 ↑ 1.0 2 1

Seq Scan on collections c (cost=0.00..1.02 rows=2 width=1,127) (actual time=0.455..0.457 rows=2 loops=1)