explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S3PT

Settings
# exclusive inclusive rows x rows loops node
1. 0.046 0.830 ↓ 0.0 0 1

Hash Right Join (cost=24.57..27.87 rows=20 width=4,585) (actual time=0.830..0.830 rows=0 loops=1)

  • Hash Cond: (criteriaan2_.analysis_uid = dbanalysis1_.uid)
2. 0.000 0.000 ↓ 0.0 0

Seq Scan on criterion_analysis criteriaan2_ (cost=0.00..2.80 rows=80 width=81) (never executed)

3. 0.001 0.784 ↓ 0.0 0 1

Hash (cost=24.56..24.56 rows=1 width=4,488) (actual time=0.784..0.784 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
4. 0.000 0.783 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.29..24.56 rows=1 width=4,488) (actual time=0.783..0.783 rows=0 loops=1)

  • Join Filter: (dbscanpack5_.analysis_uid = dbanalysis6_.uid)
5. 0.000 0.783 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.29..23.47 rows=1 width=2,813) (actual time=0.783..0.783 rows=0 loops=1)

  • Join Filter: (dbphoto0_.scan_package_uid = dbscanpack5_.uid)
6. 0.000 0.783 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.29..22.20 rows=1 width=2,233) (actual time=0.783..0.783 rows=0 loops=1)

7. 0.001 0.783 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.14..14.03 rows=1 width=2,022) (actual time=0.783..0.783 rows=0 loops=1)

8. 0.001 0.782 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..5.85 rows=1 width=1,811) (actual time=0.782..0.782 rows=0 loops=1)

  • Join Filter: (dbphoto0_.analysis_uid = dbanalysis1_.uid)
9. 0.781 0.781 ↓ 0.0 0 1

Seq Scan on photo dbphoto0_ (cost=0.00..4.76 rows=1 width=136) (actual time=0.781..0.781 rows=0 loops=1)

  • Filter: (uid = '3c16d5d6-7ca4-4874-9fe9-5dcdd671678b'::uuid)
  • Rows Removed by Filter: 141
10. 0.000 0.000 ↓ 0.0 0

Seq Scan on analysis dbanalysis1_ (cost=0.00..1.04 rows=4 width=1,675) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Index Scan using photo_file_pkey on photo_file photofile3_ (cost=0.14..8.16 rows=1 width=211) (never executed)

  • Index Cond: (dbphoto0_.cropped_photo_uid = uid)
12. 0.000 0.000 ↓ 0.0 0

Index Scan using photo_file_pkey on photo_file photofile4_ (cost=0.14..8.16 rows=1 width=211) (never executed)

  • Index Cond: (dbphoto0_.received_photo_uid = uid)
13. 0.000 0.000 ↓ 0.0 0

Seq Scan on scan_package dbscanpack5_ (cost=0.00..1.12 rows=12 width=580) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Seq Scan on analysis dbanalysis6_ (cost=0.00..1.04 rows=4 width=1,675) (never executed)

Planning time : 22.421 ms
Execution time : 1.132 ms