explain.depesz.com

PostgreSQL's explain analyze made readable

Result: epcF

Settings
# exclusive inclusive rows x rows loops node
1. 0.341 56,667.006 ↑ 1.0 50 1

Limit (cost=0.42..1,616.42 rows=50 width=2,656) (actual time=56,660.996..56,667.006 rows=50 loops=1)

2. 304.076 56,666.665 ↑ 1,752.4 50 1

Nested Loop (cost=0.42..2,831,802.73 rows=87,618 width=2,656) (actual time=56,660.666..56,666.665 rows=50 loops=1)

  • Join Filter: (((i.collection)::text = (c.id)::text) AND ((((i.properties -> 'eo:cloud_cover'::text))::numeric < '95'::numeric) OR (((c.properties -> 'eo:cloud_cover'::text))::numeric < '95'::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: 188172
3. 55,986.045 56,362.589 ↑ 2.2 94,136 1

Index Scan using idx_cloud_cover on items i (cost=0.42..2,594,716.63 rows=205,313 width=1,479) (actual time=0.028..56,362.589 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: 422365
4.          

SubPlan (for Index Scan)

5. 94.136 376.544 ↑ 1.0 1 94,136

Result (cost=2.04..2.05 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..1.02 rows=1 width=32) (actual time=0.001..0.002 rows=1 loops=94,136)

8. 94.136 94.136 ↑ 1.0 1 94,136

Seq Scan on apiurls (cost=0.00..1.02 rows=1 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..1.01 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=94,136)

10. 0.000 0.000 ↑ 1.0 1 94,136

Seq Scan on apiurls apiurls_1 (cost=0.00..1.01 rows=1 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.004 0.004 ↑ 1.0 2 1

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