explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6YG : 100 of 1000 - unnest 9.6

Settings
# exclusive inclusive rows x rows loops node
1. 0.447 2,885.138 ↑ 1.0 1,000 1

Limit (cost=0.42..14,883.77 rows=1,000 width=8) (actual time=426.098..2,885.138 rows=1,000 loops=1)

2. 27.135 2,884.691 ↑ 100.9 1,000 1

Index Scan Backward using revinfo_ext_2b_pkey on revinfo_ext_2b ri (cost=0.42..1,502,177.07 rows=100,930 width=8) (actual time=426.096..2,884.691 rows=1,000 loops=1)

  • Filter: (SubPlan 1)
  • Rows Removed by Filter: 14964
3.          

SubPlan (forIndex Scan Backward)

4. 410.123 2,857.556 ↓ 0.0 0 15,964

Hash Join (cost=2.25..45.48 rows=9 width=0) (actual time=0.179..0.179 rows=0 loops=15,964)

  • Hash Cond: (vpe.object_uuid = rio.object_uuid)
5. 2,399.541 2,399.541 ↑ 1.1 95 15,891

Seq Scan on virtual_project_entities vpe (cost=0.00..42.76 rows=100 width=16) (actual time=0.079..0.151 rows=95 loops=15,891)

  • Filter: (virtual_project_uuid = '2b332407-c14e-47d0-bbd4-000000000100'::uuid)
  • Rows Removed by Filter: 1603
6. 15.964 47.892 ↑ 100.0 1 15,964

Hash (cost=1.00..1.00 rows=100 width=16) (actual time=0.003..0.003 rows=1 loops=15,964)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 31.928 31.928 ↑ 100.0 1 15,964

Function Scan on unnest rio (cost=0.00..1.00 rows=100 width=16) (actual time=0.002..0.002 rows=1 loops=15,964)