explain.depesz.com

PostgreSQL's explain analyze made readable

Result: K33K

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.062 ↓ 0.0 0 1

Nested Loop (cost=9.95..12.50 rows=1 width=166) (actual time=0.062..0.062 rows=0 loops=1)

2. 0.000 0.060 ↓ 0.0 0 1

Nested Loop (cost=9.81..11.75 rows=1 width=123) (actual time=0.060..0.060 rows=0 loops=1)

3. 0.033 0.060 ↓ 0.0 0 1

Hash Join (cost=9.67..11.00 rows=1 width=115) (actual time=0.060..0.060 rows=0 loops=1)

  • Hash Cond: (sc.status_cd = fu.status_cd)
4. 0.008 0.008 ↑ 23.0 1 1

Seq Scan on status_code_def sc (cost=0.00..1.23 rows=23 width=20) (actual time=0.008..0.008 rows=1 loops=1)

5. 0.001 0.019 ↓ 0.0 0 1

Hash (cost=9.66..9.66 rows=1 width=99) (actual time=0.019..0.019 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
6. 0.001 0.018 ↓ 0.0 0 1

Nested Loop (cost=0.15..9.66 rows=1 width=99) (actual time=0.018..0.018 rows=0 loops=1)

  • Join Filter: (fu.srce_sys_file_mapping_id = sf.srce_sys_file_mapping_id)
7. 0.017 0.017 ↓ 0.0 0 1

Index Scan using file_upload_pkey on file_upload fu (cost=0.15..8.17 rows=1 width=91) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (file_upload_id = 359)
8. 0.000 0.000 ↓ 0.0 0

Seq Scan on srce_sys_file_format sf (cost=0.00..1.22 rows=22 width=10) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Index Scan using srce_sys_pkey on srce_sys s (cost=0.14..0.70 rows=1 width=12) (never executed)

  • Index Cond: (srce_sys_key = sf.srce_sys_key)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using file_upload_format_pkey on file_upload_format ff (cost=0.14..0.70 rows=1 width=47) (never executed)

  • Index Cond: (file_upload_format_id = sf.file_upload_format_id)