explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9uzE : Optimization for: Test; plan #XPFH

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.006 0.024 ↑ 1.0 10 1

Limit (cost=0..0.71 rows=10 width=211) (actual time=0.016..0.024 rows=10 loops=1)

  • Buffers: shared hit=1
2. 0.004 0.018 ↑ 6,979.5 10 1

Append (cost=0..4,934.93 rows=69,795 width=211) (actual time=0.014..0.018 rows=10 loops=1)

  • Buffers: shared hit=1
3. 0.014 0.014 ↑ 2.7 10 1

Seq Scan on t_e20so1_document_datastore_1 t_e20so1_document_datastore_1 (cost=0..1.27 rows=27 width=696) (actual time=0.012..0.014 rows=10 loops=1)

  • Buffers: shared hit=1
4. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on t_e20so1_document_datastore_11 t_e20so1_document_datastore_11 (cost=0..587.41 rows=14,041 width=237) (never executed)

5. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on t_e20so1_document_datastore_12 t_e20so1_document_datastore_12 (cost=0..1.26 rows=26 width=193) (never executed)

6. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on t_e20so1_document_datastore_13 t_e20so1_document_datastore_13 (cost=0..2.43 rows=43 width=205) (never executed)

7. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on t_e20so1_document_datastore_14 t_e20so1_document_datastore_14 (cost=0..22.58 rows=658 width=209) (never executed)

8. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on t_e20so1_document_datastore_15 t_e20so1_document_datastore_15 (cost=0..3,946.6 rows=54,660 width=203) (never executed)

9. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on t_e20so1_document_datastore_16 t_e20so1_document_datastore_16 (cost=0..12.94 rows=294 width=235) (never executed)

10. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on t_e20so1_document_datastore_17 t_e20so1_document_datastore_17 (cost=0..1.16 rows=16 width=682) (never executed)

11. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on t_e20so1_document_datastore_default t_e20so1_document_datastore_default (cost=0..10.3 rows=30 width=2,222) (never executed)

Planning time : 9.18 ms
Execution time : 0.228 ms