explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ry6w

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 12,739.718 ↑ 1.0 50 1

Limit (cost=392,913.35..393,039.35 rows=50 width=2,655) (actual time=12,739.116..12,739.718 rows=50 loops=1)

2. 1.394 12,739.711 ↑ 14,669.5 50 1

Result (cost=392,913.35..2,241,267.83 rows=733,474 width=2,655) (actual time=12,739.115..12,739.711 rows=50 loops=1)

3. 719.337 12,738.317 ↑ 14,669.5 50 1

Sort (cost=392,913.35..394,747.03 rows=733,474 width=2,623) (actual time=12,738.311..12,738.317 rows=50 loops=1)

  • Sort Key: ((i.properties -> 'eo:cloud_cover'::text))
  • Sort Method: top-N heapsort Memory: 394kB
4. 559.100 12,018.980 ↓ 1.0 734,457 1

Hash Join (cost=1.04..368,547.87 rows=733,474 width=2,623) (actual time=0.513..12,018.980 rows=734,457 loops=1)

  • Hash Cond: ((i.collection)::text = (c.id)::text)
5. 8,522.044 11,459.872 ↓ 1.0 734,457 1

Seq Scan on items i (cost=0.00..360,707.82 rows=733,474 width=1,478) (actual time=0.497..11,459.872 rows=734,457 loops=1)

  • Filter: (datetime < '2019-05-02 23:59:00'::timestamp without time zone)
  • Rows Removed by Filter: 313,617
6.          

SubPlan (for Seq Scan)

7. 1,468.914 2,937.828 ↑ 1.0 1 734,457

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

8.          

Initplan (for Result)

9. 0.000 734.457 ↑ 1.0 1 734,457

Limit (cost=0.00..0.09 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=734,457)

10. 734.457 734.457 ↑ 150.0 1 734,457

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

11. 734.457 734.457 ↑ 1.0 1 734,457

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

12. 0.000 0.000 ↑ 150.0 1 734,457

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

13. 0.005 0.008 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=1,127) (actual time=0.008..0.008 rows=2 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
14. 0.003 0.003 ↑ 1.0 2 1

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